APPS.HR_COMP_ELEMENT_OUTCOME_API dependencies on PER_COMP_ELEMENT_OUTCOMES

Line 87: l_comp_element_outcome_id per_comp_element_outcomes.comp_element_outcome_id%TYPE;

83:
84: --
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;

Line 88: l_object_version_number per_comp_element_outcomes.object_version_number%TYPE;

84: --
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;

Line 470: lv_object_version_number per_comp_element_outcomes.object_version_number%TYPE;

466: -- Declare cursors and local variables
467: --
468: l_proc varchar2(72) := g_package||'update_element_outcome';
469: l_effective_date date;
470: lv_object_version_number per_comp_element_outcomes.object_version_number%TYPE;
471:
472: --
473: -- Declare out parameters
474: --

Line 475: l_object_version_number per_comp_element_outcomes.object_version_number%TYPE;

471:
472: --
473: -- Declare out parameters
474: --
475: l_object_version_number per_comp_element_outcomes.object_version_number%TYPE;
476:
477: --
478: begin
479: --

Line 770: from per_comp_element_outcomes

766: --
767:
768: cursor csr_get_competence_element_id is
769: select competence_element_id
770: from per_comp_element_outcomes
771: where comp_element_outcome_id = p_comp_element_outcome_id;
772:
773: l_competence_element_id per_comp_element_outcomes.competence_element_id%TYPE;
774: cursor csr_competence_element is

Line 773: l_competence_element_id per_comp_element_outcomes.competence_element_id%TYPE;

769: select competence_element_id
770: from per_comp_element_outcomes
771: where comp_element_outcome_id = p_comp_element_outcome_id;
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;

Line 781: lv_object_version_number per_comp_element_outcomes.object_version_number%TYPE;

777: where competence_element_id = l_competence_element_id;
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;

Line 791: l_object_version_number per_comp_element_outcomes.object_version_number%TYPE;

787:
788: --
789: -- Declare out variables
790: --
791: l_object_version_number per_comp_element_outcomes.object_version_number%TYPE;
792: --
793: begin
794: hr_utility.set_location('Entering:'|| l_proc, 10);
795: