APPS.HR_COMPETENCE_OUTCOME_API dependencies on PER_COMPETENCE_ELEMENTS

Line 448: l_cel_ovn per_competence_elements.object_version_number%TYPE;

444: l_language_code per_competence_outcomes_tl.language%TYPE;
445: l_date_from per_comp_element_outcomes.date_from%TYPE;
446: l_date_to per_comp_element_outcomes.date_to%TYPE;
447: l_ceo_ovn per_comp_element_outcomes.object_version_number%TYPE;
448: l_cel_ovn per_competence_elements.object_version_number%TYPE;
449: l_boolean boolean;
450: l_competence_element_id per_competence_elements.competence_element_id%TYPE;
451: l_party_id per_competence_elements.party_id%TYPE;
452: lo_object_version_number per_competence_elements.object_version_number%TYPE;

Line 450: l_competence_element_id per_competence_elements.competence_element_id%TYPE;

446: l_date_to per_comp_element_outcomes.date_to%TYPE;
447: l_ceo_ovn per_comp_element_outcomes.object_version_number%TYPE;
448: l_cel_ovn per_competence_elements.object_version_number%TYPE;
449: l_boolean boolean;
450: l_competence_element_id per_competence_elements.competence_element_id%TYPE;
451: l_party_id per_competence_elements.party_id%TYPE;
452: lo_object_version_number per_competence_elements.object_version_number%TYPE;
453: l_competence_id per_competence_outcomes.competence_id%TYPE;
454: l_exists varchar2(1);

Line 451: l_party_id per_competence_elements.party_id%TYPE;

447: l_ceo_ovn per_comp_element_outcomes.object_version_number%TYPE;
448: l_cel_ovn per_competence_elements.object_version_number%TYPE;
449: l_boolean boolean;
450: l_competence_element_id per_competence_elements.competence_element_id%TYPE;
451: l_party_id per_competence_elements.party_id%TYPE;
452: lo_object_version_number per_competence_elements.object_version_number%TYPE;
453: l_competence_id per_competence_outcomes.competence_id%TYPE;
454: l_exists varchar2(1);
455: l_max_date_from date;

Line 452: lo_object_version_number per_competence_elements.object_version_number%TYPE;

448: l_cel_ovn per_competence_elements.object_version_number%TYPE;
449: l_boolean boolean;
450: l_competence_element_id per_competence_elements.competence_element_id%TYPE;
451: l_party_id per_competence_elements.party_id%TYPE;
452: lo_object_version_number per_competence_elements.object_version_number%TYPE;
453: l_competence_id per_competence_outcomes.competence_id%TYPE;
454: l_exists varchar2(1);
455: l_max_date_from date;
456:

Line 460: from per_competence_elements

456:
457: --
458: cursor csr_get_competence_element_id is
459: select competence_element_id ,party_id,object_version_number
460: from per_competence_elements
461: where competence_id = l_competence_id
462: and type = 'PERSONAL';
463:
464: --

Line 854: l_competence_element_id per_competence_elements.competence_element_id%TYPE;

850: -- Declare cursors and local variables
851: --
852: l_proc varchar2(72) := g_package||'delete_outcome';
853: lv_object_version_number per_competence_outcomes.object_version_number%TYPE;
854: l_competence_element_id per_competence_elements.competence_element_id%TYPE;
855: l_party_id per_competence_elements.party_id%TYPE;
856: lo_object_version_number per_competence_elements.object_version_number%TYPE;
857: l_competence_id per_competence_outcomes.competence_id%TYPE;
858: l_max_date_from date;

Line 855: l_party_id per_competence_elements.party_id%TYPE;

851: --
852: l_proc varchar2(72) := g_package||'delete_outcome';
853: lv_object_version_number per_competence_outcomes.object_version_number%TYPE;
854: l_competence_element_id per_competence_elements.competence_element_id%TYPE;
855: l_party_id per_competence_elements.party_id%TYPE;
856: lo_object_version_number per_competence_elements.object_version_number%TYPE;
857: l_competence_id per_competence_outcomes.competence_id%TYPE;
858: l_max_date_from date;
859:

Line 856: lo_object_version_number per_competence_elements.object_version_number%TYPE;

852: l_proc varchar2(72) := g_package||'delete_outcome';
853: lv_object_version_number per_competence_outcomes.object_version_number%TYPE;
854: l_competence_element_id per_competence_elements.competence_element_id%TYPE;
855: l_party_id per_competence_elements.party_id%TYPE;
856: lo_object_version_number per_competence_elements.object_version_number%TYPE;
857: l_competence_id per_competence_outcomes.competence_id%TYPE;
858: l_max_date_from date;
859:
860:

Line 863: from per_competence_elements

859:
860:
861: cursor csr_get_competence_element_id is
862: select competence_element_id ,party_id,object_version_number
863: from per_competence_elements
864: where competence_id = l_competence_id
865: and type = 'PERSONAL' and status = 'IN_PROGRESS';
866:
867: --