APPS.HR_CAGR_ENT_ITEM_API dependencies on PER_CAGR_ENTITLEMENT_ITEMS

Line 39: l_object_version_number per_cagr_entitlement_items.object_version_number%TYPE;

35: --
36: -- Declare cursors and local variables
37: --
38: l_proc VARCHAR2(72) := g_package||'create_cagr_entitlement_item';
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;

Line 40: l_cagr_entitlement_item_id per_cagr_entitlement_items.cagr_entitlement_item_id%TYPE;

36: -- Declare cursors and local variables
37: --
38: l_proc VARCHAR2(72) := g_package||'create_cagr_entitlement_item';
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: --

Line 42: l_cagr_api_id per_cagr_entitlement_items.cagr_api_id%TYPE;

38: l_proc VARCHAR2(72) := g_package||'create_cagr_entitlement_item';
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: --

Line 305: l_object_version_number per_cagr_entitlement_items.object_version_number%TYPE;

301: --
302: -- Declare cursors and local variables
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: --

Line 308: l_cagr_api_id per_cagr_entitlement_items.cagr_api_id%TYPE;

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
312: FROM per_cagr_api_parameters p

Line 515: l_object_version_number per_cagr_entitlement_items.object_version_number%TYPE;

511: --
512: -- Declare cursors and local variables
513: --
514: l_proc VARCHAR2(72) := g_package||'update_cagr_entitlement_item';
515: l_object_version_number per_cagr_entitlement_items.object_version_number%TYPE;
516: l_effective_date DATE;
517: l_opt_id NUMBER;
518: l_opt_ovn NUMBER;
519: l_effective_start_date DATE;

Line 526: PER_CAGR_ENTITLEMENT_ITEMS cagitems

522: CURSOR csr_option IS
523: SELECT b.opt_id,
524: b.object_version_number
525: FROM ben_opt_f b,
526: PER_CAGR_ENTITLEMENT_ITEMS cagitems
527: WHERE b.opt_id = cagitems.opt_Id
528: AND cagitems.CAGR_ENTITLEMENT_ITEM_ID = p_cagr_entitlement_item_id;
529: --
530: begin