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.PAY_US_RSRW_UPGREV dependencies on PAY_DATETRACKED_EVENTS

Line 2112: ln_eef_dt_ovn pay_datetracked_events.object_version_number%TYPE;

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:
2116: ln_eef_dt_event_id pay_datetracked_events.datetracked_event_id%TYPE;

Line 2113: ln_eevf_dt_ovn pay_datetracked_events.object_version_number%TYPE;

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:
2116: ln_eef_dt_event_id pay_datetracked_events.datetracked_event_id%TYPE;
2117: ln_eevf_dt_event_id pay_datetracked_events.datetracked_event_id%TYPE;

Line 2114: ln_paaf_dt_ovn pay_datetracked_events.object_version_number%TYPE;

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:
2116: ln_eef_dt_event_id pay_datetracked_events.datetracked_event_id%TYPE;
2117: ln_eevf_dt_event_id pay_datetracked_events.datetracked_event_id%TYPE;
2118: ln_paaf_dt_event_id pay_datetracked_events.datetracked_event_id%TYPE;

Line 2116: ln_eef_dt_event_id pay_datetracked_events.datetracked_event_id%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:
2116: ln_eef_dt_event_id pay_datetracked_events.datetracked_event_id%TYPE;
2117: ln_eevf_dt_event_id pay_datetracked_events.datetracked_event_id%TYPE;
2118: ln_paaf_dt_event_id pay_datetracked_events.datetracked_event_id%TYPE;
2119:
2120: ln_eef_dt_tbl_id pay_dated_tables.dated_table_id%TYPE;

Line 2117: ln_eevf_dt_event_id pay_datetracked_events.datetracked_event_id%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:
2116: ln_eef_dt_event_id pay_datetracked_events.datetracked_event_id%TYPE;
2117: ln_eevf_dt_event_id pay_datetracked_events.datetracked_event_id%TYPE;
2118: ln_paaf_dt_event_id pay_datetracked_events.datetracked_event_id%TYPE;
2119:
2120: ln_eef_dt_tbl_id pay_dated_tables.dated_table_id%TYPE;
2121: ln_eevf_dt_tbl_id pay_dated_tables.dated_table_id%TYPE;

Line 2118: ln_paaf_dt_event_id pay_datetracked_events.datetracked_event_id%TYPE;

2114: ln_paaf_dt_ovn pay_datetracked_events.object_version_number%TYPE;
2115:
2116: ln_eef_dt_event_id pay_datetracked_events.datetracked_event_id%TYPE;
2117: ln_eevf_dt_event_id pay_datetracked_events.datetracked_event_id%TYPE;
2118: ln_paaf_dt_event_id pay_datetracked_events.datetracked_event_id%TYPE;
2119:
2120: ln_eef_dt_tbl_id pay_dated_tables.dated_table_id%TYPE;
2121: ln_eevf_dt_tbl_id pay_dated_tables.dated_table_id%TYPE;
2122: ln_paaf_dt_tbl_id pay_dated_tables.dated_table_id%TYPE;

Line 2172: pay_datetracked_events_api.create_datetracked_event(FALSE

2168: hr_utility.trace('ln_event_group_id := ' || ln_event_group_id);
2169: hr_utility.trace('ln_eef_dt_tbl_id := ' || ln_eef_dt_tbl_id);
2170: hr_utility.trace('col_name_tbl(i) := ' || col_name_tbl(i));
2171:
2172: pay_datetracked_events_api.create_datetracked_event(FALSE
2173: ,fnd_date.canonical_to_date('0001/01/01')
2174: ,ln_event_group_id
2175: ,ln_eef_dt_tbl_id
2176: ,'U'

Line 2216: pay_datetracked_events_api.create_datetracked_event(FALSE

2212: hr_utility.trace('ln_event_group_id := ' || ln_event_group_id);
2213: hr_utility.trace('ln_eevf_dt_tbl_id := ' || ln_eevf_dt_tbl_id);
2214: hr_utility.trace('col_name_tbl(i) := ' || col_name_tbl(i));
2215:
2216: pay_datetracked_events_api.create_datetracked_event(FALSE
2217: ,fnd_date.canonical_to_date('0001/01/01')
2218: ,ln_event_group_id
2219: ,ln_eevf_dt_tbl_id
2220: ,'U'

Line 2260: pay_datetracked_events_api.create_datetracked_event(FALSE

2256: hr_utility.trace('ln_event_group_id := ' || ln_event_group_id);
2257: hr_utility.trace('ln_paaf_dt_tbl_id := ' || ln_paaf_dt_tbl_id);
2258: hr_utility.trace('col_name_tbl(i) := ' || col_name_tbl(i));
2259:
2260: pay_datetracked_events_api.create_datetracked_event(FALSE
2261: ,fnd_date.canonical_to_date('0001/01/01')
2262: ,ln_event_group_id
2263: ,ln_paaf_dt_tbl_id
2264: ,'U'

Line 2311: delete from pay_datetracked_events

2307:
2308: hr_utility.trace('ln_event_grp_id := ' || ln_event_grp_id);
2309: hr_utility.trace('ln_obj_ver_num := ' || ln_obj_ver_num);
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);