APPS.HRDPP_CREATE_COMPETENCE_ELEMEN dependencies on PER_COMPETENCE_DATA_PUMP

Line 503: PER_COMPETENCE_DATA_PUMP.get_enterprise_id;

499: hr_utility.raise_error;
500: end if;
501: --
502: L_ENTERPRISE_ID :=
503: PER_COMPETENCE_DATA_PUMP.get_enterprise_id;
504: --
505: L_COMPETENCE_ID :=
506: PER_COMPETENCE_DATA_PUMP.get_competence_id
507: (P_DATA_PUMP_ALWAYS_CALL => null

Line 506: PER_COMPETENCE_DATA_PUMP.get_competence_id

502: L_ENTERPRISE_ID :=
503: PER_COMPETENCE_DATA_PUMP.get_enterprise_id;
504: --
505: L_COMPETENCE_ID :=
506: PER_COMPETENCE_DATA_PUMP.get_competence_id
507: (P_DATA_PUMP_ALWAYS_CALL => null
508: ,P_COMPETENCE_NAME => c.p67
509: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID);
510: --

Line 512: PER_COMPETENCE_DATA_PUMP.get_proficiency_level_id;

508: ,P_COMPETENCE_NAME => c.p67
509: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID);
510: --
511: L_PROFICIENCY_LEVEL_ID :=
512: PER_COMPETENCE_DATA_PUMP.get_proficiency_level_id;
513: --
514: L_HIGH_PROFICIENCY_LEVEL_ID :=
515: PER_COMPETENCE_DATA_PUMP.get_high_proficiency_level_id;
516: --

Line 515: PER_COMPETENCE_DATA_PUMP.get_high_proficiency_level_id;

511: L_PROFICIENCY_LEVEL_ID :=
512: PER_COMPETENCE_DATA_PUMP.get_proficiency_level_id;
513: --
514: L_HIGH_PROFICIENCY_LEVEL_ID :=
515: PER_COMPETENCE_DATA_PUMP.get_high_proficiency_level_id;
516: --
517: L_WEIGHTING_LEVEL_ID :=
518: PER_COMPETENCE_DATA_PUMP.get_weighting_level_id;
519: --

Line 518: PER_COMPETENCE_DATA_PUMP.get_weighting_level_id;

514: L_HIGH_PROFICIENCY_LEVEL_ID :=
515: PER_COMPETENCE_DATA_PUMP.get_high_proficiency_level_id;
516: --
517: L_WEIGHTING_LEVEL_ID :=
518: PER_COMPETENCE_DATA_PUMP.get_weighting_level_id;
519: --
520: L_RATING_LEVEL_ID :=
521: PER_COMPETENCE_DATA_PUMP.get_rating_level_id
522: (P_DATA_PUMP_ALWAYS_CALL => null

Line 521: PER_COMPETENCE_DATA_PUMP.get_rating_level_id

517: L_WEIGHTING_LEVEL_ID :=
518: PER_COMPETENCE_DATA_PUMP.get_weighting_level_id;
519: --
520: L_RATING_LEVEL_ID :=
521: PER_COMPETENCE_DATA_PUMP.get_rating_level_id
522: (P_DATA_PUMP_ALWAYS_CALL => null
523: ,P_RATING_SCALE_NAME => c.p68
524: ,P_COMPETENCE_NAME => c.p67
525: ,P_RATING_LEVEL_NAME => c.p69

Line 529: PER_COMPETENCE_DATA_PUMP.get_person_id;

525: ,P_RATING_LEVEL_NAME => c.p69
526: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID);
527: --
528: L_PERSON_ID :=
529: PER_COMPETENCE_DATA_PUMP.get_person_id;
530: --
531: if c.p70 is null or
532: c.p39 is null then
533: L_JOB_ID:=nn;

Line 543: PER_COMPETENCE_DATA_PUMP.get_valid_grade_id;

539: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID);
540: end if;
541: --
542: L_VALID_GRADE_ID :=
543: PER_COMPETENCE_DATA_PUMP.get_valid_grade_id;
544: --
545: L_POSITION_ID :=
546: PER_COMPETENCE_DATA_PUMP.get_position_id;
547: --

Line 546: PER_COMPETENCE_DATA_PUMP.get_position_id;

542: L_VALID_GRADE_ID :=
543: PER_COMPETENCE_DATA_PUMP.get_valid_grade_id;
544: --
545: L_POSITION_ID :=
546: PER_COMPETENCE_DATA_PUMP.get_position_id;
547: --
548: if c.p71 is null or
549: c.p39 is null or
550: c.p72 is null then

Line 562: PER_COMPETENCE_DATA_PUMP.GET_PARENT_COMP_ELEMENT_ID;

558: ,P_LANGUAGE_CODE => c.p72);
559: end if;
560: --
561: L_PARENT_COMPETENCE_ELEMENT_ID :=
562: PER_COMPETENCE_DATA_PUMP.GET_PARENT_COMP_ELEMENT_ID;
563: --
564: L_ACTIVITY_VERSION_ID :=
565: PER_COMPETENCE_DATA_PUMP.get_activity_version_id;
566: --

Line 565: PER_COMPETENCE_DATA_PUMP.get_activity_version_id;

561: L_PARENT_COMPETENCE_ELEMENT_ID :=
562: PER_COMPETENCE_DATA_PUMP.GET_PARENT_COMP_ELEMENT_ID;
563: --
564: L_ACTIVITY_VERSION_ID :=
565: PER_COMPETENCE_DATA_PUMP.get_activity_version_id;
566: --
567: L_ASSESSMENT_ID :=
568: PER_COMPETENCE_DATA_PUMP.get_assessment_id;
569: --

Line 568: PER_COMPETENCE_DATA_PUMP.get_assessment_id;

564: L_ACTIVITY_VERSION_ID :=
565: PER_COMPETENCE_DATA_PUMP.get_activity_version_id;
566: --
567: L_ASSESSMENT_ID :=
568: PER_COMPETENCE_DATA_PUMP.get_assessment_id;
569: --
570: L_ASSESSMENT_TYPE_ID :=
571: PER_COMPETENCE_DATA_PUMP.get_assessment_type_id;
572: --

Line 571: PER_COMPETENCE_DATA_PUMP.get_assessment_type_id;

567: L_ASSESSMENT_ID :=
568: PER_COMPETENCE_DATA_PUMP.get_assessment_id;
569: --
570: L_ASSESSMENT_TYPE_ID :=
571: PER_COMPETENCE_DATA_PUMP.get_assessment_type_id;
572: --
573: L_OBJECT_ID :=
574: PER_COMPETENCE_DATA_PUMP.get_object_id;
575: --

Line 574: PER_COMPETENCE_DATA_PUMP.get_object_id;

570: L_ASSESSMENT_TYPE_ID :=
571: PER_COMPETENCE_DATA_PUMP.get_assessment_type_id;
572: --
573: L_OBJECT_ID :=
574: PER_COMPETENCE_DATA_PUMP.get_object_id;
575: --
576: L_QUALIFICATION_TYPE_ID :=
577: PER_COMPETENCE_DATA_PUMP.get_qualification_type_id
578: (P_DATA_PUMP_ALWAYS_CALL => null

Line 577: PER_COMPETENCE_DATA_PUMP.get_qualification_type_id

573: L_OBJECT_ID :=
574: PER_COMPETENCE_DATA_PUMP.get_object_id;
575: --
576: L_QUALIFICATION_TYPE_ID :=
577: PER_COMPETENCE_DATA_PUMP.get_qualification_type_id
578: (P_DATA_PUMP_ALWAYS_CALL => null
579: ,P_QUALIFICATION_TYPE_NAME => c.p73);
580: --
581: hr_data_pump.api_trc_on;