eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_COMP_ELEMENT_OUTCOME_API dependencies on PER_COMPETENCE_ELEMENTS

Line 70: from per_competence_elements

66: -- Declare cursors and local variables
67: --
68: cursor csr_competence_element is
69: select party_id ,person_id, type, status, object_version_number
70: from per_competence_elements
71: where competence_element_id = p_competence_element_id;
72:
73: cursor csr_get_competence_id is
74: select competence_id

Line 89: lv_object_version_number per_competence_elements.object_version_number%TYPE;

85: -- Declare out parameters
86: --
87: l_comp_element_outcome_id per_comp_element_outcomes.comp_element_outcome_id%TYPE;
88: l_object_version_number per_comp_element_outcomes.object_version_number%TYPE;
89: lv_object_version_number per_competence_elements.object_version_number%TYPE;
90: l_party_id per_competence_elements.party_id%TYPE;
91: l_person_id per_competence_elements.person_id%TYPE;
92: l_type per_competence_elements.type%TYPE;
93: l_status per_competence_elements.status%TYPE;

Line 90: l_party_id per_competence_elements.party_id%TYPE;

86: --
87: l_comp_element_outcome_id per_comp_element_outcomes.comp_element_outcome_id%TYPE;
88: l_object_version_number per_comp_element_outcomes.object_version_number%TYPE;
89: lv_object_version_number per_competence_elements.object_version_number%TYPE;
90: l_party_id per_competence_elements.party_id%TYPE;
91: l_person_id per_competence_elements.person_id%TYPE;
92: l_type per_competence_elements.type%TYPE;
93: l_status per_competence_elements.status%TYPE;
94:

Line 91: l_person_id per_competence_elements.person_id%TYPE;

87: l_comp_element_outcome_id per_comp_element_outcomes.comp_element_outcome_id%TYPE;
88: l_object_version_number per_comp_element_outcomes.object_version_number%TYPE;
89: lv_object_version_number per_competence_elements.object_version_number%TYPE;
90: l_party_id per_competence_elements.party_id%TYPE;
91: l_person_id per_competence_elements.person_id%TYPE;
92: l_type per_competence_elements.type%TYPE;
93: l_status per_competence_elements.status%TYPE;
94:
95: --

Line 92: l_type per_competence_elements.type%TYPE;

88: l_object_version_number per_comp_element_outcomes.object_version_number%TYPE;
89: lv_object_version_number per_competence_elements.object_version_number%TYPE;
90: l_party_id per_competence_elements.party_id%TYPE;
91: l_person_id per_competence_elements.person_id%TYPE;
92: l_type per_competence_elements.type%TYPE;
93: l_status per_competence_elements.status%TYPE;
94:
95: --
96: begin

Line 93: l_status per_competence_elements.status%TYPE;

89: lv_object_version_number per_competence_elements.object_version_number%TYPE;
90: l_party_id per_competence_elements.party_id%TYPE;
91: l_person_id per_competence_elements.person_id%TYPE;
92: l_type per_competence_elements.type%TYPE;
93: l_status per_competence_elements.status%TYPE;
94:
95: --
96: begin
97: --

Line 776: from per_competence_elements

772:
773: l_competence_element_id per_comp_element_outcomes.competence_element_id%TYPE;
774: cursor csr_competence_element is
775: select party_id ,person_id, type, status, object_version_number
776: from per_competence_elements
777: where competence_element_id = l_competence_element_id;
778:
779:
780: l_proc varchar2(72) := g_package||'delete_element_outcome';

Line 782: ll_object_version_number per_competence_elements.object_version_number%TYPE;

778:
779:
780: l_proc varchar2(72) := g_package||'delete_element_outcome';
781: lv_object_version_number per_comp_element_outcomes.object_version_number%TYPE;
782: ll_object_version_number per_competence_elements.object_version_number%TYPE;
783: l_party_id per_competence_elements.party_id%TYPE;
784: l_person_id per_competence_elements.person_id%TYPE;
785: l_type per_competence_elements.type%TYPE;
786: l_status per_competence_elements.status%TYPE;

Line 783: l_party_id per_competence_elements.party_id%TYPE;

779:
780: l_proc varchar2(72) := g_package||'delete_element_outcome';
781: lv_object_version_number per_comp_element_outcomes.object_version_number%TYPE;
782: ll_object_version_number per_competence_elements.object_version_number%TYPE;
783: l_party_id per_competence_elements.party_id%TYPE;
784: l_person_id per_competence_elements.person_id%TYPE;
785: l_type per_competence_elements.type%TYPE;
786: l_status per_competence_elements.status%TYPE;
787:

Line 784: l_person_id per_competence_elements.person_id%TYPE;

780: l_proc varchar2(72) := g_package||'delete_element_outcome';
781: lv_object_version_number per_comp_element_outcomes.object_version_number%TYPE;
782: ll_object_version_number per_competence_elements.object_version_number%TYPE;
783: l_party_id per_competence_elements.party_id%TYPE;
784: l_person_id per_competence_elements.person_id%TYPE;
785: l_type per_competence_elements.type%TYPE;
786: l_status per_competence_elements.status%TYPE;
787:
788: --

Line 785: l_type per_competence_elements.type%TYPE;

781: lv_object_version_number per_comp_element_outcomes.object_version_number%TYPE;
782: ll_object_version_number per_competence_elements.object_version_number%TYPE;
783: l_party_id per_competence_elements.party_id%TYPE;
784: l_person_id per_competence_elements.person_id%TYPE;
785: l_type per_competence_elements.type%TYPE;
786: l_status per_competence_elements.status%TYPE;
787:
788: --
789: -- Declare out variables

Line 786: l_status per_competence_elements.status%TYPE;

782: ll_object_version_number per_competence_elements.object_version_number%TYPE;
783: l_party_id per_competence_elements.party_id%TYPE;
784: l_person_id per_competence_elements.person_id%TYPE;
785: l_type per_competence_elements.type%TYPE;
786: l_status per_competence_elements.status%TYPE;
787:
788: --
789: -- Declare out variables
790: --