1: PACKAGE BODY pay_emp_action_arch AS
2: /* $Header: pyempxfr.pkb 120.25.12020000.2 2012/07/06 10:06:32 vmaripal 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
203: 15-Apr-2010 sjawid 115.61 9549403 Modified cursor get_shift_desc such that
204: it will execute when get_shift_code cursor found.
205: 09-Mar-2011 nkjaladi 115.62 10324741 Modified cursor c_employee_details of
206: pacakage procedure
207: pay_emp_action_arch.get_personal_information
208: to check for ex-employee based on
209: current_employee_flag instead of
210: person_type_id
211: 30-Dec-2011 pkoduri 115.63 13529461 Added code to archive organization name and
377:
378: /******************************************************************
379: Name : initialization_process
380: Purpose : The procedure initializes the PL/SQL table -
381: pay_emp_action_arch.lrr_act_tab,
382: pay_emp_action_arch.ltr_ppa_arch and
383: pay_us_emp_payslip_accrual_web.ltr_assignment_accruals.
384: Arguments :
385: Notes :
378: /******************************************************************
379: Name : initialization_process
380: Purpose : The procedure initializes the PL/SQL table -
381: pay_emp_action_arch.lrr_act_tab,
382: pay_emp_action_arch.ltr_ppa_arch and
383: pay_us_emp_payslip_accrual_web.ltr_assignment_accruals.
384: Arguments :
385: Notes :
386: ******************************************************************/
391: BEGIN
392: lv_procedure_name := '.initialization_process';
393: hr_utility.set_location(gv_package || lv_procedure_name, 10);
394:
395: if pay_emp_action_arch.lrr_act_tab.count > 0 then
396: hr_utility.set_location(gv_package || lv_procedure_name, 20);
397: for i in pay_emp_action_arch.lrr_act_tab.first ..
398: pay_emp_action_arch.lrr_act_tab.last loop
399: pay_emp_action_arch.lrr_act_tab(i).action_context_id := null;
393: hr_utility.set_location(gv_package || lv_procedure_name, 10);
394:
395: if pay_emp_action_arch.lrr_act_tab.count > 0 then
396: hr_utility.set_location(gv_package || lv_procedure_name, 20);
397: for i in pay_emp_action_arch.lrr_act_tab.first ..
398: pay_emp_action_arch.lrr_act_tab.last loop
399: pay_emp_action_arch.lrr_act_tab(i).action_context_id := null;
400: pay_emp_action_arch.lrr_act_tab(i).action_context_type := null;
401: pay_emp_action_arch.lrr_act_tab(i).action_info_category := null;
394:
395: if pay_emp_action_arch.lrr_act_tab.count > 0 then
396: hr_utility.set_location(gv_package || lv_procedure_name, 20);
397: for i in pay_emp_action_arch.lrr_act_tab.first ..
398: pay_emp_action_arch.lrr_act_tab.last loop
399: pay_emp_action_arch.lrr_act_tab(i).action_context_id := null;
400: pay_emp_action_arch.lrr_act_tab(i).action_context_type := null;
401: pay_emp_action_arch.lrr_act_tab(i).action_info_category := null;
402: pay_emp_action_arch.lrr_act_tab(i).jurisdiction_code := null;
395: if pay_emp_action_arch.lrr_act_tab.count > 0 then
396: hr_utility.set_location(gv_package || lv_procedure_name, 20);
397: for i in pay_emp_action_arch.lrr_act_tab.first ..
398: pay_emp_action_arch.lrr_act_tab.last loop
399: pay_emp_action_arch.lrr_act_tab(i).action_context_id := null;
400: pay_emp_action_arch.lrr_act_tab(i).action_context_type := null;
401: pay_emp_action_arch.lrr_act_tab(i).action_info_category := null;
402: pay_emp_action_arch.lrr_act_tab(i).jurisdiction_code := null;
403: pay_emp_action_arch.lrr_act_tab(i).act_info1 := null;
396: hr_utility.set_location(gv_package || lv_procedure_name, 20);
397: for i in pay_emp_action_arch.lrr_act_tab.first ..
398: pay_emp_action_arch.lrr_act_tab.last loop
399: pay_emp_action_arch.lrr_act_tab(i).action_context_id := null;
400: pay_emp_action_arch.lrr_act_tab(i).action_context_type := null;
401: pay_emp_action_arch.lrr_act_tab(i).action_info_category := null;
402: pay_emp_action_arch.lrr_act_tab(i).jurisdiction_code := null;
403: pay_emp_action_arch.lrr_act_tab(i).act_info1 := null;
404: pay_emp_action_arch.lrr_act_tab(i).act_info2 := null;
397: for i in pay_emp_action_arch.lrr_act_tab.first ..
398: pay_emp_action_arch.lrr_act_tab.last loop
399: pay_emp_action_arch.lrr_act_tab(i).action_context_id := null;
400: pay_emp_action_arch.lrr_act_tab(i).action_context_type := null;
401: pay_emp_action_arch.lrr_act_tab(i).action_info_category := null;
402: pay_emp_action_arch.lrr_act_tab(i).jurisdiction_code := null;
403: pay_emp_action_arch.lrr_act_tab(i).act_info1 := null;
404: pay_emp_action_arch.lrr_act_tab(i).act_info2 := null;
405: pay_emp_action_arch.lrr_act_tab(i).act_info3 := null;
398: pay_emp_action_arch.lrr_act_tab.last loop
399: pay_emp_action_arch.lrr_act_tab(i).action_context_id := null;
400: pay_emp_action_arch.lrr_act_tab(i).action_context_type := null;
401: pay_emp_action_arch.lrr_act_tab(i).action_info_category := null;
402: pay_emp_action_arch.lrr_act_tab(i).jurisdiction_code := null;
403: pay_emp_action_arch.lrr_act_tab(i).act_info1 := null;
404: pay_emp_action_arch.lrr_act_tab(i).act_info2 := null;
405: pay_emp_action_arch.lrr_act_tab(i).act_info3 := null;
406: pay_emp_action_arch.lrr_act_tab(i).act_info4 := null;
399: pay_emp_action_arch.lrr_act_tab(i).action_context_id := null;
400: pay_emp_action_arch.lrr_act_tab(i).action_context_type := null;
401: pay_emp_action_arch.lrr_act_tab(i).action_info_category := null;
402: pay_emp_action_arch.lrr_act_tab(i).jurisdiction_code := null;
403: pay_emp_action_arch.lrr_act_tab(i).act_info1 := null;
404: pay_emp_action_arch.lrr_act_tab(i).act_info2 := null;
405: pay_emp_action_arch.lrr_act_tab(i).act_info3 := null;
406: pay_emp_action_arch.lrr_act_tab(i).act_info4 := null;
407: pay_emp_action_arch.lrr_act_tab(i).act_info5 := null;
400: pay_emp_action_arch.lrr_act_tab(i).action_context_type := null;
401: pay_emp_action_arch.lrr_act_tab(i).action_info_category := null;
402: pay_emp_action_arch.lrr_act_tab(i).jurisdiction_code := null;
403: pay_emp_action_arch.lrr_act_tab(i).act_info1 := null;
404: pay_emp_action_arch.lrr_act_tab(i).act_info2 := null;
405: pay_emp_action_arch.lrr_act_tab(i).act_info3 := null;
406: pay_emp_action_arch.lrr_act_tab(i).act_info4 := null;
407: pay_emp_action_arch.lrr_act_tab(i).act_info5 := null;
408: pay_emp_action_arch.lrr_act_tab(i).act_info6 := null;
401: pay_emp_action_arch.lrr_act_tab(i).action_info_category := null;
402: pay_emp_action_arch.lrr_act_tab(i).jurisdiction_code := null;
403: pay_emp_action_arch.lrr_act_tab(i).act_info1 := null;
404: pay_emp_action_arch.lrr_act_tab(i).act_info2 := null;
405: pay_emp_action_arch.lrr_act_tab(i).act_info3 := null;
406: pay_emp_action_arch.lrr_act_tab(i).act_info4 := null;
407: pay_emp_action_arch.lrr_act_tab(i).act_info5 := null;
408: pay_emp_action_arch.lrr_act_tab(i).act_info6 := null;
409: pay_emp_action_arch.lrr_act_tab(i).act_info7 := null;
402: pay_emp_action_arch.lrr_act_tab(i).jurisdiction_code := null;
403: pay_emp_action_arch.lrr_act_tab(i).act_info1 := null;
404: pay_emp_action_arch.lrr_act_tab(i).act_info2 := null;
405: pay_emp_action_arch.lrr_act_tab(i).act_info3 := null;
406: pay_emp_action_arch.lrr_act_tab(i).act_info4 := null;
407: pay_emp_action_arch.lrr_act_tab(i).act_info5 := null;
408: pay_emp_action_arch.lrr_act_tab(i).act_info6 := null;
409: pay_emp_action_arch.lrr_act_tab(i).act_info7 := null;
410: pay_emp_action_arch.lrr_act_tab(i).act_info8 := null;
403: pay_emp_action_arch.lrr_act_tab(i).act_info1 := null;
404: pay_emp_action_arch.lrr_act_tab(i).act_info2 := null;
405: pay_emp_action_arch.lrr_act_tab(i).act_info3 := null;
406: pay_emp_action_arch.lrr_act_tab(i).act_info4 := null;
407: pay_emp_action_arch.lrr_act_tab(i).act_info5 := null;
408: pay_emp_action_arch.lrr_act_tab(i).act_info6 := null;
409: pay_emp_action_arch.lrr_act_tab(i).act_info7 := null;
410: pay_emp_action_arch.lrr_act_tab(i).act_info8 := null;
411: pay_emp_action_arch.lrr_act_tab(i).act_info9 := null;
404: pay_emp_action_arch.lrr_act_tab(i).act_info2 := null;
405: pay_emp_action_arch.lrr_act_tab(i).act_info3 := null;
406: pay_emp_action_arch.lrr_act_tab(i).act_info4 := null;
407: pay_emp_action_arch.lrr_act_tab(i).act_info5 := null;
408: pay_emp_action_arch.lrr_act_tab(i).act_info6 := null;
409: pay_emp_action_arch.lrr_act_tab(i).act_info7 := null;
410: pay_emp_action_arch.lrr_act_tab(i).act_info8 := null;
411: pay_emp_action_arch.lrr_act_tab(i).act_info9 := null;
412: pay_emp_action_arch.lrr_act_tab(i).act_info10 := null;
405: pay_emp_action_arch.lrr_act_tab(i).act_info3 := null;
406: pay_emp_action_arch.lrr_act_tab(i).act_info4 := null;
407: pay_emp_action_arch.lrr_act_tab(i).act_info5 := null;
408: pay_emp_action_arch.lrr_act_tab(i).act_info6 := null;
409: pay_emp_action_arch.lrr_act_tab(i).act_info7 := null;
410: pay_emp_action_arch.lrr_act_tab(i).act_info8 := null;
411: pay_emp_action_arch.lrr_act_tab(i).act_info9 := null;
412: pay_emp_action_arch.lrr_act_tab(i).act_info10 := null;
413: pay_emp_action_arch.lrr_act_tab(i).act_info11 := null;
406: pay_emp_action_arch.lrr_act_tab(i).act_info4 := null;
407: pay_emp_action_arch.lrr_act_tab(i).act_info5 := null;
408: pay_emp_action_arch.lrr_act_tab(i).act_info6 := null;
409: pay_emp_action_arch.lrr_act_tab(i).act_info7 := null;
410: pay_emp_action_arch.lrr_act_tab(i).act_info8 := null;
411: pay_emp_action_arch.lrr_act_tab(i).act_info9 := null;
412: pay_emp_action_arch.lrr_act_tab(i).act_info10 := null;
413: pay_emp_action_arch.lrr_act_tab(i).act_info11 := null;
414: pay_emp_action_arch.lrr_act_tab(i).act_info12 := null;
407: pay_emp_action_arch.lrr_act_tab(i).act_info5 := null;
408: pay_emp_action_arch.lrr_act_tab(i).act_info6 := null;
409: pay_emp_action_arch.lrr_act_tab(i).act_info7 := null;
410: pay_emp_action_arch.lrr_act_tab(i).act_info8 := null;
411: pay_emp_action_arch.lrr_act_tab(i).act_info9 := null;
412: pay_emp_action_arch.lrr_act_tab(i).act_info10 := null;
413: pay_emp_action_arch.lrr_act_tab(i).act_info11 := null;
414: pay_emp_action_arch.lrr_act_tab(i).act_info12 := null;
415: pay_emp_action_arch.lrr_act_tab(i).act_info13 := null;
408: pay_emp_action_arch.lrr_act_tab(i).act_info6 := null;
409: pay_emp_action_arch.lrr_act_tab(i).act_info7 := null;
410: pay_emp_action_arch.lrr_act_tab(i).act_info8 := null;
411: pay_emp_action_arch.lrr_act_tab(i).act_info9 := null;
412: pay_emp_action_arch.lrr_act_tab(i).act_info10 := null;
413: pay_emp_action_arch.lrr_act_tab(i).act_info11 := null;
414: pay_emp_action_arch.lrr_act_tab(i).act_info12 := null;
415: pay_emp_action_arch.lrr_act_tab(i).act_info13 := null;
416: pay_emp_action_arch.lrr_act_tab(i).act_info14 := null;
409: pay_emp_action_arch.lrr_act_tab(i).act_info7 := null;
410: pay_emp_action_arch.lrr_act_tab(i).act_info8 := null;
411: pay_emp_action_arch.lrr_act_tab(i).act_info9 := null;
412: pay_emp_action_arch.lrr_act_tab(i).act_info10 := null;
413: pay_emp_action_arch.lrr_act_tab(i).act_info11 := null;
414: pay_emp_action_arch.lrr_act_tab(i).act_info12 := null;
415: pay_emp_action_arch.lrr_act_tab(i).act_info13 := null;
416: pay_emp_action_arch.lrr_act_tab(i).act_info14 := null;
417: pay_emp_action_arch.lrr_act_tab(i).act_info15 := null;
410: pay_emp_action_arch.lrr_act_tab(i).act_info8 := null;
411: pay_emp_action_arch.lrr_act_tab(i).act_info9 := null;
412: pay_emp_action_arch.lrr_act_tab(i).act_info10 := null;
413: pay_emp_action_arch.lrr_act_tab(i).act_info11 := null;
414: pay_emp_action_arch.lrr_act_tab(i).act_info12 := null;
415: pay_emp_action_arch.lrr_act_tab(i).act_info13 := null;
416: pay_emp_action_arch.lrr_act_tab(i).act_info14 := null;
417: pay_emp_action_arch.lrr_act_tab(i).act_info15 := null;
418: pay_emp_action_arch.lrr_act_tab(i).act_info16 := null;
411: pay_emp_action_arch.lrr_act_tab(i).act_info9 := null;
412: pay_emp_action_arch.lrr_act_tab(i).act_info10 := null;
413: pay_emp_action_arch.lrr_act_tab(i).act_info11 := null;
414: pay_emp_action_arch.lrr_act_tab(i).act_info12 := null;
415: pay_emp_action_arch.lrr_act_tab(i).act_info13 := null;
416: pay_emp_action_arch.lrr_act_tab(i).act_info14 := null;
417: pay_emp_action_arch.lrr_act_tab(i).act_info15 := null;
418: pay_emp_action_arch.lrr_act_tab(i).act_info16 := null;
419: pay_emp_action_arch.lrr_act_tab(i).act_info17 := null;
412: pay_emp_action_arch.lrr_act_tab(i).act_info10 := null;
413: pay_emp_action_arch.lrr_act_tab(i).act_info11 := null;
414: pay_emp_action_arch.lrr_act_tab(i).act_info12 := null;
415: pay_emp_action_arch.lrr_act_tab(i).act_info13 := null;
416: pay_emp_action_arch.lrr_act_tab(i).act_info14 := null;
417: pay_emp_action_arch.lrr_act_tab(i).act_info15 := null;
418: pay_emp_action_arch.lrr_act_tab(i).act_info16 := null;
419: pay_emp_action_arch.lrr_act_tab(i).act_info17 := null;
420: pay_emp_action_arch.lrr_act_tab(i).act_info18 := null;
413: pay_emp_action_arch.lrr_act_tab(i).act_info11 := null;
414: pay_emp_action_arch.lrr_act_tab(i).act_info12 := null;
415: pay_emp_action_arch.lrr_act_tab(i).act_info13 := null;
416: pay_emp_action_arch.lrr_act_tab(i).act_info14 := null;
417: pay_emp_action_arch.lrr_act_tab(i).act_info15 := null;
418: pay_emp_action_arch.lrr_act_tab(i).act_info16 := null;
419: pay_emp_action_arch.lrr_act_tab(i).act_info17 := null;
420: pay_emp_action_arch.lrr_act_tab(i).act_info18 := null;
421: pay_emp_action_arch.lrr_act_tab(i).act_info19 := null;
414: pay_emp_action_arch.lrr_act_tab(i).act_info12 := null;
415: pay_emp_action_arch.lrr_act_tab(i).act_info13 := null;
416: pay_emp_action_arch.lrr_act_tab(i).act_info14 := null;
417: pay_emp_action_arch.lrr_act_tab(i).act_info15 := null;
418: pay_emp_action_arch.lrr_act_tab(i).act_info16 := null;
419: pay_emp_action_arch.lrr_act_tab(i).act_info17 := null;
420: pay_emp_action_arch.lrr_act_tab(i).act_info18 := null;
421: pay_emp_action_arch.lrr_act_tab(i).act_info19 := null;
422: pay_emp_action_arch.lrr_act_tab(i).act_info20 := null;
415: pay_emp_action_arch.lrr_act_tab(i).act_info13 := null;
416: pay_emp_action_arch.lrr_act_tab(i).act_info14 := null;
417: pay_emp_action_arch.lrr_act_tab(i).act_info15 := null;
418: pay_emp_action_arch.lrr_act_tab(i).act_info16 := null;
419: pay_emp_action_arch.lrr_act_tab(i).act_info17 := null;
420: pay_emp_action_arch.lrr_act_tab(i).act_info18 := null;
421: pay_emp_action_arch.lrr_act_tab(i).act_info19 := null;
422: pay_emp_action_arch.lrr_act_tab(i).act_info20 := null;
423: pay_emp_action_arch.lrr_act_tab(i).act_info21 := null;
416: pay_emp_action_arch.lrr_act_tab(i).act_info14 := null;
417: pay_emp_action_arch.lrr_act_tab(i).act_info15 := null;
418: pay_emp_action_arch.lrr_act_tab(i).act_info16 := null;
419: pay_emp_action_arch.lrr_act_tab(i).act_info17 := null;
420: pay_emp_action_arch.lrr_act_tab(i).act_info18 := null;
421: pay_emp_action_arch.lrr_act_tab(i).act_info19 := null;
422: pay_emp_action_arch.lrr_act_tab(i).act_info20 := null;
423: pay_emp_action_arch.lrr_act_tab(i).act_info21 := null;
424: pay_emp_action_arch.lrr_act_tab(i).act_info22 := null;
417: pay_emp_action_arch.lrr_act_tab(i).act_info15 := null;
418: pay_emp_action_arch.lrr_act_tab(i).act_info16 := null;
419: pay_emp_action_arch.lrr_act_tab(i).act_info17 := null;
420: pay_emp_action_arch.lrr_act_tab(i).act_info18 := null;
421: pay_emp_action_arch.lrr_act_tab(i).act_info19 := null;
422: pay_emp_action_arch.lrr_act_tab(i).act_info20 := null;
423: pay_emp_action_arch.lrr_act_tab(i).act_info21 := null;
424: pay_emp_action_arch.lrr_act_tab(i).act_info22 := null;
425: pay_emp_action_arch.lrr_act_tab(i).act_info23 := null;
418: pay_emp_action_arch.lrr_act_tab(i).act_info16 := null;
419: pay_emp_action_arch.lrr_act_tab(i).act_info17 := null;
420: pay_emp_action_arch.lrr_act_tab(i).act_info18 := null;
421: pay_emp_action_arch.lrr_act_tab(i).act_info19 := null;
422: pay_emp_action_arch.lrr_act_tab(i).act_info20 := null;
423: pay_emp_action_arch.lrr_act_tab(i).act_info21 := null;
424: pay_emp_action_arch.lrr_act_tab(i).act_info22 := null;
425: pay_emp_action_arch.lrr_act_tab(i).act_info23 := null;
426: pay_emp_action_arch.lrr_act_tab(i).act_info24 := null;
419: pay_emp_action_arch.lrr_act_tab(i).act_info17 := null;
420: pay_emp_action_arch.lrr_act_tab(i).act_info18 := null;
421: pay_emp_action_arch.lrr_act_tab(i).act_info19 := null;
422: pay_emp_action_arch.lrr_act_tab(i).act_info20 := null;
423: pay_emp_action_arch.lrr_act_tab(i).act_info21 := null;
424: pay_emp_action_arch.lrr_act_tab(i).act_info22 := null;
425: pay_emp_action_arch.lrr_act_tab(i).act_info23 := null;
426: pay_emp_action_arch.lrr_act_tab(i).act_info24 := null;
427: pay_emp_action_arch.lrr_act_tab(i).act_info25 := null;
420: pay_emp_action_arch.lrr_act_tab(i).act_info18 := null;
421: pay_emp_action_arch.lrr_act_tab(i).act_info19 := null;
422: pay_emp_action_arch.lrr_act_tab(i).act_info20 := null;
423: pay_emp_action_arch.lrr_act_tab(i).act_info21 := null;
424: pay_emp_action_arch.lrr_act_tab(i).act_info22 := null;
425: pay_emp_action_arch.lrr_act_tab(i).act_info23 := null;
426: pay_emp_action_arch.lrr_act_tab(i).act_info24 := null;
427: pay_emp_action_arch.lrr_act_tab(i).act_info25 := null;
428: pay_emp_action_arch.lrr_act_tab(i).act_info26 := null;
421: pay_emp_action_arch.lrr_act_tab(i).act_info19 := null;
422: pay_emp_action_arch.lrr_act_tab(i).act_info20 := null;
423: pay_emp_action_arch.lrr_act_tab(i).act_info21 := null;
424: pay_emp_action_arch.lrr_act_tab(i).act_info22 := null;
425: pay_emp_action_arch.lrr_act_tab(i).act_info23 := null;
426: pay_emp_action_arch.lrr_act_tab(i).act_info24 := null;
427: pay_emp_action_arch.lrr_act_tab(i).act_info25 := null;
428: pay_emp_action_arch.lrr_act_tab(i).act_info26 := null;
429: pay_emp_action_arch.lrr_act_tab(i).act_info27 := null;
422: pay_emp_action_arch.lrr_act_tab(i).act_info20 := null;
423: pay_emp_action_arch.lrr_act_tab(i).act_info21 := null;
424: pay_emp_action_arch.lrr_act_tab(i).act_info22 := null;
425: pay_emp_action_arch.lrr_act_tab(i).act_info23 := null;
426: pay_emp_action_arch.lrr_act_tab(i).act_info24 := null;
427: pay_emp_action_arch.lrr_act_tab(i).act_info25 := null;
428: pay_emp_action_arch.lrr_act_tab(i).act_info26 := null;
429: pay_emp_action_arch.lrr_act_tab(i).act_info27 := null;
430: pay_emp_action_arch.lrr_act_tab(i).act_info28 := null;
423: pay_emp_action_arch.lrr_act_tab(i).act_info21 := null;
424: pay_emp_action_arch.lrr_act_tab(i).act_info22 := null;
425: pay_emp_action_arch.lrr_act_tab(i).act_info23 := null;
426: pay_emp_action_arch.lrr_act_tab(i).act_info24 := null;
427: pay_emp_action_arch.lrr_act_tab(i).act_info25 := null;
428: pay_emp_action_arch.lrr_act_tab(i).act_info26 := null;
429: pay_emp_action_arch.lrr_act_tab(i).act_info27 := null;
430: pay_emp_action_arch.lrr_act_tab(i).act_info28 := null;
431: pay_emp_action_arch.lrr_act_tab(i).act_info29 := null;
424: pay_emp_action_arch.lrr_act_tab(i).act_info22 := null;
425: pay_emp_action_arch.lrr_act_tab(i).act_info23 := null;
426: pay_emp_action_arch.lrr_act_tab(i).act_info24 := null;
427: pay_emp_action_arch.lrr_act_tab(i).act_info25 := null;
428: pay_emp_action_arch.lrr_act_tab(i).act_info26 := null;
429: pay_emp_action_arch.lrr_act_tab(i).act_info27 := null;
430: pay_emp_action_arch.lrr_act_tab(i).act_info28 := null;
431: pay_emp_action_arch.lrr_act_tab(i).act_info29 := null;
432: pay_emp_action_arch.lrr_act_tab(i).act_info30 := null;
425: pay_emp_action_arch.lrr_act_tab(i).act_info23 := null;
426: pay_emp_action_arch.lrr_act_tab(i).act_info24 := null;
427: pay_emp_action_arch.lrr_act_tab(i).act_info25 := null;
428: pay_emp_action_arch.lrr_act_tab(i).act_info26 := null;
429: pay_emp_action_arch.lrr_act_tab(i).act_info27 := null;
430: pay_emp_action_arch.lrr_act_tab(i).act_info28 := null;
431: pay_emp_action_arch.lrr_act_tab(i).act_info29 := null;
432: pay_emp_action_arch.lrr_act_tab(i).act_info30 := null;
433: end loop;
426: pay_emp_action_arch.lrr_act_tab(i).act_info24 := null;
427: pay_emp_action_arch.lrr_act_tab(i).act_info25 := null;
428: pay_emp_action_arch.lrr_act_tab(i).act_info26 := null;
429: pay_emp_action_arch.lrr_act_tab(i).act_info27 := null;
430: pay_emp_action_arch.lrr_act_tab(i).act_info28 := null;
431: pay_emp_action_arch.lrr_act_tab(i).act_info29 := null;
432: pay_emp_action_arch.lrr_act_tab(i).act_info30 := null;
433: end loop;
434: end if;
427: pay_emp_action_arch.lrr_act_tab(i).act_info25 := null;
428: pay_emp_action_arch.lrr_act_tab(i).act_info26 := null;
429: pay_emp_action_arch.lrr_act_tab(i).act_info27 := null;
430: pay_emp_action_arch.lrr_act_tab(i).act_info28 := null;
431: pay_emp_action_arch.lrr_act_tab(i).act_info29 := null;
432: pay_emp_action_arch.lrr_act_tab(i).act_info30 := null;
433: end loop;
434: end if;
435: pay_emp_action_arch.lrr_act_tab.delete;
428: pay_emp_action_arch.lrr_act_tab(i).act_info26 := null;
429: pay_emp_action_arch.lrr_act_tab(i).act_info27 := null;
430: pay_emp_action_arch.lrr_act_tab(i).act_info28 := null;
431: pay_emp_action_arch.lrr_act_tab(i).act_info29 := null;
432: pay_emp_action_arch.lrr_act_tab(i).act_info30 := null;
433: end loop;
434: end if;
435: pay_emp_action_arch.lrr_act_tab.delete;
436: pay_us_emp_payslip_accrual_web.ltr_assignment_accruals.delete;
431: pay_emp_action_arch.lrr_act_tab(i).act_info29 := null;
432: pay_emp_action_arch.lrr_act_tab(i).act_info30 := null;
433: end loop;
434: end if;
435: pay_emp_action_arch.lrr_act_tab.delete;
436: pay_us_emp_payslip_accrual_web.ltr_assignment_accruals.delete;
437: hr_utility.set_location(gv_package || lv_procedure_name, 30);
438:
439: if pay_emp_action_arch.ltr_ppa_arch.count > 0 then
435: pay_emp_action_arch.lrr_act_tab.delete;
436: pay_us_emp_payslip_accrual_web.ltr_assignment_accruals.delete;
437: hr_utility.set_location(gv_package || lv_procedure_name, 30);
438:
439: if pay_emp_action_arch.ltr_ppa_arch.count > 0 then
440: hr_utility.set_location(gv_package || lv_procedure_name, 40);
441: for i in pay_emp_action_arch.ltr_ppa_arch.first ..
442: pay_emp_action_arch.ltr_ppa_arch.last loop
443: pay_emp_action_arch.ltr_ppa_arch(i).action_context_id := null;
437: hr_utility.set_location(gv_package || lv_procedure_name, 30);
438:
439: if pay_emp_action_arch.ltr_ppa_arch.count > 0 then
440: hr_utility.set_location(gv_package || lv_procedure_name, 40);
441: for i in pay_emp_action_arch.ltr_ppa_arch.first ..
442: pay_emp_action_arch.ltr_ppa_arch.last loop
443: pay_emp_action_arch.ltr_ppa_arch(i).action_context_id := null;
444: pay_emp_action_arch.ltr_ppa_arch(i).action_context_type := null;
445: pay_emp_action_arch.ltr_ppa_arch(i).action_info_category := null;
438:
439: if pay_emp_action_arch.ltr_ppa_arch.count > 0 then
440: hr_utility.set_location(gv_package || lv_procedure_name, 40);
441: for i in pay_emp_action_arch.ltr_ppa_arch.first ..
442: pay_emp_action_arch.ltr_ppa_arch.last loop
443: pay_emp_action_arch.ltr_ppa_arch(i).action_context_id := null;
444: pay_emp_action_arch.ltr_ppa_arch(i).action_context_type := null;
445: pay_emp_action_arch.ltr_ppa_arch(i).action_info_category := null;
446: pay_emp_action_arch.ltr_ppa_arch(i).jurisdiction_code := null;
439: if pay_emp_action_arch.ltr_ppa_arch.count > 0 then
440: hr_utility.set_location(gv_package || lv_procedure_name, 40);
441: for i in pay_emp_action_arch.ltr_ppa_arch.first ..
442: pay_emp_action_arch.ltr_ppa_arch.last loop
443: pay_emp_action_arch.ltr_ppa_arch(i).action_context_id := null;
444: pay_emp_action_arch.ltr_ppa_arch(i).action_context_type := null;
445: pay_emp_action_arch.ltr_ppa_arch(i).action_info_category := null;
446: pay_emp_action_arch.ltr_ppa_arch(i).jurisdiction_code := null;
447: pay_emp_action_arch.ltr_ppa_arch(i).act_info1 := null;
440: hr_utility.set_location(gv_package || lv_procedure_name, 40);
441: for i in pay_emp_action_arch.ltr_ppa_arch.first ..
442: pay_emp_action_arch.ltr_ppa_arch.last loop
443: pay_emp_action_arch.ltr_ppa_arch(i).action_context_id := null;
444: pay_emp_action_arch.ltr_ppa_arch(i).action_context_type := null;
445: pay_emp_action_arch.ltr_ppa_arch(i).action_info_category := null;
446: pay_emp_action_arch.ltr_ppa_arch(i).jurisdiction_code := null;
447: pay_emp_action_arch.ltr_ppa_arch(i).act_info1 := null;
448: pay_emp_action_arch.ltr_ppa_arch(i).act_info2 := null;
441: for i in pay_emp_action_arch.ltr_ppa_arch.first ..
442: pay_emp_action_arch.ltr_ppa_arch.last loop
443: pay_emp_action_arch.ltr_ppa_arch(i).action_context_id := null;
444: pay_emp_action_arch.ltr_ppa_arch(i).action_context_type := null;
445: pay_emp_action_arch.ltr_ppa_arch(i).action_info_category := null;
446: pay_emp_action_arch.ltr_ppa_arch(i).jurisdiction_code := null;
447: pay_emp_action_arch.ltr_ppa_arch(i).act_info1 := null;
448: pay_emp_action_arch.ltr_ppa_arch(i).act_info2 := null;
449: pay_emp_action_arch.ltr_ppa_arch(i).act_info3 := null;
442: pay_emp_action_arch.ltr_ppa_arch.last loop
443: pay_emp_action_arch.ltr_ppa_arch(i).action_context_id := null;
444: pay_emp_action_arch.ltr_ppa_arch(i).action_context_type := null;
445: pay_emp_action_arch.ltr_ppa_arch(i).action_info_category := null;
446: pay_emp_action_arch.ltr_ppa_arch(i).jurisdiction_code := null;
447: pay_emp_action_arch.ltr_ppa_arch(i).act_info1 := null;
448: pay_emp_action_arch.ltr_ppa_arch(i).act_info2 := null;
449: pay_emp_action_arch.ltr_ppa_arch(i).act_info3 := null;
450: pay_emp_action_arch.ltr_ppa_arch(i).act_info4 := null;
443: pay_emp_action_arch.ltr_ppa_arch(i).action_context_id := null;
444: pay_emp_action_arch.ltr_ppa_arch(i).action_context_type := null;
445: pay_emp_action_arch.ltr_ppa_arch(i).action_info_category := null;
446: pay_emp_action_arch.ltr_ppa_arch(i).jurisdiction_code := null;
447: pay_emp_action_arch.ltr_ppa_arch(i).act_info1 := null;
448: pay_emp_action_arch.ltr_ppa_arch(i).act_info2 := null;
449: pay_emp_action_arch.ltr_ppa_arch(i).act_info3 := null;
450: pay_emp_action_arch.ltr_ppa_arch(i).act_info4 := null;
451: pay_emp_action_arch.ltr_ppa_arch(i).act_info5 := null;
444: pay_emp_action_arch.ltr_ppa_arch(i).action_context_type := null;
445: pay_emp_action_arch.ltr_ppa_arch(i).action_info_category := null;
446: pay_emp_action_arch.ltr_ppa_arch(i).jurisdiction_code := null;
447: pay_emp_action_arch.ltr_ppa_arch(i).act_info1 := null;
448: pay_emp_action_arch.ltr_ppa_arch(i).act_info2 := null;
449: pay_emp_action_arch.ltr_ppa_arch(i).act_info3 := null;
450: pay_emp_action_arch.ltr_ppa_arch(i).act_info4 := null;
451: pay_emp_action_arch.ltr_ppa_arch(i).act_info5 := null;
452: pay_emp_action_arch.ltr_ppa_arch(i).act_info6 := null;
445: pay_emp_action_arch.ltr_ppa_arch(i).action_info_category := null;
446: pay_emp_action_arch.ltr_ppa_arch(i).jurisdiction_code := null;
447: pay_emp_action_arch.ltr_ppa_arch(i).act_info1 := null;
448: pay_emp_action_arch.ltr_ppa_arch(i).act_info2 := null;
449: pay_emp_action_arch.ltr_ppa_arch(i).act_info3 := null;
450: pay_emp_action_arch.ltr_ppa_arch(i).act_info4 := null;
451: pay_emp_action_arch.ltr_ppa_arch(i).act_info5 := null;
452: pay_emp_action_arch.ltr_ppa_arch(i).act_info6 := null;
453: pay_emp_action_arch.ltr_ppa_arch(i).act_info7 := null;
446: pay_emp_action_arch.ltr_ppa_arch(i).jurisdiction_code := null;
447: pay_emp_action_arch.ltr_ppa_arch(i).act_info1 := null;
448: pay_emp_action_arch.ltr_ppa_arch(i).act_info2 := null;
449: pay_emp_action_arch.ltr_ppa_arch(i).act_info3 := null;
450: pay_emp_action_arch.ltr_ppa_arch(i).act_info4 := null;
451: pay_emp_action_arch.ltr_ppa_arch(i).act_info5 := null;
452: pay_emp_action_arch.ltr_ppa_arch(i).act_info6 := null;
453: pay_emp_action_arch.ltr_ppa_arch(i).act_info7 := null;
454: pay_emp_action_arch.ltr_ppa_arch(i).act_info8 := null;
447: pay_emp_action_arch.ltr_ppa_arch(i).act_info1 := null;
448: pay_emp_action_arch.ltr_ppa_arch(i).act_info2 := null;
449: pay_emp_action_arch.ltr_ppa_arch(i).act_info3 := null;
450: pay_emp_action_arch.ltr_ppa_arch(i).act_info4 := null;
451: pay_emp_action_arch.ltr_ppa_arch(i).act_info5 := null;
452: pay_emp_action_arch.ltr_ppa_arch(i).act_info6 := null;
453: pay_emp_action_arch.ltr_ppa_arch(i).act_info7 := null;
454: pay_emp_action_arch.ltr_ppa_arch(i).act_info8 := null;
455: pay_emp_action_arch.ltr_ppa_arch(i).act_info9 := null;
448: pay_emp_action_arch.ltr_ppa_arch(i).act_info2 := null;
449: pay_emp_action_arch.ltr_ppa_arch(i).act_info3 := null;
450: pay_emp_action_arch.ltr_ppa_arch(i).act_info4 := null;
451: pay_emp_action_arch.ltr_ppa_arch(i).act_info5 := null;
452: pay_emp_action_arch.ltr_ppa_arch(i).act_info6 := null;
453: pay_emp_action_arch.ltr_ppa_arch(i).act_info7 := null;
454: pay_emp_action_arch.ltr_ppa_arch(i).act_info8 := null;
455: pay_emp_action_arch.ltr_ppa_arch(i).act_info9 := null;
456: pay_emp_action_arch.ltr_ppa_arch(i).act_info10 := null;
449: pay_emp_action_arch.ltr_ppa_arch(i).act_info3 := null;
450: pay_emp_action_arch.ltr_ppa_arch(i).act_info4 := null;
451: pay_emp_action_arch.ltr_ppa_arch(i).act_info5 := null;
452: pay_emp_action_arch.ltr_ppa_arch(i).act_info6 := null;
453: pay_emp_action_arch.ltr_ppa_arch(i).act_info7 := null;
454: pay_emp_action_arch.ltr_ppa_arch(i).act_info8 := null;
455: pay_emp_action_arch.ltr_ppa_arch(i).act_info9 := null;
456: pay_emp_action_arch.ltr_ppa_arch(i).act_info10 := null;
457: pay_emp_action_arch.ltr_ppa_arch(i).act_info11 := null;
450: pay_emp_action_arch.ltr_ppa_arch(i).act_info4 := null;
451: pay_emp_action_arch.ltr_ppa_arch(i).act_info5 := null;
452: pay_emp_action_arch.ltr_ppa_arch(i).act_info6 := null;
453: pay_emp_action_arch.ltr_ppa_arch(i).act_info7 := null;
454: pay_emp_action_arch.ltr_ppa_arch(i).act_info8 := null;
455: pay_emp_action_arch.ltr_ppa_arch(i).act_info9 := null;
456: pay_emp_action_arch.ltr_ppa_arch(i).act_info10 := null;
457: pay_emp_action_arch.ltr_ppa_arch(i).act_info11 := null;
458: pay_emp_action_arch.ltr_ppa_arch(i).act_info12 := null;
451: pay_emp_action_arch.ltr_ppa_arch(i).act_info5 := null;
452: pay_emp_action_arch.ltr_ppa_arch(i).act_info6 := null;
453: pay_emp_action_arch.ltr_ppa_arch(i).act_info7 := null;
454: pay_emp_action_arch.ltr_ppa_arch(i).act_info8 := null;
455: pay_emp_action_arch.ltr_ppa_arch(i).act_info9 := null;
456: pay_emp_action_arch.ltr_ppa_arch(i).act_info10 := null;
457: pay_emp_action_arch.ltr_ppa_arch(i).act_info11 := null;
458: pay_emp_action_arch.ltr_ppa_arch(i).act_info12 := null;
459: pay_emp_action_arch.ltr_ppa_arch(i).act_info13 := null;
452: pay_emp_action_arch.ltr_ppa_arch(i).act_info6 := null;
453: pay_emp_action_arch.ltr_ppa_arch(i).act_info7 := null;
454: pay_emp_action_arch.ltr_ppa_arch(i).act_info8 := null;
455: pay_emp_action_arch.ltr_ppa_arch(i).act_info9 := null;
456: pay_emp_action_arch.ltr_ppa_arch(i).act_info10 := null;
457: pay_emp_action_arch.ltr_ppa_arch(i).act_info11 := null;
458: pay_emp_action_arch.ltr_ppa_arch(i).act_info12 := null;
459: pay_emp_action_arch.ltr_ppa_arch(i).act_info13 := null;
460: pay_emp_action_arch.ltr_ppa_arch(i).act_info14 := null;
453: pay_emp_action_arch.ltr_ppa_arch(i).act_info7 := null;
454: pay_emp_action_arch.ltr_ppa_arch(i).act_info8 := null;
455: pay_emp_action_arch.ltr_ppa_arch(i).act_info9 := null;
456: pay_emp_action_arch.ltr_ppa_arch(i).act_info10 := null;
457: pay_emp_action_arch.ltr_ppa_arch(i).act_info11 := null;
458: pay_emp_action_arch.ltr_ppa_arch(i).act_info12 := null;
459: pay_emp_action_arch.ltr_ppa_arch(i).act_info13 := null;
460: pay_emp_action_arch.ltr_ppa_arch(i).act_info14 := null;
461: pay_emp_action_arch.ltr_ppa_arch(i).act_info15 := null;
454: pay_emp_action_arch.ltr_ppa_arch(i).act_info8 := null;
455: pay_emp_action_arch.ltr_ppa_arch(i).act_info9 := null;
456: pay_emp_action_arch.ltr_ppa_arch(i).act_info10 := null;
457: pay_emp_action_arch.ltr_ppa_arch(i).act_info11 := null;
458: pay_emp_action_arch.ltr_ppa_arch(i).act_info12 := null;
459: pay_emp_action_arch.ltr_ppa_arch(i).act_info13 := null;
460: pay_emp_action_arch.ltr_ppa_arch(i).act_info14 := null;
461: pay_emp_action_arch.ltr_ppa_arch(i).act_info15 := null;
462: pay_emp_action_arch.ltr_ppa_arch(i).act_info16 := null;
455: pay_emp_action_arch.ltr_ppa_arch(i).act_info9 := null;
456: pay_emp_action_arch.ltr_ppa_arch(i).act_info10 := null;
457: pay_emp_action_arch.ltr_ppa_arch(i).act_info11 := null;
458: pay_emp_action_arch.ltr_ppa_arch(i).act_info12 := null;
459: pay_emp_action_arch.ltr_ppa_arch(i).act_info13 := null;
460: pay_emp_action_arch.ltr_ppa_arch(i).act_info14 := null;
461: pay_emp_action_arch.ltr_ppa_arch(i).act_info15 := null;
462: pay_emp_action_arch.ltr_ppa_arch(i).act_info16 := null;
463: pay_emp_action_arch.ltr_ppa_arch(i).act_info17 := null;
456: pay_emp_action_arch.ltr_ppa_arch(i).act_info10 := null;
457: pay_emp_action_arch.ltr_ppa_arch(i).act_info11 := null;
458: pay_emp_action_arch.ltr_ppa_arch(i).act_info12 := null;
459: pay_emp_action_arch.ltr_ppa_arch(i).act_info13 := null;
460: pay_emp_action_arch.ltr_ppa_arch(i).act_info14 := null;
461: pay_emp_action_arch.ltr_ppa_arch(i).act_info15 := null;
462: pay_emp_action_arch.ltr_ppa_arch(i).act_info16 := null;
463: pay_emp_action_arch.ltr_ppa_arch(i).act_info17 := null;
464: pay_emp_action_arch.ltr_ppa_arch(i).act_info18 := null;
457: pay_emp_action_arch.ltr_ppa_arch(i).act_info11 := null;
458: pay_emp_action_arch.ltr_ppa_arch(i).act_info12 := null;
459: pay_emp_action_arch.ltr_ppa_arch(i).act_info13 := null;
460: pay_emp_action_arch.ltr_ppa_arch(i).act_info14 := null;
461: pay_emp_action_arch.ltr_ppa_arch(i).act_info15 := null;
462: pay_emp_action_arch.ltr_ppa_arch(i).act_info16 := null;
463: pay_emp_action_arch.ltr_ppa_arch(i).act_info17 := null;
464: pay_emp_action_arch.ltr_ppa_arch(i).act_info18 := null;
465: pay_emp_action_arch.ltr_ppa_arch(i).act_info19 := null;
458: pay_emp_action_arch.ltr_ppa_arch(i).act_info12 := null;
459: pay_emp_action_arch.ltr_ppa_arch(i).act_info13 := null;
460: pay_emp_action_arch.ltr_ppa_arch(i).act_info14 := null;
461: pay_emp_action_arch.ltr_ppa_arch(i).act_info15 := null;
462: pay_emp_action_arch.ltr_ppa_arch(i).act_info16 := null;
463: pay_emp_action_arch.ltr_ppa_arch(i).act_info17 := null;
464: pay_emp_action_arch.ltr_ppa_arch(i).act_info18 := null;
465: pay_emp_action_arch.ltr_ppa_arch(i).act_info19 := null;
466: pay_emp_action_arch.ltr_ppa_arch(i).act_info20 := null;
459: pay_emp_action_arch.ltr_ppa_arch(i).act_info13 := null;
460: pay_emp_action_arch.ltr_ppa_arch(i).act_info14 := null;
461: pay_emp_action_arch.ltr_ppa_arch(i).act_info15 := null;
462: pay_emp_action_arch.ltr_ppa_arch(i).act_info16 := null;
463: pay_emp_action_arch.ltr_ppa_arch(i).act_info17 := null;
464: pay_emp_action_arch.ltr_ppa_arch(i).act_info18 := null;
465: pay_emp_action_arch.ltr_ppa_arch(i).act_info19 := null;
466: pay_emp_action_arch.ltr_ppa_arch(i).act_info20 := null;
467: pay_emp_action_arch.ltr_ppa_arch(i).act_info21 := null;
460: pay_emp_action_arch.ltr_ppa_arch(i).act_info14 := null;
461: pay_emp_action_arch.ltr_ppa_arch(i).act_info15 := null;
462: pay_emp_action_arch.ltr_ppa_arch(i).act_info16 := null;
463: pay_emp_action_arch.ltr_ppa_arch(i).act_info17 := null;
464: pay_emp_action_arch.ltr_ppa_arch(i).act_info18 := null;
465: pay_emp_action_arch.ltr_ppa_arch(i).act_info19 := null;
466: pay_emp_action_arch.ltr_ppa_arch(i).act_info20 := null;
467: pay_emp_action_arch.ltr_ppa_arch(i).act_info21 := null;
468: pay_emp_action_arch.ltr_ppa_arch(i).act_info22 := null;
461: pay_emp_action_arch.ltr_ppa_arch(i).act_info15 := null;
462: pay_emp_action_arch.ltr_ppa_arch(i).act_info16 := null;
463: pay_emp_action_arch.ltr_ppa_arch(i).act_info17 := null;
464: pay_emp_action_arch.ltr_ppa_arch(i).act_info18 := null;
465: pay_emp_action_arch.ltr_ppa_arch(i).act_info19 := null;
466: pay_emp_action_arch.ltr_ppa_arch(i).act_info20 := null;
467: pay_emp_action_arch.ltr_ppa_arch(i).act_info21 := null;
468: pay_emp_action_arch.ltr_ppa_arch(i).act_info22 := null;
469: pay_emp_action_arch.ltr_ppa_arch(i).act_info23 := null;
462: pay_emp_action_arch.ltr_ppa_arch(i).act_info16 := null;
463: pay_emp_action_arch.ltr_ppa_arch(i).act_info17 := null;
464: pay_emp_action_arch.ltr_ppa_arch(i).act_info18 := null;
465: pay_emp_action_arch.ltr_ppa_arch(i).act_info19 := null;
466: pay_emp_action_arch.ltr_ppa_arch(i).act_info20 := null;
467: pay_emp_action_arch.ltr_ppa_arch(i).act_info21 := null;
468: pay_emp_action_arch.ltr_ppa_arch(i).act_info22 := null;
469: pay_emp_action_arch.ltr_ppa_arch(i).act_info23 := null;
470: pay_emp_action_arch.ltr_ppa_arch(i).act_info24 := null;
463: pay_emp_action_arch.ltr_ppa_arch(i).act_info17 := null;
464: pay_emp_action_arch.ltr_ppa_arch(i).act_info18 := null;
465: pay_emp_action_arch.ltr_ppa_arch(i).act_info19 := null;
466: pay_emp_action_arch.ltr_ppa_arch(i).act_info20 := null;
467: pay_emp_action_arch.ltr_ppa_arch(i).act_info21 := null;
468: pay_emp_action_arch.ltr_ppa_arch(i).act_info22 := null;
469: pay_emp_action_arch.ltr_ppa_arch(i).act_info23 := null;
470: pay_emp_action_arch.ltr_ppa_arch(i).act_info24 := null;
471: pay_emp_action_arch.ltr_ppa_arch(i).act_info25 := null;
464: pay_emp_action_arch.ltr_ppa_arch(i).act_info18 := null;
465: pay_emp_action_arch.ltr_ppa_arch(i).act_info19 := null;
466: pay_emp_action_arch.ltr_ppa_arch(i).act_info20 := null;
467: pay_emp_action_arch.ltr_ppa_arch(i).act_info21 := null;
468: pay_emp_action_arch.ltr_ppa_arch(i).act_info22 := null;
469: pay_emp_action_arch.ltr_ppa_arch(i).act_info23 := null;
470: pay_emp_action_arch.ltr_ppa_arch(i).act_info24 := null;
471: pay_emp_action_arch.ltr_ppa_arch(i).act_info25 := null;
472: pay_emp_action_arch.ltr_ppa_arch(i).act_info26 := null;
465: pay_emp_action_arch.ltr_ppa_arch(i).act_info19 := null;
466: pay_emp_action_arch.ltr_ppa_arch(i).act_info20 := null;
467: pay_emp_action_arch.ltr_ppa_arch(i).act_info21 := null;
468: pay_emp_action_arch.ltr_ppa_arch(i).act_info22 := null;
469: pay_emp_action_arch.ltr_ppa_arch(i).act_info23 := null;
470: pay_emp_action_arch.ltr_ppa_arch(i).act_info24 := null;
471: pay_emp_action_arch.ltr_ppa_arch(i).act_info25 := null;
472: pay_emp_action_arch.ltr_ppa_arch(i).act_info26 := null;
473: pay_emp_action_arch.ltr_ppa_arch(i).act_info27 := null;
466: pay_emp_action_arch.ltr_ppa_arch(i).act_info20 := null;
467: pay_emp_action_arch.ltr_ppa_arch(i).act_info21 := null;
468: pay_emp_action_arch.ltr_ppa_arch(i).act_info22 := null;
469: pay_emp_action_arch.ltr_ppa_arch(i).act_info23 := null;
470: pay_emp_action_arch.ltr_ppa_arch(i).act_info24 := null;
471: pay_emp_action_arch.ltr_ppa_arch(i).act_info25 := null;
472: pay_emp_action_arch.ltr_ppa_arch(i).act_info26 := null;
473: pay_emp_action_arch.ltr_ppa_arch(i).act_info27 := null;
474: pay_emp_action_arch.ltr_ppa_arch(i).act_info28 := null;
467: pay_emp_action_arch.ltr_ppa_arch(i).act_info21 := null;
468: pay_emp_action_arch.ltr_ppa_arch(i).act_info22 := null;
469: pay_emp_action_arch.ltr_ppa_arch(i).act_info23 := null;
470: pay_emp_action_arch.ltr_ppa_arch(i).act_info24 := null;
471: pay_emp_action_arch.ltr_ppa_arch(i).act_info25 := null;
472: pay_emp_action_arch.ltr_ppa_arch(i).act_info26 := null;
473: pay_emp_action_arch.ltr_ppa_arch(i).act_info27 := null;
474: pay_emp_action_arch.ltr_ppa_arch(i).act_info28 := null;
475: pay_emp_action_arch.ltr_ppa_arch(i).act_info29 := null;
468: pay_emp_action_arch.ltr_ppa_arch(i).act_info22 := null;
469: pay_emp_action_arch.ltr_ppa_arch(i).act_info23 := null;
470: pay_emp_action_arch.ltr_ppa_arch(i).act_info24 := null;
471: pay_emp_action_arch.ltr_ppa_arch(i).act_info25 := null;
472: pay_emp_action_arch.ltr_ppa_arch(i).act_info26 := null;
473: pay_emp_action_arch.ltr_ppa_arch(i).act_info27 := null;
474: pay_emp_action_arch.ltr_ppa_arch(i).act_info28 := null;
475: pay_emp_action_arch.ltr_ppa_arch(i).act_info29 := null;
476: pay_emp_action_arch.ltr_ppa_arch(i).act_info30 := null;
469: pay_emp_action_arch.ltr_ppa_arch(i).act_info23 := null;
470: pay_emp_action_arch.ltr_ppa_arch(i).act_info24 := null;
471: pay_emp_action_arch.ltr_ppa_arch(i).act_info25 := null;
472: pay_emp_action_arch.ltr_ppa_arch(i).act_info26 := null;
473: pay_emp_action_arch.ltr_ppa_arch(i).act_info27 := null;
474: pay_emp_action_arch.ltr_ppa_arch(i).act_info28 := null;
475: pay_emp_action_arch.ltr_ppa_arch(i).act_info29 := null;
476: pay_emp_action_arch.ltr_ppa_arch(i).act_info30 := null;
477: end loop;
470: pay_emp_action_arch.ltr_ppa_arch(i).act_info24 := null;
471: pay_emp_action_arch.ltr_ppa_arch(i).act_info25 := null;
472: pay_emp_action_arch.ltr_ppa_arch(i).act_info26 := null;
473: pay_emp_action_arch.ltr_ppa_arch(i).act_info27 := null;
474: pay_emp_action_arch.ltr_ppa_arch(i).act_info28 := null;
475: pay_emp_action_arch.ltr_ppa_arch(i).act_info29 := null;
476: pay_emp_action_arch.ltr_ppa_arch(i).act_info30 := null;
477: end loop;
478: end if;
471: pay_emp_action_arch.ltr_ppa_arch(i).act_info25 := null;
472: pay_emp_action_arch.ltr_ppa_arch(i).act_info26 := null;
473: pay_emp_action_arch.ltr_ppa_arch(i).act_info27 := null;
474: pay_emp_action_arch.ltr_ppa_arch(i).act_info28 := null;
475: pay_emp_action_arch.ltr_ppa_arch(i).act_info29 := null;
476: pay_emp_action_arch.ltr_ppa_arch(i).act_info30 := null;
477: end loop;
478: end if;
479: pay_emp_action_arch.ltr_ppa_arch.delete;
472: pay_emp_action_arch.ltr_ppa_arch(i).act_info26 := null;
473: pay_emp_action_arch.ltr_ppa_arch(i).act_info27 := null;
474: pay_emp_action_arch.ltr_ppa_arch(i).act_info28 := null;
475: pay_emp_action_arch.ltr_ppa_arch(i).act_info29 := null;
476: pay_emp_action_arch.ltr_ppa_arch(i).act_info30 := null;
477: end loop;
478: end if;
479: pay_emp_action_arch.ltr_ppa_arch.delete;
480:
475: pay_emp_action_arch.ltr_ppa_arch(i).act_info29 := null;
476: pay_emp_action_arch.ltr_ppa_arch(i).act_info30 := null;
477: end loop;
478: end if;
479: pay_emp_action_arch.ltr_ppa_arch.delete;
480:
481: hr_utility.set_location(gv_package || lv_procedure_name, 50);
482: END initialization_process;
483:
494: ,p_action_context_type in varchar2
495: ,p_assignment_id in number
496: ,p_tax_unit_id in number
497: ,p_curr_pymt_eff_date in date
498: ,p_tab_rec_data in pay_emp_action_arch.action_info_table
499: )
500:
501: IS
502: l_action_information_id_1 NUMBER ;
935: hr_utility.trace('lv_value ' || lv_value);
936: hr_utility.trace('lv_name ' || lv_info_type);
937: hr_utility.trace('lv_value_type ' || lv_value_type);
938:
939: ln_index := pay_emp_action_arch.lrr_act_tab.count;
940:
941: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category
942: := 'EMPLOYEE OTHER INFORMATION';
943: pay_emp_action_arch.lrr_act_tab(ln_index).jurisdiction_code
937: hr_utility.trace('lv_value_type ' || lv_value_type);
938:
939: ln_index := pay_emp_action_arch.lrr_act_tab.count;
940:
941: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category
942: := 'EMPLOYEE OTHER INFORMATION';
943: pay_emp_action_arch.lrr_act_tab(ln_index).jurisdiction_code
944: := '00-000-0000';
945: pay_emp_action_arch.lrr_act_tab(ln_index).act_info1
939: ln_index := pay_emp_action_arch.lrr_act_tab.count;
940:
941: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category
942: := 'EMPLOYEE OTHER INFORMATION';
943: pay_emp_action_arch.lrr_act_tab(ln_index).jurisdiction_code
944: := '00-000-0000';
945: pay_emp_action_arch.lrr_act_tab(ln_index).act_info1
946: := p_organization_id;
947: pay_emp_action_arch.lrr_act_tab(ln_index).act_info2
941: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category
942: := 'EMPLOYEE OTHER INFORMATION';
943: pay_emp_action_arch.lrr_act_tab(ln_index).jurisdiction_code
944: := '00-000-0000';
945: pay_emp_action_arch.lrr_act_tab(ln_index).act_info1
946: := p_organization_id;
947: pay_emp_action_arch.lrr_act_tab(ln_index).act_info2
948: := lv_info_type;
949: pay_emp_action_arch.lrr_act_tab(ln_index).act_info4
943: pay_emp_action_arch.lrr_act_tab(ln_index).jurisdiction_code
944: := '00-000-0000';
945: pay_emp_action_arch.lrr_act_tab(ln_index).act_info1
946: := p_organization_id;
947: pay_emp_action_arch.lrr_act_tab(ln_index).act_info2
948: := lv_info_type;
949: pay_emp_action_arch.lrr_act_tab(ln_index).act_info4
950: := nvl(lv_display_name,lv_name) ;
951: pay_emp_action_arch.lrr_act_tab(ln_index).act_info5
945: pay_emp_action_arch.lrr_act_tab(ln_index).act_info1
946: := p_organization_id;
947: pay_emp_action_arch.lrr_act_tab(ln_index).act_info2
948: := lv_info_type;
949: pay_emp_action_arch.lrr_act_tab(ln_index).act_info4
950: := nvl(lv_display_name,lv_name) ;
951: pay_emp_action_arch.lrr_act_tab(ln_index).act_info5
952: := lv_value_type ;
953: pay_emp_action_arch.lrr_act_tab(ln_index).act_info6
947: pay_emp_action_arch.lrr_act_tab(ln_index).act_info2
948: := lv_info_type;
949: pay_emp_action_arch.lrr_act_tab(ln_index).act_info4
950: := nvl(lv_display_name,lv_name) ;
951: pay_emp_action_arch.lrr_act_tab(ln_index).act_info5
952: := lv_value_type ;
953: pay_emp_action_arch.lrr_act_tab(ln_index).act_info6
954: := lv_value;
955: pay_emp_action_arch.lrr_act_tab(ln_index).act_info7
949: pay_emp_action_arch.lrr_act_tab(ln_index).act_info4
950: := nvl(lv_display_name,lv_name) ;
951: pay_emp_action_arch.lrr_act_tab(ln_index).act_info5
952: := lv_value_type ;
953: pay_emp_action_arch.lrr_act_tab(ln_index).act_info6
954: := lv_value;
955: pay_emp_action_arch.lrr_act_tab(ln_index).act_info7
956: := ln_element_type_id;
957: pay_emp_action_arch.lrr_act_tab(ln_index).act_info8
951: pay_emp_action_arch.lrr_act_tab(ln_index).act_info5
952: := lv_value_type ;
953: pay_emp_action_arch.lrr_act_tab(ln_index).act_info6
954: := lv_value;
955: pay_emp_action_arch.lrr_act_tab(ln_index).act_info7
956: := ln_element_type_id;
957: pay_emp_action_arch.lrr_act_tab(ln_index).act_info8
958: := ln_input_value_id;
959: -- Bug 5707497
953: pay_emp_action_arch.lrr_act_tab(ln_index).act_info6
954: := lv_value;
955: pay_emp_action_arch.lrr_act_tab(ln_index).act_info7
956: := ln_element_type_id;
957: pay_emp_action_arch.lrr_act_tab(ln_index).act_info8
958: := ln_input_value_id;
959: -- Bug 5707497
960: pay_emp_action_arch.lrr_act_tab(ln_index).act_info11
961: := lv_uom;
956: := ln_element_type_id;
957: pay_emp_action_arch.lrr_act_tab(ln_index).act_info8
958: := ln_input_value_id;
959: -- Bug 5707497
960: pay_emp_action_arch.lrr_act_tab(ln_index).act_info11
961: := lv_uom;
962: --Added for bug 8827140
963: pay_emp_action_arch.lrr_act_tab(ln_index).act_info14
964: := nvl(lv_display_name,lv_reporting_name);
959: -- Bug 5707497
960: pay_emp_action_arch.lrr_act_tab(ln_index).act_info11
961: := lv_uom;
962: --Added for bug 8827140
963: pay_emp_action_arch.lrr_act_tab(ln_index).act_info14
964: := nvl(lv_display_name,lv_reporting_name);
965: end if;
966: close c_element_details;
967:
1000: lv_value := nvl(pay_balance_pkg.get_value(ln_defined_balance_id,
1001: ln_run_action_id),0);
1002: if lv_value <> 0 then
1003: hr_utility.set_location(gv_package || lv_procedure_name, 110);
1004: ln_index := pay_emp_action_arch.lrr_act_tab.count;
1005:
1006: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category
1007: := 'EMPLOYEE OTHER INFORMATION';
1008: pay_emp_action_arch.lrr_act_tab(ln_index).jurisdiction_code
1002: if lv_value <> 0 then
1003: hr_utility.set_location(gv_package || lv_procedure_name, 110);
1004: ln_index := pay_emp_action_arch.lrr_act_tab.count;
1005:
1006: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category
1007: := 'EMPLOYEE OTHER INFORMATION';
1008: pay_emp_action_arch.lrr_act_tab(ln_index).jurisdiction_code
1009: := '00-000-0000';
1010: pay_emp_action_arch.lrr_act_tab(ln_index).act_info1
1004: ln_index := pay_emp_action_arch.lrr_act_tab.count;
1005:
1006: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category
1007: := 'EMPLOYEE OTHER INFORMATION';
1008: pay_emp_action_arch.lrr_act_tab(ln_index).jurisdiction_code
1009: := '00-000-0000';
1010: pay_emp_action_arch.lrr_act_tab(ln_index).act_info1
1011: := p_organization_id;
1012: pay_emp_action_arch.lrr_act_tab(ln_index).act_info2
1006: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category
1007: := 'EMPLOYEE OTHER INFORMATION';
1008: pay_emp_action_arch.lrr_act_tab(ln_index).jurisdiction_code
1009: := '00-000-0000';
1010: pay_emp_action_arch.lrr_act_tab(ln_index).act_info1
1011: := p_organization_id;
1012: pay_emp_action_arch.lrr_act_tab(ln_index).act_info2
1013: := lv_info_type;
1014: pay_emp_action_arch.lrr_act_tab(ln_index).act_info4
1008: pay_emp_action_arch.lrr_act_tab(ln_index).jurisdiction_code
1009: := '00-000-0000';
1010: pay_emp_action_arch.lrr_act_tab(ln_index).act_info1
1011: := p_organization_id;
1012: pay_emp_action_arch.lrr_act_tab(ln_index).act_info2
1013: := lv_info_type;
1014: pay_emp_action_arch.lrr_act_tab(ln_index).act_info4
1015: := nvl(lv_display_name,lv_name) ;
1016: pay_emp_action_arch.lrr_act_tab(ln_index).act_info5
1010: pay_emp_action_arch.lrr_act_tab(ln_index).act_info1
1011: := p_organization_id;
1012: pay_emp_action_arch.lrr_act_tab(ln_index).act_info2
1013: := lv_info_type;
1014: pay_emp_action_arch.lrr_act_tab(ln_index).act_info4
1015: := nvl(lv_display_name,lv_name) ;
1016: pay_emp_action_arch.lrr_act_tab(ln_index).act_info5
1017: := lv_value_type ;
1018: pay_emp_action_arch.lrr_act_tab(ln_index).act_info6
1012: pay_emp_action_arch.lrr_act_tab(ln_index).act_info2
1013: := lv_info_type;
1014: pay_emp_action_arch.lrr_act_tab(ln_index).act_info4
1015: := nvl(lv_display_name,lv_name) ;
1016: pay_emp_action_arch.lrr_act_tab(ln_index).act_info5
1017: := lv_value_type ;
1018: pay_emp_action_arch.lrr_act_tab(ln_index).act_info6
1019: := fnd_number.number_to_canonical(lv_value); /*bug 4225799*/
1020: pay_emp_action_arch.lrr_act_tab(ln_index).act_info9
1014: pay_emp_action_arch.lrr_act_tab(ln_index).act_info4
1015: := nvl(lv_display_name,lv_name) ;
1016: pay_emp_action_arch.lrr_act_tab(ln_index).act_info5
1017: := lv_value_type ;
1018: pay_emp_action_arch.lrr_act_tab(ln_index).act_info6
1019: := fnd_number.number_to_canonical(lv_value); /*bug 4225799*/
1020: pay_emp_action_arch.lrr_act_tab(ln_index).act_info9
1021: := ln_balance_type_id;
1022: pay_emp_action_arch.lrr_act_tab(ln_index).act_info10
1016: pay_emp_action_arch.lrr_act_tab(ln_index).act_info5
1017: := lv_value_type ;
1018: pay_emp_action_arch.lrr_act_tab(ln_index).act_info6
1019: := fnd_number.number_to_canonical(lv_value); /*bug 4225799*/
1020: pay_emp_action_arch.lrr_act_tab(ln_index).act_info9
1021: := ln_balance_type_id;
1022: pay_emp_action_arch.lrr_act_tab(ln_index).act_info10
1023: := ln_balance_dimension_id;
1024: -- Bug 5707497
1018: pay_emp_action_arch.lrr_act_tab(ln_index).act_info6
1019: := fnd_number.number_to_canonical(lv_value); /*bug 4225799*/
1020: pay_emp_action_arch.lrr_act_tab(ln_index).act_info9
1021: := ln_balance_type_id;
1022: pay_emp_action_arch.lrr_act_tab(ln_index).act_info10
1023: := ln_balance_dimension_id;
1024: -- Bug 5707497
1025: pay_emp_action_arch.lrr_act_tab(ln_index).act_info11
1026: := lv_uom;
1021: := ln_balance_type_id;
1022: pay_emp_action_arch.lrr_act_tab(ln_index).act_info10
1023: := ln_balance_dimension_id;
1024: -- Bug 5707497
1025: pay_emp_action_arch.lrr_act_tab(ln_index).act_info11
1026: := lv_uom;
1027: --Added for bug 8827140
1028: pay_emp_action_arch.lrr_act_tab(ln_index).act_info14
1029: := nvl(lv_display_name,lv_reporting_name);
1024: -- Bug 5707497
1025: pay_emp_action_arch.lrr_act_tab(ln_index).act_info11
1026: := lv_uom;
1027: --Added for bug 8827140
1028: pay_emp_action_arch.lrr_act_tab(ln_index).act_info14
1029: := nvl(lv_display_name,lv_reporting_name);
1030: end if;
1031: end if;
1032: close c_defined_balance_id;
1033:
1034: end if;
1035:
1036: hr_utility.trace('ln_index in get_employee_other_info proc is '
1037: || pay_emp_action_arch.lrr_act_tab.count);
1038: hr_utility.trace('lv_info_type is'||lv_info_type);
1039:
1040: end loop;
1041: close c_organization_info;
1082: if lv_uom in ('M', 'N', 'I') then
1083: lv_value := fnd_number.number_to_canonical(lv_value);
1084: end if;
1085:
1086: ln_index := pay_emp_action_arch.lrr_act_tab.count;
1087: hr_utility.trace('lv_name ' || lv_info_type);
1088: hr_utility.trace('lv_value ' || lv_value);
1089: hr_utility.trace('lv_value_type ' || lv_value_type);
1090:
1087: hr_utility.trace('lv_name ' || lv_info_type);
1088: hr_utility.trace('lv_value ' || lv_value);
1089: hr_utility.trace('lv_value_type ' || lv_value_type);
1090:
1091: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category
1092: := 'EMPLOYEE OTHER INFORMATION';
1093: pay_emp_action_arch.lrr_act_tab(ln_index).jurisdiction_code
1094: := '00-000-0000';
1095: pay_emp_action_arch.lrr_act_tab(ln_index).act_info1
1089: hr_utility.trace('lv_value_type ' || lv_value_type);
1090:
1091: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category
1092: := 'EMPLOYEE OTHER INFORMATION';
1093: pay_emp_action_arch.lrr_act_tab(ln_index).jurisdiction_code
1094: := '00-000-0000';
1095: pay_emp_action_arch.lrr_act_tab(ln_index).act_info1
1096: := p_business_group_id;
1097: pay_emp_action_arch.lrr_act_tab(ln_index).act_info2
1091: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category
1092: := 'EMPLOYEE OTHER INFORMATION';
1093: pay_emp_action_arch.lrr_act_tab(ln_index).jurisdiction_code
1094: := '00-000-0000';
1095: pay_emp_action_arch.lrr_act_tab(ln_index).act_info1
1096: := p_business_group_id;
1097: pay_emp_action_arch.lrr_act_tab(ln_index).act_info2
1098: := lv_info_type;
1099: pay_emp_action_arch.lrr_act_tab(ln_index).act_info4
1093: pay_emp_action_arch.lrr_act_tab(ln_index).jurisdiction_code
1094: := '00-000-0000';
1095: pay_emp_action_arch.lrr_act_tab(ln_index).act_info1
1096: := p_business_group_id;
1097: pay_emp_action_arch.lrr_act_tab(ln_index).act_info2
1098: := lv_info_type;
1099: pay_emp_action_arch.lrr_act_tab(ln_index).act_info4
1100: := nvl(lv_display_name,lv_name) ;
1101: pay_emp_action_arch.lrr_act_tab(ln_index).act_info5
1095: pay_emp_action_arch.lrr_act_tab(ln_index).act_info1
1096: := p_business_group_id;
1097: pay_emp_action_arch.lrr_act_tab(ln_index).act_info2
1098: := lv_info_type;
1099: pay_emp_action_arch.lrr_act_tab(ln_index).act_info4
1100: := nvl(lv_display_name,lv_name) ;
1101: pay_emp_action_arch.lrr_act_tab(ln_index).act_info5
1102: := lv_value_type ;
1103: pay_emp_action_arch.lrr_act_tab(ln_index).act_info6
1097: pay_emp_action_arch.lrr_act_tab(ln_index).act_info2
1098: := lv_info_type;
1099: pay_emp_action_arch.lrr_act_tab(ln_index).act_info4
1100: := nvl(lv_display_name,lv_name) ;
1101: pay_emp_action_arch.lrr_act_tab(ln_index).act_info5
1102: := lv_value_type ;
1103: pay_emp_action_arch.lrr_act_tab(ln_index).act_info6
1104: := lv_value;
1105: pay_emp_action_arch.lrr_act_tab(ln_index).act_info7
1099: pay_emp_action_arch.lrr_act_tab(ln_index).act_info4
1100: := nvl(lv_display_name,lv_name) ;
1101: pay_emp_action_arch.lrr_act_tab(ln_index).act_info5
1102: := lv_value_type ;
1103: pay_emp_action_arch.lrr_act_tab(ln_index).act_info6
1104: := lv_value;
1105: pay_emp_action_arch.lrr_act_tab(ln_index).act_info7
1106: := ln_element_type_id;
1107: pay_emp_action_arch.lrr_act_tab(ln_index).act_info8
1101: pay_emp_action_arch.lrr_act_tab(ln_index).act_info5
1102: := lv_value_type ;
1103: pay_emp_action_arch.lrr_act_tab(ln_index).act_info6
1104: := lv_value;
1105: pay_emp_action_arch.lrr_act_tab(ln_index).act_info7
1106: := ln_element_type_id;
1107: pay_emp_action_arch.lrr_act_tab(ln_index).act_info8
1108: := ln_input_value_id;
1109: -- Bug 5707497
1103: pay_emp_action_arch.lrr_act_tab(ln_index).act_info6
1104: := lv_value;
1105: pay_emp_action_arch.lrr_act_tab(ln_index).act_info7
1106: := ln_element_type_id;
1107: pay_emp_action_arch.lrr_act_tab(ln_index).act_info8
1108: := ln_input_value_id;
1109: -- Bug 5707497
1110: pay_emp_action_arch.lrr_act_tab(ln_index).act_info11
1111: := lv_uom;
1106: := ln_element_type_id;
1107: pay_emp_action_arch.lrr_act_tab(ln_index).act_info8
1108: := ln_input_value_id;
1109: -- Bug 5707497
1110: pay_emp_action_arch.lrr_act_tab(ln_index).act_info11
1111: := lv_uom;
1112: --Added for bug 8827140
1113: pay_emp_action_arch.lrr_act_tab(ln_index).act_info14
1114: := nvl(lv_display_name,lv_reporting_name);
1109: -- Bug 5707497
1110: pay_emp_action_arch.lrr_act_tab(ln_index).act_info11
1111: := lv_uom;
1112: --Added for bug 8827140
1113: pay_emp_action_arch.lrr_act_tab(ln_index).act_info14
1114: := nvl(lv_display_name,lv_reporting_name);
1115: end if;
1116: close c_element_details;
1117: elsif lv_info_type = 'BALANCE' then
1153:
1154: lv_value := nvl(pay_balance_pkg.get_value(ln_defined_balance_id,
1155: ln_run_action_id),0);
1156: if lv_value <> 0 then
1157: ln_index := pay_emp_action_arch.lrr_act_tab.count;
1158:
1159: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category
1160: := 'EMPLOYEE OTHER INFORMATION';
1161: pay_emp_action_arch.lrr_act_tab(ln_index).jurisdiction_code
1155: ln_run_action_id),0);
1156: if lv_value <> 0 then
1157: ln_index := pay_emp_action_arch.lrr_act_tab.count;
1158:
1159: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category
1160: := 'EMPLOYEE OTHER INFORMATION';
1161: pay_emp_action_arch.lrr_act_tab(ln_index).jurisdiction_code
1162: := '00-000-0000';
1163: pay_emp_action_arch.lrr_act_tab(ln_index).act_info1
1157: ln_index := pay_emp_action_arch.lrr_act_tab.count;
1158:
1159: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category
1160: := 'EMPLOYEE OTHER INFORMATION';
1161: pay_emp_action_arch.lrr_act_tab(ln_index).jurisdiction_code
1162: := '00-000-0000';
1163: pay_emp_action_arch.lrr_act_tab(ln_index).act_info1
1164: := p_business_group_id;
1165: pay_emp_action_arch.lrr_act_tab(ln_index).act_info2
1159: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category
1160: := 'EMPLOYEE OTHER INFORMATION';
1161: pay_emp_action_arch.lrr_act_tab(ln_index).jurisdiction_code
1162: := '00-000-0000';
1163: pay_emp_action_arch.lrr_act_tab(ln_index).act_info1
1164: := p_business_group_id;
1165: pay_emp_action_arch.lrr_act_tab(ln_index).act_info2
1166: := lv_info_type;
1167: pay_emp_action_arch.lrr_act_tab(ln_index).act_info4
1161: pay_emp_action_arch.lrr_act_tab(ln_index).jurisdiction_code
1162: := '00-000-0000';
1163: pay_emp_action_arch.lrr_act_tab(ln_index).act_info1
1164: := p_business_group_id;
1165: pay_emp_action_arch.lrr_act_tab(ln_index).act_info2
1166: := lv_info_type;
1167: pay_emp_action_arch.lrr_act_tab(ln_index).act_info4
1168: := nvl(lv_display_name,lv_name) ;
1169: pay_emp_action_arch.lrr_act_tab(ln_index).act_info5
1163: pay_emp_action_arch.lrr_act_tab(ln_index).act_info1
1164: := p_business_group_id;
1165: pay_emp_action_arch.lrr_act_tab(ln_index).act_info2
1166: := lv_info_type;
1167: pay_emp_action_arch.lrr_act_tab(ln_index).act_info4
1168: := nvl(lv_display_name,lv_name) ;
1169: pay_emp_action_arch.lrr_act_tab(ln_index).act_info5
1170: := lv_value_type ;
1171: pay_emp_action_arch.lrr_act_tab(ln_index).act_info6
1165: pay_emp_action_arch.lrr_act_tab(ln_index).act_info2
1166: := lv_info_type;
1167: pay_emp_action_arch.lrr_act_tab(ln_index).act_info4
1168: := nvl(lv_display_name,lv_name) ;
1169: pay_emp_action_arch.lrr_act_tab(ln_index).act_info5
1170: := lv_value_type ;
1171: pay_emp_action_arch.lrr_act_tab(ln_index).act_info6
1172: := fnd_number.number_to_canonical(lv_value); /*bug 4225799*/
1173: pay_emp_action_arch.lrr_act_tab(ln_index).act_info9
1167: pay_emp_action_arch.lrr_act_tab(ln_index).act_info4
1168: := nvl(lv_display_name,lv_name) ;
1169: pay_emp_action_arch.lrr_act_tab(ln_index).act_info5
1170: := lv_value_type ;
1171: pay_emp_action_arch.lrr_act_tab(ln_index).act_info6
1172: := fnd_number.number_to_canonical(lv_value); /*bug 4225799*/
1173: pay_emp_action_arch.lrr_act_tab(ln_index).act_info9
1174: := ln_balance_type_id;
1175: pay_emp_action_arch.lrr_act_tab(ln_index).act_info10
1169: pay_emp_action_arch.lrr_act_tab(ln_index).act_info5
1170: := lv_value_type ;
1171: pay_emp_action_arch.lrr_act_tab(ln_index).act_info6
1172: := fnd_number.number_to_canonical(lv_value); /*bug 4225799*/
1173: pay_emp_action_arch.lrr_act_tab(ln_index).act_info9
1174: := ln_balance_type_id;
1175: pay_emp_action_arch.lrr_act_tab(ln_index).act_info10
1176: := ln_balance_dimension_id;
1177: -- Bug 5707497
1171: pay_emp_action_arch.lrr_act_tab(ln_index).act_info6
1172: := fnd_number.number_to_canonical(lv_value); /*bug 4225799*/
1173: pay_emp_action_arch.lrr_act_tab(ln_index).act_info9
1174: := ln_balance_type_id;
1175: pay_emp_action_arch.lrr_act_tab(ln_index).act_info10
1176: := ln_balance_dimension_id;
1177: -- Bug 5707497
1178: pay_emp_action_arch.lrr_act_tab(ln_index).act_info11
1179: := lv_uom;
1174: := ln_balance_type_id;
1175: pay_emp_action_arch.lrr_act_tab(ln_index).act_info10
1176: := ln_balance_dimension_id;
1177: -- Bug 5707497
1178: pay_emp_action_arch.lrr_act_tab(ln_index).act_info11
1179: := lv_uom;
1180: --Added for bug 8827140
1181: pay_emp_action_arch.lrr_act_tab(ln_index).act_info14
1182: := nvl(lv_display_name,lv_reporting_name);
1177: -- Bug 5707497
1178: pay_emp_action_arch.lrr_act_tab(ln_index).act_info11
1179: := lv_uom;
1180: --Added for bug 8827140
1181: pay_emp_action_arch.lrr_act_tab(ln_index).act_info14
1182: := nvl(lv_display_name,lv_reporting_name);
1183: end if; -- lv_value > 0 then
1184: end if;
1185: close c_defined_balance_id;
1222: if pay_us_emp_payslip_accrual_web.ltr_assignment_accruals.count > 0 then
1223: for i in pay_us_emp_payslip_accrual_web.ltr_assignment_accruals.first ..
1224: pay_us_emp_payslip_accrual_web.ltr_assignment_accruals.last loop
1225:
1226: ln_index := pay_emp_action_arch.lrr_act_tab.count;
1227:
1228: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category
1229: := 'EMPLOYEE ACCRUALS';
1230: pay_emp_action_arch.lrr_act_tab(ln_index).jurisdiction_code
1224: pay_us_emp_payslip_accrual_web.ltr_assignment_accruals.last loop
1225:
1226: ln_index := pay_emp_action_arch.lrr_act_tab.count;
1227:
1228: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category
1229: := 'EMPLOYEE ACCRUALS';
1230: pay_emp_action_arch.lrr_act_tab(ln_index).jurisdiction_code
1231: := '00-000-0000';
1232: pay_emp_action_arch.lrr_act_tab(ln_index).act_info4
1226: ln_index := pay_emp_action_arch.lrr_act_tab.count;
1227:
1228: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category
1229: := 'EMPLOYEE ACCRUALS';
1230: pay_emp_action_arch.lrr_act_tab(ln_index).jurisdiction_code
1231: := '00-000-0000';
1232: pay_emp_action_arch.lrr_act_tab(ln_index).act_info4
1233: := pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i).accrual_category;
1234: /* Bug 3311866*/
1228: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category
1229: := 'EMPLOYEE ACCRUALS';
1230: pay_emp_action_arch.lrr_act_tab(ln_index).jurisdiction_code
1231: := '00-000-0000';
1232: pay_emp_action_arch.lrr_act_tab(ln_index).act_info4
1233: := pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i).accrual_category;
1234: /* Bug 3311866*/
1235: pay_emp_action_arch.lrr_act_tab(ln_index).act_info5
1236: := fnd_number.number_to_canonical
1231: := '00-000-0000';
1232: pay_emp_action_arch.lrr_act_tab(ln_index).act_info4
1233: := pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i).accrual_category;
1234: /* Bug 3311866*/
1235: pay_emp_action_arch.lrr_act_tab(ln_index).act_info5
1236: := fnd_number.number_to_canonical
1237: (pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i).accrual_cur_value);
1238: pay_emp_action_arch.lrr_act_tab(ln_index).act_info6
1239: := fnd_number.number_to_canonical
1234: /* Bug 3311866*/
1235: pay_emp_action_arch.lrr_act_tab(ln_index).act_info5
1236: := fnd_number.number_to_canonical
1237: (pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i).accrual_cur_value);
1238: pay_emp_action_arch.lrr_act_tab(ln_index).act_info6
1239: := fnd_number.number_to_canonical
1240: (pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i).accrual_net_value);
1241: pay_emp_action_arch.lrr_act_tab(ln_index).act_info7
1242: := pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i).accrual_code;
1237: (pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i).accrual_cur_value);
1238: pay_emp_action_arch.lrr_act_tab(ln_index).act_info6
1239: := fnd_number.number_to_canonical
1240: (pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i).accrual_net_value);
1241: pay_emp_action_arch.lrr_act_tab(ln_index).act_info7
1242: := pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i).accrual_code;
1243: end loop;
1244: end if;
1245:
1270: BEGIN
1271: lv_procedure_name := 'get_organization_name';
1272: lv_exists := 'N';
1273: hr_utility.trace('Entered get_organization_name');
1274: if pay_emp_action_arch.ltr_organizations.count > 0 then
1275: for i in pay_emp_action_arch.ltr_organizations.first ..
1276: pay_emp_action_arch.ltr_organizations.last loop
1277: if pay_emp_action_arch.ltr_organizations(i).id = p_organization_id then
1278: lv_organization_name := pay_emp_action_arch.ltr_organizations(i).name;
1271: lv_procedure_name := 'get_organization_name';
1272: lv_exists := 'N';
1273: hr_utility.trace('Entered get_organization_name');
1274: if pay_emp_action_arch.ltr_organizations.count > 0 then
1275: for i in pay_emp_action_arch.ltr_organizations.first ..
1276: pay_emp_action_arch.ltr_organizations.last loop
1277: if pay_emp_action_arch.ltr_organizations(i).id = p_organization_id then
1278: lv_organization_name := pay_emp_action_arch.ltr_organizations(i).name;
1279: lv_exists := 'Y';
1272: lv_exists := 'N';
1273: hr_utility.trace('Entered get_organization_name');
1274: if pay_emp_action_arch.ltr_organizations.count > 0 then
1275: for i in pay_emp_action_arch.ltr_organizations.first ..
1276: pay_emp_action_arch.ltr_organizations.last loop
1277: if pay_emp_action_arch.ltr_organizations(i).id = p_organization_id then
1278: lv_organization_name := pay_emp_action_arch.ltr_organizations(i).name;
1279: lv_exists := 'Y';
1280: exit;
1273: hr_utility.trace('Entered get_organization_name');
1274: if pay_emp_action_arch.ltr_organizations.count > 0 then
1275: for i in pay_emp_action_arch.ltr_organizations.first ..
1276: pay_emp_action_arch.ltr_organizations.last loop
1277: if pay_emp_action_arch.ltr_organizations(i).id = p_organization_id then
1278: lv_organization_name := pay_emp_action_arch.ltr_organizations(i).name;
1279: lv_exists := 'Y';
1280: exit;
1281: end if;
1274: if pay_emp_action_arch.ltr_organizations.count > 0 then
1275: for i in pay_emp_action_arch.ltr_organizations.first ..
1276: pay_emp_action_arch.ltr_organizations.last loop
1277: if pay_emp_action_arch.ltr_organizations(i).id = p_organization_id then
1278: lv_organization_name := pay_emp_action_arch.ltr_organizations(i).name;
1279: lv_exists := 'Y';
1280: exit;
1281: end if;
1282: end loop;
1285: if lv_exists = 'N' then
1286: open c_organization_name;
1287: fetch c_organization_name into lv_organization_name;
1288: close c_organization_name;
1289: ln_index := pay_emp_action_arch.ltr_organizations.count;
1290: pay_emp_action_arch.ltr_organizations(ln_index).id := p_organization_id;
1291: pay_emp_action_arch.ltr_organizations(ln_index).name := lv_organization_name;
1292: end if;
1293:
1286: open c_organization_name;
1287: fetch c_organization_name into lv_organization_name;
1288: close c_organization_name;
1289: ln_index := pay_emp_action_arch.ltr_organizations.count;
1290: pay_emp_action_arch.ltr_organizations(ln_index).id := p_organization_id;
1291: pay_emp_action_arch.ltr_organizations(ln_index).name := lv_organization_name;
1292: end if;
1293:
1294: hr_utility.trace('Leaving get_organization_name');
1287: fetch c_organization_name into lv_organization_name;
1288: close c_organization_name;
1289: ln_index := pay_emp_action_arch.ltr_organizations.count;
1290: pay_emp_action_arch.ltr_organizations(ln_index).id := p_organization_id;
1291: pay_emp_action_arch.ltr_organizations(ln_index).name := lv_organization_name;
1292: end if;
1293:
1294: hr_utility.trace('Leaving get_organization_name');
1295: return(lv_organization_name);
1326: lv_procedure_name := 'get_location';
1327: lv_exists := 'N';
1328: hr_utility.trace('Entered get_location');
1329:
1330: if pay_emp_action_arch.ltr_location.count > 0 then
1331: for i in pay_emp_action_arch.ltr_location.first ..
1332: pay_emp_action_arch.ltr_location.last loop
1333: if pay_emp_action_arch.ltr_location(i).id = p_location_id then
1334: lv_location_name := pay_emp_action_arch.ltr_location(i).name;
1327: lv_exists := 'N';
1328: hr_utility.trace('Entered get_location');
1329:
1330: if pay_emp_action_arch.ltr_location.count > 0 then
1331: for i in pay_emp_action_arch.ltr_location.first ..
1332: pay_emp_action_arch.ltr_location.last loop
1333: if pay_emp_action_arch.ltr_location(i).id = p_location_id then
1334: lv_location_name := pay_emp_action_arch.ltr_location(i).name;
1335: lv_exists := 'Y';
1328: hr_utility.trace('Entered get_location');
1329:
1330: if pay_emp_action_arch.ltr_location.count > 0 then
1331: for i in pay_emp_action_arch.ltr_location.first ..
1332: pay_emp_action_arch.ltr_location.last loop
1333: if pay_emp_action_arch.ltr_location(i).id = p_location_id then
1334: lv_location_name := pay_emp_action_arch.ltr_location(i).name;
1335: lv_exists := 'Y';
1336: exit;
1329:
1330: if pay_emp_action_arch.ltr_location.count > 0 then
1331: for i in pay_emp_action_arch.ltr_location.first ..
1332: pay_emp_action_arch.ltr_location.last loop
1333: if pay_emp_action_arch.ltr_location(i).id = p_location_id then
1334: lv_location_name := pay_emp_action_arch.ltr_location(i).name;
1335: lv_exists := 'Y';
1336: exit;
1337: end if;
1330: if pay_emp_action_arch.ltr_location.count > 0 then
1331: for i in pay_emp_action_arch.ltr_location.first ..
1332: pay_emp_action_arch.ltr_location.last loop
1333: if pay_emp_action_arch.ltr_location(i).id = p_location_id then
1334: lv_location_name := pay_emp_action_arch.ltr_location(i).name;
1335: lv_exists := 'Y';
1336: exit;
1337: end if;
1338: end loop;
1341: if lv_exists = 'N' then
1342: open c_location(p_location_id);
1343: fetch c_location into lv_location_name;
1344: close c_location;
1345: ln_index := pay_emp_action_arch.ltr_location.count;
1346: pay_emp_action_arch.ltr_location(ln_index).id := p_location_id;
1347: pay_emp_action_arch.ltr_location(ln_index).name := lv_location_name;
1348: end if;
1349:
1342: open c_location(p_location_id);
1343: fetch c_location into lv_location_name;
1344: close c_location;
1345: ln_index := pay_emp_action_arch.ltr_location.count;
1346: pay_emp_action_arch.ltr_location(ln_index).id := p_location_id;
1347: pay_emp_action_arch.ltr_location(ln_index).name := lv_location_name;
1348: end if;
1349:
1350: hr_utility.trace('Leaving get_location');
1343: fetch c_location into lv_location_name;
1344: close c_location;
1345: ln_index := pay_emp_action_arch.ltr_location.count;
1346: pay_emp_action_arch.ltr_location(ln_index).id := p_location_id;
1347: pay_emp_action_arch.ltr_location(ln_index).name := lv_location_name;
1348: end if;
1349:
1350: hr_utility.trace('Leaving get_location');
1351:
1385: BEGIN
1386: lv_procedure_name := 'get_job_name';
1387: lv_exists := 'N';
1388: hr_utility.trace('Entered get_job_name');
1389: if pay_emp_action_arch.ltr_jobs.count > 0 then
1390: for i in pay_emp_action_arch.ltr_jobs.first ..
1391: pay_emp_action_arch.ltr_jobs.last loop
1392: if pay_emp_action_arch.ltr_jobs(i).id = p_job_id then
1393: lv_job_name := pay_emp_action_arch.ltr_jobs(i).name;
1386: lv_procedure_name := 'get_job_name';
1387: lv_exists := 'N';
1388: hr_utility.trace('Entered get_job_name');
1389: if pay_emp_action_arch.ltr_jobs.count > 0 then
1390: for i in pay_emp_action_arch.ltr_jobs.first ..
1391: pay_emp_action_arch.ltr_jobs.last loop
1392: if pay_emp_action_arch.ltr_jobs(i).id = p_job_id then
1393: lv_job_name := pay_emp_action_arch.ltr_jobs(i).name;
1394: lv_exists := 'Y';
1387: lv_exists := 'N';
1388: hr_utility.trace('Entered get_job_name');
1389: if pay_emp_action_arch.ltr_jobs.count > 0 then
1390: for i in pay_emp_action_arch.ltr_jobs.first ..
1391: pay_emp_action_arch.ltr_jobs.last loop
1392: if pay_emp_action_arch.ltr_jobs(i).id = p_job_id then
1393: lv_job_name := pay_emp_action_arch.ltr_jobs(i).name;
1394: lv_exists := 'Y';
1395: exit;
1388: hr_utility.trace('Entered get_job_name');
1389: if pay_emp_action_arch.ltr_jobs.count > 0 then
1390: for i in pay_emp_action_arch.ltr_jobs.first ..
1391: pay_emp_action_arch.ltr_jobs.last loop
1392: if pay_emp_action_arch.ltr_jobs(i).id = p_job_id then
1393: lv_job_name := pay_emp_action_arch.ltr_jobs(i).name;
1394: lv_exists := 'Y';
1395: exit;
1396: end if;
1389: if pay_emp_action_arch.ltr_jobs.count > 0 then
1390: for i in pay_emp_action_arch.ltr_jobs.first ..
1391: pay_emp_action_arch.ltr_jobs.last loop
1392: if pay_emp_action_arch.ltr_jobs(i).id = p_job_id then
1393: lv_job_name := pay_emp_action_arch.ltr_jobs(i).name;
1394: lv_exists := 'Y';
1395: exit;
1396: end if;
1397: end loop;
1400: if lv_exists = 'N' then
1401: open c_job_name(p_job_id, p_effective_date);
1402: fetch c_job_name into lv_job_name;
1403: close c_job_name;
1404: ln_index := pay_emp_action_arch.ltr_jobs.count;
1405: pay_emp_action_arch.ltr_jobs(ln_index).id := p_job_id;
1406: pay_emp_action_arch.ltr_jobs(ln_index).name := lv_job_name;
1407: end if;
1408:
1401: open c_job_name(p_job_id, p_effective_date);
1402: fetch c_job_name into lv_job_name;
1403: close c_job_name;
1404: ln_index := pay_emp_action_arch.ltr_jobs.count;
1405: pay_emp_action_arch.ltr_jobs(ln_index).id := p_job_id;
1406: pay_emp_action_arch.ltr_jobs(ln_index).name := lv_job_name;
1407: end if;
1408:
1409: hr_utility.trace('Leaving get_job_name');
1402: fetch c_job_name into lv_job_name;
1403: close c_job_name;
1404: ln_index := pay_emp_action_arch.ltr_jobs.count;
1405: pay_emp_action_arch.ltr_jobs(ln_index).id := p_job_id;
1406: pay_emp_action_arch.ltr_jobs(ln_index).name := lv_job_name;
1407: end if;
1408:
1409: hr_utility.trace('Leaving get_job_name');
1410: return(lv_job_name);
1438: BEGIN
1439: lv_procedure_name := 'get_position';
1440: lv_exists := 'N';
1441: hr_utility.trace('Entered get_position');
1442: if pay_emp_action_arch.ltr_positions.count > 0 then
1443: for i in pay_emp_action_arch.ltr_positions.first ..
1444: pay_emp_action_arch.ltr_positions.last loop
1445: if pay_emp_action_arch.ltr_positions(i).id = p_position_id then
1446: lv_position_name := pay_emp_action_arch.ltr_positions(i).name;
1439: lv_procedure_name := 'get_position';
1440: lv_exists := 'N';
1441: hr_utility.trace('Entered get_position');
1442: if pay_emp_action_arch.ltr_positions.count > 0 then
1443: for i in pay_emp_action_arch.ltr_positions.first ..
1444: pay_emp_action_arch.ltr_positions.last loop
1445: if pay_emp_action_arch.ltr_positions(i).id = p_position_id then
1446: lv_position_name := pay_emp_action_arch.ltr_positions(i).name;
1447: lv_exists := 'Y';
1440: lv_exists := 'N';
1441: hr_utility.trace('Entered get_position');
1442: if pay_emp_action_arch.ltr_positions.count > 0 then
1443: for i in pay_emp_action_arch.ltr_positions.first ..
1444: pay_emp_action_arch.ltr_positions.last loop
1445: if pay_emp_action_arch.ltr_positions(i).id = p_position_id then
1446: lv_position_name := pay_emp_action_arch.ltr_positions(i).name;
1447: lv_exists := 'Y';
1448: exit;
1441: hr_utility.trace('Entered get_position');
1442: if pay_emp_action_arch.ltr_positions.count > 0 then
1443: for i in pay_emp_action_arch.ltr_positions.first ..
1444: pay_emp_action_arch.ltr_positions.last loop
1445: if pay_emp_action_arch.ltr_positions(i).id = p_position_id then
1446: lv_position_name := pay_emp_action_arch.ltr_positions(i).name;
1447: lv_exists := 'Y';
1448: exit;
1449: end if;
1442: if pay_emp_action_arch.ltr_positions.count > 0 then
1443: for i in pay_emp_action_arch.ltr_positions.first ..
1444: pay_emp_action_arch.ltr_positions.last loop
1445: if pay_emp_action_arch.ltr_positions(i).id = p_position_id then
1446: lv_position_name := pay_emp_action_arch.ltr_positions(i).name;
1447: lv_exists := 'Y';
1448: exit;
1449: end if;
1450: end loop;
1453: if lv_exists = 'N' then
1454: open c_position_name(p_position_id, p_effective_date);
1455: fetch c_position_name into lv_position_name;
1456: close c_position_name;
1457: ln_index := pay_emp_action_arch.ltr_positions.count;
1458: pay_emp_action_arch.ltr_positions(ln_index).id := p_position_id;
1459: pay_emp_action_arch.ltr_positions(ln_index).name := lv_position_name;
1460: end if;
1461:
1454: open c_position_name(p_position_id, p_effective_date);
1455: fetch c_position_name into lv_position_name;
1456: close c_position_name;
1457: ln_index := pay_emp_action_arch.ltr_positions.count;
1458: pay_emp_action_arch.ltr_positions(ln_index).id := p_position_id;
1459: pay_emp_action_arch.ltr_positions(ln_index).name := lv_position_name;
1460: end if;
1461:
1462: hr_utility.trace('Leaving get_position');
1455: fetch c_position_name into lv_position_name;
1456: close c_position_name;
1457: ln_index := pay_emp_action_arch.ltr_positions.count;
1458: pay_emp_action_arch.ltr_positions(ln_index).id := p_position_id;
1459: pay_emp_action_arch.ltr_positions(ln_index).name := lv_position_name;
1460: end if;
1461:
1462: hr_utility.trace('Leaving get_position');
1463:
1494: BEGIN
1495: lv_procedure_name := 'get_pay_basis';
1496: lv_exists := 'N';
1497: hr_utility.trace('Entered get_pay_basis');
1498: if pay_emp_action_arch.ltr_pay_basis.count > 0 then
1499: for i in pay_emp_action_arch.ltr_pay_basis.first ..
1500: pay_emp_action_arch.ltr_pay_basis.last loop
1501: if pay_emp_action_arch.ltr_pay_basis(i).id = p_pay_basis_id then
1502: lv_pay_basis := pay_emp_action_arch.ltr_pay_basis(i).name;
1495: lv_procedure_name := 'get_pay_basis';
1496: lv_exists := 'N';
1497: hr_utility.trace('Entered get_pay_basis');
1498: if pay_emp_action_arch.ltr_pay_basis.count > 0 then
1499: for i in pay_emp_action_arch.ltr_pay_basis.first ..
1500: pay_emp_action_arch.ltr_pay_basis.last loop
1501: if pay_emp_action_arch.ltr_pay_basis(i).id = p_pay_basis_id then
1502: lv_pay_basis := pay_emp_action_arch.ltr_pay_basis(i).name;
1503: lv_exists := 'Y';
1496: lv_exists := 'N';
1497: hr_utility.trace('Entered get_pay_basis');
1498: if pay_emp_action_arch.ltr_pay_basis.count > 0 then
1499: for i in pay_emp_action_arch.ltr_pay_basis.first ..
1500: pay_emp_action_arch.ltr_pay_basis.last loop
1501: if pay_emp_action_arch.ltr_pay_basis(i).id = p_pay_basis_id then
1502: lv_pay_basis := pay_emp_action_arch.ltr_pay_basis(i).name;
1503: lv_exists := 'Y';
1504: exit;
1497: hr_utility.trace('Entered get_pay_basis');
1498: if pay_emp_action_arch.ltr_pay_basis.count > 0 then
1499: for i in pay_emp_action_arch.ltr_pay_basis.first ..
1500: pay_emp_action_arch.ltr_pay_basis.last loop
1501: if pay_emp_action_arch.ltr_pay_basis(i).id = p_pay_basis_id then
1502: lv_pay_basis := pay_emp_action_arch.ltr_pay_basis(i).name;
1503: lv_exists := 'Y';
1504: exit;
1505: end if;
1498: if pay_emp_action_arch.ltr_pay_basis.count > 0 then
1499: for i in pay_emp_action_arch.ltr_pay_basis.first ..
1500: pay_emp_action_arch.ltr_pay_basis.last loop
1501: if pay_emp_action_arch.ltr_pay_basis(i).id = p_pay_basis_id then
1502: lv_pay_basis := pay_emp_action_arch.ltr_pay_basis(i).name;
1503: lv_exists := 'Y';
1504: exit;
1505: end if;
1506: end loop;
1509: if lv_exists = 'N' then
1510: open c_pay_basis(p_pay_basis_id, p_effective_date);
1511: fetch c_pay_basis into lv_pay_basis;
1512: close c_pay_basis;
1513: ln_index := pay_emp_action_arch.ltr_pay_basis.count;
1514: pay_emp_action_arch.ltr_pay_basis(ln_index).id := p_pay_basis_id;
1515: pay_emp_action_arch.ltr_pay_basis(ln_index).name := lv_pay_basis;
1516: end if;
1517:
1510: open c_pay_basis(p_pay_basis_id, p_effective_date);
1511: fetch c_pay_basis into lv_pay_basis;
1512: close c_pay_basis;
1513: ln_index := pay_emp_action_arch.ltr_pay_basis.count;
1514: pay_emp_action_arch.ltr_pay_basis(ln_index).id := p_pay_basis_id;
1515: pay_emp_action_arch.ltr_pay_basis(ln_index).name := lv_pay_basis;
1516: end if;
1517:
1518: hr_utility.trace('Leaving get_pay_basis');
1511: fetch c_pay_basis into lv_pay_basis;
1512: close c_pay_basis;
1513: ln_index := pay_emp_action_arch.ltr_pay_basis.count;
1514: pay_emp_action_arch.ltr_pay_basis(ln_index).id := p_pay_basis_id;
1515: pay_emp_action_arch.ltr_pay_basis(ln_index).name := lv_pay_basis;
1516: end if;
1517:
1518: hr_utility.trace('Leaving get_pay_basis');
1519:
1585: BEGIN
1586: lv_procedure_name := 'get_grade';
1587: lv_exists := 'N';
1588: hr_utility.trace('Entered get_grades');
1589: if pay_emp_action_arch.ltr_grades.count > 0 then
1590: for i in pay_emp_action_arch.ltr_grades.first ..
1591: pay_emp_action_arch.ltr_grades.last loop
1592: if pay_emp_action_arch.ltr_grades(i).id = p_grade_id then
1593: lv_grade := pay_emp_action_arch.ltr_grades(i).name;
1586: lv_procedure_name := 'get_grade';
1587: lv_exists := 'N';
1588: hr_utility.trace('Entered get_grades');
1589: if pay_emp_action_arch.ltr_grades.count > 0 then
1590: for i in pay_emp_action_arch.ltr_grades.first ..
1591: pay_emp_action_arch.ltr_grades.last loop
1592: if pay_emp_action_arch.ltr_grades(i).id = p_grade_id then
1593: lv_grade := pay_emp_action_arch.ltr_grades(i).name;
1594: lv_exists := 'Y';
1587: lv_exists := 'N';
1588: hr_utility.trace('Entered get_grades');
1589: if pay_emp_action_arch.ltr_grades.count > 0 then
1590: for i in pay_emp_action_arch.ltr_grades.first ..
1591: pay_emp_action_arch.ltr_grades.last loop
1592: if pay_emp_action_arch.ltr_grades(i).id = p_grade_id then
1593: lv_grade := pay_emp_action_arch.ltr_grades(i).name;
1594: lv_exists := 'Y';
1595: exit;
1588: hr_utility.trace('Entered get_grades');
1589: if pay_emp_action_arch.ltr_grades.count > 0 then
1590: for i in pay_emp_action_arch.ltr_grades.first ..
1591: pay_emp_action_arch.ltr_grades.last loop
1592: if pay_emp_action_arch.ltr_grades(i).id = p_grade_id then
1593: lv_grade := pay_emp_action_arch.ltr_grades(i).name;
1594: lv_exists := 'Y';
1595: exit;
1596: end if;
1589: if pay_emp_action_arch.ltr_grades.count > 0 then
1590: for i in pay_emp_action_arch.ltr_grades.first ..
1591: pay_emp_action_arch.ltr_grades.last loop
1592: if pay_emp_action_arch.ltr_grades(i).id = p_grade_id then
1593: lv_grade := pay_emp_action_arch.ltr_grades(i).name;
1594: lv_exists := 'Y';
1595: exit;
1596: end if;
1597: end loop;
1600: if lv_exists = 'N' then
1601: open c_grade(p_grade_id, p_effective_date);
1602: fetch c_grade into lv_grade;
1603: close c_grade;
1604: ln_index := pay_emp_action_arch.ltr_grades.count;
1605: pay_emp_action_arch.ltr_grades(ln_index).id := p_grade_id;
1606: pay_emp_action_arch.ltr_grades(ln_index).name := lv_grade;
1607: end if;
1608:
1601: open c_grade(p_grade_id, p_effective_date);
1602: fetch c_grade into lv_grade;
1603: close c_grade;
1604: ln_index := pay_emp_action_arch.ltr_grades.count;
1605: pay_emp_action_arch.ltr_grades(ln_index).id := p_grade_id;
1606: pay_emp_action_arch.ltr_grades(ln_index).name := lv_grade;
1607: end if;
1608:
1609: return(lv_grade);
1602: fetch c_grade into lv_grade;
1603: close c_grade;
1604: ln_index := pay_emp_action_arch.ltr_grades.count;
1605: pay_emp_action_arch.ltr_grades(ln_index).id := p_grade_id;
1606: pay_emp_action_arch.ltr_grades(ln_index).name := lv_grade;
1607: end if;
1608:
1609: return(lv_grade);
1610:
1882: ,lv_ee_postal_code
1883: ,lv_ee_country;
1884: close c_addr_line;
1885:
1886: ln_index := pay_emp_action_arch.lrr_act_tab.count;
1887:
1888: hr_utility.trace('ln_index in get_employee_addr proc is '
1889: || pay_emp_action_arch.lrr_act_tab.count);
1890: hr_utility.trace('person_id is'||p_person_id);
1885:
1886: ln_index := pay_emp_action_arch.lrr_act_tab.count;
1887:
1888: hr_utility.trace('ln_index in get_employee_addr proc is '
1889: || pay_emp_action_arch.lrr_act_tab.count);
1890: hr_utility.trace('person_id is'||p_person_id);
1891:
1892: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category
1893: := 'ADDRESS DETAILS';
1888: hr_utility.trace('ln_index in get_employee_addr proc is '
1889: || pay_emp_action_arch.lrr_act_tab.count);
1890: hr_utility.trace('person_id is'||p_person_id);
1891:
1892: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category
1893: := 'ADDRESS DETAILS';
1894: pay_emp_action_arch.lrr_act_tab(ln_index).jurisdiction_code
1895: := '00-000-0000';
1896: pay_emp_action_arch.lrr_act_tab(ln_index).act_info1
1890: hr_utility.trace('person_id is'||p_person_id);
1891:
1892: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category
1893: := 'ADDRESS DETAILS';
1894: pay_emp_action_arch.lrr_act_tab(ln_index).jurisdiction_code
1895: := '00-000-0000';
1896: pay_emp_action_arch.lrr_act_tab(ln_index).act_info1
1897: := p_person_id;
1898: pay_emp_action_arch.lrr_act_tab(ln_index).act_info5
1892: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category
1893: := 'ADDRESS DETAILS';
1894: pay_emp_action_arch.lrr_act_tab(ln_index).jurisdiction_code
1895: := '00-000-0000';
1896: pay_emp_action_arch.lrr_act_tab(ln_index).act_info1
1897: := p_person_id;
1898: pay_emp_action_arch.lrr_act_tab(ln_index).act_info5
1899: := lv_ee_address_line_1 ;
1900: pay_emp_action_arch.lrr_act_tab(ln_index).act_info6
1894: pay_emp_action_arch.lrr_act_tab(ln_index).jurisdiction_code
1895: := '00-000-0000';
1896: pay_emp_action_arch.lrr_act_tab(ln_index).act_info1
1897: := p_person_id;
1898: pay_emp_action_arch.lrr_act_tab(ln_index).act_info5
1899: := lv_ee_address_line_1 ;
1900: pay_emp_action_arch.lrr_act_tab(ln_index).act_info6
1901: := lv_ee_address_line_2;
1902: pay_emp_action_arch.lrr_act_tab(ln_index).act_info7
1896: pay_emp_action_arch.lrr_act_tab(ln_index).act_info1
1897: := p_person_id;
1898: pay_emp_action_arch.lrr_act_tab(ln_index).act_info5
1899: := lv_ee_address_line_1 ;
1900: pay_emp_action_arch.lrr_act_tab(ln_index).act_info6
1901: := lv_ee_address_line_2;
1902: pay_emp_action_arch.lrr_act_tab(ln_index).act_info7
1903: := lv_ee_address_line_3;
1904: pay_emp_action_arch.lrr_act_tab(ln_index).act_info8
1898: pay_emp_action_arch.lrr_act_tab(ln_index).act_info5
1899: := lv_ee_address_line_1 ;
1900: pay_emp_action_arch.lrr_act_tab(ln_index).act_info6
1901: := lv_ee_address_line_2;
1902: pay_emp_action_arch.lrr_act_tab(ln_index).act_info7
1903: := lv_ee_address_line_3;
1904: pay_emp_action_arch.lrr_act_tab(ln_index).act_info8
1905: := lv_ee_town_or_city;
1906: pay_emp_action_arch.lrr_act_tab(ln_index).act_info9
1900: pay_emp_action_arch.lrr_act_tab(ln_index).act_info6
1901: := lv_ee_address_line_2;
1902: pay_emp_action_arch.lrr_act_tab(ln_index).act_info7
1903: := lv_ee_address_line_3;
1904: pay_emp_action_arch.lrr_act_tab(ln_index).act_info8
1905: := lv_ee_town_or_city;
1906: pay_emp_action_arch.lrr_act_tab(ln_index).act_info9
1907: := lv_ee_region_1;
1908: pay_emp_action_arch.lrr_act_tab(ln_index).act_info10
1902: pay_emp_action_arch.lrr_act_tab(ln_index).act_info7
1903: := lv_ee_address_line_3;
1904: pay_emp_action_arch.lrr_act_tab(ln_index).act_info8
1905: := lv_ee_town_or_city;
1906: pay_emp_action_arch.lrr_act_tab(ln_index).act_info9
1907: := lv_ee_region_1;
1908: pay_emp_action_arch.lrr_act_tab(ln_index).act_info10
1909: := lv_ee_region_2;
1910: pay_emp_action_arch.lrr_act_tab(ln_index).act_info11
1904: pay_emp_action_arch.lrr_act_tab(ln_index).act_info8
1905: := lv_ee_town_or_city;
1906: pay_emp_action_arch.lrr_act_tab(ln_index).act_info9
1907: := lv_ee_region_1;
1908: pay_emp_action_arch.lrr_act_tab(ln_index).act_info10
1909: := lv_ee_region_2;
1910: pay_emp_action_arch.lrr_act_tab(ln_index).act_info11
1911: := lv_ee_region_3 ;
1912: pay_emp_action_arch.lrr_act_tab(ln_index).act_info12
1906: pay_emp_action_arch.lrr_act_tab(ln_index).act_info9
1907: := lv_ee_region_1;
1908: pay_emp_action_arch.lrr_act_tab(ln_index).act_info10
1909: := lv_ee_region_2;
1910: pay_emp_action_arch.lrr_act_tab(ln_index).act_info11
1911: := lv_ee_region_3 ;
1912: pay_emp_action_arch.lrr_act_tab(ln_index).act_info12
1913: := lv_ee_postal_code;
1914: pay_emp_action_arch.lrr_act_tab(ln_index).act_info13
1908: pay_emp_action_arch.lrr_act_tab(ln_index).act_info10
1909: := lv_ee_region_2;
1910: pay_emp_action_arch.lrr_act_tab(ln_index).act_info11
1911: := lv_ee_region_3 ;
1912: pay_emp_action_arch.lrr_act_tab(ln_index).act_info12
1913: := lv_ee_postal_code;
1914: pay_emp_action_arch.lrr_act_tab(ln_index).act_info13
1915: := lv_ee_country;
1916: pay_emp_action_arch.lrr_act_tab(ln_index).act_info14
1910: pay_emp_action_arch.lrr_act_tab(ln_index).act_info11
1911: := lv_ee_region_3 ;
1912: pay_emp_action_arch.lrr_act_tab(ln_index).act_info12
1913: := lv_ee_postal_code;
1914: pay_emp_action_arch.lrr_act_tab(ln_index).act_info13
1915: := lv_ee_country;
1916: pay_emp_action_arch.lrr_act_tab(ln_index).act_info14
1917: := lv_ee_or_er;
1918: hr_utility.trace('Leaving get_employee_addr');
1912: pay_emp_action_arch.lrr_act_tab(ln_index).act_info12
1913: := lv_ee_postal_code;
1914: pay_emp_action_arch.lrr_act_tab(ln_index).act_info13
1915: := lv_ee_country;
1916: pay_emp_action_arch.lrr_act_tab(ln_index).act_info14
1917: := lv_ee_or_er;
1918: hr_utility.trace('Leaving get_employee_addr');
1919: END get_employee_addr;
1920:
2050: if c_net_pay%notfound then
2051: exit;
2052: end if;
2053:
2054: ln_index := pay_emp_action_arch.lrr_act_tab.count;
2055:
2056: hr_utility.trace('ln_index in get_net_pay_dist proc is '
2057: || pay_emp_action_arch.lrr_act_tab.count);
2058:
2053:
2054: ln_index := pay_emp_action_arch.lrr_act_tab.count;
2055:
2056: hr_utility.trace('ln_index in get_net_pay_dist proc is '
2057: || pay_emp_action_arch.lrr_act_tab.count);
2058:
2059: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category
2060: := 'EMPLOYEE NET PAY DISTRIBUTION';
2061: pay_emp_action_arch.lrr_act_tab(ln_index).jurisdiction_code
2055:
2056: hr_utility.trace('ln_index in get_net_pay_dist proc is '
2057: || pay_emp_action_arch.lrr_act_tab.count);
2058:
2059: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category
2060: := 'EMPLOYEE NET PAY DISTRIBUTION';
2061: pay_emp_action_arch.lrr_act_tab(ln_index).jurisdiction_code
2062: := '00-000-0000';
2063: pay_emp_action_arch.lrr_act_tab(ln_index).act_info1
2057: || pay_emp_action_arch.lrr_act_tab.count);
2058:
2059: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category
2060: := 'EMPLOYEE NET PAY DISTRIBUTION';
2061: pay_emp_action_arch.lrr_act_tab(ln_index).jurisdiction_code
2062: := '00-000-0000';
2063: pay_emp_action_arch.lrr_act_tab(ln_index).act_info1
2064: := ln_org_payment_method_id;
2065: pay_emp_action_arch.lrr_act_tab(ln_index).act_info2
2059: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category
2060: := 'EMPLOYEE NET PAY DISTRIBUTION';
2061: pay_emp_action_arch.lrr_act_tab(ln_index).jurisdiction_code
2062: := '00-000-0000';
2063: pay_emp_action_arch.lrr_act_tab(ln_index).act_info1
2064: := ln_org_payment_method_id;
2065: pay_emp_action_arch.lrr_act_tab(ln_index).act_info2
2066: := ln_emp_payment_method_id;
2067: pay_emp_action_arch.lrr_act_tab(ln_index).act_info4
2061: pay_emp_action_arch.lrr_act_tab(ln_index).jurisdiction_code
2062: := '00-000-0000';
2063: pay_emp_action_arch.lrr_act_tab(ln_index).act_info1
2064: := ln_org_payment_method_id;
2065: pay_emp_action_arch.lrr_act_tab(ln_index).act_info2
2066: := ln_emp_payment_method_id;
2067: pay_emp_action_arch.lrr_act_tab(ln_index).act_info4
2068: := null;
2069: pay_emp_action_arch.lrr_act_tab(ln_index).act_info5
2063: pay_emp_action_arch.lrr_act_tab(ln_index).act_info1
2064: := ln_org_payment_method_id;
2065: pay_emp_action_arch.lrr_act_tab(ln_index).act_info2
2066: := ln_emp_payment_method_id;
2067: pay_emp_action_arch.lrr_act_tab(ln_index).act_info4
2068: := null;
2069: pay_emp_action_arch.lrr_act_tab(ln_index).act_info5
2070: := lv_segment1;
2071: pay_emp_action_arch.lrr_act_tab(ln_index).act_info6
2065: pay_emp_action_arch.lrr_act_tab(ln_index).act_info2
2066: := ln_emp_payment_method_id;
2067: pay_emp_action_arch.lrr_act_tab(ln_index).act_info4
2068: := null;
2069: pay_emp_action_arch.lrr_act_tab(ln_index).act_info5
2070: := lv_segment1;
2071: pay_emp_action_arch.lrr_act_tab(ln_index).act_info6
2072: := lv_segment2;
2073: pay_emp_action_arch.lrr_act_tab(ln_index).act_info7
2067: pay_emp_action_arch.lrr_act_tab(ln_index).act_info4
2068: := null;
2069: pay_emp_action_arch.lrr_act_tab(ln_index).act_info5
2070: := lv_segment1;
2071: pay_emp_action_arch.lrr_act_tab(ln_index).act_info6
2072: := lv_segment2;
2073: pay_emp_action_arch.lrr_act_tab(ln_index).act_info7
2074: := lv_segment3;
2075: pay_emp_action_arch.lrr_act_tab(ln_index).act_info8
2069: pay_emp_action_arch.lrr_act_tab(ln_index).act_info5
2070: := lv_segment1;
2071: pay_emp_action_arch.lrr_act_tab(ln_index).act_info6
2072: := lv_segment2;
2073: pay_emp_action_arch.lrr_act_tab(ln_index).act_info7
2074: := lv_segment3;
2075: pay_emp_action_arch.lrr_act_tab(ln_index).act_info8
2076: := lv_segment4;
2077: pay_emp_action_arch.lrr_act_tab(ln_index).act_info9
2071: pay_emp_action_arch.lrr_act_tab(ln_index).act_info6
2072: := lv_segment2;
2073: pay_emp_action_arch.lrr_act_tab(ln_index).act_info7
2074: := lv_segment3;
2075: pay_emp_action_arch.lrr_act_tab(ln_index).act_info8
2076: := lv_segment4;
2077: pay_emp_action_arch.lrr_act_tab(ln_index).act_info9
2078: := lv_segment5;
2079: pay_emp_action_arch.lrr_act_tab(ln_index).act_info10
2073: pay_emp_action_arch.lrr_act_tab(ln_index).act_info7
2074: := lv_segment3;
2075: pay_emp_action_arch.lrr_act_tab(ln_index).act_info8
2076: := lv_segment4;
2077: pay_emp_action_arch.lrr_act_tab(ln_index).act_info9
2078: := lv_segment5;
2079: pay_emp_action_arch.lrr_act_tab(ln_index).act_info10
2080: := lv_segment6;
2081: pay_emp_action_arch.lrr_act_tab(ln_index).act_info11
2075: pay_emp_action_arch.lrr_act_tab(ln_index).act_info8
2076: := lv_segment4;
2077: pay_emp_action_arch.lrr_act_tab(ln_index).act_info9
2078: := lv_segment5;
2079: pay_emp_action_arch.lrr_act_tab(ln_index).act_info10
2080: := lv_segment6;
2081: pay_emp_action_arch.lrr_act_tab(ln_index).act_info11
2082: := lv_segment7 ;
2083: pay_emp_action_arch.lrr_act_tab(ln_index).act_info12
2077: pay_emp_action_arch.lrr_act_tab(ln_index).act_info9
2078: := lv_segment5;
2079: pay_emp_action_arch.lrr_act_tab(ln_index).act_info10
2080: := lv_segment6;
2081: pay_emp_action_arch.lrr_act_tab(ln_index).act_info11
2082: := lv_segment7 ;
2083: pay_emp_action_arch.lrr_act_tab(ln_index).act_info12
2084: := lv_segment8;
2085: pay_emp_action_arch.lrr_act_tab(ln_index).act_info13
2079: pay_emp_action_arch.lrr_act_tab(ln_index).act_info10
2080: := lv_segment6;
2081: pay_emp_action_arch.lrr_act_tab(ln_index).act_info11
2082: := lv_segment7 ;
2083: pay_emp_action_arch.lrr_act_tab(ln_index).act_info12
2084: := lv_segment8;
2085: pay_emp_action_arch.lrr_act_tab(ln_index).act_info13
2086: := lv_segment9;
2087: pay_emp_action_arch.lrr_act_tab(ln_index).act_info14
2081: pay_emp_action_arch.lrr_act_tab(ln_index).act_info11
2082: := lv_segment7 ;
2083: pay_emp_action_arch.lrr_act_tab(ln_index).act_info12
2084: := lv_segment8;
2085: pay_emp_action_arch.lrr_act_tab(ln_index).act_info13
2086: := lv_segment9;
2087: pay_emp_action_arch.lrr_act_tab(ln_index).act_info14
2088: := lv_segment10;
2089: pay_emp_action_arch.lrr_act_tab(ln_index).act_info15
2083: pay_emp_action_arch.lrr_act_tab(ln_index).act_info12
2084: := lv_segment8;
2085: pay_emp_action_arch.lrr_act_tab(ln_index).act_info13
2086: := lv_segment9;
2087: pay_emp_action_arch.lrr_act_tab(ln_index).act_info14
2088: := lv_segment10;
2089: pay_emp_action_arch.lrr_act_tab(ln_index).act_info15
2090: := ln_pre_payment_id;
2091: pay_emp_action_arch.lrr_act_tab(ln_index).act_info16
2085: pay_emp_action_arch.lrr_act_tab(ln_index).act_info13
2086: := lv_segment9;
2087: pay_emp_action_arch.lrr_act_tab(ln_index).act_info14
2088: := lv_segment10;
2089: pay_emp_action_arch.lrr_act_tab(ln_index).act_info15
2090: := ln_pre_payment_id;
2091: pay_emp_action_arch.lrr_act_tab(ln_index).act_info16
2092: := fnd_number.number_to_canonical(ln_value); /* Bug 3311866*/
2093: pay_emp_action_arch.lrr_act_tab(ln_index).act_info17
2087: pay_emp_action_arch.lrr_act_tab(ln_index).act_info14
2088: := lv_segment10;
2089: pay_emp_action_arch.lrr_act_tab(ln_index).act_info15
2090: := ln_pre_payment_id;
2091: pay_emp_action_arch.lrr_act_tab(ln_index).act_info16
2092: := fnd_number.number_to_canonical(ln_value); /* Bug 3311866*/
2093: pay_emp_action_arch.lrr_act_tab(ln_index).act_info17
2094: := p_pre_pay_action_id;
2095: pay_emp_action_arch.lrr_act_tab(ln_index).act_info18
2089: pay_emp_action_arch.lrr_act_tab(ln_index).act_info15
2090: := ln_pre_payment_id;
2091: pay_emp_action_arch.lrr_act_tab(ln_index).act_info16
2092: := fnd_number.number_to_canonical(ln_value); /* Bug 3311866*/
2093: pay_emp_action_arch.lrr_act_tab(ln_index).act_info17
2094: := p_pre_pay_action_id;
2095: pay_emp_action_arch.lrr_act_tab(ln_index).act_info18
2096: := lv_org_payment_method_name;
2097: end loop;
2091: pay_emp_action_arch.lrr_act_tab(ln_index).act_info16
2092: := fnd_number.number_to_canonical(ln_value); /* Bug 3311866*/
2093: pay_emp_action_arch.lrr_act_tab(ln_index).act_info17
2094: := p_pre_pay_action_id;
2095: pay_emp_action_arch.lrr_act_tab(ln_index).act_info18
2096: := lv_org_payment_method_name;
2097: end loop;
2098: close c_net_pay;
2099: hr_utility.set_location(gv_package || lv_procedure_name,100);
2222: hr_utility.trace('p_ppp_source_action_id = '|| p_ppp_source_action_id);
2223: k := 0;
2224:
2225: -- Check if Multi assignment payment is enabled
2226: if pay_emp_action_arch.gv_multi_payroll_pymt is null then
2227: pay_emp_action_arch.gv_multi_payroll_pymt
2228: := pay_emp_action_arch.get_multi_assignment_flag(
2229: p_payroll_id => p_payroll_id
2230: ,p_effective_date => p_curr_pymt_eff_date);
2223: k := 0;
2224:
2225: -- Check if Multi assignment payment is enabled
2226: if pay_emp_action_arch.gv_multi_payroll_pymt is null then
2227: pay_emp_action_arch.gv_multi_payroll_pymt
2228: := pay_emp_action_arch.get_multi_assignment_flag(
2229: p_payroll_id => p_payroll_id
2230: ,p_effective_date => p_curr_pymt_eff_date);
2231: end if;
2224:
2225: -- Check if Multi assignment payment is enabled
2226: if pay_emp_action_arch.gv_multi_payroll_pymt is null then
2227: pay_emp_action_arch.gv_multi_payroll_pymt
2228: := pay_emp_action_arch.get_multi_assignment_flag(
2229: p_payroll_id => p_payroll_id
2230: ,p_effective_date => p_curr_pymt_eff_date);
2231: end if;
2232: hr_utility.set_location(gv_package || lv_procedure_name,20);
2230: ,p_effective_date => p_curr_pymt_eff_date);
2231: end if;
2232: hr_utility.set_location(gv_package || lv_procedure_name,20);
2233:
2234: if nvl(pay_emp_action_arch.gv_multi_payroll_pymt, 'N') = 'Y' then
2235: -- If Multi Assignment Payment is enabled, get the child prepayment
2236: -- actions as payment information is stored against child.
2237: -- Insert this data in pl/sql table.
2238: for cval in c_child_action(p_pre_pay_action_id, p_assignment_id) loop
2283: if c_third_party_pay%notfound then
2284: exit;
2285: end if;
2286:
2287: ln_index := pay_emp_action_arch.lrr_act_tab.count;
2288:
2289: hr_utility.trace('ln_index in get_3rdparty_pay_distribution proc is '
2290: || pay_emp_action_arch.lrr_act_tab.count);
2291:
2286:
2287: ln_index := pay_emp_action_arch.lrr_act_tab.count;
2288:
2289: hr_utility.trace('ln_index in get_3rdparty_pay_distribution proc is '
2290: || pay_emp_action_arch.lrr_act_tab.count);
2291:
2292: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category
2293: := 'EMPLOYEE THIRD PARTY PAYMENTS';
2294: pay_emp_action_arch.lrr_act_tab(ln_index).jurisdiction_code
2288:
2289: hr_utility.trace('ln_index in get_3rdparty_pay_distribution proc is '
2290: || pay_emp_action_arch.lrr_act_tab.count);
2291:
2292: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category
2293: := 'EMPLOYEE THIRD PARTY PAYMENTS';
2294: pay_emp_action_arch.lrr_act_tab(ln_index).jurisdiction_code
2295: := '00-000-0000';
2296: pay_emp_action_arch.lrr_act_tab(ln_index).act_info1
2290: || pay_emp_action_arch.lrr_act_tab.count);
2291:
2292: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category
2293: := 'EMPLOYEE THIRD PARTY PAYMENTS';
2294: pay_emp_action_arch.lrr_act_tab(ln_index).jurisdiction_code
2295: := '00-000-0000';
2296: pay_emp_action_arch.lrr_act_tab(ln_index).act_info1
2297: := ln_org_payment_method_id;
2298: hr_utility.trace('ln_org_payment_method_id'||ln_org_payment_method_id);
2292: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category
2293: := 'EMPLOYEE THIRD PARTY PAYMENTS';
2294: pay_emp_action_arch.lrr_act_tab(ln_index).jurisdiction_code
2295: := '00-000-0000';
2296: pay_emp_action_arch.lrr_act_tab(ln_index).act_info1
2297: := ln_org_payment_method_id;
2298: hr_utility.trace('ln_org_payment_method_id'||ln_org_payment_method_id);
2299: pay_emp_action_arch.lrr_act_tab(ln_index).act_info2
2300: := ln_emp_payment_method_id;
2295: := '00-000-0000';
2296: pay_emp_action_arch.lrr_act_tab(ln_index).act_info1
2297: := ln_org_payment_method_id;
2298: hr_utility.trace('ln_org_payment_method_id'||ln_org_payment_method_id);
2299: pay_emp_action_arch.lrr_act_tab(ln_index).act_info2
2300: := ln_emp_payment_method_id;
2301: pay_emp_action_arch.lrr_act_tab(ln_index).act_info4
2302: := null;
2303: pay_emp_action_arch.lrr_act_tab(ln_index).act_info5
2297: := ln_org_payment_method_id;
2298: hr_utility.trace('ln_org_payment_method_id'||ln_org_payment_method_id);
2299: pay_emp_action_arch.lrr_act_tab(ln_index).act_info2
2300: := ln_emp_payment_method_id;
2301: pay_emp_action_arch.lrr_act_tab(ln_index).act_info4
2302: := null;
2303: pay_emp_action_arch.lrr_act_tab(ln_index).act_info5
2304: := lv_segment1;
2305: pay_emp_action_arch.lrr_act_tab(ln_index).act_info6
2299: pay_emp_action_arch.lrr_act_tab(ln_index).act_info2
2300: := ln_emp_payment_method_id;
2301: pay_emp_action_arch.lrr_act_tab(ln_index).act_info4
2302: := null;
2303: pay_emp_action_arch.lrr_act_tab(ln_index).act_info5
2304: := lv_segment1;
2305: pay_emp_action_arch.lrr_act_tab(ln_index).act_info6
2306: := lv_segment2;
2307: pay_emp_action_arch.lrr_act_tab(ln_index).act_info7
2301: pay_emp_action_arch.lrr_act_tab(ln_index).act_info4
2302: := null;
2303: pay_emp_action_arch.lrr_act_tab(ln_index).act_info5
2304: := lv_segment1;
2305: pay_emp_action_arch.lrr_act_tab(ln_index).act_info6
2306: := lv_segment2;
2307: pay_emp_action_arch.lrr_act_tab(ln_index).act_info7
2308: := lv_segment3;
2309: pay_emp_action_arch.lrr_act_tab(ln_index).act_info8
2303: pay_emp_action_arch.lrr_act_tab(ln_index).act_info5
2304: := lv_segment1;
2305: pay_emp_action_arch.lrr_act_tab(ln_index).act_info6
2306: := lv_segment2;
2307: pay_emp_action_arch.lrr_act_tab(ln_index).act_info7
2308: := lv_segment3;
2309: pay_emp_action_arch.lrr_act_tab(ln_index).act_info8
2310: := lv_segment4;
2311: pay_emp_action_arch.lrr_act_tab(ln_index).act_info9
2305: pay_emp_action_arch.lrr_act_tab(ln_index).act_info6
2306: := lv_segment2;
2307: pay_emp_action_arch.lrr_act_tab(ln_index).act_info7
2308: := lv_segment3;
2309: pay_emp_action_arch.lrr_act_tab(ln_index).act_info8
2310: := lv_segment4;
2311: pay_emp_action_arch.lrr_act_tab(ln_index).act_info9
2312: := lv_segment5;
2313: pay_emp_action_arch.lrr_act_tab(ln_index).act_info10
2307: pay_emp_action_arch.lrr_act_tab(ln_index).act_info7
2308: := lv_segment3;
2309: pay_emp_action_arch.lrr_act_tab(ln_index).act_info8
2310: := lv_segment4;
2311: pay_emp_action_arch.lrr_act_tab(ln_index).act_info9
2312: := lv_segment5;
2313: pay_emp_action_arch.lrr_act_tab(ln_index).act_info10
2314: := lv_segment6;
2315: pay_emp_action_arch.lrr_act_tab(ln_index).act_info11
2309: pay_emp_action_arch.lrr_act_tab(ln_index).act_info8
2310: := lv_segment4;
2311: pay_emp_action_arch.lrr_act_tab(ln_index).act_info9
2312: := lv_segment5;
2313: pay_emp_action_arch.lrr_act_tab(ln_index).act_info10
2314: := lv_segment6;
2315: pay_emp_action_arch.lrr_act_tab(ln_index).act_info11
2316: := lv_segment7 ;
2317: pay_emp_action_arch.lrr_act_tab(ln_index).act_info12
2311: pay_emp_action_arch.lrr_act_tab(ln_index).act_info9
2312: := lv_segment5;
2313: pay_emp_action_arch.lrr_act_tab(ln_index).act_info10
2314: := lv_segment6;
2315: pay_emp_action_arch.lrr_act_tab(ln_index).act_info11
2316: := lv_segment7 ;
2317: pay_emp_action_arch.lrr_act_tab(ln_index).act_info12
2318: := lv_segment8;
2319: pay_emp_action_arch.lrr_act_tab(ln_index).act_info13
2313: pay_emp_action_arch.lrr_act_tab(ln_index).act_info10
2314: := lv_segment6;
2315: pay_emp_action_arch.lrr_act_tab(ln_index).act_info11
2316: := lv_segment7 ;
2317: pay_emp_action_arch.lrr_act_tab(ln_index).act_info12
2318: := lv_segment8;
2319: pay_emp_action_arch.lrr_act_tab(ln_index).act_info13
2320: := lv_segment9;
2321: pay_emp_action_arch.lrr_act_tab(ln_index).act_info14
2315: pay_emp_action_arch.lrr_act_tab(ln_index).act_info11
2316: := lv_segment7 ;
2317: pay_emp_action_arch.lrr_act_tab(ln_index).act_info12
2318: := lv_segment8;
2319: pay_emp_action_arch.lrr_act_tab(ln_index).act_info13
2320: := lv_segment9;
2321: pay_emp_action_arch.lrr_act_tab(ln_index).act_info14
2322: := lv_segment10;
2323: pay_emp_action_arch.lrr_act_tab(ln_index).act_info15
2317: pay_emp_action_arch.lrr_act_tab(ln_index).act_info12
2318: := lv_segment8;
2319: pay_emp_action_arch.lrr_act_tab(ln_index).act_info13
2320: := lv_segment9;
2321: pay_emp_action_arch.lrr_act_tab(ln_index).act_info14
2322: := lv_segment10;
2323: pay_emp_action_arch.lrr_act_tab(ln_index).act_info15
2324: := ln_pre_payment_id;
2325: pay_emp_action_arch.lrr_act_tab(ln_index).act_info16
2319: pay_emp_action_arch.lrr_act_tab(ln_index).act_info13
2320: := lv_segment9;
2321: pay_emp_action_arch.lrr_act_tab(ln_index).act_info14
2322: := lv_segment10;
2323: pay_emp_action_arch.lrr_act_tab(ln_index).act_info15
2324: := ln_pre_payment_id;
2325: pay_emp_action_arch.lrr_act_tab(ln_index).act_info16
2326: := fnd_number.number_to_canonical(ln_value); /* Bug 3311866*/
2327: pay_emp_action_arch.lrr_act_tab(ln_index).act_info17
2321: pay_emp_action_arch.lrr_act_tab(ln_index).act_info14
2322: := lv_segment10;
2323: pay_emp_action_arch.lrr_act_tab(ln_index).act_info15
2324: := ln_pre_payment_id;
2325: pay_emp_action_arch.lrr_act_tab(ln_index).act_info16
2326: := fnd_number.number_to_canonical(ln_value); /* Bug 3311866*/
2327: pay_emp_action_arch.lrr_act_tab(ln_index).act_info17
2328: := ltt_actions(j);
2329: pay_emp_action_arch.lrr_act_tab(ln_index).act_info18
2323: pay_emp_action_arch.lrr_act_tab(ln_index).act_info15
2324: := ln_pre_payment_id;
2325: pay_emp_action_arch.lrr_act_tab(ln_index).act_info16
2326: := fnd_number.number_to_canonical(ln_value); /* Bug 3311866*/
2327: pay_emp_action_arch.lrr_act_tab(ln_index).act_info17
2328: := ltt_actions(j);
2329: pay_emp_action_arch.lrr_act_tab(ln_index).act_info18
2330: := lv_org_payment_method_name;
2331: end loop;
2325: pay_emp_action_arch.lrr_act_tab(ln_index).act_info16
2326: := fnd_number.number_to_canonical(ln_value); /* Bug 3311866*/
2327: pay_emp_action_arch.lrr_act_tab(ln_index).act_info17
2328: := ltt_actions(j);
2329: pay_emp_action_arch.lrr_act_tab(ln_index).act_info18
2330: := lv_org_payment_method_name;
2331: end loop;
2332: close c_third_party_pay;
2333: end loop;
2388: end if;
2389:
2390:
2391: hr_utility.set_location(gv_package || lv_procedure_name, 40);
2392: if pay_emp_action_arch.ltr_ppa_arch.count > 0 then
2393: for i in pay_emp_action_arch.ltr_ppa_arch.first ..
2394: pay_emp_action_arch.ltr_ppa_arch.last loop
2395: if pay_emp_action_arch.ltr_ppa_arch(i).act_info1
2396: = p_organization_id and
2389:
2390:
2391: hr_utility.set_location(gv_package || lv_procedure_name, 40);
2392: if pay_emp_action_arch.ltr_ppa_arch.count > 0 then
2393: for i in pay_emp_action_arch.ltr_ppa_arch.first ..
2394: pay_emp_action_arch.ltr_ppa_arch.last loop
2395: if pay_emp_action_arch.ltr_ppa_arch(i).act_info1
2396: = p_organization_id and
2397: pay_emp_action_arch.ltr_ppa_arch(i).act_info2
2390:
2391: hr_utility.set_location(gv_package || lv_procedure_name, 40);
2392: if pay_emp_action_arch.ltr_ppa_arch.count > 0 then
2393: for i in pay_emp_action_arch.ltr_ppa_arch.first ..
2394: pay_emp_action_arch.ltr_ppa_arch.last loop
2395: if pay_emp_action_arch.ltr_ppa_arch(i).act_info1
2396: = p_organization_id and
2397: pay_emp_action_arch.ltr_ppa_arch(i).act_info2
2398: = 'MESG' and
2391: hr_utility.set_location(gv_package || lv_procedure_name, 40);
2392: if pay_emp_action_arch.ltr_ppa_arch.count > 0 then
2393: for i in pay_emp_action_arch.ltr_ppa_arch.first ..
2394: pay_emp_action_arch.ltr_ppa_arch.last loop
2395: if pay_emp_action_arch.ltr_ppa_arch(i).act_info1
2396: = p_organization_id and
2397: pay_emp_action_arch.ltr_ppa_arch(i).act_info2
2398: = 'MESG' and
2399: /* Bug 13815091 - NVL added to check Meassages having NULL values properly */
2393: for i in pay_emp_action_arch.ltr_ppa_arch.first ..
2394: pay_emp_action_arch.ltr_ppa_arch.last loop
2395: if pay_emp_action_arch.ltr_ppa_arch(i).act_info1
2396: = p_organization_id and
2397: pay_emp_action_arch.ltr_ppa_arch(i).act_info2
2398: = 'MESG' and
2399: /* Bug 13815091 - NVL added to check Meassages having NULL values properly */
2400: nvl(pay_emp_action_arch.ltr_ppa_arch(i).act_info6,'-1')
2401: = nvl(lv_org_information6,'-1') then
2396: = p_organization_id and
2397: pay_emp_action_arch.ltr_ppa_arch(i).act_info2
2398: = 'MESG' and
2399: /* Bug 13815091 - NVL added to check Meassages having NULL values properly */
2400: nvl(pay_emp_action_arch.ltr_ppa_arch(i).act_info6,'-1')
2401: = nvl(lv_org_information6,'-1') then
2402: lv_exists := 'Y';
2403: exit;
2404: end if;
2405: end loop;
2406: end if;
2407:
2408: if lv_exists = 'N' then
2409: ln_index := pay_emp_action_arch.ltr_ppa_arch.count;
2410: pay_emp_action_arch.ltr_ppa_arch(ln_index).action_info_category
2411: := 'EMPLOYEE OTHER INFORMATION';
2412: pay_emp_action_arch.ltr_ppa_arch(ln_index).jurisdiction_code
2413: := '00-000-0000';
2406: end if;
2407:
2408: if lv_exists = 'N' then
2409: ln_index := pay_emp_action_arch.ltr_ppa_arch.count;
2410: pay_emp_action_arch.ltr_ppa_arch(ln_index).action_info_category
2411: := 'EMPLOYEE OTHER INFORMATION';
2412: pay_emp_action_arch.ltr_ppa_arch(ln_index).jurisdiction_code
2413: := '00-000-0000';
2414: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info1
2408: if lv_exists = 'N' then
2409: ln_index := pay_emp_action_arch.ltr_ppa_arch.count;
2410: pay_emp_action_arch.ltr_ppa_arch(ln_index).action_info_category
2411: := 'EMPLOYEE OTHER INFORMATION';
2412: pay_emp_action_arch.ltr_ppa_arch(ln_index).jurisdiction_code
2413: := '00-000-0000';
2414: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info1
2415: := p_organization_id;
2416: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info2
2410: pay_emp_action_arch.ltr_ppa_arch(ln_index).action_info_category
2411: := 'EMPLOYEE OTHER INFORMATION';
2412: pay_emp_action_arch.ltr_ppa_arch(ln_index).jurisdiction_code
2413: := '00-000-0000';
2414: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info1
2415: := p_organization_id;
2416: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info2
2417: := 'MESG';
2418: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info4
2412: pay_emp_action_arch.ltr_ppa_arch(ln_index).jurisdiction_code
2413: := '00-000-0000';
2414: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info1
2415: := p_organization_id;
2416: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info2
2417: := 'MESG';
2418: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info4
2419: := nvl(lv_org_information7,lv_org_information4) ;
2420: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info5
2414: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info1
2415: := p_organization_id;
2416: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info2
2417: := 'MESG';
2418: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info4
2419: := nvl(lv_org_information7,lv_org_information4) ;
2420: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info5
2421: := lv_org_information5;
2422: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info6
2416: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info2
2417: := 'MESG';
2418: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info4
2419: := nvl(lv_org_information7,lv_org_information4) ;
2420: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info5
2421: := lv_org_information5;
2422: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info6
2423: := lv_org_information6;
2424: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info13
2418: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info4
2419: := nvl(lv_org_information7,lv_org_information4) ;
2420: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info5
2421: := lv_org_information5;
2422: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info6
2423: := lv_org_information6;
2424: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info13
2425: := lv_org_information_cntxt; ----Bug 7115367
2426: end if;
2420: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info5
2421: := lv_org_information5;
2422: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info6
2423: := lv_org_information6;
2424: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info13
2425: := lv_org_information_cntxt; ----Bug 7115367
2426: end if;
2427: end loop ;
2428: close c_get_other_info;
2447: exit;
2448: end if;
2449:
2450: hr_utility.set_location(gv_package || lv_procedure_name, 130);
2451: if pay_emp_action_arch.ltr_ppa_arch.count > 0 then
2452: for i in pay_emp_action_arch.ltr_ppa_arch.first ..
2453: pay_emp_action_arch.ltr_ppa_arch.last loop
2454: if pay_emp_action_arch.ltr_ppa_arch(i).act_info1
2455: = p_business_group_id and
2448: end if;
2449:
2450: hr_utility.set_location(gv_package || lv_procedure_name, 130);
2451: if pay_emp_action_arch.ltr_ppa_arch.count > 0 then
2452: for i in pay_emp_action_arch.ltr_ppa_arch.first ..
2453: pay_emp_action_arch.ltr_ppa_arch.last loop
2454: if pay_emp_action_arch.ltr_ppa_arch(i).act_info1
2455: = p_business_group_id and
2456: pay_emp_action_arch.ltr_ppa_arch(i).act_info2
2449:
2450: hr_utility.set_location(gv_package || lv_procedure_name, 130);
2451: if pay_emp_action_arch.ltr_ppa_arch.count > 0 then
2452: for i in pay_emp_action_arch.ltr_ppa_arch.first ..
2453: pay_emp_action_arch.ltr_ppa_arch.last loop
2454: if pay_emp_action_arch.ltr_ppa_arch(i).act_info1
2455: = p_business_group_id and
2456: pay_emp_action_arch.ltr_ppa_arch(i).act_info2
2457: = 'MESG' and
2450: hr_utility.set_location(gv_package || lv_procedure_name, 130);
2451: if pay_emp_action_arch.ltr_ppa_arch.count > 0 then
2452: for i in pay_emp_action_arch.ltr_ppa_arch.first ..
2453: pay_emp_action_arch.ltr_ppa_arch.last loop
2454: if pay_emp_action_arch.ltr_ppa_arch(i).act_info1
2455: = p_business_group_id and
2456: pay_emp_action_arch.ltr_ppa_arch(i).act_info2
2457: = 'MESG' and
2458: /* Bug 13815091 - NVL added to check Meassages having NULL values properly */
2452: for i in pay_emp_action_arch.ltr_ppa_arch.first ..
2453: pay_emp_action_arch.ltr_ppa_arch.last loop
2454: if pay_emp_action_arch.ltr_ppa_arch(i).act_info1
2455: = p_business_group_id and
2456: pay_emp_action_arch.ltr_ppa_arch(i).act_info2
2457: = 'MESG' and
2458: /* Bug 13815091 - NVL added to check Meassages having NULL values properly */
2459: nvl(pay_emp_action_arch.ltr_ppa_arch(i).act_info6,'-1')
2460: = nvl(lv_org_information6,'-1') then
2455: = p_business_group_id and
2456: pay_emp_action_arch.ltr_ppa_arch(i).act_info2
2457: = 'MESG' and
2458: /* Bug 13815091 - NVL added to check Meassages having NULL values properly */
2459: nvl(pay_emp_action_arch.ltr_ppa_arch(i).act_info6,'-1')
2460: = nvl(lv_org_information6,'-1') then
2461: lv_exists := 'Y';
2462: exit;
2463: end if;
2464: end loop;
2465: end if;
2466:
2467: if lv_exists = 'N' then
2468: ln_index := pay_emp_action_arch.ltr_ppa_arch.count;
2469: pay_emp_action_arch.ltr_ppa_arch(ln_index).action_info_category
2470: := 'EMPLOYEE OTHER INFORMATION';
2471: pay_emp_action_arch.ltr_ppa_arch(ln_index).jurisdiction_code
2472: := '00-000-0000';
2465: end if;
2466:
2467: if lv_exists = 'N' then
2468: ln_index := pay_emp_action_arch.ltr_ppa_arch.count;
2469: pay_emp_action_arch.ltr_ppa_arch(ln_index).action_info_category
2470: := 'EMPLOYEE OTHER INFORMATION';
2471: pay_emp_action_arch.ltr_ppa_arch(ln_index).jurisdiction_code
2472: := '00-000-0000';
2473: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info1
2467: if lv_exists = 'N' then
2468: ln_index := pay_emp_action_arch.ltr_ppa_arch.count;
2469: pay_emp_action_arch.ltr_ppa_arch(ln_index).action_info_category
2470: := 'EMPLOYEE OTHER INFORMATION';
2471: pay_emp_action_arch.ltr_ppa_arch(ln_index).jurisdiction_code
2472: := '00-000-0000';
2473: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info1
2474: := p_business_group_id;
2475: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info2
2469: pay_emp_action_arch.ltr_ppa_arch(ln_index).action_info_category
2470: := 'EMPLOYEE OTHER INFORMATION';
2471: pay_emp_action_arch.ltr_ppa_arch(ln_index).jurisdiction_code
2472: := '00-000-0000';
2473: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info1
2474: := p_business_group_id;
2475: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info2
2476: := 'MESG';
2477: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info4
2471: pay_emp_action_arch.ltr_ppa_arch(ln_index).jurisdiction_code
2472: := '00-000-0000';
2473: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info1
2474: := p_business_group_id;
2475: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info2
2476: := 'MESG';
2477: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info4
2478: := nvl(lv_org_information7,lv_org_information4) ;
2479: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info5
2473: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info1
2474: := p_business_group_id;
2475: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info2
2476: := 'MESG';
2477: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info4
2478: := nvl(lv_org_information7,lv_org_information4) ;
2479: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info5
2480: := lv_org_information5 ;
2481: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info6
2475: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info2
2476: := 'MESG';
2477: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info4
2478: := nvl(lv_org_information7,lv_org_information4) ;
2479: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info5
2480: := lv_org_information5 ;
2481: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info6
2482: := lv_org_information6;
2483: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info13
2477: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info4
2478: := nvl(lv_org_information7,lv_org_information4) ;
2479: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info5
2480: := lv_org_information5 ;
2481: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info6
2482: := lv_org_information6;
2483: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info13
2484: := lv_org_information_cntxt; --Bug 7115367
2485: end if;
2479: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info5
2480: := lv_org_information5 ;
2481: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info6
2482: := lv_org_information6;
2483: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info13
2484: := lv_org_information_cntxt; --Bug 7115367
2485: end if;
2486: end loop ;
2487: close c_get_other_info;
2542: ,lv_er_telephone;
2543: close c_addr_line;
2544: hr_utility.set_location(gv_package || lv_procedure_name, 250);
2545:
2546: if pay_emp_action_arch.ltr_ppa_arch.count > 0 then
2547: for i in pay_emp_action_arch.ltr_ppa_arch.first ..
2548: pay_emp_action_arch.ltr_ppa_arch.last loop
2549: if pay_emp_action_arch.ltr_ppa_arch(i).act_info1
2550: = p_organization_id and
2543: close c_addr_line;
2544: hr_utility.set_location(gv_package || lv_procedure_name, 250);
2545:
2546: if pay_emp_action_arch.ltr_ppa_arch.count > 0 then
2547: for i in pay_emp_action_arch.ltr_ppa_arch.first ..
2548: pay_emp_action_arch.ltr_ppa_arch.last loop
2549: if pay_emp_action_arch.ltr_ppa_arch(i).act_info1
2550: = p_organization_id and
2551: pay_emp_action_arch.ltr_ppa_arch(i).act_info14
2544: hr_utility.set_location(gv_package || lv_procedure_name, 250);
2545:
2546: if pay_emp_action_arch.ltr_ppa_arch.count > 0 then
2547: for i in pay_emp_action_arch.ltr_ppa_arch.first ..
2548: pay_emp_action_arch.ltr_ppa_arch.last loop
2549: if pay_emp_action_arch.ltr_ppa_arch(i).act_info1
2550: = p_organization_id and
2551: pay_emp_action_arch.ltr_ppa_arch(i).act_info14
2552: = 'Employer Address' then
2545:
2546: if pay_emp_action_arch.ltr_ppa_arch.count > 0 then
2547: for i in pay_emp_action_arch.ltr_ppa_arch.first ..
2548: pay_emp_action_arch.ltr_ppa_arch.last loop
2549: if pay_emp_action_arch.ltr_ppa_arch(i).act_info1
2550: = p_organization_id and
2551: pay_emp_action_arch.ltr_ppa_arch(i).act_info14
2552: = 'Employer Address' then
2553: lv_exists := 'Y';
2547: for i in pay_emp_action_arch.ltr_ppa_arch.first ..
2548: pay_emp_action_arch.ltr_ppa_arch.last loop
2549: if pay_emp_action_arch.ltr_ppa_arch(i).act_info1
2550: = p_organization_id and
2551: pay_emp_action_arch.ltr_ppa_arch(i).act_info14
2552: = 'Employer Address' then
2553: lv_exists := 'Y';
2554: exit;
2555: end if;
2557: end if;
2558:
2559: if lv_exists = 'N' then
2560: hr_utility.set_location(gv_package || lv_procedure_name, 260);
2561: ln_index := pay_emp_action_arch.ltr_ppa_arch.count;
2562:
2563: pay_emp_action_arch.ltr_ppa_arch(ln_index).action_info_category
2564: := 'ADDRESS DETAILS';
2565: pay_emp_action_arch.ltr_ppa_arch(ln_index).jurisdiction_code
2559: if lv_exists = 'N' then
2560: hr_utility.set_location(gv_package || lv_procedure_name, 260);
2561: ln_index := pay_emp_action_arch.ltr_ppa_arch.count;
2562:
2563: pay_emp_action_arch.ltr_ppa_arch(ln_index).action_info_category
2564: := 'ADDRESS DETAILS';
2565: pay_emp_action_arch.ltr_ppa_arch(ln_index).jurisdiction_code
2566: := '00-000-0000';
2567: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info1
2561: ln_index := pay_emp_action_arch.ltr_ppa_arch.count;
2562:
2563: pay_emp_action_arch.ltr_ppa_arch(ln_index).action_info_category
2564: := 'ADDRESS DETAILS';
2565: pay_emp_action_arch.ltr_ppa_arch(ln_index).jurisdiction_code
2566: := '00-000-0000';
2567: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info1
2568: := p_organization_id;
2569: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info5
2563: pay_emp_action_arch.ltr_ppa_arch(ln_index).action_info_category
2564: := 'ADDRESS DETAILS';
2565: pay_emp_action_arch.ltr_ppa_arch(ln_index).jurisdiction_code
2566: := '00-000-0000';
2567: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info1
2568: := p_organization_id;
2569: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info5
2570: := lv_er_address_line_1 ;
2571: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info6
2565: pay_emp_action_arch.ltr_ppa_arch(ln_index).jurisdiction_code
2566: := '00-000-0000';
2567: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info1
2568: := p_organization_id;
2569: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info5
2570: := lv_er_address_line_1 ;
2571: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info6
2572: := lv_er_address_line_2;
2573: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info7
2567: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info1
2568: := p_organization_id;
2569: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info5
2570: := lv_er_address_line_1 ;
2571: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info6
2572: := lv_er_address_line_2;
2573: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info7
2574: := lv_er_address_line_3;
2575: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info8
2569: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info5
2570: := lv_er_address_line_1 ;
2571: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info6
2572: := lv_er_address_line_2;
2573: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info7
2574: := lv_er_address_line_3;
2575: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info8
2576: := lv_er_town_or_city;
2577: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info9
2571: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info6
2572: := lv_er_address_line_2;
2573: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info7
2574: := lv_er_address_line_3;
2575: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info8
2576: := lv_er_town_or_city;
2577: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info9
2578: := lv_er_region_1;
2579: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info10
2573: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info7
2574: := lv_er_address_line_3;
2575: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info8
2576: := lv_er_town_or_city;
2577: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info9
2578: := lv_er_region_1;
2579: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info10
2580: := lv_er_region_2;
2581: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info11
2575: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info8
2576: := lv_er_town_or_city;
2577: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info9
2578: := lv_er_region_1;
2579: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info10
2580: := lv_er_region_2;
2581: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info11
2582: := lv_er_region_3 ;
2583: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info12
2577: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info9
2578: := lv_er_region_1;
2579: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info10
2580: := lv_er_region_2;
2581: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info11
2582: := lv_er_region_3 ;
2583: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info12
2584: := lv_er_postal_code;
2585: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info13
2579: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info10
2580: := lv_er_region_2;
2581: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info11
2582: := lv_er_region_3 ;
2583: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info12
2584: := lv_er_postal_code;
2585: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info13
2586: := lv_er_country;
2587: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info14
2581: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info11
2582: := lv_er_region_3 ;
2583: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info12
2584: := lv_er_postal_code;
2585: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info13
2586: := lv_er_country;
2587: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info14
2588: := lv_ee_or_er;
2589: /*Bug# 13529461 - Start*/
2583: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info12
2584: := lv_er_postal_code;
2585: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info13
2586: := lv_er_country;
2587: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info14
2588: := lv_ee_or_er;
2589: /*Bug# 13529461 - Start*/
2590: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info15
2591: := get_organization_name(p_organization_id);
2586: := lv_er_country;
2587: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info14
2588: := lv_ee_or_er;
2589: /*Bug# 13529461 - Start*/
2590: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info15
2591: := get_organization_name(p_organization_id);
2592: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info16
2593: := lv_er_telephone;
2594: /*Bug# 13529461 - End*/
2588: := lv_ee_or_er;
2589: /*Bug# 13529461 - Start*/
2590: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info15
2591: := get_organization_name(p_organization_id);
2592: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info16
2593: := lv_er_telephone;
2594: /*Bug# 13529461 - End*/
2595: end if;
2596:
2648:
2649: hr_utility.set_location(gv_package || lv_procedure_name, 140);
2650:
2651: -- insert rows in pay_action_information table
2652: if pay_emp_action_arch.ltr_ppa_arch.count > 0 then
2653: insert_rows_thro_api_process(
2654: p_action_context_id => p_payroll_action_id
2655: ,p_action_context_type => 'PA'
2656: ,p_assignment_id => null
2655: ,p_action_context_type => 'PA'
2656: ,p_assignment_id => null
2657: ,p_tax_unit_id => null
2658: ,p_curr_pymt_eff_date => p_effective_date
2659: ,p_tab_rec_data => pay_emp_action_arch.ltr_ppa_arch
2660: );
2661: end if;
2662: EXCEPTION
2663: when others then
2768:
2769: hr_utility.set_location(gv_package || lv_procedure_name, 100);
2770:
2771: -- insert rows in pay_action_information table
2772: if pay_emp_action_arch.ltr_ppa_arch.count > 0 then
2773: insert_rows_thro_api_process(
2774: p_action_context_id => p_payroll_action_id
2775: ,p_action_context_type => 'PA'
2776: ,p_assignment_id => null
2775: ,p_action_context_type => 'PA'
2776: ,p_assignment_id => null
2777: ,p_tax_unit_id => null
2778: ,p_curr_pymt_eff_date => p_effective_date
2779: ,p_tab_rec_data => pay_emp_action_arch.ltr_ppa_arch
2780: );
2781: end if;
2782: hr_utility.set_location(gv_package || lv_procedure_name, 150);
2783:
3100: fetch c_step into lv_step;
3101: close c_step;
3102: end if;
3103:
3104: ln_index := pay_emp_action_arch.lrr_act_tab.count;
3105:
3106: hr_utility.trace('ln_index in get_personal_information proc is '
3107: || pay_emp_action_arch.lrr_act_tab.count);
3108:
3103:
3104: ln_index := pay_emp_action_arch.lrr_act_tab.count;
3105:
3106: hr_utility.trace('ln_index in get_personal_information proc is '
3107: || pay_emp_action_arch.lrr_act_tab.count);
3108:
3109: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category
3110: := 'EMPLOYEE DETAILS';
3111: pay_emp_action_arch.lrr_act_tab(ln_index).jurisdiction_code
3105:
3106: hr_utility.trace('ln_index in get_personal_information proc is '
3107: || pay_emp_action_arch.lrr_act_tab.count);
3108:
3109: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category
3110: := 'EMPLOYEE DETAILS';
3111: pay_emp_action_arch.lrr_act_tab(ln_index).jurisdiction_code
3112: := '00-000-0000';
3113: pay_emp_action_arch.lrr_act_tab(ln_index).act_info1
3107: || pay_emp_action_arch.lrr_act_tab.count);
3108:
3109: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category
3110: := 'EMPLOYEE DETAILS';
3111: pay_emp_action_arch.lrr_act_tab(ln_index).jurisdiction_code
3112: := '00-000-0000';
3113: pay_emp_action_arch.lrr_act_tab(ln_index).act_info1
3114: := lv_full_name;
3115: hr_utility.trace('lv_full_name is'||lv_full_name);
3109: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category
3110: := 'EMPLOYEE DETAILS';
3111: pay_emp_action_arch.lrr_act_tab(ln_index).jurisdiction_code
3112: := '00-000-0000';
3113: pay_emp_action_arch.lrr_act_tab(ln_index).act_info1
3114: := lv_full_name;
3115: hr_utility.trace('lv_full_name is'||lv_full_name);
3116:
3117: pay_emp_action_arch.lrr_act_tab(ln_index).act_info2
3113: pay_emp_action_arch.lrr_act_tab(ln_index).act_info1
3114: := lv_full_name;
3115: hr_utility.trace('lv_full_name is'||lv_full_name);
3116:
3117: pay_emp_action_arch.lrr_act_tab(ln_index).act_info2
3118: := ln_organization_id;
3119: hr_utility.trace('ln_organization_id is'||ln_organization_id);
3120:
3121: pay_emp_action_arch.lrr_act_tab(ln_index).act_info4
3117: pay_emp_action_arch.lrr_act_tab(ln_index).act_info2
3118: := ln_organization_id;
3119: hr_utility.trace('ln_organization_id is'||ln_organization_id);
3120:
3121: pay_emp_action_arch.lrr_act_tab(ln_index).act_info4
3122: := lv_national_identifier ;
3123:
3124: hr_utility.trace('lv_national_identifier is'||lv_national_identifier);
3125:
3122: := lv_national_identifier ;
3123:
3124: hr_utility.trace('lv_national_identifier is'||lv_national_identifier);
3125:
3126: pay_emp_action_arch.lrr_act_tab(ln_index).act_info5 := lv_pay_basis;
3127:
3128: hr_utility.trace('lv_pay_basis is'||lv_pay_basis);
3129:
3130: pay_emp_action_arch.lrr_act_tab(ln_index).act_info6
3126: pay_emp_action_arch.lrr_act_tab(ln_index).act_info5 := lv_pay_basis;
3127:
3128: hr_utility.trace('lv_pay_basis is'||lv_pay_basis);
3129:
3130: pay_emp_action_arch.lrr_act_tab(ln_index).act_info6
3131: := lv_frequency_desc;
3132:
3133: hr_utility.trace('lv_frequency_desc is'||lv_frequency_desc);
3134:
3131: := lv_frequency_desc;
3132:
3133: hr_utility.trace('lv_frequency_desc is'||lv_frequency_desc);
3134:
3135: pay_emp_action_arch.lrr_act_tab(ln_index).act_info7
3136: := lv_grade;
3137:
3138: hr_utility.trace('lv_grade is'||lv_grade);
3139:
3136: := lv_grade;
3137:
3138: hr_utility.trace('lv_grade is'||lv_grade);
3139:
3140: pay_emp_action_arch.lrr_act_tab(ln_index).act_info8
3141: := lv_bargaining_unit;
3142:
3143: hr_utility.trace('lv_bargaining_unit is'||lv_bargaining_unit);
3144: pay_emp_action_arch.lrr_act_tab(ln_index).act_info9
3140: pay_emp_action_arch.lrr_act_tab(ln_index).act_info8
3141: := lv_bargaining_unit;
3142:
3143: hr_utility.trace('lv_bargaining_unit is'||lv_bargaining_unit);
3144: pay_emp_action_arch.lrr_act_tab(ln_index).act_info9
3145: := lv_collective_agreement;
3146:
3147: hr_utility.trace('lv_collective_agreement is'||lv_collective_agreement);
3148: pay_emp_action_arch.lrr_act_tab(ln_index).act_info10
3144: pay_emp_action_arch.lrr_act_tab(ln_index).act_info9
3145: := lv_collective_agreement;
3146:
3147: hr_utility.trace('lv_collective_agreement is'||lv_collective_agreement);
3148: pay_emp_action_arch.lrr_act_tab(ln_index).act_info10
3149: := lv_employee_number ;
3150:
3151: pay_emp_action_arch.lrr_act_tab(ln_index).act_info11
3152: := fnd_date.date_to_canonical(ld_date_start);
3147: hr_utility.trace('lv_collective_agreement is'||lv_collective_agreement);
3148: pay_emp_action_arch.lrr_act_tab(ln_index).act_info10
3149: := lv_employee_number ;
3150:
3151: pay_emp_action_arch.lrr_act_tab(ln_index).act_info11
3152: := fnd_date.date_to_canonical(ld_date_start);
3153:
3154: pay_emp_action_arch.lrr_act_tab(ln_index).act_info12
3155: := fnd_date.date_to_canonical(ld_original_date_of_hire);
3150:
3151: pay_emp_action_arch.lrr_act_tab(ln_index).act_info11
3152: := fnd_date.date_to_canonical(ld_date_start);
3153:
3154: pay_emp_action_arch.lrr_act_tab(ln_index).act_info12
3155: := fnd_date.date_to_canonical(ld_original_date_of_hire);
3156:
3157: pay_emp_action_arch.lrr_act_tab(ln_index).act_info13
3158: := fnd_date.date_to_canonical(ld_adjusted_svc_date);
3153:
3154: pay_emp_action_arch.lrr_act_tab(ln_index).act_info12
3155: := fnd_date.date_to_canonical(ld_original_date_of_hire);
3156:
3157: pay_emp_action_arch.lrr_act_tab(ln_index).act_info13
3158: := fnd_date.date_to_canonical(ld_adjusted_svc_date);
3159:
3160: pay_emp_action_arch.lrr_act_tab(ln_index).act_info14
3161: := lv_assignment_number;
3156:
3157: pay_emp_action_arch.lrr_act_tab(ln_index).act_info13
3158: := fnd_date.date_to_canonical(ld_adjusted_svc_date);
3159:
3160: pay_emp_action_arch.lrr_act_tab(ln_index).act_info14
3161: := lv_assignment_number;
3162:
3163: pay_emp_action_arch.lrr_act_tab(ln_index).act_info15
3164: := lv_organization_name;
3159:
3160: pay_emp_action_arch.lrr_act_tab(ln_index).act_info14
3161: := lv_assignment_number;
3162:
3163: pay_emp_action_arch.lrr_act_tab(ln_index).act_info15
3164: := lv_organization_name;
3165: pay_emp_action_arch.lrr_act_tab(ln_index).act_info16
3166: := p_time_period_id;
3167: pay_emp_action_arch.lrr_act_tab(ln_index).act_info17
3161: := lv_assignment_number;
3162:
3163: pay_emp_action_arch.lrr_act_tab(ln_index).act_info15
3164: := lv_organization_name;
3165: pay_emp_action_arch.lrr_act_tab(ln_index).act_info16
3166: := p_time_period_id;
3167: pay_emp_action_arch.lrr_act_tab(ln_index).act_info17
3168: := lv_job_name ;
3169: pay_emp_action_arch.lrr_act_tab(ln_index).act_info18
3163: pay_emp_action_arch.lrr_act_tab(ln_index).act_info15
3164: := lv_organization_name;
3165: pay_emp_action_arch.lrr_act_tab(ln_index).act_info16
3166: := p_time_period_id;
3167: pay_emp_action_arch.lrr_act_tab(ln_index).act_info17
3168: := lv_job_name ;
3169: pay_emp_action_arch.lrr_act_tab(ln_index).act_info18
3170: := lv_gre_name;
3171: pay_emp_action_arch.lrr_act_tab(ln_index).act_info19
3165: pay_emp_action_arch.lrr_act_tab(ln_index).act_info16
3166: := p_time_period_id;
3167: pay_emp_action_arch.lrr_act_tab(ln_index).act_info17
3168: := lv_job_name ;
3169: pay_emp_action_arch.lrr_act_tab(ln_index).act_info18
3170: := lv_gre_name;
3171: pay_emp_action_arch.lrr_act_tab(ln_index).act_info19
3172: := lv_position_name;
3173: pay_emp_action_arch.lrr_act_tab(ln_index).act_info20
3167: pay_emp_action_arch.lrr_act_tab(ln_index).act_info17
3168: := lv_job_name ;
3169: pay_emp_action_arch.lrr_act_tab(ln_index).act_info18
3170: := lv_gre_name;
3171: pay_emp_action_arch.lrr_act_tab(ln_index).act_info19
3172: := lv_position_name;
3173: pay_emp_action_arch.lrr_act_tab(ln_index).act_info20
3174: := lv_contract;
3175: pay_emp_action_arch.lrr_act_tab(ln_index).act_info21
3169: pay_emp_action_arch.lrr_act_tab(ln_index).act_info18
3170: := lv_gre_name;
3171: pay_emp_action_arch.lrr_act_tab(ln_index).act_info19
3172: := lv_position_name;
3173: pay_emp_action_arch.lrr_act_tab(ln_index).act_info20
3174: := lv_contract;
3175: pay_emp_action_arch.lrr_act_tab(ln_index).act_info21
3176: := lv_time_normal_start ;
3177: pay_emp_action_arch.lrr_act_tab(ln_index).act_info22
3171: pay_emp_action_arch.lrr_act_tab(ln_index).act_info19
3172: := lv_position_name;
3173: pay_emp_action_arch.lrr_act_tab(ln_index).act_info20
3174: := lv_contract;
3175: pay_emp_action_arch.lrr_act_tab(ln_index).act_info21
3176: := lv_time_normal_start ;
3177: pay_emp_action_arch.lrr_act_tab(ln_index).act_info22
3178: := lv_time_normal_finish;
3179: pay_emp_action_arch.lrr_act_tab(ln_index).act_info23
3173: pay_emp_action_arch.lrr_act_tab(ln_index).act_info20
3174: := lv_contract;
3175: pay_emp_action_arch.lrr_act_tab(ln_index).act_info21
3176: := lv_time_normal_start ;
3177: pay_emp_action_arch.lrr_act_tab(ln_index).act_info22
3178: := lv_time_normal_finish;
3179: pay_emp_action_arch.lrr_act_tab(ln_index).act_info23
3180: := lv_pay_calc_method;
3181: pay_emp_action_arch.lrr_act_tab(ln_index).act_info24
3175: pay_emp_action_arch.lrr_act_tab(ln_index).act_info21
3176: := lv_time_normal_start ;
3177: pay_emp_action_arch.lrr_act_tab(ln_index).act_info22
3178: := lv_time_normal_finish;
3179: pay_emp_action_arch.lrr_act_tab(ln_index).act_info23
3180: := lv_pay_calc_method;
3181: pay_emp_action_arch.lrr_act_tab(ln_index).act_info24
3182: := lv_shift_desc;
3183: pay_emp_action_arch.lrr_act_tab(ln_index).act_info25
3177: pay_emp_action_arch.lrr_act_tab(ln_index).act_info22
3178: := lv_time_normal_finish;
3179: pay_emp_action_arch.lrr_act_tab(ln_index).act_info23
3180: := lv_pay_calc_method;
3181: pay_emp_action_arch.lrr_act_tab(ln_index).act_info24
3182: := lv_shift_desc;
3183: pay_emp_action_arch.lrr_act_tab(ln_index).act_info25
3184: := lv_er_phone_number;
3185: pay_emp_action_arch.lrr_act_tab(ln_index).act_info26
3179: pay_emp_action_arch.lrr_act_tab(ln_index).act_info23
3180: := lv_pay_calc_method;
3181: pay_emp_action_arch.lrr_act_tab(ln_index).act_info24
3182: := lv_shift_desc;
3183: pay_emp_action_arch.lrr_act_tab(ln_index).act_info25
3184: := lv_er_phone_number;
3185: pay_emp_action_arch.lrr_act_tab(ln_index).act_info26
3186: := lv_hourly_salaried_desc;
3187: pay_emp_action_arch.lrr_act_tab(ln_index).act_info27
3181: pay_emp_action_arch.lrr_act_tab(ln_index).act_info24
3182: := lv_shift_desc;
3183: pay_emp_action_arch.lrr_act_tab(ln_index).act_info25
3184: := lv_er_phone_number;
3185: pay_emp_action_arch.lrr_act_tab(ln_index).act_info26
3186: := lv_hourly_salaried_desc;
3187: pay_emp_action_arch.lrr_act_tab(ln_index).act_info27
3188: := lv_step ;
3189: pay_emp_action_arch.lrr_act_tab(ln_index).act_info28
3183: pay_emp_action_arch.lrr_act_tab(ln_index).act_info25
3184: := lv_er_phone_number;
3185: pay_emp_action_arch.lrr_act_tab(ln_index).act_info26
3186: := lv_hourly_salaried_desc;
3187: pay_emp_action_arch.lrr_act_tab(ln_index).act_info27
3188: := lv_step ;
3189: pay_emp_action_arch.lrr_act_tab(ln_index).act_info28
3190: := fnd_number.number_to_canonical(ln_proposed_salary) ; /* Bug 3311866*/
3191: pay_emp_action_arch.lrr_act_tab(ln_index).act_info29
3185: pay_emp_action_arch.lrr_act_tab(ln_index).act_info26
3186: := lv_hourly_salaried_desc;
3187: pay_emp_action_arch.lrr_act_tab(ln_index).act_info27
3188: := lv_step ;
3189: pay_emp_action_arch.lrr_act_tab(ln_index).act_info28
3190: := fnd_number.number_to_canonical(ln_proposed_salary) ; /* Bug 3311866*/
3191: pay_emp_action_arch.lrr_act_tab(ln_index).act_info29
3192: := fnd_number.number_to_canonical(ln_pay_annualization_factor) ;
3193: pay_emp_action_arch.lrr_act_tab(ln_index).act_info30
3187: pay_emp_action_arch.lrr_act_tab(ln_index).act_info27
3188: := lv_step ;
3189: pay_emp_action_arch.lrr_act_tab(ln_index).act_info28
3190: := fnd_number.number_to_canonical(ln_proposed_salary) ; /* Bug 3311866*/
3191: pay_emp_action_arch.lrr_act_tab(ln_index).act_info29
3192: := fnd_number.number_to_canonical(ln_pay_annualization_factor) ;
3193: pay_emp_action_arch.lrr_act_tab(ln_index).act_info30
3194: := lv_location_code ;
3195:
3189: pay_emp_action_arch.lrr_act_tab(ln_index).act_info28
3190: := fnd_number.number_to_canonical(ln_proposed_salary) ; /* Bug 3311866*/
3191: pay_emp_action_arch.lrr_act_tab(ln_index).act_info29
3192: := fnd_number.number_to_canonical(ln_pay_annualization_factor) ;
3193: pay_emp_action_arch.lrr_act_tab(ln_index).act_info30
3194: := lv_location_code ;
3195:
3196: close c_employee_details;
3197:
3227: get_employee_addr (ln_person_id
3228: ,p_curr_eff_date);
3229:
3230:
3231: if pay_emp_action_arch.lrr_act_tab.count > 0 then
3232: insert_rows_thro_api_process(
3233: p_action_context_id => p_assactid
3234: ,p_action_context_type=> 'AAP'
3235: ,p_assignment_id => p_assignment_id
3234: ,p_action_context_type=> 'AAP'
3235: ,p_assignment_id => p_assignment_id
3236: ,p_tax_unit_id => p_tax_unit_id
3237: ,p_curr_pymt_eff_date => p_curr_pymt_eff_date
3238: ,p_tab_rec_data => pay_emp_action_arch.lrr_act_tab
3239: );
3240: end if;
3241:
3242: END get_personal_information;
3241:
3242: END get_personal_information;
3243:
3244: BEGIN
3245: gv_package := 'pay_emp_action_arch';
3246:
3247: EXCEPTION
3248: when others then
3249: hr_utility.trace('Error in ' || gv_package ||
3249: hr_utility.trace('Error in ' || gv_package ||
3250: to_char(sqlcode) || '-' || sqlerrm);
3251: raise hr_utility.hr_error;
3252:
3253: END pay_emp_action_arch;