APPS.PAY_US_RSRW_UPGREV dependencies on PAY_EVENT_GROUPS

Line 2110: ln_event_group_id pay_event_groups.event_group_id%TYPE;

2106: AND pdt.table_name = p_table_name
2107: AND pdt.legislation_code IS NULL
2108: AND pdt.business_group_id IS NULL;
2109:
2110: ln_event_group_id pay_event_groups.event_group_id%TYPE;
2111: ln_event_grp_ovn pay_event_groups.object_version_number%TYPE;
2112: ln_eef_dt_ovn pay_datetracked_events.object_version_number%TYPE;
2113: ln_eevf_dt_ovn pay_datetracked_events.object_version_number%TYPE;
2114: ln_paaf_dt_ovn pay_datetracked_events.object_version_number%TYPE;

Line 2111: ln_event_grp_ovn pay_event_groups.object_version_number%TYPE;

2107: AND pdt.legislation_code IS NULL
2108: AND pdt.business_group_id IS NULL;
2109:
2110: ln_event_group_id pay_event_groups.event_group_id%TYPE;
2111: ln_event_grp_ovn pay_event_groups.object_version_number%TYPE;
2112: ln_eef_dt_ovn pay_datetracked_events.object_version_number%TYPE;
2113: ln_eevf_dt_ovn pay_datetracked_events.object_version_number%TYPE;
2114: ln_paaf_dt_ovn pay_datetracked_events.object_version_number%TYPE;
2115:

Line 2135: pay_event_groups_api.create_event_group(FALSE

2131: col_name_tbl.delete;
2132: END IF;
2133:
2134: hr_utility.trace('Before Event Group Creation.');
2135: pay_event_groups_api.create_event_group(FALSE
2136: ,fnd_date.canonical_to_date('0001/01/01')
2137: ,'Proration Group for Regular Salary'
2138: ,'P'
2139: ,'P'

Line 2290: FROM pay_event_groups peg

2286:
2287: CURSOR get_proration_event_grp(cp_event_grp_nm IN VARCHAR2) IS
2288: SELECT event_group_id
2289: ,object_version_number
2290: FROM pay_event_groups peg
2291: WHERE peg.event_group_name = cp_event_grp_nm
2292: AND peg.event_group_type = 'P'
2293: AND peg.proration_type = 'P'
2294: AND peg.legislation_code = 'US'

Line 2297: ln_event_grp_id pay_event_groups.event_group_id%TYPE;

2293: AND peg.proration_type = 'P'
2294: AND peg.legislation_code = 'US'
2295: AND peg.business_group_id IS NULL;
2296:
2297: ln_event_grp_id pay_event_groups.event_group_id%TYPE;
2298: ln_obj_ver_num pay_event_groups.object_version_number%TYPE;
2299:
2300: BEGIN
2301:

Line 2298: ln_obj_ver_num pay_event_groups.object_version_number%TYPE;

2294: AND peg.legislation_code = 'US'
2295: AND peg.business_group_id IS NULL;
2296:
2297: ln_event_grp_id pay_event_groups.event_group_id%TYPE;
2298: ln_obj_ver_num pay_event_groups.object_version_number%TYPE;
2299:
2300: BEGIN
2301:
2302: hr_utility.trace('Entered into pay_us_rsrw_upgrev.delete_proration_group');

Line 2314: pay_event_groups_api.delete_event_group(p_event_group_id => ln_event_grp_id

2310:
2311: delete from pay_datetracked_events
2312: where event_group_id = ln_event_grp_id;
2313:
2314: pay_event_groups_api.delete_event_group(p_event_group_id => ln_event_grp_id
2315: ,p_object_version_number => ln_obj_ver_num);
2316:
2317: commit;
2318: END delete_proration_group;

Line 2357: FROM pay_event_groups peg

2353:
2354: -- Get Proration Event Group
2355: CURSOR get_proration_event_grp(cp_event_grp_nm IN VARCHAR2) IS
2356: SELECT event_group_id
2357: FROM pay_event_groups peg
2358: WHERE peg.event_group_name = cp_event_grp_nm
2359: AND peg.event_group_type = 'P'
2360: AND peg.proration_type = 'P'
2361: AND peg.legislation_code = 'US'

Line 2366: ln_proration_event_grp_id pay_event_groups.event_group_id%TYPE;

2362: AND peg.business_group_id IS NULL;
2363:
2364: -- Local Variable Declaration
2365: l_date_of_mig date;
2366: ln_proration_event_grp_id pay_event_groups.event_group_id%TYPE;
2367: ln_rs_ele_typ_id number;
2368: lv_rs_ele_name pay_element_types_f.element_name%TYPE;
2369: ln_rs_proration_grp_id pay_element_types_f.proration_group_id%TYPE;
2370: ln_rw_ele_typ_id number;

Line 2614: ln_proration_event_grp_id pay_event_groups.event_group_id%TYPE;

2610: ln_rs_proration_grp_id pay_element_types_f.proration_group_id%TYPE;
2611: ln_rw_ele_typ_id number;
2612: lv_rw_ele_name pay_element_types_f.element_name%TYPE;
2613: ln_rw_proration_grp_id pay_element_types_f.proration_group_id%TYPE;
2614: ln_proration_event_grp_id pay_event_groups.event_group_id%TYPE;
2615: lv_upg_status varchar2(30);
2616: ln_upg_defn_id NUMBER;
2617: ln_dbg_step NUMBER;
2618: