[Home] [Help]
1: PACKAGE BODY pay_emp_action_arch AS
2: /* $Header: pyempxfr.pkb 120.10.12010000.4 2008/08/06 07:10:48 ubhat ship $ */
3: /*
4: ******************************************************************
5: * *
16: * 500 Oracle Parkway, Redwood City, CA, 94065. *
17: * *
18: ******************************************************************
19:
20: Name : pay_emp_action_arch
21:
22: Description : This package populates the global data
23: for payslip in pay_action_information table.
24: The action_information_categories that it
341:
342: /******************************************************************
343: Name : initialization_process
344: Purpose : The procedure initializes the PL/SQL table -
345: pay_emp_action_arch.lrr_act_tab,
346: pay_emp_action_arch.ltr_ppa_arch and
347: pay_us_emp_payslip_accrual_web.ltr_assignment_accruals.
348: Arguments :
349: Notes :
342: /******************************************************************
343: Name : initialization_process
344: Purpose : The procedure initializes the PL/SQL table -
345: pay_emp_action_arch.lrr_act_tab,
346: pay_emp_action_arch.ltr_ppa_arch and
347: pay_us_emp_payslip_accrual_web.ltr_assignment_accruals.
348: Arguments :
349: Notes :
350: ******************************************************************/
355: BEGIN
356: lv_procedure_name := '.initialization_process';
357: hr_utility.set_location(gv_package || lv_procedure_name, 10);
358:
359: if pay_emp_action_arch.lrr_act_tab.count > 0 then
360: hr_utility.set_location(gv_package || lv_procedure_name, 20);
361: for i in pay_emp_action_arch.lrr_act_tab.first ..
362: pay_emp_action_arch.lrr_act_tab.last loop
363: pay_emp_action_arch.lrr_act_tab(i).action_context_id := null;
357: hr_utility.set_location(gv_package || lv_procedure_name, 10);
358:
359: if pay_emp_action_arch.lrr_act_tab.count > 0 then
360: hr_utility.set_location(gv_package || lv_procedure_name, 20);
361: for i in pay_emp_action_arch.lrr_act_tab.first ..
362: pay_emp_action_arch.lrr_act_tab.last loop
363: pay_emp_action_arch.lrr_act_tab(i).action_context_id := null;
364: pay_emp_action_arch.lrr_act_tab(i).action_context_type := null;
365: pay_emp_action_arch.lrr_act_tab(i).action_info_category := null;
358:
359: if pay_emp_action_arch.lrr_act_tab.count > 0 then
360: hr_utility.set_location(gv_package || lv_procedure_name, 20);
361: for i in pay_emp_action_arch.lrr_act_tab.first ..
362: pay_emp_action_arch.lrr_act_tab.last loop
363: pay_emp_action_arch.lrr_act_tab(i).action_context_id := null;
364: pay_emp_action_arch.lrr_act_tab(i).action_context_type := null;
365: pay_emp_action_arch.lrr_act_tab(i).action_info_category := null;
366: pay_emp_action_arch.lrr_act_tab(i).jurisdiction_code := null;
359: if pay_emp_action_arch.lrr_act_tab.count > 0 then
360: hr_utility.set_location(gv_package || lv_procedure_name, 20);
361: for i in pay_emp_action_arch.lrr_act_tab.first ..
362: pay_emp_action_arch.lrr_act_tab.last loop
363: pay_emp_action_arch.lrr_act_tab(i).action_context_id := null;
364: pay_emp_action_arch.lrr_act_tab(i).action_context_type := null;
365: pay_emp_action_arch.lrr_act_tab(i).action_info_category := null;
366: pay_emp_action_arch.lrr_act_tab(i).jurisdiction_code := null;
367: pay_emp_action_arch.lrr_act_tab(i).act_info1 := null;
360: hr_utility.set_location(gv_package || lv_procedure_name, 20);
361: for i in pay_emp_action_arch.lrr_act_tab.first ..
362: pay_emp_action_arch.lrr_act_tab.last loop
363: pay_emp_action_arch.lrr_act_tab(i).action_context_id := null;
364: pay_emp_action_arch.lrr_act_tab(i).action_context_type := null;
365: pay_emp_action_arch.lrr_act_tab(i).action_info_category := null;
366: pay_emp_action_arch.lrr_act_tab(i).jurisdiction_code := null;
367: pay_emp_action_arch.lrr_act_tab(i).act_info1 := null;
368: pay_emp_action_arch.lrr_act_tab(i).act_info2 := null;
361: for i in pay_emp_action_arch.lrr_act_tab.first ..
362: pay_emp_action_arch.lrr_act_tab.last loop
363: pay_emp_action_arch.lrr_act_tab(i).action_context_id := null;
364: pay_emp_action_arch.lrr_act_tab(i).action_context_type := null;
365: pay_emp_action_arch.lrr_act_tab(i).action_info_category := null;
366: pay_emp_action_arch.lrr_act_tab(i).jurisdiction_code := null;
367: pay_emp_action_arch.lrr_act_tab(i).act_info1 := null;
368: pay_emp_action_arch.lrr_act_tab(i).act_info2 := null;
369: pay_emp_action_arch.lrr_act_tab(i).act_info3 := null;
362: pay_emp_action_arch.lrr_act_tab.last loop
363: pay_emp_action_arch.lrr_act_tab(i).action_context_id := null;
364: pay_emp_action_arch.lrr_act_tab(i).action_context_type := null;
365: pay_emp_action_arch.lrr_act_tab(i).action_info_category := null;
366: pay_emp_action_arch.lrr_act_tab(i).jurisdiction_code := null;
367: pay_emp_action_arch.lrr_act_tab(i).act_info1 := null;
368: pay_emp_action_arch.lrr_act_tab(i).act_info2 := null;
369: pay_emp_action_arch.lrr_act_tab(i).act_info3 := null;
370: pay_emp_action_arch.lrr_act_tab(i).act_info4 := null;
363: pay_emp_action_arch.lrr_act_tab(i).action_context_id := null;
364: pay_emp_action_arch.lrr_act_tab(i).action_context_type := null;
365: pay_emp_action_arch.lrr_act_tab(i).action_info_category := null;
366: pay_emp_action_arch.lrr_act_tab(i).jurisdiction_code := null;
367: pay_emp_action_arch.lrr_act_tab(i).act_info1 := null;
368: pay_emp_action_arch.lrr_act_tab(i).act_info2 := null;
369: pay_emp_action_arch.lrr_act_tab(i).act_info3 := null;
370: pay_emp_action_arch.lrr_act_tab(i).act_info4 := null;
371: pay_emp_action_arch.lrr_act_tab(i).act_info5 := null;
364: pay_emp_action_arch.lrr_act_tab(i).action_context_type := null;
365: pay_emp_action_arch.lrr_act_tab(i).action_info_category := null;
366: pay_emp_action_arch.lrr_act_tab(i).jurisdiction_code := null;
367: pay_emp_action_arch.lrr_act_tab(i).act_info1 := null;
368: pay_emp_action_arch.lrr_act_tab(i).act_info2 := null;
369: pay_emp_action_arch.lrr_act_tab(i).act_info3 := null;
370: pay_emp_action_arch.lrr_act_tab(i).act_info4 := null;
371: pay_emp_action_arch.lrr_act_tab(i).act_info5 := null;
372: pay_emp_action_arch.lrr_act_tab(i).act_info6 := null;
365: pay_emp_action_arch.lrr_act_tab(i).action_info_category := null;
366: pay_emp_action_arch.lrr_act_tab(i).jurisdiction_code := null;
367: pay_emp_action_arch.lrr_act_tab(i).act_info1 := null;
368: pay_emp_action_arch.lrr_act_tab(i).act_info2 := null;
369: pay_emp_action_arch.lrr_act_tab(i).act_info3 := null;
370: pay_emp_action_arch.lrr_act_tab(i).act_info4 := null;
371: pay_emp_action_arch.lrr_act_tab(i).act_info5 := null;
372: pay_emp_action_arch.lrr_act_tab(i).act_info6 := null;
373: pay_emp_action_arch.lrr_act_tab(i).act_info7 := null;
366: pay_emp_action_arch.lrr_act_tab(i).jurisdiction_code := null;
367: pay_emp_action_arch.lrr_act_tab(i).act_info1 := null;
368: pay_emp_action_arch.lrr_act_tab(i).act_info2 := null;
369: pay_emp_action_arch.lrr_act_tab(i).act_info3 := null;
370: pay_emp_action_arch.lrr_act_tab(i).act_info4 := null;
371: pay_emp_action_arch.lrr_act_tab(i).act_info5 := null;
372: pay_emp_action_arch.lrr_act_tab(i).act_info6 := null;
373: pay_emp_action_arch.lrr_act_tab(i).act_info7 := null;
374: pay_emp_action_arch.lrr_act_tab(i).act_info8 := null;
367: pay_emp_action_arch.lrr_act_tab(i).act_info1 := null;
368: pay_emp_action_arch.lrr_act_tab(i).act_info2 := null;
369: pay_emp_action_arch.lrr_act_tab(i).act_info3 := null;
370: pay_emp_action_arch.lrr_act_tab(i).act_info4 := null;
371: pay_emp_action_arch.lrr_act_tab(i).act_info5 := null;
372: pay_emp_action_arch.lrr_act_tab(i).act_info6 := null;
373: pay_emp_action_arch.lrr_act_tab(i).act_info7 := null;
374: pay_emp_action_arch.lrr_act_tab(i).act_info8 := null;
375: pay_emp_action_arch.lrr_act_tab(i).act_info9 := null;
368: pay_emp_action_arch.lrr_act_tab(i).act_info2 := null;
369: pay_emp_action_arch.lrr_act_tab(i).act_info3 := null;
370: pay_emp_action_arch.lrr_act_tab(i).act_info4 := null;
371: pay_emp_action_arch.lrr_act_tab(i).act_info5 := null;
372: pay_emp_action_arch.lrr_act_tab(i).act_info6 := null;
373: pay_emp_action_arch.lrr_act_tab(i).act_info7 := null;
374: pay_emp_action_arch.lrr_act_tab(i).act_info8 := null;
375: pay_emp_action_arch.lrr_act_tab(i).act_info9 := null;
376: pay_emp_action_arch.lrr_act_tab(i).act_info10 := null;
369: pay_emp_action_arch.lrr_act_tab(i).act_info3 := null;
370: pay_emp_action_arch.lrr_act_tab(i).act_info4 := null;
371: pay_emp_action_arch.lrr_act_tab(i).act_info5 := null;
372: pay_emp_action_arch.lrr_act_tab(i).act_info6 := null;
373: pay_emp_action_arch.lrr_act_tab(i).act_info7 := null;
374: pay_emp_action_arch.lrr_act_tab(i).act_info8 := null;
375: pay_emp_action_arch.lrr_act_tab(i).act_info9 := null;
376: pay_emp_action_arch.lrr_act_tab(i).act_info10 := null;
377: pay_emp_action_arch.lrr_act_tab(i).act_info11 := null;
370: pay_emp_action_arch.lrr_act_tab(i).act_info4 := null;
371: pay_emp_action_arch.lrr_act_tab(i).act_info5 := null;
372: pay_emp_action_arch.lrr_act_tab(i).act_info6 := null;
373: pay_emp_action_arch.lrr_act_tab(i).act_info7 := null;
374: pay_emp_action_arch.lrr_act_tab(i).act_info8 := null;
375: pay_emp_action_arch.lrr_act_tab(i).act_info9 := null;
376: pay_emp_action_arch.lrr_act_tab(i).act_info10 := null;
377: pay_emp_action_arch.lrr_act_tab(i).act_info11 := null;
378: pay_emp_action_arch.lrr_act_tab(i).act_info12 := null;
371: pay_emp_action_arch.lrr_act_tab(i).act_info5 := null;
372: pay_emp_action_arch.lrr_act_tab(i).act_info6 := null;
373: pay_emp_action_arch.lrr_act_tab(i).act_info7 := null;
374: pay_emp_action_arch.lrr_act_tab(i).act_info8 := null;
375: pay_emp_action_arch.lrr_act_tab(i).act_info9 := null;
376: pay_emp_action_arch.lrr_act_tab(i).act_info10 := null;
377: pay_emp_action_arch.lrr_act_tab(i).act_info11 := null;
378: pay_emp_action_arch.lrr_act_tab(i).act_info12 := null;
379: pay_emp_action_arch.lrr_act_tab(i).act_info13 := null;
372: pay_emp_action_arch.lrr_act_tab(i).act_info6 := null;
373: pay_emp_action_arch.lrr_act_tab(i).act_info7 := null;
374: pay_emp_action_arch.lrr_act_tab(i).act_info8 := null;
375: pay_emp_action_arch.lrr_act_tab(i).act_info9 := null;
376: pay_emp_action_arch.lrr_act_tab(i).act_info10 := null;
377: pay_emp_action_arch.lrr_act_tab(i).act_info11 := null;
378: pay_emp_action_arch.lrr_act_tab(i).act_info12 := null;
379: pay_emp_action_arch.lrr_act_tab(i).act_info13 := null;
380: pay_emp_action_arch.lrr_act_tab(i).act_info14 := null;
373: pay_emp_action_arch.lrr_act_tab(i).act_info7 := null;
374: pay_emp_action_arch.lrr_act_tab(i).act_info8 := null;
375: pay_emp_action_arch.lrr_act_tab(i).act_info9 := null;
376: pay_emp_action_arch.lrr_act_tab(i).act_info10 := null;
377: pay_emp_action_arch.lrr_act_tab(i).act_info11 := null;
378: pay_emp_action_arch.lrr_act_tab(i).act_info12 := null;
379: pay_emp_action_arch.lrr_act_tab(i).act_info13 := null;
380: pay_emp_action_arch.lrr_act_tab(i).act_info14 := null;
381: pay_emp_action_arch.lrr_act_tab(i).act_info15 := null;
374: pay_emp_action_arch.lrr_act_tab(i).act_info8 := null;
375: pay_emp_action_arch.lrr_act_tab(i).act_info9 := null;
376: pay_emp_action_arch.lrr_act_tab(i).act_info10 := null;
377: pay_emp_action_arch.lrr_act_tab(i).act_info11 := null;
378: pay_emp_action_arch.lrr_act_tab(i).act_info12 := null;
379: pay_emp_action_arch.lrr_act_tab(i).act_info13 := null;
380: pay_emp_action_arch.lrr_act_tab(i).act_info14 := null;
381: pay_emp_action_arch.lrr_act_tab(i).act_info15 := null;
382: pay_emp_action_arch.lrr_act_tab(i).act_info16 := null;
375: pay_emp_action_arch.lrr_act_tab(i).act_info9 := null;
376: pay_emp_action_arch.lrr_act_tab(i).act_info10 := null;
377: pay_emp_action_arch.lrr_act_tab(i).act_info11 := null;
378: pay_emp_action_arch.lrr_act_tab(i).act_info12 := null;
379: pay_emp_action_arch.lrr_act_tab(i).act_info13 := null;
380: pay_emp_action_arch.lrr_act_tab(i).act_info14 := null;
381: pay_emp_action_arch.lrr_act_tab(i).act_info15 := null;
382: pay_emp_action_arch.lrr_act_tab(i).act_info16 := null;
383: pay_emp_action_arch.lrr_act_tab(i).act_info17 := null;
376: pay_emp_action_arch.lrr_act_tab(i).act_info10 := null;
377: pay_emp_action_arch.lrr_act_tab(i).act_info11 := null;
378: pay_emp_action_arch.lrr_act_tab(i).act_info12 := null;
379: pay_emp_action_arch.lrr_act_tab(i).act_info13 := null;
380: pay_emp_action_arch.lrr_act_tab(i).act_info14 := null;
381: pay_emp_action_arch.lrr_act_tab(i).act_info15 := null;
382: pay_emp_action_arch.lrr_act_tab(i).act_info16 := null;
383: pay_emp_action_arch.lrr_act_tab(i).act_info17 := null;
384: pay_emp_action_arch.lrr_act_tab(i).act_info18 := null;
377: pay_emp_action_arch.lrr_act_tab(i).act_info11 := null;
378: pay_emp_action_arch.lrr_act_tab(i).act_info12 := null;
379: pay_emp_action_arch.lrr_act_tab(i).act_info13 := null;
380: pay_emp_action_arch.lrr_act_tab(i).act_info14 := null;
381: pay_emp_action_arch.lrr_act_tab(i).act_info15 := null;
382: pay_emp_action_arch.lrr_act_tab(i).act_info16 := null;
383: pay_emp_action_arch.lrr_act_tab(i).act_info17 := null;
384: pay_emp_action_arch.lrr_act_tab(i).act_info18 := null;
385: pay_emp_action_arch.lrr_act_tab(i).act_info19 := null;
378: pay_emp_action_arch.lrr_act_tab(i).act_info12 := null;
379: pay_emp_action_arch.lrr_act_tab(i).act_info13 := null;
380: pay_emp_action_arch.lrr_act_tab(i).act_info14 := null;
381: pay_emp_action_arch.lrr_act_tab(i).act_info15 := null;
382: pay_emp_action_arch.lrr_act_tab(i).act_info16 := null;
383: pay_emp_action_arch.lrr_act_tab(i).act_info17 := null;
384: pay_emp_action_arch.lrr_act_tab(i).act_info18 := null;
385: pay_emp_action_arch.lrr_act_tab(i).act_info19 := null;
386: pay_emp_action_arch.lrr_act_tab(i).act_info20 := null;
379: pay_emp_action_arch.lrr_act_tab(i).act_info13 := null;
380: pay_emp_action_arch.lrr_act_tab(i).act_info14 := null;
381: pay_emp_action_arch.lrr_act_tab(i).act_info15 := null;
382: pay_emp_action_arch.lrr_act_tab(i).act_info16 := null;
383: pay_emp_action_arch.lrr_act_tab(i).act_info17 := null;
384: pay_emp_action_arch.lrr_act_tab(i).act_info18 := null;
385: pay_emp_action_arch.lrr_act_tab(i).act_info19 := null;
386: pay_emp_action_arch.lrr_act_tab(i).act_info20 := null;
387: pay_emp_action_arch.lrr_act_tab(i).act_info21 := null;
380: pay_emp_action_arch.lrr_act_tab(i).act_info14 := null;
381: pay_emp_action_arch.lrr_act_tab(i).act_info15 := null;
382: pay_emp_action_arch.lrr_act_tab(i).act_info16 := null;
383: pay_emp_action_arch.lrr_act_tab(i).act_info17 := null;
384: pay_emp_action_arch.lrr_act_tab(i).act_info18 := null;
385: pay_emp_action_arch.lrr_act_tab(i).act_info19 := null;
386: pay_emp_action_arch.lrr_act_tab(i).act_info20 := null;
387: pay_emp_action_arch.lrr_act_tab(i).act_info21 := null;
388: pay_emp_action_arch.lrr_act_tab(i).act_info22 := null;
381: pay_emp_action_arch.lrr_act_tab(i).act_info15 := null;
382: pay_emp_action_arch.lrr_act_tab(i).act_info16 := null;
383: pay_emp_action_arch.lrr_act_tab(i).act_info17 := null;
384: pay_emp_action_arch.lrr_act_tab(i).act_info18 := null;
385: pay_emp_action_arch.lrr_act_tab(i).act_info19 := null;
386: pay_emp_action_arch.lrr_act_tab(i).act_info20 := null;
387: pay_emp_action_arch.lrr_act_tab(i).act_info21 := null;
388: pay_emp_action_arch.lrr_act_tab(i).act_info22 := null;
389: pay_emp_action_arch.lrr_act_tab(i).act_info23 := null;
382: pay_emp_action_arch.lrr_act_tab(i).act_info16 := null;
383: pay_emp_action_arch.lrr_act_tab(i).act_info17 := null;
384: pay_emp_action_arch.lrr_act_tab(i).act_info18 := null;
385: pay_emp_action_arch.lrr_act_tab(i).act_info19 := null;
386: pay_emp_action_arch.lrr_act_tab(i).act_info20 := null;
387: pay_emp_action_arch.lrr_act_tab(i).act_info21 := null;
388: pay_emp_action_arch.lrr_act_tab(i).act_info22 := null;
389: pay_emp_action_arch.lrr_act_tab(i).act_info23 := null;
390: pay_emp_action_arch.lrr_act_tab(i).act_info24 := null;
383: pay_emp_action_arch.lrr_act_tab(i).act_info17 := null;
384: pay_emp_action_arch.lrr_act_tab(i).act_info18 := null;
385: pay_emp_action_arch.lrr_act_tab(i).act_info19 := null;
386: pay_emp_action_arch.lrr_act_tab(i).act_info20 := null;
387: pay_emp_action_arch.lrr_act_tab(i).act_info21 := null;
388: pay_emp_action_arch.lrr_act_tab(i).act_info22 := null;
389: pay_emp_action_arch.lrr_act_tab(i).act_info23 := null;
390: pay_emp_action_arch.lrr_act_tab(i).act_info24 := null;
391: pay_emp_action_arch.lrr_act_tab(i).act_info25 := null;
384: pay_emp_action_arch.lrr_act_tab(i).act_info18 := null;
385: pay_emp_action_arch.lrr_act_tab(i).act_info19 := null;
386: pay_emp_action_arch.lrr_act_tab(i).act_info20 := null;
387: pay_emp_action_arch.lrr_act_tab(i).act_info21 := null;
388: pay_emp_action_arch.lrr_act_tab(i).act_info22 := null;
389: pay_emp_action_arch.lrr_act_tab(i).act_info23 := null;
390: pay_emp_action_arch.lrr_act_tab(i).act_info24 := null;
391: pay_emp_action_arch.lrr_act_tab(i).act_info25 := null;
392: pay_emp_action_arch.lrr_act_tab(i).act_info26 := null;
385: pay_emp_action_arch.lrr_act_tab(i).act_info19 := null;
386: pay_emp_action_arch.lrr_act_tab(i).act_info20 := null;
387: pay_emp_action_arch.lrr_act_tab(i).act_info21 := null;
388: pay_emp_action_arch.lrr_act_tab(i).act_info22 := null;
389: pay_emp_action_arch.lrr_act_tab(i).act_info23 := null;
390: pay_emp_action_arch.lrr_act_tab(i).act_info24 := null;
391: pay_emp_action_arch.lrr_act_tab(i).act_info25 := null;
392: pay_emp_action_arch.lrr_act_tab(i).act_info26 := null;
393: pay_emp_action_arch.lrr_act_tab(i).act_info27 := null;
386: pay_emp_action_arch.lrr_act_tab(i).act_info20 := null;
387: pay_emp_action_arch.lrr_act_tab(i).act_info21 := null;
388: pay_emp_action_arch.lrr_act_tab(i).act_info22 := null;
389: pay_emp_action_arch.lrr_act_tab(i).act_info23 := null;
390: pay_emp_action_arch.lrr_act_tab(i).act_info24 := null;
391: pay_emp_action_arch.lrr_act_tab(i).act_info25 := null;
392: pay_emp_action_arch.lrr_act_tab(i).act_info26 := null;
393: pay_emp_action_arch.lrr_act_tab(i).act_info27 := null;
394: pay_emp_action_arch.lrr_act_tab(i).act_info28 := null;
387: pay_emp_action_arch.lrr_act_tab(i).act_info21 := null;
388: pay_emp_action_arch.lrr_act_tab(i).act_info22 := null;
389: pay_emp_action_arch.lrr_act_tab(i).act_info23 := null;
390: pay_emp_action_arch.lrr_act_tab(i).act_info24 := null;
391: pay_emp_action_arch.lrr_act_tab(i).act_info25 := null;
392: pay_emp_action_arch.lrr_act_tab(i).act_info26 := null;
393: pay_emp_action_arch.lrr_act_tab(i).act_info27 := null;
394: pay_emp_action_arch.lrr_act_tab(i).act_info28 := null;
395: pay_emp_action_arch.lrr_act_tab(i).act_info29 := null;
388: pay_emp_action_arch.lrr_act_tab(i).act_info22 := null;
389: pay_emp_action_arch.lrr_act_tab(i).act_info23 := null;
390: pay_emp_action_arch.lrr_act_tab(i).act_info24 := null;
391: pay_emp_action_arch.lrr_act_tab(i).act_info25 := null;
392: pay_emp_action_arch.lrr_act_tab(i).act_info26 := null;
393: pay_emp_action_arch.lrr_act_tab(i).act_info27 := null;
394: pay_emp_action_arch.lrr_act_tab(i).act_info28 := null;
395: pay_emp_action_arch.lrr_act_tab(i).act_info29 := null;
396: pay_emp_action_arch.lrr_act_tab(i).act_info30 := null;
389: pay_emp_action_arch.lrr_act_tab(i).act_info23 := null;
390: pay_emp_action_arch.lrr_act_tab(i).act_info24 := null;
391: pay_emp_action_arch.lrr_act_tab(i).act_info25 := null;
392: pay_emp_action_arch.lrr_act_tab(i).act_info26 := null;
393: pay_emp_action_arch.lrr_act_tab(i).act_info27 := null;
394: pay_emp_action_arch.lrr_act_tab(i).act_info28 := null;
395: pay_emp_action_arch.lrr_act_tab(i).act_info29 := null;
396: pay_emp_action_arch.lrr_act_tab(i).act_info30 := null;
397: end loop;
390: pay_emp_action_arch.lrr_act_tab(i).act_info24 := null;
391: pay_emp_action_arch.lrr_act_tab(i).act_info25 := null;
392: pay_emp_action_arch.lrr_act_tab(i).act_info26 := null;
393: pay_emp_action_arch.lrr_act_tab(i).act_info27 := null;
394: pay_emp_action_arch.lrr_act_tab(i).act_info28 := null;
395: pay_emp_action_arch.lrr_act_tab(i).act_info29 := null;
396: pay_emp_action_arch.lrr_act_tab(i).act_info30 := null;
397: end loop;
398: end if;
391: pay_emp_action_arch.lrr_act_tab(i).act_info25 := null;
392: pay_emp_action_arch.lrr_act_tab(i).act_info26 := null;
393: pay_emp_action_arch.lrr_act_tab(i).act_info27 := null;
394: pay_emp_action_arch.lrr_act_tab(i).act_info28 := null;
395: pay_emp_action_arch.lrr_act_tab(i).act_info29 := null;
396: pay_emp_action_arch.lrr_act_tab(i).act_info30 := null;
397: end loop;
398: end if;
399: pay_emp_action_arch.lrr_act_tab.delete;
392: pay_emp_action_arch.lrr_act_tab(i).act_info26 := null;
393: pay_emp_action_arch.lrr_act_tab(i).act_info27 := null;
394: pay_emp_action_arch.lrr_act_tab(i).act_info28 := null;
395: pay_emp_action_arch.lrr_act_tab(i).act_info29 := null;
396: pay_emp_action_arch.lrr_act_tab(i).act_info30 := null;
397: end loop;
398: end if;
399: pay_emp_action_arch.lrr_act_tab.delete;
400: pay_us_emp_payslip_accrual_web.ltr_assignment_accruals.delete;
395: pay_emp_action_arch.lrr_act_tab(i).act_info29 := null;
396: pay_emp_action_arch.lrr_act_tab(i).act_info30 := null;
397: end loop;
398: end if;
399: pay_emp_action_arch.lrr_act_tab.delete;
400: pay_us_emp_payslip_accrual_web.ltr_assignment_accruals.delete;
401: hr_utility.set_location(gv_package || lv_procedure_name, 30);
402:
403: if pay_emp_action_arch.ltr_ppa_arch.count > 0 then
399: pay_emp_action_arch.lrr_act_tab.delete;
400: pay_us_emp_payslip_accrual_web.ltr_assignment_accruals.delete;
401: hr_utility.set_location(gv_package || lv_procedure_name, 30);
402:
403: if pay_emp_action_arch.ltr_ppa_arch.count > 0 then
404: hr_utility.set_location(gv_package || lv_procedure_name, 40);
405: for i in pay_emp_action_arch.ltr_ppa_arch.first ..
406: pay_emp_action_arch.ltr_ppa_arch.last loop
407: pay_emp_action_arch.ltr_ppa_arch(i).action_context_id := null;
401: hr_utility.set_location(gv_package || lv_procedure_name, 30);
402:
403: if pay_emp_action_arch.ltr_ppa_arch.count > 0 then
404: hr_utility.set_location(gv_package || lv_procedure_name, 40);
405: for i in pay_emp_action_arch.ltr_ppa_arch.first ..
406: pay_emp_action_arch.ltr_ppa_arch.last loop
407: pay_emp_action_arch.ltr_ppa_arch(i).action_context_id := null;
408: pay_emp_action_arch.ltr_ppa_arch(i).action_context_type := null;
409: pay_emp_action_arch.ltr_ppa_arch(i).action_info_category := null;
402:
403: if pay_emp_action_arch.ltr_ppa_arch.count > 0 then
404: hr_utility.set_location(gv_package || lv_procedure_name, 40);
405: for i in pay_emp_action_arch.ltr_ppa_arch.first ..
406: pay_emp_action_arch.ltr_ppa_arch.last loop
407: pay_emp_action_arch.ltr_ppa_arch(i).action_context_id := null;
408: pay_emp_action_arch.ltr_ppa_arch(i).action_context_type := null;
409: pay_emp_action_arch.ltr_ppa_arch(i).action_info_category := null;
410: pay_emp_action_arch.ltr_ppa_arch(i).jurisdiction_code := null;
403: if pay_emp_action_arch.ltr_ppa_arch.count > 0 then
404: hr_utility.set_location(gv_package || lv_procedure_name, 40);
405: for i in pay_emp_action_arch.ltr_ppa_arch.first ..
406: pay_emp_action_arch.ltr_ppa_arch.last loop
407: pay_emp_action_arch.ltr_ppa_arch(i).action_context_id := null;
408: pay_emp_action_arch.ltr_ppa_arch(i).action_context_type := null;
409: pay_emp_action_arch.ltr_ppa_arch(i).action_info_category := null;
410: pay_emp_action_arch.ltr_ppa_arch(i).jurisdiction_code := null;
411: pay_emp_action_arch.ltr_ppa_arch(i).act_info1 := null;
404: hr_utility.set_location(gv_package || lv_procedure_name, 40);
405: for i in pay_emp_action_arch.ltr_ppa_arch.first ..
406: pay_emp_action_arch.ltr_ppa_arch.last loop
407: pay_emp_action_arch.ltr_ppa_arch(i).action_context_id := null;
408: pay_emp_action_arch.ltr_ppa_arch(i).action_context_type := null;
409: pay_emp_action_arch.ltr_ppa_arch(i).action_info_category := null;
410: pay_emp_action_arch.ltr_ppa_arch(i).jurisdiction_code := null;
411: pay_emp_action_arch.ltr_ppa_arch(i).act_info1 := null;
412: pay_emp_action_arch.ltr_ppa_arch(i).act_info2 := null;
405: for i in pay_emp_action_arch.ltr_ppa_arch.first ..
406: pay_emp_action_arch.ltr_ppa_arch.last loop
407: pay_emp_action_arch.ltr_ppa_arch(i).action_context_id := null;
408: pay_emp_action_arch.ltr_ppa_arch(i).action_context_type := null;
409: pay_emp_action_arch.ltr_ppa_arch(i).action_info_category := null;
410: pay_emp_action_arch.ltr_ppa_arch(i).jurisdiction_code := null;
411: pay_emp_action_arch.ltr_ppa_arch(i).act_info1 := null;
412: pay_emp_action_arch.ltr_ppa_arch(i).act_info2 := null;
413: pay_emp_action_arch.ltr_ppa_arch(i).act_info3 := null;
406: pay_emp_action_arch.ltr_ppa_arch.last loop
407: pay_emp_action_arch.ltr_ppa_arch(i).action_context_id := null;
408: pay_emp_action_arch.ltr_ppa_arch(i).action_context_type := null;
409: pay_emp_action_arch.ltr_ppa_arch(i).action_info_category := null;
410: pay_emp_action_arch.ltr_ppa_arch(i).jurisdiction_code := null;
411: pay_emp_action_arch.ltr_ppa_arch(i).act_info1 := null;
412: pay_emp_action_arch.ltr_ppa_arch(i).act_info2 := null;
413: pay_emp_action_arch.ltr_ppa_arch(i).act_info3 := null;
414: pay_emp_action_arch.ltr_ppa_arch(i).act_info4 := null;
407: pay_emp_action_arch.ltr_ppa_arch(i).action_context_id := null;
408: pay_emp_action_arch.ltr_ppa_arch(i).action_context_type := null;
409: pay_emp_action_arch.ltr_ppa_arch(i).action_info_category := null;
410: pay_emp_action_arch.ltr_ppa_arch(i).jurisdiction_code := null;
411: pay_emp_action_arch.ltr_ppa_arch(i).act_info1 := null;
412: pay_emp_action_arch.ltr_ppa_arch(i).act_info2 := null;
413: pay_emp_action_arch.ltr_ppa_arch(i).act_info3 := null;
414: pay_emp_action_arch.ltr_ppa_arch(i).act_info4 := null;
415: pay_emp_action_arch.ltr_ppa_arch(i).act_info5 := null;
408: pay_emp_action_arch.ltr_ppa_arch(i).action_context_type := null;
409: pay_emp_action_arch.ltr_ppa_arch(i).action_info_category := null;
410: pay_emp_action_arch.ltr_ppa_arch(i).jurisdiction_code := null;
411: pay_emp_action_arch.ltr_ppa_arch(i).act_info1 := null;
412: pay_emp_action_arch.ltr_ppa_arch(i).act_info2 := null;
413: pay_emp_action_arch.ltr_ppa_arch(i).act_info3 := null;
414: pay_emp_action_arch.ltr_ppa_arch(i).act_info4 := null;
415: pay_emp_action_arch.ltr_ppa_arch(i).act_info5 := null;
416: pay_emp_action_arch.ltr_ppa_arch(i).act_info6 := null;
409: pay_emp_action_arch.ltr_ppa_arch(i).action_info_category := null;
410: pay_emp_action_arch.ltr_ppa_arch(i).jurisdiction_code := null;
411: pay_emp_action_arch.ltr_ppa_arch(i).act_info1 := null;
412: pay_emp_action_arch.ltr_ppa_arch(i).act_info2 := null;
413: pay_emp_action_arch.ltr_ppa_arch(i).act_info3 := null;
414: pay_emp_action_arch.ltr_ppa_arch(i).act_info4 := null;
415: pay_emp_action_arch.ltr_ppa_arch(i).act_info5 := null;
416: pay_emp_action_arch.ltr_ppa_arch(i).act_info6 := null;
417: pay_emp_action_arch.ltr_ppa_arch(i).act_info7 := null;
410: pay_emp_action_arch.ltr_ppa_arch(i).jurisdiction_code := null;
411: pay_emp_action_arch.ltr_ppa_arch(i).act_info1 := null;
412: pay_emp_action_arch.ltr_ppa_arch(i).act_info2 := null;
413: pay_emp_action_arch.ltr_ppa_arch(i).act_info3 := null;
414: pay_emp_action_arch.ltr_ppa_arch(i).act_info4 := null;
415: pay_emp_action_arch.ltr_ppa_arch(i).act_info5 := null;
416: pay_emp_action_arch.ltr_ppa_arch(i).act_info6 := null;
417: pay_emp_action_arch.ltr_ppa_arch(i).act_info7 := null;
418: pay_emp_action_arch.ltr_ppa_arch(i).act_info8 := null;
411: pay_emp_action_arch.ltr_ppa_arch(i).act_info1 := null;
412: pay_emp_action_arch.ltr_ppa_arch(i).act_info2 := null;
413: pay_emp_action_arch.ltr_ppa_arch(i).act_info3 := null;
414: pay_emp_action_arch.ltr_ppa_arch(i).act_info4 := null;
415: pay_emp_action_arch.ltr_ppa_arch(i).act_info5 := null;
416: pay_emp_action_arch.ltr_ppa_arch(i).act_info6 := null;
417: pay_emp_action_arch.ltr_ppa_arch(i).act_info7 := null;
418: pay_emp_action_arch.ltr_ppa_arch(i).act_info8 := null;
419: pay_emp_action_arch.ltr_ppa_arch(i).act_info9 := null;
412: pay_emp_action_arch.ltr_ppa_arch(i).act_info2 := null;
413: pay_emp_action_arch.ltr_ppa_arch(i).act_info3 := null;
414: pay_emp_action_arch.ltr_ppa_arch(i).act_info4 := null;
415: pay_emp_action_arch.ltr_ppa_arch(i).act_info5 := null;
416: pay_emp_action_arch.ltr_ppa_arch(i).act_info6 := null;
417: pay_emp_action_arch.ltr_ppa_arch(i).act_info7 := null;
418: pay_emp_action_arch.ltr_ppa_arch(i).act_info8 := null;
419: pay_emp_action_arch.ltr_ppa_arch(i).act_info9 := null;
420: pay_emp_action_arch.ltr_ppa_arch(i).act_info10 := null;
413: pay_emp_action_arch.ltr_ppa_arch(i).act_info3 := null;
414: pay_emp_action_arch.ltr_ppa_arch(i).act_info4 := null;
415: pay_emp_action_arch.ltr_ppa_arch(i).act_info5 := null;
416: pay_emp_action_arch.ltr_ppa_arch(i).act_info6 := null;
417: pay_emp_action_arch.ltr_ppa_arch(i).act_info7 := null;
418: pay_emp_action_arch.ltr_ppa_arch(i).act_info8 := null;
419: pay_emp_action_arch.ltr_ppa_arch(i).act_info9 := null;
420: pay_emp_action_arch.ltr_ppa_arch(i).act_info10 := null;
421: pay_emp_action_arch.ltr_ppa_arch(i).act_info11 := null;
414: pay_emp_action_arch.ltr_ppa_arch(i).act_info4 := null;
415: pay_emp_action_arch.ltr_ppa_arch(i).act_info5 := null;
416: pay_emp_action_arch.ltr_ppa_arch(i).act_info6 := null;
417: pay_emp_action_arch.ltr_ppa_arch(i).act_info7 := null;
418: pay_emp_action_arch.ltr_ppa_arch(i).act_info8 := null;
419: pay_emp_action_arch.ltr_ppa_arch(i).act_info9 := null;
420: pay_emp_action_arch.ltr_ppa_arch(i).act_info10 := null;
421: pay_emp_action_arch.ltr_ppa_arch(i).act_info11 := null;
422: pay_emp_action_arch.ltr_ppa_arch(i).act_info12 := null;
415: pay_emp_action_arch.ltr_ppa_arch(i).act_info5 := null;
416: pay_emp_action_arch.ltr_ppa_arch(i).act_info6 := null;
417: pay_emp_action_arch.ltr_ppa_arch(i).act_info7 := null;
418: pay_emp_action_arch.ltr_ppa_arch(i).act_info8 := null;
419: pay_emp_action_arch.ltr_ppa_arch(i).act_info9 := null;
420: pay_emp_action_arch.ltr_ppa_arch(i).act_info10 := null;
421: pay_emp_action_arch.ltr_ppa_arch(i).act_info11 := null;
422: pay_emp_action_arch.ltr_ppa_arch(i).act_info12 := null;
423: pay_emp_action_arch.ltr_ppa_arch(i).act_info13 := null;
416: pay_emp_action_arch.ltr_ppa_arch(i).act_info6 := null;
417: pay_emp_action_arch.ltr_ppa_arch(i).act_info7 := null;
418: pay_emp_action_arch.ltr_ppa_arch(i).act_info8 := null;
419: pay_emp_action_arch.ltr_ppa_arch(i).act_info9 := null;
420: pay_emp_action_arch.ltr_ppa_arch(i).act_info10 := null;
421: pay_emp_action_arch.ltr_ppa_arch(i).act_info11 := null;
422: pay_emp_action_arch.ltr_ppa_arch(i).act_info12 := null;
423: pay_emp_action_arch.ltr_ppa_arch(i).act_info13 := null;
424: pay_emp_action_arch.ltr_ppa_arch(i).act_info14 := null;
417: pay_emp_action_arch.ltr_ppa_arch(i).act_info7 := null;
418: pay_emp_action_arch.ltr_ppa_arch(i).act_info8 := null;
419: pay_emp_action_arch.ltr_ppa_arch(i).act_info9 := null;
420: pay_emp_action_arch.ltr_ppa_arch(i).act_info10 := null;
421: pay_emp_action_arch.ltr_ppa_arch(i).act_info11 := null;
422: pay_emp_action_arch.ltr_ppa_arch(i).act_info12 := null;
423: pay_emp_action_arch.ltr_ppa_arch(i).act_info13 := null;
424: pay_emp_action_arch.ltr_ppa_arch(i).act_info14 := null;
425: pay_emp_action_arch.ltr_ppa_arch(i).act_info15 := null;
418: pay_emp_action_arch.ltr_ppa_arch(i).act_info8 := null;
419: pay_emp_action_arch.ltr_ppa_arch(i).act_info9 := null;
420: pay_emp_action_arch.ltr_ppa_arch(i).act_info10 := null;
421: pay_emp_action_arch.ltr_ppa_arch(i).act_info11 := null;
422: pay_emp_action_arch.ltr_ppa_arch(i).act_info12 := null;
423: pay_emp_action_arch.ltr_ppa_arch(i).act_info13 := null;
424: pay_emp_action_arch.ltr_ppa_arch(i).act_info14 := null;
425: pay_emp_action_arch.ltr_ppa_arch(i).act_info15 := null;
426: pay_emp_action_arch.ltr_ppa_arch(i).act_info16 := null;
419: pay_emp_action_arch.ltr_ppa_arch(i).act_info9 := null;
420: pay_emp_action_arch.ltr_ppa_arch(i).act_info10 := null;
421: pay_emp_action_arch.ltr_ppa_arch(i).act_info11 := null;
422: pay_emp_action_arch.ltr_ppa_arch(i).act_info12 := null;
423: pay_emp_action_arch.ltr_ppa_arch(i).act_info13 := null;
424: pay_emp_action_arch.ltr_ppa_arch(i).act_info14 := null;
425: pay_emp_action_arch.ltr_ppa_arch(i).act_info15 := null;
426: pay_emp_action_arch.ltr_ppa_arch(i).act_info16 := null;
427: pay_emp_action_arch.ltr_ppa_arch(i).act_info17 := null;
420: pay_emp_action_arch.ltr_ppa_arch(i).act_info10 := null;
421: pay_emp_action_arch.ltr_ppa_arch(i).act_info11 := null;
422: pay_emp_action_arch.ltr_ppa_arch(i).act_info12 := null;
423: pay_emp_action_arch.ltr_ppa_arch(i).act_info13 := null;
424: pay_emp_action_arch.ltr_ppa_arch(i).act_info14 := null;
425: pay_emp_action_arch.ltr_ppa_arch(i).act_info15 := null;
426: pay_emp_action_arch.ltr_ppa_arch(i).act_info16 := null;
427: pay_emp_action_arch.ltr_ppa_arch(i).act_info17 := null;
428: pay_emp_action_arch.ltr_ppa_arch(i).act_info18 := null;
421: pay_emp_action_arch.ltr_ppa_arch(i).act_info11 := null;
422: pay_emp_action_arch.ltr_ppa_arch(i).act_info12 := null;
423: pay_emp_action_arch.ltr_ppa_arch(i).act_info13 := null;
424: pay_emp_action_arch.ltr_ppa_arch(i).act_info14 := null;
425: pay_emp_action_arch.ltr_ppa_arch(i).act_info15 := null;
426: pay_emp_action_arch.ltr_ppa_arch(i).act_info16 := null;
427: pay_emp_action_arch.ltr_ppa_arch(i).act_info17 := null;
428: pay_emp_action_arch.ltr_ppa_arch(i).act_info18 := null;
429: pay_emp_action_arch.ltr_ppa_arch(i).act_info19 := null;
422: pay_emp_action_arch.ltr_ppa_arch(i).act_info12 := null;
423: pay_emp_action_arch.ltr_ppa_arch(i).act_info13 := null;
424: pay_emp_action_arch.ltr_ppa_arch(i).act_info14 := null;
425: pay_emp_action_arch.ltr_ppa_arch(i).act_info15 := null;
426: pay_emp_action_arch.ltr_ppa_arch(i).act_info16 := null;
427: pay_emp_action_arch.ltr_ppa_arch(i).act_info17 := null;
428: pay_emp_action_arch.ltr_ppa_arch(i).act_info18 := null;
429: pay_emp_action_arch.ltr_ppa_arch(i).act_info19 := null;
430: pay_emp_action_arch.ltr_ppa_arch(i).act_info20 := null;
423: pay_emp_action_arch.ltr_ppa_arch(i).act_info13 := null;
424: pay_emp_action_arch.ltr_ppa_arch(i).act_info14 := null;
425: pay_emp_action_arch.ltr_ppa_arch(i).act_info15 := null;
426: pay_emp_action_arch.ltr_ppa_arch(i).act_info16 := null;
427: pay_emp_action_arch.ltr_ppa_arch(i).act_info17 := null;
428: pay_emp_action_arch.ltr_ppa_arch(i).act_info18 := null;
429: pay_emp_action_arch.ltr_ppa_arch(i).act_info19 := null;
430: pay_emp_action_arch.ltr_ppa_arch(i).act_info20 := null;
431: pay_emp_action_arch.ltr_ppa_arch(i).act_info21 := null;
424: pay_emp_action_arch.ltr_ppa_arch(i).act_info14 := null;
425: pay_emp_action_arch.ltr_ppa_arch(i).act_info15 := null;
426: pay_emp_action_arch.ltr_ppa_arch(i).act_info16 := null;
427: pay_emp_action_arch.ltr_ppa_arch(i).act_info17 := null;
428: pay_emp_action_arch.ltr_ppa_arch(i).act_info18 := null;
429: pay_emp_action_arch.ltr_ppa_arch(i).act_info19 := null;
430: pay_emp_action_arch.ltr_ppa_arch(i).act_info20 := null;
431: pay_emp_action_arch.ltr_ppa_arch(i).act_info21 := null;
432: pay_emp_action_arch.ltr_ppa_arch(i).act_info22 := null;
425: pay_emp_action_arch.ltr_ppa_arch(i).act_info15 := null;
426: pay_emp_action_arch.ltr_ppa_arch(i).act_info16 := null;
427: pay_emp_action_arch.ltr_ppa_arch(i).act_info17 := null;
428: pay_emp_action_arch.ltr_ppa_arch(i).act_info18 := null;
429: pay_emp_action_arch.ltr_ppa_arch(i).act_info19 := null;
430: pay_emp_action_arch.ltr_ppa_arch(i).act_info20 := null;
431: pay_emp_action_arch.ltr_ppa_arch(i).act_info21 := null;
432: pay_emp_action_arch.ltr_ppa_arch(i).act_info22 := null;
433: pay_emp_action_arch.ltr_ppa_arch(i).act_info23 := null;
426: pay_emp_action_arch.ltr_ppa_arch(i).act_info16 := null;
427: pay_emp_action_arch.ltr_ppa_arch(i).act_info17 := null;
428: pay_emp_action_arch.ltr_ppa_arch(i).act_info18 := null;
429: pay_emp_action_arch.ltr_ppa_arch(i).act_info19 := null;
430: pay_emp_action_arch.ltr_ppa_arch(i).act_info20 := null;
431: pay_emp_action_arch.ltr_ppa_arch(i).act_info21 := null;
432: pay_emp_action_arch.ltr_ppa_arch(i).act_info22 := null;
433: pay_emp_action_arch.ltr_ppa_arch(i).act_info23 := null;
434: pay_emp_action_arch.ltr_ppa_arch(i).act_info24 := null;
427: pay_emp_action_arch.ltr_ppa_arch(i).act_info17 := null;
428: pay_emp_action_arch.ltr_ppa_arch(i).act_info18 := null;
429: pay_emp_action_arch.ltr_ppa_arch(i).act_info19 := null;
430: pay_emp_action_arch.ltr_ppa_arch(i).act_info20 := null;
431: pay_emp_action_arch.ltr_ppa_arch(i).act_info21 := null;
432: pay_emp_action_arch.ltr_ppa_arch(i).act_info22 := null;
433: pay_emp_action_arch.ltr_ppa_arch(i).act_info23 := null;
434: pay_emp_action_arch.ltr_ppa_arch(i).act_info24 := null;
435: pay_emp_action_arch.ltr_ppa_arch(i).act_info25 := null;
428: pay_emp_action_arch.ltr_ppa_arch(i).act_info18 := null;
429: pay_emp_action_arch.ltr_ppa_arch(i).act_info19 := null;
430: pay_emp_action_arch.ltr_ppa_arch(i).act_info20 := null;
431: pay_emp_action_arch.ltr_ppa_arch(i).act_info21 := null;
432: pay_emp_action_arch.ltr_ppa_arch(i).act_info22 := null;
433: pay_emp_action_arch.ltr_ppa_arch(i).act_info23 := null;
434: pay_emp_action_arch.ltr_ppa_arch(i).act_info24 := null;
435: pay_emp_action_arch.ltr_ppa_arch(i).act_info25 := null;
436: pay_emp_action_arch.ltr_ppa_arch(i).act_info26 := null;
429: pay_emp_action_arch.ltr_ppa_arch(i).act_info19 := null;
430: pay_emp_action_arch.ltr_ppa_arch(i).act_info20 := null;
431: pay_emp_action_arch.ltr_ppa_arch(i).act_info21 := null;
432: pay_emp_action_arch.ltr_ppa_arch(i).act_info22 := null;
433: pay_emp_action_arch.ltr_ppa_arch(i).act_info23 := null;
434: pay_emp_action_arch.ltr_ppa_arch(i).act_info24 := null;
435: pay_emp_action_arch.ltr_ppa_arch(i).act_info25 := null;
436: pay_emp_action_arch.ltr_ppa_arch(i).act_info26 := null;
437: pay_emp_action_arch.ltr_ppa_arch(i).act_info27 := null;
430: pay_emp_action_arch.ltr_ppa_arch(i).act_info20 := null;
431: pay_emp_action_arch.ltr_ppa_arch(i).act_info21 := null;
432: pay_emp_action_arch.ltr_ppa_arch(i).act_info22 := null;
433: pay_emp_action_arch.ltr_ppa_arch(i).act_info23 := null;
434: pay_emp_action_arch.ltr_ppa_arch(i).act_info24 := null;
435: pay_emp_action_arch.ltr_ppa_arch(i).act_info25 := null;
436: pay_emp_action_arch.ltr_ppa_arch(i).act_info26 := null;
437: pay_emp_action_arch.ltr_ppa_arch(i).act_info27 := null;
438: pay_emp_action_arch.ltr_ppa_arch(i).act_info28 := null;
431: pay_emp_action_arch.ltr_ppa_arch(i).act_info21 := null;
432: pay_emp_action_arch.ltr_ppa_arch(i).act_info22 := null;
433: pay_emp_action_arch.ltr_ppa_arch(i).act_info23 := null;
434: pay_emp_action_arch.ltr_ppa_arch(i).act_info24 := null;
435: pay_emp_action_arch.ltr_ppa_arch(i).act_info25 := null;
436: pay_emp_action_arch.ltr_ppa_arch(i).act_info26 := null;
437: pay_emp_action_arch.ltr_ppa_arch(i).act_info27 := null;
438: pay_emp_action_arch.ltr_ppa_arch(i).act_info28 := null;
439: pay_emp_action_arch.ltr_ppa_arch(i).act_info29 := null;
432: pay_emp_action_arch.ltr_ppa_arch(i).act_info22 := null;
433: pay_emp_action_arch.ltr_ppa_arch(i).act_info23 := null;
434: pay_emp_action_arch.ltr_ppa_arch(i).act_info24 := null;
435: pay_emp_action_arch.ltr_ppa_arch(i).act_info25 := null;
436: pay_emp_action_arch.ltr_ppa_arch(i).act_info26 := null;
437: pay_emp_action_arch.ltr_ppa_arch(i).act_info27 := null;
438: pay_emp_action_arch.ltr_ppa_arch(i).act_info28 := null;
439: pay_emp_action_arch.ltr_ppa_arch(i).act_info29 := null;
440: pay_emp_action_arch.ltr_ppa_arch(i).act_info30 := null;
433: pay_emp_action_arch.ltr_ppa_arch(i).act_info23 := null;
434: pay_emp_action_arch.ltr_ppa_arch(i).act_info24 := null;
435: pay_emp_action_arch.ltr_ppa_arch(i).act_info25 := null;
436: pay_emp_action_arch.ltr_ppa_arch(i).act_info26 := null;
437: pay_emp_action_arch.ltr_ppa_arch(i).act_info27 := null;
438: pay_emp_action_arch.ltr_ppa_arch(i).act_info28 := null;
439: pay_emp_action_arch.ltr_ppa_arch(i).act_info29 := null;
440: pay_emp_action_arch.ltr_ppa_arch(i).act_info30 := null;
441: end loop;
434: pay_emp_action_arch.ltr_ppa_arch(i).act_info24 := null;
435: pay_emp_action_arch.ltr_ppa_arch(i).act_info25 := null;
436: pay_emp_action_arch.ltr_ppa_arch(i).act_info26 := null;
437: pay_emp_action_arch.ltr_ppa_arch(i).act_info27 := null;
438: pay_emp_action_arch.ltr_ppa_arch(i).act_info28 := null;
439: pay_emp_action_arch.ltr_ppa_arch(i).act_info29 := null;
440: pay_emp_action_arch.ltr_ppa_arch(i).act_info30 := null;
441: end loop;
442: end if;
435: pay_emp_action_arch.ltr_ppa_arch(i).act_info25 := null;
436: pay_emp_action_arch.ltr_ppa_arch(i).act_info26 := null;
437: pay_emp_action_arch.ltr_ppa_arch(i).act_info27 := null;
438: pay_emp_action_arch.ltr_ppa_arch(i).act_info28 := null;
439: pay_emp_action_arch.ltr_ppa_arch(i).act_info29 := null;
440: pay_emp_action_arch.ltr_ppa_arch(i).act_info30 := null;
441: end loop;
442: end if;
443: pay_emp_action_arch.ltr_ppa_arch.delete;
436: pay_emp_action_arch.ltr_ppa_arch(i).act_info26 := null;
437: pay_emp_action_arch.ltr_ppa_arch(i).act_info27 := null;
438: pay_emp_action_arch.ltr_ppa_arch(i).act_info28 := null;
439: pay_emp_action_arch.ltr_ppa_arch(i).act_info29 := null;
440: pay_emp_action_arch.ltr_ppa_arch(i).act_info30 := null;
441: end loop;
442: end if;
443: pay_emp_action_arch.ltr_ppa_arch.delete;
444:
439: pay_emp_action_arch.ltr_ppa_arch(i).act_info29 := null;
440: pay_emp_action_arch.ltr_ppa_arch(i).act_info30 := null;
441: end loop;
442: end if;
443: pay_emp_action_arch.ltr_ppa_arch.delete;
444:
445: hr_utility.set_location(gv_package || lv_procedure_name, 50);
446: END initialization_process;
447:
458: ,p_action_context_type in varchar2
459: ,p_assignment_id in number
460: ,p_tax_unit_id in number
461: ,p_curr_pymt_eff_date in date
462: ,p_tab_rec_data in pay_emp_action_arch.action_info_table
463: )
464:
465: IS
466: l_action_information_id_1 NUMBER ;
884: hr_utility.trace('lv_value ' || lv_value);
885: hr_utility.trace('lv_name ' || lv_info_type);
886: hr_utility.trace('lv_value_type ' || lv_value_type);
887:
888: ln_index := pay_emp_action_arch.lrr_act_tab.count;
889:
890: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category
891: := 'EMPLOYEE OTHER INFORMATION';
892: pay_emp_action_arch.lrr_act_tab(ln_index).jurisdiction_code
886: hr_utility.trace('lv_value_type ' || lv_value_type);
887:
888: ln_index := pay_emp_action_arch.lrr_act_tab.count;
889:
890: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category
891: := 'EMPLOYEE OTHER INFORMATION';
892: pay_emp_action_arch.lrr_act_tab(ln_index).jurisdiction_code
893: := '00-000-0000';
894: pay_emp_action_arch.lrr_act_tab(ln_index).act_info1
888: ln_index := pay_emp_action_arch.lrr_act_tab.count;
889:
890: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category
891: := 'EMPLOYEE OTHER INFORMATION';
892: pay_emp_action_arch.lrr_act_tab(ln_index).jurisdiction_code
893: := '00-000-0000';
894: pay_emp_action_arch.lrr_act_tab(ln_index).act_info1
895: := p_organization_id;
896: pay_emp_action_arch.lrr_act_tab(ln_index).act_info2
890: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category
891: := 'EMPLOYEE OTHER INFORMATION';
892: pay_emp_action_arch.lrr_act_tab(ln_index).jurisdiction_code
893: := '00-000-0000';
894: pay_emp_action_arch.lrr_act_tab(ln_index).act_info1
895: := p_organization_id;
896: pay_emp_action_arch.lrr_act_tab(ln_index).act_info2
897: := lv_info_type;
898: pay_emp_action_arch.lrr_act_tab(ln_index).act_info4
892: pay_emp_action_arch.lrr_act_tab(ln_index).jurisdiction_code
893: := '00-000-0000';
894: pay_emp_action_arch.lrr_act_tab(ln_index).act_info1
895: := p_organization_id;
896: pay_emp_action_arch.lrr_act_tab(ln_index).act_info2
897: := lv_info_type;
898: pay_emp_action_arch.lrr_act_tab(ln_index).act_info4
899: := nvl(lv_display_name,lv_name) ;
900: pay_emp_action_arch.lrr_act_tab(ln_index).act_info5
894: pay_emp_action_arch.lrr_act_tab(ln_index).act_info1
895: := p_organization_id;
896: pay_emp_action_arch.lrr_act_tab(ln_index).act_info2
897: := lv_info_type;
898: pay_emp_action_arch.lrr_act_tab(ln_index).act_info4
899: := nvl(lv_display_name,lv_name) ;
900: pay_emp_action_arch.lrr_act_tab(ln_index).act_info5
901: := lv_value_type ;
902: pay_emp_action_arch.lrr_act_tab(ln_index).act_info6
896: pay_emp_action_arch.lrr_act_tab(ln_index).act_info2
897: := lv_info_type;
898: pay_emp_action_arch.lrr_act_tab(ln_index).act_info4
899: := nvl(lv_display_name,lv_name) ;
900: pay_emp_action_arch.lrr_act_tab(ln_index).act_info5
901: := lv_value_type ;
902: pay_emp_action_arch.lrr_act_tab(ln_index).act_info6
903: := lv_value;
904: pay_emp_action_arch.lrr_act_tab(ln_index).act_info7
898: pay_emp_action_arch.lrr_act_tab(ln_index).act_info4
899: := nvl(lv_display_name,lv_name) ;
900: pay_emp_action_arch.lrr_act_tab(ln_index).act_info5
901: := lv_value_type ;
902: pay_emp_action_arch.lrr_act_tab(ln_index).act_info6
903: := lv_value;
904: pay_emp_action_arch.lrr_act_tab(ln_index).act_info7
905: := ln_element_type_id;
906: pay_emp_action_arch.lrr_act_tab(ln_index).act_info8
900: pay_emp_action_arch.lrr_act_tab(ln_index).act_info5
901: := lv_value_type ;
902: pay_emp_action_arch.lrr_act_tab(ln_index).act_info6
903: := lv_value;
904: pay_emp_action_arch.lrr_act_tab(ln_index).act_info7
905: := ln_element_type_id;
906: pay_emp_action_arch.lrr_act_tab(ln_index).act_info8
907: := ln_input_value_id;
908: -- Bug 5707497
902: pay_emp_action_arch.lrr_act_tab(ln_index).act_info6
903: := lv_value;
904: pay_emp_action_arch.lrr_act_tab(ln_index).act_info7
905: := ln_element_type_id;
906: pay_emp_action_arch.lrr_act_tab(ln_index).act_info8
907: := ln_input_value_id;
908: -- Bug 5707497
909: pay_emp_action_arch.lrr_act_tab(ln_index).act_info11
910: := lv_uom;
905: := ln_element_type_id;
906: pay_emp_action_arch.lrr_act_tab(ln_index).act_info8
907: := ln_input_value_id;
908: -- Bug 5707497
909: pay_emp_action_arch.lrr_act_tab(ln_index).act_info11
910: := lv_uom;
911: end if;
912: close c_element_details;
913:
943: lv_value := nvl(pay_balance_pkg.get_value(ln_defined_balance_id,
944: ln_run_action_id),0);
945: if lv_value <> 0 then
946: hr_utility.set_location(gv_package || lv_procedure_name, 110);
947: ln_index := pay_emp_action_arch.lrr_act_tab.count;
948:
949: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category
950: := 'EMPLOYEE OTHER INFORMATION';
951: pay_emp_action_arch.lrr_act_tab(ln_index).jurisdiction_code
945: if lv_value <> 0 then
946: hr_utility.set_location(gv_package || lv_procedure_name, 110);
947: ln_index := pay_emp_action_arch.lrr_act_tab.count;
948:
949: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category
950: := 'EMPLOYEE OTHER INFORMATION';
951: pay_emp_action_arch.lrr_act_tab(ln_index).jurisdiction_code
952: := '00-000-0000';
953: pay_emp_action_arch.lrr_act_tab(ln_index).act_info1
947: ln_index := pay_emp_action_arch.lrr_act_tab.count;
948:
949: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category
950: := 'EMPLOYEE OTHER INFORMATION';
951: pay_emp_action_arch.lrr_act_tab(ln_index).jurisdiction_code
952: := '00-000-0000';
953: pay_emp_action_arch.lrr_act_tab(ln_index).act_info1
954: := p_organization_id;
955: pay_emp_action_arch.lrr_act_tab(ln_index).act_info2
949: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category
950: := 'EMPLOYEE OTHER INFORMATION';
951: pay_emp_action_arch.lrr_act_tab(ln_index).jurisdiction_code
952: := '00-000-0000';
953: pay_emp_action_arch.lrr_act_tab(ln_index).act_info1
954: := p_organization_id;
955: pay_emp_action_arch.lrr_act_tab(ln_index).act_info2
956: := lv_info_type;
957: pay_emp_action_arch.lrr_act_tab(ln_index).act_info4
951: pay_emp_action_arch.lrr_act_tab(ln_index).jurisdiction_code
952: := '00-000-0000';
953: pay_emp_action_arch.lrr_act_tab(ln_index).act_info1
954: := p_organization_id;
955: pay_emp_action_arch.lrr_act_tab(ln_index).act_info2
956: := lv_info_type;
957: pay_emp_action_arch.lrr_act_tab(ln_index).act_info4
958: := nvl(lv_display_name,lv_name) ;
959: pay_emp_action_arch.lrr_act_tab(ln_index).act_info5
953: pay_emp_action_arch.lrr_act_tab(ln_index).act_info1
954: := p_organization_id;
955: pay_emp_action_arch.lrr_act_tab(ln_index).act_info2
956: := lv_info_type;
957: pay_emp_action_arch.lrr_act_tab(ln_index).act_info4
958: := nvl(lv_display_name,lv_name) ;
959: pay_emp_action_arch.lrr_act_tab(ln_index).act_info5
960: := lv_value_type ;
961: pay_emp_action_arch.lrr_act_tab(ln_index).act_info6
955: pay_emp_action_arch.lrr_act_tab(ln_index).act_info2
956: := lv_info_type;
957: pay_emp_action_arch.lrr_act_tab(ln_index).act_info4
958: := nvl(lv_display_name,lv_name) ;
959: pay_emp_action_arch.lrr_act_tab(ln_index).act_info5
960: := lv_value_type ;
961: pay_emp_action_arch.lrr_act_tab(ln_index).act_info6
962: := fnd_number.number_to_canonical(lv_value); /*bug 4225799*/
963: pay_emp_action_arch.lrr_act_tab(ln_index).act_info9
957: pay_emp_action_arch.lrr_act_tab(ln_index).act_info4
958: := nvl(lv_display_name,lv_name) ;
959: pay_emp_action_arch.lrr_act_tab(ln_index).act_info5
960: := lv_value_type ;
961: pay_emp_action_arch.lrr_act_tab(ln_index).act_info6
962: := fnd_number.number_to_canonical(lv_value); /*bug 4225799*/
963: pay_emp_action_arch.lrr_act_tab(ln_index).act_info9
964: := ln_balance_type_id;
965: pay_emp_action_arch.lrr_act_tab(ln_index).act_info10
959: pay_emp_action_arch.lrr_act_tab(ln_index).act_info5
960: := lv_value_type ;
961: pay_emp_action_arch.lrr_act_tab(ln_index).act_info6
962: := fnd_number.number_to_canonical(lv_value); /*bug 4225799*/
963: pay_emp_action_arch.lrr_act_tab(ln_index).act_info9
964: := ln_balance_type_id;
965: pay_emp_action_arch.lrr_act_tab(ln_index).act_info10
966: := ln_balance_dimension_id;
967: -- Bug 5707497
961: pay_emp_action_arch.lrr_act_tab(ln_index).act_info6
962: := fnd_number.number_to_canonical(lv_value); /*bug 4225799*/
963: pay_emp_action_arch.lrr_act_tab(ln_index).act_info9
964: := ln_balance_type_id;
965: pay_emp_action_arch.lrr_act_tab(ln_index).act_info10
966: := ln_balance_dimension_id;
967: -- Bug 5707497
968: pay_emp_action_arch.lrr_act_tab(ln_index).act_info11
969: := lv_uom;
964: := ln_balance_type_id;
965: pay_emp_action_arch.lrr_act_tab(ln_index).act_info10
966: := ln_balance_dimension_id;
967: -- Bug 5707497
968: pay_emp_action_arch.lrr_act_tab(ln_index).act_info11
969: := lv_uom;
970: end if;
971: end if;
972: close c_defined_balance_id;
973:
974: end if;
975:
976: hr_utility.trace('ln_index in get_employee_other_info proc is '
977: || pay_emp_action_arch.lrr_act_tab.count);
978: hr_utility.trace('lv_info_type is'||lv_info_type);
979:
980: end loop;
981: close c_organization_info;
1021: if lv_uom in ('M', 'N', 'I') then
1022: lv_value := fnd_number.number_to_canonical(lv_value);
1023: end if;
1024:
1025: ln_index := pay_emp_action_arch.lrr_act_tab.count;
1026: hr_utility.trace('lv_name ' || lv_info_type);
1027: hr_utility.trace('lv_value ' || lv_value);
1028: hr_utility.trace('lv_value_type ' || lv_value_type);
1029:
1026: hr_utility.trace('lv_name ' || lv_info_type);
1027: hr_utility.trace('lv_value ' || lv_value);
1028: hr_utility.trace('lv_value_type ' || lv_value_type);
1029:
1030: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category
1031: := 'EMPLOYEE OTHER INFORMATION';
1032: pay_emp_action_arch.lrr_act_tab(ln_index).jurisdiction_code
1033: := '00-000-0000';
1034: pay_emp_action_arch.lrr_act_tab(ln_index).act_info1
1028: hr_utility.trace('lv_value_type ' || lv_value_type);
1029:
1030: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category
1031: := 'EMPLOYEE OTHER INFORMATION';
1032: pay_emp_action_arch.lrr_act_tab(ln_index).jurisdiction_code
1033: := '00-000-0000';
1034: pay_emp_action_arch.lrr_act_tab(ln_index).act_info1
1035: := p_business_group_id;
1036: pay_emp_action_arch.lrr_act_tab(ln_index).act_info2
1030: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category
1031: := 'EMPLOYEE OTHER INFORMATION';
1032: pay_emp_action_arch.lrr_act_tab(ln_index).jurisdiction_code
1033: := '00-000-0000';
1034: pay_emp_action_arch.lrr_act_tab(ln_index).act_info1
1035: := p_business_group_id;
1036: pay_emp_action_arch.lrr_act_tab(ln_index).act_info2
1037: := lv_info_type;
1038: pay_emp_action_arch.lrr_act_tab(ln_index).act_info4
1032: pay_emp_action_arch.lrr_act_tab(ln_index).jurisdiction_code
1033: := '00-000-0000';
1034: pay_emp_action_arch.lrr_act_tab(ln_index).act_info1
1035: := p_business_group_id;
1036: pay_emp_action_arch.lrr_act_tab(ln_index).act_info2
1037: := lv_info_type;
1038: pay_emp_action_arch.lrr_act_tab(ln_index).act_info4
1039: := nvl(lv_display_name,lv_name) ;
1040: pay_emp_action_arch.lrr_act_tab(ln_index).act_info5
1034: pay_emp_action_arch.lrr_act_tab(ln_index).act_info1
1035: := p_business_group_id;
1036: pay_emp_action_arch.lrr_act_tab(ln_index).act_info2
1037: := lv_info_type;
1038: pay_emp_action_arch.lrr_act_tab(ln_index).act_info4
1039: := nvl(lv_display_name,lv_name) ;
1040: pay_emp_action_arch.lrr_act_tab(ln_index).act_info5
1041: := lv_value_type ;
1042: pay_emp_action_arch.lrr_act_tab(ln_index).act_info6
1036: pay_emp_action_arch.lrr_act_tab(ln_index).act_info2
1037: := lv_info_type;
1038: pay_emp_action_arch.lrr_act_tab(ln_index).act_info4
1039: := nvl(lv_display_name,lv_name) ;
1040: pay_emp_action_arch.lrr_act_tab(ln_index).act_info5
1041: := lv_value_type ;
1042: pay_emp_action_arch.lrr_act_tab(ln_index).act_info6
1043: := lv_value;
1044: pay_emp_action_arch.lrr_act_tab(ln_index).act_info7
1038: pay_emp_action_arch.lrr_act_tab(ln_index).act_info4
1039: := nvl(lv_display_name,lv_name) ;
1040: pay_emp_action_arch.lrr_act_tab(ln_index).act_info5
1041: := lv_value_type ;
1042: pay_emp_action_arch.lrr_act_tab(ln_index).act_info6
1043: := lv_value;
1044: pay_emp_action_arch.lrr_act_tab(ln_index).act_info7
1045: := ln_element_type_id;
1046: pay_emp_action_arch.lrr_act_tab(ln_index).act_info8
1040: pay_emp_action_arch.lrr_act_tab(ln_index).act_info5
1041: := lv_value_type ;
1042: pay_emp_action_arch.lrr_act_tab(ln_index).act_info6
1043: := lv_value;
1044: pay_emp_action_arch.lrr_act_tab(ln_index).act_info7
1045: := ln_element_type_id;
1046: pay_emp_action_arch.lrr_act_tab(ln_index).act_info8
1047: := ln_input_value_id;
1048: -- Bug 5707497
1042: pay_emp_action_arch.lrr_act_tab(ln_index).act_info6
1043: := lv_value;
1044: pay_emp_action_arch.lrr_act_tab(ln_index).act_info7
1045: := ln_element_type_id;
1046: pay_emp_action_arch.lrr_act_tab(ln_index).act_info8
1047: := ln_input_value_id;
1048: -- Bug 5707497
1049: pay_emp_action_arch.lrr_act_tab(ln_index).act_info11
1050: := lv_uom;
1045: := ln_element_type_id;
1046: pay_emp_action_arch.lrr_act_tab(ln_index).act_info8
1047: := ln_input_value_id;
1048: -- Bug 5707497
1049: pay_emp_action_arch.lrr_act_tab(ln_index).act_info11
1050: := lv_uom;
1051: end if;
1052: close c_element_details;
1053: elsif lv_info_type = 'BALANCE' then
1086:
1087: lv_value := nvl(pay_balance_pkg.get_value(ln_defined_balance_id,
1088: ln_run_action_id),0);
1089: if lv_value <> 0 then
1090: ln_index := pay_emp_action_arch.lrr_act_tab.count;
1091:
1092: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category
1093: := 'EMPLOYEE OTHER INFORMATION';
1094: pay_emp_action_arch.lrr_act_tab(ln_index).jurisdiction_code
1088: ln_run_action_id),0);
1089: if lv_value <> 0 then
1090: ln_index := pay_emp_action_arch.lrr_act_tab.count;
1091:
1092: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category
1093: := 'EMPLOYEE OTHER INFORMATION';
1094: pay_emp_action_arch.lrr_act_tab(ln_index).jurisdiction_code
1095: := '00-000-0000';
1096: pay_emp_action_arch.lrr_act_tab(ln_index).act_info1
1090: ln_index := pay_emp_action_arch.lrr_act_tab.count;
1091:
1092: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category
1093: := 'EMPLOYEE OTHER INFORMATION';
1094: pay_emp_action_arch.lrr_act_tab(ln_index).jurisdiction_code
1095: := '00-000-0000';
1096: pay_emp_action_arch.lrr_act_tab(ln_index).act_info1
1097: := p_business_group_id;
1098: pay_emp_action_arch.lrr_act_tab(ln_index).act_info2
1092: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category
1093: := 'EMPLOYEE OTHER INFORMATION';
1094: pay_emp_action_arch.lrr_act_tab(ln_index).jurisdiction_code
1095: := '00-000-0000';
1096: pay_emp_action_arch.lrr_act_tab(ln_index).act_info1
1097: := p_business_group_id;
1098: pay_emp_action_arch.lrr_act_tab(ln_index).act_info2
1099: := lv_info_type;
1100: pay_emp_action_arch.lrr_act_tab(ln_index).act_info4
1094: pay_emp_action_arch.lrr_act_tab(ln_index).jurisdiction_code
1095: := '00-000-0000';
1096: pay_emp_action_arch.lrr_act_tab(ln_index).act_info1
1097: := p_business_group_id;
1098: pay_emp_action_arch.lrr_act_tab(ln_index).act_info2
1099: := lv_info_type;
1100: pay_emp_action_arch.lrr_act_tab(ln_index).act_info4
1101: := nvl(lv_display_name,lv_name) ;
1102: pay_emp_action_arch.lrr_act_tab(ln_index).act_info5
1096: pay_emp_action_arch.lrr_act_tab(ln_index).act_info1
1097: := p_business_group_id;
1098: pay_emp_action_arch.lrr_act_tab(ln_index).act_info2
1099: := lv_info_type;
1100: pay_emp_action_arch.lrr_act_tab(ln_index).act_info4
1101: := nvl(lv_display_name,lv_name) ;
1102: pay_emp_action_arch.lrr_act_tab(ln_index).act_info5
1103: := lv_value_type ;
1104: pay_emp_action_arch.lrr_act_tab(ln_index).act_info6
1098: pay_emp_action_arch.lrr_act_tab(ln_index).act_info2
1099: := lv_info_type;
1100: pay_emp_action_arch.lrr_act_tab(ln_index).act_info4
1101: := nvl(lv_display_name,lv_name) ;
1102: pay_emp_action_arch.lrr_act_tab(ln_index).act_info5
1103: := lv_value_type ;
1104: pay_emp_action_arch.lrr_act_tab(ln_index).act_info6
1105: := fnd_number.number_to_canonical(lv_value); /*bug 4225799*/
1106: pay_emp_action_arch.lrr_act_tab(ln_index).act_info9
1100: pay_emp_action_arch.lrr_act_tab(ln_index).act_info4
1101: := nvl(lv_display_name,lv_name) ;
1102: pay_emp_action_arch.lrr_act_tab(ln_index).act_info5
1103: := lv_value_type ;
1104: pay_emp_action_arch.lrr_act_tab(ln_index).act_info6
1105: := fnd_number.number_to_canonical(lv_value); /*bug 4225799*/
1106: pay_emp_action_arch.lrr_act_tab(ln_index).act_info9
1107: := ln_balance_type_id;
1108: pay_emp_action_arch.lrr_act_tab(ln_index).act_info10
1102: pay_emp_action_arch.lrr_act_tab(ln_index).act_info5
1103: := lv_value_type ;
1104: pay_emp_action_arch.lrr_act_tab(ln_index).act_info6
1105: := fnd_number.number_to_canonical(lv_value); /*bug 4225799*/
1106: pay_emp_action_arch.lrr_act_tab(ln_index).act_info9
1107: := ln_balance_type_id;
1108: pay_emp_action_arch.lrr_act_tab(ln_index).act_info10
1109: := ln_balance_dimension_id;
1110: -- Bug 5707497
1104: pay_emp_action_arch.lrr_act_tab(ln_index).act_info6
1105: := fnd_number.number_to_canonical(lv_value); /*bug 4225799*/
1106: pay_emp_action_arch.lrr_act_tab(ln_index).act_info9
1107: := ln_balance_type_id;
1108: pay_emp_action_arch.lrr_act_tab(ln_index).act_info10
1109: := ln_balance_dimension_id;
1110: -- Bug 5707497
1111: pay_emp_action_arch.lrr_act_tab(ln_index).act_info11
1112: := lv_uom;
1107: := ln_balance_type_id;
1108: pay_emp_action_arch.lrr_act_tab(ln_index).act_info10
1109: := ln_balance_dimension_id;
1110: -- Bug 5707497
1111: pay_emp_action_arch.lrr_act_tab(ln_index).act_info11
1112: := lv_uom;
1113: end if; -- lv_value > 0 then
1114: end if;
1115: close c_defined_balance_id;
1152: if pay_us_emp_payslip_accrual_web.ltr_assignment_accruals.count > 0 then
1153: for i in pay_us_emp_payslip_accrual_web.ltr_assignment_accruals.first ..
1154: pay_us_emp_payslip_accrual_web.ltr_assignment_accruals.last loop
1155:
1156: ln_index := pay_emp_action_arch.lrr_act_tab.count;
1157:
1158: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category
1159: := 'EMPLOYEE ACCRUALS';
1160: pay_emp_action_arch.lrr_act_tab(ln_index).jurisdiction_code
1154: pay_us_emp_payslip_accrual_web.ltr_assignment_accruals.last loop
1155:
1156: ln_index := pay_emp_action_arch.lrr_act_tab.count;
1157:
1158: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category
1159: := 'EMPLOYEE ACCRUALS';
1160: pay_emp_action_arch.lrr_act_tab(ln_index).jurisdiction_code
1161: := '00-000-0000';
1162: pay_emp_action_arch.lrr_act_tab(ln_index).act_info4
1156: ln_index := pay_emp_action_arch.lrr_act_tab.count;
1157:
1158: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category
1159: := 'EMPLOYEE ACCRUALS';
1160: pay_emp_action_arch.lrr_act_tab(ln_index).jurisdiction_code
1161: := '00-000-0000';
1162: pay_emp_action_arch.lrr_act_tab(ln_index).act_info4
1163: := pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i).accrual_category;
1164: /* Bug 3311866*/
1158: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category
1159: := 'EMPLOYEE ACCRUALS';
1160: pay_emp_action_arch.lrr_act_tab(ln_index).jurisdiction_code
1161: := '00-000-0000';
1162: pay_emp_action_arch.lrr_act_tab(ln_index).act_info4
1163: := pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i).accrual_category;
1164: /* Bug 3311866*/
1165: pay_emp_action_arch.lrr_act_tab(ln_index).act_info5
1166: := fnd_number.number_to_canonical
1161: := '00-000-0000';
1162: pay_emp_action_arch.lrr_act_tab(ln_index).act_info4
1163: := pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i).accrual_category;
1164: /* Bug 3311866*/
1165: pay_emp_action_arch.lrr_act_tab(ln_index).act_info5
1166: := fnd_number.number_to_canonical
1167: (pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i).accrual_cur_value);
1168: pay_emp_action_arch.lrr_act_tab(ln_index).act_info6
1169: := fnd_number.number_to_canonical
1164: /* Bug 3311866*/
1165: pay_emp_action_arch.lrr_act_tab(ln_index).act_info5
1166: := fnd_number.number_to_canonical
1167: (pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i).accrual_cur_value);
1168: pay_emp_action_arch.lrr_act_tab(ln_index).act_info6
1169: := fnd_number.number_to_canonical
1170: (pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i).accrual_net_value);
1171: pay_emp_action_arch.lrr_act_tab(ln_index).act_info7
1172: := pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i).accrual_code;
1167: (pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i).accrual_cur_value);
1168: pay_emp_action_arch.lrr_act_tab(ln_index).act_info6
1169: := fnd_number.number_to_canonical
1170: (pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i).accrual_net_value);
1171: pay_emp_action_arch.lrr_act_tab(ln_index).act_info7
1172: := pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i).accrual_code;
1173: end loop;
1174: end if;
1175:
1200: BEGIN
1201: lv_procedure_name := 'get_organization_name';
1202: lv_exists := 'N';
1203: hr_utility.trace('Entered get_organization_name');
1204: if pay_emp_action_arch.ltr_organizations.count > 0 then
1205: for i in pay_emp_action_arch.ltr_organizations.first ..
1206: pay_emp_action_arch.ltr_organizations.last loop
1207: if pay_emp_action_arch.ltr_organizations(i).id = p_organization_id then
1208: lv_organization_name := pay_emp_action_arch.ltr_organizations(i).name;
1201: lv_procedure_name := 'get_organization_name';
1202: lv_exists := 'N';
1203: hr_utility.trace('Entered get_organization_name');
1204: if pay_emp_action_arch.ltr_organizations.count > 0 then
1205: for i in pay_emp_action_arch.ltr_organizations.first ..
1206: pay_emp_action_arch.ltr_organizations.last loop
1207: if pay_emp_action_arch.ltr_organizations(i).id = p_organization_id then
1208: lv_organization_name := pay_emp_action_arch.ltr_organizations(i).name;
1209: lv_exists := 'Y';
1202: lv_exists := 'N';
1203: hr_utility.trace('Entered get_organization_name');
1204: if pay_emp_action_arch.ltr_organizations.count > 0 then
1205: for i in pay_emp_action_arch.ltr_organizations.first ..
1206: pay_emp_action_arch.ltr_organizations.last loop
1207: if pay_emp_action_arch.ltr_organizations(i).id = p_organization_id then
1208: lv_organization_name := pay_emp_action_arch.ltr_organizations(i).name;
1209: lv_exists := 'Y';
1210: exit;
1203: hr_utility.trace('Entered get_organization_name');
1204: if pay_emp_action_arch.ltr_organizations.count > 0 then
1205: for i in pay_emp_action_arch.ltr_organizations.first ..
1206: pay_emp_action_arch.ltr_organizations.last loop
1207: if pay_emp_action_arch.ltr_organizations(i).id = p_organization_id then
1208: lv_organization_name := pay_emp_action_arch.ltr_organizations(i).name;
1209: lv_exists := 'Y';
1210: exit;
1211: end if;
1204: if pay_emp_action_arch.ltr_organizations.count > 0 then
1205: for i in pay_emp_action_arch.ltr_organizations.first ..
1206: pay_emp_action_arch.ltr_organizations.last loop
1207: if pay_emp_action_arch.ltr_organizations(i).id = p_organization_id then
1208: lv_organization_name := pay_emp_action_arch.ltr_organizations(i).name;
1209: lv_exists := 'Y';
1210: exit;
1211: end if;
1212: end loop;
1215: if lv_exists = 'N' then
1216: open c_organization_name;
1217: fetch c_organization_name into lv_organization_name;
1218: close c_organization_name;
1219: ln_index := pay_emp_action_arch.ltr_organizations.count;
1220: pay_emp_action_arch.ltr_organizations(ln_index).id := p_organization_id;
1221: pay_emp_action_arch.ltr_organizations(ln_index).name := lv_organization_name;
1222: end if;
1223:
1216: open c_organization_name;
1217: fetch c_organization_name into lv_organization_name;
1218: close c_organization_name;
1219: ln_index := pay_emp_action_arch.ltr_organizations.count;
1220: pay_emp_action_arch.ltr_organizations(ln_index).id := p_organization_id;
1221: pay_emp_action_arch.ltr_organizations(ln_index).name := lv_organization_name;
1222: end if;
1223:
1224: hr_utility.trace('Leaving get_organization_name');
1217: fetch c_organization_name into lv_organization_name;
1218: close c_organization_name;
1219: ln_index := pay_emp_action_arch.ltr_organizations.count;
1220: pay_emp_action_arch.ltr_organizations(ln_index).id := p_organization_id;
1221: pay_emp_action_arch.ltr_organizations(ln_index).name := lv_organization_name;
1222: end if;
1223:
1224: hr_utility.trace('Leaving get_organization_name');
1225: return(lv_organization_name);
1256: lv_procedure_name := 'get_location';
1257: lv_exists := 'N';
1258: hr_utility.trace('Entered get_location');
1259:
1260: if pay_emp_action_arch.ltr_location.count > 0 then
1261: for i in pay_emp_action_arch.ltr_location.first ..
1262: pay_emp_action_arch.ltr_location.last loop
1263: if pay_emp_action_arch.ltr_location(i).id = p_location_id then
1264: lv_location_name := pay_emp_action_arch.ltr_location(i).name;
1257: lv_exists := 'N';
1258: hr_utility.trace('Entered get_location');
1259:
1260: if pay_emp_action_arch.ltr_location.count > 0 then
1261: for i in pay_emp_action_arch.ltr_location.first ..
1262: pay_emp_action_arch.ltr_location.last loop
1263: if pay_emp_action_arch.ltr_location(i).id = p_location_id then
1264: lv_location_name := pay_emp_action_arch.ltr_location(i).name;
1265: lv_exists := 'Y';
1258: hr_utility.trace('Entered get_location');
1259:
1260: if pay_emp_action_arch.ltr_location.count > 0 then
1261: for i in pay_emp_action_arch.ltr_location.first ..
1262: pay_emp_action_arch.ltr_location.last loop
1263: if pay_emp_action_arch.ltr_location(i).id = p_location_id then
1264: lv_location_name := pay_emp_action_arch.ltr_location(i).name;
1265: lv_exists := 'Y';
1266: exit;
1259:
1260: if pay_emp_action_arch.ltr_location.count > 0 then
1261: for i in pay_emp_action_arch.ltr_location.first ..
1262: pay_emp_action_arch.ltr_location.last loop
1263: if pay_emp_action_arch.ltr_location(i).id = p_location_id then
1264: lv_location_name := pay_emp_action_arch.ltr_location(i).name;
1265: lv_exists := 'Y';
1266: exit;
1267: end if;
1260: if pay_emp_action_arch.ltr_location.count > 0 then
1261: for i in pay_emp_action_arch.ltr_location.first ..
1262: pay_emp_action_arch.ltr_location.last loop
1263: if pay_emp_action_arch.ltr_location(i).id = p_location_id then
1264: lv_location_name := pay_emp_action_arch.ltr_location(i).name;
1265: lv_exists := 'Y';
1266: exit;
1267: end if;
1268: end loop;
1271: if lv_exists = 'N' then
1272: open c_location(p_location_id);
1273: fetch c_location into lv_location_name;
1274: close c_location;
1275: ln_index := pay_emp_action_arch.ltr_location.count;
1276: pay_emp_action_arch.ltr_location(ln_index).id := p_location_id;
1277: pay_emp_action_arch.ltr_location(ln_index).name := lv_location_name;
1278: end if;
1279:
1272: open c_location(p_location_id);
1273: fetch c_location into lv_location_name;
1274: close c_location;
1275: ln_index := pay_emp_action_arch.ltr_location.count;
1276: pay_emp_action_arch.ltr_location(ln_index).id := p_location_id;
1277: pay_emp_action_arch.ltr_location(ln_index).name := lv_location_name;
1278: end if;
1279:
1280: hr_utility.trace('Leaving get_location');
1273: fetch c_location into lv_location_name;
1274: close c_location;
1275: ln_index := pay_emp_action_arch.ltr_location.count;
1276: pay_emp_action_arch.ltr_location(ln_index).id := p_location_id;
1277: pay_emp_action_arch.ltr_location(ln_index).name := lv_location_name;
1278: end if;
1279:
1280: hr_utility.trace('Leaving get_location');
1281:
1315: BEGIN
1316: lv_procedure_name := 'get_job_name';
1317: lv_exists := 'N';
1318: hr_utility.trace('Entered get_job_name');
1319: if pay_emp_action_arch.ltr_jobs.count > 0 then
1320: for i in pay_emp_action_arch.ltr_jobs.first ..
1321: pay_emp_action_arch.ltr_jobs.last loop
1322: if pay_emp_action_arch.ltr_jobs(i).id = p_job_id then
1323: lv_job_name := pay_emp_action_arch.ltr_jobs(i).name;
1316: lv_procedure_name := 'get_job_name';
1317: lv_exists := 'N';
1318: hr_utility.trace('Entered get_job_name');
1319: if pay_emp_action_arch.ltr_jobs.count > 0 then
1320: for i in pay_emp_action_arch.ltr_jobs.first ..
1321: pay_emp_action_arch.ltr_jobs.last loop
1322: if pay_emp_action_arch.ltr_jobs(i).id = p_job_id then
1323: lv_job_name := pay_emp_action_arch.ltr_jobs(i).name;
1324: lv_exists := 'Y';
1317: lv_exists := 'N';
1318: hr_utility.trace('Entered get_job_name');
1319: if pay_emp_action_arch.ltr_jobs.count > 0 then
1320: for i in pay_emp_action_arch.ltr_jobs.first ..
1321: pay_emp_action_arch.ltr_jobs.last loop
1322: if pay_emp_action_arch.ltr_jobs(i).id = p_job_id then
1323: lv_job_name := pay_emp_action_arch.ltr_jobs(i).name;
1324: lv_exists := 'Y';
1325: exit;
1318: hr_utility.trace('Entered get_job_name');
1319: if pay_emp_action_arch.ltr_jobs.count > 0 then
1320: for i in pay_emp_action_arch.ltr_jobs.first ..
1321: pay_emp_action_arch.ltr_jobs.last loop
1322: if pay_emp_action_arch.ltr_jobs(i).id = p_job_id then
1323: lv_job_name := pay_emp_action_arch.ltr_jobs(i).name;
1324: lv_exists := 'Y';
1325: exit;
1326: end if;
1319: if pay_emp_action_arch.ltr_jobs.count > 0 then
1320: for i in pay_emp_action_arch.ltr_jobs.first ..
1321: pay_emp_action_arch.ltr_jobs.last loop
1322: if pay_emp_action_arch.ltr_jobs(i).id = p_job_id then
1323: lv_job_name := pay_emp_action_arch.ltr_jobs(i).name;
1324: lv_exists := 'Y';
1325: exit;
1326: end if;
1327: end loop;
1330: if lv_exists = 'N' then
1331: open c_job_name(p_job_id, p_effective_date);
1332: fetch c_job_name into lv_job_name;
1333: close c_job_name;
1334: ln_index := pay_emp_action_arch.ltr_jobs.count;
1335: pay_emp_action_arch.ltr_jobs(ln_index).id := p_job_id;
1336: pay_emp_action_arch.ltr_jobs(ln_index).name := lv_job_name;
1337: end if;
1338:
1331: open c_job_name(p_job_id, p_effective_date);
1332: fetch c_job_name into lv_job_name;
1333: close c_job_name;
1334: ln_index := pay_emp_action_arch.ltr_jobs.count;
1335: pay_emp_action_arch.ltr_jobs(ln_index).id := p_job_id;
1336: pay_emp_action_arch.ltr_jobs(ln_index).name := lv_job_name;
1337: end if;
1338:
1339: hr_utility.trace('Leaving get_job_name');
1332: fetch c_job_name into lv_job_name;
1333: close c_job_name;
1334: ln_index := pay_emp_action_arch.ltr_jobs.count;
1335: pay_emp_action_arch.ltr_jobs(ln_index).id := p_job_id;
1336: pay_emp_action_arch.ltr_jobs(ln_index).name := lv_job_name;
1337: end if;
1338:
1339: hr_utility.trace('Leaving get_job_name');
1340: return(lv_job_name);
1368: BEGIN
1369: lv_procedure_name := 'get_position';
1370: lv_exists := 'N';
1371: hr_utility.trace('Entered get_position');
1372: if pay_emp_action_arch.ltr_positions.count > 0 then
1373: for i in pay_emp_action_arch.ltr_positions.first ..
1374: pay_emp_action_arch.ltr_positions.last loop
1375: if pay_emp_action_arch.ltr_positions(i).id = p_position_id then
1376: lv_position_name := pay_emp_action_arch.ltr_positions(i).name;
1369: lv_procedure_name := 'get_position';
1370: lv_exists := 'N';
1371: hr_utility.trace('Entered get_position');
1372: if pay_emp_action_arch.ltr_positions.count > 0 then
1373: for i in pay_emp_action_arch.ltr_positions.first ..
1374: pay_emp_action_arch.ltr_positions.last loop
1375: if pay_emp_action_arch.ltr_positions(i).id = p_position_id then
1376: lv_position_name := pay_emp_action_arch.ltr_positions(i).name;
1377: lv_exists := 'Y';
1370: lv_exists := 'N';
1371: hr_utility.trace('Entered get_position');
1372: if pay_emp_action_arch.ltr_positions.count > 0 then
1373: for i in pay_emp_action_arch.ltr_positions.first ..
1374: pay_emp_action_arch.ltr_positions.last loop
1375: if pay_emp_action_arch.ltr_positions(i).id = p_position_id then
1376: lv_position_name := pay_emp_action_arch.ltr_positions(i).name;
1377: lv_exists := 'Y';
1378: exit;
1371: hr_utility.trace('Entered get_position');
1372: if pay_emp_action_arch.ltr_positions.count > 0 then
1373: for i in pay_emp_action_arch.ltr_positions.first ..
1374: pay_emp_action_arch.ltr_positions.last loop
1375: if pay_emp_action_arch.ltr_positions(i).id = p_position_id then
1376: lv_position_name := pay_emp_action_arch.ltr_positions(i).name;
1377: lv_exists := 'Y';
1378: exit;
1379: end if;
1372: if pay_emp_action_arch.ltr_positions.count > 0 then
1373: for i in pay_emp_action_arch.ltr_positions.first ..
1374: pay_emp_action_arch.ltr_positions.last loop
1375: if pay_emp_action_arch.ltr_positions(i).id = p_position_id then
1376: lv_position_name := pay_emp_action_arch.ltr_positions(i).name;
1377: lv_exists := 'Y';
1378: exit;
1379: end if;
1380: end loop;
1383: if lv_exists = 'N' then
1384: open c_position_name(p_position_id, p_effective_date);
1385: fetch c_position_name into lv_position_name;
1386: close c_position_name;
1387: ln_index := pay_emp_action_arch.ltr_positions.count;
1388: pay_emp_action_arch.ltr_positions(ln_index).id := p_position_id;
1389: pay_emp_action_arch.ltr_positions(ln_index).name := lv_position_name;
1390: end if;
1391:
1384: open c_position_name(p_position_id, p_effective_date);
1385: fetch c_position_name into lv_position_name;
1386: close c_position_name;
1387: ln_index := pay_emp_action_arch.ltr_positions.count;
1388: pay_emp_action_arch.ltr_positions(ln_index).id := p_position_id;
1389: pay_emp_action_arch.ltr_positions(ln_index).name := lv_position_name;
1390: end if;
1391:
1392: hr_utility.trace('Leaving get_position');
1385: fetch c_position_name into lv_position_name;
1386: close c_position_name;
1387: ln_index := pay_emp_action_arch.ltr_positions.count;
1388: pay_emp_action_arch.ltr_positions(ln_index).id := p_position_id;
1389: pay_emp_action_arch.ltr_positions(ln_index).name := lv_position_name;
1390: end if;
1391:
1392: hr_utility.trace('Leaving get_position');
1393:
1424: BEGIN
1425: lv_procedure_name := 'get_pay_basis';
1426: lv_exists := 'N';
1427: hr_utility.trace('Entered get_pay_basis');
1428: if pay_emp_action_arch.ltr_pay_basis.count > 0 then
1429: for i in pay_emp_action_arch.ltr_pay_basis.first ..
1430: pay_emp_action_arch.ltr_pay_basis.last loop
1431: if pay_emp_action_arch.ltr_pay_basis(i).id = p_pay_basis_id then
1432: lv_pay_basis := pay_emp_action_arch.ltr_pay_basis(i).name;
1425: lv_procedure_name := 'get_pay_basis';
1426: lv_exists := 'N';
1427: hr_utility.trace('Entered get_pay_basis');
1428: if pay_emp_action_arch.ltr_pay_basis.count > 0 then
1429: for i in pay_emp_action_arch.ltr_pay_basis.first ..
1430: pay_emp_action_arch.ltr_pay_basis.last loop
1431: if pay_emp_action_arch.ltr_pay_basis(i).id = p_pay_basis_id then
1432: lv_pay_basis := pay_emp_action_arch.ltr_pay_basis(i).name;
1433: lv_exists := 'Y';
1426: lv_exists := 'N';
1427: hr_utility.trace('Entered get_pay_basis');
1428: if pay_emp_action_arch.ltr_pay_basis.count > 0 then
1429: for i in pay_emp_action_arch.ltr_pay_basis.first ..
1430: pay_emp_action_arch.ltr_pay_basis.last loop
1431: if pay_emp_action_arch.ltr_pay_basis(i).id = p_pay_basis_id then
1432: lv_pay_basis := pay_emp_action_arch.ltr_pay_basis(i).name;
1433: lv_exists := 'Y';
1434: exit;
1427: hr_utility.trace('Entered get_pay_basis');
1428: if pay_emp_action_arch.ltr_pay_basis.count > 0 then
1429: for i in pay_emp_action_arch.ltr_pay_basis.first ..
1430: pay_emp_action_arch.ltr_pay_basis.last loop
1431: if pay_emp_action_arch.ltr_pay_basis(i).id = p_pay_basis_id then
1432: lv_pay_basis := pay_emp_action_arch.ltr_pay_basis(i).name;
1433: lv_exists := 'Y';
1434: exit;
1435: end if;
1428: if pay_emp_action_arch.ltr_pay_basis.count > 0 then
1429: for i in pay_emp_action_arch.ltr_pay_basis.first ..
1430: pay_emp_action_arch.ltr_pay_basis.last loop
1431: if pay_emp_action_arch.ltr_pay_basis(i).id = p_pay_basis_id then
1432: lv_pay_basis := pay_emp_action_arch.ltr_pay_basis(i).name;
1433: lv_exists := 'Y';
1434: exit;
1435: end if;
1436: end loop;
1439: if lv_exists = 'N' then
1440: open c_pay_basis(p_pay_basis_id, p_effective_date);
1441: fetch c_pay_basis into lv_pay_basis;
1442: close c_pay_basis;
1443: ln_index := pay_emp_action_arch.ltr_pay_basis.count;
1444: pay_emp_action_arch.ltr_pay_basis(ln_index).id := p_pay_basis_id;
1445: pay_emp_action_arch.ltr_pay_basis(ln_index).name := lv_pay_basis;
1446: end if;
1447:
1440: open c_pay_basis(p_pay_basis_id, p_effective_date);
1441: fetch c_pay_basis into lv_pay_basis;
1442: close c_pay_basis;
1443: ln_index := pay_emp_action_arch.ltr_pay_basis.count;
1444: pay_emp_action_arch.ltr_pay_basis(ln_index).id := p_pay_basis_id;
1445: pay_emp_action_arch.ltr_pay_basis(ln_index).name := lv_pay_basis;
1446: end if;
1447:
1448: hr_utility.trace('Leaving get_pay_basis');
1441: fetch c_pay_basis into lv_pay_basis;
1442: close c_pay_basis;
1443: ln_index := pay_emp_action_arch.ltr_pay_basis.count;
1444: pay_emp_action_arch.ltr_pay_basis(ln_index).id := p_pay_basis_id;
1445: pay_emp_action_arch.ltr_pay_basis(ln_index).name := lv_pay_basis;
1446: end if;
1447:
1448: hr_utility.trace('Leaving get_pay_basis');
1449:
1515: BEGIN
1516: lv_procedure_name := 'get_grade';
1517: lv_exists := 'N';
1518: hr_utility.trace('Entered get_grades');
1519: if pay_emp_action_arch.ltr_grades.count > 0 then
1520: for i in pay_emp_action_arch.ltr_grades.first ..
1521: pay_emp_action_arch.ltr_grades.last loop
1522: if pay_emp_action_arch.ltr_grades(i).id = p_grade_id then
1523: lv_grade := pay_emp_action_arch.ltr_grades(i).name;
1516: lv_procedure_name := 'get_grade';
1517: lv_exists := 'N';
1518: hr_utility.trace('Entered get_grades');
1519: if pay_emp_action_arch.ltr_grades.count > 0 then
1520: for i in pay_emp_action_arch.ltr_grades.first ..
1521: pay_emp_action_arch.ltr_grades.last loop
1522: if pay_emp_action_arch.ltr_grades(i).id = p_grade_id then
1523: lv_grade := pay_emp_action_arch.ltr_grades(i).name;
1524: lv_exists := 'Y';
1517: lv_exists := 'N';
1518: hr_utility.trace('Entered get_grades');
1519: if pay_emp_action_arch.ltr_grades.count > 0 then
1520: for i in pay_emp_action_arch.ltr_grades.first ..
1521: pay_emp_action_arch.ltr_grades.last loop
1522: if pay_emp_action_arch.ltr_grades(i).id = p_grade_id then
1523: lv_grade := pay_emp_action_arch.ltr_grades(i).name;
1524: lv_exists := 'Y';
1525: exit;
1518: hr_utility.trace('Entered get_grades');
1519: if pay_emp_action_arch.ltr_grades.count > 0 then
1520: for i in pay_emp_action_arch.ltr_grades.first ..
1521: pay_emp_action_arch.ltr_grades.last loop
1522: if pay_emp_action_arch.ltr_grades(i).id = p_grade_id then
1523: lv_grade := pay_emp_action_arch.ltr_grades(i).name;
1524: lv_exists := 'Y';
1525: exit;
1526: end if;
1519: if pay_emp_action_arch.ltr_grades.count > 0 then
1520: for i in pay_emp_action_arch.ltr_grades.first ..
1521: pay_emp_action_arch.ltr_grades.last loop
1522: if pay_emp_action_arch.ltr_grades(i).id = p_grade_id then
1523: lv_grade := pay_emp_action_arch.ltr_grades(i).name;
1524: lv_exists := 'Y';
1525: exit;
1526: end if;
1527: end loop;
1530: if lv_exists = 'N' then
1531: open c_grade(p_grade_id, p_effective_date);
1532: fetch c_grade into lv_grade;
1533: close c_grade;
1534: ln_index := pay_emp_action_arch.ltr_grades.count;
1535: pay_emp_action_arch.ltr_grades(ln_index).id := p_grade_id;
1536: pay_emp_action_arch.ltr_grades(ln_index).name := lv_grade;
1537: end if;
1538:
1531: open c_grade(p_grade_id, p_effective_date);
1532: fetch c_grade into lv_grade;
1533: close c_grade;
1534: ln_index := pay_emp_action_arch.ltr_grades.count;
1535: pay_emp_action_arch.ltr_grades(ln_index).id := p_grade_id;
1536: pay_emp_action_arch.ltr_grades(ln_index).name := lv_grade;
1537: end if;
1538:
1539: return(lv_grade);
1532: fetch c_grade into lv_grade;
1533: close c_grade;
1534: ln_index := pay_emp_action_arch.ltr_grades.count;
1535: pay_emp_action_arch.ltr_grades(ln_index).id := p_grade_id;
1536: pay_emp_action_arch.ltr_grades(ln_index).name := lv_grade;
1537: end if;
1538:
1539: return(lv_grade);
1540:
1787: ,lv_ee_postal_code
1788: ,lv_ee_country;
1789: close c_addr_line;
1790:
1791: ln_index := pay_emp_action_arch.lrr_act_tab.count;
1792:
1793: hr_utility.trace('ln_index in get_employee_addr proc is '
1794: || pay_emp_action_arch.lrr_act_tab.count);
1795: hr_utility.trace('person_id is'||p_person_id);
1790:
1791: ln_index := pay_emp_action_arch.lrr_act_tab.count;
1792:
1793: hr_utility.trace('ln_index in get_employee_addr proc is '
1794: || pay_emp_action_arch.lrr_act_tab.count);
1795: hr_utility.trace('person_id is'||p_person_id);
1796:
1797: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category
1798: := 'ADDRESS DETAILS';
1793: hr_utility.trace('ln_index in get_employee_addr proc is '
1794: || pay_emp_action_arch.lrr_act_tab.count);
1795: hr_utility.trace('person_id is'||p_person_id);
1796:
1797: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category
1798: := 'ADDRESS DETAILS';
1799: pay_emp_action_arch.lrr_act_tab(ln_index).jurisdiction_code
1800: := '00-000-0000';
1801: pay_emp_action_arch.lrr_act_tab(ln_index).act_info1
1795: hr_utility.trace('person_id is'||p_person_id);
1796:
1797: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category
1798: := 'ADDRESS DETAILS';
1799: pay_emp_action_arch.lrr_act_tab(ln_index).jurisdiction_code
1800: := '00-000-0000';
1801: pay_emp_action_arch.lrr_act_tab(ln_index).act_info1
1802: := p_person_id;
1803: pay_emp_action_arch.lrr_act_tab(ln_index).act_info5
1797: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category
1798: := 'ADDRESS DETAILS';
1799: pay_emp_action_arch.lrr_act_tab(ln_index).jurisdiction_code
1800: := '00-000-0000';
1801: pay_emp_action_arch.lrr_act_tab(ln_index).act_info1
1802: := p_person_id;
1803: pay_emp_action_arch.lrr_act_tab(ln_index).act_info5
1804: := lv_ee_address_line_1 ;
1805: pay_emp_action_arch.lrr_act_tab(ln_index).act_info6
1799: pay_emp_action_arch.lrr_act_tab(ln_index).jurisdiction_code
1800: := '00-000-0000';
1801: pay_emp_action_arch.lrr_act_tab(ln_index).act_info1
1802: := p_person_id;
1803: pay_emp_action_arch.lrr_act_tab(ln_index).act_info5
1804: := lv_ee_address_line_1 ;
1805: pay_emp_action_arch.lrr_act_tab(ln_index).act_info6
1806: := lv_ee_address_line_2;
1807: pay_emp_action_arch.lrr_act_tab(ln_index).act_info7
1801: pay_emp_action_arch.lrr_act_tab(ln_index).act_info1
1802: := p_person_id;
1803: pay_emp_action_arch.lrr_act_tab(ln_index).act_info5
1804: := lv_ee_address_line_1 ;
1805: pay_emp_action_arch.lrr_act_tab(ln_index).act_info6
1806: := lv_ee_address_line_2;
1807: pay_emp_action_arch.lrr_act_tab(ln_index).act_info7
1808: := lv_ee_address_line_3;
1809: pay_emp_action_arch.lrr_act_tab(ln_index).act_info8
1803: pay_emp_action_arch.lrr_act_tab(ln_index).act_info5
1804: := lv_ee_address_line_1 ;
1805: pay_emp_action_arch.lrr_act_tab(ln_index).act_info6
1806: := lv_ee_address_line_2;
1807: pay_emp_action_arch.lrr_act_tab(ln_index).act_info7
1808: := lv_ee_address_line_3;
1809: pay_emp_action_arch.lrr_act_tab(ln_index).act_info8
1810: := lv_ee_town_or_city;
1811: pay_emp_action_arch.lrr_act_tab(ln_index).act_info9
1805: pay_emp_action_arch.lrr_act_tab(ln_index).act_info6
1806: := lv_ee_address_line_2;
1807: pay_emp_action_arch.lrr_act_tab(ln_index).act_info7
1808: := lv_ee_address_line_3;
1809: pay_emp_action_arch.lrr_act_tab(ln_index).act_info8
1810: := lv_ee_town_or_city;
1811: pay_emp_action_arch.lrr_act_tab(ln_index).act_info9
1812: := lv_ee_region_1;
1813: pay_emp_action_arch.lrr_act_tab(ln_index).act_info10
1807: pay_emp_action_arch.lrr_act_tab(ln_index).act_info7
1808: := lv_ee_address_line_3;
1809: pay_emp_action_arch.lrr_act_tab(ln_index).act_info8
1810: := lv_ee_town_or_city;
1811: pay_emp_action_arch.lrr_act_tab(ln_index).act_info9
1812: := lv_ee_region_1;
1813: pay_emp_action_arch.lrr_act_tab(ln_index).act_info10
1814: := lv_ee_region_2;
1815: pay_emp_action_arch.lrr_act_tab(ln_index).act_info11
1809: pay_emp_action_arch.lrr_act_tab(ln_index).act_info8
1810: := lv_ee_town_or_city;
1811: pay_emp_action_arch.lrr_act_tab(ln_index).act_info9
1812: := lv_ee_region_1;
1813: pay_emp_action_arch.lrr_act_tab(ln_index).act_info10
1814: := lv_ee_region_2;
1815: pay_emp_action_arch.lrr_act_tab(ln_index).act_info11
1816: := lv_ee_region_3 ;
1817: pay_emp_action_arch.lrr_act_tab(ln_index).act_info12
1811: pay_emp_action_arch.lrr_act_tab(ln_index).act_info9
1812: := lv_ee_region_1;
1813: pay_emp_action_arch.lrr_act_tab(ln_index).act_info10
1814: := lv_ee_region_2;
1815: pay_emp_action_arch.lrr_act_tab(ln_index).act_info11
1816: := lv_ee_region_3 ;
1817: pay_emp_action_arch.lrr_act_tab(ln_index).act_info12
1818: := lv_ee_postal_code;
1819: pay_emp_action_arch.lrr_act_tab(ln_index).act_info13
1813: pay_emp_action_arch.lrr_act_tab(ln_index).act_info10
1814: := lv_ee_region_2;
1815: pay_emp_action_arch.lrr_act_tab(ln_index).act_info11
1816: := lv_ee_region_3 ;
1817: pay_emp_action_arch.lrr_act_tab(ln_index).act_info12
1818: := lv_ee_postal_code;
1819: pay_emp_action_arch.lrr_act_tab(ln_index).act_info13
1820: := lv_ee_country;
1821: pay_emp_action_arch.lrr_act_tab(ln_index).act_info14
1815: pay_emp_action_arch.lrr_act_tab(ln_index).act_info11
1816: := lv_ee_region_3 ;
1817: pay_emp_action_arch.lrr_act_tab(ln_index).act_info12
1818: := lv_ee_postal_code;
1819: pay_emp_action_arch.lrr_act_tab(ln_index).act_info13
1820: := lv_ee_country;
1821: pay_emp_action_arch.lrr_act_tab(ln_index).act_info14
1822: := lv_ee_or_er;
1823: hr_utility.trace('Leaving get_employee_addr');
1817: pay_emp_action_arch.lrr_act_tab(ln_index).act_info12
1818: := lv_ee_postal_code;
1819: pay_emp_action_arch.lrr_act_tab(ln_index).act_info13
1820: := lv_ee_country;
1821: pay_emp_action_arch.lrr_act_tab(ln_index).act_info14
1822: := lv_ee_or_er;
1823: hr_utility.trace('Leaving get_employee_addr');
1824: END get_employee_addr;
1825:
1955: if c_net_pay%notfound then
1956: exit;
1957: end if;
1958:
1959: ln_index := pay_emp_action_arch.lrr_act_tab.count;
1960:
1961: hr_utility.trace('ln_index in get_net_pay_dist proc is '
1962: || pay_emp_action_arch.lrr_act_tab.count);
1963:
1958:
1959: ln_index := pay_emp_action_arch.lrr_act_tab.count;
1960:
1961: hr_utility.trace('ln_index in get_net_pay_dist proc is '
1962: || pay_emp_action_arch.lrr_act_tab.count);
1963:
1964: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category
1965: := 'EMPLOYEE NET PAY DISTRIBUTION';
1966: pay_emp_action_arch.lrr_act_tab(ln_index).jurisdiction_code
1960:
1961: hr_utility.trace('ln_index in get_net_pay_dist proc is '
1962: || pay_emp_action_arch.lrr_act_tab.count);
1963:
1964: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category
1965: := 'EMPLOYEE NET PAY DISTRIBUTION';
1966: pay_emp_action_arch.lrr_act_tab(ln_index).jurisdiction_code
1967: := '00-000-0000';
1968: pay_emp_action_arch.lrr_act_tab(ln_index).act_info1
1962: || pay_emp_action_arch.lrr_act_tab.count);
1963:
1964: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category
1965: := 'EMPLOYEE NET PAY DISTRIBUTION';
1966: pay_emp_action_arch.lrr_act_tab(ln_index).jurisdiction_code
1967: := '00-000-0000';
1968: pay_emp_action_arch.lrr_act_tab(ln_index).act_info1
1969: := ln_org_payment_method_id;
1970: pay_emp_action_arch.lrr_act_tab(ln_index).act_info2
1964: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category
1965: := 'EMPLOYEE NET PAY DISTRIBUTION';
1966: pay_emp_action_arch.lrr_act_tab(ln_index).jurisdiction_code
1967: := '00-000-0000';
1968: pay_emp_action_arch.lrr_act_tab(ln_index).act_info1
1969: := ln_org_payment_method_id;
1970: pay_emp_action_arch.lrr_act_tab(ln_index).act_info2
1971: := ln_emp_payment_method_id;
1972: pay_emp_action_arch.lrr_act_tab(ln_index).act_info4
1966: pay_emp_action_arch.lrr_act_tab(ln_index).jurisdiction_code
1967: := '00-000-0000';
1968: pay_emp_action_arch.lrr_act_tab(ln_index).act_info1
1969: := ln_org_payment_method_id;
1970: pay_emp_action_arch.lrr_act_tab(ln_index).act_info2
1971: := ln_emp_payment_method_id;
1972: pay_emp_action_arch.lrr_act_tab(ln_index).act_info4
1973: := null;
1974: pay_emp_action_arch.lrr_act_tab(ln_index).act_info5
1968: pay_emp_action_arch.lrr_act_tab(ln_index).act_info1
1969: := ln_org_payment_method_id;
1970: pay_emp_action_arch.lrr_act_tab(ln_index).act_info2
1971: := ln_emp_payment_method_id;
1972: pay_emp_action_arch.lrr_act_tab(ln_index).act_info4
1973: := null;
1974: pay_emp_action_arch.lrr_act_tab(ln_index).act_info5
1975: := lv_segment1;
1976: pay_emp_action_arch.lrr_act_tab(ln_index).act_info6
1970: pay_emp_action_arch.lrr_act_tab(ln_index).act_info2
1971: := ln_emp_payment_method_id;
1972: pay_emp_action_arch.lrr_act_tab(ln_index).act_info4
1973: := null;
1974: pay_emp_action_arch.lrr_act_tab(ln_index).act_info5
1975: := lv_segment1;
1976: pay_emp_action_arch.lrr_act_tab(ln_index).act_info6
1977: := lv_segment2;
1978: pay_emp_action_arch.lrr_act_tab(ln_index).act_info7
1972: pay_emp_action_arch.lrr_act_tab(ln_index).act_info4
1973: := null;
1974: pay_emp_action_arch.lrr_act_tab(ln_index).act_info5
1975: := lv_segment1;
1976: pay_emp_action_arch.lrr_act_tab(ln_index).act_info6
1977: := lv_segment2;
1978: pay_emp_action_arch.lrr_act_tab(ln_index).act_info7
1979: := lv_segment3;
1980: pay_emp_action_arch.lrr_act_tab(ln_index).act_info8
1974: pay_emp_action_arch.lrr_act_tab(ln_index).act_info5
1975: := lv_segment1;
1976: pay_emp_action_arch.lrr_act_tab(ln_index).act_info6
1977: := lv_segment2;
1978: pay_emp_action_arch.lrr_act_tab(ln_index).act_info7
1979: := lv_segment3;
1980: pay_emp_action_arch.lrr_act_tab(ln_index).act_info8
1981: := lv_segment4;
1982: pay_emp_action_arch.lrr_act_tab(ln_index).act_info9
1976: pay_emp_action_arch.lrr_act_tab(ln_index).act_info6
1977: := lv_segment2;
1978: pay_emp_action_arch.lrr_act_tab(ln_index).act_info7
1979: := lv_segment3;
1980: pay_emp_action_arch.lrr_act_tab(ln_index).act_info8
1981: := lv_segment4;
1982: pay_emp_action_arch.lrr_act_tab(ln_index).act_info9
1983: := lv_segment5;
1984: pay_emp_action_arch.lrr_act_tab(ln_index).act_info10
1978: pay_emp_action_arch.lrr_act_tab(ln_index).act_info7
1979: := lv_segment3;
1980: pay_emp_action_arch.lrr_act_tab(ln_index).act_info8
1981: := lv_segment4;
1982: pay_emp_action_arch.lrr_act_tab(ln_index).act_info9
1983: := lv_segment5;
1984: pay_emp_action_arch.lrr_act_tab(ln_index).act_info10
1985: := lv_segment6;
1986: pay_emp_action_arch.lrr_act_tab(ln_index).act_info11
1980: pay_emp_action_arch.lrr_act_tab(ln_index).act_info8
1981: := lv_segment4;
1982: pay_emp_action_arch.lrr_act_tab(ln_index).act_info9
1983: := lv_segment5;
1984: pay_emp_action_arch.lrr_act_tab(ln_index).act_info10
1985: := lv_segment6;
1986: pay_emp_action_arch.lrr_act_tab(ln_index).act_info11
1987: := lv_segment7 ;
1988: pay_emp_action_arch.lrr_act_tab(ln_index).act_info12
1982: pay_emp_action_arch.lrr_act_tab(ln_index).act_info9
1983: := lv_segment5;
1984: pay_emp_action_arch.lrr_act_tab(ln_index).act_info10
1985: := lv_segment6;
1986: pay_emp_action_arch.lrr_act_tab(ln_index).act_info11
1987: := lv_segment7 ;
1988: pay_emp_action_arch.lrr_act_tab(ln_index).act_info12
1989: := lv_segment8;
1990: pay_emp_action_arch.lrr_act_tab(ln_index).act_info13
1984: pay_emp_action_arch.lrr_act_tab(ln_index).act_info10
1985: := lv_segment6;
1986: pay_emp_action_arch.lrr_act_tab(ln_index).act_info11
1987: := lv_segment7 ;
1988: pay_emp_action_arch.lrr_act_tab(ln_index).act_info12
1989: := lv_segment8;
1990: pay_emp_action_arch.lrr_act_tab(ln_index).act_info13
1991: := lv_segment9;
1992: pay_emp_action_arch.lrr_act_tab(ln_index).act_info14
1986: pay_emp_action_arch.lrr_act_tab(ln_index).act_info11
1987: := lv_segment7 ;
1988: pay_emp_action_arch.lrr_act_tab(ln_index).act_info12
1989: := lv_segment8;
1990: pay_emp_action_arch.lrr_act_tab(ln_index).act_info13
1991: := lv_segment9;
1992: pay_emp_action_arch.lrr_act_tab(ln_index).act_info14
1993: := lv_segment10;
1994: pay_emp_action_arch.lrr_act_tab(ln_index).act_info15
1988: pay_emp_action_arch.lrr_act_tab(ln_index).act_info12
1989: := lv_segment8;
1990: pay_emp_action_arch.lrr_act_tab(ln_index).act_info13
1991: := lv_segment9;
1992: pay_emp_action_arch.lrr_act_tab(ln_index).act_info14
1993: := lv_segment10;
1994: pay_emp_action_arch.lrr_act_tab(ln_index).act_info15
1995: := ln_pre_payment_id;
1996: pay_emp_action_arch.lrr_act_tab(ln_index).act_info16
1990: pay_emp_action_arch.lrr_act_tab(ln_index).act_info13
1991: := lv_segment9;
1992: pay_emp_action_arch.lrr_act_tab(ln_index).act_info14
1993: := lv_segment10;
1994: pay_emp_action_arch.lrr_act_tab(ln_index).act_info15
1995: := ln_pre_payment_id;
1996: pay_emp_action_arch.lrr_act_tab(ln_index).act_info16
1997: := fnd_number.number_to_canonical(ln_value); /* Bug 3311866*/
1998: pay_emp_action_arch.lrr_act_tab(ln_index).act_info17
1992: pay_emp_action_arch.lrr_act_tab(ln_index).act_info14
1993: := lv_segment10;
1994: pay_emp_action_arch.lrr_act_tab(ln_index).act_info15
1995: := ln_pre_payment_id;
1996: pay_emp_action_arch.lrr_act_tab(ln_index).act_info16
1997: := fnd_number.number_to_canonical(ln_value); /* Bug 3311866*/
1998: pay_emp_action_arch.lrr_act_tab(ln_index).act_info17
1999: := p_pre_pay_action_id;
2000: pay_emp_action_arch.lrr_act_tab(ln_index).act_info18
1994: pay_emp_action_arch.lrr_act_tab(ln_index).act_info15
1995: := ln_pre_payment_id;
1996: pay_emp_action_arch.lrr_act_tab(ln_index).act_info16
1997: := fnd_number.number_to_canonical(ln_value); /* Bug 3311866*/
1998: pay_emp_action_arch.lrr_act_tab(ln_index).act_info17
1999: := p_pre_pay_action_id;
2000: pay_emp_action_arch.lrr_act_tab(ln_index).act_info18
2001: := lv_org_payment_method_name;
2002: end loop;
1996: pay_emp_action_arch.lrr_act_tab(ln_index).act_info16
1997: := fnd_number.number_to_canonical(ln_value); /* Bug 3311866*/
1998: pay_emp_action_arch.lrr_act_tab(ln_index).act_info17
1999: := p_pre_pay_action_id;
2000: pay_emp_action_arch.lrr_act_tab(ln_index).act_info18
2001: := lv_org_payment_method_name;
2002: end loop;
2003: close c_net_pay;
2004: hr_utility.set_location(gv_package || lv_procedure_name,100);
2127: hr_utility.trace('p_ppp_source_action_id = '|| p_ppp_source_action_id);
2128: k := 0;
2129:
2130: -- Check if Multi assignment payment is enabled
2131: if pay_emp_action_arch.gv_multi_payroll_pymt is null then
2132: pay_emp_action_arch.gv_multi_payroll_pymt
2133: := pay_emp_action_arch.get_multi_assignment_flag(
2134: p_payroll_id => p_payroll_id
2135: ,p_effective_date => p_curr_pymt_eff_date);
2128: k := 0;
2129:
2130: -- Check if Multi assignment payment is enabled
2131: if pay_emp_action_arch.gv_multi_payroll_pymt is null then
2132: pay_emp_action_arch.gv_multi_payroll_pymt
2133: := pay_emp_action_arch.get_multi_assignment_flag(
2134: p_payroll_id => p_payroll_id
2135: ,p_effective_date => p_curr_pymt_eff_date);
2136: end if;
2129:
2130: -- Check if Multi assignment payment is enabled
2131: if pay_emp_action_arch.gv_multi_payroll_pymt is null then
2132: pay_emp_action_arch.gv_multi_payroll_pymt
2133: := pay_emp_action_arch.get_multi_assignment_flag(
2134: p_payroll_id => p_payroll_id
2135: ,p_effective_date => p_curr_pymt_eff_date);
2136: end if;
2137: hr_utility.set_location(gv_package || lv_procedure_name,20);
2135: ,p_effective_date => p_curr_pymt_eff_date);
2136: end if;
2137: hr_utility.set_location(gv_package || lv_procedure_name,20);
2138:
2139: if nvl(pay_emp_action_arch.gv_multi_payroll_pymt, 'N') = 'Y' then
2140: -- If Multi Assignment Payment is enabled, get the child prepayment
2141: -- actions as payment information is stored against child.
2142: -- Insert this data in pl/sql table.
2143: for cval in c_child_action(p_pre_pay_action_id, p_assignment_id) loop
2188: if c_third_party_pay%notfound then
2189: exit;
2190: end if;
2191:
2192: ln_index := pay_emp_action_arch.lrr_act_tab.count;
2193:
2194: hr_utility.trace('ln_index in get_3rdparty_pay_distribution proc is '
2195: || pay_emp_action_arch.lrr_act_tab.count);
2196:
2191:
2192: ln_index := pay_emp_action_arch.lrr_act_tab.count;
2193:
2194: hr_utility.trace('ln_index in get_3rdparty_pay_distribution proc is '
2195: || pay_emp_action_arch.lrr_act_tab.count);
2196:
2197: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category
2198: := 'EMPLOYEE THIRD PARTY PAYMENTS';
2199: pay_emp_action_arch.lrr_act_tab(ln_index).jurisdiction_code
2193:
2194: hr_utility.trace('ln_index in get_3rdparty_pay_distribution proc is '
2195: || pay_emp_action_arch.lrr_act_tab.count);
2196:
2197: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category
2198: := 'EMPLOYEE THIRD PARTY PAYMENTS';
2199: pay_emp_action_arch.lrr_act_tab(ln_index).jurisdiction_code
2200: := '00-000-0000';
2201: pay_emp_action_arch.lrr_act_tab(ln_index).act_info1
2195: || pay_emp_action_arch.lrr_act_tab.count);
2196:
2197: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category
2198: := 'EMPLOYEE THIRD PARTY PAYMENTS';
2199: pay_emp_action_arch.lrr_act_tab(ln_index).jurisdiction_code
2200: := '00-000-0000';
2201: pay_emp_action_arch.lrr_act_tab(ln_index).act_info1
2202: := ln_org_payment_method_id;
2203: hr_utility.trace('ln_org_payment_method_id'||ln_org_payment_method_id);
2197: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category
2198: := 'EMPLOYEE THIRD PARTY PAYMENTS';
2199: pay_emp_action_arch.lrr_act_tab(ln_index).jurisdiction_code
2200: := '00-000-0000';
2201: pay_emp_action_arch.lrr_act_tab(ln_index).act_info1
2202: := ln_org_payment_method_id;
2203: hr_utility.trace('ln_org_payment_method_id'||ln_org_payment_method_id);
2204: pay_emp_action_arch.lrr_act_tab(ln_index).act_info2
2205: := ln_emp_payment_method_id;
2200: := '00-000-0000';
2201: pay_emp_action_arch.lrr_act_tab(ln_index).act_info1
2202: := ln_org_payment_method_id;
2203: hr_utility.trace('ln_org_payment_method_id'||ln_org_payment_method_id);
2204: pay_emp_action_arch.lrr_act_tab(ln_index).act_info2
2205: := ln_emp_payment_method_id;
2206: pay_emp_action_arch.lrr_act_tab(ln_index).act_info4
2207: := null;
2208: pay_emp_action_arch.lrr_act_tab(ln_index).act_info5
2202: := ln_org_payment_method_id;
2203: hr_utility.trace('ln_org_payment_method_id'||ln_org_payment_method_id);
2204: pay_emp_action_arch.lrr_act_tab(ln_index).act_info2
2205: := ln_emp_payment_method_id;
2206: pay_emp_action_arch.lrr_act_tab(ln_index).act_info4
2207: := null;
2208: pay_emp_action_arch.lrr_act_tab(ln_index).act_info5
2209: := lv_segment1;
2210: pay_emp_action_arch.lrr_act_tab(ln_index).act_info6
2204: pay_emp_action_arch.lrr_act_tab(ln_index).act_info2
2205: := ln_emp_payment_method_id;
2206: pay_emp_action_arch.lrr_act_tab(ln_index).act_info4
2207: := null;
2208: pay_emp_action_arch.lrr_act_tab(ln_index).act_info5
2209: := lv_segment1;
2210: pay_emp_action_arch.lrr_act_tab(ln_index).act_info6
2211: := lv_segment2;
2212: pay_emp_action_arch.lrr_act_tab(ln_index).act_info7
2206: pay_emp_action_arch.lrr_act_tab(ln_index).act_info4
2207: := null;
2208: pay_emp_action_arch.lrr_act_tab(ln_index).act_info5
2209: := lv_segment1;
2210: pay_emp_action_arch.lrr_act_tab(ln_index).act_info6
2211: := lv_segment2;
2212: pay_emp_action_arch.lrr_act_tab(ln_index).act_info7
2213: := lv_segment3;
2214: pay_emp_action_arch.lrr_act_tab(ln_index).act_info8
2208: pay_emp_action_arch.lrr_act_tab(ln_index).act_info5
2209: := lv_segment1;
2210: pay_emp_action_arch.lrr_act_tab(ln_index).act_info6
2211: := lv_segment2;
2212: pay_emp_action_arch.lrr_act_tab(ln_index).act_info7
2213: := lv_segment3;
2214: pay_emp_action_arch.lrr_act_tab(ln_index).act_info8
2215: := lv_segment4;
2216: pay_emp_action_arch.lrr_act_tab(ln_index).act_info9
2210: pay_emp_action_arch.lrr_act_tab(ln_index).act_info6
2211: := lv_segment2;
2212: pay_emp_action_arch.lrr_act_tab(ln_index).act_info7
2213: := lv_segment3;
2214: pay_emp_action_arch.lrr_act_tab(ln_index).act_info8
2215: := lv_segment4;
2216: pay_emp_action_arch.lrr_act_tab(ln_index).act_info9
2217: := lv_segment5;
2218: pay_emp_action_arch.lrr_act_tab(ln_index).act_info10
2212: pay_emp_action_arch.lrr_act_tab(ln_index).act_info7
2213: := lv_segment3;
2214: pay_emp_action_arch.lrr_act_tab(ln_index).act_info8
2215: := lv_segment4;
2216: pay_emp_action_arch.lrr_act_tab(ln_index).act_info9
2217: := lv_segment5;
2218: pay_emp_action_arch.lrr_act_tab(ln_index).act_info10
2219: := lv_segment6;
2220: pay_emp_action_arch.lrr_act_tab(ln_index).act_info11
2214: pay_emp_action_arch.lrr_act_tab(ln_index).act_info8
2215: := lv_segment4;
2216: pay_emp_action_arch.lrr_act_tab(ln_index).act_info9
2217: := lv_segment5;
2218: pay_emp_action_arch.lrr_act_tab(ln_index).act_info10
2219: := lv_segment6;
2220: pay_emp_action_arch.lrr_act_tab(ln_index).act_info11
2221: := lv_segment7 ;
2222: pay_emp_action_arch.lrr_act_tab(ln_index).act_info12
2216: pay_emp_action_arch.lrr_act_tab(ln_index).act_info9
2217: := lv_segment5;
2218: pay_emp_action_arch.lrr_act_tab(ln_index).act_info10
2219: := lv_segment6;
2220: pay_emp_action_arch.lrr_act_tab(ln_index).act_info11
2221: := lv_segment7 ;
2222: pay_emp_action_arch.lrr_act_tab(ln_index).act_info12
2223: := lv_segment8;
2224: pay_emp_action_arch.lrr_act_tab(ln_index).act_info13
2218: pay_emp_action_arch.lrr_act_tab(ln_index).act_info10
2219: := lv_segment6;
2220: pay_emp_action_arch.lrr_act_tab(ln_index).act_info11
2221: := lv_segment7 ;
2222: pay_emp_action_arch.lrr_act_tab(ln_index).act_info12
2223: := lv_segment8;
2224: pay_emp_action_arch.lrr_act_tab(ln_index).act_info13
2225: := lv_segment9;
2226: pay_emp_action_arch.lrr_act_tab(ln_index).act_info14
2220: pay_emp_action_arch.lrr_act_tab(ln_index).act_info11
2221: := lv_segment7 ;
2222: pay_emp_action_arch.lrr_act_tab(ln_index).act_info12
2223: := lv_segment8;
2224: pay_emp_action_arch.lrr_act_tab(ln_index).act_info13
2225: := lv_segment9;
2226: pay_emp_action_arch.lrr_act_tab(ln_index).act_info14
2227: := lv_segment10;
2228: pay_emp_action_arch.lrr_act_tab(ln_index).act_info15
2222: pay_emp_action_arch.lrr_act_tab(ln_index).act_info12
2223: := lv_segment8;
2224: pay_emp_action_arch.lrr_act_tab(ln_index).act_info13
2225: := lv_segment9;
2226: pay_emp_action_arch.lrr_act_tab(ln_index).act_info14
2227: := lv_segment10;
2228: pay_emp_action_arch.lrr_act_tab(ln_index).act_info15
2229: := ln_pre_payment_id;
2230: pay_emp_action_arch.lrr_act_tab(ln_index).act_info16
2224: pay_emp_action_arch.lrr_act_tab(ln_index).act_info13
2225: := lv_segment9;
2226: pay_emp_action_arch.lrr_act_tab(ln_index).act_info14
2227: := lv_segment10;
2228: pay_emp_action_arch.lrr_act_tab(ln_index).act_info15
2229: := ln_pre_payment_id;
2230: pay_emp_action_arch.lrr_act_tab(ln_index).act_info16
2231: := fnd_number.number_to_canonical(ln_value); /* Bug 3311866*/
2232: pay_emp_action_arch.lrr_act_tab(ln_index).act_info17
2226: pay_emp_action_arch.lrr_act_tab(ln_index).act_info14
2227: := lv_segment10;
2228: pay_emp_action_arch.lrr_act_tab(ln_index).act_info15
2229: := ln_pre_payment_id;
2230: pay_emp_action_arch.lrr_act_tab(ln_index).act_info16
2231: := fnd_number.number_to_canonical(ln_value); /* Bug 3311866*/
2232: pay_emp_action_arch.lrr_act_tab(ln_index).act_info17
2233: := ltt_actions(j);
2234: pay_emp_action_arch.lrr_act_tab(ln_index).act_info18
2228: pay_emp_action_arch.lrr_act_tab(ln_index).act_info15
2229: := ln_pre_payment_id;
2230: pay_emp_action_arch.lrr_act_tab(ln_index).act_info16
2231: := fnd_number.number_to_canonical(ln_value); /* Bug 3311866*/
2232: pay_emp_action_arch.lrr_act_tab(ln_index).act_info17
2233: := ltt_actions(j);
2234: pay_emp_action_arch.lrr_act_tab(ln_index).act_info18
2235: := lv_org_payment_method_name;
2236: end loop;
2230: pay_emp_action_arch.lrr_act_tab(ln_index).act_info16
2231: := fnd_number.number_to_canonical(ln_value); /* Bug 3311866*/
2232: pay_emp_action_arch.lrr_act_tab(ln_index).act_info17
2233: := ltt_actions(j);
2234: pay_emp_action_arch.lrr_act_tab(ln_index).act_info18
2235: := lv_org_payment_method_name;
2236: end loop;
2237: close c_third_party_pay;
2238: end loop;
2293: end if;
2294:
2295:
2296: hr_utility.set_location(gv_package || lv_procedure_name, 40);
2297: if pay_emp_action_arch.ltr_ppa_arch.count > 0 then
2298: for i in pay_emp_action_arch.ltr_ppa_arch.first ..
2299: pay_emp_action_arch.ltr_ppa_arch.last loop
2300: if pay_emp_action_arch.ltr_ppa_arch(i).act_info1
2301: = p_organization_id and
2294:
2295:
2296: hr_utility.set_location(gv_package || lv_procedure_name, 40);
2297: if pay_emp_action_arch.ltr_ppa_arch.count > 0 then
2298: for i in pay_emp_action_arch.ltr_ppa_arch.first ..
2299: pay_emp_action_arch.ltr_ppa_arch.last loop
2300: if pay_emp_action_arch.ltr_ppa_arch(i).act_info1
2301: = p_organization_id and
2302: pay_emp_action_arch.ltr_ppa_arch(i).act_info2
2295:
2296: hr_utility.set_location(gv_package || lv_procedure_name, 40);
2297: if pay_emp_action_arch.ltr_ppa_arch.count > 0 then
2298: for i in pay_emp_action_arch.ltr_ppa_arch.first ..
2299: pay_emp_action_arch.ltr_ppa_arch.last loop
2300: if pay_emp_action_arch.ltr_ppa_arch(i).act_info1
2301: = p_organization_id and
2302: pay_emp_action_arch.ltr_ppa_arch(i).act_info2
2303: = 'MESG' and
2296: hr_utility.set_location(gv_package || lv_procedure_name, 40);
2297: if pay_emp_action_arch.ltr_ppa_arch.count > 0 then
2298: for i in pay_emp_action_arch.ltr_ppa_arch.first ..
2299: pay_emp_action_arch.ltr_ppa_arch.last loop
2300: if pay_emp_action_arch.ltr_ppa_arch(i).act_info1
2301: = p_organization_id and
2302: pay_emp_action_arch.ltr_ppa_arch(i).act_info2
2303: = 'MESG' and
2304: pay_emp_action_arch.ltr_ppa_arch(i).act_info6
2298: for i in pay_emp_action_arch.ltr_ppa_arch.first ..
2299: pay_emp_action_arch.ltr_ppa_arch.last loop
2300: if pay_emp_action_arch.ltr_ppa_arch(i).act_info1
2301: = p_organization_id and
2302: pay_emp_action_arch.ltr_ppa_arch(i).act_info2
2303: = 'MESG' and
2304: pay_emp_action_arch.ltr_ppa_arch(i).act_info6
2305: = lv_org_information6 then
2306: lv_exists := 'Y';
2300: if pay_emp_action_arch.ltr_ppa_arch(i).act_info1
2301: = p_organization_id and
2302: pay_emp_action_arch.ltr_ppa_arch(i).act_info2
2303: = 'MESG' and
2304: pay_emp_action_arch.ltr_ppa_arch(i).act_info6
2305: = lv_org_information6 then
2306: lv_exists := 'Y';
2307: exit;
2308: end if;
2309: end loop;
2310: end if;
2311:
2312: if lv_exists = 'N' then
2313: ln_index := pay_emp_action_arch.ltr_ppa_arch.count;
2314: pay_emp_action_arch.ltr_ppa_arch(ln_index).action_info_category
2315: := 'EMPLOYEE OTHER INFORMATION';
2316: pay_emp_action_arch.ltr_ppa_arch(ln_index).jurisdiction_code
2317: := '00-000-0000';
2310: end if;
2311:
2312: if lv_exists = 'N' then
2313: ln_index := pay_emp_action_arch.ltr_ppa_arch.count;
2314: pay_emp_action_arch.ltr_ppa_arch(ln_index).action_info_category
2315: := 'EMPLOYEE OTHER INFORMATION';
2316: pay_emp_action_arch.ltr_ppa_arch(ln_index).jurisdiction_code
2317: := '00-000-0000';
2318: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info1
2312: if lv_exists = 'N' then
2313: ln_index := pay_emp_action_arch.ltr_ppa_arch.count;
2314: pay_emp_action_arch.ltr_ppa_arch(ln_index).action_info_category
2315: := 'EMPLOYEE OTHER INFORMATION';
2316: pay_emp_action_arch.ltr_ppa_arch(ln_index).jurisdiction_code
2317: := '00-000-0000';
2318: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info1
2319: := p_organization_id;
2320: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info2
2314: pay_emp_action_arch.ltr_ppa_arch(ln_index).action_info_category
2315: := 'EMPLOYEE OTHER INFORMATION';
2316: pay_emp_action_arch.ltr_ppa_arch(ln_index).jurisdiction_code
2317: := '00-000-0000';
2318: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info1
2319: := p_organization_id;
2320: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info2
2321: := 'MESG';
2322: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info4
2316: pay_emp_action_arch.ltr_ppa_arch(ln_index).jurisdiction_code
2317: := '00-000-0000';
2318: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info1
2319: := p_organization_id;
2320: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info2
2321: := 'MESG';
2322: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info4
2323: := nvl(lv_org_information7,lv_org_information4) ;
2324: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info5
2318: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info1
2319: := p_organization_id;
2320: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info2
2321: := 'MESG';
2322: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info4
2323: := nvl(lv_org_information7,lv_org_information4) ;
2324: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info5
2325: := lv_org_information5;
2326: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info6
2320: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info2
2321: := 'MESG';
2322: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info4
2323: := nvl(lv_org_information7,lv_org_information4) ;
2324: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info5
2325: := lv_org_information5;
2326: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info6
2327: := lv_org_information6;
2328: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info13
2322: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info4
2323: := nvl(lv_org_information7,lv_org_information4) ;
2324: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info5
2325: := lv_org_information5;
2326: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info6
2327: := lv_org_information6;
2328: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info13
2329: := lv_org_information_cntxt; ----Bug 7115367
2330: end if;
2324: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info5
2325: := lv_org_information5;
2326: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info6
2327: := lv_org_information6;
2328: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info13
2329: := lv_org_information_cntxt; ----Bug 7115367
2330: end if;
2331: end loop ;
2332: close c_get_other_info;
2351: exit;
2352: end if;
2353:
2354: hr_utility.set_location(gv_package || lv_procedure_name, 130);
2355: if pay_emp_action_arch.ltr_ppa_arch.count > 0 then
2356: for i in pay_emp_action_arch.ltr_ppa_arch.first ..
2357: pay_emp_action_arch.ltr_ppa_arch.last loop
2358: if pay_emp_action_arch.ltr_ppa_arch(i).act_info1
2359: = p_business_group_id and
2352: end if;
2353:
2354: hr_utility.set_location(gv_package || lv_procedure_name, 130);
2355: if pay_emp_action_arch.ltr_ppa_arch.count > 0 then
2356: for i in pay_emp_action_arch.ltr_ppa_arch.first ..
2357: pay_emp_action_arch.ltr_ppa_arch.last loop
2358: if pay_emp_action_arch.ltr_ppa_arch(i).act_info1
2359: = p_business_group_id and
2360: pay_emp_action_arch.ltr_ppa_arch(i).act_info2
2353:
2354: hr_utility.set_location(gv_package || lv_procedure_name, 130);
2355: if pay_emp_action_arch.ltr_ppa_arch.count > 0 then
2356: for i in pay_emp_action_arch.ltr_ppa_arch.first ..
2357: pay_emp_action_arch.ltr_ppa_arch.last loop
2358: if pay_emp_action_arch.ltr_ppa_arch(i).act_info1
2359: = p_business_group_id and
2360: pay_emp_action_arch.ltr_ppa_arch(i).act_info2
2361: = 'MESG' and
2354: hr_utility.set_location(gv_package || lv_procedure_name, 130);
2355: if pay_emp_action_arch.ltr_ppa_arch.count > 0 then
2356: for i in pay_emp_action_arch.ltr_ppa_arch.first ..
2357: pay_emp_action_arch.ltr_ppa_arch.last loop
2358: if pay_emp_action_arch.ltr_ppa_arch(i).act_info1
2359: = p_business_group_id and
2360: pay_emp_action_arch.ltr_ppa_arch(i).act_info2
2361: = 'MESG' and
2362: pay_emp_action_arch.ltr_ppa_arch(i).act_info6
2356: for i in pay_emp_action_arch.ltr_ppa_arch.first ..
2357: pay_emp_action_arch.ltr_ppa_arch.last loop
2358: if pay_emp_action_arch.ltr_ppa_arch(i).act_info1
2359: = p_business_group_id and
2360: pay_emp_action_arch.ltr_ppa_arch(i).act_info2
2361: = 'MESG' and
2362: pay_emp_action_arch.ltr_ppa_arch(i).act_info6
2363: = lv_org_information6 then
2364: lv_exists := 'Y';
2358: if pay_emp_action_arch.ltr_ppa_arch(i).act_info1
2359: = p_business_group_id and
2360: pay_emp_action_arch.ltr_ppa_arch(i).act_info2
2361: = 'MESG' and
2362: pay_emp_action_arch.ltr_ppa_arch(i).act_info6
2363: = lv_org_information6 then
2364: lv_exists := 'Y';
2365: exit;
2366: end if;
2367: end loop;
2368: end if;
2369:
2370: if lv_exists = 'N' then
2371: ln_index := pay_emp_action_arch.ltr_ppa_arch.count;
2372: pay_emp_action_arch.ltr_ppa_arch(ln_index).action_info_category
2373: := 'EMPLOYEE OTHER INFORMATION';
2374: pay_emp_action_arch.ltr_ppa_arch(ln_index).jurisdiction_code
2375: := '00-000-0000';
2368: end if;
2369:
2370: if lv_exists = 'N' then
2371: ln_index := pay_emp_action_arch.ltr_ppa_arch.count;
2372: pay_emp_action_arch.ltr_ppa_arch(ln_index).action_info_category
2373: := 'EMPLOYEE OTHER INFORMATION';
2374: pay_emp_action_arch.ltr_ppa_arch(ln_index).jurisdiction_code
2375: := '00-000-0000';
2376: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info1
2370: if lv_exists = 'N' then
2371: ln_index := pay_emp_action_arch.ltr_ppa_arch.count;
2372: pay_emp_action_arch.ltr_ppa_arch(ln_index).action_info_category
2373: := 'EMPLOYEE OTHER INFORMATION';
2374: pay_emp_action_arch.ltr_ppa_arch(ln_index).jurisdiction_code
2375: := '00-000-0000';
2376: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info1
2377: := p_business_group_id;
2378: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info2
2372: pay_emp_action_arch.ltr_ppa_arch(ln_index).action_info_category
2373: := 'EMPLOYEE OTHER INFORMATION';
2374: pay_emp_action_arch.ltr_ppa_arch(ln_index).jurisdiction_code
2375: := '00-000-0000';
2376: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info1
2377: := p_business_group_id;
2378: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info2
2379: := 'MESG';
2380: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info4
2374: pay_emp_action_arch.ltr_ppa_arch(ln_index).jurisdiction_code
2375: := '00-000-0000';
2376: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info1
2377: := p_business_group_id;
2378: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info2
2379: := 'MESG';
2380: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info4
2381: := nvl(lv_org_information7,lv_org_information4) ;
2382: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info5
2376: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info1
2377: := p_business_group_id;
2378: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info2
2379: := 'MESG';
2380: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info4
2381: := nvl(lv_org_information7,lv_org_information4) ;
2382: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info5
2383: := lv_org_information5 ;
2384: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info6
2378: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info2
2379: := 'MESG';
2380: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info4
2381: := nvl(lv_org_information7,lv_org_information4) ;
2382: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info5
2383: := lv_org_information5 ;
2384: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info6
2385: := lv_org_information6;
2386: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info13
2380: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info4
2381: := nvl(lv_org_information7,lv_org_information4) ;
2382: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info5
2383: := lv_org_information5 ;
2384: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info6
2385: := lv_org_information6;
2386: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info13
2387: := lv_org_information_cntxt; --Bug 7115367
2388: end if;
2382: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info5
2383: := lv_org_information5 ;
2384: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info6
2385: := lv_org_information6;
2386: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info13
2387: := lv_org_information_cntxt; --Bug 7115367
2388: end if;
2389: end loop ;
2390: close c_get_other_info;
2445: ,lv_er_telephone;
2446: close c_addr_line;
2447: hr_utility.set_location(gv_package || lv_procedure_name, 250);
2448:
2449: if pay_emp_action_arch.ltr_ppa_arch.count > 0 then
2450: for i in pay_emp_action_arch.ltr_ppa_arch.first ..
2451: pay_emp_action_arch.ltr_ppa_arch.last loop
2452: if pay_emp_action_arch.ltr_ppa_arch(i).act_info1
2453: = p_organization_id and
2446: close c_addr_line;
2447: hr_utility.set_location(gv_package || lv_procedure_name, 250);
2448:
2449: if pay_emp_action_arch.ltr_ppa_arch.count > 0 then
2450: for i in pay_emp_action_arch.ltr_ppa_arch.first ..
2451: pay_emp_action_arch.ltr_ppa_arch.last loop
2452: if pay_emp_action_arch.ltr_ppa_arch(i).act_info1
2453: = p_organization_id and
2454: pay_emp_action_arch.ltr_ppa_arch(i).act_info14
2447: hr_utility.set_location(gv_package || lv_procedure_name, 250);
2448:
2449: if pay_emp_action_arch.ltr_ppa_arch.count > 0 then
2450: for i in pay_emp_action_arch.ltr_ppa_arch.first ..
2451: pay_emp_action_arch.ltr_ppa_arch.last loop
2452: if pay_emp_action_arch.ltr_ppa_arch(i).act_info1
2453: = p_organization_id and
2454: pay_emp_action_arch.ltr_ppa_arch(i).act_info14
2455: = 'Employer Address' then
2448:
2449: if pay_emp_action_arch.ltr_ppa_arch.count > 0 then
2450: for i in pay_emp_action_arch.ltr_ppa_arch.first ..
2451: pay_emp_action_arch.ltr_ppa_arch.last loop
2452: if pay_emp_action_arch.ltr_ppa_arch(i).act_info1
2453: = p_organization_id and
2454: pay_emp_action_arch.ltr_ppa_arch(i).act_info14
2455: = 'Employer Address' then
2456: lv_exists := 'Y';
2450: for i in pay_emp_action_arch.ltr_ppa_arch.first ..
2451: pay_emp_action_arch.ltr_ppa_arch.last loop
2452: if pay_emp_action_arch.ltr_ppa_arch(i).act_info1
2453: = p_organization_id and
2454: pay_emp_action_arch.ltr_ppa_arch(i).act_info14
2455: = 'Employer Address' then
2456: lv_exists := 'Y';
2457: exit;
2458: end if;
2460: end if;
2461:
2462: if lv_exists = 'N' then
2463: hr_utility.set_location(gv_package || lv_procedure_name, 260);
2464: ln_index := pay_emp_action_arch.ltr_ppa_arch.count;
2465:
2466: pay_emp_action_arch.ltr_ppa_arch(ln_index).action_info_category
2467: := 'ADDRESS DETAILS';
2468: pay_emp_action_arch.ltr_ppa_arch(ln_index).jurisdiction_code
2462: if lv_exists = 'N' then
2463: hr_utility.set_location(gv_package || lv_procedure_name, 260);
2464: ln_index := pay_emp_action_arch.ltr_ppa_arch.count;
2465:
2466: pay_emp_action_arch.ltr_ppa_arch(ln_index).action_info_category
2467: := 'ADDRESS DETAILS';
2468: pay_emp_action_arch.ltr_ppa_arch(ln_index).jurisdiction_code
2469: := '00-000-0000';
2470: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info1
2464: ln_index := pay_emp_action_arch.ltr_ppa_arch.count;
2465:
2466: pay_emp_action_arch.ltr_ppa_arch(ln_index).action_info_category
2467: := 'ADDRESS DETAILS';
2468: pay_emp_action_arch.ltr_ppa_arch(ln_index).jurisdiction_code
2469: := '00-000-0000';
2470: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info1
2471: := p_organization_id;
2472: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info5
2466: pay_emp_action_arch.ltr_ppa_arch(ln_index).action_info_category
2467: := 'ADDRESS DETAILS';
2468: pay_emp_action_arch.ltr_ppa_arch(ln_index).jurisdiction_code
2469: := '00-000-0000';
2470: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info1
2471: := p_organization_id;
2472: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info5
2473: := lv_er_address_line_1 ;
2474: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info6
2468: pay_emp_action_arch.ltr_ppa_arch(ln_index).jurisdiction_code
2469: := '00-000-0000';
2470: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info1
2471: := p_organization_id;
2472: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info5
2473: := lv_er_address_line_1 ;
2474: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info6
2475: := lv_er_address_line_2;
2476: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info7
2470: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info1
2471: := p_organization_id;
2472: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info5
2473: := lv_er_address_line_1 ;
2474: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info6
2475: := lv_er_address_line_2;
2476: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info7
2477: := lv_er_address_line_3;
2478: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info8
2472: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info5
2473: := lv_er_address_line_1 ;
2474: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info6
2475: := lv_er_address_line_2;
2476: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info7
2477: := lv_er_address_line_3;
2478: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info8
2479: := lv_er_town_or_city;
2480: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info9
2474: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info6
2475: := lv_er_address_line_2;
2476: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info7
2477: := lv_er_address_line_3;
2478: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info8
2479: := lv_er_town_or_city;
2480: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info9
2481: := lv_er_region_1;
2482: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info10
2476: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info7
2477: := lv_er_address_line_3;
2478: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info8
2479: := lv_er_town_or_city;
2480: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info9
2481: := lv_er_region_1;
2482: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info10
2483: := lv_er_region_2;
2484: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info11
2478: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info8
2479: := lv_er_town_or_city;
2480: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info9
2481: := lv_er_region_1;
2482: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info10
2483: := lv_er_region_2;
2484: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info11
2485: := lv_er_region_3 ;
2486: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info12
2480: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info9
2481: := lv_er_region_1;
2482: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info10
2483: := lv_er_region_2;
2484: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info11
2485: := lv_er_region_3 ;
2486: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info12
2487: := lv_er_postal_code;
2488: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info13
2482: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info10
2483: := lv_er_region_2;
2484: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info11
2485: := lv_er_region_3 ;
2486: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info12
2487: := lv_er_postal_code;
2488: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info13
2489: := lv_er_country;
2490: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info14
2484: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info11
2485: := lv_er_region_3 ;
2486: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info12
2487: := lv_er_postal_code;
2488: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info13
2489: := lv_er_country;
2490: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info14
2491: := lv_ee_or_er;
2492: end if;
2486: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info12
2487: := lv_er_postal_code;
2488: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info13
2489: := lv_er_country;
2490: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info14
2491: := lv_ee_or_er;
2492: end if;
2493:
2494: END get_org_address;
2545:
2546: hr_utility.set_location(gv_package || lv_procedure_name, 140);
2547:
2548: -- insert rows in pay_action_information table
2549: if pay_emp_action_arch.ltr_ppa_arch.count > 0 then
2550: insert_rows_thro_api_process(
2551: p_action_context_id => p_payroll_action_id
2552: ,p_action_context_type => 'PA'
2553: ,p_assignment_id => null
2552: ,p_action_context_type => 'PA'
2553: ,p_assignment_id => null
2554: ,p_tax_unit_id => null
2555: ,p_curr_pymt_eff_date => p_effective_date
2556: ,p_tab_rec_data => pay_emp_action_arch.ltr_ppa_arch
2557: );
2558: end if;
2559: EXCEPTION
2560: when others then
2665:
2666: hr_utility.set_location(gv_package || lv_procedure_name, 100);
2667:
2668: -- insert rows in pay_action_information table
2669: if pay_emp_action_arch.ltr_ppa_arch.count > 0 then
2670: insert_rows_thro_api_process(
2671: p_action_context_id => p_payroll_action_id
2672: ,p_action_context_type => 'PA'
2673: ,p_assignment_id => null
2672: ,p_action_context_type => 'PA'
2673: ,p_assignment_id => null
2674: ,p_tax_unit_id => null
2675: ,p_curr_pymt_eff_date => p_effective_date
2676: ,p_tab_rec_data => pay_emp_action_arch.ltr_ppa_arch
2677: );
2678: end if;
2679: hr_utility.set_location(gv_package || lv_procedure_name, 150);
2680:
2984: fetch c_step into lv_step;
2985: close c_step;
2986: end if;
2987:
2988: ln_index := pay_emp_action_arch.lrr_act_tab.count;
2989:
2990: hr_utility.trace('ln_index in get_personal_information proc is '
2991: || pay_emp_action_arch.lrr_act_tab.count);
2992:
2987:
2988: ln_index := pay_emp_action_arch.lrr_act_tab.count;
2989:
2990: hr_utility.trace('ln_index in get_personal_information proc is '
2991: || pay_emp_action_arch.lrr_act_tab.count);
2992:
2993: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category
2994: := 'EMPLOYEE DETAILS';
2995: pay_emp_action_arch.lrr_act_tab(ln_index).jurisdiction_code
2989:
2990: hr_utility.trace('ln_index in get_personal_information proc is '
2991: || pay_emp_action_arch.lrr_act_tab.count);
2992:
2993: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category
2994: := 'EMPLOYEE DETAILS';
2995: pay_emp_action_arch.lrr_act_tab(ln_index).jurisdiction_code
2996: := '00-000-0000';
2997: pay_emp_action_arch.lrr_act_tab(ln_index).act_info1
2991: || pay_emp_action_arch.lrr_act_tab.count);
2992:
2993: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category
2994: := 'EMPLOYEE DETAILS';
2995: pay_emp_action_arch.lrr_act_tab(ln_index).jurisdiction_code
2996: := '00-000-0000';
2997: pay_emp_action_arch.lrr_act_tab(ln_index).act_info1
2998: := lv_full_name;
2999: hr_utility.trace('lv_full_name is'||lv_full_name);
2993: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category
2994: := 'EMPLOYEE DETAILS';
2995: pay_emp_action_arch.lrr_act_tab(ln_index).jurisdiction_code
2996: := '00-000-0000';
2997: pay_emp_action_arch.lrr_act_tab(ln_index).act_info1
2998: := lv_full_name;
2999: hr_utility.trace('lv_full_name is'||lv_full_name);
3000: pay_emp_action_arch.lrr_act_tab(ln_index).act_info2
3001: := ln_organization_id;
2996: := '00-000-0000';
2997: pay_emp_action_arch.lrr_act_tab(ln_index).act_info1
2998: := lv_full_name;
2999: hr_utility.trace('lv_full_name is'||lv_full_name);
3000: pay_emp_action_arch.lrr_act_tab(ln_index).act_info2
3001: := ln_organization_id;
3002:
3003: pay_emp_action_arch.lrr_act_tab(ln_index).act_info4
3004: := lv_national_identifier ;
2999: hr_utility.trace('lv_full_name is'||lv_full_name);
3000: pay_emp_action_arch.lrr_act_tab(ln_index).act_info2
3001: := ln_organization_id;
3002:
3003: pay_emp_action_arch.lrr_act_tab(ln_index).act_info4
3004: := lv_national_identifier ;
3005:
3006: hr_utility.trace('lv_national_identifier is'||lv_national_identifier);
3007:
3004: := lv_national_identifier ;
3005:
3006: hr_utility.trace('lv_national_identifier is'||lv_national_identifier);
3007:
3008: pay_emp_action_arch.lrr_act_tab(ln_index).act_info5 := lv_pay_basis;
3009:
3010: hr_utility.trace('lv_pay_basis is'||lv_pay_basis);
3011:
3012: pay_emp_action_arch.lrr_act_tab(ln_index).act_info6
3008: pay_emp_action_arch.lrr_act_tab(ln_index).act_info5 := lv_pay_basis;
3009:
3010: hr_utility.trace('lv_pay_basis is'||lv_pay_basis);
3011:
3012: pay_emp_action_arch.lrr_act_tab(ln_index).act_info6
3013: := lv_frequency_desc;
3014:
3015: hr_utility.trace('lv_frequency_desc is'||lv_frequency_desc);
3016:
3013: := lv_frequency_desc;
3014:
3015: hr_utility.trace('lv_frequency_desc is'||lv_frequency_desc);
3016:
3017: pay_emp_action_arch.lrr_act_tab(ln_index).act_info7
3018: := lv_grade;
3019:
3020: hr_utility.trace('lv_grade is'||lv_grade);
3021:
3018: := lv_grade;
3019:
3020: hr_utility.trace('lv_grade is'||lv_grade);
3021:
3022: pay_emp_action_arch.lrr_act_tab(ln_index).act_info8
3023: := lv_bargaining_unit;
3024:
3025: hr_utility.trace('lv_bargaining_unit is'||lv_bargaining_unit);
3026: pay_emp_action_arch.lrr_act_tab(ln_index).act_info9
3022: pay_emp_action_arch.lrr_act_tab(ln_index).act_info8
3023: := lv_bargaining_unit;
3024:
3025: hr_utility.trace('lv_bargaining_unit is'||lv_bargaining_unit);
3026: pay_emp_action_arch.lrr_act_tab(ln_index).act_info9
3027: := lv_collective_agreement;
3028:
3029: hr_utility.trace('lv_collective_agreement is'||lv_collective_agreement);
3030: pay_emp_action_arch.lrr_act_tab(ln_index).act_info10
3026: pay_emp_action_arch.lrr_act_tab(ln_index).act_info9
3027: := lv_collective_agreement;
3028:
3029: hr_utility.trace('lv_collective_agreement is'||lv_collective_agreement);
3030: pay_emp_action_arch.lrr_act_tab(ln_index).act_info10
3031: := lv_employee_number ;
3032:
3033: pay_emp_action_arch.lrr_act_tab(ln_index).act_info11
3034: := fnd_date.date_to_canonical(ld_date_start);
3029: hr_utility.trace('lv_collective_agreement is'||lv_collective_agreement);
3030: pay_emp_action_arch.lrr_act_tab(ln_index).act_info10
3031: := lv_employee_number ;
3032:
3033: pay_emp_action_arch.lrr_act_tab(ln_index).act_info11
3034: := fnd_date.date_to_canonical(ld_date_start);
3035:
3036: pay_emp_action_arch.lrr_act_tab(ln_index).act_info12
3037: := fnd_date.date_to_canonical(ld_original_date_of_hire);
3032:
3033: pay_emp_action_arch.lrr_act_tab(ln_index).act_info11
3034: := fnd_date.date_to_canonical(ld_date_start);
3035:
3036: pay_emp_action_arch.lrr_act_tab(ln_index).act_info12
3037: := fnd_date.date_to_canonical(ld_original_date_of_hire);
3038:
3039: pay_emp_action_arch.lrr_act_tab(ln_index).act_info13
3040: := fnd_date.date_to_canonical(ld_adjusted_svc_date);
3035:
3036: pay_emp_action_arch.lrr_act_tab(ln_index).act_info12
3037: := fnd_date.date_to_canonical(ld_original_date_of_hire);
3038:
3039: pay_emp_action_arch.lrr_act_tab(ln_index).act_info13
3040: := fnd_date.date_to_canonical(ld_adjusted_svc_date);
3041:
3042: pay_emp_action_arch.lrr_act_tab(ln_index).act_info14
3043: := lv_assignment_number;
3038:
3039: pay_emp_action_arch.lrr_act_tab(ln_index).act_info13
3040: := fnd_date.date_to_canonical(ld_adjusted_svc_date);
3041:
3042: pay_emp_action_arch.lrr_act_tab(ln_index).act_info14
3043: := lv_assignment_number;
3044:
3045: pay_emp_action_arch.lrr_act_tab(ln_index).act_info15
3046: := lv_organization_name;
3041:
3042: pay_emp_action_arch.lrr_act_tab(ln_index).act_info14
3043: := lv_assignment_number;
3044:
3045: pay_emp_action_arch.lrr_act_tab(ln_index).act_info15
3046: := lv_organization_name;
3047: pay_emp_action_arch.lrr_act_tab(ln_index).act_info16
3048: := p_time_period_id;
3049: pay_emp_action_arch.lrr_act_tab(ln_index).act_info17
3043: := lv_assignment_number;
3044:
3045: pay_emp_action_arch.lrr_act_tab(ln_index).act_info15
3046: := lv_organization_name;
3047: pay_emp_action_arch.lrr_act_tab(ln_index).act_info16
3048: := p_time_period_id;
3049: pay_emp_action_arch.lrr_act_tab(ln_index).act_info17
3050: := lv_job_name ;
3051: pay_emp_action_arch.lrr_act_tab(ln_index).act_info18
3045: pay_emp_action_arch.lrr_act_tab(ln_index).act_info15
3046: := lv_organization_name;
3047: pay_emp_action_arch.lrr_act_tab(ln_index).act_info16
3048: := p_time_period_id;
3049: pay_emp_action_arch.lrr_act_tab(ln_index).act_info17
3050: := lv_job_name ;
3051: pay_emp_action_arch.lrr_act_tab(ln_index).act_info18
3052: := lv_gre_name;
3053: pay_emp_action_arch.lrr_act_tab(ln_index).act_info19
3047: pay_emp_action_arch.lrr_act_tab(ln_index).act_info16
3048: := p_time_period_id;
3049: pay_emp_action_arch.lrr_act_tab(ln_index).act_info17
3050: := lv_job_name ;
3051: pay_emp_action_arch.lrr_act_tab(ln_index).act_info18
3052: := lv_gre_name;
3053: pay_emp_action_arch.lrr_act_tab(ln_index).act_info19
3054: := lv_position_name;
3055: pay_emp_action_arch.lrr_act_tab(ln_index).act_info20
3049: pay_emp_action_arch.lrr_act_tab(ln_index).act_info17
3050: := lv_job_name ;
3051: pay_emp_action_arch.lrr_act_tab(ln_index).act_info18
3052: := lv_gre_name;
3053: pay_emp_action_arch.lrr_act_tab(ln_index).act_info19
3054: := lv_position_name;
3055: pay_emp_action_arch.lrr_act_tab(ln_index).act_info20
3056: := lv_contract;
3057: pay_emp_action_arch.lrr_act_tab(ln_index).act_info21
3051: pay_emp_action_arch.lrr_act_tab(ln_index).act_info18
3052: := lv_gre_name;
3053: pay_emp_action_arch.lrr_act_tab(ln_index).act_info19
3054: := lv_position_name;
3055: pay_emp_action_arch.lrr_act_tab(ln_index).act_info20
3056: := lv_contract;
3057: pay_emp_action_arch.lrr_act_tab(ln_index).act_info21
3058: := lv_time_normal_start ;
3059: pay_emp_action_arch.lrr_act_tab(ln_index).act_info22
3053: pay_emp_action_arch.lrr_act_tab(ln_index).act_info19
3054: := lv_position_name;
3055: pay_emp_action_arch.lrr_act_tab(ln_index).act_info20
3056: := lv_contract;
3057: pay_emp_action_arch.lrr_act_tab(ln_index).act_info21
3058: := lv_time_normal_start ;
3059: pay_emp_action_arch.lrr_act_tab(ln_index).act_info22
3060: := lv_time_normal_finish;
3061: pay_emp_action_arch.lrr_act_tab(ln_index).act_info23
3055: pay_emp_action_arch.lrr_act_tab(ln_index).act_info20
3056: := lv_contract;
3057: pay_emp_action_arch.lrr_act_tab(ln_index).act_info21
3058: := lv_time_normal_start ;
3059: pay_emp_action_arch.lrr_act_tab(ln_index).act_info22
3060: := lv_time_normal_finish;
3061: pay_emp_action_arch.lrr_act_tab(ln_index).act_info23
3062: := lv_pay_calc_method;
3063: pay_emp_action_arch.lrr_act_tab(ln_index).act_info24
3057: pay_emp_action_arch.lrr_act_tab(ln_index).act_info21
3058: := lv_time_normal_start ;
3059: pay_emp_action_arch.lrr_act_tab(ln_index).act_info22
3060: := lv_time_normal_finish;
3061: pay_emp_action_arch.lrr_act_tab(ln_index).act_info23
3062: := lv_pay_calc_method;
3063: pay_emp_action_arch.lrr_act_tab(ln_index).act_info24
3064: := lv_shift_desc;
3065: pay_emp_action_arch.lrr_act_tab(ln_index).act_info25
3059: pay_emp_action_arch.lrr_act_tab(ln_index).act_info22
3060: := lv_time_normal_finish;
3061: pay_emp_action_arch.lrr_act_tab(ln_index).act_info23
3062: := lv_pay_calc_method;
3063: pay_emp_action_arch.lrr_act_tab(ln_index).act_info24
3064: := lv_shift_desc;
3065: pay_emp_action_arch.lrr_act_tab(ln_index).act_info25
3066: := lv_er_phone_number;
3067: pay_emp_action_arch.lrr_act_tab(ln_index).act_info26
3061: pay_emp_action_arch.lrr_act_tab(ln_index).act_info23
3062: := lv_pay_calc_method;
3063: pay_emp_action_arch.lrr_act_tab(ln_index).act_info24
3064: := lv_shift_desc;
3065: pay_emp_action_arch.lrr_act_tab(ln_index).act_info25
3066: := lv_er_phone_number;
3067: pay_emp_action_arch.lrr_act_tab(ln_index).act_info26
3068: := lv_hourly_salaried_desc;
3069: pay_emp_action_arch.lrr_act_tab(ln_index).act_info27
3063: pay_emp_action_arch.lrr_act_tab(ln_index).act_info24
3064: := lv_shift_desc;
3065: pay_emp_action_arch.lrr_act_tab(ln_index).act_info25
3066: := lv_er_phone_number;
3067: pay_emp_action_arch.lrr_act_tab(ln_index).act_info26
3068: := lv_hourly_salaried_desc;
3069: pay_emp_action_arch.lrr_act_tab(ln_index).act_info27
3070: := lv_step ;
3071: pay_emp_action_arch.lrr_act_tab(ln_index).act_info28
3065: pay_emp_action_arch.lrr_act_tab(ln_index).act_info25
3066: := lv_er_phone_number;
3067: pay_emp_action_arch.lrr_act_tab(ln_index).act_info26
3068: := lv_hourly_salaried_desc;
3069: pay_emp_action_arch.lrr_act_tab(ln_index).act_info27
3070: := lv_step ;
3071: pay_emp_action_arch.lrr_act_tab(ln_index).act_info28
3072: := fnd_number.number_to_canonical(ln_proposed_salary) ; /* Bug 3311866*/
3073: pay_emp_action_arch.lrr_act_tab(ln_index).act_info29
3067: pay_emp_action_arch.lrr_act_tab(ln_index).act_info26
3068: := lv_hourly_salaried_desc;
3069: pay_emp_action_arch.lrr_act_tab(ln_index).act_info27
3070: := lv_step ;
3071: pay_emp_action_arch.lrr_act_tab(ln_index).act_info28
3072: := fnd_number.number_to_canonical(ln_proposed_salary) ; /* Bug 3311866*/
3073: pay_emp_action_arch.lrr_act_tab(ln_index).act_info29
3074: := fnd_number.number_to_canonical(ln_pay_annualization_factor) ;
3075: pay_emp_action_arch.lrr_act_tab(ln_index).act_info30
3069: pay_emp_action_arch.lrr_act_tab(ln_index).act_info27
3070: := lv_step ;
3071: pay_emp_action_arch.lrr_act_tab(ln_index).act_info28
3072: := fnd_number.number_to_canonical(ln_proposed_salary) ; /* Bug 3311866*/
3073: pay_emp_action_arch.lrr_act_tab(ln_index).act_info29
3074: := fnd_number.number_to_canonical(ln_pay_annualization_factor) ;
3075: pay_emp_action_arch.lrr_act_tab(ln_index).act_info30
3076: := lv_location_code ;
3077:
3071: pay_emp_action_arch.lrr_act_tab(ln_index).act_info28
3072: := fnd_number.number_to_canonical(ln_proposed_salary) ; /* Bug 3311866*/
3073: pay_emp_action_arch.lrr_act_tab(ln_index).act_info29
3074: := fnd_number.number_to_canonical(ln_pay_annualization_factor) ;
3075: pay_emp_action_arch.lrr_act_tab(ln_index).act_info30
3076: := lv_location_code ;
3077:
3078: close c_employee_details;
3079:
3109: get_employee_addr (ln_person_id
3110: ,p_curr_eff_date);
3111:
3112:
3113: if pay_emp_action_arch.lrr_act_tab.count > 0 then
3114: insert_rows_thro_api_process(
3115: p_action_context_id => p_assactid
3116: ,p_action_context_type=> 'AAP'
3117: ,p_assignment_id => p_assignment_id
3116: ,p_action_context_type=> 'AAP'
3117: ,p_assignment_id => p_assignment_id
3118: ,p_tax_unit_id => p_tax_unit_id
3119: ,p_curr_pymt_eff_date => p_curr_pymt_eff_date
3120: ,p_tab_rec_data => pay_emp_action_arch.lrr_act_tab
3121: );
3122: end if;
3123:
3124: END get_personal_information;
3123:
3124: END get_personal_information;
3125:
3126: BEGIN
3127: gv_package := 'pay_emp_action_arch';
3128:
3129: EXCEPTION
3130: when others then
3131: hr_utility.trace('Error in ' || gv_package ||
3131: hr_utility.trace('Error in ' || gv_package ||
3132: to_char(sqlcode) || '-' || sqlerrm);
3133: raise hr_utility.hr_error;
3134:
3135: END pay_emp_action_arch;