DBA Data[Home] [Help]

APPS.BEN_EXT_PAYROLL_BALANCE dependencies on BEN_EXT_PERSON

Line 273: (p_pay_events_tab IN ben_ext_person.t_detailed_output_table)

269:
270: --
271:
272: PROCEDURE sort_payroll_events
273: (p_pay_events_tab IN ben_ext_person.t_detailed_output_table)
274: IS
275:
276: l_pay_events_tab ben_ext_person.t_detailed_output_table;
277: l_sortrec ben_ext_person.t_detailed_output_tab_rec;

Line 276: l_pay_events_tab ben_ext_person.t_detailed_output_table;

272: PROCEDURE sort_payroll_events
273: (p_pay_events_tab IN ben_ext_person.t_detailed_output_table)
274: IS
275:
276: l_pay_events_tab ben_ext_person.t_detailed_output_table;
277: l_sortrec ben_ext_person.t_detailed_output_tab_rec;
278: l_next_event_date date ;
279: l_proc varchar2(75) ;
280: BEGIN

Line 277: l_sortrec ben_ext_person.t_detailed_output_tab_rec;

273: (p_pay_events_tab IN ben_ext_person.t_detailed_output_table)
274: IS
275:
276: l_pay_events_tab ben_ext_person.t_detailed_output_table;
277: l_sortrec ben_ext_person.t_detailed_output_tab_rec;
278: l_next_event_date date ;
279: l_proc varchar2(75) ;
280: BEGIN
281:

Line 285: ben_ext_person.g_pay_proc_evt_tab := l_pay_events_tab ;

281:
282: l_proc := g_package ||'sort_payroll_events';
283: hr_utility.set_location('Entering: '||l_proc, 5);
284: -- nullify the global table
285: ben_ext_person.g_pay_proc_evt_tab := l_pay_events_tab ;
286: --intiali
287: l_pay_events_tab := p_pay_events_tab;
288:
289: hr_utility.set_location('Before Looping ', 10);

Line 326: ben_ext_person.g_pay_proc_evt_tab := l_pay_events_tab;

322: --
323: END IF;
324:
325: -- Assign back the sorted collection
326: ben_ext_person.g_pay_proc_evt_tab := l_pay_events_tab;
327:
328: hr_utility.set_location('Leaving: '||l_proc, 80);
329: EXCEPTION
330: WHEN OTHERS THEN

Line 331: ben_ext_person.g_pay_proc_evt_tab := p_pay_events_tab ;

327:
328: hr_utility.set_location('Leaving: '||l_proc, 80);
329: EXCEPTION
330: WHEN OTHERS THEN
331: ben_ext_person.g_pay_proc_evt_tab := p_pay_events_tab ;
332: hr_utility.set_location('error ' || substr(sqlerrm,1,200) , 99 ) ;
333: RAISE;
334: END;
335: