[Home] [Help]
155: l_dummy VARCHAR2(1000);
156: l_proc VARCHAR2(100) := 'pay_gb_eoy_archive.remove_null_address_lines';
157: --
158: BEGIN
159: hr_utility.set_location('Entering: '||l_proc,1);
160: hr_utility.trace('p_address_line1='||p_address_line1);
161: hr_utility.trace('p_address_line2='||p_address_line2);
162: hr_utility.trace('p_address_line3='||p_address_line3);
163: hr_utility.trace('p_address_line4='||p_address_line4);
156: l_proc VARCHAR2(100) := 'pay_gb_eoy_archive.remove_null_address_lines';
157: --
158: BEGIN
159: hr_utility.set_location('Entering: '||l_proc,1);
160: hr_utility.trace('p_address_line1='||p_address_line1);
161: hr_utility.trace('p_address_line2='||p_address_line2);
162: hr_utility.trace('p_address_line3='||p_address_line3);
163: hr_utility.trace('p_address_line4='||p_address_line4);
164: --
157: --
158: BEGIN
159: hr_utility.set_location('Entering: '||l_proc,1);
160: hr_utility.trace('p_address_line1='||p_address_line1);
161: hr_utility.trace('p_address_line2='||p_address_line2);
162: hr_utility.trace('p_address_line3='||p_address_line3);
163: hr_utility.trace('p_address_line4='||p_address_line4);
164: --
165: l_lines(1) := p_address_line1;
158: BEGIN
159: hr_utility.set_location('Entering: '||l_proc,1);
160: hr_utility.trace('p_address_line1='||p_address_line1);
161: hr_utility.trace('p_address_line2='||p_address_line2);
162: hr_utility.trace('p_address_line3='||p_address_line3);
163: hr_utility.trace('p_address_line4='||p_address_line4);
164: --
165: l_lines(1) := p_address_line1;
166: l_lines(2) := p_address_line2;
159: hr_utility.set_location('Entering: '||l_proc,1);
160: hr_utility.trace('p_address_line1='||p_address_line1);
161: hr_utility.trace('p_address_line2='||p_address_line2);
162: hr_utility.trace('p_address_line3='||p_address_line3);
163: hr_utility.trace('p_address_line4='||p_address_line4);
164: --
165: l_lines(1) := p_address_line1;
166: l_lines(2) := p_address_line2;
167: l_lines(3) := p_address_line3;
175: END IF;
176: END LOOP;
177: END LOOP;
178: --
179: hr_utility.set_location(l_proc,10);
180: --
181: p_address_line1 := l_lines(1);
182: p_address_line2 := l_lines(2);
183: p_address_line3 := l_lines(3);
182: p_address_line2 := l_lines(2);
183: p_address_line3 := l_lines(3);
184: p_address_line4 := l_lines(4);
185: --
186: hr_utility.set_location('Leaving: '||l_proc,20);
187: hr_utility.trace('p_address_line1='||p_address_line1);
188: hr_utility.trace('p_address_line2='||p_address_line2);
189: hr_utility.trace('p_address_line3='||p_address_line3);
190: hr_utility.trace('p_address_line4='||p_address_line4);
183: p_address_line3 := l_lines(3);
184: p_address_line4 := l_lines(4);
185: --
186: hr_utility.set_location('Leaving: '||l_proc,20);
187: hr_utility.trace('p_address_line1='||p_address_line1);
188: hr_utility.trace('p_address_line2='||p_address_line2);
189: hr_utility.trace('p_address_line3='||p_address_line3);
190: hr_utility.trace('p_address_line4='||p_address_line4);
191: END;
184: p_address_line4 := l_lines(4);
185: --
186: hr_utility.set_location('Leaving: '||l_proc,20);
187: hr_utility.trace('p_address_line1='||p_address_line1);
188: hr_utility.trace('p_address_line2='||p_address_line2);
189: hr_utility.trace('p_address_line3='||p_address_line3);
190: hr_utility.trace('p_address_line4='||p_address_line4);
191: END;
192: --
185: --
186: hr_utility.set_location('Leaving: '||l_proc,20);
187: hr_utility.trace('p_address_line1='||p_address_line1);
188: hr_utility.trace('p_address_line2='||p_address_line2);
189: hr_utility.trace('p_address_line3='||p_address_line3);
190: hr_utility.trace('p_address_line4='||p_address_line4);
191: END;
192: --
193:
186: hr_utility.set_location('Leaving: '||l_proc,20);
187: hr_utility.trace('p_address_line1='||p_address_line1);
188: hr_utility.trace('p_address_line2='||p_address_line2);
189: hr_utility.trace('p_address_line3='||p_address_line3);
190: hr_utility.trace('p_address_line4='||p_address_line4);
191: END;
192: --
193:
194:
248: l_ovn NUMBER;
249:
250: BEGIN
251:
252: hr_utility.set_location('Entering '|| l_proc, 10);
253: l_arch := TRUE;
254:
255: OPEN csr_parameter_info;
256: FETCH csr_parameter_info
264: FETCH csr_payrolls
265: INTO l_payroll_rec;
266: CLOSE csr_payrolls;
267:
268: hr_utility.trace('Assigning values to p_payroll_rec');
269: hr_utility.trace('l_payroll_rec.tax_district_reference '||l_payroll_rec.tax_district_reference);
270: hr_utility.trace('l_payroll_rec.tax_reference '||l_payroll_rec.tax_reference);
271: hr_utility.trace('l_payroll_rec.tax_district_name '||l_payroll_rec.tax_district_name);
272: hr_utility.trace('l_payroll_rec.employers_name '||l_payroll_rec.employers_name);
265: INTO l_payroll_rec;
266: CLOSE csr_payrolls;
267:
268: hr_utility.trace('Assigning values to p_payroll_rec');
269: hr_utility.trace('l_payroll_rec.tax_district_reference '||l_payroll_rec.tax_district_reference);
270: hr_utility.trace('l_payroll_rec.tax_reference '||l_payroll_rec.tax_reference);
271: hr_utility.trace('l_payroll_rec.tax_district_name '||l_payroll_rec.tax_district_name);
272: hr_utility.trace('l_payroll_rec.employers_name '||l_payroll_rec.employers_name);
273: hr_utility.trace('l_payroll_rec.employers_address_line '||l_payroll_rec.employers_address_line);
266: CLOSE csr_payrolls;
267:
268: hr_utility.trace('Assigning values to p_payroll_rec');
269: hr_utility.trace('l_payroll_rec.tax_district_reference '||l_payroll_rec.tax_district_reference);
270: hr_utility.trace('l_payroll_rec.tax_reference '||l_payroll_rec.tax_reference);
271: hr_utility.trace('l_payroll_rec.tax_district_name '||l_payroll_rec.tax_district_name);
272: hr_utility.trace('l_payroll_rec.employers_name '||l_payroll_rec.employers_name);
273: hr_utility.trace('l_payroll_rec.employers_address_line '||l_payroll_rec.employers_address_line);
274:
267:
268: hr_utility.trace('Assigning values to p_payroll_rec');
269: hr_utility.trace('l_payroll_rec.tax_district_reference '||l_payroll_rec.tax_district_reference);
270: hr_utility.trace('l_payroll_rec.tax_reference '||l_payroll_rec.tax_reference);
271: hr_utility.trace('l_payroll_rec.tax_district_name '||l_payroll_rec.tax_district_name);
272: hr_utility.trace('l_payroll_rec.employers_name '||l_payroll_rec.employers_name);
273: hr_utility.trace('l_payroll_rec.employers_address_line '||l_payroll_rec.employers_address_line);
274:
275: pay_action_information_api.create_action_information ( p_action_information_id => l_action_info_id ,
268: hr_utility.trace('Assigning values to p_payroll_rec');
269: hr_utility.trace('l_payroll_rec.tax_district_reference '||l_payroll_rec.tax_district_reference);
270: hr_utility.trace('l_payroll_rec.tax_reference '||l_payroll_rec.tax_reference);
271: hr_utility.trace('l_payroll_rec.tax_district_name '||l_payroll_rec.tax_district_name);
272: hr_utility.trace('l_payroll_rec.employers_name '||l_payroll_rec.employers_name);
273: hr_utility.trace('l_payroll_rec.employers_address_line '||l_payroll_rec.employers_address_line);
274:
275: pay_action_information_api.create_action_information ( p_action_information_id => l_action_info_id ,
276: p_action_context_id => p_pactid ,
269: hr_utility.trace('l_payroll_rec.tax_district_reference '||l_payroll_rec.tax_district_reference);
270: hr_utility.trace('l_payroll_rec.tax_reference '||l_payroll_rec.tax_reference);
271: hr_utility.trace('l_payroll_rec.tax_district_name '||l_payroll_rec.tax_district_name);
272: hr_utility.trace('l_payroll_rec.employers_name '||l_payroll_rec.employers_name);
273: hr_utility.trace('l_payroll_rec.employers_address_line '||l_payroll_rec.employers_address_line);
274:
275: pay_action_information_api.create_action_information ( p_action_information_id => l_action_info_id ,
276: p_action_context_id => p_pactid ,
277: p_action_context_type => 'PA' ,
283: p_action_information2 => l_payroll_rec.tax_district_name ,
284: p_action_information3 => l_payroll_rec.employers_name ,
285: p_action_information4 => l_payroll_rec.employers_address_line);
286:
287: hr_utility.trace('After archiving data for GB RTI P60 PAYROLL DET');
288: RETURN l_arch;
289:
290: EXCEPTION
291: WHEN OTHERS THEN
288: RETURN l_arch;
289:
290: EXCEPTION
291: WHEN OTHERS THEN
292: hr_utility.set_location('Error in function fetch_p60_payroll_det ', 15);
293: hr_utility.trace('Exception:' || SQLCODE || ' - ' || SQLERRM );
294: fnd_file.put_line(fnd_file.LOG,'Exception:' || SQLCODE || ' - ' || SQLERRM);
295: RAISE;
296: END fetch_p60_payroll_det;
289:
290: EXCEPTION
291: WHEN OTHERS THEN
292: hr_utility.set_location('Error in function fetch_p60_payroll_det ', 15);
293: hr_utility.trace('Exception:' || SQLCODE || ' - ' || SQLERRM );
294: fnd_file.put_line(fnd_file.LOG,'Exception:' || SQLCODE || ' - ' || SQLERRM);
295: RAISE;
296: END fetch_p60_payroll_det;
297:
393: l_people_group_flex number;
394: --
395:
396: BEGIN
397: hr_utility.set_location('Entering '|| l_proc, 10);
398: l_arch := true;
399: OPEN csr_person_info(p_person_id);
400: FETCH csr_person_info INTO l_last_name,
401: l_first_name,
411: l_employee_number,
412: l_expense_check;
413: CLOSE csr_person_info;
414:
415: hr_utility.trace('l_first_name='||l_first_name);
416: hr_utility.trace('l_middle_name='||l_middle_name);
417: hr_utility.trace('l_date_of_birth='||fnd_date.date_to_displaydate(l_date_of_birth));
418: hr_utility.trace('l_title='||l_title);
419: hr_utility.trace('l_expense_check_to_address='||l_expense_check_to_address);
412: l_expense_check;
413: CLOSE csr_person_info;
414:
415: hr_utility.trace('l_first_name='||l_first_name);
416: hr_utility.trace('l_middle_name='||l_middle_name);
417: hr_utility.trace('l_date_of_birth='||fnd_date.date_to_displaydate(l_date_of_birth));
418: hr_utility.trace('l_title='||l_title);
419: hr_utility.trace('l_expense_check_to_address='||l_expense_check_to_address);
420: hr_utility.trace('l_ni_number='||l_ni_number);
413: CLOSE csr_person_info;
414:
415: hr_utility.trace('l_first_name='||l_first_name);
416: hr_utility.trace('l_middle_name='||l_middle_name);
417: hr_utility.trace('l_date_of_birth='||fnd_date.date_to_displaydate(l_date_of_birth));
418: hr_utility.trace('l_title='||l_title);
419: hr_utility.trace('l_expense_check_to_address='||l_expense_check_to_address);
420: hr_utility.trace('l_ni_number='||l_ni_number);
421: hr_utility.trace('l_sex='||l_sex);
414:
415: hr_utility.trace('l_first_name='||l_first_name);
416: hr_utility.trace('l_middle_name='||l_middle_name);
417: hr_utility.trace('l_date_of_birth='||fnd_date.date_to_displaydate(l_date_of_birth));
418: hr_utility.trace('l_title='||l_title);
419: hr_utility.trace('l_expense_check_to_address='||l_expense_check_to_address);
420: hr_utility.trace('l_ni_number='||l_ni_number);
421: hr_utility.trace('l_sex='||l_sex);
422: hr_utility.trace('l_pensioner_indicator='||l_pensioner_indicator);
415: hr_utility.trace('l_first_name='||l_first_name);
416: hr_utility.trace('l_middle_name='||l_middle_name);
417: hr_utility.trace('l_date_of_birth='||fnd_date.date_to_displaydate(l_date_of_birth));
418: hr_utility.trace('l_title='||l_title);
419: hr_utility.trace('l_expense_check_to_address='||l_expense_check_to_address);
420: hr_utility.trace('l_ni_number='||l_ni_number);
421: hr_utility.trace('l_sex='||l_sex);
422: hr_utility.trace('l_pensioner_indicator='||l_pensioner_indicator);
423: hr_utility.trace('l_aggregated_paye_flag='||l_aggregated_paye_flag);
416: hr_utility.trace('l_middle_name='||l_middle_name);
417: hr_utility.trace('l_date_of_birth='||fnd_date.date_to_displaydate(l_date_of_birth));
418: hr_utility.trace('l_title='||l_title);
419: hr_utility.trace('l_expense_check_to_address='||l_expense_check_to_address);
420: hr_utility.trace('l_ni_number='||l_ni_number);
421: hr_utility.trace('l_sex='||l_sex);
422: hr_utility.trace('l_pensioner_indicator='||l_pensioner_indicator);
423: hr_utility.trace('l_aggregated_paye_flag='||l_aggregated_paye_flag);
424: hr_utility.trace('l_multiple_asg_flag='||l_multiple_asg_flag);
417: hr_utility.trace('l_date_of_birth='||fnd_date.date_to_displaydate(l_date_of_birth));
418: hr_utility.trace('l_title='||l_title);
419: hr_utility.trace('l_expense_check_to_address='||l_expense_check_to_address);
420: hr_utility.trace('l_ni_number='||l_ni_number);
421: hr_utility.trace('l_sex='||l_sex);
422: hr_utility.trace('l_pensioner_indicator='||l_pensioner_indicator);
423: hr_utility.trace('l_aggregated_paye_flag='||l_aggregated_paye_flag);
424: hr_utility.trace('l_multiple_asg_flag='||l_multiple_asg_flag);
425:
418: hr_utility.trace('l_title='||l_title);
419: hr_utility.trace('l_expense_check_to_address='||l_expense_check_to_address);
420: hr_utility.trace('l_ni_number='||l_ni_number);
421: hr_utility.trace('l_sex='||l_sex);
422: hr_utility.trace('l_pensioner_indicator='||l_pensioner_indicator);
423: hr_utility.trace('l_aggregated_paye_flag='||l_aggregated_paye_flag);
424: hr_utility.trace('l_multiple_asg_flag='||l_multiple_asg_flag);
425:
426: OPEN csr_addresses(p_person_id);
419: hr_utility.trace('l_expense_check_to_address='||l_expense_check_to_address);
420: hr_utility.trace('l_ni_number='||l_ni_number);
421: hr_utility.trace('l_sex='||l_sex);
422: hr_utility.trace('l_pensioner_indicator='||l_pensioner_indicator);
423: hr_utility.trace('l_aggregated_paye_flag='||l_aggregated_paye_flag);
424: hr_utility.trace('l_multiple_asg_flag='||l_multiple_asg_flag);
425:
426: OPEN csr_addresses(p_person_id);
427: FETCH csr_addresses INTO l_address_line1,
420: hr_utility.trace('l_ni_number='||l_ni_number);
421: hr_utility.trace('l_sex='||l_sex);
422: hr_utility.trace('l_pensioner_indicator='||l_pensioner_indicator);
423: hr_utility.trace('l_aggregated_paye_flag='||l_aggregated_paye_flag);
424: hr_utility.trace('l_multiple_asg_flag='||l_multiple_asg_flag);
425:
426: OPEN csr_addresses(p_person_id);
427: FETCH csr_addresses INTO l_address_line1,
428: l_address_line2,
432: l_postal_code,
433: l_country; -- 4011263
434: CLOSE csr_addresses;
435:
436: hr_utility.trace('l_address_line1='||l_address_line1);
437: hr_utility.trace('l_address_line2='||l_address_line2);
438: hr_utility.trace('l_address_line3='||l_address_line3);
439: hr_utility.trace('l_town_or_city='||l_town_or_city);
440: hr_utility.trace('l_county='||l_county);
433: l_country; -- 4011263
434: CLOSE csr_addresses;
435:
436: hr_utility.trace('l_address_line1='||l_address_line1);
437: hr_utility.trace('l_address_line2='||l_address_line2);
438: hr_utility.trace('l_address_line3='||l_address_line3);
439: hr_utility.trace('l_town_or_city='||l_town_or_city);
440: hr_utility.trace('l_county='||l_county);
441: hr_utility.trace('l_postal_code='||l_postal_code);
434: CLOSE csr_addresses;
435:
436: hr_utility.trace('l_address_line1='||l_address_line1);
437: hr_utility.trace('l_address_line2='||l_address_line2);
438: hr_utility.trace('l_address_line3='||l_address_line3);
439: hr_utility.trace('l_town_or_city='||l_town_or_city);
440: hr_utility.trace('l_county='||l_county);
441: hr_utility.trace('l_postal_code='||l_postal_code);
442: hr_utility.trace('l_country='||l_country);
435:
436: hr_utility.trace('l_address_line1='||l_address_line1);
437: hr_utility.trace('l_address_line2='||l_address_line2);
438: hr_utility.trace('l_address_line3='||l_address_line3);
439: hr_utility.trace('l_town_or_city='||l_town_or_city);
440: hr_utility.trace('l_county='||l_county);
441: hr_utility.trace('l_postal_code='||l_postal_code);
442: hr_utility.trace('l_country='||l_country);
443: --
436: hr_utility.trace('l_address_line1='||l_address_line1);
437: hr_utility.trace('l_address_line2='||l_address_line2);
438: hr_utility.trace('l_address_line3='||l_address_line3);
439: hr_utility.trace('l_town_or_city='||l_town_or_city);
440: hr_utility.trace('l_county='||l_county);
441: hr_utility.trace('l_postal_code='||l_postal_code);
442: hr_utility.trace('l_country='||l_country);
443: --
444: /* 4752018 - Push null address lines to the end */
437: hr_utility.trace('l_address_line2='||l_address_line2);
438: hr_utility.trace('l_address_line3='||l_address_line3);
439: hr_utility.trace('l_town_or_city='||l_town_or_city);
440: hr_utility.trace('l_county='||l_county);
441: hr_utility.trace('l_postal_code='||l_postal_code);
442: hr_utility.trace('l_country='||l_country);
443: --
444: /* 4752018 - Push null address lines to the end */
445: remove_null_address_lines(p_address_line1 => l_address_line1,
438: hr_utility.trace('l_address_line3='||l_address_line3);
439: hr_utility.trace('l_town_or_city='||l_town_or_city);
440: hr_utility.trace('l_county='||l_county);
441: hr_utility.trace('l_postal_code='||l_postal_code);
442: hr_utility.trace('l_country='||l_country);
443: --
444: /* 4752018 - Push null address lines to the end */
445: remove_null_address_lines(p_address_line1 => l_address_line1,
446: p_address_line2 => l_address_line2,
511: (36-(length(l_assignment_number)+1)),' ')||' '||
512: l_assignment_number);
513: end if;
514:
515: hr_utility.trace('Assigning values to p_emp_rec');
516:
517: p_emp_rec.assignment_id := p_asg_id;
518: p_emp_rec.action_info_category := 'GB RTI P60 EMP DET';
519: p_emp_rec.act_info1 := l_ni_number;
537: p_emp_rec.act_info18 := l_expense_check;
538: p_emp_rec.act_info19 := l_people_group_flex;
539: p_emp_rec.act_info20 := g_business_group_id;
540:
541: hr_utility.set_location('Leaving: '||l_proc,999);
542: RETURN l_arch;
543:
544:
545: EXCEPTION
543:
544:
545: EXCEPTION
546: WHEN OTHERS THEN
547: hr_utility.set_location('Error in function fetch_p60_emp_det ', 15);
548: hr_utility.trace('Exception:' || SQLCODE || ' - ' || SQLERRM );
549: fnd_file.put_line(fnd_file.LOG,'Exception:' || SQLCODE || ' - ' || SQLERRM);
550: RAISE;
551: END fetch_p60_emp_det;
544:
545: EXCEPTION
546: WHEN OTHERS THEN
547: hr_utility.set_location('Error in function fetch_p60_emp_det ', 15);
548: hr_utility.trace('Exception:' || SQLCODE || ' - ' || SQLERRM );
549: fnd_file.put_line(fnd_file.LOG,'Exception:' || SQLCODE || ' - ' || SQLERRM);
550: RAISE;
551: END fetch_p60_emp_det;
552:
788: l_aggr_last_chld_act_id number;
789: l_assignment_number varchar2(30);
790:
791: BEGIN
792: hr_utility.set_location('Entering '|| l_proc, 10);
793: l_arch := true;
794:
795: hr_utility.trace('p_assactid : '||p_assactid);
796: hr_utility.trace('p_pactid : '||p_pactid);
791: BEGIN
792: hr_utility.set_location('Entering '|| l_proc, 10);
793: l_arch := true;
794:
795: hr_utility.trace('p_assactid : '||p_assactid);
796: hr_utility.trace('p_pactid : '||p_pactid);
797: hr_utility.trace('p_last_asg_action_id : '||p_last_asg_action_id);
798: hr_utility.trace('p_person_id : '||p_person_id);
799: hr_utility.trace('p_asg_id : '||p_asg_id);
792: hr_utility.set_location('Entering '|| l_proc, 10);
793: l_arch := true;
794:
795: hr_utility.trace('p_assactid : '||p_assactid);
796: hr_utility.trace('p_pactid : '||p_pactid);
797: hr_utility.trace('p_last_asg_action_id : '||p_last_asg_action_id);
798: hr_utility.trace('p_person_id : '||p_person_id);
799: hr_utility.trace('p_asg_id : '||p_asg_id);
800: hr_utility.trace('p_start_date : '||p_start_date);
793: l_arch := true;
794:
795: hr_utility.trace('p_assactid : '||p_assactid);
796: hr_utility.trace('p_pactid : '||p_pactid);
797: hr_utility.trace('p_last_asg_action_id : '||p_last_asg_action_id);
798: hr_utility.trace('p_person_id : '||p_person_id);
799: hr_utility.trace('p_asg_id : '||p_asg_id);
800: hr_utility.trace('p_start_date : '||p_start_date);
801: hr_utility.trace('p_end_date : '||p_end_date);
794:
795: hr_utility.trace('p_assactid : '||p_assactid);
796: hr_utility.trace('p_pactid : '||p_pactid);
797: hr_utility.trace('p_last_asg_action_id : '||p_last_asg_action_id);
798: hr_utility.trace('p_person_id : '||p_person_id);
799: hr_utility.trace('p_asg_id : '||p_asg_id);
800: hr_utility.trace('p_start_date : '||p_start_date);
801: hr_utility.trace('p_end_date : '||p_end_date);
802:
795: hr_utility.trace('p_assactid : '||p_assactid);
796: hr_utility.trace('p_pactid : '||p_pactid);
797: hr_utility.trace('p_last_asg_action_id : '||p_last_asg_action_id);
798: hr_utility.trace('p_person_id : '||p_person_id);
799: hr_utility.trace('p_asg_id : '||p_asg_id);
800: hr_utility.trace('p_start_date : '||p_start_date);
801: hr_utility.trace('p_end_date : '||p_end_date);
802:
803: OPEN csr_parameter_info;
796: hr_utility.trace('p_pactid : '||p_pactid);
797: hr_utility.trace('p_last_asg_action_id : '||p_last_asg_action_id);
798: hr_utility.trace('p_person_id : '||p_person_id);
799: hr_utility.trace('p_asg_id : '||p_asg_id);
800: hr_utility.trace('p_start_date : '||p_start_date);
801: hr_utility.trace('p_end_date : '||p_end_date);
802:
803: OPEN csr_parameter_info;
804: FETCH csr_parameter_info
797: hr_utility.trace('p_last_asg_action_id : '||p_last_asg_action_id);
798: hr_utility.trace('p_person_id : '||p_person_id);
799: hr_utility.trace('p_asg_id : '||p_asg_id);
800: hr_utility.trace('p_start_date : '||p_start_date);
801: hr_utility.trace('p_end_date : '||p_end_date);
802:
803: OPEN csr_parameter_info;
804: FETCH csr_parameter_info
805: INTO l_tax_ref;
804: FETCH csr_parameter_info
805: INTO l_tax_ref;
806: CLOSE csr_parameter_info;
807:
808: hr_utility.trace('l_tax_ref : '||l_tax_ref);
809:
810: l_context_lst(1).tax_unit_id :=NULL;
811: l_context_lst(1).jurisdiction_code :=NULL;
812: l_context_lst(1).source_id :=NULL;
826: IF l_last_chld_act_id is NULL THEN
827: l_last_chld_act_id := p_last_asg_action_id;
828: END IF;
829:
830: hr_utility.trace('l_last_chld_act_id : '||l_last_chld_act_id);
831:
832: OPEN csr_tax_paye_result(l_last_chld_act_id);
833: FETCH csr_tax_paye_result
834: INTO l_tax_code,
836: l_pay_previous,
837: l_tax_previous;
838: CLOSE csr_tax_paye_result;
839:
840: hr_utility.trace('l_tax_code : '||l_tax_code);
841:
842: if l_tax_code is null then
843: open csr_paye_details(p_asg_id);
844: fetch csr_paye_details
848: l_tax_previous;
849: close csr_paye_details;
850: end if;
851:
852: hr_utility.trace('l_tax_code : '||l_tax_code);
853: hr_utility.trace('l_w1_m1_indicator : '||l_w1_m1_indicator);
854: hr_utility.trace('l_pay_previous : '||l_pay_previous);
855: hr_utility.trace('l_tax_previous : '||l_tax_previous);
856:
849: close csr_paye_details;
850: end if;
851:
852: hr_utility.trace('l_tax_code : '||l_tax_code);
853: hr_utility.trace('l_w1_m1_indicator : '||l_w1_m1_indicator);
854: hr_utility.trace('l_pay_previous : '||l_pay_previous);
855: hr_utility.trace('l_tax_previous : '||l_tax_previous);
856:
857: OPEN csr_get_period_type;
850: end if;
851:
852: hr_utility.trace('l_tax_code : '||l_tax_code);
853: hr_utility.trace('l_w1_m1_indicator : '||l_w1_m1_indicator);
854: hr_utility.trace('l_pay_previous : '||l_pay_previous);
855: hr_utility.trace('l_tax_previous : '||l_tax_previous);
856:
857: OPEN csr_get_period_type;
858: FETCH csr_get_period_type
851:
852: hr_utility.trace('l_tax_code : '||l_tax_code);
853: hr_utility.trace('l_w1_m1_indicator : '||l_w1_m1_indicator);
854: hr_utility.trace('l_pay_previous : '||l_pay_previous);
855: hr_utility.trace('l_tax_previous : '||l_tax_previous);
856:
857: OPEN csr_get_period_type;
858: FETCH csr_get_period_type
859: INTO l_payroll_id, l_period_type, l_prl_max_period_number, l_prl_start_year, l_prl_end_year;
858: FETCH csr_get_period_type
859: INTO l_payroll_id, l_period_type, l_prl_max_period_number, l_prl_start_year, l_prl_end_year;
860: CLOSE csr_get_period_type;
861:
862: hr_utility.trace('l_payroll_id : '||l_payroll_id);
863: hr_utility.trace('l_period_type :'||l_period_type);
864: hr_utility.trace('l_prl_max_period_number : '||l_prl_max_period_number);
865: hr_utility.trace('l_prl_start_year : '||l_prl_start_year);
866: hr_utility.trace('l_prl_end_year : '||l_prl_end_year);
859: INTO l_payroll_id, l_period_type, l_prl_max_period_number, l_prl_start_year, l_prl_end_year;
860: CLOSE csr_get_period_type;
861:
862: hr_utility.trace('l_payroll_id : '||l_payroll_id);
863: hr_utility.trace('l_period_type :'||l_period_type);
864: hr_utility.trace('l_prl_max_period_number : '||l_prl_max_period_number);
865: hr_utility.trace('l_prl_start_year : '||l_prl_start_year);
866: hr_utility.trace('l_prl_end_year : '||l_prl_end_year);
867:
860: CLOSE csr_get_period_type;
861:
862: hr_utility.trace('l_payroll_id : '||l_payroll_id);
863: hr_utility.trace('l_period_type :'||l_period_type);
864: hr_utility.trace('l_prl_max_period_number : '||l_prl_max_period_number);
865: hr_utility.trace('l_prl_start_year : '||l_prl_start_year);
866: hr_utility.trace('l_prl_end_year : '||l_prl_end_year);
867:
868: OPEN csr_period_type_info(l_period_type);
861:
862: hr_utility.trace('l_payroll_id : '||l_payroll_id);
863: hr_utility.trace('l_period_type :'||l_period_type);
864: hr_utility.trace('l_prl_max_period_number : '||l_prl_max_period_number);
865: hr_utility.trace('l_prl_start_year : '||l_prl_start_year);
866: hr_utility.trace('l_prl_end_year : '||l_prl_end_year);
867:
868: OPEN csr_period_type_info(l_period_type);
869: FETCH csr_period_type_info INTO l_number_per_fiscal_yr;
862: hr_utility.trace('l_payroll_id : '||l_payroll_id);
863: hr_utility.trace('l_period_type :'||l_period_type);
864: hr_utility.trace('l_prl_max_period_number : '||l_prl_max_period_number);
865: hr_utility.trace('l_prl_start_year : '||l_prl_start_year);
866: hr_utility.trace('l_prl_end_year : '||l_prl_end_year);
867:
868: OPEN csr_period_type_info(l_period_type);
869: FETCH csr_period_type_info INTO l_number_per_fiscal_yr;
870: CLOSE csr_period_type_info;
868: OPEN csr_period_type_info(l_period_type);
869: FETCH csr_period_type_info INTO l_number_per_fiscal_yr;
870: CLOSE csr_period_type_info;
871:
872: hr_utility.trace('l_number_per_fiscal_yr :'||l_number_per_fiscal_yr);
873: hr_utility.trace('l_w1_m1_indicator before :'||l_w1_m1_indicator);
874:
875: IF l_w1_m1_indicator = 'C' THEN
876: l_w1_m1_indicator := ' ';
869: FETCH csr_period_type_info INTO l_number_per_fiscal_yr;
870: CLOSE csr_period_type_info;
871:
872: hr_utility.trace('l_number_per_fiscal_yr :'||l_number_per_fiscal_yr);
873: hr_utility.trace('l_w1_m1_indicator before :'||l_w1_m1_indicator);
874:
875: IF l_w1_m1_indicator = 'C' THEN
876: l_w1_m1_indicator := ' ';
877: ELSE
874:
875: IF l_w1_m1_indicator = 'C' THEN
876: l_w1_m1_indicator := ' ';
877: ELSE
878: hr_utility.trace('No of periods per year = '||l_number_per_fiscal_yr);
879: IF l_number_per_fiscal_yr in (1,2,4,6,12,24) THEN
880: l_w1_m1_indicator := 'M';
881: ELSE
882: l_w1_m1_indicator := 'W';
886: IF (l_w1_m1_indicator in ('M', 'W')) THEN
887: l_w1_m1_indicator := l_w1_m1_indicator || '1';
888: END IF;
889:
890: hr_utility.trace('l_w1_m1_indicator after :'||l_w1_m1_indicator);
891:
892: p_asg_rec.act_info5 := l_tax_code;
893: p_asg_rec.act_info6 := l_w1_m1_indicator;
894:
895: OPEN get_asg_active_range(p_asg_id, l_tax_ref);
896: FETCH get_asg_active_range INTO l_active_start, l_active_end;
897: CLOSE get_asg_active_range;
898:
899: hr_utility.trace('l_active_start : '||l_active_start);
900: hr_utility.trace('l_active_end : '||l_active_end);
901:
902: if l_prl_max_period_number in (53,54,56) then
903: OPEN get_week_53_start(l_payroll_id, l_prl_max_period_number,l_prl_start_year, l_prl_end_year);
896: FETCH get_asg_active_range INTO l_active_start, l_active_end;
897: CLOSE get_asg_active_range;
898:
899: hr_utility.trace('l_active_start : '||l_active_start);
900: hr_utility.trace('l_active_end : '||l_active_end);
901:
902: if l_prl_max_period_number in (53,54,56) then
903: OPEN get_week_53_start(l_payroll_id, l_prl_max_period_number,l_prl_start_year, l_prl_end_year);
904: FETCH get_week_53_start INTO l_week_53_start;
903: OPEN get_week_53_start(l_payroll_id, l_prl_max_period_number,l_prl_start_year, l_prl_end_year);
904: FETCH get_week_53_start INTO l_week_53_start;
905: CLOSE get_week_53_start;
906:
907: hr_utility.trace('After get_week_53_start, l_week_53_start='||
908: fnd_date.date_to_displaydate(l_week_53_start));
909: IF nvl(l_week_53_start, hr_general.end_of_time) <= l_active_end THEN
910: l_week_53_indicator := substr(to_char(l_prl_max_period_number),2,1);
911: END IF;
912: else
913: l_week_53_indicator := ' ';
914: end if;
915:
916: hr_utility.trace('l_week_53_indicator : '||l_week_53_indicator);
917:
918: open csr_get_taxable_pay('Taxable Pay', '_ASG_RUN');
919: fetch csr_get_taxable_pay into l_tax_pay_def_bal_id;
920: close csr_get_taxable_pay;
917:
918: open csr_get_taxable_pay('Taxable Pay', '_ASG_RUN');
919: fetch csr_get_taxable_pay into l_tax_pay_def_bal_id;
920: close csr_get_taxable_pay;
921: hr_utility.trace('l_tax_pay_def_bal_id : '||l_tax_pay_def_bal_id);
922:
923: OPEN csr_asg;
924: FETCH csr_asg INTO l_asg_primary_flag, l_per_ni_agg_flag, l_per_paye_agg_flag, l_assignment_number;
925: CLOSE csr_asg;
922:
923: OPEN csr_asg;
924: FETCH csr_asg INTO l_asg_primary_flag, l_per_ni_agg_flag, l_per_paye_agg_flag, l_assignment_number;
925: CLOSE csr_asg;
926: hr_utility.trace('l_asg_primary_flag : '||l_asg_primary_flag);
927: hr_utility.trace('l_per_ni_agg_flag : '||l_per_ni_agg_flag);
928: hr_utility.trace('l_per_paye_agg_flag : '||l_per_paye_agg_flag);
929: hr_utility.trace('l_assignment_number : '||l_assignment_number);
930:
923: OPEN csr_asg;
924: FETCH csr_asg INTO l_asg_primary_flag, l_per_ni_agg_flag, l_per_paye_agg_flag, l_assignment_number;
925: CLOSE csr_asg;
926: hr_utility.trace('l_asg_primary_flag : '||l_asg_primary_flag);
927: hr_utility.trace('l_per_ni_agg_flag : '||l_per_ni_agg_flag);
928: hr_utility.trace('l_per_paye_agg_flag : '||l_per_paye_agg_flag);
929: hr_utility.trace('l_assignment_number : '||l_assignment_number);
930:
931: OPEN csr_agg_primary_asg;
924: FETCH csr_asg INTO l_asg_primary_flag, l_per_ni_agg_flag, l_per_paye_agg_flag, l_assignment_number;
925: CLOSE csr_asg;
926: hr_utility.trace('l_asg_primary_flag : '||l_asg_primary_flag);
927: hr_utility.trace('l_per_ni_agg_flag : '||l_per_ni_agg_flag);
928: hr_utility.trace('l_per_paye_agg_flag : '||l_per_paye_agg_flag);
929: hr_utility.trace('l_assignment_number : '||l_assignment_number);
930:
931: OPEN csr_agg_primary_asg;
932: FETCH csr_agg_primary_asg INTO l_primary_asg_id;
925: CLOSE csr_asg;
926: hr_utility.trace('l_asg_primary_flag : '||l_asg_primary_flag);
927: hr_utility.trace('l_per_ni_agg_flag : '||l_per_ni_agg_flag);
928: hr_utility.trace('l_per_paye_agg_flag : '||l_per_paye_agg_flag);
929: hr_utility.trace('l_assignment_number : '||l_assignment_number);
930:
931: OPEN csr_agg_primary_asg;
932: FETCH csr_agg_primary_asg INTO l_primary_asg_id;
933: CLOSE csr_agg_primary_asg;
941: END IF;
942:
943: if (l_per_paye_agg_flag <> 'Y' or
944: (l_per_paye_agg_flag = 'Y' and p_asg_id <> l_oldest_asg_id)) then
945: hr_utility.trace('Entered Non-Aggregated Code');
946:
947: p_asg_rec.assignment_id := p_asg_id;
948: p_asg_rec.action_info_category := 'GB RTI P60 ASG DET';
949:
949:
950: open csr_tax_pay_value(p_last_asg_action_id,l_tax_pay_def_bal_id);
951: fetch csr_tax_pay_value into l_tax_pay_val;
952: close csr_tax_pay_value;
953: hr_utility.trace('l_tax_pay_val : '||l_tax_pay_val);
954: -- Test whether we can get run level value with parent action id.
955: -- If not pass the child assignment action id.
956: if l_tax_pay_val = 0 then
957: pay_balance_pkg.get_value(p_assignment_action_id => l_last_chld_act_id,
964: p_context_lst => l_context_lst ,
965: p_output_table => l_output_table );
966: end if;
967:
968: hr_utility.trace('After invoking get_value');
969:
970: hr_utility.trace('Before entering for i in 1..g_fps_bal_det_tab.last loop');
971:
972: hr_utility.trace('l_output_table.count: '||l_output_table.count);
966: end if;
967:
968: hr_utility.trace('After invoking get_value');
969:
970: hr_utility.trace('Before entering for i in 1..g_fps_bal_det_tab.last loop');
971:
972: hr_utility.trace('l_output_table.count: '||l_output_table.count);
973:
974: FOR outer_rec IN 1..l_output_table.count
968: hr_utility.trace('After invoking get_value');
969:
970: hr_utility.trace('Before entering for i in 1..g_fps_bal_det_tab.last loop');
971:
972: hr_utility.trace('l_output_table.count: '||l_output_table.count);
973:
974: FOR outer_rec IN 1..l_output_table.count
975: LOOP
976:
1033:
1034: END IF;
1035: END IF;
1036: END LOOP;
1037: hr_utility.trace('After for i in 1..g_fps_bal_det_tab.last loop');
1038: END IF; --Not null check ends
1039: END LOOP;
1040: IF (l_per_paye_agg_flag = 'Y') THEN
1041: p_asg_rec.act_info20 := 'Y';
1041: p_asg_rec.act_info20 := 'Y';
1042: END IF;
1043: else --if l_per_paye_agg_flag <> 'Y' then
1044:
1045: hr_utility.trace('Entered PAYE Aggregated Code');
1046:
1047: OPEN csr_aggr_last_payroll_action;
1048: FETCH csr_aggr_last_payroll_action
1049: INTO l_aggr_last_asgact_id,
1049: INTO l_aggr_last_asgact_id,
1050: l_aggr_last_eff_date;
1051: CLOSE csr_aggr_last_payroll_action;
1052:
1053: hr_utility.trace('l_aggr_last_asgact_id : '||l_aggr_last_asgact_id);
1054: hr_utility.trace('l_aggr_last_eff_date : '||l_aggr_last_eff_date);
1055:
1056: p_asg_rec.assignment_id := p_asg_id;
1057: p_asg_rec.action_info_category := 'GB RTI P60 ASG DET';
1050: l_aggr_last_eff_date;
1051: CLOSE csr_aggr_last_payroll_action;
1052:
1053: hr_utility.trace('l_aggr_last_asgact_id : '||l_aggr_last_asgact_id);
1054: hr_utility.trace('l_aggr_last_eff_date : '||l_aggr_last_eff_date);
1055:
1056: p_asg_rec.assignment_id := p_asg_id;
1057: p_asg_rec.action_info_category := 'GB RTI P60 ASG DET';
1058:
1063: IF l_aggr_last_chld_act_id is NULL THEN
1064: l_aggr_last_chld_act_id := l_aggr_last_asgact_id;
1065: END IF;
1066:
1067: hr_utility.trace('l_aggr_last_chld_act_id : '||l_aggr_last_chld_act_id);
1068:
1069: p_paye_aggr_asgactid := l_aggr_last_asgact_id;
1070: p_paye_aggr_asgid := p_asg_id;
1071:
1068:
1069: p_paye_aggr_asgactid := l_aggr_last_asgact_id;
1070: p_paye_aggr_asgid := p_asg_id;
1071:
1072: hr_utility.trace('p_paye_aggr_asgactid : '||p_paye_aggr_asgactid);
1073: hr_utility.trace('p_paye_aggr_asgid : '||p_paye_aggr_asgid);
1074:
1075: open csr_tax_pay_value(l_aggr_last_asgact_id,l_tax_pay_def_bal_id);
1076: fetch csr_tax_pay_value into l_tax_pay_val;
1069: p_paye_aggr_asgactid := l_aggr_last_asgact_id;
1070: p_paye_aggr_asgid := p_asg_id;
1071:
1072: hr_utility.trace('p_paye_aggr_asgactid : '||p_paye_aggr_asgactid);
1073: hr_utility.trace('p_paye_aggr_asgid : '||p_paye_aggr_asgid);
1074:
1075: open csr_tax_pay_value(l_aggr_last_asgact_id,l_tax_pay_def_bal_id);
1076: fetch csr_tax_pay_value into l_tax_pay_val;
1077: close csr_tax_pay_value;
1074:
1075: open csr_tax_pay_value(l_aggr_last_asgact_id,l_tax_pay_def_bal_id);
1076: fetch csr_tax_pay_value into l_tax_pay_val;
1077: close csr_tax_pay_value;
1078: hr_utility.trace('l_tax_pay_val : '||l_tax_pay_val);
1079: -- Test whether we can get run level value with parent action id.
1080: -- If not pass the child assignment action id.
1081: if l_tax_pay_val = 0 then
1082: pay_balance_pkg.get_value(p_assignment_action_id => l_aggr_last_chld_act_id,
1089: p_context_lst => l_context_lst ,
1090: p_output_table => l_output_table );
1091: end if;
1092:
1093: hr_utility.trace('After invoking get_value');
1094:
1095: hr_utility.trace('Before entering for i in 1..g_fps_bal_det_tab.last loop');
1096:
1097: hr_utility.trace('l_output_table.count: '||l_output_table.count);
1091: end if;
1092:
1093: hr_utility.trace('After invoking get_value');
1094:
1095: hr_utility.trace('Before entering for i in 1..g_fps_bal_det_tab.last loop');
1096:
1097: hr_utility.trace('l_output_table.count: '||l_output_table.count);
1098:
1099: FOR outer_rec IN 1..l_output_table.count
1093: hr_utility.trace('After invoking get_value');
1094:
1095: hr_utility.trace('Before entering for i in 1..g_fps_bal_det_tab.last loop');
1096:
1097: hr_utility.trace('l_output_table.count: '||l_output_table.count);
1098:
1099: FOR outer_rec IN 1..l_output_table.count
1100: LOOP
1101:
1158:
1159: END IF;
1160: END IF;
1161: END LOOP;
1162: hr_utility.trace('After for i in 1..g_fps_bal_det_tab.last loop');
1163: END IF; --Not null check ends
1164: END LOOP;
1165: p_asg_rec.act_info20 := 'Y';
1166: p_asg_rec.act_info21 := 'Y';
1185: RETURN l_arch;
1186:
1187: EXCEPTION
1188: WHEN OTHERS THEN
1189: hr_utility.set_location('Error in function fetch_p60_asg_det ', 15);
1190: hr_utility.trace('Exception:' || SQLCODE || ' - ' || SQLERRM );
1191: fnd_file.put_line(fnd_file.LOG,'Exception:' || SQLCODE || ' - ' || SQLERRM);
1192: RAISE;
1193: END fetch_p60_asg_det;
1186:
1187: EXCEPTION
1188: WHEN OTHERS THEN
1189: hr_utility.set_location('Error in function fetch_p60_asg_det ', 15);
1190: hr_utility.trace('Exception:' || SQLCODE || ' - ' || SQLERRM );
1191: fnd_file.put_line(fnd_file.LOG,'Exception:' || SQLCODE || ' - ' || SQLERRM);
1192: RAISE;
1193: END fetch_p60_asg_det;
1194: --
1203: l_proc CONSTANT VARCHAR2(50):= g_package||'insert_archive_row';
1204: l_ovn NUMBER;
1205: l_action_id NUMBER;
1206: BEGIN
1207: hr_utility.set_location('Entering: '||l_proc,1);
1208:
1209: IF p_tab_rec_data.count > 0 THEN
1210: FOR i IN p_tab_rec_data.first .. p_tab_rec_data.last
1211: LOOP
1208:
1209: IF p_tab_rec_data.count > 0 THEN
1210: FOR i IN p_tab_rec_data.first .. p_tab_rec_data.last
1211: LOOP
1212: hr_utility.trace
1213: (
1214: 'Defining category '|| p_tab_rec_data(i).action_info_category
1215: )
1216: ;
1213: (
1214: 'Defining category '|| p_tab_rec_data(i).action_info_category
1215: )
1216: ;
1217: hr_utility.trace('action_context_id = '|| p_assactid);
1218: IF p_tab_rec_data(i).action_info_category IS NOT NULL THEN
1219: pay_action_information_api.create_action_information( p_action_information_id => l_action_id,
1220: p_object_version_number => l_ovn,
1221: p_action_information_category => p_tab_rec_data(i).action_info_category,
1255: p_action_information30 => p_tab_rec_data(i).act_info30 );
1256: END IF;
1257: END LOOP;
1258: END IF;
1259: hr_utility.set_location('Leaving: '||l_proc,999);
1260: END insert_archive_row;
1261: --For fetching NI balances
1262: --
1263: PROCEDURE load_defined_balances
2087: and paa.payroll_action_id = ppa.payroll_action_id
2088: and ACTION_TYPE in ('V');
2089:
2090: BEGIN
2091: hr_utility.trace('Entering PAY_GB_RTI_P60.get_ni_balances_for_asg.');
2092: load_defined_balances();
2093: -- fetch NI x Total/Able balances for checking whether this assignment
2094: -- reported in the P35 report or not. -- Bug 6271548
2095: hr_utility.trace('fetching NI x Total/Able balances');
2091: hr_utility.trace('Entering PAY_GB_RTI_P60.get_ni_balances_for_asg.');
2092: load_defined_balances();
2093: -- fetch NI x Total/Able balances for checking whether this assignment
2094: -- reported in the P35 report or not. -- Bug 6271548
2095: hr_utility.trace('fetching NI x Total/Able balances');
2096:
2097: OPEN csr_get_taxable_pay('Taxable Pay', '_ASG_RUN');
2098: FETCH csr_get_taxable_pay INTO l_tax_pay_def_bal_id;
2099: CLOSE csr_get_taxable_pay;
2101: OPEN csr_tax_pay_value(l_last_asg_action_id,l_tax_pay_def_bal_id);
2102: FETCH csr_tax_pay_value INTO l_tax_pay_val;
2103: CLOSE csr_tax_pay_value;
2104:
2105: hr_utility.trace('l_last_asg_action_id: ' || l_last_asg_action_id);
2106: -- Test whether we can get run level value with parent action id.
2107: -- If not pass the child assignment action id.
2108:
2109: hr_utility.trace('l_child_flag := '||l_child_flag);
2105: hr_utility.trace('l_last_asg_action_id: ' || l_last_asg_action_id);
2106: -- Test whether we can get run level value with parent action id.
2107: -- If not pass the child assignment action id.
2108:
2109: hr_utility.trace('l_child_flag := '||l_child_flag);
2110:
2111: IF l_tax_pay_val = 0 THEN
2112: OPEN csr_child_act_id(l_last_asg_action_id);
2113: FETCH csr_child_act_id INTO l_asg_action_id;
2128: close csr_reversal;
2129:
2130: if l_child_flag = 'N' then
2131:
2132: hr_utility.trace('Processing NI with Master Action ID.');
2133: hr_utility.trace('l_asg_action_id: ' || l_asg_action_id);
2134: -- NI A
2135: l_nia_tot := hr_dirbal.get_balance(l_asg_action_id,g_nia_tot_id);
2136: l_nia_able := hr_dirbal.get_balance(l_asg_action_id, g_nia_able_id);
2129:
2130: if l_child_flag = 'N' then
2131:
2132: hr_utility.trace('Processing NI with Master Action ID.');
2133: hr_utility.trace('l_asg_action_id: ' || l_asg_action_id);
2134: -- NI A
2135: l_nia_tot := hr_dirbal.get_balance(l_asg_action_id,g_nia_tot_id);
2136: l_nia_able := hr_dirbal.get_balance(l_asg_action_id, g_nia_able_id);
2137: -- NI B
2179: end if;
2180:
2181:
2182: IF (NVL(l_nia_tot,0) <> 0 OR NVL(l_nia_able,0) <> 0 ) or ( l_reversal is not null and NVL(l_nia_able_run,0) <> 0 OR NVL(l_nia_e_ptd,0) <> 0) THEN
2183: hr_utility.trace('fetching NI A Total/Able balances');
2184: p_ni_a_balance.act_info1 := 'A';
2185: p_ni_a_balance.act_info2 := hr_dirbal.get_balance(l_asg_action_id, g_nia_able_id_run);
2186: p_ni_a_balance.act_info3 := hr_dirbal.get_balance(l_last_asg_action_id, g_nia_lel_id);
2187: p_ni_a_balance.act_info4 := hr_dirbal.get_balance(l_last_asg_action_id, g_nia_et_id);
2193: p_ni_a_balance.act_info10 := hr_dirbal.get_balance(l_asg_action_id, g_nia_e_ptd_id);
2194: l_count_values := l_count_values +1;
2195: END IF;
2196: IF ( NVL(l_nib_tot,0) <> 0 OR NVL(l_nib_able,0) <> 0 ) or ( l_reversal is not null and NVL(l_nib_able_run,0) <> 0 OR NVL(l_nib_e_ptd,0) <> 0) THEN
2197: hr_utility.trace('fetching NI B Total/Able balances');
2198: p_ni_b_balance.act_info1 := 'B';
2199: p_ni_b_balance.act_info2 := hr_dirbal.get_balance(l_asg_action_id, g_nib_able_id_run);
2200: p_ni_b_balance.act_info3 := hr_dirbal.get_balance(l_last_asg_action_id, g_nib_lel_id);
2201: p_ni_b_balance.act_info4 := hr_dirbal.get_balance(l_last_asg_action_id, g_nib_et_id);
2207: p_ni_b_balance.act_info10 := hr_dirbal.get_balance(l_asg_action_id, g_nib_e_ptd_id);
2208: l_count_values := l_count_values +1;
2209: END IF;
2210: IF( NVL(l_nic_tot,0) <> 0 OR NVL(l_nic_able,0) <> 0 ) or ( l_reversal is not null and NVL(l_nic_able_run,0) <> 0 OR NVL(l_nic_e_ptd,0) <> 0) THEN
2211: hr_utility.trace('fetching NI C Total/Able balances');
2212: p_ni_c_balance.act_info1 := 'C';
2213: p_ni_c_balance.act_info2 := hr_dirbal.get_balance(l_asg_action_id, g_nic_able_id_run);
2214: p_ni_c_balance.act_info3 := hr_dirbal.get_balance(l_last_asg_action_id, g_nic_lel_id);
2215: p_ni_c_balance.act_info4 := hr_dirbal.get_balance(l_last_asg_action_id, g_nic_et_id);
2221: p_ni_c_balance.act_info10 := hr_dirbal.get_balance(l_asg_action_id, g_nic_e_ptd_id);
2222: l_count_values := l_count_values +1;
2223: END IF;
2224: IF ( NVL(l_nid_tot,0) <> 0 OR NVL(l_nid_able,0) <> 0 ) or ( l_reversal is not null and NVL(l_nid_able_run,0) <> 0 OR NVL(l_nid_e_ptd,0) <> 0) THEN
2225: hr_utility.trace('fetching NI D Total/Able balances');
2226: hr_utility.trace('l_asg_action_id: ' || l_asg_action_id);
2227: hr_utility.trace('g_nid_r_ytd_id: ' || g_nid_r_ytd_id);
2228: hr_utility.trace('g_nid_e_ytd_id: ' || g_nid_e_ytd_id);
2229: hr_utility.trace('g_nid_r_ptd_id: ' || g_nid_r_ptd_id);
2222: l_count_values := l_count_values +1;
2223: END IF;
2224: IF ( NVL(l_nid_tot,0) <> 0 OR NVL(l_nid_able,0) <> 0 ) or ( l_reversal is not null and NVL(l_nid_able_run,0) <> 0 OR NVL(l_nid_e_ptd,0) <> 0) THEN
2225: hr_utility.trace('fetching NI D Total/Able balances');
2226: hr_utility.trace('l_asg_action_id: ' || l_asg_action_id);
2227: hr_utility.trace('g_nid_r_ytd_id: ' || g_nid_r_ytd_id);
2228: hr_utility.trace('g_nid_e_ytd_id: ' || g_nid_e_ytd_id);
2229: hr_utility.trace('g_nid_r_ptd_id: ' || g_nid_r_ptd_id);
2230: hr_utility.trace('g_nid_e_ptd_id: ' || g_nid_e_ptd_id);
2223: END IF;
2224: IF ( NVL(l_nid_tot,0) <> 0 OR NVL(l_nid_able,0) <> 0 ) or ( l_reversal is not null and NVL(l_nid_able_run,0) <> 0 OR NVL(l_nid_e_ptd,0) <> 0) THEN
2225: hr_utility.trace('fetching NI D Total/Able balances');
2226: hr_utility.trace('l_asg_action_id: ' || l_asg_action_id);
2227: hr_utility.trace('g_nid_r_ytd_id: ' || g_nid_r_ytd_id);
2228: hr_utility.trace('g_nid_e_ytd_id: ' || g_nid_e_ytd_id);
2229: hr_utility.trace('g_nid_r_ptd_id: ' || g_nid_r_ptd_id);
2230: hr_utility.trace('g_nid_e_ptd_id: ' || g_nid_e_ptd_id);
2231: p_ni_d_balance.act_info1 := 'D';
2224: IF ( NVL(l_nid_tot,0) <> 0 OR NVL(l_nid_able,0) <> 0 ) or ( l_reversal is not null and NVL(l_nid_able_run,0) <> 0 OR NVL(l_nid_e_ptd,0) <> 0) THEN
2225: hr_utility.trace('fetching NI D Total/Able balances');
2226: hr_utility.trace('l_asg_action_id: ' || l_asg_action_id);
2227: hr_utility.trace('g_nid_r_ytd_id: ' || g_nid_r_ytd_id);
2228: hr_utility.trace('g_nid_e_ytd_id: ' || g_nid_e_ytd_id);
2229: hr_utility.trace('g_nid_r_ptd_id: ' || g_nid_r_ptd_id);
2230: hr_utility.trace('g_nid_e_ptd_id: ' || g_nid_e_ptd_id);
2231: p_ni_d_balance.act_info1 := 'D';
2232: p_ni_d_balance.act_info2 := hr_dirbal.get_balance(l_asg_action_id, g_nid_able_id_run);
2225: hr_utility.trace('fetching NI D Total/Able balances');
2226: hr_utility.trace('l_asg_action_id: ' || l_asg_action_id);
2227: hr_utility.trace('g_nid_r_ytd_id: ' || g_nid_r_ytd_id);
2228: hr_utility.trace('g_nid_e_ytd_id: ' || g_nid_e_ytd_id);
2229: hr_utility.trace('g_nid_r_ptd_id: ' || g_nid_r_ptd_id);
2230: hr_utility.trace('g_nid_e_ptd_id: ' || g_nid_e_ptd_id);
2231: p_ni_d_balance.act_info1 := 'D';
2232: p_ni_d_balance.act_info2 := hr_dirbal.get_balance(l_asg_action_id, g_nid_able_id_run);
2233: p_ni_d_balance.act_info3 := hr_dirbal.get_balance(l_last_asg_action_id, g_nid_lel_id);
2226: hr_utility.trace('l_asg_action_id: ' || l_asg_action_id);
2227: hr_utility.trace('g_nid_r_ytd_id: ' || g_nid_r_ytd_id);
2228: hr_utility.trace('g_nid_e_ytd_id: ' || g_nid_e_ytd_id);
2229: hr_utility.trace('g_nid_r_ptd_id: ' || g_nid_r_ptd_id);
2230: hr_utility.trace('g_nid_e_ptd_id: ' || g_nid_e_ptd_id);
2231: p_ni_d_balance.act_info1 := 'D';
2232: p_ni_d_balance.act_info2 := hr_dirbal.get_balance(l_asg_action_id, g_nid_able_id_run);
2233: p_ni_d_balance.act_info3 := hr_dirbal.get_balance(l_last_asg_action_id, g_nid_lel_id);
2234: p_ni_d_balance.act_info4 := hr_dirbal.get_balance(l_last_asg_action_id, g_nid_et_id);
2240: p_ni_d_balance.act_info10 := hr_dirbal.get_balance(l_asg_action_id, g_nid_e_ptd_id);
2241: l_count_values := l_count_values +1;
2242: END IF;
2243: IF( NVL(l_nie_tot,0) <> 0 OR NVL(l_nie_able,0) <> 0 ) or ( l_reversal is not null and NVL(l_nie_able_run,0) <> 0 OR NVL(l_nie_e_ptd,0) <> 0) THEN
2244: hr_utility.trace('fetching NI E Total/Able balances');
2245: p_ni_e_balance.act_info1 := 'E';
2246: p_ni_e_balance.act_info2 := hr_dirbal.get_balance(l_asg_action_id, g_nie_able_id_run);
2247: p_ni_e_balance.act_info3 := hr_dirbal.get_balance(l_last_asg_action_id, g_nie_lel_id);
2248: p_ni_e_balance.act_info4 := hr_dirbal.get_balance(l_last_asg_action_id, g_nie_et_id);
2254: p_ni_e_balance.act_info10 := hr_dirbal.get_balance(l_asg_action_id, g_nie_e_ptd_id);
2255: l_count_values := l_count_values +1;
2256: END IF;
2257: IF( NVL(l_nij_tot,0) <> 0 OR NVL(l_nij_able,0) <> 0 ) or ( l_reversal is not null and NVL(l_nij_able_run,0) <> 0 OR NVL(l_nij_e_ptd,0) <> 0) THEN
2258: hr_utility.trace('fetching NI J Total/Able balances');
2259: p_ni_j_balance.act_info1 := 'J';
2260: p_ni_j_balance.act_info2 := hr_dirbal.get_balance(l_asg_action_id, g_nij_able_id_run);
2261: p_ni_j_balance.act_info3 := hr_dirbal.get_balance(l_last_asg_action_id, g_nij_lel_id);
2262: p_ni_j_balance.act_info4 := hr_dirbal.get_balance(l_last_asg_action_id, g_nij_et_id);
2268: p_ni_j_balance.act_info10 := hr_dirbal.get_balance(l_asg_action_id, g_nij_e_ptd_id);
2269: l_count_values := l_count_values +1;
2270: END IF;
2271: IF( NVL(l_nil_tot,0) <> 0 OR NVL(l_nil_able,0) <> 0 ) or ( l_reversal is not null and NVL(l_nil_able_run,0) <> 0 OR NVL(l_nil_e_ptd,0) <> 0) THEN
2272: hr_utility.trace('fetching NI L Total/Able balances');
2273: p_ni_l_balance.act_info1 := 'L';
2274: p_ni_l_balance.act_info2 := hr_dirbal.get_balance(l_asg_action_id, g_nil_able_id_run);
2275: p_ni_l_balance.act_info3 := hr_dirbal.get_balance(l_last_asg_action_id, g_nil_lel_id);
2276: p_ni_l_balance.act_info4 := hr_dirbal.get_balance(l_last_asg_action_id, g_nil_et_id);
2328:
2329: l_asg_action_id := child.ASSIGNMENT_ACTION_ID;
2330: l_count_values :=0;
2331:
2332: hr_utility.trace('Processing NI with Child Action ID.');
2333: hr_utility.trace('l_asg_action_id: ' || l_asg_action_id);
2334:
2335: -- NI A
2336: l_nia_tot := hr_dirbal.get_balance(l_last_asg_action_id,g_nia_tot_id);
2329: l_asg_action_id := child.ASSIGNMENT_ACTION_ID;
2330: l_count_values :=0;
2331:
2332: hr_utility.trace('Processing NI with Child Action ID.');
2333: hr_utility.trace('l_asg_action_id: ' || l_asg_action_id);
2334:
2335: -- NI A
2336: l_nia_tot := hr_dirbal.get_balance(l_last_asg_action_id,g_nia_tot_id);
2337: l_nia_able := hr_dirbal.get_balance(l_last_asg_action_id, g_nia_able_id);
2355: l_nil_able := hr_dirbal.get_balance(l_last_asg_action_id, g_nil_able_id);
2356:
2357:
2358: IF NVL(l_nia_tot,0) <> 0 OR NVL(l_nia_able,0) <> 0 THEN
2359: hr_utility.trace('fetching NI A Total/Able balances');
2360: p_ni_a_balance.act_info1 := 'A';
2361: p_ni_a_balance.act_info2 := hr_dirbal.get_balance(l_asg_action_id, g_nia_able_id_run);
2362: p_ni_a_balance.act_info3 := hr_dirbal.get_balance(l_last_asg_action_id, g_nia_lel_id);
2363: p_ni_a_balance.act_info4 := hr_dirbal.get_balance(l_last_asg_action_id, g_nia_et_id);
2369: p_ni_a_balance.act_info10 := p_ni_a_balance.act_info10 + (hr_dirbal.get_balance(l_asg_action_id, g_nia_e_ptd_id));
2370: l_count_values := l_count_values +1;
2371: END IF;
2372: IF NVL(l_nib_tot,0) <> 0 OR NVL(l_nib_able,0) <> 0 THEN
2373: hr_utility.trace('fetching NI B Total/Able balances');
2374: p_ni_b_balance.act_info1 := 'B';
2375: p_ni_b_balance.act_info2 := hr_dirbal.get_balance(l_asg_action_id, g_nib_able_id_run);
2376: p_ni_b_balance.act_info3 := hr_dirbal.get_balance(l_last_asg_action_id, g_nib_lel_id);
2377: p_ni_b_balance.act_info4 := hr_dirbal.get_balance(l_last_asg_action_id, g_nib_et_id);
2383: p_ni_b_balance.act_info10 := p_ni_b_balance.act_info10 + (hr_dirbal.get_balance(l_asg_action_id, g_nib_e_ptd_id));
2384: l_count_values := l_count_values +1;
2385: END IF;
2386: IF NVL(l_nic_tot,0) <> 0 OR NVL(l_nic_able,0) <> 0 THEN
2387: hr_utility.trace('fetching NI C Total/Able balances');
2388: p_ni_c_balance.act_info1 := 'C';
2389: p_ni_c_balance.act_info2 := hr_dirbal.get_balance(l_asg_action_id, g_nic_able_id_run);
2390: p_ni_c_balance.act_info3 := hr_dirbal.get_balance(l_last_asg_action_id, g_nic_lel_id);
2391: p_ni_c_balance.act_info4 := hr_dirbal.get_balance(l_last_asg_action_id, g_nic_et_id);
2397: p_ni_c_balance.act_info10 := p_ni_c_balance.act_info10 + (hr_dirbal.get_balance(l_asg_action_id, g_nic_e_ptd_id));
2398: l_count_values := l_count_values +1;
2399: END IF;
2400: IF NVL(l_nid_tot,0) <> 0 OR NVL(l_nid_able,0) <> 0 THEN
2401: hr_utility.trace('fetching NI D Total/Able balances');
2402: hr_utility.trace('l_asg_action_id: ' || l_asg_action_id);
2403: hr_utility.trace('g_nid_r_ytd_id: ' || g_nid_r_ytd_id);
2404: hr_utility.trace('g_nid_e_ytd_id: ' || g_nid_e_ytd_id);
2405: hr_utility.trace('g_nid_r_ptd_id: ' || g_nid_r_ptd_id);
2398: l_count_values := l_count_values +1;
2399: END IF;
2400: IF NVL(l_nid_tot,0) <> 0 OR NVL(l_nid_able,0) <> 0 THEN
2401: hr_utility.trace('fetching NI D Total/Able balances');
2402: hr_utility.trace('l_asg_action_id: ' || l_asg_action_id);
2403: hr_utility.trace('g_nid_r_ytd_id: ' || g_nid_r_ytd_id);
2404: hr_utility.trace('g_nid_e_ytd_id: ' || g_nid_e_ytd_id);
2405: hr_utility.trace('g_nid_r_ptd_id: ' || g_nid_r_ptd_id);
2406: hr_utility.trace('g_nid_e_ptd_id: ' || g_nid_e_ptd_id);
2399: END IF;
2400: IF NVL(l_nid_tot,0) <> 0 OR NVL(l_nid_able,0) <> 0 THEN
2401: hr_utility.trace('fetching NI D Total/Able balances');
2402: hr_utility.trace('l_asg_action_id: ' || l_asg_action_id);
2403: hr_utility.trace('g_nid_r_ytd_id: ' || g_nid_r_ytd_id);
2404: hr_utility.trace('g_nid_e_ytd_id: ' || g_nid_e_ytd_id);
2405: hr_utility.trace('g_nid_r_ptd_id: ' || g_nid_r_ptd_id);
2406: hr_utility.trace('g_nid_e_ptd_id: ' || g_nid_e_ptd_id);
2407: p_ni_d_balance.act_info1 := 'D';
2400: IF NVL(l_nid_tot,0) <> 0 OR NVL(l_nid_able,0) <> 0 THEN
2401: hr_utility.trace('fetching NI D Total/Able balances');
2402: hr_utility.trace('l_asg_action_id: ' || l_asg_action_id);
2403: hr_utility.trace('g_nid_r_ytd_id: ' || g_nid_r_ytd_id);
2404: hr_utility.trace('g_nid_e_ytd_id: ' || g_nid_e_ytd_id);
2405: hr_utility.trace('g_nid_r_ptd_id: ' || g_nid_r_ptd_id);
2406: hr_utility.trace('g_nid_e_ptd_id: ' || g_nid_e_ptd_id);
2407: p_ni_d_balance.act_info1 := 'D';
2408: p_ni_d_balance.act_info2 := hr_dirbal.get_balance(l_asg_action_id, g_nid_able_id_run);
2401: hr_utility.trace('fetching NI D Total/Able balances');
2402: hr_utility.trace('l_asg_action_id: ' || l_asg_action_id);
2403: hr_utility.trace('g_nid_r_ytd_id: ' || g_nid_r_ytd_id);
2404: hr_utility.trace('g_nid_e_ytd_id: ' || g_nid_e_ytd_id);
2405: hr_utility.trace('g_nid_r_ptd_id: ' || g_nid_r_ptd_id);
2406: hr_utility.trace('g_nid_e_ptd_id: ' || g_nid_e_ptd_id);
2407: p_ni_d_balance.act_info1 := 'D';
2408: p_ni_d_balance.act_info2 := hr_dirbal.get_balance(l_asg_action_id, g_nid_able_id_run);
2409: p_ni_d_balance.act_info3 := hr_dirbal.get_balance(l_last_asg_action_id, g_nid_lel_id);
2402: hr_utility.trace('l_asg_action_id: ' || l_asg_action_id);
2403: hr_utility.trace('g_nid_r_ytd_id: ' || g_nid_r_ytd_id);
2404: hr_utility.trace('g_nid_e_ytd_id: ' || g_nid_e_ytd_id);
2405: hr_utility.trace('g_nid_r_ptd_id: ' || g_nid_r_ptd_id);
2406: hr_utility.trace('g_nid_e_ptd_id: ' || g_nid_e_ptd_id);
2407: p_ni_d_balance.act_info1 := 'D';
2408: p_ni_d_balance.act_info2 := hr_dirbal.get_balance(l_asg_action_id, g_nid_able_id_run);
2409: p_ni_d_balance.act_info3 := hr_dirbal.get_balance(l_last_asg_action_id, g_nid_lel_id);
2410: p_ni_d_balance.act_info4 := hr_dirbal.get_balance(l_last_asg_action_id, g_nid_et_id);
2413: p_ni_d_balance.act_info7 := hr_dirbal.get_balance(l_last_asg_action_id, g_nid_r_ytd_id);
2414: p_ni_d_balance.act_info8 := hr_dirbal.get_balance(l_last_asg_action_id, g_nid_e_ytd_id);
2415: p_ni_d_balance.act_info9 := p_ni_d_balance.act_info9 + (hr_dirbal.get_balance(l_asg_action_id, g_nid_r_ptd_id));
2416: p_ni_d_balance.act_info10 := p_ni_d_balance.act_info10 + (hr_dirbal.get_balance(l_asg_action_id, g_nid_e_ptd_id));
2417: hr_utility.trace('p_ni_d_balance.act_info7 D'||p_ni_d_balance.act_info7);
2418: hr_utility.trace('p_ni_d_balance.act_info8 D'||p_ni_d_balance.act_info8);
2419: hr_utility.trace('p_ni_d_balance.act_info9 D'||p_ni_d_balance.act_info9);
2420: hr_utility.trace('p_ni_d_balance.act_info10 D'||p_ni_d_balance.act_info10);
2421:
2414: p_ni_d_balance.act_info8 := hr_dirbal.get_balance(l_last_asg_action_id, g_nid_e_ytd_id);
2415: p_ni_d_balance.act_info9 := p_ni_d_balance.act_info9 + (hr_dirbal.get_balance(l_asg_action_id, g_nid_r_ptd_id));
2416: p_ni_d_balance.act_info10 := p_ni_d_balance.act_info10 + (hr_dirbal.get_balance(l_asg_action_id, g_nid_e_ptd_id));
2417: hr_utility.trace('p_ni_d_balance.act_info7 D'||p_ni_d_balance.act_info7);
2418: hr_utility.trace('p_ni_d_balance.act_info8 D'||p_ni_d_balance.act_info8);
2419: hr_utility.trace('p_ni_d_balance.act_info9 D'||p_ni_d_balance.act_info9);
2420: hr_utility.trace('p_ni_d_balance.act_info10 D'||p_ni_d_balance.act_info10);
2421:
2422: l_count_values := l_count_values +1;
2415: p_ni_d_balance.act_info9 := p_ni_d_balance.act_info9 + (hr_dirbal.get_balance(l_asg_action_id, g_nid_r_ptd_id));
2416: p_ni_d_balance.act_info10 := p_ni_d_balance.act_info10 + (hr_dirbal.get_balance(l_asg_action_id, g_nid_e_ptd_id));
2417: hr_utility.trace('p_ni_d_balance.act_info7 D'||p_ni_d_balance.act_info7);
2418: hr_utility.trace('p_ni_d_balance.act_info8 D'||p_ni_d_balance.act_info8);
2419: hr_utility.trace('p_ni_d_balance.act_info9 D'||p_ni_d_balance.act_info9);
2420: hr_utility.trace('p_ni_d_balance.act_info10 D'||p_ni_d_balance.act_info10);
2421:
2422: l_count_values := l_count_values +1;
2423: END IF;
2416: p_ni_d_balance.act_info10 := p_ni_d_balance.act_info10 + (hr_dirbal.get_balance(l_asg_action_id, g_nid_e_ptd_id));
2417: hr_utility.trace('p_ni_d_balance.act_info7 D'||p_ni_d_balance.act_info7);
2418: hr_utility.trace('p_ni_d_balance.act_info8 D'||p_ni_d_balance.act_info8);
2419: hr_utility.trace('p_ni_d_balance.act_info9 D'||p_ni_d_balance.act_info9);
2420: hr_utility.trace('p_ni_d_balance.act_info10 D'||p_ni_d_balance.act_info10);
2421:
2422: l_count_values := l_count_values +1;
2423: END IF;
2424: IF NVL(l_nie_tot,0) <> 0 OR NVL(l_nie_able,0) <> 0 THEN
2421:
2422: l_count_values := l_count_values +1;
2423: END IF;
2424: IF NVL(l_nie_tot,0) <> 0 OR NVL(l_nie_able,0) <> 0 THEN
2425: hr_utility.trace('fetching NI E Total/Able balances');
2426: p_ni_e_balance.act_info1 := 'E';
2427: p_ni_e_balance.act_info2 := hr_dirbal.get_balance(l_asg_action_id, g_nie_able_id_run);
2428: p_ni_e_balance.act_info3 := hr_dirbal.get_balance(l_last_asg_action_id, g_nie_lel_id);
2429: p_ni_e_balance.act_info4 := hr_dirbal.get_balance(l_last_asg_action_id, g_nie_et_id);
2435: p_ni_e_balance.act_info10 := p_ni_e_balance.act_info10 + (hr_dirbal.get_balance(l_asg_action_id, g_nie_e_ptd_id));
2436: l_count_values := l_count_values +1;
2437: END IF;
2438: IF NVL(l_nij_tot,0) <> 0 OR NVL(l_nij_able,0) <> 0 THEN
2439: hr_utility.trace('fetching NI J Total/Able balances');
2440: p_ni_j_balance.act_info1 := 'J';
2441: p_ni_j_balance.act_info2 := hr_dirbal.get_balance(l_asg_action_id, g_nij_able_id_run);
2442: p_ni_j_balance.act_info3 := hr_dirbal.get_balance(l_last_asg_action_id, g_nij_lel_id);
2443: p_ni_j_balance.act_info4 := hr_dirbal.get_balance(l_last_asg_action_id, g_nij_et_id);
2449: p_ni_j_balance.act_info10 := p_ni_j_balance.act_info10 + (hr_dirbal.get_balance(l_asg_action_id, g_nij_e_ptd_id));
2450: l_count_values := l_count_values +1;
2451: END IF;
2452: IF NVL(l_nil_tot,0) <> 0 OR NVL(l_nil_able,0) <> 0 THEN
2453: hr_utility.trace('fetching NI L Total/Able balances');
2454: p_ni_l_balance.act_info1 := 'L';
2455: p_ni_l_balance.act_info2 := hr_dirbal.get_balance(l_asg_action_id, g_nil_able_id_run);
2456: p_ni_l_balance.act_info3 := hr_dirbal.get_balance(l_last_asg_action_id, g_nil_lel_id);
2457: p_ni_l_balance.act_info4 := hr_dirbal.get_balance(l_last_asg_action_id, g_nil_et_id);
2465: END IF;
2466: end loop; -- Child Loop Ends
2467: END IF; -- If Ends for Child flag
2468:
2469: hr_utility.trace('Number of categories: ' || l_count_values);
2470:
2471:
2472: END get_ni_balances_for_asg;
2473:
2546: and paa.payroll_action_id = ppa.payroll_action_id
2547: and ACTION_TYPE in ('V');
2548:
2549: BEGIN
2550: hr_utility.trace('Entering get_paye_aggr_ni_balances');
2551: load_defined_balances_aggr();
2552: -- fetch NI x Total/Able balances for checking whether this assignment
2553: -- reported in the P35 report or not. -- Bug 6271548
2554: hr_utility.trace('fetching NI x Total/Able balances');
2550: hr_utility.trace('Entering get_paye_aggr_ni_balances');
2551: load_defined_balances_aggr();
2552: -- fetch NI x Total/Able balances for checking whether this assignment
2553: -- reported in the P35 report or not. -- Bug 6271548
2554: hr_utility.trace('fetching NI x Total/Able balances');
2555: OPEN csr_get_taxable_pay('Taxable Pay', '_ASG_RUN');
2556: FETCH csr_get_taxable_pay INTO l_tax_pay_def_bal_id;
2557: CLOSE csr_get_taxable_pay;
2558: OPEN csr_tax_pay_value(l_last_asg_action_id,l_tax_pay_def_bal_id);
2557: CLOSE csr_get_taxable_pay;
2558: OPEN csr_tax_pay_value(l_last_asg_action_id,l_tax_pay_def_bal_id);
2559: FETCH csr_tax_pay_value INTO l_tax_pay_val;
2560: CLOSE csr_tax_pay_value;
2561: hr_utility.trace('l_last_asg_action_id: ' || l_last_asg_action_id);
2562: -- Test whether we can get run level value with parent action id.
2563: -- If not pass the child assignment action id.
2564: IF l_tax_pay_val = 0 THEN
2565: OPEN csr_child_act_id(l_last_asg_action_id);
2567: CLOSE csr_child_act_id;
2568: ELSE
2569: l_asg_action_id := l_last_asg_action_id;
2570: END IF;
2571: hr_utility.trace('l_asg_action_id: ' || l_asg_action_id);
2572: if l_asg_action_id is null then
2573: l_asg_action_id := l_last_asg_action_id;
2574: end if;
2575:
2625: end if;
2626:
2627:
2628: IF (NVL(l_nia_tot,0) <> 0 OR NVL(l_nia_able,0) <> 0 ) or ( l_reversal is not null and NVL(l_nia_able_run,0) <> 0 OR NVL(l_nia_e_ptd,0) <> 0) THEN
2629: hr_utility.trace('fetching NI A Total/Able balances');
2630: p_ni_a_balance.assignment_id := p_asg_id;
2631: p_ni_a_balance.act_info1 := 'A';
2632: p_ni_a_balance.act_info2 := hr_dirbal.get_balance(l_asg_action_id, g_nia_able_id_run);
2633: p_ni_a_balance.act_info3 := hr_dirbal.get_balance(l_last_asg_action_id, g_nia_lel_id);
2640: p_ni_a_balance.act_info10 := hr_dirbal.get_balance(l_asg_action_id, g_nia_e_ptd_id);
2641: l_count_values := l_count_values +1;
2642: END IF;
2643: IF ( NVL(l_nib_tot,0) <> 0 OR NVL(l_nib_able,0) <> 0 ) or ( l_reversal is not null and NVL(l_nib_able_run,0) <> 0 OR NVL(l_nib_e_ptd,0) <> 0) THEN
2644: hr_utility.trace('fetching NI B Total/Able balances');
2645: p_ni_b_balance.assignment_id := p_asg_id;
2646: p_ni_b_balance.act_info1 := 'B';
2647: p_ni_b_balance.act_info2 := hr_dirbal.get_balance(l_asg_action_id, g_nib_able_id_run);
2648: p_ni_b_balance.act_info3 := hr_dirbal.get_balance(l_last_asg_action_id, g_nib_lel_id);
2655: p_ni_b_balance.act_info10 := hr_dirbal.get_balance(l_asg_action_id, g_nib_e_ptd_id);
2656: l_count_values := l_count_values +1;
2657: END IF;
2658: IF( NVL(l_nic_tot,0) <> 0 OR NVL(l_nic_able,0) <> 0 ) or ( l_reversal is not null and NVL(l_nic_able_run,0) <> 0 OR NVL(l_nic_e_ptd,0) <> 0) THEN
2659: hr_utility.trace('fetching NI C Total/Able balances');
2660: p_ni_c_balance.assignment_id := p_asg_id;
2661: p_ni_c_balance.act_info1 := 'C';
2662: p_ni_c_balance.act_info2 := hr_dirbal.get_balance(l_asg_action_id, g_nic_able_id_run);
2663: p_ni_c_balance.act_info3 := hr_dirbal.get_balance(l_last_asg_action_id, g_nic_lel_id);
2670: p_ni_c_balance.act_info10 := hr_dirbal.get_balance(l_asg_action_id, g_nic_e_ptd_id);
2671: l_count_values := l_count_values +1;
2672: END IF;
2673: IF ( NVL(l_nid_tot,0) <> 0 OR NVL(l_nid_able,0) <> 0 ) or ( l_reversal is not null and NVL(l_nid_able_run,0) <> 0 OR NVL(l_nid_e_ptd,0) <> 0) THEN
2674: hr_utility.trace('fetching NI D Total/Able balances');
2675: hr_utility.trace('l_asg_action_id: ' || l_asg_action_id);
2676: hr_utility.trace('g_nid_r_ytd_id: ' || g_nid_r_ytd_id);
2677: hr_utility.trace('g_nid_e_ytd_id: ' || g_nid_e_ytd_id);
2678: hr_utility.trace('g_nid_r_ptd_id: ' || g_nid_r_ptd_id);
2671: l_count_values := l_count_values +1;
2672: END IF;
2673: IF ( NVL(l_nid_tot,0) <> 0 OR NVL(l_nid_able,0) <> 0 ) or ( l_reversal is not null and NVL(l_nid_able_run,0) <> 0 OR NVL(l_nid_e_ptd,0) <> 0) THEN
2674: hr_utility.trace('fetching NI D Total/Able balances');
2675: hr_utility.trace('l_asg_action_id: ' || l_asg_action_id);
2676: hr_utility.trace('g_nid_r_ytd_id: ' || g_nid_r_ytd_id);
2677: hr_utility.trace('g_nid_e_ytd_id: ' || g_nid_e_ytd_id);
2678: hr_utility.trace('g_nid_r_ptd_id: ' || g_nid_r_ptd_id);
2679: hr_utility.trace('g_nid_e_ptd_id: ' || g_nid_e_ptd_id);
2672: END IF;
2673: IF ( NVL(l_nid_tot,0) <> 0 OR NVL(l_nid_able,0) <> 0 ) or ( l_reversal is not null and NVL(l_nid_able_run,0) <> 0 OR NVL(l_nid_e_ptd,0) <> 0) THEN
2674: hr_utility.trace('fetching NI D Total/Able balances');
2675: hr_utility.trace('l_asg_action_id: ' || l_asg_action_id);
2676: hr_utility.trace('g_nid_r_ytd_id: ' || g_nid_r_ytd_id);
2677: hr_utility.trace('g_nid_e_ytd_id: ' || g_nid_e_ytd_id);
2678: hr_utility.trace('g_nid_r_ptd_id: ' || g_nid_r_ptd_id);
2679: hr_utility.trace('g_nid_e_ptd_id: ' || g_nid_e_ptd_id);
2680: p_ni_d_balance.assignment_id := p_asg_id;
2673: IF ( NVL(l_nid_tot,0) <> 0 OR NVL(l_nid_able,0) <> 0 ) or ( l_reversal is not null and NVL(l_nid_able_run,0) <> 0 OR NVL(l_nid_e_ptd,0) <> 0) THEN
2674: hr_utility.trace('fetching NI D Total/Able balances');
2675: hr_utility.trace('l_asg_action_id: ' || l_asg_action_id);
2676: hr_utility.trace('g_nid_r_ytd_id: ' || g_nid_r_ytd_id);
2677: hr_utility.trace('g_nid_e_ytd_id: ' || g_nid_e_ytd_id);
2678: hr_utility.trace('g_nid_r_ptd_id: ' || g_nid_r_ptd_id);
2679: hr_utility.trace('g_nid_e_ptd_id: ' || g_nid_e_ptd_id);
2680: p_ni_d_balance.assignment_id := p_asg_id;
2681: p_ni_d_balance.act_info1 := 'D';
2674: hr_utility.trace('fetching NI D Total/Able balances');
2675: hr_utility.trace('l_asg_action_id: ' || l_asg_action_id);
2676: hr_utility.trace('g_nid_r_ytd_id: ' || g_nid_r_ytd_id);
2677: hr_utility.trace('g_nid_e_ytd_id: ' || g_nid_e_ytd_id);
2678: hr_utility.trace('g_nid_r_ptd_id: ' || g_nid_r_ptd_id);
2679: hr_utility.trace('g_nid_e_ptd_id: ' || g_nid_e_ptd_id);
2680: p_ni_d_balance.assignment_id := p_asg_id;
2681: p_ni_d_balance.act_info1 := 'D';
2682: p_ni_d_balance.act_info2 := hr_dirbal.get_balance(l_asg_action_id, g_nid_able_id_run);
2675: hr_utility.trace('l_asg_action_id: ' || l_asg_action_id);
2676: hr_utility.trace('g_nid_r_ytd_id: ' || g_nid_r_ytd_id);
2677: hr_utility.trace('g_nid_e_ytd_id: ' || g_nid_e_ytd_id);
2678: hr_utility.trace('g_nid_r_ptd_id: ' || g_nid_r_ptd_id);
2679: hr_utility.trace('g_nid_e_ptd_id: ' || g_nid_e_ptd_id);
2680: p_ni_d_balance.assignment_id := p_asg_id;
2681: p_ni_d_balance.act_info1 := 'D';
2682: p_ni_d_balance.act_info2 := hr_dirbal.get_balance(l_asg_action_id, g_nid_able_id_run);
2683: p_ni_d_balance.act_info3 := hr_dirbal.get_balance(l_last_asg_action_id, g_nid_lel_id);
2690: p_ni_d_balance.act_info10 := hr_dirbal.get_balance(l_asg_action_id, g_nid_e_ptd_id);
2691: l_count_values := l_count_values +1;
2692: END IF;
2693: IF( NVL(l_nie_tot,0) <> 0 OR NVL(l_nie_able,0) <> 0 ) or ( l_reversal is not null and NVL(l_nie_able_run,0) <> 0 OR NVL(l_nie_e_ptd,0) <> 0) THEN
2694: hr_utility.trace('fetching NI E Total/Able balances');
2695: p_ni_e_balance.assignment_id := p_asg_id;
2696: p_ni_e_balance.act_info1 := 'E';
2697: p_ni_e_balance.act_info2 := hr_dirbal.get_balance(l_asg_action_id, g_nie_able_id_run);
2698: p_ni_e_balance.act_info3 := hr_dirbal.get_balance(l_last_asg_action_id, g_nie_lel_id);
2705: p_ni_e_balance.act_info10 := hr_dirbal.get_balance(l_asg_action_id, g_nie_e_ptd_id);
2706: l_count_values := l_count_values +1;
2707: END IF;
2708: IF( NVL(l_nij_tot,0) <> 0 OR NVL(l_nij_able,0) <> 0 ) or ( l_reversal is not null and NVL(l_nij_able_run,0) <> 0 OR NVL(l_nij_e_ptd,0) <> 0) THEN
2709: hr_utility.trace('fetching NI J Total/Able balances');
2710: p_ni_j_balance.assignment_id := p_asg_id;
2711: p_ni_j_balance.act_info1 := 'J';
2712: p_ni_j_balance.act_info2 := hr_dirbal.get_balance(l_asg_action_id, g_nij_able_id_run);
2713: p_ni_j_balance.act_info3 := hr_dirbal.get_balance(l_last_asg_action_id, g_nij_lel_id);
2720: p_ni_j_balance.act_info10 := hr_dirbal.get_balance(l_asg_action_id, g_nij_e_ptd_id);
2721: l_count_values := l_count_values +1;
2722: END IF;
2723: IF( NVL(l_nil_tot,0) <> 0 OR NVL(l_nil_able,0) <> 0 ) or ( l_reversal is not null and NVL(l_nil_able_run,0) <> 0 OR NVL(l_nil_e_ptd,0) <> 0) THEN
2724: hr_utility.trace('fetching NI L Total/Able balances');
2725: p_ni_l_balance.assignment_id := p_asg_id;
2726: p_ni_l_balance.act_info1 := 'L';
2727: p_ni_l_balance.act_info2 := hr_dirbal.get_balance(l_asg_action_id, g_nil_able_id_run);
2728: p_ni_l_balance.act_info3 := hr_dirbal.get_balance(l_last_asg_action_id, g_nil_lel_id);
2735: p_ni_l_balance.act_info10 := hr_dirbal.get_balance(l_asg_action_id, g_nil_e_ptd_id);
2736: l_count_values := l_count_values +1;
2737: END IF;
2738:
2739: hr_utility.trace('Number of categories: ' || l_count_values);
2740: END get_paye_aggr_ni_balances;
2741: --
2742: PROCEDURE get_ni_aggr_ni_balances(
2743: l_last_asg_action_id IN NUMBER,
2813: and paa.payroll_action_id = ppa.payroll_action_id
2814: and ACTION_TYPE in ('V');
2815:
2816: BEGIN
2817: hr_utility.trace('Entering get_ni_aggr_ni_balances');
2818: load_defined_balances_aggr();
2819: -- fetch NI x Total/Able balances for checking whether this assignment
2820: -- reported in the P35 report or not. -- Bug 6271548
2821: hr_utility.trace('fetching NI x Total/Able balances');
2817: hr_utility.trace('Entering get_ni_aggr_ni_balances');
2818: load_defined_balances_aggr();
2819: -- fetch NI x Total/Able balances for checking whether this assignment
2820: -- reported in the P35 report or not. -- Bug 6271548
2821: hr_utility.trace('fetching NI x Total/Able balances');
2822: OPEN csr_get_taxable_pay('Taxable Pay', '_ASG_RUN');
2823: FETCH csr_get_taxable_pay INTO l_tax_pay_def_bal_id;
2824: CLOSE csr_get_taxable_pay;
2825: OPEN csr_tax_pay_value(l_last_asg_action_id,l_tax_pay_def_bal_id);
2824: CLOSE csr_get_taxable_pay;
2825: OPEN csr_tax_pay_value(l_last_asg_action_id,l_tax_pay_def_bal_id);
2826: FETCH csr_tax_pay_value INTO l_tax_pay_val;
2827: CLOSE csr_tax_pay_value;
2828: hr_utility.trace('l_last_asg_action_id: ' || l_last_asg_action_id);
2829: -- Test whether we can get run level value with parent action id.
2830: -- If not pass the child assignment action id.
2831: IF l_tax_pay_val = 0 THEN
2832: OPEN csr_child_act_id(l_last_asg_action_id);
2834: CLOSE csr_child_act_id;
2835: ELSE
2836: l_asg_action_id := l_last_asg_action_id;
2837: END IF;
2838: hr_utility.trace('l_asg_action_id: ' || l_asg_action_id);
2839: if l_asg_action_id is null then
2840: l_asg_action_id := l_last_asg_action_id;
2841: end if;
2842:
2891:
2892: end if;
2893:
2894: IF (NVL(l_nia_tot,0) <> 0 OR NVL(l_nia_able,0) <> 0 ) or ( l_reversal is not null and NVL(l_nia_able_run,0) <> 0 OR NVL(l_nia_e_ptd,0) <> 0) THEN
2895: hr_utility.trace('fetching NI A Total/Able balances');
2896: p_ni_a_balance.act_info1 := 'A';
2897: p_ni_a_balance.act_info2 := hr_dirbal.get_balance(l_asg_action_id, g_nia_able_id_run);
2898: p_ni_a_balance.act_info3 := hr_dirbal.get_balance(l_last_asg_action_id, g_nia_lel_id);
2899: p_ni_a_balance.act_info4 := hr_dirbal.get_balance(l_last_asg_action_id, g_nia_et_id);
2905: p_ni_a_balance.act_info10 := hr_dirbal.get_balance(l_asg_action_id, g_nia_e_ptd_id);
2906: l_count_values := l_count_values +1;
2907: END IF;
2908: IF ( NVL(l_nib_tot,0) <> 0 OR NVL(l_nib_able,0) <> 0 ) or ( l_reversal is not null and NVL(l_nib_able_run,0) <> 0 OR NVL(l_nib_e_ptd,0) <> 0) THEN
2909: hr_utility.trace('fetching NI B Total/Able balances');
2910: p_ni_b_balance.act_info1 := 'B';
2911: p_ni_b_balance.act_info2 := hr_dirbal.get_balance(l_asg_action_id, g_nib_able_id_run);
2912: p_ni_b_balance.act_info3 := hr_dirbal.get_balance(l_last_asg_action_id, g_nib_lel_id);
2913: p_ni_b_balance.act_info4 := hr_dirbal.get_balance(l_last_asg_action_id, g_nib_et_id);
2919: p_ni_b_balance.act_info10 := hr_dirbal.get_balance(l_asg_action_id, g_nib_e_ptd_id);
2920: l_count_values := l_count_values +1;
2921: END IF;
2922: IF( NVL(l_nic_tot,0) <> 0 OR NVL(l_nic_able,0) <> 0 ) or ( l_reversal is not null and NVL(l_nic_able_run,0) <> 0 OR NVL(l_nic_e_ptd,0) <> 0) THEN
2923: hr_utility.trace('fetching NI C Total/Able balances');
2924: p_ni_c_balance.act_info1 := 'C';
2925: p_ni_c_balance.act_info2 := hr_dirbal.get_balance(l_asg_action_id, g_nic_able_id_run);
2926: p_ni_c_balance.act_info3 := hr_dirbal.get_balance(l_last_asg_action_id, g_nic_lel_id);
2927: p_ni_c_balance.act_info4 := hr_dirbal.get_balance(l_last_asg_action_id, g_nic_et_id);
2933: p_ni_c_balance.act_info10 := hr_dirbal.get_balance(l_asg_action_id, g_nic_e_ptd_id);
2934: l_count_values := l_count_values +1;
2935: END IF;
2936: IF ( NVL(l_nid_tot,0) <> 0 OR NVL(l_nid_able,0) <> 0 ) or ( l_reversal is not null and NVL(l_nid_able_run,0) <> 0 OR NVL(l_nid_e_ptd,0) <> 0) THEN
2937: hr_utility.trace('fetching NI D Total/Able balances');
2938: hr_utility.trace('l_asg_action_id: ' || l_asg_action_id);
2939: hr_utility.trace('g_nid_r_ytd_id: ' || g_nid_r_ytd_id);
2940: hr_utility.trace('g_nid_e_ytd_id: ' || g_nid_e_ytd_id);
2941: hr_utility.trace('g_nid_r_ptd_id: ' || g_nid_r_ptd_id);
2934: l_count_values := l_count_values +1;
2935: END IF;
2936: IF ( NVL(l_nid_tot,0) <> 0 OR NVL(l_nid_able,0) <> 0 ) or ( l_reversal is not null and NVL(l_nid_able_run,0) <> 0 OR NVL(l_nid_e_ptd,0) <> 0) THEN
2937: hr_utility.trace('fetching NI D Total/Able balances');
2938: hr_utility.trace('l_asg_action_id: ' || l_asg_action_id);
2939: hr_utility.trace('g_nid_r_ytd_id: ' || g_nid_r_ytd_id);
2940: hr_utility.trace('g_nid_e_ytd_id: ' || g_nid_e_ytd_id);
2941: hr_utility.trace('g_nid_r_ptd_id: ' || g_nid_r_ptd_id);
2942: hr_utility.trace('g_nid_e_ptd_id: ' || g_nid_e_ptd_id);
2935: END IF;
2936: IF ( NVL(l_nid_tot,0) <> 0 OR NVL(l_nid_able,0) <> 0 ) or ( l_reversal is not null and NVL(l_nid_able_run,0) <> 0 OR NVL(l_nid_e_ptd,0) <> 0) THEN
2937: hr_utility.trace('fetching NI D Total/Able balances');
2938: hr_utility.trace('l_asg_action_id: ' || l_asg_action_id);
2939: hr_utility.trace('g_nid_r_ytd_id: ' || g_nid_r_ytd_id);
2940: hr_utility.trace('g_nid_e_ytd_id: ' || g_nid_e_ytd_id);
2941: hr_utility.trace('g_nid_r_ptd_id: ' || g_nid_r_ptd_id);
2942: hr_utility.trace('g_nid_e_ptd_id: ' || g_nid_e_ptd_id);
2943: p_ni_d_balance.act_info1 := 'D';
2936: IF ( NVL(l_nid_tot,0) <> 0 OR NVL(l_nid_able,0) <> 0 ) or ( l_reversal is not null and NVL(l_nid_able_run,0) <> 0 OR NVL(l_nid_e_ptd,0) <> 0) THEN
2937: hr_utility.trace('fetching NI D Total/Able balances');
2938: hr_utility.trace('l_asg_action_id: ' || l_asg_action_id);
2939: hr_utility.trace('g_nid_r_ytd_id: ' || g_nid_r_ytd_id);
2940: hr_utility.trace('g_nid_e_ytd_id: ' || g_nid_e_ytd_id);
2941: hr_utility.trace('g_nid_r_ptd_id: ' || g_nid_r_ptd_id);
2942: hr_utility.trace('g_nid_e_ptd_id: ' || g_nid_e_ptd_id);
2943: p_ni_d_balance.act_info1 := 'D';
2944: p_ni_d_balance.act_info2 := hr_dirbal.get_balance(l_asg_action_id, g_nid_able_id_run);
2937: hr_utility.trace('fetching NI D Total/Able balances');
2938: hr_utility.trace('l_asg_action_id: ' || l_asg_action_id);
2939: hr_utility.trace('g_nid_r_ytd_id: ' || g_nid_r_ytd_id);
2940: hr_utility.trace('g_nid_e_ytd_id: ' || g_nid_e_ytd_id);
2941: hr_utility.trace('g_nid_r_ptd_id: ' || g_nid_r_ptd_id);
2942: hr_utility.trace('g_nid_e_ptd_id: ' || g_nid_e_ptd_id);
2943: p_ni_d_balance.act_info1 := 'D';
2944: p_ni_d_balance.act_info2 := hr_dirbal.get_balance(l_asg_action_id, g_nid_able_id_run);
2945: p_ni_d_balance.act_info3 := hr_dirbal.get_balance(l_last_asg_action_id, g_nid_lel_id);
2938: hr_utility.trace('l_asg_action_id: ' || l_asg_action_id);
2939: hr_utility.trace('g_nid_r_ytd_id: ' || g_nid_r_ytd_id);
2940: hr_utility.trace('g_nid_e_ytd_id: ' || g_nid_e_ytd_id);
2941: hr_utility.trace('g_nid_r_ptd_id: ' || g_nid_r_ptd_id);
2942: hr_utility.trace('g_nid_e_ptd_id: ' || g_nid_e_ptd_id);
2943: p_ni_d_balance.act_info1 := 'D';
2944: p_ni_d_balance.act_info2 := hr_dirbal.get_balance(l_asg_action_id, g_nid_able_id_run);
2945: p_ni_d_balance.act_info3 := hr_dirbal.get_balance(l_last_asg_action_id, g_nid_lel_id);
2946: p_ni_d_balance.act_info4 := hr_dirbal.get_balance(l_last_asg_action_id, g_nid_et_id);
2952: p_ni_d_balance.act_info10 := hr_dirbal.get_balance(l_asg_action_id, g_nid_e_ptd_id);
2953: l_count_values := l_count_values +1;
2954: END IF;
2955: IF( NVL(l_nie_tot,0) <> 0 OR NVL(l_nie_able,0) <> 0 ) or ( l_reversal is not null and NVL(l_nie_able_run,0) <> 0 OR NVL(l_nie_e_ptd,0) <> 0) THEN
2956: hr_utility.trace('fetching NI E Total/Able balances');
2957: p_ni_e_balance.act_info1 := 'E';
2958: p_ni_e_balance.act_info2 := hr_dirbal.get_balance(l_asg_action_id, g_nie_able_id_run);
2959: p_ni_e_balance.act_info3 := hr_dirbal.get_balance(l_last_asg_action_id, g_nie_lel_id);
2960: p_ni_e_balance.act_info4 := hr_dirbal.get_balance(l_last_asg_action_id, g_nie_et_id);
2966: p_ni_e_balance.act_info10 := hr_dirbal.get_balance(l_asg_action_id, g_nie_e_ptd_id);
2967: l_count_values := l_count_values +1;
2968: END IF;
2969: IF( NVL(l_nij_tot,0) <> 0 OR NVL(l_nij_able,0) <> 0 ) or ( l_reversal is not null and NVL(l_nij_able_run,0) <> 0 OR NVL(l_nij_e_ptd,0) <> 0) THEN
2970: hr_utility.trace('fetching NI J Total/Able balances');
2971: p_ni_j_balance.act_info1 := 'J';
2972: p_ni_j_balance.act_info2 := hr_dirbal.get_balance(l_asg_action_id, g_nij_able_id_run);
2973: p_ni_j_balance.act_info3 := hr_dirbal.get_balance(l_last_asg_action_id, g_nij_lel_id);
2974: p_ni_j_balance.act_info4 := hr_dirbal.get_balance(l_last_asg_action_id, g_nij_et_id);
2980: p_ni_j_balance.act_info10 := hr_dirbal.get_balance(l_asg_action_id, g_nij_e_ptd_id);
2981: l_count_values := l_count_values +1;
2982: END IF;
2983: IF( NVL(l_nil_tot,0) <> 0 OR NVL(l_nil_able,0) <> 0 ) or ( l_reversal is not null and NVL(l_nil_able_run,0) <> 0 OR NVL(l_nil_e_ptd,0) <> 0) THEN
2984: hr_utility.trace('fetching NI L Total/Able balances');
2985: p_ni_l_balance.act_info1 := 'L';
2986: p_ni_l_balance.act_info2 := hr_dirbal.get_balance(l_asg_action_id, g_nil_able_id_run);
2987: p_ni_l_balance.act_info3 := hr_dirbal.get_balance(l_last_asg_action_id, g_nil_lel_id);
2988: p_ni_l_balance.act_info4 := hr_dirbal.get_balance(l_last_asg_action_id, g_nil_et_id);
2993: p_ni_l_balance.act_info9 := hr_dirbal.get_balance(l_asg_action_id, g_nil_r_ptd_id);
2994: p_ni_l_balance.act_info10 := hr_dirbal.get_balance(l_asg_action_id, g_nil_e_ptd_id);
2995: l_count_values := l_count_values +1;
2996: END IF;
2997: hr_utility.trace('Number of categories: ' || l_count_values);
2998: END get_ni_aggr_ni_balances;
2999:
3000:
3001: --
3133: AND legislation_code = 'GB'
3134: AND business_group_id IS NULL;
3135:
3136: BEGIN
3137: hr_utility.set_location('Entering: '||l_proc,1);
3138: --
3139: -- Find payroll action parameters
3140: /*
3141: OPEN csr_parameter_info(pactid);
3167: EXCEPTION
3168: WHEN value_error THEN
3169: RAISE tax_dist_ref_error;
3170: END;
3171: hr_utility.set_location(l_proc,10);
3172: --
3173: l_payroll_name := NULL;
3174: -- Extract Payroll info
3175:
3172: --
3173: l_payroll_name := NULL;
3174: -- Extract Payroll info
3175:
3176: hr_utility.set_location(l_proc,30);
3177: -- sqlstr must contain one and only one entry of :payroll_action_id
3178: -- it must be ordered by person_id
3179: --
3180: sqlstr := 'SELECT DISTINCT person_id
3183: WHERE ppa.payroll_action_id = :payroll_action_id
3184: AND ppa.business_group_id +0= ppf.business_group_id
3185: --and rownum < 50
3186: ORDER BY ppf.person_id';
3187: hr_utility.set_location('Leaving: '||l_proc,40);
3188: EXCEPTION
3189: WHEN OTHERS THEN
3190: hr_utility.set_location(' Leaving: '||l_proc,50);
3191: fnd_file.put_line(fnd_file.log,
3186: ORDER BY ppf.person_id';
3187: hr_utility.set_location('Leaving: '||l_proc,40);
3188: EXCEPTION
3189: WHEN OTHERS THEN
3190: hr_utility.set_location(' Leaving: '||l_proc,50);
3191: fnd_file.put_line(fnd_file.log,
3192: substr('Error in rangecode '||sqlerrm(sqlcode),1,80));
3193: -- Return cursor that selects no rows
3194: sqlstr := 'select 1 from dual where to_char(:payroll_action_id) = dummy';
3409: l_aspp_adopt number;
3410: l_aspp_birth number;
3411:
3412: BEGIN
3413: hr_utility.set_location('Entering: '||l_proc,1);
3414:
3415: OPEN csr_parameter_info;
3416: FETCH csr_parameter_info
3417: INTO l_tax_ref,
3419: l_business_group_id,
3420: l_asg_set_id;
3421: CLOSE csr_parameter_info;
3422:
3423: hr_utility.set_location('process start date'||l_start_date,20);
3424: hr_utility.set_location('process end date'||l_end_date,20);
3425: hr_utility.set_location('pactid: '||pactid,20);
3426: hr_utility.set_location('stperson: '||stperson,20);
3427: hr_utility.set_location('endperson: '||endperson,20);
3420: l_asg_set_id;
3421: CLOSE csr_parameter_info;
3422:
3423: hr_utility.set_location('process start date'||l_start_date,20);
3424: hr_utility.set_location('process end date'||l_end_date,20);
3425: hr_utility.set_location('pactid: '||pactid,20);
3426: hr_utility.set_location('stperson: '||stperson,20);
3427: hr_utility.set_location('endperson: '||endperson,20);
3428: hr_utility.set_location('l_payroll_id: '||l_payroll_id,20);
3421: CLOSE csr_parameter_info;
3422:
3423: hr_utility.set_location('process start date'||l_start_date,20);
3424: hr_utility.set_location('process end date'||l_end_date,20);
3425: hr_utility.set_location('pactid: '||pactid,20);
3426: hr_utility.set_location('stperson: '||stperson,20);
3427: hr_utility.set_location('endperson: '||endperson,20);
3428: hr_utility.set_location('l_payroll_id: '||l_payroll_id,20);
3429: hr_utility.set_location('l_tax_ref: '||l_tax_ref,20);
3422:
3423: hr_utility.set_location('process start date'||l_start_date,20);
3424: hr_utility.set_location('process end date'||l_end_date,20);
3425: hr_utility.set_location('pactid: '||pactid,20);
3426: hr_utility.set_location('stperson: '||stperson,20);
3427: hr_utility.set_location('endperson: '||endperson,20);
3428: hr_utility.set_location('l_payroll_id: '||l_payroll_id,20);
3429: hr_utility.set_location('l_tax_ref: '||l_tax_ref,20);
3430: hr_utility.set_location('l_effective_date: '||l_effective_date,20);
3423: hr_utility.set_location('process start date'||l_start_date,20);
3424: hr_utility.set_location('process end date'||l_end_date,20);
3425: hr_utility.set_location('pactid: '||pactid,20);
3426: hr_utility.set_location('stperson: '||stperson,20);
3427: hr_utility.set_location('endperson: '||endperson,20);
3428: hr_utility.set_location('l_payroll_id: '||l_payroll_id,20);
3429: hr_utility.set_location('l_tax_ref: '||l_tax_ref,20);
3430: hr_utility.set_location('l_effective_date: '||l_effective_date,20);
3431: hr_utility.set_location('l_business_group_id: '||l_business_group_id,20);
3424: hr_utility.set_location('process end date'||l_end_date,20);
3425: hr_utility.set_location('pactid: '||pactid,20);
3426: hr_utility.set_location('stperson: '||stperson,20);
3427: hr_utility.set_location('endperson: '||endperson,20);
3428: hr_utility.set_location('l_payroll_id: '||l_payroll_id,20);
3429: hr_utility.set_location('l_tax_ref: '||l_tax_ref,20);
3430: hr_utility.set_location('l_effective_date: '||l_effective_date,20);
3431: hr_utility.set_location('l_business_group_id: '||l_business_group_id,20);
3432: hr_utility.set_location('g_start_year: '||g_start_year,20);
3425: hr_utility.set_location('pactid: '||pactid,20);
3426: hr_utility.set_location('stperson: '||stperson,20);
3427: hr_utility.set_location('endperson: '||endperson,20);
3428: hr_utility.set_location('l_payroll_id: '||l_payroll_id,20);
3429: hr_utility.set_location('l_tax_ref: '||l_tax_ref,20);
3430: hr_utility.set_location('l_effective_date: '||l_effective_date,20);
3431: hr_utility.set_location('l_business_group_id: '||l_business_group_id,20);
3432: hr_utility.set_location('g_start_year: '||g_start_year,20);
3433: hr_utility.set_location('l_first_fps_run_date: '||l_first_fps_run_date,20);
3426: hr_utility.set_location('stperson: '||stperson,20);
3427: hr_utility.set_location('endperson: '||endperson,20);
3428: hr_utility.set_location('l_payroll_id: '||l_payroll_id,20);
3429: hr_utility.set_location('l_tax_ref: '||l_tax_ref,20);
3430: hr_utility.set_location('l_effective_date: '||l_effective_date,20);
3431: hr_utility.set_location('l_business_group_id: '||l_business_group_id,20);
3432: hr_utility.set_location('g_start_year: '||g_start_year,20);
3433: hr_utility.set_location('l_first_fps_run_date: '||l_first_fps_run_date,20);
3434: hr_utility.set_location('l_first_fps_eff_date: '||l_first_fps_eff_date,20);
3427: hr_utility.set_location('endperson: '||endperson,20);
3428: hr_utility.set_location('l_payroll_id: '||l_payroll_id,20);
3429: hr_utility.set_location('l_tax_ref: '||l_tax_ref,20);
3430: hr_utility.set_location('l_effective_date: '||l_effective_date,20);
3431: hr_utility.set_location('l_business_group_id: '||l_business_group_id,20);
3432: hr_utility.set_location('g_start_year: '||g_start_year,20);
3433: hr_utility.set_location('l_first_fps_run_date: '||l_first_fps_run_date,20);
3434: hr_utility.set_location('l_first_fps_eff_date: '||l_first_fps_eff_date,20);
3435:
3428: hr_utility.set_location('l_payroll_id: '||l_payroll_id,20);
3429: hr_utility.set_location('l_tax_ref: '||l_tax_ref,20);
3430: hr_utility.set_location('l_effective_date: '||l_effective_date,20);
3431: hr_utility.set_location('l_business_group_id: '||l_business_group_id,20);
3432: hr_utility.set_location('g_start_year: '||g_start_year,20);
3433: hr_utility.set_location('l_first_fps_run_date: '||l_first_fps_run_date,20);
3434: hr_utility.set_location('l_first_fps_eff_date: '||l_first_fps_eff_date,20);
3435:
3436: hr_utility.trace(' Payroll : '||l_payroll_id);
3429: hr_utility.set_location('l_tax_ref: '||l_tax_ref,20);
3430: hr_utility.set_location('l_effective_date: '||l_effective_date,20);
3431: hr_utility.set_location('l_business_group_id: '||l_business_group_id,20);
3432: hr_utility.set_location('g_start_year: '||g_start_year,20);
3433: hr_utility.set_location('l_first_fps_run_date: '||l_first_fps_run_date,20);
3434: hr_utility.set_location('l_first_fps_eff_date: '||l_first_fps_eff_date,20);
3435:
3436: hr_utility.trace(' Payroll : '||l_payroll_id);
3437:
3430: hr_utility.set_location('l_effective_date: '||l_effective_date,20);
3431: hr_utility.set_location('l_business_group_id: '||l_business_group_id,20);
3432: hr_utility.set_location('g_start_year: '||g_start_year,20);
3433: hr_utility.set_location('l_first_fps_run_date: '||l_first_fps_run_date,20);
3434: hr_utility.set_location('l_first_fps_eff_date: '||l_first_fps_eff_date,20);
3435:
3436: hr_utility.trace(' Payroll : '||l_payroll_id);
3437:
3438: IF l_effective_date >= to_date('06-04-'||SUBSTR(TO_CHAR(l_effective_date,'YYYY/MON/DD'),1,4),'DD-MM-YYYY' ) THEN
3432: hr_utility.set_location('g_start_year: '||g_start_year,20);
3433: hr_utility.set_location('l_first_fps_run_date: '||l_first_fps_run_date,20);
3434: hr_utility.set_location('l_first_fps_eff_date: '||l_first_fps_eff_date,20);
3435:
3436: hr_utility.trace(' Payroll : '||l_payroll_id);
3437:
3438: IF l_effective_date >= to_date('06-04-'||SUBSTR(TO_CHAR(l_effective_date,'YYYY/MON/DD'),1,4),'DD-MM-YYYY' ) THEN
3439: g_start_year := to_date('06-04-'||SUBSTR(TO_CHAR(l_effective_date,'YYYY/MON/DD'),1,4),'DD-MM-YYYY' ) ;
3440: g_end_year := to_date('05-04-'||TO_CHAR(to_number(SUBSTR(TO_CHAR(l_effective_date,'YYYY/MON/DD'),1,4))+1 ),'DD-MM-YYYY') ;
3442: g_start_year := to_date('06-04-'||TO_CHAR(to_number(SUBSTR(TO_CHAR(l_effective_date,'YYYY/MON/DD'),1,4))-1 ),'DD-MM-YYYY') ;
3443: g_end_year := to_date('05-04-'||SUBSTR(TO_CHAR(l_effective_date,'YYYY/MON/DD'),1,4),'DD-MM-YYYY') ;
3444: END IF;
3445:
3446: hr_utility.set_location('pactid :' || pactid,15);
3447: hr_utility.set_location('stperson :' || stperson,15);
3448: hr_utility.set_location('endperson :' || endperson,15);
3449: hr_utility.set_location('l_payroll_id :' || l_payroll_id,15);
3450: hr_utility.set_location('l_pre_pact_id :' || l_pre_pact_id,15);
3443: g_end_year := to_date('05-04-'||SUBSTR(TO_CHAR(l_effective_date,'YYYY/MON/DD'),1,4),'DD-MM-YYYY') ;
3444: END IF;
3445:
3446: hr_utility.set_location('pactid :' || pactid,15);
3447: hr_utility.set_location('stperson :' || stperson,15);
3448: hr_utility.set_location('endperson :' || endperson,15);
3449: hr_utility.set_location('l_payroll_id :' || l_payroll_id,15);
3450: hr_utility.set_location('l_pre_pact_id :' || l_pre_pact_id,15);
3451: hr_utility.set_location('l_effective_date :' || l_effective_date,15);
3444: END IF;
3445:
3446: hr_utility.set_location('pactid :' || pactid,15);
3447: hr_utility.set_location('stperson :' || stperson,15);
3448: hr_utility.set_location('endperson :' || endperson,15);
3449: hr_utility.set_location('l_payroll_id :' || l_payroll_id,15);
3450: hr_utility.set_location('l_pre_pact_id :' || l_pre_pact_id,15);
3451: hr_utility.set_location('l_effective_date :' || l_effective_date,15);
3452:
3445:
3446: hr_utility.set_location('pactid :' || pactid,15);
3447: hr_utility.set_location('stperson :' || stperson,15);
3448: hr_utility.set_location('endperson :' || endperson,15);
3449: hr_utility.set_location('l_payroll_id :' || l_payroll_id,15);
3450: hr_utility.set_location('l_pre_pact_id :' || l_pre_pact_id,15);
3451: hr_utility.set_location('l_effective_date :' || l_effective_date,15);
3452:
3453: hr_utility.set_location('l_first_fps : '||l_first_fps,20);
3446: hr_utility.set_location('pactid :' || pactid,15);
3447: hr_utility.set_location('stperson :' || stperson,15);
3448: hr_utility.set_location('endperson :' || endperson,15);
3449: hr_utility.set_location('l_payroll_id :' || l_payroll_id,15);
3450: hr_utility.set_location('l_pre_pact_id :' || l_pre_pact_id,15);
3451: hr_utility.set_location('l_effective_date :' || l_effective_date,15);
3452:
3453: hr_utility.set_location('l_first_fps : '||l_first_fps,20);
3454: hr_utility.set_location('l_effective_date :' || l_effective_date,15);
3447: hr_utility.set_location('stperson :' || stperson,15);
3448: hr_utility.set_location('endperson :' || endperson,15);
3449: hr_utility.set_location('l_payroll_id :' || l_payroll_id,15);
3450: hr_utility.set_location('l_pre_pact_id :' || l_pre_pact_id,15);
3451: hr_utility.set_location('l_effective_date :' || l_effective_date,15);
3452:
3453: hr_utility.set_location('l_first_fps : '||l_first_fps,20);
3454: hr_utility.set_location('l_effective_date :' || l_effective_date,15);
3455: hr_utility.set_location('g_start_year :' || g_start_year,15);
3449: hr_utility.set_location('l_payroll_id :' || l_payroll_id,15);
3450: hr_utility.set_location('l_pre_pact_id :' || l_pre_pact_id,15);
3451: hr_utility.set_location('l_effective_date :' || l_effective_date,15);
3452:
3453: hr_utility.set_location('l_first_fps : '||l_first_fps,20);
3454: hr_utility.set_location('l_effective_date :' || l_effective_date,15);
3455: hr_utility.set_location('g_start_year :' || g_start_year,15);
3456: hr_utility.set_location('g_end_year :' || g_end_year,15);
3457:
3450: hr_utility.set_location('l_pre_pact_id :' || l_pre_pact_id,15);
3451: hr_utility.set_location('l_effective_date :' || l_effective_date,15);
3452:
3453: hr_utility.set_location('l_first_fps : '||l_first_fps,20);
3454: hr_utility.set_location('l_effective_date :' || l_effective_date,15);
3455: hr_utility.set_location('g_start_year :' || g_start_year,15);
3456: hr_utility.set_location('g_end_year :' || g_end_year,15);
3457:
3458: FOR asg_record IN csr_asg_details(l_tax_ref, l_effective_date,l_asg_set_id)
3451: hr_utility.set_location('l_effective_date :' || l_effective_date,15);
3452:
3453: hr_utility.set_location('l_first_fps : '||l_first_fps,20);
3454: hr_utility.set_location('l_effective_date :' || l_effective_date,15);
3455: hr_utility.set_location('g_start_year :' || g_start_year,15);
3456: hr_utility.set_location('g_end_year :' || g_end_year,15);
3457:
3458: FOR asg_record IN csr_asg_details(l_tax_ref, l_effective_date,l_asg_set_id)
3459: LOOP
3452:
3453: hr_utility.set_location('l_first_fps : '||l_first_fps,20);
3454: hr_utility.set_location('l_effective_date :' || l_effective_date,15);
3455: hr_utility.set_location('g_start_year :' || g_start_year,15);
3456: hr_utility.set_location('g_end_year :' || g_end_year,15);
3457:
3458: FOR asg_record IN csr_asg_details(l_tax_ref, l_effective_date,l_asg_set_id)
3459: LOOP
3460: l_flag := 'Y';
3458: FOR asg_record IN csr_asg_details(l_tax_ref, l_effective_date,l_asg_set_id)
3459: LOOP
3460: l_flag := 'Y';
3461:
3462: hr_utility.set_location('l_flag: '||l_flag,20);
3463:
3464: OPEN get_defined_balance_id('Gross Pay','_ASG_TD_YTD');
3465: FETCH get_defined_balance_id INTO l_gross_id;
3466: CLOSE get_defined_balance_id;
3509: l_date_soy := to_date('06-04-'||to_char(to_number(substr(to_char(l_effective_date,'YYYY/MON/DD'),1,4))-1 ),'DD-MM-YYYY') ;
3510: l_date_eoy := to_date('05-04-'||substr(to_char(l_effective_date,'YYYY/MON/DD'),1,4),'DD-MM-YYYY') ;
3511: End If;
3512:
3513: hr_utility.trace('asg_record.assignment_id '||asg_record.assignment_id);
3514: hr_utility.trace('l_date_soy '||l_date_soy);
3515: hr_utility.trace('l_date_eoy '||l_date_eoy);
3516:
3517: -- To get latest assignment action id for the assignment
3510: l_date_eoy := to_date('05-04-'||substr(to_char(l_effective_date,'YYYY/MON/DD'),1,4),'DD-MM-YYYY') ;
3511: End If;
3512:
3513: hr_utility.trace('asg_record.assignment_id '||asg_record.assignment_id);
3514: hr_utility.trace('l_date_soy '||l_date_soy);
3515: hr_utility.trace('l_date_eoy '||l_date_eoy);
3516:
3517: -- To get latest assignment action id for the assignment
3518: OPEN csr_last_action(asg_record.assignment_id,l_date_soy,l_date_eoy);
3511: End If;
3512:
3513: hr_utility.trace('asg_record.assignment_id '||asg_record.assignment_id);
3514: hr_utility.trace('l_date_soy '||l_date_soy);
3515: hr_utility.trace('l_date_eoy '||l_date_eoy);
3516:
3517: -- To get latest assignment action id for the assignment
3518: OPEN csr_last_action(asg_record.assignment_id,l_date_soy,l_date_eoy);
3519: FETCH csr_last_action
3551:
3552: IF (l_gross > 0 or l_taxable > 0 or l_niable > 0 or l_stud_loan > 0 or l_smp > 0 or l_sap > 0
3553: or l_spp_adopt > 0 or l_spp_birth > 0 or l_aspp_adopt > 0 or l_aspp_birth > 0)
3554: THEN
3555: hr_utility.trace('Assignment '||asg_record.assignment_id||' has YTD values');
3556: ELSE
3557: hr_utility.trace('Assignment '||asg_record.assignment_id||' has No YTD values.');
3558: l_flag:= 'N';
3559: END IF;
3553: or l_spp_adopt > 0 or l_spp_birth > 0 or l_aspp_adopt > 0 or l_aspp_birth > 0)
3554: THEN
3555: hr_utility.trace('Assignment '||asg_record.assignment_id||' has YTD values');
3556: ELSE
3557: hr_utility.trace('Assignment '||asg_record.assignment_id||' has No YTD values.');
3558: l_flag:= 'N';
3559: END IF;
3560:
3561: if l_flag = 'Y' Then --and l_first_fps_prepay_asg = 'N' Then
3566: End if;
3567:
3568: END LOOP;
3569:
3570: hr_utility.set_location('Leaving: '||l_proc,999);
3571: END internal_action_creation;
3572: --
3573: --
3574: --
3721: l_pre_pact_effective_date DATE;
3722: l_first_fps_run_date date;
3723:
3724: BEGIN
3725: hr_utility.set_location('Entering '|| l_proc, 10);
3726: l_err := FALSE;
3727:
3728: OPEN csr_parameter_info(p_payroll_action_id);
3729: FETCH csr_parameter_info
3737:
3738: g_fps_effective_date := l_effective_date;
3739: g_payroll_action_id := p_payroll_action_id;
3740:
3741: hr_utility.trace('l_effective_date: '||l_effective_date);
3742: hr_utility.trace('g_fps_effective_date: '||g_fps_effective_date);
3743: hr_utility.trace('g_business_group_id: '||g_business_group_id);
3744: hr_utility.trace('g_pre_pact_id: '||g_pre_pact_id);
3745: hr_utility.trace('g_payroll_id: '||g_payroll_id);
3738: g_fps_effective_date := l_effective_date;
3739: g_payroll_action_id := p_payroll_action_id;
3740:
3741: hr_utility.trace('l_effective_date: '||l_effective_date);
3742: hr_utility.trace('g_fps_effective_date: '||g_fps_effective_date);
3743: hr_utility.trace('g_business_group_id: '||g_business_group_id);
3744: hr_utility.trace('g_pre_pact_id: '||g_pre_pact_id);
3745: hr_utility.trace('g_payroll_id: '||g_payroll_id);
3746:
3739: g_payroll_action_id := p_payroll_action_id;
3740:
3741: hr_utility.trace('l_effective_date: '||l_effective_date);
3742: hr_utility.trace('g_fps_effective_date: '||g_fps_effective_date);
3743: hr_utility.trace('g_business_group_id: '||g_business_group_id);
3744: hr_utility.trace('g_pre_pact_id: '||g_pre_pact_id);
3745: hr_utility.trace('g_payroll_id: '||g_payroll_id);
3746:
3747: hr_utility.trace('l_first_fps_run_date: '||l_first_fps_run_date);
3740:
3741: hr_utility.trace('l_effective_date: '||l_effective_date);
3742: hr_utility.trace('g_fps_effective_date: '||g_fps_effective_date);
3743: hr_utility.trace('g_business_group_id: '||g_business_group_id);
3744: hr_utility.trace('g_pre_pact_id: '||g_pre_pact_id);
3745: hr_utility.trace('g_payroll_id: '||g_payroll_id);
3746:
3747: hr_utility.trace('l_first_fps_run_date: '||l_first_fps_run_date);
3748:
3741: hr_utility.trace('l_effective_date: '||l_effective_date);
3742: hr_utility.trace('g_fps_effective_date: '||g_fps_effective_date);
3743: hr_utility.trace('g_business_group_id: '||g_business_group_id);
3744: hr_utility.trace('g_pre_pact_id: '||g_pre_pact_id);
3745: hr_utility.trace('g_payroll_id: '||g_payroll_id);
3746:
3747: hr_utility.trace('l_first_fps_run_date: '||l_first_fps_run_date);
3748:
3749: SELECT distinct element_type_id
3743: hr_utility.trace('g_business_group_id: '||g_business_group_id);
3744: hr_utility.trace('g_pre_pact_id: '||g_pre_pact_id);
3745: hr_utility.trace('g_payroll_id: '||g_payroll_id);
3746:
3747: hr_utility.trace('l_first_fps_run_date: '||l_first_fps_run_date);
3748:
3749: SELECT distinct element_type_id
3750: INTO g_paye_element_id
3751: FROM pay_element_types_f
3757: FROM pay_element_types_f
3758: WHERE element_name = 'PAYE Details'
3759: AND legislation_code = 'GB';
3760:
3761: hr_utility.trace('g_paye_element_id: '||TO_CHAR(g_paye_element_id));
3762:
3763: IF l_effective_date >= to_date('06-04-'||SUBSTR(TO_CHAR(l_effective_date,'YYYY/MON/DD'),1,4),'DD-MM-YYYY' ) THEN
3764: g_start_year := to_date('06-04-'||SUBSTR(TO_CHAR(l_effective_date,'YYYY/MON/DD'),1,4),'DD-MM-YYYY' ) ;
3765: g_end_year := to_date('05-04-'||TO_CHAR(to_number(SUBSTR(TO_CHAR(l_effective_date,'YYYY/MON/DD'),1,4))+1 ),'DD-MM-YYYY') ;
3767: g_start_year := to_date('06-04-'||TO_CHAR(to_number(SUBSTR(TO_CHAR(l_effective_date,'YYYY/MON/DD'),1,4))-1 ),'DD-MM-YYYY') ;
3768: g_end_year := to_date('05-04-'||SUBSTR(TO_CHAR(l_effective_date,'YYYY/MON/DD'),1,4),'DD-MM-YYYY') ;
3769: END IF;
3770:
3771: hr_utility.trace('g_start_year: '||g_start_year);
3772: hr_utility.trace('g_end_year: '||g_end_year);
3773: hr_utility.trace('l_pre_pact_effective_date: '||l_pre_pact_effective_date);
3774:
3775: OPEN csr_ni_details;
3768: g_end_year := to_date('05-04-'||SUBSTR(TO_CHAR(l_effective_date,'YYYY/MON/DD'),1,4),'DD-MM-YYYY') ;
3769: END IF;
3770:
3771: hr_utility.trace('g_start_year: '||g_start_year);
3772: hr_utility.trace('g_end_year: '||g_end_year);
3773: hr_utility.trace('l_pre_pact_effective_date: '||l_pre_pact_effective_date);
3774:
3775: OPEN csr_ni_details;
3776: FETCH csr_ni_details INTO g_ni_pt_eid, g_ni_pt_ivid;
3769: END IF;
3770:
3771: hr_utility.trace('g_start_year: '||g_start_year);
3772: hr_utility.trace('g_end_year: '||g_end_year);
3773: hr_utility.trace('l_pre_pact_effective_date: '||l_pre_pact_effective_date);
3774:
3775: OPEN csr_ni_details;
3776: FETCH csr_ni_details INTO g_ni_pt_eid, g_ni_pt_ivid;
3777: CLOSE csr_ni_details;
3780: l_balance_counter := 1;
3781: FOR rec IN get_defined_balance_id
3782: LOOP
3783: g_fps_bal_det_tab(l_balance_counter).balance_name := rec.balance_name;
3784: hr_utility.trace('balance_name: '||g_fps_bal_det_tab(l_balance_counter).balance_name);
3785: g_fps_bal_det_tab(l_balance_counter).balance_type_id := rec.balance_type_id;
3786: hr_utility.trace('balance_type_id: '||g_fps_bal_det_tab(l_balance_counter).balance_type_id);
3787: g_fps_bal_det_tab(l_balance_counter).database_item_suffix := rec.database_item_suffix;
3788: hr_utility.trace('database_item_suffix: '||g_fps_bal_det_tab(l_balance_counter).database_item_suffix);
3782: LOOP
3783: g_fps_bal_det_tab(l_balance_counter).balance_name := rec.balance_name;
3784: hr_utility.trace('balance_name: '||g_fps_bal_det_tab(l_balance_counter).balance_name);
3785: g_fps_bal_det_tab(l_balance_counter).balance_type_id := rec.balance_type_id;
3786: hr_utility.trace('balance_type_id: '||g_fps_bal_det_tab(l_balance_counter).balance_type_id);
3787: g_fps_bal_det_tab(l_balance_counter).database_item_suffix := rec.database_item_suffix;
3788: hr_utility.trace('database_item_suffix: '||g_fps_bal_det_tab(l_balance_counter).database_item_suffix);
3789: g_fps_bal_det_tab(l_balance_counter).balance_dimension_id := rec.balance_dimension_id;
3790: hr_utility.trace('balance_dimension_id: '||g_fps_bal_det_tab(l_balance_counter).balance_dimension_id);
3784: hr_utility.trace('balance_name: '||g_fps_bal_det_tab(l_balance_counter).balance_name);
3785: g_fps_bal_det_tab(l_balance_counter).balance_type_id := rec.balance_type_id;
3786: hr_utility.trace('balance_type_id: '||g_fps_bal_det_tab(l_balance_counter).balance_type_id);
3787: g_fps_bal_det_tab(l_balance_counter).database_item_suffix := rec.database_item_suffix;
3788: hr_utility.trace('database_item_suffix: '||g_fps_bal_det_tab(l_balance_counter).database_item_suffix);
3789: g_fps_bal_det_tab(l_balance_counter).balance_dimension_id := rec.balance_dimension_id;
3790: hr_utility.trace('balance_dimension_id: '||g_fps_bal_det_tab(l_balance_counter).balance_dimension_id);
3791: g_fps_bal_det_tab(l_balance_counter).defined_balance_id := rec.defined_balance_id;
3792: hr_utility.trace('defined_balance_id: '||g_fps_bal_det_tab(l_balance_counter).defined_balance_id);
3786: hr_utility.trace('balance_type_id: '||g_fps_bal_det_tab(l_balance_counter).balance_type_id);
3787: g_fps_bal_det_tab(l_balance_counter).database_item_suffix := rec.database_item_suffix;
3788: hr_utility.trace('database_item_suffix: '||g_fps_bal_det_tab(l_balance_counter).database_item_suffix);
3789: g_fps_bal_det_tab(l_balance_counter).balance_dimension_id := rec.balance_dimension_id;
3790: hr_utility.trace('balance_dimension_id: '||g_fps_bal_det_tab(l_balance_counter).balance_dimension_id);
3791: g_fps_bal_det_tab(l_balance_counter).defined_balance_id := rec.defined_balance_id;
3792: hr_utility.trace('defined_balance_id: '||g_fps_bal_det_tab(l_balance_counter).defined_balance_id);
3793: l_balance_counter := l_balance_counter + 1;
3794: hr_utility.trace('Balance Counter: '||l_balance_counter);
3788: hr_utility.trace('database_item_suffix: '||g_fps_bal_det_tab(l_balance_counter).database_item_suffix);
3789: g_fps_bal_det_tab(l_balance_counter).balance_dimension_id := rec.balance_dimension_id;
3790: hr_utility.trace('balance_dimension_id: '||g_fps_bal_det_tab(l_balance_counter).balance_dimension_id);
3791: g_fps_bal_det_tab(l_balance_counter).defined_balance_id := rec.defined_balance_id;
3792: hr_utility.trace('defined_balance_id: '||g_fps_bal_det_tab(l_balance_counter).defined_balance_id);
3793: l_balance_counter := l_balance_counter + 1;
3794: hr_utility.trace('Balance Counter: '||l_balance_counter);
3795: END LOOP;
3796:
3790: hr_utility.trace('balance_dimension_id: '||g_fps_bal_det_tab(l_balance_counter).balance_dimension_id);
3791: g_fps_bal_det_tab(l_balance_counter).defined_balance_id := rec.defined_balance_id;
3792: hr_utility.trace('defined_balance_id: '||g_fps_bal_det_tab(l_balance_counter).defined_balance_id);
3793: l_balance_counter := l_balance_counter + 1;
3794: hr_utility.trace('Balance Counter: '||l_balance_counter);
3795: END LOOP;
3796:
3797: FOR i IN 1..g_fps_bal_det_tab.last
3798: LOOP
3798: LOOP
3799: g_defined_balance_lst(i).defined_balance_id := g_fps_bal_det_tab(i).defined_balance_id;
3800: END LOOP;
3801:
3802: hr_utility.set_location('Leaving '|| l_proc, 10);
3803:
3804: EXCEPTION
3805: WHEN OTHERS THEN
3806: fnd_file.put_line(fnd_file.LOG,'Exception:' || SQLCODE || ' - ' || SQLERRM);
3803:
3804: EXCEPTION
3805: WHEN OTHERS THEN
3806: fnd_file.put_line(fnd_file.LOG,'Exception:' || SQLCODE || ' - ' || SQLERRM);
3807: hr_utility.raise_error;
3808: END archinit;
3809: --
3810: --
3811: --
4044:
4045: BEGIN
4046:
4047: --archive_code begins here
4048: hr_utility.set_location('Entering the debug: '||l_proc,1);
4049: hr_utility.trace('p_assactid: '||p_assactid);
4050: hr_utility.trace('p_effective_date: '||p_effective_date);
4051: i := 1;
4052: -- get the parameter values present in globals to local variables.
4045: BEGIN
4046:
4047: --archive_code begins here
4048: hr_utility.set_location('Entering the debug: '||l_proc,1);
4049: hr_utility.trace('p_assactid: '||p_assactid);
4050: hr_utility.trace('p_effective_date: '||p_effective_date);
4051: i := 1;
4052: -- get the parameter values present in globals to local variables.
4053: l_tax_ref := g_tax_ref;
4046:
4047: --archive_code begins here
4048: hr_utility.set_location('Entering the debug: '||l_proc,1);
4049: hr_utility.trace('p_assactid: '||p_assactid);
4050: hr_utility.trace('p_effective_date: '||p_effective_date);
4051: i := 1;
4052: -- get the parameter values present in globals to local variables.
4053: l_tax_ref := g_tax_ref;
4054:
4051: i := 1;
4052: -- get the parameter values present in globals to local variables.
4053: l_tax_ref := g_tax_ref;
4054:
4055: hr_utility.trace('l_tax_ref: '||l_tax_ref);
4056:
4057: IF p_effective_date >= to_date('06-04-'||SUBSTR(TO_CHAR(p_effective_date,'YYYY/MON/DD'),1,4),'DD-MM-YYYY' ) THEN
4058: g_start_year := to_date('06-04-'||SUBSTR(TO_CHAR(p_effective_date,'YYYY/MON/DD'),1,4),'DD-MM-YYYY' ) ;
4059: g_end_year := to_date('05-04-'||TO_CHAR(to_number(SUBSTR(TO_CHAR(p_effective_date,'YYYY/MON/DD'),1,4))+1 ),'DD-MM-YYYY') ;
4075: OPEN csr_asg_basic_details(p_assactid);
4076: FETCH csr_asg_basic_details INTO l_asg_id, l_asg_eff_start_date, l_person_id, l_assignment_number, l_payroll_id;
4077: CLOSE csr_asg_basic_details;
4078:
4079: hr_utility.trace('l_asg_id: '||l_asg_id);
4080: hr_utility.trace('l_asg_eff_start_date: '||l_asg_eff_start_date);
4081: hr_utility.trace('l_person_id: '||l_person_id);
4082: hr_utility.trace('l_assignment_number: '||l_assignment_number);
4083: hr_utility.trace('l_payroll_id: '||l_payroll_id);
4076: FETCH csr_asg_basic_details INTO l_asg_id, l_asg_eff_start_date, l_person_id, l_assignment_number, l_payroll_id;
4077: CLOSE csr_asg_basic_details;
4078:
4079: hr_utility.trace('l_asg_id: '||l_asg_id);
4080: hr_utility.trace('l_asg_eff_start_date: '||l_asg_eff_start_date);
4081: hr_utility.trace('l_person_id: '||l_person_id);
4082: hr_utility.trace('l_assignment_number: '||l_assignment_number);
4083: hr_utility.trace('l_payroll_id: '||l_payroll_id);
4084:
4077: CLOSE csr_asg_basic_details;
4078:
4079: hr_utility.trace('l_asg_id: '||l_asg_id);
4080: hr_utility.trace('l_asg_eff_start_date: '||l_asg_eff_start_date);
4081: hr_utility.trace('l_person_id: '||l_person_id);
4082: hr_utility.trace('l_assignment_number: '||l_assignment_number);
4083: hr_utility.trace('l_payroll_id: '||l_payroll_id);
4084:
4085: OPEN csr_asg(p_assactid, p_effective_date);
4078:
4079: hr_utility.trace('l_asg_id: '||l_asg_id);
4080: hr_utility.trace('l_asg_eff_start_date: '||l_asg_eff_start_date);
4081: hr_utility.trace('l_person_id: '||l_person_id);
4082: hr_utility.trace('l_assignment_number: '||l_assignment_number);
4083: hr_utility.trace('l_payroll_id: '||l_payroll_id);
4084:
4085: OPEN csr_asg(p_assactid, p_effective_date);
4086: FETCH csr_asg INTO l_asg_primary_flag1, l_per_ni_agg_flag1, l_per_paye_agg_flag1, l_payroll_id1;
4079: hr_utility.trace('l_asg_id: '||l_asg_id);
4080: hr_utility.trace('l_asg_eff_start_date: '||l_asg_eff_start_date);
4081: hr_utility.trace('l_person_id: '||l_person_id);
4082: hr_utility.trace('l_assignment_number: '||l_assignment_number);
4083: hr_utility.trace('l_payroll_id: '||l_payroll_id);
4084:
4085: OPEN csr_asg(p_assactid, p_effective_date);
4086: FETCH csr_asg INTO l_asg_primary_flag1, l_per_ni_agg_flag1, l_per_paye_agg_flag1, l_payroll_id1;
4087: CLOSE csr_asg;
4084:
4085: OPEN csr_asg(p_assactid, p_effective_date);
4086: FETCH csr_asg INTO l_asg_primary_flag1, l_per_ni_agg_flag1, l_per_paye_agg_flag1, l_payroll_id1;
4087: CLOSE csr_asg;
4088: hr_utility.trace('l_per_ni_agg_flag1: '|| l_per_ni_agg_flag1);
4089: hr_utility.trace('l_per_paye_agg_flag1: '|| l_per_paye_agg_flag1);
4090:
4091:
4092: -- To get Assignment ID
4085: OPEN csr_asg(p_assactid, p_effective_date);
4086: FETCH csr_asg INTO l_asg_primary_flag1, l_per_ni_agg_flag1, l_per_paye_agg_flag1, l_payroll_id1;
4087: CLOSE csr_asg;
4088: hr_utility.trace('l_per_ni_agg_flag1: '|| l_per_ni_agg_flag1);
4089: hr_utility.trace('l_per_paye_agg_flag1: '|| l_per_paye_agg_flag1);
4090:
4091:
4092: -- To get Assignment ID
4093: open csr_asg_id(p_assactid);
4093: open csr_asg_id(p_assactid);
4094: fetch csr_asg_id into l_asg_id;
4095: close csr_asg_id;
4096:
4097: hr_utility.trace('l_asg_id: '|| l_asg_id);
4098: hr_utility.trace('g_start_year: '|| g_start_year);
4099: hr_utility.trace('g_end_year: '|| g_end_year);
4100: hr_utility.trace('l_payroll_id: '|| l_payroll_id);
4101:
4094: fetch csr_asg_id into l_asg_id;
4095: close csr_asg_id;
4096:
4097: hr_utility.trace('l_asg_id: '|| l_asg_id);
4098: hr_utility.trace('g_start_year: '|| g_start_year);
4099: hr_utility.trace('g_end_year: '|| g_end_year);
4100: hr_utility.trace('l_payroll_id: '|| l_payroll_id);
4101:
4102: -- To get latest assignment action id for the assignment
4095: close csr_asg_id;
4096:
4097: hr_utility.trace('l_asg_id: '|| l_asg_id);
4098: hr_utility.trace('g_start_year: '|| g_start_year);
4099: hr_utility.trace('g_end_year: '|| g_end_year);
4100: hr_utility.trace('l_payroll_id: '|| l_payroll_id);
4101:
4102: -- To get latest assignment action id for the assignment
4103: OPEN csr_last_action_p60(l_asg_id, g_start_year, g_end_year, l_payroll_id);
4096:
4097: hr_utility.trace('l_asg_id: '|| l_asg_id);
4098: hr_utility.trace('g_start_year: '|| g_start_year);
4099: hr_utility.trace('g_end_year: '|| g_end_year);
4100: hr_utility.trace('l_payroll_id: '|| l_payroll_id);
4101:
4102: -- To get latest assignment action id for the assignment
4103: OPEN csr_last_action_p60(l_asg_id, g_start_year, g_end_year, l_payroll_id);
4104: FETCH csr_last_action_p60 INTO l_last_asg_action_id,
4104: FETCH csr_last_action_p60 INTO l_last_asg_action_id,
4105: l_last_effective_date;
4106: CLOSE csr_last_action_p60;
4107:
4108: hr_utility.trace('l_last_asg_action_id: '|| l_last_asg_action_id);
4109: hr_utility.trace('l_last_effective_date: '|| l_last_effective_date);
4110:
4111: hr_utility.set_location('Fetching Payroll Details ',10);
4112: l_archive_p60_emp := fetch_p60_emp_det(p_assactid,
4105: l_last_effective_date;
4106: CLOSE csr_last_action_p60;
4107:
4108: hr_utility.trace('l_last_asg_action_id: '|| l_last_asg_action_id);
4109: hr_utility.trace('l_last_effective_date: '|| l_last_effective_date);
4110:
4111: hr_utility.set_location('Fetching Payroll Details ',10);
4112: l_archive_p60_emp := fetch_p60_emp_det(p_assactid,
4113: l_pact_id,
4107:
4108: hr_utility.trace('l_last_asg_action_id: '|| l_last_asg_action_id);
4109: hr_utility.trace('l_last_effective_date: '|| l_last_effective_date);
4110:
4111: hr_utility.set_location('Fetching Payroll Details ',10);
4112: l_archive_p60_emp := fetch_p60_emp_det(p_assactid,
4113: l_pact_id,
4114: l_person_id,
4115: l_asg_id,
4116: g_start_year,
4117: g_end_year,
4118: l_archive_tab(0));
4119:
4120: hr_utility.set_location('Fetching address details ',20);
4121:
4122: l_archive_p60_asg := fetch_p60_asg_det(p_assactid,
4123: l_pact_id,
4124: l_last_asg_action_id,
4129: l_paye_aggr_asgactid,
4130: l_paye_aggr_asgid,
4131: l_archive_tab(1));
4132:
4133: hr_utility.set_location('l_paye_aggr_asgactid: ' || l_paye_aggr_asgactid, 50);
4134: hr_utility.set_location('l_paye_aggr_asgid: ' || l_paye_aggr_asgid, 50);
4135:
4136: if (l_per_ni_agg_flag1 = 'Y') then
4137: open csr_get_ni_rpt_asg(l_asg_id);
4130: l_paye_aggr_asgid,
4131: l_archive_tab(1));
4132:
4133: hr_utility.set_location('l_paye_aggr_asgactid: ' || l_paye_aggr_asgactid, 50);
4134: hr_utility.set_location('l_paye_aggr_asgid: ' || l_paye_aggr_asgid, 50);
4135:
4136: if (l_per_ni_agg_flag1 = 'Y') then
4137: open csr_get_ni_rpt_asg(l_asg_id);
4138: fetch csr_get_ni_rpt_asg into l_ni_rpt_asg_id,l_ni_rpt_date;
4136: if (l_per_ni_agg_flag1 = 'Y') then
4137: open csr_get_ni_rpt_asg(l_asg_id);
4138: fetch csr_get_ni_rpt_asg into l_ni_rpt_asg_id,l_ni_rpt_date;
4139: close csr_get_ni_rpt_asg;
4140: hr_utility.set_location('l_ni_rpt_asg_id: ' || l_ni_rpt_asg_id, 50);
4141: hr_utility.set_location('l_ni_rpt_date: ' || l_ni_rpt_date, 50);
4142:
4143: if l_ni_rpt_asg_id is null then
4144: hr_utility.set_location('NO RTI Reporting asg for :'|| l_asg_id, 50);
4137: open csr_get_ni_rpt_asg(l_asg_id);
4138: fetch csr_get_ni_rpt_asg into l_ni_rpt_asg_id,l_ni_rpt_date;
4139: close csr_get_ni_rpt_asg;
4140: hr_utility.set_location('l_ni_rpt_asg_id: ' || l_ni_rpt_asg_id, 50);
4141: hr_utility.set_location('l_ni_rpt_date: ' || l_ni_rpt_date, 50);
4142:
4143: if l_ni_rpt_asg_id is null then
4144: hr_utility.set_location('NO RTI Reporting asg for :'|| l_asg_id, 50);
4145: fnd_file.put_line (fnd_file.LOG,'NO RTI Reporting asg for :'|| l_asg_id);
4140: hr_utility.set_location('l_ni_rpt_asg_id: ' || l_ni_rpt_asg_id, 50);
4141: hr_utility.set_location('l_ni_rpt_date: ' || l_ni_rpt_date, 50);
4142:
4143: if l_ni_rpt_asg_id is null then
4144: hr_utility.set_location('NO RTI Reporting asg for :'|| l_asg_id, 50);
4145: fnd_file.put_line (fnd_file.LOG,'NO RTI Reporting asg for :'|| l_asg_id);
4146: end if;
4147: end if;
4148:
4147: end if;
4148:
4149: if (l_per_ni_agg_flag1 = 'Y' and l_ni_rpt_asg_id = l_asg_id) then
4150:
4151: hr_utility.set_location('Inside NI Only Aggregation for NI Balances for: '||l_aggr_last_asgact_id,60);
4152:
4153: open csr_aggr_last_payroll_action(l_person_id,g_start_year,g_end_year);
4154: fetch csr_aggr_last_payroll_action into l_aggr_last_asgact_id, l_aggr_last_eff_date;
4155: close csr_aggr_last_payroll_action;
4163: p_ni_j_balance,
4164: p_ni_l_balance);
4165:
4166: elsif (l_per_paye_agg_flag1 = 'Y' and l_asg_id = nvl(l_paye_aggr_asgid,-999)) then
4167: hr_utility.set_location('Inside PAYE Aggregation for NI Balances for: '||l_paye_aggr_asgactid, 60);
4168: get_paye_aggr_ni_balances(l_asg_id,
4169: l_paye_aggr_asgactid,
4170: p_ni_a_balance,
4171: p_ni_b_balance,
4173: p_ni_d_balance,
4174: p_ni_e_balance,
4175: p_ni_j_balance,
4176: p_ni_l_balance);
4177: hr_utility.trace('l_asg_id: '|| l_asg_id);
4178: hr_utility.trace('l_paye_aggr_asgactid: '|| l_paye_aggr_asgactid);
4179: else
4180: hr_utility.set_location('Inside Non-Aggregation for NI Balances for: '||l_last_asg_action_id, 60);
4181: get_ni_balances_for_asg(l_last_asg_action_id,
4174: p_ni_e_balance,
4175: p_ni_j_balance,
4176: p_ni_l_balance);
4177: hr_utility.trace('l_asg_id: '|| l_asg_id);
4178: hr_utility.trace('l_paye_aggr_asgactid: '|| l_paye_aggr_asgactid);
4179: else
4180: hr_utility.set_location('Inside Non-Aggregation for NI Balances for: '||l_last_asg_action_id, 60);
4181: get_ni_balances_for_asg(l_last_asg_action_id,
4182: p_ni_a_balance,
4176: p_ni_l_balance);
4177: hr_utility.trace('l_asg_id: '|| l_asg_id);
4178: hr_utility.trace('l_paye_aggr_asgactid: '|| l_paye_aggr_asgactid);
4179: else
4180: hr_utility.set_location('Inside Non-Aggregation for NI Balances for: '||l_last_asg_action_id, 60);
4181: get_ni_balances_for_asg(l_last_asg_action_id,
4182: p_ni_a_balance,
4183: p_ni_b_balance,
4184: p_ni_c_balance,
4185: p_ni_d_balance,
4186: p_ni_e_balance,
4187: p_ni_j_balance,
4188: p_ni_l_balance);
4189: hr_utility.trace('l_last_asg_action_id: '|| l_last_asg_action_id);
4190: end if;
4191:
4192: if (l_per_ni_agg_flag1 = 'Y' and l_ni_rpt_asg_id <> l_asg_id) then
4193: hr_utility.trace('Archiving X category for NI Only Aggregation scenarios: '|| l_asg_id);
4189: hr_utility.trace('l_last_asg_action_id: '|| l_last_asg_action_id);
4190: end if;
4191:
4192: if (l_per_ni_agg_flag1 = 'Y' and l_ni_rpt_asg_id <> l_asg_id) then
4193: hr_utility.trace('Archiving X category for NI Only Aggregation scenarios: '|| l_asg_id);
4194:
4195: l_archive_tab(2).assignment_id := l_archive_tab(1).assignment_id;
4196: l_archive_tab(2).action_info_category := 'GB RTI P60 NI DET';
4197: l_archive_tab(2).act_info1 := 'X';
4217: l_archive_tab(already_a).act_info4 := p_ni_a_balance.act_info5;
4218: l_archive_tab(already_a).act_info5 := p_ni_a_balance.act_info6;
4219: l_archive_tab(already_a).act_info6 := p_ni_a_balance.act_info8;
4220:
4221: hr_utility.set_location('l_ni_counter: '||l_ni_counter,10);
4222:
4223: if (l_ni_counter = 1) then
4224: l_archive_tab(already_a).act_info7 := 'NIC1';
4225: elsif (l_ni_counter = 2) then
4247: l_archive_tab(already_b).act_info4 := p_ni_b_balance.act_info5;
4248: l_archive_tab(already_b).act_info5 := p_ni_b_balance.act_info6;
4249: l_archive_tab(already_b).act_info6 := p_ni_b_balance.act_info8;
4250:
4251: hr_utility.set_location('l_ni_counter: '||l_ni_counter,10);
4252:
4253: if (l_ni_counter = 1) then
4254: l_archive_tab(already_b).act_info7 := 'NIC1';
4255: elsif (l_ni_counter = 2) then
4279: l_archive_tab(already_c).act_info4 := p_ni_c_balance.act_info5;
4280: l_archive_tab(already_c).act_info5 := p_ni_c_balance.act_info6;
4281: l_archive_tab(already_c).act_info6 := p_ni_c_balance.act_info8;
4282:
4283: hr_utility.set_location('l_ni_counter: '||l_ni_counter,10);
4284:
4285: if (l_ni_counter = 1) then
4286: l_archive_tab(already_c).act_info7 := 'NIC1';
4287: elsif (l_ni_counter = 2) then
4310: l_archive_tab(already_d).act_info4 := p_ni_d_balance.act_info5;
4311: l_archive_tab(already_d).act_info5 := p_ni_d_balance.act_info6;
4312: l_archive_tab(already_d).act_info6 := p_ni_d_balance.act_info8;
4313:
4314: hr_utility.set_location('l_ni_counter: '||l_ni_counter,10);
4315:
4316: if (l_ni_counter = 1) then
4317: l_archive_tab(already_d).act_info7 := 'NIC1';
4318: elsif (l_ni_counter = 2) then
4341: l_archive_tab(already_e).act_info4 := p_ni_e_balance.act_info5;
4342: l_archive_tab(already_e).act_info5 := p_ni_e_balance.act_info6;
4343: l_archive_tab(already_e).act_info6 := p_ni_e_balance.act_info8;
4344:
4345: hr_utility.set_location('l_ni_counter: '||l_ni_counter,10);
4346:
4347: if (l_ni_counter = 1) then
4348: l_archive_tab(already_e).act_info7 := 'NIC1';
4349: elsif (l_ni_counter = 2) then
4372: l_archive_tab(already_j).act_info4 := p_ni_j_balance.act_info5;
4373: l_archive_tab(already_j).act_info5 := p_ni_j_balance.act_info6;
4374: l_archive_tab(already_j).act_info6 := p_ni_j_balance.act_info8;
4375:
4376: hr_utility.set_location('l_ni_counter: '||l_ni_counter,10);
4377:
4378: if (l_ni_counter = 1) then
4379: l_archive_tab(already_j).act_info7 := 'NIC1';
4380: elsif (l_ni_counter = 2) then
4403: l_archive_tab(already_l).act_info4 := p_ni_l_balance.act_info5;
4404: l_archive_tab(already_l).act_info5 := p_ni_l_balance.act_info6;
4405: l_archive_tab(already_l).act_info6 := p_ni_l_balance.act_info8;
4406:
4407: hr_utility.set_location('l_ni_counter: '||l_ni_counter,10);
4408:
4409: if (l_ni_counter = 1) then
4410: l_archive_tab(already_l).act_info7 := 'NIC1';
4411: elsif (l_ni_counter = 2) then
4420: END IF;
4421:
4422: end if; --if (l_per_ni_agg_flag1 = 'Y' and l_ni_rpt_asg_id <> l_asg_id) then
4423:
4424: hr_utility.trace('already_a: '||already_a);
4425: hr_utility.trace('already_b: '||already_b);
4426: hr_utility.trace('already_c: '||already_c);
4427: hr_utility.trace('already_d: '||already_d);
4428: hr_utility.trace('already_e: '||already_e);
4421:
4422: end if; --if (l_per_ni_agg_flag1 = 'Y' and l_ni_rpt_asg_id <> l_asg_id) then
4423:
4424: hr_utility.trace('already_a: '||already_a);
4425: hr_utility.trace('already_b: '||already_b);
4426: hr_utility.trace('already_c: '||already_c);
4427: hr_utility.trace('already_d: '||already_d);
4428: hr_utility.trace('already_e: '||already_e);
4429: hr_utility.trace('already_j: '||already_j);
4422: end if; --if (l_per_ni_agg_flag1 = 'Y' and l_ni_rpt_asg_id <> l_asg_id) then
4423:
4424: hr_utility.trace('already_a: '||already_a);
4425: hr_utility.trace('already_b: '||already_b);
4426: hr_utility.trace('already_c: '||already_c);
4427: hr_utility.trace('already_d: '||already_d);
4428: hr_utility.trace('already_e: '||already_e);
4429: hr_utility.trace('already_j: '||already_j);
4430: hr_utility.trace('already_l: '||already_l);
4423:
4424: hr_utility.trace('already_a: '||already_a);
4425: hr_utility.trace('already_b: '||already_b);
4426: hr_utility.trace('already_c: '||already_c);
4427: hr_utility.trace('already_d: '||already_d);
4428: hr_utility.trace('already_e: '||already_e);
4429: hr_utility.trace('already_j: '||already_j);
4430: hr_utility.trace('already_l: '||already_l);
4431: hr_utility.trace('***i: '||i);
4424: hr_utility.trace('already_a: '||already_a);
4425: hr_utility.trace('already_b: '||already_b);
4426: hr_utility.trace('already_c: '||already_c);
4427: hr_utility.trace('already_d: '||already_d);
4428: hr_utility.trace('already_e: '||already_e);
4429: hr_utility.trace('already_j: '||already_j);
4430: hr_utility.trace('already_l: '||already_l);
4431: hr_utility.trace('***i: '||i);
4432:
4425: hr_utility.trace('already_b: '||already_b);
4426: hr_utility.trace('already_c: '||already_c);
4427: hr_utility.trace('already_d: '||already_d);
4428: hr_utility.trace('already_e: '||already_e);
4429: hr_utility.trace('already_j: '||already_j);
4430: hr_utility.trace('already_l: '||already_l);
4431: hr_utility.trace('***i: '||i);
4432:
4433: IF l_archive_p60_emp AND l_archive_p60_asg THEN
4426: hr_utility.trace('already_c: '||already_c);
4427: hr_utility.trace('already_d: '||already_d);
4428: hr_utility.trace('already_e: '||already_e);
4429: hr_utility.trace('already_j: '||already_j);
4430: hr_utility.trace('already_l: '||already_l);
4431: hr_utility.trace('***i: '||i);
4432:
4433: IF l_archive_p60_emp AND l_archive_p60_asg THEN
4434: hr_utility.set_location('Validation successful, archive data.',999);
4427: hr_utility.trace('already_d: '||already_d);
4428: hr_utility.trace('already_e: '||already_e);
4429: hr_utility.trace('already_j: '||already_j);
4430: hr_utility.trace('already_l: '||already_l);
4431: hr_utility.trace('***i: '||i);
4432:
4433: IF l_archive_p60_emp AND l_archive_p60_asg THEN
4434: hr_utility.set_location('Validation successful, archive data.',999);
4435: insert_archive_row(p_assactid, p_effective_date,l_archive_tab);
4430: hr_utility.trace('already_l: '||already_l);
4431: hr_utility.trace('***i: '||i);
4432:
4433: IF l_archive_p60_emp AND l_archive_p60_asg THEN
4434: hr_utility.set_location('Validation successful, archive data.',999);
4435: insert_archive_row(p_assactid, p_effective_date,l_archive_tab);
4436: ELSE
4437: hr_utility.set_location('Archiving Error - assignment action id ' || p_assactid ,999);
4438: raise error_found;
4433: IF l_archive_p60_emp AND l_archive_p60_asg THEN
4434: hr_utility.set_location('Validation successful, archive data.',999);
4435: insert_archive_row(p_assactid, p_effective_date,l_archive_tab);
4436: ELSE
4437: hr_utility.set_location('Archiving Error - assignment action id ' || p_assactid ,999);
4438: raise error_found;
4439: END IF;
4440:
4441: hr_utility.set_location('Leaving: '||l_proc,999);
4437: hr_utility.set_location('Archiving Error - assignment action id ' || p_assactid ,999);
4438: raise error_found;
4439: END IF;
4440:
4441: hr_utility.set_location('Leaving: '||l_proc,999);
4442: EXCEPTION
4443: WHEN error_found THEN
4444: -- reset_flag('GB_RTI_ASG_DETAILS',g_reset_flag_type, p_assactid);
4445: fnd_file.put_line(fnd_file.LOG,'Errors found while archiving data.');
4917: fnd_file.put_line(fnd_file.output,'Total Number of employees successfully processed : ' || l_person_count);
4918: END write_footer;
4919: ---------------------
4920: BEGIN
4921: hr_utility.trace('Entering deinit: '||l_proc);
4922:
4923: hr_utility.set_location('Fetching Payroll Details ',10);
4924: delete from pay_action_information pai
4925: where pai.action_context_id = pactid
4919: ---------------------
4920: BEGIN
4921: hr_utility.trace('Entering deinit: '||l_proc);
4922:
4923: hr_utility.set_location('Fetching Payroll Details ',10);
4924: delete from pay_action_information pai
4925: where pai.action_context_id = pactid
4926: and pai.action_context_type = 'PA'
4927: and pai.action_information_category in ('GB RTI P60 PAYROLL DET');
4926: and pai.action_context_type = 'PA'
4927: and pai.action_information_category in ('GB RTI P60 PAYROLL DET');
4928:
4929:
4930: hr_utility.set_location('Archiving GB RTI P60 PAYROLL DET',60);
4931:
4932:
4933: l_archive_p60_payroll := fetch_p60_payroll_det(pactid,
4934: g_start_year,
4932:
4933: l_archive_p60_payroll := fetch_p60_payroll_det(pactid,
4934: g_start_year,
4935: g_end_year);
4936: hr_utility.set_location('After Fetching Payroll Details ',10);
4937:
4938: pay_balance_pkg.set_context('PAYROLL_ACTION_ID',pactid);
4939:
4940: OPEN csr_is_etext_report;
4950: write_sub_header('W',l_is_etext_report);
4951: write_body('W',pactid,l_is_etext_report);
4952: write_footer;
4953:
4954: hr_utility.set_location('Leaving: '||l_proc,999);
4955:
4956: EXCEPTION
4957: When l_exp then
4958: fnd_file.put_line(fnd_file.LOG,'Errors found while archiving data.');
4966: varchar2 is
4967: l_stmt varchar2(200);
4968: l_col_val varchar2(100);
4969: begin
4970: hr_utility.set_location('p_column_name: ' || p_column_name,60);
4971: hr_utility.set_location('p_peop_grp_id: '|| p_peop_grp_id,60);
4972: fnd_file.put_line(fnd_file.LOG,'p_column_name: ' || p_column_name || '-' ||'p_peop_grp_id: '|| p_peop_grp_id);
4973:
4974: if p_column_name is not null and p_peop_grp_id is not null then
4967: l_stmt varchar2(200);
4968: l_col_val varchar2(100);
4969: begin
4970: hr_utility.set_location('p_column_name: ' || p_column_name,60);
4971: hr_utility.set_location('p_peop_grp_id: '|| p_peop_grp_id,60);
4972: fnd_file.put_line(fnd_file.LOG,'p_column_name: ' || p_column_name || '-' ||'p_peop_grp_id: '|| p_peop_grp_id);
4973:
4974: if p_column_name is not null and p_peop_grp_id is not null then
4975: l_stmt := 'select '|| p_column_name ||' from pay_people_groups pp where pp.people_group_id = :PEOPLE_GRP_ID';