APPS.HR_COMPETENCE_OUTCOME_API dependencies on PER_COMPETENCE_OUTCOMES_TL

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