APPS.HR_CAGR_ENT_ITEM_API dependencies on HR_LOCATIONS_ALL_TL

Line 43: l_language_code hr_locations_all_tl.language%TYPE;

39: l_object_version_number per_cagr_entitlement_items.object_version_number%TYPE;
40: l_cagr_entitlement_item_id per_cagr_entitlement_items.cagr_entitlement_item_id%TYPE;
41: l_effective_date DATE;
42: l_cagr_api_id per_cagr_entitlement_items.cagr_api_id%TYPE;
43: l_language_code hr_locations_all_tl.language%TYPE;
44: --
45: -- Declare variables for Option API Call
46: --
47: l_opt_id ben_opt_f.opt_id%TYPE;

Line 189: -- Now insert translatable rows in HR_LOCATIONS_ALL_TL table

185: ,p_mult_entries_allowed_flag => p_mult_entries_allowed_flag
186: ,p_auto_create_entries_flag => p_auto_create_entries_flag -- CEI Enh
187: ,p_object_version_number => l_object_version_number);
188: --
189: -- Now insert translatable rows in HR_LOCATIONS_ALL_TL table
190: --
191: per_cit_ins.ins_tl
192: (p_language_code => l_language_code
193: ,p_cagr_entitlement_item_id => l_cagr_entitlement_item_id

Line 307: l_language_code hr_locations_all_tl.language%TYPE;

303: --
304: l_proc varchar2(72) := g_package||'update_cagr_entitlement_item';
305: l_object_version_number per_cagr_entitlement_items.object_version_number%TYPE;
306: l_effective_date DATE;
307: l_language_code hr_locations_all_tl.language%TYPE;
308: l_cagr_api_id per_cagr_entitlement_items.cagr_api_id%TYPE;
309: --
310: CURSOR csr_get_api_id IS
311: SELECT cagr_api_id