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_COMPETENCE_OUTCOME_API dependencies on PER_COMPETENCE_OUTCOMES

Line 74: l_language_code per_competence_outcomes_tl.language%TYPE;

70: --
71:
72: l_proc varchar2(72) := g_package||'create_outcome';
73: l_effective_date date;
74: l_language_code per_competence_outcomes_tl.language%TYPE;
75:
76: --
77: -- Declare out parameters
78: --

Line 79: l_outcome_id per_competence_outcomes.outcome_id%TYPE;

75:
76: --
77: -- Declare out parameters
78: --
79: l_outcome_id per_competence_outcomes.outcome_id%TYPE;
80: l_object_version_number per_competence_outcomes.object_version_number%TYPE;
81: --
82: begin
83: --

Line 80: l_object_version_number per_competence_outcomes.object_version_number%TYPE;

76: --
77: -- Declare out parameters
78: --
79: l_outcome_id per_competence_outcomes.outcome_id%TYPE;
80: l_object_version_number per_competence_outcomes.object_version_number%TYPE;
81: --
82: begin
83: --
84: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 243: -- Insert translatable rows in per_competence_outcomes_tl table

239:
240: hr_utility.set_location(l_proc, 50);
241:
242: --
243: -- Insert translatable rows in per_competence_outcomes_tl table
244: --
245: per_cot_ins.ins_tl
246: (p_outcome_id => l_outcome_id
247: ,p_language_code => l_language_code

Line 443: lv_object_version_number per_competence_outcomes.object_version_number%TYPE;

439: -- Declare cursors and local variables
440: --
441: l_proc varchar2(72) := g_package||'update_outcome';
442: l_effective_date date;
443: lv_object_version_number per_competence_outcomes.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;

Line 444: l_language_code per_competence_outcomes_tl.language%TYPE;

440: --
441: l_proc varchar2(72) := g_package||'update_outcome';
442: l_effective_date date;
443: lv_object_version_number per_competence_outcomes.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;

Line 453: l_competence_id per_competence_outcomes.competence_id%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:
457: --

Line 467: l_object_version_number per_competence_outcomes.object_version_number%TYPE;

463:
464: --
465: -- Declare out parameters
466: --
467: l_object_version_number per_competence_outcomes.object_version_number%TYPE;
468: --
469: --
470: begin
471: --

Line 645: -- Insert translatable rows in per_competence_outcomes_tl table

641:
642: hr_utility.set_location(l_proc, 50);
643:
644: --
645: -- Insert translatable rows in per_competence_outcomes_tl table
646: --
647: per_cot_upd.upd_tl
648: (p_outcome_id => p_outcome_id
649: ,p_language_code => p_language_code

Line 738: from per_competence_outcomes

734: hr_utility.trace('p_competence_id : ' || p_competence_id);
735: if (p_competence_id = hr_api.g_number) then
736: hr_utility.set_location(l_proc, 72);
737: select competence_id into l_competence_id
738: from per_competence_outcomes
739: where outcome_id = p_outcome_id;
740: else
741: hr_utility.set_location(l_proc, 73);
742: l_competence_id := p_competence_id;

Line 853: lv_object_version_number per_competence_outcomes.object_version_number%TYPE;

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

Line 857: l_competence_id per_competence_outcomes.competence_id%TYPE;

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:
861: cursor csr_get_competence_element_id is

Line 870: l_object_version_number per_competence_outcomes.object_version_number%TYPE;

866:
867: --
868: -- Declare out variables
869: --
870: l_object_version_number per_competence_outcomes.object_version_number%TYPE;
871: --
872: begin
873: hr_utility.set_location('Entering:'|| l_proc, 10);
874:

Line 907: from per_competence_outcomes

903: -- Saved competence_id for calling hr_competence_element api
904: --
905: hr_utility.trace('p_outcome_id : '|| p_outcome_id);
906: select competence_id into l_competence_id
907: from per_competence_outcomes
908: where outcome_id = p_outcome_id;
909:
910: hr_utility.trace('l_competence_id : '|| l_competence_id);
911:

Line 913: -- Remove all matching translation rows in per_competence_outcomes_tl

909:
910: hr_utility.trace('l_competence_id : '|| l_competence_id);
911:
912: --
913: -- Remove all matching translation rows in per_competence_outcomes_tl
914: --
915: per_cot_del.del_tl
916: (p_outcome_id => p_outcome_id
917: );