Thursday, January 3, 2013

Single Insert Script for HRMS Competence Element for JOBS/Positions

 Single Insert Script for HRMS Competence Element for JOBS/Positions
DECLARE
  L_BUSINESS_GROUP_ID            NUMBER :=81 ;
  l_competence_id                NUMBER :=5001;
  l_assessment_type_id           NUMBER;
  L_COMPETENCE_TYPE_CODE         VARCHAR2(30);
  l_validate                     BOOLEAN :=FALSE;
  L_PARENT_COMPETENCE_ELEMENT_ID NUMBER;
  L_COMPETENCE_ELEMENT_ID        NUMBER;
  l_object_version_number        NUMBER;
  l_status                       VARCHAR2(5) := 'True';
  error_msg                      VARCHAR2(1000);
  l_validate_count               NUMBER;
  l_group_count                  NUMBER;
  l_competence_count             NUMBER;
  l_assess_count                 NUMBER;
  l_group_exists                 VARCHAR2(5);
  l_competence_exists            VARCHAR2(5);
  l_total_records                NUMBER := 0;
  l_success_records              NUMBER := 0;
  L_FAILURE_RECORDS              number := 0;
  l_position_id                  NUMBER:=202201;
  L_DATE_EFFECTIVE DATE;
--  l_job_id NUMBER:=460;
BEGIN
  FND_GLOBAL.APPS_INITIALIZE(USER_ID=>15062, RESP_ID=>50939, RESP_APPL_ID=>800);
  BEGIN
    HR_COMPETENCE_ELEMENT_API.CREATE_COMPETENCE_ELEMENT (P_VALIDATE => L_VALIDATE ,
                                                         P_EFFECTIVE_DATE => '01-JAN-2012' ,
                                                         P_BUSINESS_GROUP_ID =>L_BUSINESS_GROUP_ID ,
                                                         P_TYPE => 'REQUIREMENT' ,
                                                         P_COMPETENCE_ID=>L_COMPETENCE_ID ,
                                                         P_POSITION_ID =>L_POSITION_ID ,
                                                         P_EFFECTIVE_DATE_FROM=>'01-JAN-2012' ,
                                                         P_COMPETENCE_ELEMENT_ID => L_COMPETENCE_ELEMENT_ID ,
                                                         P_OBJECT_VERSION_NUMBER => L_OBJECT_VERSION_NUMBER );
  EXCEPTION
  WHEN OTHERS THEN
    DBMS_OUTPUT.PUT_LINE('err:'||SQLERRM);
  END;
  dbms_output.put_line('Comp:'||l_competence_element_id||l_object_version_number);
END; 
   
                   

3 comments:

Prologic Corporation said...

This is a good article & good site.Thank you for sharing this article. It is help us following categorize:
healthcare, e commerce, programming, multi platform,inventory management, cloud-based solutions, it consulting, retail, manufacturing, CRM, technology means, digital supply chain management, Delivering high-quality service for your business applications,
Solutions for all Industries,
Getting your applications talking is the key to better business processes,
Rapid web services solutions for real business problems,
Web-based Corporate Document Management System,
Outsourcing Solution,
Financial and Operations Business Intelligence Solution,

Our address:
2002 Timberloch Place, Suite 200
The Woodlands, TX 77380
281-364-1799

prologic-corp

Cindy Dy said...

I am happy to find your distinguished way of writing the post. Now you make it easy for me to understand and implement the concept. Thank you for the post.

Bry
www.gofastek.com

Leslie Lim said...

First time I commented in a blog! I really enjoy it. You have an awesome post. Please do more articles like this. I'm gonna come back surely. God bless.

Rica
www.imarksweb.org