APPS.HRI_DBI_WMV_SEPARATION dependencies on PAY_EVENTS_WRAPPER

Line 148: p_supv_tab IN OUT NOCOPY pay_events_wrapper.t_summary_refresh_tab_type,

144: -- * effective dates rather than actual calendar dates *
145: -- * Also deletes all appropriate records from the summary table *
146: -- ***********************************************************************
147: PROCEDURE build_full_refresh_table(
148: p_supv_tab IN OUT NOCOPY pay_events_wrapper.t_summary_refresh_tab_type,
149: p_start_date IN DATE,
150: p_end_date IN DATE
151: ) IS
152: --

Line 187: p_supv_tab(l_recs).location_id := pay_events_wrapper.blank_location_id;

183: FOR rec_supv IN get_supervisors_affected(p_start_date,p_end_date) LOOP
184: l_recs := l_recs + 1;
185: dbg('Supervisor('||l_recs||'): '||rec_supv.supervisor_id);
186: p_supv_tab(l_recs).supervisor_id := rec_supv.supervisor_id;
187: p_supv_tab(l_recs).location_id := pay_events_wrapper.blank_location_id;
188: p_supv_tab(l_recs).effective_start_date := rec_supv.effective_start_date;
189: p_supv_tab(l_recs).effective_end_date := rec_supv.effective_end_date;
190: END LOOP;
191: msg('Found '||NVL((p_supv_tab.LAST - p_supv_tab.FIRST)+1,0)||' ('||l_recs||') records');

Line 213: p_supv_tab IN OUT NOCOPY pay_events_wrapper.t_summary_refresh_tab_type,

209: -- * supervisors that we need to refresh *
210: -- * Also deletes all appropriate records from the summary table *
211: -- ***********************************************************************
212: PROCEDURE build_delta_refresh_table(
213: p_supv_tab IN OUT NOCOPY pay_events_wrapper.t_summary_refresh_tab_type,
214: p_start_date IN DATE,
215: p_end_date IN DATE
216: ) IS
217: --

Line 240: pay_events_wrapper.get_summaries_affected(

236: --
237: -- Use the payroll events model to calculate the supervisors and
238: -- date ranges that we need to recalculate
239: msg('Getting affected supervisors from Payroll Events Model wrapper');
240: pay_events_wrapper.get_summaries_affected(
241: p_event_group => event_group,
242: p_start_date => p_start_date,
243: p_end_date => p_end_date,
244: p_summary_refresh => p_supv_tab,

Line 611: p_supv_tab IN OUT NOCOPY pay_events_wrapper.t_summary_refresh_tab_type

607: -- * into the summary table *
608: -- * Return a count of the records inserted *
609: -- ***********************************************************************
610: FUNCTION process_refresh_table(
611: p_supv_tab IN OUT NOCOPY pay_events_wrapper.t_summary_refresh_tab_type
612: ) RETURN NUMBER IS
613: --
614: -- Main cursor to calculate the separations that have happened for a
615: -- supervisor between the given effective dates

Line 793: l_supv_tab pay_events_wrapper.t_summary_refresh_tab_type;

789: --
790: l_start_date DATE := fnd_date.canonical_to_date(p_start_date);
791: l_end_date DATE := fnd_date.canonical_to_date(NVL(p_end_date,eot_char));
792: l_tot_rec NUMBER := 0;
793: l_supv_tab pay_events_wrapper.t_summary_refresh_tab_type;
794: --
795: BEGIN
796: -- Do the BIS refresh framework setup
797: IF bis_collection_utilities.setup(p_object_name => object_name) = FALSE THEN

Line 860: l_supv_tab pay_events_wrapper.t_summary_refresh_tab_type;

856: l_bis_end_date DATE;
857: l_period_from DATE;
858: l_period_to DATE;
859: l_tot_rec NUMBER := 0;
860: l_supv_tab pay_events_wrapper.t_summary_refresh_tab_type;
861: --
862: BEGIN
863: -- Do the BIS refresh framework setup
864: IF bis_collection_utilities.setup(p_object_name => object_name) = FALSE THEN

Line 962: pay_events_wrapper.set_concurrent_logging(TRUE);

958: retcode OUT NOCOPY NUMBER
959: ) IS
960: BEGIN
961: set_debugging(TRUE);
962: pay_events_wrapper.set_concurrent_logging(TRUE);
963: pay_events_wrapper.set_debugging(TRUE);
964: refresh_from_deltas(errbuf,retcode);
965: END refresh_from_deltas_debug;
966: --

Line 963: pay_events_wrapper.set_debugging(TRUE);

959: ) IS
960: BEGIN
961: set_debugging(TRUE);
962: pay_events_wrapper.set_concurrent_logging(TRUE);
963: pay_events_wrapper.set_debugging(TRUE);
964: refresh_from_deltas(errbuf,retcode);
965: END refresh_from_deltas_debug;
966: --
967: BEGIN