[Home] [Help]
300: l_proc VARCHAR2(50) := g_package || 'get_parameters';
301:
302: BEGIN
303:
304: hr_utility.set_location('Entering ' || l_proc,10);
305:
306: hr_utility.set_location('Step ' || l_proc,20);
307: hr_utility.set_location('p_token_name = ' || p_token_name,20);
308:
302: BEGIN
303:
304: hr_utility.set_location('Entering ' || l_proc,10);
305:
306: hr_utility.set_location('Step ' || l_proc,20);
307: hr_utility.set_location('p_token_name = ' || p_token_name,20);
308:
309: OPEN csr_parameter_info(p_payroll_action_id,
310: p_token_name);
303:
304: hr_utility.set_location('Entering ' || l_proc,10);
305:
306: hr_utility.set_location('Step ' || l_proc,20);
307: hr_utility.set_location('p_token_name = ' || p_token_name,20);
308:
309: OPEN csr_parameter_info(p_payroll_action_id,
310: p_token_name);
311:
325: p_token_value := l_token_value;
326:
327: END IF;
328:
329: hr_utility.set_location('l_token_value = ' || l_token_value,20);
330: hr_utility.set_location('Leaving ' || l_proc,30);
331:
332: END get_parameters;
333:
326:
327: END IF;
328:
329: hr_utility.set_location('l_token_value = ' || l_token_value,20);
330: hr_utility.set_location('Leaving ' || l_proc,30);
331:
332: END get_parameters;
333:
334: --------------------------------
367:
368: BEGIN
369:
370:
371: hr_utility.set_location('Entering ' || l_proc,10);
372: hr_utility.set_location('Step ' || l_proc,20);
373:
374: FOR l_index IN 1 ..g_max_statutory_balance_index
375: LOOP
368: BEGIN
369:
370:
371: hr_utility.set_location('Entering ' || l_proc,10);
372: hr_utility.set_location('Step ' || l_proc,20);
373:
374: FOR l_index IN 1 ..g_max_statutory_balance_index
375: LOOP
376:
373:
374: FOR l_index IN 1 ..g_max_statutory_balance_index
375: LOOP
376:
377: hr_utility.set_location('p_pactid = '||p_pactid,20);
378: hr_utility.set_location('p_payroll_pact = '||p_payroll_pact,20);
379: hr_utility.set_location('p_effective_date = '||p_effective_date,20);
380: hr_utility.set_location('defined_balance_id = '||g_statutory_balance_table(l_index).defined_balance_id,20);
381: hr_utility.set_location('balance_name = '||g_statutory_balance_table(l_index).balance_name,20);
374: FOR l_index IN 1 ..g_max_statutory_balance_index
375: LOOP
376:
377: hr_utility.set_location('p_pactid = '||p_pactid,20);
378: hr_utility.set_location('p_payroll_pact = '||p_payroll_pact,20);
379: hr_utility.set_location('p_effective_date = '||p_effective_date,20);
380: hr_utility.set_location('defined_balance_id = '||g_statutory_balance_table(l_index).defined_balance_id,20);
381: hr_utility.set_location('balance_name = '||g_statutory_balance_table(l_index).balance_name,20);
382:
375: LOOP
376:
377: hr_utility.set_location('p_pactid = '||p_pactid,20);
378: hr_utility.set_location('p_payroll_pact = '||p_payroll_pact,20);
379: hr_utility.set_location('p_effective_date = '||p_effective_date,20);
380: hr_utility.set_location('defined_balance_id = '||g_statutory_balance_table(l_index).defined_balance_id,20);
381: hr_utility.set_location('balance_name = '||g_statutory_balance_table(l_index).balance_name,20);
382:
383: pay_action_information_api.create_action_information (
376:
377: hr_utility.set_location('p_pactid = '||p_pactid,20);
378: hr_utility.set_location('p_payroll_pact = '||p_payroll_pact,20);
379: hr_utility.set_location('p_effective_date = '||p_effective_date,20);
380: hr_utility.set_location('defined_balance_id = '||g_statutory_balance_table(l_index).defined_balance_id,20);
381: hr_utility.set_location('balance_name = '||g_statutory_balance_table(l_index).balance_name,20);
382:
383: pay_action_information_api.create_action_information (
384: p_action_information_id => l_action_info_id
377: hr_utility.set_location('p_pactid = '||p_pactid,20);
378: hr_utility.set_location('p_payroll_pact = '||p_payroll_pact,20);
379: hr_utility.set_location('p_effective_date = '||p_effective_date,20);
380: hr_utility.set_location('defined_balance_id = '||g_statutory_balance_table(l_index).defined_balance_id,20);
381: hr_utility.set_location('balance_name = '||g_statutory_balance_table(l_index).balance_name,20);
382:
383: pay_action_information_api.create_action_information (
384: p_action_information_id => l_action_info_id
385: , p_action_context_id => p_pactid
396: , p_action_information7 => 'N' /* 7291676 */
397: );
398: END LOOP;
399: /* 7291676 */
400: hr_utility.set_location(' creating emea balance definations for PPSN override balance table ',20);
401:
402: FOR l_index IN 1 ..g_max_statutory_balance_index
403: LOOP
404:
401:
402: FOR l_index IN 1 ..g_max_statutory_balance_index
403: LOOP
404:
405: hr_utility.set_location('p_pactid = '||p_pactid,20);
406: hr_utility.set_location('p_payroll_pact = '||p_payroll_pact,20);
407: hr_utility.set_location('p_effective_date = '||p_effective_date,20);
408: hr_utility.set_location('defined_balance_id = '||g_statutory_balance_table(l_index).defined_balance_id,20);
409: hr_utility.set_location('balance_name = '||g_statutory_balance_table(l_index).balance_name,20);
402: FOR l_index IN 1 ..g_max_statutory_balance_index
403: LOOP
404:
405: hr_utility.set_location('p_pactid = '||p_pactid,20);
406: hr_utility.set_location('p_payroll_pact = '||p_payroll_pact,20);
407: hr_utility.set_location('p_effective_date = '||p_effective_date,20);
408: hr_utility.set_location('defined_balance_id = '||g_statutory_balance_table(l_index).defined_balance_id,20);
409: hr_utility.set_location('balance_name = '||g_statutory_balance_table(l_index).balance_name,20);
410:
403: LOOP
404:
405: hr_utility.set_location('p_pactid = '||p_pactid,20);
406: hr_utility.set_location('p_payroll_pact = '||p_payroll_pact,20);
407: hr_utility.set_location('p_effective_date = '||p_effective_date,20);
408: hr_utility.set_location('defined_balance_id = '||g_statutory_balance_table(l_index).defined_balance_id,20);
409: hr_utility.set_location('balance_name = '||g_statutory_balance_table(l_index).balance_name,20);
410:
411: pay_action_information_api.create_action_information (
404:
405: hr_utility.set_location('p_pactid = '||p_pactid,20);
406: hr_utility.set_location('p_payroll_pact = '||p_payroll_pact,20);
407: hr_utility.set_location('p_effective_date = '||p_effective_date,20);
408: hr_utility.set_location('defined_balance_id = '||g_statutory_balance_table(l_index).defined_balance_id,20);
409: hr_utility.set_location('balance_name = '||g_statutory_balance_table(l_index).balance_name,20);
410:
411: pay_action_information_api.create_action_information (
412: p_action_information_id => l_action_info_id
405: hr_utility.set_location('p_pactid = '||p_pactid,20);
406: hr_utility.set_location('p_payroll_pact = '||p_payroll_pact,20);
407: hr_utility.set_location('p_effective_date = '||p_effective_date,20);
408: hr_utility.set_location('defined_balance_id = '||g_statutory_balance_table(l_index).defined_balance_id,20);
409: hr_utility.set_location('balance_name = '||g_statutory_balance_table(l_index).balance_name,20);
410:
411: pay_action_information_api.create_action_information (
412: p_action_information_id => l_action_info_id
413: , p_action_context_id => p_pactid
425: );
426:
427: END LOOP;
428:
429: hr_utility.set_location('Leaving ' || l_proc,30);
430:
431: END setup_balance_definitions;
432: ------------------------
433: /* This Procedure populates PL/SQL Table with balance names and defined_balance_id which are used to
487: l_pactid NUMBER;
488: l_payroll_pact NUMBER;
489: l_proc VARCHAR2(100) := g_package || 'setup_standard_balance_table';
490: BEGIN
491: hr_utility.set_location('Entering ' || l_proc,10);
492: hr_utility.set_location('Step ' || l_proc,20);
493: l_statutory_balance(1).balance_name := 'IE Taxable Pay';
494: l_statutory_balance(2).balance_name := 'IE Net Tax';
495: l_statutory_balance(3).balance_name := 'IE PRSI Employer';
488: l_payroll_pact NUMBER;
489: l_proc VARCHAR2(100) := g_package || 'setup_standard_balance_table';
490: BEGIN
491: hr_utility.set_location('Entering ' || l_proc,10);
492: hr_utility.set_location('Step ' || l_proc,20);
493: l_statutory_balance(1).balance_name := 'IE Taxable Pay';
494: l_statutory_balance(2).balance_name := 'IE Net Tax';
495: l_statutory_balance(3).balance_name := 'IE PRSI Employer';
496: l_statutory_balance(4).balance_name := 'IE PRSI Employee';
520: l_statutory_balance(15).balance_name := 'IE USCable Pay';
521: l_statutory_balance(16).balance_name := 'IE USC Balance';
522: l_statutory_balance(22).balance_name := 'IE P45 USC Pay';
523: l_statutory_balance(23).balance_name := 'IE P45 USC Deducted';
524: hr_utility.set_location('Step = ' || l_proc,30);
525: FOR l_index IN 1 .. l_max_stat_balance
526: LOOP
527: /* 7291676 */
528: l_statutory_balance_ppsn(l_index).balance_name:=l_statutory_balance(l_index).balance_name;
525: FOR l_index IN 1 .. l_max_stat_balance
526: LOOP
527: /* 7291676 */
528: l_statutory_balance_ppsn(l_index).balance_name:=l_statutory_balance(l_index).balance_name;
529: hr_utility.set_location(' PPSN Override balance_name = ' || l_statutory_balance_ppsn(l_index).balance_name,30);
530:
531: hr_utility.set_location('l_index = ' || l_index,30);
532: hr_utility.set_location('balance_name = ' || l_statutory_balance(l_index).balance_name,30);
533: hr_utility.set_location('l_dimension = ' || l_dimension,30);
527: /* 7291676 */
528: l_statutory_balance_ppsn(l_index).balance_name:=l_statutory_balance(l_index).balance_name;
529: hr_utility.set_location(' PPSN Override balance_name = ' || l_statutory_balance_ppsn(l_index).balance_name,30);
530:
531: hr_utility.set_location('l_index = ' || l_index,30);
532: hr_utility.set_location('balance_name = ' || l_statutory_balance(l_index).balance_name,30);
533: hr_utility.set_location('l_dimension = ' || l_dimension,30);
534: -- IF (l_index < 15) THEN -- Stores RUN balance_defined information -- Bug 5015438
535: IF (l_index < 17 ) THEN -- Bug 13359530
528: l_statutory_balance_ppsn(l_index).balance_name:=l_statutory_balance(l_index).balance_name;
529: hr_utility.set_location(' PPSN Override balance_name = ' || l_statutory_balance_ppsn(l_index).balance_name,30);
530:
531: hr_utility.set_location('l_index = ' || l_index,30);
532: hr_utility.set_location('balance_name = ' || l_statutory_balance(l_index).balance_name,30);
533: hr_utility.set_location('l_dimension = ' || l_dimension,30);
534: -- IF (l_index < 15) THEN -- Stores RUN balance_defined information -- Bug 5015438
535: IF (l_index < 17 ) THEN -- Bug 13359530
536: IF l_statutory_balance(l_index).balance_name in ('IE PRSI Insurable Weeks','IE PRSI K Term Insurable Weeks','IE PRSI M Term Insurable Weeks','IE PRSI_ClassA Insurable Weeks') THEN
529: hr_utility.set_location(' PPSN Override balance_name = ' || l_statutory_balance_ppsn(l_index).balance_name,30);
530:
531: hr_utility.set_location('l_index = ' || l_index,30);
532: hr_utility.set_location('balance_name = ' || l_statutory_balance(l_index).balance_name,30);
533: hr_utility.set_location('l_dimension = ' || l_dimension,30);
534: -- IF (l_index < 15) THEN -- Stores RUN balance_defined information -- Bug 5015438
535: IF (l_index < 17 ) THEN -- Bug 13359530
536: IF l_statutory_balance(l_index).balance_name in ('IE PRSI Insurable Weeks','IE PRSI K Term Insurable Weeks','IE PRSI M Term Insurable Weeks','IE PRSI_ClassA Insurable Weeks') THEN
537:
594: /* 7291676 to create a new balance table for assignments with PPSN override values */
595:
596: FOR l_index IN 1 .. l_max_stat_balance
597: LOOP
598: hr_utility.set_location('l_index = ' || l_index,30);
599: hr_utility.set_location('balance_name = ' || l_statutory_balance_ppsn(l_index).balance_name,30);
600: hr_utility.set_location('l_dimension_ppsn = ' || l_dimension_ppsn,30);
601: -- IF (l_index < 15) THEN -- Stores RUN balance_defined information -- Bug 5015438
602: IF (l_index < 17 ) THEN -- Bug 13359530
595:
596: FOR l_index IN 1 .. l_max_stat_balance
597: LOOP
598: hr_utility.set_location('l_index = ' || l_index,30);
599: hr_utility.set_location('balance_name = ' || l_statutory_balance_ppsn(l_index).balance_name,30);
600: hr_utility.set_location('l_dimension_ppsn = ' || l_dimension_ppsn,30);
601: -- IF (l_index < 15) THEN -- Stores RUN balance_defined information -- Bug 5015438
602: IF (l_index < 17 ) THEN -- Bug 13359530
603: IF l_statutory_balance_ppsn(l_index).balance_name in ('IE PRSI Insurable Weeks','IE PRSI K Term Insurable Weeks','IE PRSI M Term Insurable Weeks','IE PRSI_ClassA Insurable Weeks') THEN
596: FOR l_index IN 1 .. l_max_stat_balance
597: LOOP
598: hr_utility.set_location('l_index = ' || l_index,30);
599: hr_utility.set_location('balance_name = ' || l_statutory_balance_ppsn(l_index).balance_name,30);
600: hr_utility.set_location('l_dimension_ppsn = ' || l_dimension_ppsn,30);
601: -- IF (l_index < 15) THEN -- Stores RUN balance_defined information -- Bug 5015438
602: IF (l_index < 17 ) THEN -- Bug 13359530
603: IF l_statutory_balance_ppsn(l_index).balance_name in ('IE PRSI Insurable Weeks','IE PRSI K Term Insurable Weeks','IE PRSI M Term Insurable Weeks','IE PRSI_ClassA Insurable Weeks') THEN
604:
656:
657: END IF;
658: l_archive_index_ppsn := l_archive_index_ppsn + 1;
659: if(l_index<15) then
660: hr_utility.set_location('g_statutory_ppsn(l_max)'||g_statutory_balance_table_ppsn(l_max_stat_balance + l_index).defined_balance_id,40);
661: hr_utility.set_location('g_statutory_ppsn(l_max)'||g_statutory_balance_table_ppsn(l_max_stat_balance + l_index).balance_name,40);
662: end if;
663: hr_utility.set_location('g_statutory_ppsn(l_ind)'||g_statutory_balance_table_ppsn(l_index).defined_balance_id,40);
664: hr_utility.set_location('g_statutory_ppsn(l_ind)'||g_statutory_balance_table_ppsn(l_index).balance_name,40);
657: END IF;
658: l_archive_index_ppsn := l_archive_index_ppsn + 1;
659: if(l_index<15) then
660: hr_utility.set_location('g_statutory_ppsn(l_max)'||g_statutory_balance_table_ppsn(l_max_stat_balance + l_index).defined_balance_id,40);
661: hr_utility.set_location('g_statutory_ppsn(l_max)'||g_statutory_balance_table_ppsn(l_max_stat_balance + l_index).balance_name,40);
662: end if;
663: hr_utility.set_location('g_statutory_ppsn(l_ind)'||g_statutory_balance_table_ppsn(l_index).defined_balance_id,40);
664: hr_utility.set_location('g_statutory_ppsn(l_ind)'||g_statutory_balance_table_ppsn(l_index).balance_name,40);
665: END LOOP;
659: if(l_index<15) then
660: hr_utility.set_location('g_statutory_ppsn(l_max)'||g_statutory_balance_table_ppsn(l_max_stat_balance + l_index).defined_balance_id,40);
661: hr_utility.set_location('g_statutory_ppsn(l_max)'||g_statutory_balance_table_ppsn(l_max_stat_balance + l_index).balance_name,40);
662: end if;
663: hr_utility.set_location('g_statutory_ppsn(l_ind)'||g_statutory_balance_table_ppsn(l_index).defined_balance_id,40);
664: hr_utility.set_location('g_statutory_ppsn(l_ind)'||g_statutory_balance_table_ppsn(l_index).balance_name,40);
665: END LOOP;
666:
667: ---
660: hr_utility.set_location('g_statutory_ppsn(l_max)'||g_statutory_balance_table_ppsn(l_max_stat_balance + l_index).defined_balance_id,40);
661: hr_utility.set_location('g_statutory_ppsn(l_max)'||g_statutory_balance_table_ppsn(l_max_stat_balance + l_index).balance_name,40);
662: end if;
663: hr_utility.set_location('g_statutory_ppsn(l_ind)'||g_statutory_balance_table_ppsn(l_index).defined_balance_id,40);
664: hr_utility.set_location('g_statutory_ppsn(l_ind)'||g_statutory_balance_table_ppsn(l_index).balance_name,40);
665: END LOOP;
666:
667: ---
668: l_archive_index_ppsn := l_archive_index_ppsn - 1;
666:
667: ---
668: l_archive_index_ppsn := l_archive_index_ppsn - 1;
669: l_archive_index := l_archive_index - 1;
670: -- hr_utility.set_location('retrieving PER_PAYE_REF_PRSI_YTD bal_id for Insurable weeks',40); -- Bug 5015438
671: -- OPEN csr_balance_dimension('IE PRSI Insurable Weeks',l_dimension_1);
672: -- FETCH csr_balance_dimension INTO l_statutory_bal_id(l_archive_index).defined_balance_id;
673: -- CLOSE csr_balance_dimension;
674: -- g_statutory_balance_table(l_archive_index).defined_balance_id := l_statutory_bal_id(l_archive_index).defined_balance_id;
673: -- CLOSE csr_balance_dimension;
674: -- g_statutory_balance_table(l_archive_index).defined_balance_id := l_statutory_bal_id(l_archive_index).defined_balance_id;
675: -- g_statutory_balance_table(l_archive_index).balance_name := 'IE PRSI_ClassA Insurable Weeks';
676: -- g_statutory_balance_table(l_archive_index).database_item_suffix := l_dimension_1;
677: -- hr_utility.set_location('Step = ' || l_proc,40);
678: -- hr_utility.set_location('l_max_stat_balance = ' || l_max_stat_balance,40);
679: g_max_statutory_balance_index := l_archive_index;
680: -- hr_utility.set_location('Step ' || l_proc,50);
681: -- hr_utility.set_location('l_archive_index = ' || l_archive_index,50);
674: -- g_statutory_balance_table(l_archive_index).defined_balance_id := l_statutory_bal_id(l_archive_index).defined_balance_id;
675: -- g_statutory_balance_table(l_archive_index).balance_name := 'IE PRSI_ClassA Insurable Weeks';
676: -- g_statutory_balance_table(l_archive_index).database_item_suffix := l_dimension_1;
677: -- hr_utility.set_location('Step = ' || l_proc,40);
678: -- hr_utility.set_location('l_max_stat_balance = ' || l_max_stat_balance,40);
679: g_max_statutory_balance_index := l_archive_index;
680: -- hr_utility.set_location('Step ' || l_proc,50);
681: -- hr_utility.set_location('l_archive_index = ' || l_archive_index,50);
682: -- hr_utility.set_location('Leaving ' || l_proc,60);
676: -- g_statutory_balance_table(l_archive_index).database_item_suffix := l_dimension_1;
677: -- hr_utility.set_location('Step = ' || l_proc,40);
678: -- hr_utility.set_location('l_max_stat_balance = ' || l_max_stat_balance,40);
679: g_max_statutory_balance_index := l_archive_index;
680: -- hr_utility.set_location('Step ' || l_proc,50);
681: -- hr_utility.set_location('l_archive_index = ' || l_archive_index,50);
682: -- hr_utility.set_location('Leaving ' || l_proc,60);
683: END setup_standard_balance_table;
684: ---------------------------------------
677: -- hr_utility.set_location('Step = ' || l_proc,40);
678: -- hr_utility.set_location('l_max_stat_balance = ' || l_max_stat_balance,40);
679: g_max_statutory_balance_index := l_archive_index;
680: -- hr_utility.set_location('Step ' || l_proc,50);
681: -- hr_utility.set_location('l_archive_index = ' || l_archive_index,50);
682: -- hr_utility.set_location('Leaving ' || l_proc,60);
683: END setup_standard_balance_table;
684: ---------------------------------------
685:
678: -- hr_utility.set_location('l_max_stat_balance = ' || l_max_stat_balance,40);
679: g_max_statutory_balance_index := l_archive_index;
680: -- hr_utility.set_location('Step ' || l_proc,50);
681: -- hr_utility.set_location('l_archive_index = ' || l_archive_index,50);
682: -- hr_utility.set_location('Leaving ' || l_proc,60);
683: END setup_standard_balance_table;
684: ---------------------------------------
685:
686: PROCEDURE archinit (p_payroll_action_id IN NUMBER)
715: l_error varchar2(1) ;
716: BEGIN
717:
718:
719: hr_utility.set_location('Entering ' || l_proc,10);
720:
721: g_archive_pact := p_payroll_action_id;
722:
723: OPEN csr_archive_effective_date(p_payroll_action_id);
744: p_payroll_action_id => p_payroll_action_id
745: , p_token_name => 'BG_ID'
746: , p_token_value => l_bg_id);
747:
748: hr_utility.set_location('Step ' || l_proc,20);
749: hr_utility.set_location('g_paye_ref = ' || g_paye_ref,20);
750: hr_utility.set_location('l_end_date = ' || l_end_date,20);
751:
752: l_canonical_start_date := TO_DATE(l_start_date,'yyyy/mm/dd');
745: , p_token_name => 'BG_ID'
746: , p_token_value => l_bg_id);
747:
748: hr_utility.set_location('Step ' || l_proc,20);
749: hr_utility.set_location('g_paye_ref = ' || g_paye_ref,20);
750: hr_utility.set_location('l_end_date = ' || l_end_date,20);
751:
752: l_canonical_start_date := TO_DATE(l_start_date,'yyyy/mm/dd');
753: l_canonical_end_date := TO_DATE(l_end_date,'yyyy/mm/dd');
746: , p_token_value => l_bg_id);
747:
748: hr_utility.set_location('Step ' || l_proc,20);
749: hr_utility.set_location('g_paye_ref = ' || g_paye_ref,20);
750: hr_utility.set_location('l_end_date = ' || l_end_date,20);
751:
752: l_canonical_start_date := TO_DATE(l_start_date,'yyyy/mm/dd');
753: l_canonical_end_date := TO_DATE(l_end_date,'yyyy/mm/dd');
754:
755: -- Initialized g_archive_end_date to support Retry Option
756: g_archive_end_date := TO_DATE(l_end_date,'yyyy/mm/dd');
757: g_archive_start_date := l_canonical_start_date;
758:
759: hr_utility.set_location('l_canonical_start_date = ' || l_canonical_start_date,20);
760:
761:
762: -- retrieve ids for tax elements
763: hr_utility.set_location('stage 1',22);
759: hr_utility.set_location('l_canonical_start_date = ' || l_canonical_start_date,20);
760:
761:
762: -- retrieve ids for tax elements
763: hr_utility.set_location('stage 1',22);
764:
765: OPEN csr_input_value_id('IE PAYE details','Tax Basis');
766: FETCH csr_input_value_id INTO g_paye_details_element_id,
767: g_tax_basis_id;
817: FETCH csr_input_value_id INTO g_paye_details_element_id,
818: g_period_week_std_cutoff;
819: CLOSE csr_input_value_id;
820:
821: hr_utility.set_location('stage 2',23);
822: pay_ie_p45_archive.setup_standard_balance_table;
823:
824: hr_utility.set_location('stage 3',24);
825:
820:
821: hr_utility.set_location('stage 2',23);
822: pay_ie_p45_archive.setup_standard_balance_table;
823:
824: hr_utility.set_location('stage 3',24);
825:
826: -- hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
827: -- hr_utility.set_location('l_consolidation_set = ' || l_consolidation_set,20);
828: -- hr_utility.set_location('l_canonical_start_date = ' || l_canonical_start_date,20);
822: pay_ie_p45_archive.setup_standard_balance_table;
823:
824: hr_utility.set_location('stage 3',24);
825:
826: -- hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
827: -- hr_utility.set_location('l_consolidation_set = ' || l_consolidation_set,20);
828: -- hr_utility.set_location('l_canonical_start_date = ' || l_canonical_start_date,20);
829: -- hr_utility.set_location('l_canonical_end_date = ' || l_canonical_end_date,20);
830: hr_utility.set_location('Leaving ' || l_proc,20);
823:
824: hr_utility.set_location('stage 3',24);
825:
826: -- hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
827: -- hr_utility.set_location('l_consolidation_set = ' || l_consolidation_set,20);
828: -- hr_utility.set_location('l_canonical_start_date = ' || l_canonical_start_date,20);
829: -- hr_utility.set_location('l_canonical_end_date = ' || l_canonical_end_date,20);
830: hr_utility.set_location('Leaving ' || l_proc,20);
831: END archinit;
824: hr_utility.set_location('stage 3',24);
825:
826: -- hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
827: -- hr_utility.set_location('l_consolidation_set = ' || l_consolidation_set,20);
828: -- hr_utility.set_location('l_canonical_start_date = ' || l_canonical_start_date,20);
829: -- hr_utility.set_location('l_canonical_end_date = ' || l_canonical_end_date,20);
830: hr_utility.set_location('Leaving ' || l_proc,20);
831: END archinit;
832: --------------------------------------------------------------------
825:
826: -- hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
827: -- hr_utility.set_location('l_consolidation_set = ' || l_consolidation_set,20);
828: -- hr_utility.set_location('l_canonical_start_date = ' || l_canonical_start_date,20);
829: -- hr_utility.set_location('l_canonical_end_date = ' || l_canonical_end_date,20);
830: hr_utility.set_location('Leaving ' || l_proc,20);
831: END archinit;
832: --------------------------------------------------------------------
833:
826: -- hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
827: -- hr_utility.set_location('l_consolidation_set = ' || l_consolidation_set,20);
828: -- hr_utility.set_location('l_canonical_start_date = ' || l_canonical_start_date,20);
829: -- hr_utility.set_location('l_canonical_end_date = ' || l_canonical_end_date,20);
830: hr_utility.set_location('Leaving ' || l_proc,20);
831: END archinit;
832: --------------------------------------------------------------------
833:
834: PROCEDURE archive_employee_details (
1107: l_prsi_count NUMBER(1) := 0; --bug 4724788
1108: l_usc_tax_basis VARCHAR2(20);
1109: --
1110: BEGIN
1111: hr_utility.set_location('Entering ' || l_proc,10);
1112: -- call generic procedure to retrieve and archive all data for
1113: -- EMPLOYEE DETAILS, ADDRESS DETAILS and EMPLOYEE NET PAY DISTRIBUTION
1114: hr_utility.set_location('Calling pay_emp_action_arch',20);
1115:
1110: BEGIN
1111: hr_utility.set_location('Entering ' || l_proc,10);
1112: -- call generic procedure to retrieve and archive all data for
1113: -- EMPLOYEE DETAILS, ADDRESS DETAILS and EMPLOYEE NET PAY DISTRIBUTION
1114: hr_utility.set_location('Calling pay_emp_action_arch',20);
1115:
1116: pay_emp_action_arch.get_personal_information (
1117: p_payroll_action_id => g_archive_pact -- archive payroll_action_id
1118: , p_assactid => p_assactid -- archive assignment_action_id
1126: , p_tax_unit_id => g_paye_ref -- only required for US
1127: , p_time_period_id => p_time_period_id -- payroll time_period_id
1128: , p_ppp_source_action_id => NULL);
1129:
1130: hr_utility.set_location('Returned from pay_emp_action_arch',30);
1131:
1132: hr_utility.set_location('p_payroll_child_actid'||p_payroll_child_actid,30);
1133: hr_utility.set_location('p_ppsn_override_flag'||p_ppsn_override_flag,30);
1134: -- get the business group id
1128: , p_ppp_source_action_id => NULL);
1129:
1130: hr_utility.set_location('Returned from pay_emp_action_arch',30);
1131:
1132: hr_utility.set_location('p_payroll_child_actid'||p_payroll_child_actid,30);
1133: hr_utility.set_location('p_ppsn_override_flag'||p_ppsn_override_flag,30);
1134: -- get the business group id
1135: pay_ie_p45_archive.get_parameters (
1136: p_payroll_action_id => g_archive_pact
1129:
1130: hr_utility.set_location('Returned from pay_emp_action_arch',30);
1131:
1132: hr_utility.set_location('p_payroll_child_actid'||p_payroll_child_actid,30);
1133: hr_utility.set_location('p_ppsn_override_flag'||p_ppsn_override_flag,30);
1134: -- get the business group id
1135: pay_ie_p45_archive.get_parameters (
1136: p_payroll_action_id => g_archive_pact
1137: , p_token_name => 'BG_ID'
1136: p_payroll_action_id => g_archive_pact
1137: , p_token_name => 'BG_ID'
1138: , p_token_value => l_bg_id);
1139:
1140: hr_utility.set_location('p_run_assignment_action_id ='||p_payroll_child_actid,40);
1141:
1142: -- get tax basis
1143: hr_utility.set_location('g_tax_basis_id ='||g_tax_basis_id,40);
1144: -- Bug 5386432, since for terminated which does not have any element attached with FPD
1139:
1140: hr_utility.set_location('p_run_assignment_action_id ='||p_payroll_child_actid,40);
1141:
1142: -- get tax basis
1143: hr_utility.set_location('g_tax_basis_id ='||g_tax_basis_id,40);
1144: -- Bug 5386432, since for terminated which does not have any element attached with FPD
1145: -- will have no child assignment actions. Call this only if child actions exists.
1146: IF p_payroll_child_actid IS NOT NULL THEN
1147: l_tax_basis := pay_ie_archive_detail_pkg.get_tax_details (
1148: p_run_assignment_action_id => p_payroll_child_actid
1149: ,p_input_value_id => g_tax_basis_id
1150: ,p_date_earned => to_char(p_date_earned, 'yyyy/mm/dd'));
1151: END IF;
1152: hr_utility.set_location('l_tax_basis = ' || l_tax_basis,40);
1153:
1154: -- get prsi classes
1155: hr_utility.set_location('g_prsi_cat_id ='||g_prsi_cat_id,40);
1156: -- check for supplementary run
1151: END IF;
1152: hr_utility.set_location('l_tax_basis = ' || l_tax_basis,40);
1153:
1154: -- get prsi classes
1155: hr_utility.set_location('g_prsi_cat_id ='||g_prsi_cat_id,40);
1156: -- check for supplementary run
1157: /*
1158: OPEN cur_supp_run;
1159: FETCH cur_supp_run INTO l_arch_run_count;
1157: /*
1158: OPEN cur_supp_run;
1159: FETCH cur_supp_run INTO l_arch_run_count;
1160: CLOSE cur_supp_run;
1161: hr_utility.set_location('l_arch_run_count ='||l_arch_run_count,40);
1162: -- if it is a supplementary run, archive only for the current run
1163: IF l_arch_run_count>1
1164: */
1165: /*
1198:
1199: if l_current_sequence is null then
1200: l_current_sequence := 0;
1201: end if;
1202: hr_utility.set_location('l_current_sequence..'||l_current_sequence,101);
1203: hr_utility.set_location('l_prev_sequence..'||l_prev_sequence,101);
1204:
1205:
1206: FOR assg_act_rec IN cur_payroll_assg_action
1199: if l_current_sequence is null then
1200: l_current_sequence := 0;
1201: end if;
1202: hr_utility.set_location('l_current_sequence..'||l_current_sequence,101);
1203: hr_utility.set_location('l_prev_sequence..'||l_prev_sequence,101);
1204:
1205:
1206: FOR assg_act_rec IN cur_payroll_assg_action
1207: LOOP
1208: l_prsi_cur_cat := pay_ie_archive_detail_pkg.get_tax_details (
1209: p_run_assignment_action_id => assg_act_rec.pay_assg_act_id
1210: ,p_input_value_id => g_prsi_cat_id
1211: ,p_date_earned => to_char(p_date_earned, 'yyyy/mm/dd'));
1212: hr_utility.set_location('l_prsi_cur_cat = ' || l_prsi_cur_cat,40);
1213:
1214: IF l_prsi_cur_cat IS NOT NULL AND l_prsi_cur_cat <>'A' AND (nvl(instr(l_prsi_cat,l_prsi_cur_cat),0) = 0)
1215: THEN
1216:
1215: THEN
1216:
1217: IF l_prsi_cat <> ' ' THEN
1218: -- Bug 3669639 Added a space after the comma so that the display is now uniform with spaces
1219: hr_utility.set_location('In if l_prsi_cur_cat = ' || l_prsi_cur_cat,41);
1220: open Cur_Act_Contexts(l_defined_balance_id,'IE_'||l_prsi_cur_cat);
1221: fetch Cur_Act_Contexts into l_class_weeks;
1222: CLOSE Cur_Act_Contexts;
1223: hr_utility.set_location('in if l_class_weeks ..'||l_class_weeks,101);
1219: hr_utility.set_location('In if l_prsi_cur_cat = ' || l_prsi_cur_cat,41);
1220: open Cur_Act_Contexts(l_defined_balance_id,'IE_'||l_prsi_cur_cat);
1221: fetch Cur_Act_Contexts into l_class_weeks;
1222: CLOSE Cur_Act_Contexts;
1223: hr_utility.set_location('in if l_class_weeks ..'||l_class_weeks,101);
1224: if nvl(l_class_weeks,0) > 0 then
1225: l_prsi_cat := l_prsi_cat||', '|| l_prsi_cur_cat;
1226: l_prsi_count := l_prsi_count + 1; --Bug 4724788
1227: end if;
1224: if nvl(l_class_weeks,0) > 0 then
1225: l_prsi_cat := l_prsi_cat||', '|| l_prsi_cur_cat;
1226: l_prsi_count := l_prsi_count + 1; --Bug 4724788
1227: end if;
1228: hr_utility.set_location('l_prsi_count = ' || l_prsi_count,420);
1229: --Bug 4724788
1230: if l_prsi_count = 2 then
1231: exit;
1232: end if;
1231: exit;
1232: end if;
1233: ELSE
1234: v_class := 'IE_'||l_prsi_cur_cat;
1235: hr_utility.set_location('before in else l_class_weeks ..'||l_class_weeks,101);
1236: hr_utility.set_location('before in else l_prsi_cur_cat ..'||l_prsi_cur_cat,101);
1237: hr_utility.set_location('v_class ..'||v_class,101);
1238: open Cur_Act_Contexts(l_defined_balance_id,v_class);
1239: fetch Cur_Act_Contexts into l_class_weeks;
1232: end if;
1233: ELSE
1234: v_class := 'IE_'||l_prsi_cur_cat;
1235: hr_utility.set_location('before in else l_class_weeks ..'||l_class_weeks,101);
1236: hr_utility.set_location('before in else l_prsi_cur_cat ..'||l_prsi_cur_cat,101);
1237: hr_utility.set_location('v_class ..'||v_class,101);
1238: open Cur_Act_Contexts(l_defined_balance_id,v_class);
1239: fetch Cur_Act_Contexts into l_class_weeks;
1240: CLOSE Cur_Act_Contexts;
1233: ELSE
1234: v_class := 'IE_'||l_prsi_cur_cat;
1235: hr_utility.set_location('before in else l_class_weeks ..'||l_class_weeks,101);
1236: hr_utility.set_location('before in else l_prsi_cur_cat ..'||l_prsi_cur_cat,101);
1237: hr_utility.set_location('v_class ..'||v_class,101);
1238: open Cur_Act_Contexts(l_defined_balance_id,v_class);
1239: fetch Cur_Act_Contexts into l_class_weeks;
1240: CLOSE Cur_Act_Contexts;
1241: hr_utility.set_location('in else l_class_weeks ..'||l_class_weeks,101);
1237: hr_utility.set_location('v_class ..'||v_class,101);
1238: open Cur_Act_Contexts(l_defined_balance_id,v_class);
1239: fetch Cur_Act_Contexts into l_class_weeks;
1240: CLOSE Cur_Act_Contexts;
1241: hr_utility.set_location('in else l_class_weeks ..'||l_class_weeks,101);
1242:
1243: if nvl(l_class_weeks,0) > 0 then
1244:
1245: l_prsi_cat :=l_prsi_cur_cat;
1242:
1243: if nvl(l_class_weeks,0) > 0 then
1244:
1245: l_prsi_cat :=l_prsi_cur_cat;
1246: hr_utility.set_location('In if else v_class = ' || v_class,42);
1247: end if;
1248: --exit;
1249: END IF;
1250: END IF;
1247: end if;
1248: --exit;
1249: END IF;
1250: END IF;
1251: hr_utility.set_location(' kal after if and else l_prsi_cat = ' || l_prsi_cat,40);
1252:
1253: END LOOP;
1254: hr_utility.set_location(' kal after loop l_prsi_cat = ' || l_prsi_cat,40);
1255: -- end bug 5591812
1250: END IF;
1251: hr_utility.set_location(' kal after if and else l_prsi_cat = ' || l_prsi_cat,40);
1252:
1253: END LOOP;
1254: hr_utility.set_location(' kal after loop l_prsi_cat = ' || l_prsi_cat,40);
1255: -- end bug 5591812
1256: -- END IF;
1257: hr_utility.set_location('g_prsi_subcat_id ='||g_prsi_subcat_id,40);
1258: -- Bug 5386432, since for terminated which does not have any element attached with FPD
1253: END LOOP;
1254: hr_utility.set_location(' kal after loop l_prsi_cat = ' || l_prsi_cat,40);
1255: -- end bug 5591812
1256: -- END IF;
1257: hr_utility.set_location('g_prsi_subcat_id ='||g_prsi_subcat_id,40);
1258: -- Bug 5386432, since for terminated which does not have any element attached with FPD
1259: -- will have no child assignment actions. Call this only if child actions exists.
1260: IF p_payroll_child_actid IS NOT NULL THEN
1261: l_prsi_subcat := pay_ie_archive_detail_pkg.get_tax_details (
1266: p_run_assignment_action_id => p_payroll_child_actid
1267: ,p_input_value_id => g_ins_weeks_id
1268: ,p_date_earned => to_char(p_date_earned, 'yyyy/mm/dd'));
1269: END IF;
1270: hr_utility.set_location('l_prsi_subcat = ' || l_prsi_subcat,40);
1271: hr_utility.set_location('g_ins_weeks_id ='||g_ins_weeks_id,40);
1272: hr_utility.set_location('l_ins_weeks = ' || l_ins_weeks,40);
1273:
1274: -- get tax credit and std rate cut off
1267: ,p_input_value_id => g_ins_weeks_id
1268: ,p_date_earned => to_char(p_date_earned, 'yyyy/mm/dd'));
1269: END IF;
1270: hr_utility.set_location('l_prsi_subcat = ' || l_prsi_subcat,40);
1271: hr_utility.set_location('g_ins_weeks_id ='||g_ins_weeks_id,40);
1272: hr_utility.set_location('l_ins_weeks = ' || l_ins_weeks,40);
1273:
1274: -- get tax credit and std rate cut off
1275: OPEN cur_period_type;
1268: ,p_date_earned => to_char(p_date_earned, 'yyyy/mm/dd'));
1269: END IF;
1270: hr_utility.set_location('l_prsi_subcat = ' || l_prsi_subcat,40);
1271: hr_utility.set_location('g_ins_weeks_id ='||g_ins_weeks_id,40);
1272: hr_utility.set_location('l_ins_weeks = ' || l_ins_weeks,40);
1273:
1274: -- get tax credit and std rate cut off
1275: OPEN cur_period_type;
1276: FETCH cur_period_type INTO l_period_type;
1344: l_weekly_std_rate_cutoff := l_period_weekly_std_cutoff;
1345: END IF;
1346: END IF;
1347:
1348: hr_utility.set_location('p_payroll_child_actid'|| p_payroll_child_actid,30);
1349: hr_utility.set_location('l_weekly_tax_credit'|| l_weekly_tax_credit,30);
1350: hr_utility.set_location('l_period_weekly_tax_credit'|| l_period_weekly_tax_credit,30);
1351: hr_utility.set_location('l_monthly_tax_credit'|| l_monthly_tax_credit,30);
1352: hr_utility.set_location('l_monthly_std_rate_cutoff'|| l_monthly_std_rate_cutoff,30);
1345: END IF;
1346: END IF;
1347:
1348: hr_utility.set_location('p_payroll_child_actid'|| p_payroll_child_actid,30);
1349: hr_utility.set_location('l_weekly_tax_credit'|| l_weekly_tax_credit,30);
1350: hr_utility.set_location('l_period_weekly_tax_credit'|| l_period_weekly_tax_credit,30);
1351: hr_utility.set_location('l_monthly_tax_credit'|| l_monthly_tax_credit,30);
1352: hr_utility.set_location('l_monthly_std_rate_cutoff'|| l_monthly_std_rate_cutoff,30);
1353: hr_utility.set_location('l_weekly_std_rate_cutoff'|| l_weekly_std_rate_cutoff,30);
1346: END IF;
1347:
1348: hr_utility.set_location('p_payroll_child_actid'|| p_payroll_child_actid,30);
1349: hr_utility.set_location('l_weekly_tax_credit'|| l_weekly_tax_credit,30);
1350: hr_utility.set_location('l_period_weekly_tax_credit'|| l_period_weekly_tax_credit,30);
1351: hr_utility.set_location('l_monthly_tax_credit'|| l_monthly_tax_credit,30);
1352: hr_utility.set_location('l_monthly_std_rate_cutoff'|| l_monthly_std_rate_cutoff,30);
1353: hr_utility.set_location('l_weekly_std_rate_cutoff'|| l_weekly_std_rate_cutoff,30);
1354: hr_utility.set_location('l_period_weekly_std_cutoff'|| l_period_weekly_std_cutoff,30);
1347:
1348: hr_utility.set_location('p_payroll_child_actid'|| p_payroll_child_actid,30);
1349: hr_utility.set_location('l_weekly_tax_credit'|| l_weekly_tax_credit,30);
1350: hr_utility.set_location('l_period_weekly_tax_credit'|| l_period_weekly_tax_credit,30);
1351: hr_utility.set_location('l_monthly_tax_credit'|| l_monthly_tax_credit,30);
1352: hr_utility.set_location('l_monthly_std_rate_cutoff'|| l_monthly_std_rate_cutoff,30);
1353: hr_utility.set_location('l_weekly_std_rate_cutoff'|| l_weekly_std_rate_cutoff,30);
1354: hr_utility.set_location('l_period_weekly_std_cutoff'|| l_period_weekly_std_cutoff,30);
1355: -- Bug 5386432, if no child assignment actions fetch values from
1348: hr_utility.set_location('p_payroll_child_actid'|| p_payroll_child_actid,30);
1349: hr_utility.set_location('l_weekly_tax_credit'|| l_weekly_tax_credit,30);
1350: hr_utility.set_location('l_period_weekly_tax_credit'|| l_period_weekly_tax_credit,30);
1351: hr_utility.set_location('l_monthly_tax_credit'|| l_monthly_tax_credit,30);
1352: hr_utility.set_location('l_monthly_std_rate_cutoff'|| l_monthly_std_rate_cutoff,30);
1353: hr_utility.set_location('l_weekly_std_rate_cutoff'|| l_weekly_std_rate_cutoff,30);
1354: hr_utility.set_location('l_period_weekly_std_cutoff'|| l_period_weekly_std_cutoff,30);
1355: -- Bug 5386432, if no child assignment actions fetch values from
1356: -- PAYE table.
1349: hr_utility.set_location('l_weekly_tax_credit'|| l_weekly_tax_credit,30);
1350: hr_utility.set_location('l_period_weekly_tax_credit'|| l_period_weekly_tax_credit,30);
1351: hr_utility.set_location('l_monthly_tax_credit'|| l_monthly_tax_credit,30);
1352: hr_utility.set_location('l_monthly_std_rate_cutoff'|| l_monthly_std_rate_cutoff,30);
1353: hr_utility.set_location('l_weekly_std_rate_cutoff'|| l_weekly_std_rate_cutoff,30);
1354: hr_utility.set_location('l_period_weekly_std_cutoff'|| l_period_weekly_std_cutoff,30);
1355: -- Bug 5386432, if no child assignment actions fetch values from
1356: -- PAYE table.
1357: IF p_payroll_child_actid IS NULL THEN
1350: hr_utility.set_location('l_period_weekly_tax_credit'|| l_period_weekly_tax_credit,30);
1351: hr_utility.set_location('l_monthly_tax_credit'|| l_monthly_tax_credit,30);
1352: hr_utility.set_location('l_monthly_std_rate_cutoff'|| l_monthly_std_rate_cutoff,30);
1353: hr_utility.set_location('l_weekly_std_rate_cutoff'|| l_weekly_std_rate_cutoff,30);
1354: hr_utility.set_location('l_period_weekly_std_cutoff'|| l_period_weekly_std_cutoff,30);
1355: -- Bug 5386432, if no child assignment actions fetch values from
1356: -- PAYE table.
1357: IF p_payroll_child_actid IS NULL THEN
1358: open csr_get_paye_details;
1397: l_usc_cutoff_1 := 0 ;
1398: l_usc_cutoff_2 := 0 ;
1399: END IF;
1400: -- end 5510536.
1401: hr_utility.set_location('l_tax_credit = ' || l_tax_credit,40);
1402: hr_utility.set_location('l_std_rate_cut_off = ' || l_std_rate_cut_off,40);
1403: IF l_tax_basis = 'C'
1404: THEN
1405: l_tax_basis_det := 'Cumulative';
1398: l_usc_cutoff_2 := 0 ;
1399: END IF;
1400: -- end 5510536.
1401: hr_utility.set_location('l_tax_credit = ' || l_tax_credit,40);
1402: hr_utility.set_location('l_std_rate_cut_off = ' || l_std_rate_cut_off,40);
1403: IF l_tax_basis = 'C'
1404: THEN
1405: l_tax_basis_det := 'Cumulative';
1406: ELSIF l_tax_basis = 'N'
1410: l_tax_basis_det := l_tax_basis;
1411: END IF;
1412:
1413: --get the date of birth and separate name
1414: hr_utility.set_location('V_assignment_id = ' || p_assignment_id,40);
1415: hr_utility.set_location('V_date_earned = ' || p_date_earned,40);
1416:
1417: OPEN cur_sep_name_dob(l_bg_id);
1418: FETCH cur_sep_name_dob INTO l_date_of_birth,l_first_name,l_last_name;
1411: END IF;
1412:
1413: --get the date of birth and separate name
1414: hr_utility.set_location('V_assignment_id = ' || p_assignment_id,40);
1415: hr_utility.set_location('V_date_earned = ' || p_date_earned,40);
1416:
1417: OPEN cur_sep_name_dob(l_bg_id);
1418: FETCH cur_sep_name_dob INTO l_date_of_birth,l_first_name,l_last_name;
1419: CLOSE cur_sep_name_dob;
1445: -- Bug 3669639 : Changed the code so that l_prsi_cat is now
1446: -- previous classes concatenated with K or M
1447: -- Bug 5386432, since for terminated which does not have any element attached with FPD
1448: -- will have no child assignment actions. Call this only if child actions exists.
1449: hr_utility.set_location(' kal before if l_prsi_cat = ' || l_prsi_cat,40);
1450: IF pay_act_id IS NOT NULL THEN
1451: if pay_balance_pkg.get_value(k_defined_balance_id,pay_act_id,g_paye_ref,null,null,null,null,null) > 0 and
1452: l_prsi_cat is not NULL and l_prsi_count <> 2 then --Bug 4724788
1453: l_prsi_cat := l_prsi_cat ||', K';
1463: l_prsi_cat is null then
1464: l_prsi_cat := 'M';
1465: end if;
1466: END IF;
1467: hr_utility.set_location(' kal after if l_prsi_cat = ' || l_prsi_cat,40);
1468:
1469: -- bug 5383808, Fetch value of latest hire date.
1470: --if p_last_p45_act IS NULL THEN
1471: OPEN comm_date_first;
1479:
1480:
1481:
1482: -- end bug 5383808
1483: hr_utility.set_location('Archiving IE EMPLOYEE DETAILS',50);
1484: pay_action_information_api.create_action_information (
1485: p_action_information_id => l_action_info_id
1486: , p_action_context_id => p_assactid
1487: , p_action_context_type => 'AAP'
1789: --6615117
1790: l_source_null_flag NUMBER:= 0;
1791:
1792: BEGIN
1793: -- hr_utility.trace_on(null,'P45');
1794: hr_utility.set_location('Entering ' || l_proc,10);
1795: hr_utility.set_location('Step ' || l_proc,20);
1796: hr_utility.set_location('p_action_context_id = ' || p_action_context_id,20);
1797: hr_utility.set_location('p_assignment_id = ' || p_assignment_id,20);
1790: l_source_null_flag NUMBER:= 0;
1791:
1792: BEGIN
1793: -- hr_utility.trace_on(null,'P45');
1794: hr_utility.set_location('Entering ' || l_proc,10);
1795: hr_utility.set_location('Step ' || l_proc,20);
1796: hr_utility.set_location('p_action_context_id = ' || p_action_context_id,20);
1797: hr_utility.set_location('p_assignment_id = ' || p_assignment_id,20);
1798: hr_utility.set_location('p_person_id = ' || p_person_id,20);
1791:
1792: BEGIN
1793: -- hr_utility.trace_on(null,'P45');
1794: hr_utility.set_location('Entering ' || l_proc,10);
1795: hr_utility.set_location('Step ' || l_proc,20);
1796: hr_utility.set_location('p_action_context_id = ' || p_action_context_id,20);
1797: hr_utility.set_location('p_assignment_id = ' || p_assignment_id,20);
1798: hr_utility.set_location('p_person_id = ' || p_person_id,20);
1799: hr_utility.set_location('p_source_id = ' || p_source_id,20);
1792: BEGIN
1793: -- hr_utility.trace_on(null,'P45');
1794: hr_utility.set_location('Entering ' || l_proc,10);
1795: hr_utility.set_location('Step ' || l_proc,20);
1796: hr_utility.set_location('p_action_context_id = ' || p_action_context_id,20);
1797: hr_utility.set_location('p_assignment_id = ' || p_assignment_id,20);
1798: hr_utility.set_location('p_person_id = ' || p_person_id,20);
1799: hr_utility.set_location('p_source_id = ' || p_source_id,20);
1800: hr_utility.set_location('p_effective_date = ' || p_effective_date,20);
1793: -- hr_utility.trace_on(null,'P45');
1794: hr_utility.set_location('Entering ' || l_proc,10);
1795: hr_utility.set_location('Step ' || l_proc,20);
1796: hr_utility.set_location('p_action_context_id = ' || p_action_context_id,20);
1797: hr_utility.set_location('p_assignment_id = ' || p_assignment_id,20);
1798: hr_utility.set_location('p_person_id = ' || p_person_id,20);
1799: hr_utility.set_location('p_source_id = ' || p_source_id,20);
1800: hr_utility.set_location('p_effective_date = ' || p_effective_date,20);
1801: hr_utility.set_location('p_balance = ' || p_balance,20);
1794: hr_utility.set_location('Entering ' || l_proc,10);
1795: hr_utility.set_location('Step ' || l_proc,20);
1796: hr_utility.set_location('p_action_context_id = ' || p_action_context_id,20);
1797: hr_utility.set_location('p_assignment_id = ' || p_assignment_id,20);
1798: hr_utility.set_location('p_person_id = ' || p_person_id,20);
1799: hr_utility.set_location('p_source_id = ' || p_source_id,20);
1800: hr_utility.set_location('p_effective_date = ' || p_effective_date,20);
1801: hr_utility.set_location('p_balance = ' || p_balance,20);
1802: hr_utility.set_location('p_dimension = ' || p_dimension,20);
1795: hr_utility.set_location('Step ' || l_proc,20);
1796: hr_utility.set_location('p_action_context_id = ' || p_action_context_id,20);
1797: hr_utility.set_location('p_assignment_id = ' || p_assignment_id,20);
1798: hr_utility.set_location('p_person_id = ' || p_person_id,20);
1799: hr_utility.set_location('p_source_id = ' || p_source_id,20);
1800: hr_utility.set_location('p_effective_date = ' || p_effective_date,20);
1801: hr_utility.set_location('p_balance = ' || p_balance,20);
1802: hr_utility.set_location('p_dimension = ' || p_dimension,20);
1803: hr_utility.set_location('p_defined_bal_id = ' || p_defined_bal_id,20);
1796: hr_utility.set_location('p_action_context_id = ' || p_action_context_id,20);
1797: hr_utility.set_location('p_assignment_id = ' || p_assignment_id,20);
1798: hr_utility.set_location('p_person_id = ' || p_person_id,20);
1799: hr_utility.set_location('p_source_id = ' || p_source_id,20);
1800: hr_utility.set_location('p_effective_date = ' || p_effective_date,20);
1801: hr_utility.set_location('p_balance = ' || p_balance,20);
1802: hr_utility.set_location('p_dimension = ' || p_dimension,20);
1803: hr_utility.set_location('p_defined_bal_id = ' || p_defined_bal_id,20);
1804: hr_utility.set_location('p_record_count = ' || p_record_count,20);
1797: hr_utility.set_location('p_assignment_id = ' || p_assignment_id,20);
1798: hr_utility.set_location('p_person_id = ' || p_person_id,20);
1799: hr_utility.set_location('p_source_id = ' || p_source_id,20);
1800: hr_utility.set_location('p_effective_date = ' || p_effective_date,20);
1801: hr_utility.set_location('p_balance = ' || p_balance,20);
1802: hr_utility.set_location('p_dimension = ' || p_dimension,20);
1803: hr_utility.set_location('p_defined_bal_id = ' || p_defined_bal_id,20);
1804: hr_utility.set_location('p_record_count = ' || p_record_count,20);
1805: hr_utility.set_location('p_termination_date = ' || p_termination_date,20);
1798: hr_utility.set_location('p_person_id = ' || p_person_id,20);
1799: hr_utility.set_location('p_source_id = ' || p_source_id,20);
1800: hr_utility.set_location('p_effective_date = ' || p_effective_date,20);
1801: hr_utility.set_location('p_balance = ' || p_balance,20);
1802: hr_utility.set_location('p_dimension = ' || p_dimension,20);
1803: hr_utility.set_location('p_defined_bal_id = ' || p_defined_bal_id,20);
1804: hr_utility.set_location('p_record_count = ' || p_record_count,20);
1805: hr_utility.set_location('p_termination_date = ' || p_termination_date,20);
1806: hr_utility.set_location('p_supp_flag = ' || p_supp_flag,20);
1799: hr_utility.set_location('p_source_id = ' || p_source_id,20);
1800: hr_utility.set_location('p_effective_date = ' || p_effective_date,20);
1801: hr_utility.set_location('p_balance = ' || p_balance,20);
1802: hr_utility.set_location('p_dimension = ' || p_dimension,20);
1803: hr_utility.set_location('p_defined_bal_id = ' || p_defined_bal_id,20);
1804: hr_utility.set_location('p_record_count = ' || p_record_count,20);
1805: hr_utility.set_location('p_termination_date = ' || p_termination_date,20);
1806: hr_utility.set_location('p_supp_flag = ' || p_supp_flag,20);
1807: hr_utility.set_location('p_last_p45_action = ' || p_last_p45_action,20);
1800: hr_utility.set_location('p_effective_date = ' || p_effective_date,20);
1801: hr_utility.set_location('p_balance = ' || p_balance,20);
1802: hr_utility.set_location('p_dimension = ' || p_dimension,20);
1803: hr_utility.set_location('p_defined_bal_id = ' || p_defined_bal_id,20);
1804: hr_utility.set_location('p_record_count = ' || p_record_count,20);
1805: hr_utility.set_location('p_termination_date = ' || p_termination_date,20);
1806: hr_utility.set_location('p_supp_flag = ' || p_supp_flag,20);
1807: hr_utility.set_location('p_last_p45_action = ' || p_last_p45_action,20);
1808: hr_utility.set_location('p_last_p45_pact = ' || p_last_p45_pact,20);
1801: hr_utility.set_location('p_balance = ' || p_balance,20);
1802: hr_utility.set_location('p_dimension = ' || p_dimension,20);
1803: hr_utility.set_location('p_defined_bal_id = ' || p_defined_bal_id,20);
1804: hr_utility.set_location('p_record_count = ' || p_record_count,20);
1805: hr_utility.set_location('p_termination_date = ' || p_termination_date,20);
1806: hr_utility.set_location('p_supp_flag = ' || p_supp_flag,20);
1807: hr_utility.set_location('p_last_p45_action = ' || p_last_p45_action,20);
1808: hr_utility.set_location('p_last_p45_pact = ' || p_last_p45_pact,20);
1809: hr_utility.set_location('p_prev_src_id = ' || p_prev_src_id,20);
1802: hr_utility.set_location('p_dimension = ' || p_dimension,20);
1803: hr_utility.set_location('p_defined_bal_id = ' || p_defined_bal_id,20);
1804: hr_utility.set_location('p_record_count = ' || p_record_count,20);
1805: hr_utility.set_location('p_termination_date = ' || p_termination_date,20);
1806: hr_utility.set_location('p_supp_flag = ' || p_supp_flag,20);
1807: hr_utility.set_location('p_last_p45_action = ' || p_last_p45_action,20);
1808: hr_utility.set_location('p_last_p45_pact = ' || p_last_p45_pact,20);
1809: hr_utility.set_location('p_prev_src_id = ' || p_prev_src_id,20);
1810:
1803: hr_utility.set_location('p_defined_bal_id = ' || p_defined_bal_id,20);
1804: hr_utility.set_location('p_record_count = ' || p_record_count,20);
1805: hr_utility.set_location('p_termination_date = ' || p_termination_date,20);
1806: hr_utility.set_location('p_supp_flag = ' || p_supp_flag,20);
1807: hr_utility.set_location('p_last_p45_action = ' || p_last_p45_action,20);
1808: hr_utility.set_location('p_last_p45_pact = ' || p_last_p45_pact,20);
1809: hr_utility.set_location('p_prev_src_id = ' || p_prev_src_id,20);
1810:
1811: IF p_balance = 'IE PRSI_ClassA Insurable Weeks'
1804: hr_utility.set_location('p_record_count = ' || p_record_count,20);
1805: hr_utility.set_location('p_termination_date = ' || p_termination_date,20);
1806: hr_utility.set_location('p_supp_flag = ' || p_supp_flag,20);
1807: hr_utility.set_location('p_last_p45_action = ' || p_last_p45_action,20);
1808: hr_utility.set_location('p_last_p45_pact = ' || p_last_p45_pact,20);
1809: hr_utility.set_location('p_prev_src_id = ' || p_prev_src_id,20);
1810:
1811: IF p_balance = 'IE PRSI_ClassA Insurable Weeks'
1812: THEN
1805: hr_utility.set_location('p_termination_date = ' || p_termination_date,20);
1806: hr_utility.set_location('p_supp_flag = ' || p_supp_flag,20);
1807: hr_utility.set_location('p_last_p45_action = ' || p_last_p45_action,20);
1808: hr_utility.set_location('p_last_p45_pact = ' || p_last_p45_pact,20);
1809: hr_utility.set_location('p_prev_src_id = ' || p_prev_src_id,20);
1810:
1811: IF p_balance = 'IE PRSI_ClassA Insurable Weeks'
1812: THEN
1813: --bug 5383808
1835: open csr_defined_bal_id('IE PRSI Insurable Weeks');
1836: FETCH csr_defined_bal_id into l_defined_id;
1837: CLOSE csr_defined_bal_id;
1838:
1839: hr_utility.set_location ('l_prev_sequence..'||l_prev_sequence,200);
1840: hr_utility.set_location ('l_current_sequence..'||l_current_sequence,200);
1841: hr_utility.set_location ('l_defined_id..'||l_defined_id,200);
1842: --Commented code for bug fix 3079945
1843: /*OPEN csr_iea_weeks(l_balance_type_id);
1836: FETCH csr_defined_bal_id into l_defined_id;
1837: CLOSE csr_defined_bal_id;
1838:
1839: hr_utility.set_location ('l_prev_sequence..'||l_prev_sequence,200);
1840: hr_utility.set_location ('l_current_sequence..'||l_current_sequence,200);
1841: hr_utility.set_location ('l_defined_id..'||l_defined_id,200);
1842: --Commented code for bug fix 3079945
1843: /*OPEN csr_iea_weeks(l_balance_type_id);
1844: FETCH csr_iea_weeks into l_balance_value;
1837: CLOSE csr_defined_bal_id;
1838:
1839: hr_utility.set_location ('l_prev_sequence..'||l_prev_sequence,200);
1840: hr_utility.set_location ('l_current_sequence..'||l_current_sequence,200);
1841: hr_utility.set_location ('l_defined_id..'||l_defined_id,200);
1842: --Commented code for bug fix 3079945
1843: /*OPEN csr_iea_weeks(l_balance_type_id);
1844: FETCH csr_iea_weeks into l_balance_value;
1845: CLOSE csr_iea_weeks; */
1864: l_ppsn_override:=null;
1865: OPEN csr_ppsn_override(p_assignment_id);
1866: FETCH csr_ppsn_override INTO l_ppsn_override;
1867: CLOSE csr_ppsn_override;
1868: hr_utility.set_location('PPSN Override value = ' || l_ppsn_override,200);
1869: IF l_ppsn_override IS NOT NULL THEN
1870: OPEN Cur_Act_Contexts_ppsn(l_defined_id,l_ppsn_override);
1871: FETCH Cur_Act_Contexts_ppsn into l_balance_value;
1872: CLOSE Cur_Act_Contexts_ppsn;
1889: null);
1890: l_balance_value := l_balance_value - l_p45_last_bal_value;
1891: END IF;*/
1892: l_balance_value := nvl(l_balance_value,0);
1893: hr_utility.set_location('IE PRSI_ClassA Insurable Weeks..'||l_balance_value,1000);
1894: IF p_supp_flag = 'Y' AND p_last_p45_action IS NOT NULL THEN
1895: open get_prev_ins_bal;
1896: FETCH get_prev_ins_bal into l_pre_ins_bal;
1897: CLOSE get_prev_ins_bal;
1896: FETCH get_prev_ins_bal into l_pre_ins_bal;
1897: CLOSE get_prev_ins_bal;
1898: l_balance_value := l_balance_value + l_pre_ins_bal;
1899: END IF;
1900: hr_utility.set_location('After IE PRSI_ClassA Insurable Weeks..'||l_pre_ins_bal,1000.1);
1901: ELSE
1902: /* l_balance_value := PAY_BALANCE_PKG.GET_VALUE(p_defined_bal_id,
1903: p_source_id );
1904: */
1995: + l_prsa_er_contr; --13013273
1996: END IF;
1997: -- end bug 13513882
1998:
1999: hr_utility.set_location('sg Supp Flag ='||p_supp_flag,36);
2000: hr_utility.set_location('sg Last P45 Action ='||p_last_p45_action,37);
2001:
2002: --bug 5383808
2003: IF (p_balance like 'IE Taxable Pay') AND (nvl(p_supp_flag,'N') = 'N') AND (p_last_p45_action IS NOT NULL) THEN
1996: END IF;
1997: -- end bug 13513882
1998:
1999: hr_utility.set_location('sg Supp Flag ='||p_supp_flag,36);
2000: hr_utility.set_location('sg Last P45 Action ='||p_last_p45_action,37);
2001:
2002: --bug 5383808
2003: IF (p_balance like 'IE Taxable Pay') AND (nvl(p_supp_flag,'N') = 'N') AND (p_last_p45_action IS NOT NULL) THEN
2004: l_p45_last_bal_value := PAY_BALANCE_PKG.GET_VALUE(p_defined_bal_id,
2009: null,
2010: null,
2011: null);
2012:
2013: hr_utility.set_location('before IE Taxable Pay '||l_balance_value,204);
2014: hr_utility.set_location('before IE Taxable Pay '||l_p45_last_bal_value,205);
2015: hr_utility.set_location('p_last_p45_action '||p_last_p45_action,206);
2016: hr_utility.set_location('p_defined_bal_id '||p_defined_bal_id,207);
2017: --l_balance_value := l_balance_value - l_p45_last_bal_value;
2010: null,
2011: null);
2012:
2013: hr_utility.set_location('before IE Taxable Pay '||l_balance_value,204);
2014: hr_utility.set_location('before IE Taxable Pay '||l_p45_last_bal_value,205);
2015: hr_utility.set_location('p_last_p45_action '||p_last_p45_action,206);
2016: hr_utility.set_location('p_defined_bal_id '||p_defined_bal_id,207);
2017: --l_balance_value := l_balance_value - l_p45_last_bal_value;
2018: --6615117
2011: null);
2012:
2013: hr_utility.set_location('before IE Taxable Pay '||l_balance_value,204);
2014: hr_utility.set_location('before IE Taxable Pay '||l_p45_last_bal_value,205);
2015: hr_utility.set_location('p_last_p45_action '||p_last_p45_action,206);
2016: hr_utility.set_location('p_defined_bal_id '||p_defined_bal_id,207);
2017: --l_balance_value := l_balance_value - l_p45_last_bal_value;
2018: --6615117
2019: IF l_source_null_flag = 1 THEN
2012:
2013: hr_utility.set_location('before IE Taxable Pay '||l_balance_value,204);
2014: hr_utility.set_location('before IE Taxable Pay '||l_p45_last_bal_value,205);
2015: hr_utility.set_location('p_last_p45_action '||p_last_p45_action,206);
2016: hr_utility.set_location('p_defined_bal_id '||p_defined_bal_id,207);
2017: --l_balance_value := l_balance_value - l_p45_last_bal_value;
2018: --6615117
2019: IF l_source_null_flag = 1 THEN
2020: l_balance_value:= l_balance_value;
2340:
2341: -- end changes made for PRSI
2342:
2343: --end bug 5383808
2344: hr_utility.set_location('l_balance_value = ' || l_balance_value,20);
2345:
2346: IF p_record_count = 0
2347: THEN
2348: l_record_count := NULL;
2351: END IF;
2352:
2353: IF l_balance_value <> 0
2354: THEN
2355: hr_utility.set_location('Archiving EMEA BALANCES',20);
2356: pay_action_information_api.create_action_information (
2357: p_action_information_id => l_action_info_id
2358: , p_action_context_id => p_action_context_id
2359: , p_action_context_type => 'AAP'
2369: , p_action_information4 => l_balance_value
2370: , p_action_information5 => l_record_count);
2371: END IF;
2372:
2373: hr_utility.set_location('Leaving ' || l_proc,30);
2374: EXCEPTION
2375: WHEN NO_DATA_FOUND
2376: THEN
2377: NULL;
2453: l_balance_type_id NUMBER;
2454: l_balance_value1 NUMBER:=0;
2455: l_prev_source_id number;
2456: BEGIN
2457: hr_utility.set_location('Entering ' || l_proc,10);
2458: hr_utility.set_location('Step ' || l_proc,20);
2459: hr_utility.set_location('p_action_context_id = ' || p_action_context_id,20); /* 7291676 */
2460: hr_utility.set_location('p_assignment_id = ' || p_assignment_id,20);
2461: hr_utility.set_location('p_person_id = ' || p_person_id,20);
2454: l_balance_value1 NUMBER:=0;
2455: l_prev_source_id number;
2456: BEGIN
2457: hr_utility.set_location('Entering ' || l_proc,10);
2458: hr_utility.set_location('Step ' || l_proc,20);
2459: hr_utility.set_location('p_action_context_id = ' || p_action_context_id,20); /* 7291676 */
2460: hr_utility.set_location('p_assignment_id = ' || p_assignment_id,20);
2461: hr_utility.set_location('p_person_id = ' || p_person_id,20);
2462: hr_utility.set_location('p_source_id = ' || p_source_id,20);
2455: l_prev_source_id number;
2456: BEGIN
2457: hr_utility.set_location('Entering ' || l_proc,10);
2458: hr_utility.set_location('Step ' || l_proc,20);
2459: hr_utility.set_location('p_action_context_id = ' || p_action_context_id,20); /* 7291676 */
2460: hr_utility.set_location('p_assignment_id = ' || p_assignment_id,20);
2461: hr_utility.set_location('p_person_id = ' || p_person_id,20);
2462: hr_utility.set_location('p_source_id = ' || p_source_id,20);
2463: hr_utility.set_location('p_balance = ' || p_balance,20);
2456: BEGIN
2457: hr_utility.set_location('Entering ' || l_proc,10);
2458: hr_utility.set_location('Step ' || l_proc,20);
2459: hr_utility.set_location('p_action_context_id = ' || p_action_context_id,20); /* 7291676 */
2460: hr_utility.set_location('p_assignment_id = ' || p_assignment_id,20);
2461: hr_utility.set_location('p_person_id = ' || p_person_id,20);
2462: hr_utility.set_location('p_source_id = ' || p_source_id,20);
2463: hr_utility.set_location('p_balance = ' || p_balance,20);
2464: hr_utility.set_location('p_dimension = ' || p_dimension,20);
2457: hr_utility.set_location('Entering ' || l_proc,10);
2458: hr_utility.set_location('Step ' || l_proc,20);
2459: hr_utility.set_location('p_action_context_id = ' || p_action_context_id,20); /* 7291676 */
2460: hr_utility.set_location('p_assignment_id = ' || p_assignment_id,20);
2461: hr_utility.set_location('p_person_id = ' || p_person_id,20);
2462: hr_utility.set_location('p_source_id = ' || p_source_id,20);
2463: hr_utility.set_location('p_balance = ' || p_balance,20);
2464: hr_utility.set_location('p_dimension = ' || p_dimension,20);
2465: hr_utility.set_location('p_defined_bal_id = ' || p_defined_bal_id,20);
2458: hr_utility.set_location('Step ' || l_proc,20);
2459: hr_utility.set_location('p_action_context_id = ' || p_action_context_id,20); /* 7291676 */
2460: hr_utility.set_location('p_assignment_id = ' || p_assignment_id,20);
2461: hr_utility.set_location('p_person_id = ' || p_person_id,20);
2462: hr_utility.set_location('p_source_id = ' || p_source_id,20);
2463: hr_utility.set_location('p_balance = ' || p_balance,20);
2464: hr_utility.set_location('p_dimension = ' || p_dimension,20);
2465: hr_utility.set_location('p_defined_bal_id = ' || p_defined_bal_id,20);
2466:
2459: hr_utility.set_location('p_action_context_id = ' || p_action_context_id,20); /* 7291676 */
2460: hr_utility.set_location('p_assignment_id = ' || p_assignment_id,20);
2461: hr_utility.set_location('p_person_id = ' || p_person_id,20);
2462: hr_utility.set_location('p_source_id = ' || p_source_id,20);
2463: hr_utility.set_location('p_balance = ' || p_balance,20);
2464: hr_utility.set_location('p_dimension = ' || p_dimension,20);
2465: hr_utility.set_location('p_defined_bal_id = ' || p_defined_bal_id,20);
2466:
2467: hr_utility.set_location('p_last_p45_action = ' || p_last_p45_action,20);
2460: hr_utility.set_location('p_assignment_id = ' || p_assignment_id,20);
2461: hr_utility.set_location('p_person_id = ' || p_person_id,20);
2462: hr_utility.set_location('p_source_id = ' || p_source_id,20);
2463: hr_utility.set_location('p_balance = ' || p_balance,20);
2464: hr_utility.set_location('p_dimension = ' || p_dimension,20);
2465: hr_utility.set_location('p_defined_bal_id = ' || p_defined_bal_id,20);
2466:
2467: hr_utility.set_location('p_last_p45_action = ' || p_last_p45_action,20);
2468: hr_utility.set_location('p_action_context_id = ' || p_action_context_id,20);
2461: hr_utility.set_location('p_person_id = ' || p_person_id,20);
2462: hr_utility.set_location('p_source_id = ' || p_source_id,20);
2463: hr_utility.set_location('p_balance = ' || p_balance,20);
2464: hr_utility.set_location('p_dimension = ' || p_dimension,20);
2465: hr_utility.set_location('p_defined_bal_id = ' || p_defined_bal_id,20);
2466:
2467: hr_utility.set_location('p_last_p45_action = ' || p_last_p45_action,20);
2468: hr_utility.set_location('p_action_context_id = ' || p_action_context_id,20);
2469: hr_utility.set_location('p_last_p45_pact = ' || p_last_p45_pact,20);
2463: hr_utility.set_location('p_balance = ' || p_balance,20);
2464: hr_utility.set_location('p_dimension = ' || p_dimension,20);
2465: hr_utility.set_location('p_defined_bal_id = ' || p_defined_bal_id,20);
2466:
2467: hr_utility.set_location('p_last_p45_action = ' || p_last_p45_action,20);
2468: hr_utility.set_location('p_action_context_id = ' || p_action_context_id,20);
2469: hr_utility.set_location('p_last_p45_pact = ' || p_last_p45_pact,20);
2470: hr_utility.set_location('p_ytd_balance = ' || p_ytd_balance,20);
2471: hr_utility.set_location('p_ytd_def_bal_id = ' || p_ytd_def_bal_id,20);
2464: hr_utility.set_location('p_dimension = ' || p_dimension,20);
2465: hr_utility.set_location('p_defined_bal_id = ' || p_defined_bal_id,20);
2466:
2467: hr_utility.set_location('p_last_p45_action = ' || p_last_p45_action,20);
2468: hr_utility.set_location('p_action_context_id = ' || p_action_context_id,20);
2469: hr_utility.set_location('p_last_p45_pact = ' || p_last_p45_pact,20);
2470: hr_utility.set_location('p_ytd_balance = ' || p_ytd_balance,20);
2471: hr_utility.set_location('p_ytd_def_bal_id = ' || p_ytd_def_bal_id,20);
2472:
2465: hr_utility.set_location('p_defined_bal_id = ' || p_defined_bal_id,20);
2466:
2467: hr_utility.set_location('p_last_p45_action = ' || p_last_p45_action,20);
2468: hr_utility.set_location('p_action_context_id = ' || p_action_context_id,20);
2469: hr_utility.set_location('p_last_p45_pact = ' || p_last_p45_pact,20);
2470: hr_utility.set_location('p_ytd_balance = ' || p_ytd_balance,20);
2471: hr_utility.set_location('p_ytd_def_bal_id = ' || p_ytd_def_bal_id,20);
2472:
2473: OPEN csr_get_curr_val(p_action_context_id,p_ytd_def_bal_id);
2466:
2467: hr_utility.set_location('p_last_p45_action = ' || p_last_p45_action,20);
2468: hr_utility.set_location('p_action_context_id = ' || p_action_context_id,20);
2469: hr_utility.set_location('p_last_p45_pact = ' || p_last_p45_pact,20);
2470: hr_utility.set_location('p_ytd_balance = ' || p_ytd_balance,20);
2471: hr_utility.set_location('p_ytd_def_bal_id = ' || p_ytd_def_bal_id,20);
2472:
2473: OPEN csr_get_curr_val(p_action_context_id,p_ytd_def_bal_id);
2474: FETCH csr_get_curr_val INTO l_balance_value;
2467: hr_utility.set_location('p_last_p45_action = ' || p_last_p45_action,20);
2468: hr_utility.set_location('p_action_context_id = ' || p_action_context_id,20);
2469: hr_utility.set_location('p_last_p45_pact = ' || p_last_p45_pact,20);
2470: hr_utility.set_location('p_ytd_balance = ' || p_ytd_balance,20);
2471: hr_utility.set_location('p_ytd_def_bal_id = ' || p_ytd_def_bal_id,20);
2472:
2473: OPEN csr_get_curr_val(p_action_context_id,p_ytd_def_bal_id);
2474: FETCH csr_get_curr_val INTO l_balance_value;
2475: CLOSE csr_get_curr_val;
2472:
2473: OPEN csr_get_curr_val(p_action_context_id,p_ytd_def_bal_id);
2474: FETCH csr_get_curr_val INTO l_balance_value;
2475: CLOSE csr_get_curr_val;
2476: hr_utility.set_location('l_balance_value = ' || l_balance_value,20);
2477:
2478: -- l_balance_value := get_arc_bal_value(p_action_context_id,p_ytd_balance);
2479:
2480: IF p_last_p45_action IS NOT NULL THEN
2577: --end bug 14215867
2578:
2579: END IF;
2580: END IF;
2581: hr_utility.set_location('l_balance_value1 = ' || l_balance_value1,20);
2582:
2583: l_balance_value := l_balance_value - l_balance_value1;
2584:
2585: IF p_record_count = 0
2589: l_record_count := p_record_count + 1;
2590: END IF;
2591: IF l_balance_value <> 0
2592: THEN
2593: hr_utility.set_location('Archiving EMEA BALANCES',20);
2594: pay_action_information_api.create_action_information (
2595: p_action_information_id => l_action_info_id
2596: , p_action_context_id => p_action_context_id
2597: , p_action_context_type => 'AAP'
2606: , p_action_information3 => NULL
2607: , p_action_information4 => l_balance_value
2608: , p_action_information5 => l_record_count);
2609: END IF;
2610: hr_utility.set_location('Leaving ' || l_proc,30);
2611: EXCEPTION
2612: WHEN NO_DATA_FOUND
2613: THEN
2614: NULL;
2704: l_asg_end_date DATE;
2705: l_last_end_date DATE;
2706:
2707: BEGIN
2708: hr_utility.set_location('Entering ' || l_proc,20);
2709: hr_utility.set_location('Step ' || l_proc,20);
2710: hr_utility.set_location('p_action_context_id = ' || p_action_context_id,20);
2711: hr_utility.set_location('p_assignment_id = ' || p_assignment_id,20);
2712: hr_utility.set_location('p_person_id = ' || p_person_id,20);
2705: l_last_end_date DATE;
2706:
2707: BEGIN
2708: hr_utility.set_location('Entering ' || l_proc,20);
2709: hr_utility.set_location('Step ' || l_proc,20);
2710: hr_utility.set_location('p_action_context_id = ' || p_action_context_id,20);
2711: hr_utility.set_location('p_assignment_id = ' || p_assignment_id,20);
2712: hr_utility.set_location('p_person_id = ' || p_person_id,20);
2713: hr_utility.set_location('g_paye_ref = ' || g_paye_ref,20);
2706:
2707: BEGIN
2708: hr_utility.set_location('Entering ' || l_proc,20);
2709: hr_utility.set_location('Step ' || l_proc,20);
2710: hr_utility.set_location('p_action_context_id = ' || p_action_context_id,20);
2711: hr_utility.set_location('p_assignment_id = ' || p_assignment_id,20);
2712: hr_utility.set_location('p_person_id = ' || p_person_id,20);
2713: hr_utility.set_location('g_paye_ref = ' || g_paye_ref,20);
2714: hr_utility.set_location('p_termination_date = ' || p_termination_date,20);
2707: BEGIN
2708: hr_utility.set_location('Entering ' || l_proc,20);
2709: hr_utility.set_location('Step ' || l_proc,20);
2710: hr_utility.set_location('p_action_context_id = ' || p_action_context_id,20);
2711: hr_utility.set_location('p_assignment_id = ' || p_assignment_id,20);
2712: hr_utility.set_location('p_person_id = ' || p_person_id,20);
2713: hr_utility.set_location('g_paye_ref = ' || g_paye_ref,20);
2714: hr_utility.set_location('p_termination_date = ' || p_termination_date,20);
2715:
2708: hr_utility.set_location('Entering ' || l_proc,20);
2709: hr_utility.set_location('Step ' || l_proc,20);
2710: hr_utility.set_location('p_action_context_id = ' || p_action_context_id,20);
2711: hr_utility.set_location('p_assignment_id = ' || p_assignment_id,20);
2712: hr_utility.set_location('p_person_id = ' || p_person_id,20);
2713: hr_utility.set_location('g_paye_ref = ' || g_paye_ref,20);
2714: hr_utility.set_location('p_termination_date = ' || p_termination_date,20);
2715:
2716:
2709: hr_utility.set_location('Step ' || l_proc,20);
2710: hr_utility.set_location('p_action_context_id = ' || p_action_context_id,20);
2711: hr_utility.set_location('p_assignment_id = ' || p_assignment_id,20);
2712: hr_utility.set_location('p_person_id = ' || p_person_id,20);
2713: hr_utility.set_location('g_paye_ref = ' || g_paye_ref,20);
2714: hr_utility.set_location('p_termination_date = ' || p_termination_date,20);
2715:
2716:
2717:
2710: hr_utility.set_location('p_action_context_id = ' || p_action_context_id,20);
2711: hr_utility.set_location('p_assignment_id = ' || p_assignment_id,20);
2712: hr_utility.set_location('p_person_id = ' || p_person_id,20);
2713: hr_utility.set_location('g_paye_ref = ' || g_paye_ref,20);
2714: hr_utility.set_location('p_termination_date = ' || p_termination_date,20);
2715:
2716:
2717:
2718: -- get deceased flag, date of leaving
2723: -- Copied to out variable (5600150)
2724: p_deceased_flag := l_deceased_flg;
2725:
2726: l_asg_end_date := l_termination_date;
2727: hr_utility.set_location('l_termination_date = ' || l_termination_date,21);
2728:
2729: /* If employee is not terminated using end employment check for asg end date */
2730: IF l_termination_date IS NULL THEN
2731: /* Get End Date of Employement with Employer */
2736: OPEN cur_get_asg_end_date;
2737: FETCH cur_get_asg_end_date INTO l_asg_end_date;
2738: CLOSE cur_get_asg_end_date;
2739: END IF;
2740: hr_utility.set_location('l_termination_date = ' || l_termination_date,22);
2741: p_termination_date := l_termination_date;
2742: OPEN cur_supp_run;
2743: FETCH cur_supp_run INTO l_last_end_date;
2744: hr_utility.set_location('l_last_end_date = '|| l_last_end_date,20);
2740: hr_utility.set_location('l_termination_date = ' || l_termination_date,22);
2741: p_termination_date := l_termination_date;
2742: OPEN cur_supp_run;
2743: FETCH cur_supp_run INTO l_last_end_date;
2744: hr_utility.set_location('l_last_end_date = '|| l_last_end_date,20);
2745: IF l_last_end_date IS NOT NULL THEN
2746: --IF l_report_type_count >= 1 THEN
2747: p_supp_pymt_date := p_date_earned;
2748: p_supp_flag:= 'Y';
2989:
2990: cur_next_of_kin_details_rec cur_next_of_kin_details%rowtype;
2991: BEGIN
2992: --
2993: hr_utility.set_location('Entering ' || l_proc,20);
2994: hr_utility.set_location('Step ' || l_proc,20);
2995: hr_utility.set_location('p_action_context_id = ' || p_action_context_id,20);
2996: hr_utility.set_location('p_payroll_id = ' || p_payroll_id,20);
2997: hr_utility.set_location('p_assignment_id = ' || p_assignment_id,20);
2990: cur_next_of_kin_details_rec cur_next_of_kin_details%rowtype;
2991: BEGIN
2992: --
2993: hr_utility.set_location('Entering ' || l_proc,20);
2994: hr_utility.set_location('Step ' || l_proc,20);
2995: hr_utility.set_location('p_action_context_id = ' || p_action_context_id,20);
2996: hr_utility.set_location('p_payroll_id = ' || p_payroll_id,20);
2997: hr_utility.set_location('p_assignment_id = ' || p_assignment_id,20);
2998: hr_utility.set_location('p_person_id = ' || p_person_id,20);
2991: BEGIN
2992: --
2993: hr_utility.set_location('Entering ' || l_proc,20);
2994: hr_utility.set_location('Step ' || l_proc,20);
2995: hr_utility.set_location('p_action_context_id = ' || p_action_context_id,20);
2996: hr_utility.set_location('p_payroll_id = ' || p_payroll_id,20);
2997: hr_utility.set_location('p_assignment_id = ' || p_assignment_id,20);
2998: hr_utility.set_location('p_person_id = ' || p_person_id,20);
2999: hr_utility.set_location('g_paye_ref = ' || g_paye_ref,20);
2992: --
2993: hr_utility.set_location('Entering ' || l_proc,20);
2994: hr_utility.set_location('Step ' || l_proc,20);
2995: hr_utility.set_location('p_action_context_id = ' || p_action_context_id,20);
2996: hr_utility.set_location('p_payroll_id = ' || p_payroll_id,20);
2997: hr_utility.set_location('p_assignment_id = ' || p_assignment_id,20);
2998: hr_utility.set_location('p_person_id = ' || p_person_id,20);
2999: hr_utility.set_location('g_paye_ref = ' || g_paye_ref,20);
3000: hr_utility.set_location('p_date_earned = ' || p_date_earned,20);
2993: hr_utility.set_location('Entering ' || l_proc,20);
2994: hr_utility.set_location('Step ' || l_proc,20);
2995: hr_utility.set_location('p_action_context_id = ' || p_action_context_id,20);
2996: hr_utility.set_location('p_payroll_id = ' || p_payroll_id,20);
2997: hr_utility.set_location('p_assignment_id = ' || p_assignment_id,20);
2998: hr_utility.set_location('p_person_id = ' || p_person_id,20);
2999: hr_utility.set_location('g_paye_ref = ' || g_paye_ref,20);
3000: hr_utility.set_location('p_date_earned = ' || p_date_earned,20);
3001: hr_utility.set_location('p_child_run_ass_act_id = ' || p_child_run_ass_act_id,20);
2994: hr_utility.set_location('Step ' || l_proc,20);
2995: hr_utility.set_location('p_action_context_id = ' || p_action_context_id,20);
2996: hr_utility.set_location('p_payroll_id = ' || p_payroll_id,20);
2997: hr_utility.set_location('p_assignment_id = ' || p_assignment_id,20);
2998: hr_utility.set_location('p_person_id = ' || p_person_id,20);
2999: hr_utility.set_location('g_paye_ref = ' || g_paye_ref,20);
3000: hr_utility.set_location('p_date_earned = ' || p_date_earned,20);
3001: hr_utility.set_location('p_child_run_ass_act_id = ' || p_child_run_ass_act_id,20);
3002:
2995: hr_utility.set_location('p_action_context_id = ' || p_action_context_id,20);
2996: hr_utility.set_location('p_payroll_id = ' || p_payroll_id,20);
2997: hr_utility.set_location('p_assignment_id = ' || p_assignment_id,20);
2998: hr_utility.set_location('p_person_id = ' || p_person_id,20);
2999: hr_utility.set_location('g_paye_ref = ' || g_paye_ref,20);
3000: hr_utility.set_location('p_date_earned = ' || p_date_earned,20);
3001: hr_utility.set_location('p_child_run_ass_act_id = ' || p_child_run_ass_act_id,20);
3002:
3003:
2996: hr_utility.set_location('p_payroll_id = ' || p_payroll_id,20);
2997: hr_utility.set_location('p_assignment_id = ' || p_assignment_id,20);
2998: hr_utility.set_location('p_person_id = ' || p_person_id,20);
2999: hr_utility.set_location('g_paye_ref = ' || g_paye_ref,20);
3000: hr_utility.set_location('p_date_earned = ' || p_date_earned,20);
3001: hr_utility.set_location('p_child_run_ass_act_id = ' || p_child_run_ass_act_id,20);
3002:
3003:
3004: -- get deceased flag, date of leaving
2997: hr_utility.set_location('p_assignment_id = ' || p_assignment_id,20);
2998: hr_utility.set_location('p_person_id = ' || p_person_id,20);
2999: hr_utility.set_location('g_paye_ref = ' || g_paye_ref,20);
3000: hr_utility.set_location('p_date_earned = ' || p_date_earned,20);
3001: hr_utility.set_location('p_child_run_ass_act_id = ' || p_child_run_ass_act_id,20);
3002:
3003:
3004: -- get deceased flag, date of leaving
3005: /* OPEN cur_service_leave;
3023: -- check whether this is a supplementary run
3024: -- and get the payment date of supplementary run
3025: /*OPEN cur_supp_run;
3026: FETCH cur_supp_run INTO l_last_end_date;
3027: hr_utility.set_location('l_last_end_date = '|| l_last_end_date,20);
3028: IF l_last_end_date IS NOT NULL THEN
3029: --IF l_report_type_count >= 1 THEN
3030: l_supp_flg :='Y';
3031: l_supp_pymt_date := p_date_earned;
3040:
3041: l_supp_flg := p_supp_flag;
3042: l_supp_pymt_date := p_supp_pymt_date;
3043: l_termination_date := p_termination_date;
3044: hr_utility.set_location('supplementary flag = '||l_supp_flg,20);
3045: hr_utility.set_location('supplementary date = '||l_supp_pymt_date,20);
3046: --
3047: --
3048: -- get pay_period_number
3041: l_supp_flg := p_supp_flag;
3042: l_supp_pymt_date := p_supp_pymt_date;
3043: l_termination_date := p_termination_date;
3044: hr_utility.set_location('supplementary flag = '||l_supp_flg,20);
3045: hr_utility.set_location('supplementary date = '||l_supp_pymt_date,20);
3046: --
3047: --
3048: -- get pay_period_number
3049: OPEN cur_period_num;
3048: -- get pay_period_number
3049: OPEN cur_period_num;
3050: FETCH cur_period_num INTO l_period_num, l_number_per_fiscal_year, l_periods_per_period, l_start_date, l_end_date;
3051: CLOSE cur_period_num;
3052: hr_utility.set_location('period number = '||l_period_num,20);
3053: hr_utility.set_location('number per fiscal year : '||l_number_per_fiscal_year,20);
3054: hr_utility.set_location('periods per period : '||l_periods_per_period,20);
3055: hr_utility.set_location('start date : '||l_start_date,20);
3056: hr_utility.set_location('end date : '||l_end_date,20);
3049: OPEN cur_period_num;
3050: FETCH cur_period_num INTO l_period_num, l_number_per_fiscal_year, l_periods_per_period, l_start_date, l_end_date;
3051: CLOSE cur_period_num;
3052: hr_utility.set_location('period number = '||l_period_num,20);
3053: hr_utility.set_location('number per fiscal year : '||l_number_per_fiscal_year,20);
3054: hr_utility.set_location('periods per period : '||l_periods_per_period,20);
3055: hr_utility.set_location('start date : '||l_start_date,20);
3056: hr_utility.set_location('end date : '||l_end_date,20);
3057: --
3050: FETCH cur_period_num INTO l_period_num, l_number_per_fiscal_year, l_periods_per_period, l_start_date, l_end_date;
3051: CLOSE cur_period_num;
3052: hr_utility.set_location('period number = '||l_period_num,20);
3053: hr_utility.set_location('number per fiscal year : '||l_number_per_fiscal_year,20);
3054: hr_utility.set_location('periods per period : '||l_periods_per_period,20);
3055: hr_utility.set_location('start date : '||l_start_date,20);
3056: hr_utility.set_location('end date : '||l_end_date,20);
3057: --
3058: If l_periods_per_period = 1 then
3051: CLOSE cur_period_num;
3052: hr_utility.set_location('period number = '||l_period_num,20);
3053: hr_utility.set_location('number per fiscal year : '||l_number_per_fiscal_year,20);
3054: hr_utility.set_location('periods per period : '||l_periods_per_period,20);
3055: hr_utility.set_location('start date : '||l_start_date,20);
3056: hr_utility.set_location('end date : '||l_end_date,20);
3057: --
3058: If l_periods_per_period = 1 then
3059: l_p45_period_num := l_period_num;
3052: hr_utility.set_location('period number = '||l_period_num,20);
3053: hr_utility.set_location('number per fiscal year : '||l_number_per_fiscal_year,20);
3054: hr_utility.set_location('periods per period : '||l_periods_per_period,20);
3055: hr_utility.set_location('start date : '||l_start_date,20);
3056: hr_utility.set_location('end date : '||l_end_date,20);
3057: --
3058: If l_periods_per_period = 1 then
3059: l_p45_period_num := l_period_num;
3060: Elsif l_asg_end_date between l_start_date and l_end_date then
3071: -- Bug 2943335 passed 'IE EMERGENCY PERIOD' as a parameter to cursor which was earlier hardcoded
3072: /* OPEN cur_defined_balance('IE EMERGENCY PERIOD');
3073: FETCH cur_defined_balance INTO l_defined_balance_id;
3074: CLOSE cur_defined_balance;
3075: hr_utility.set_location('defined balance = '||l_defined_balance_id,20);
3076: l_emer_num := pay_balance_pkg.get_value(p_defined_balance_id => l_defined_balance_id
3077: ,p_assignment_action_id => p_child_run_ass_act_id);
3078: IF l_emer_num >0 THEN
3079: l_emer_basis_flg :='Y';
3100: IF l_tax_basis NOT IN('IE_EMERGENCY','IE_EMERGENCY_NO_PPS') THEN
3101: l_emer_basis_flg := 'N';
3102: END IF;
3103:
3104: hr_utility.set_location('emergency basis = '||l_emer_basis_flg,20);
3105: --
3106: -- get non_cumulative_operated for benefits
3107: -- Bug 2943335 Commented out code below
3108: /* OPEN cur_cal_option;
3106: -- get non_cumulative_operated for benefits
3107: -- Bug 2943335 Commented out code below
3108: /* OPEN cur_cal_option;
3109: FETCH cur_cal_option INTO l_calculation_option;
3110: hr_utility.set_location('l_calculation_option'||l_calculation_option,20);
3111: --Bug:2450336
3112: IF l_calculation_option IN ('IE_OPTION3','IE_OPTION4') THEN
3113: l_noncum_ben_operated := 'Y';
3114: ELSIF l_calculation_option IN ('IE_OPTION1','IE_OPTION2') THEN */
3120:
3121: /*OPEN cur_defined_balance('IE Taxable Social Benefit');
3122: FETCH cur_defined_balance INTO l_soc_ben_defined_bal_id;
3123: CLOSE cur_defined_balance;
3124: hr_utility.set_location('defined balance id = '||l_soc_ben_defined_bal_id,25);
3125:
3126: -- bug 5386432, call only if p_child_run_ass_act_id is not null
3127: IF p_child_run_ass_act_id IS NOT NULL THEN
3128: l_soc_ben_amount := pay_balance_pkg.get_value(l_soc_ben_defined_bal_id,
3134: ,null
3135: ,null
3136: );
3137: end if;
3138: hr_utility.set_location('benefit amount = '||l_soc_ben_amount,25);
3139: -- Check this to identify if employee was ever paid social benefit amount
3140: -- Replacing fix for Bug:2450336
3141: IF ( l_soc_ben_amount <> 0) THEN */
3142: -- end of changes for Bug 2943335
3145: -- reported in this termination against non cumulative flag
3146: /*
3147: OPEN cur_non_cum_tax;
3148: FETCH cur_non_cum_tax INTO l_non_cum_tax;
3149: hr_utility.set_location('l_non_cum_tax'||l_non_cum_tax,20);
3150:
3151: IF cur_non_cum_tax%FOUND THEN
3152: l_noncum_ben_operated := 'true';
3153: ELSE
3164: l_noncum_ben_operated := 'false';
3165: END IF;*/
3166:
3167: -- CLOSE cur_cal_option;
3168: hr_utility.set_location('non cum basis operated = '||l_noncum_ben_operated,20);
3169: open cur_next_of_kin_details(l_termination_date);
3170: fetch cur_next_of_kin_details into cur_next_of_kin_details_rec;
3171: close cur_next_of_kin_details;
3172: --
3195: , p_action_information13 => null
3196: , p_action_information14 => cur_next_of_kin_details_rec.last_name
3197: );
3198: --
3199: hr_utility.set_location('Leaving '||l_proc,20);
3200: END archive_p45_info;
3201: ---------------------------------------------------------------------------------
3202: --Moved the archiving Payroll Action Level Info archivng part from range_cursor 4468864
3203: PROCEDURE archive_deinit(p_payroll_action_id IN NUMBER) IS
3372: l_error varchar2(1) ;
3373: l_archived NUMBER;
3374: BEGIN
3375:
3376: hr_utility.set_location('Entering ' || l_proc,10);
3377: l_archived := 0;
3378: -- Check whether assignment action is retried 4468864
3379: OPEN csr_check_archived(p_payroll_action_id);
3380: FETCH csr_check_archived INTO l_archived;
3411: pay_ie_p45_archive.get_parameters (
3412: p_payroll_action_id => p_payroll_action_id
3413: , p_token_name => 'BG_ID'
3414: , p_token_value => l_bg_id);
3415: hr_utility.set_location('Step ' || l_proc,20);
3416: l_canonical_start_date := TO_DATE(l_start_date,'yyyy/mm/dd');
3417: l_canonical_end_date := TO_DATE(l_end_date,'yyyy/mm/dd');
3418: --get_paye_reference (l_consolidation_set,g_paye_ref,l_bg_id,l_canonical_start_date,l_canonical_end_date,l_error);
3419: /*if l_error ='Y' then
3458: , p_payroll_id => rec_payroll_info.payroll_id
3459: , p_effective_date => l_canonical_end_date);
3460: END IF;
3461: CLOSE csr_check_archive;
3462: hr_utility.set_location('rec_payroll_info.payroll_action_id = ' || rec_payroll_info.payroll_action_id,30);
3463: hr_utility.set_location('rec_payroll_info.tax_details_ref = ' || rec_payroll_info.tax_details_ref_no,30);
3464: hr_utility.set_location('rec_payroll_info.employers_paye_ref_no = ' || rec_payroll_info.employer_paye_ref_no,30);
3465: hr_utility.set_location('Archiving EMEA PAYROLL INFO',30);
3466: pay_action_information_api.create_action_information (
3459: , p_effective_date => l_canonical_end_date);
3460: END IF;
3461: CLOSE csr_check_archive;
3462: hr_utility.set_location('rec_payroll_info.payroll_action_id = ' || rec_payroll_info.payroll_action_id,30);
3463: hr_utility.set_location('rec_payroll_info.tax_details_ref = ' || rec_payroll_info.tax_details_ref_no,30);
3464: hr_utility.set_location('rec_payroll_info.employers_paye_ref_no = ' || rec_payroll_info.employer_paye_ref_no,30);
3465: hr_utility.set_location('Archiving EMEA PAYROLL INFO',30);
3466: pay_action_information_api.create_action_information (
3467: p_action_information_id => l_action_info_id
3460: END IF;
3461: CLOSE csr_check_archive;
3462: hr_utility.set_location('rec_payroll_info.payroll_action_id = ' || rec_payroll_info.payroll_action_id,30);
3463: hr_utility.set_location('rec_payroll_info.tax_details_ref = ' || rec_payroll_info.tax_details_ref_no,30);
3464: hr_utility.set_location('rec_payroll_info.employers_paye_ref_no = ' || rec_payroll_info.employer_paye_ref_no,30);
3465: hr_utility.set_location('Archiving EMEA PAYROLL INFO',30);
3466: pay_action_information_api.create_action_information (
3467: p_action_information_id => l_action_info_id
3468: , p_action_context_id => p_payroll_action_id
3461: CLOSE csr_check_archive;
3462: hr_utility.set_location('rec_payroll_info.payroll_action_id = ' || rec_payroll_info.payroll_action_id,30);
3463: hr_utility.set_location('rec_payroll_info.tax_details_ref = ' || rec_payroll_info.tax_details_ref_no,30);
3464: hr_utility.set_location('rec_payroll_info.employers_paye_ref_no = ' || rec_payroll_info.employer_paye_ref_no,30);
3465: hr_utility.set_location('Archiving EMEA PAYROLL INFO',30);
3466: pay_action_information_api.create_action_information (
3467: p_action_information_id => l_action_info_id
3468: , p_action_context_id => p_payroll_action_id
3469: , p_action_context_type => 'PA'
3489: pay_ie_p45_archive.setup_standard_balance_table;
3490: FOR rec_payroll_info in csr_all_payroll_info(p_payroll_action_id)
3491: LOOP
3492: */
3493: hr_utility.trace('Entered payroll info');
3494: pay_balance_pkg.set_context('PAYROLL_ACTION_ID'
3495: , rec_payroll_info.payroll_action_id);
3496: pay_ie_p45_archive.setup_balance_definitions(p_payroll_action_id,
3497: rec_payroll_info.payroll_action_id,
3500: --end if;
3501: END IF;
3502: Exception
3503: when others then
3504: hr_utility.set_location('Leaving via exception section ' || l_proc,40);
3505: END archive_deinit;
3506:
3507: ---------------------------------------------------------------------------------
3508:
3542: l_error varchar2(1) ;
3543: l_employer NUMBER;
3544:
3545: BEGIN
3546: -- hr_utility.trace_on(null,'P45');
3547: hr_utility.set_location('Entering ' || l_proc,10);
3548: /*
3549: pay_ie_p45_archive.get_parameters (
3550: p_payroll_action_id => pactid
3543: l_employer NUMBER;
3544:
3545: BEGIN
3546: -- hr_utility.trace_on(null,'P45');
3547: hr_utility.set_location('Entering ' || l_proc,10);
3548: /*
3549: pay_ie_p45_archive.get_parameters (
3550: p_payroll_action_id => pactid
3551: , p_token_name => 'PAYROLL'
3582: p_payroll_action_id => pactid
3583: , p_token_name => 'START_DATE'
3584: , p_token_value => l_start_date);
3585:
3586: hr_utility.set_location('Step ' || l_proc,20);
3587: --hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
3588: --hr_utility.set_location('l_start_date = ' || l_start_date,20);
3589: --hr_utility.set_location('l_end_date = ' || l_end_date,20);
3590: --hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
3583: , p_token_name => 'START_DATE'
3584: , p_token_value => l_start_date);
3585:
3586: hr_utility.set_location('Step ' || l_proc,20);
3587: --hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
3588: --hr_utility.set_location('l_start_date = ' || l_start_date,20);
3589: --hr_utility.set_location('l_end_date = ' || l_end_date,20);
3590: --hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
3591: --hr_utility.set_location('l_start_date = ' || l_start_date,20);
3584: , p_token_value => l_start_date);
3585:
3586: hr_utility.set_location('Step ' || l_proc,20);
3587: --hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
3588: --hr_utility.set_location('l_start_date = ' || l_start_date,20);
3589: --hr_utility.set_location('l_end_date = ' || l_end_date,20);
3590: --hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
3591: --hr_utility.set_location('l_start_date = ' || l_start_date,20);
3592: -- l_canonical_start_date := TO_DATE(l_start_date,'yyyy/mm/dd');
3585:
3586: hr_utility.set_location('Step ' || l_proc,20);
3587: --hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
3588: --hr_utility.set_location('l_start_date = ' || l_start_date,20);
3589: --hr_utility.set_location('l_end_date = ' || l_end_date,20);
3590: --hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
3591: --hr_utility.set_location('l_start_date = ' || l_start_date,20);
3592: -- l_canonical_start_date := TO_DATE(l_start_date,'yyyy/mm/dd');
3593: -- l_canonical_end_date := TO_DATE(l_end_date,'yyyy/mm/dd');
3586: hr_utility.set_location('Step ' || l_proc,20);
3587: --hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
3588: --hr_utility.set_location('l_start_date = ' || l_start_date,20);
3589: --hr_utility.set_location('l_end_date = ' || l_end_date,20);
3590: --hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
3591: --hr_utility.set_location('l_start_date = ' || l_start_date,20);
3592: -- l_canonical_start_date := TO_DATE(l_start_date,'yyyy/mm/dd');
3593: -- l_canonical_end_date := TO_DATE(l_end_date,'yyyy/mm/dd');
3594: --archive EMEA PAYROLL INFO for each prepayment run identified
3587: --hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
3588: --hr_utility.set_location('l_start_date = ' || l_start_date,20);
3589: --hr_utility.set_location('l_end_date = ' || l_end_date,20);
3590: --hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
3591: --hr_utility.set_location('l_start_date = ' || l_start_date,20);
3592: -- l_canonical_start_date := TO_DATE(l_start_date,'yyyy/mm/dd');
3593: -- l_canonical_end_date := TO_DATE(l_end_date,'yyyy/mm/dd');
3594: --archive EMEA PAYROLL INFO for each prepayment run identified
3595: --hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
3591: --hr_utility.set_location('l_start_date = ' || l_start_date,20);
3592: -- l_canonical_start_date := TO_DATE(l_start_date,'yyyy/mm/dd');
3593: -- l_canonical_end_date := TO_DATE(l_end_date,'yyyy/mm/dd');
3594: --archive EMEA PAYROLL INFO for each prepayment run identified
3595: --hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
3596: --hr_utility.set_location('l_consolidation_set = ' || l_consolidation_set,20);
3597: -- hr_utility.set_location('l_canonical_start_date = ' || l_canonical_start_date,20);
3598: -- hr_utility.set_location('l_canonical_end_date = ' || l_canonical_end_date,20);
3599: --Call made to procedure get_paye_referene to get the PAYE reference attributed at payroll level,added for bug fix 3567562.
3592: -- l_canonical_start_date := TO_DATE(l_start_date,'yyyy/mm/dd');
3593: -- l_canonical_end_date := TO_DATE(l_end_date,'yyyy/mm/dd');
3594: --archive EMEA PAYROLL INFO for each prepayment run identified
3595: --hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
3596: --hr_utility.set_location('l_consolidation_set = ' || l_consolidation_set,20);
3597: -- hr_utility.set_location('l_canonical_start_date = ' || l_canonical_start_date,20);
3598: -- hr_utility.set_location('l_canonical_end_date = ' || l_canonical_end_date,20);
3599: --Call made to procedure get_paye_referene to get the PAYE reference attributed at payroll level,added for bug fix 3567562.
3600: --get_paye_reference (l_consolidation_set,g_paye_ref,l_bg_id,l_canonical_start_date,l_canonical_end_date,l_error);
3593: -- l_canonical_end_date := TO_DATE(l_end_date,'yyyy/mm/dd');
3594: --archive EMEA PAYROLL INFO for each prepayment run identified
3595: --hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
3596: --hr_utility.set_location('l_consolidation_set = ' || l_consolidation_set,20);
3597: -- hr_utility.set_location('l_canonical_start_date = ' || l_canonical_start_date,20);
3598: -- hr_utility.set_location('l_canonical_end_date = ' || l_canonical_end_date,20);
3599: --Call made to procedure get_paye_referene to get the PAYE reference attributed at payroll level,added for bug fix 3567562.
3600: --get_paye_reference (l_consolidation_set,g_paye_ref,l_bg_id,l_canonical_start_date,l_canonical_end_date,l_error);
3601: --Added for bug fix 3567562
3594: --archive EMEA PAYROLL INFO for each prepayment run identified
3595: --hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
3596: --hr_utility.set_location('l_consolidation_set = ' || l_consolidation_set,20);
3597: -- hr_utility.set_location('l_canonical_start_date = ' || l_canonical_start_date,20);
3598: -- hr_utility.set_location('l_canonical_end_date = ' || l_canonical_end_date,20);
3599: --Call made to procedure get_paye_referene to get the PAYE reference attributed at payroll level,added for bug fix 3567562.
3600: --get_paye_reference (l_consolidation_set,g_paye_ref,l_bg_id,l_canonical_start_date,l_canonical_end_date,l_error);
3601: --Added for bug fix 3567562
3602: /*
3609: pay_payroll_actions ppa
3610: WHERE ppa.payroll_action_id = :payroll_action_id
3611: AND ppa.business_group_id +0= ppf.business_group_id
3612: ORDER BY ppf.person_id';
3613: hr_utility.set_location('Leaving ' || l_proc,40);
3614: --end if;
3615: Exception
3616: when others then
3617: hr_utility.set_location('Leaving via exception section ' || l_proc,40);
3613: hr_utility.set_location('Leaving ' || l_proc,40);
3614: --end if;
3615: Exception
3616: when others then
3617: hr_utility.set_location('Leaving via exception section ' || l_proc,40);
3618: sqlstr:='select 1 from dual where to_char(:payroll_action_id) = dummy';
3619: END range_cursor;
3620:
3621: -------------------------------------------------
3796: --
3797: l_proc VARCHAR2(50) := g_package||'action_creation';
3798: BEGIN
3799:
3800: --hr_utility.trace_on(null,'P45');
3801: hr_utility.set_location('Entering ' || l_proc,10);
3802: pay_ie_p45_archive.get_parameters (
3803: p_payroll_action_id => pactid
3804: , p_token_name => 'EMPLOYER'
3797: l_proc VARCHAR2(50) := g_package||'action_creation';
3798: BEGIN
3799:
3800: --hr_utility.trace_on(null,'P45');
3801: hr_utility.set_location('Entering ' || l_proc,10);
3802: pay_ie_p45_archive.get_parameters (
3803: p_payroll_action_id => pactid
3804: , p_token_name => 'EMPLOYER'
3805: , p_token_value => g_paye_ref);
3823: p_payroll_action_id => pactid
3824: , p_token_name => 'PAYROLL'
3825: , p_token_value => l_payroll_id);
3826:
3827: hr_utility.set_location('Step ' || l_proc,20);
3828: hr_utility.set_location('g_paye_ref = ' || g_paye_ref,20);
3829: hr_utility.set_location('l_end_date = ' || l_end_date,20);
3830:
3831: l_canonical_start_date := TO_DATE(l_start_date,'yyyy/mm/dd');
3824: , p_token_name => 'PAYROLL'
3825: , p_token_value => l_payroll_id);
3826:
3827: hr_utility.set_location('Step ' || l_proc,20);
3828: hr_utility.set_location('g_paye_ref = ' || g_paye_ref,20);
3829: hr_utility.set_location('l_end_date = ' || l_end_date,20);
3830:
3831: l_canonical_start_date := TO_DATE(l_start_date,'yyyy/mm/dd');
3832: l_canonical_end_date := TO_DATE(l_end_date,'yyyy/mm/dd');
3825: , p_token_value => l_payroll_id);
3826:
3827: hr_utility.set_location('Step ' || l_proc,20);
3828: hr_utility.set_location('g_paye_ref = ' || g_paye_ref,20);
3829: hr_utility.set_location('l_end_date = ' || l_end_date,20);
3830:
3831: l_canonical_start_date := TO_DATE(l_start_date,'yyyy/mm/dd');
3832: l_canonical_end_date := TO_DATE(l_end_date,'yyyy/mm/dd');
3833: g_archive_start_date := l_canonical_start_date;
3837: l_prepay_action_id := 0;
3838: l_person_id := 0;
3839: l_period_of_service_id := 0;
3840:
3841: hr_utility.set_location('l_start_date = ' || l_canonical_start_date,20);
3842:
3843:
3844: --get_paye_reference (l_consolidation_set,g_paye_ref,l_bg_id,l_canonical_start_date,l_canonical_end_date,l_error);
3845: hr_utility.set_location('Before csr_prepaid_assignments',21);
3841: hr_utility.set_location('l_start_date = ' || l_canonical_start_date,20);
3842:
3843:
3844: --get_paye_reference (l_consolidation_set,g_paye_ref,l_bg_id,l_canonical_start_date,l_canonical_end_date,l_error);
3845: hr_utility.set_location('Before csr_prepaid_assignments',21);
3846:
3847: l_ppsn_override := NULL;
3848: l_ppsn_override_asg := NULL;
3849:
3854: l_payroll_id)
3855: LOOP
3856:
3857: /* 7291676 */
3858: hr_utility.set_location('Person id..'||to_char(csr_rec.person_id),21-1);
3859: hr_utility.set_location('Temp Person id..'||to_char(l_person_id),21-2);
3860: --
3861: /* 7291676QA */
3862: l_ppsn_override := NULL;
3855: LOOP
3856:
3857: /* 7291676 */
3858: hr_utility.set_location('Person id..'||to_char(csr_rec.person_id),21-1);
3859: hr_utility.set_location('Temp Person id..'||to_char(l_person_id),21-2);
3860: --
3861: /* 7291676QA */
3862: l_ppsn_override := NULL;
3863: l_ppsn_override_asg := NULL;
3860: --
3861: /* 7291676QA */
3862: l_ppsn_override := NULL;
3863: l_ppsn_override_asg := NULL;
3864: hr_utility.set_location('before fetch l_ppsn_override'||to_char(l_ppsn_override),21-3);
3865: hr_utility.set_location(' before fetch l_ppsn_override_asg'||to_char(l_ppsn_override_asg),21-3);
3866:
3867: OPEN csr_ppsn_override(csr_rec.assignment_id);
3868: FETCH csr_ppsn_override INTO l_ppsn_override;
3861: /* 7291676QA */
3862: l_ppsn_override := NULL;
3863: l_ppsn_override_asg := NULL;
3864: hr_utility.set_location('before fetch l_ppsn_override'||to_char(l_ppsn_override),21-3);
3865: hr_utility.set_location(' before fetch l_ppsn_override_asg'||to_char(l_ppsn_override_asg),21-3);
3866:
3867: OPEN csr_ppsn_override(csr_rec.assignment_id);
3868: FETCH csr_ppsn_override INTO l_ppsn_override;
3869: CLOSE csr_ppsn_override;
3867: OPEN csr_ppsn_override(csr_rec.assignment_id);
3868: FETCH csr_ppsn_override INTO l_ppsn_override;
3869: CLOSE csr_ppsn_override;
3870:
3871: hr_utility.set_location('l_ppsn_override'||to_char(l_ppsn_override),21-3);
3872:
3873: IF l_ppsn_override IS NOT NULL THEN
3874: OPEN csr_ppsn_min_asg(l_ppsn_override,csr_rec.person_id);
3875: FETCH csr_ppsn_min_asg INTO l_ppsn_override_asg;
3873: IF l_ppsn_override IS NOT NULL THEN
3874: OPEN csr_ppsn_min_asg(l_ppsn_override,csr_rec.person_id);
3875: FETCH csr_ppsn_min_asg INTO l_ppsn_override_asg;
3876: CLOSE csr_ppsn_min_asg;
3877: hr_utility.set_location('l_ppsn_override_asg'||to_char(l_ppsn_override_asg),21-4);
3878: END IF;
3879:
3880:
3881:
3878: END IF;
3879:
3880:
3881:
3882: hr_utility.set_location('csr_rec.assignment_id'||csr_rec.assignment_id,21-4);
3883:
3884: IF (l_person_id <> csr_rec.person_id and l_ppsn_override IS NULL )
3885: OR
3886: (l_ppsn_override_asg=csr_rec.assignment_id and l_ppsn_override IS NOT NULL)
3885: OR
3886: (l_ppsn_override_asg=csr_rec.assignment_id and l_ppsn_override IS NOT NULL)
3887: THEN
3888:
3889: hr_utility.set_location('Different Person '|| csr_rec.person_id ,22);
3890:
3891: SELECT pay_assignment_actions_s.NEXTVAL
3892: INTO l_actid
3893: FROM dual;
3892: INTO l_actid
3893: FROM dual;
3894:
3895: -- CREATE THE ARCHIVE ASSIGNMENT ACTION FOR THE MASTER ASSIGNMENT ACTION
3896: hr_utility.set_location('ASSIGNMENT ID : ' || csr_rec.assignment_id,23);
3897: hr_utility.trace('ASSIGNMENT ID : ' || csr_rec.assignment_id);
3898:
3899: hr_nonrun_asact.insact(l_actid,csr_rec.assignment_id,pactid,chunk,g_paye_ref);
3900: -- CREATE THE ARCHIVE TO PAYROLL MASTER ASSIGNMENT ACTION INTERLOCK AND
3893: FROM dual;
3894:
3895: -- CREATE THE ARCHIVE ASSIGNMENT ACTION FOR THE MASTER ASSIGNMENT ACTION
3896: hr_utility.set_location('ASSIGNMENT ID : ' || csr_rec.assignment_id,23);
3897: hr_utility.trace('ASSIGNMENT ID : ' || csr_rec.assignment_id);
3898:
3899: hr_nonrun_asact.insact(l_actid,csr_rec.assignment_id,pactid,chunk,g_paye_ref);
3900: -- CREATE THE ARCHIVE TO PAYROLL MASTER ASSIGNMENT ACTION INTERLOCK AND
3901: -- THE ARCHIVE TO PREPAYMENT ASSIGNMENT ACTION INTERLOCK
3898:
3899: hr_nonrun_asact.insact(l_actid,csr_rec.assignment_id,pactid,chunk,g_paye_ref);
3900: -- CREATE THE ARCHIVE TO PAYROLL MASTER ASSIGNMENT ACTION INTERLOCK AND
3901: -- THE ARCHIVE TO PREPAYMENT ASSIGNMENT ACTION INTERLOCK
3902: -- hr_utility.set_location('creating lock1 ' || l_actid || ' to ' || csr_rec.run_action_id,20);
3903: -- hr_utility.set_location('creating lock2 ' || l_actid || ' to ' || csr_rec.prepaid_action_id,20);
3904: END IF; --
3905: hr_utility.set_location('l_prepay_action_id : ' || l_prepay_action_id,100);
3906: hr_utility.set_location('csr_rec.prepaid_action_id : ' || csr_rec.prepaid_action_id,101);
3899: hr_nonrun_asact.insact(l_actid,csr_rec.assignment_id,pactid,chunk,g_paye_ref);
3900: -- CREATE THE ARCHIVE TO PAYROLL MASTER ASSIGNMENT ACTION INTERLOCK AND
3901: -- THE ARCHIVE TO PREPAYMENT ASSIGNMENT ACTION INTERLOCK
3902: -- hr_utility.set_location('creating lock1 ' || l_actid || ' to ' || csr_rec.run_action_id,20);
3903: -- hr_utility.set_location('creating lock2 ' || l_actid || ' to ' || csr_rec.prepaid_action_id,20);
3904: END IF; --
3905: hr_utility.set_location('l_prepay_action_id : ' || l_prepay_action_id,100);
3906: hr_utility.set_location('csr_rec.prepaid_action_id : ' || csr_rec.prepaid_action_id,101);
3907: hr_utility.set_location('l_actid : ' || l_actid,102);
3901: -- THE ARCHIVE TO PREPAYMENT ASSIGNMENT ACTION INTERLOCK
3902: -- hr_utility.set_location('creating lock1 ' || l_actid || ' to ' || csr_rec.run_action_id,20);
3903: -- hr_utility.set_location('creating lock2 ' || l_actid || ' to ' || csr_rec.prepaid_action_id,20);
3904: END IF; --
3905: hr_utility.set_location('l_prepay_action_id : ' || l_prepay_action_id,100);
3906: hr_utility.set_location('csr_rec.prepaid_action_id : ' || csr_rec.prepaid_action_id,101);
3907: hr_utility.set_location('l_actid : ' || l_actid,102);
3908:
3909: IF l_prepay_action_id <> csr_rec.prepaid_action_id THEN
3902: -- hr_utility.set_location('creating lock1 ' || l_actid || ' to ' || csr_rec.run_action_id,20);
3903: -- hr_utility.set_location('creating lock2 ' || l_actid || ' to ' || csr_rec.prepaid_action_id,20);
3904: END IF; --
3905: hr_utility.set_location('l_prepay_action_id : ' || l_prepay_action_id,100);
3906: hr_utility.set_location('csr_rec.prepaid_action_id : ' || csr_rec.prepaid_action_id,101);
3907: hr_utility.set_location('l_actid : ' || l_actid,102);
3908:
3909: IF l_prepay_action_id <> csr_rec.prepaid_action_id THEN
3910: hr_utility.set_location('locked id : ' || csr_rec.prepaid_action_id,23);
3903: -- hr_utility.set_location('creating lock2 ' || l_actid || ' to ' || csr_rec.prepaid_action_id,20);
3904: END IF; --
3905: hr_utility.set_location('l_prepay_action_id : ' || l_prepay_action_id,100);
3906: hr_utility.set_location('csr_rec.prepaid_action_id : ' || csr_rec.prepaid_action_id,101);
3907: hr_utility.set_location('l_actid : ' || l_actid,102);
3908:
3909: IF l_prepay_action_id <> csr_rec.prepaid_action_id THEN
3910: hr_utility.set_location('locked id : ' || csr_rec.prepaid_action_id,23);
3911: hr_nonrun_asact.insint(l_actid,csr_rec.prepaid_action_id);
3906: hr_utility.set_location('csr_rec.prepaid_action_id : ' || csr_rec.prepaid_action_id,101);
3907: hr_utility.set_location('l_actid : ' || l_actid,102);
3908:
3909: IF l_prepay_action_id <> csr_rec.prepaid_action_id THEN
3910: hr_utility.set_location('locked id : ' || csr_rec.prepaid_action_id,23);
3911: hr_nonrun_asact.insint(l_actid,csr_rec.prepaid_action_id);
3912: END IF;
3913:
3914: hr_nonrun_asact.insint(l_actid,csr_rec.run_action_id);
3918: l_period_of_service_id := csr_rec.period_of_service_id;
3919:
3920: END LOOP;
3921:
3922: hr_utility.set_location('Leaving ' || l_proc,20);
3923: END action_creation;
3924:
3925: ----------------------------
3926: PROCEDURE archive_code (p_assactid in number,
4123:
4124: BEGIN
4125:
4126: l_lat_act_seq := NULL;
4127: hr_utility.set_location('Entering'|| l_proc,10);
4128: hr_utility.set_location('Step '|| l_proc,20);
4129: hr_utility.set_location('p_assactid = ' || p_assactid,20);
4130:
4131: -- retrieve the chunk number for the current assignment action
4124: BEGIN
4125:
4126: l_lat_act_seq := NULL;
4127: hr_utility.set_location('Entering'|| l_proc,10);
4128: hr_utility.set_location('Step '|| l_proc,20);
4129: hr_utility.set_location('p_assactid = ' || p_assactid,20);
4130:
4131: -- retrieve the chunk number for the current assignment action
4132: SELECT paa.chunk_number,paa.assignment_id
4125:
4126: l_lat_act_seq := NULL;
4127: hr_utility.set_location('Entering'|| l_proc,10);
4128: hr_utility.set_location('Step '|| l_proc,20);
4129: hr_utility.set_location('p_assactid = ' || p_assactid,20);
4130:
4131: -- retrieve the chunk number for the current assignment action
4132: SELECT paa.chunk_number,paa.assignment_id
4133: INTO l_chunk_number,l_assignment_id
4138: l_record_count := 0;
4139:
4140: FOR csr_rec IN csr_assignment_actions(p_assactid)
4141: LOOP
4142: hr_utility.set_location('csr_rec.master_assignment_action_id = ' || csr_rec.master_assignment_action_id,20);
4143: hr_utility.set_location('csr_rec.pre_assignment_action_id = ' || csr_rec.pre_assignment_action_id,20);
4144: hr_utility.set_location('csr_rec.assignment_id = ' || csr_rec.assignment_id,20);
4145: hr_utility.set_location('csr_rec.date_earned = ' ||to_char( csr_rec.date_earned,'dd-mon-yyyy'),20);
4146: hr_utility.set_location('csr_rec.pre_effective_date = ' ||to_char( csr_rec.pre_effective_date,'dd-mon-yyyy'),20);
4139:
4140: FOR csr_rec IN csr_assignment_actions(p_assactid)
4141: LOOP
4142: hr_utility.set_location('csr_rec.master_assignment_action_id = ' || csr_rec.master_assignment_action_id,20);
4143: hr_utility.set_location('csr_rec.pre_assignment_action_id = ' || csr_rec.pre_assignment_action_id,20);
4144: hr_utility.set_location('csr_rec.assignment_id = ' || csr_rec.assignment_id,20);
4145: hr_utility.set_location('csr_rec.date_earned = ' ||to_char( csr_rec.date_earned,'dd-mon-yyyy'),20);
4146: hr_utility.set_location('csr_rec.pre_effective_date = ' ||to_char( csr_rec.pre_effective_date,'dd-mon-yyyy'),20);
4147: hr_utility.set_location('csr_rec.time_period_id = ' || csr_rec.time_period_id,20);
4140: FOR csr_rec IN csr_assignment_actions(p_assactid)
4141: LOOP
4142: hr_utility.set_location('csr_rec.master_assignment_action_id = ' || csr_rec.master_assignment_action_id,20);
4143: hr_utility.set_location('csr_rec.pre_assignment_action_id = ' || csr_rec.pre_assignment_action_id,20);
4144: hr_utility.set_location('csr_rec.assignment_id = ' || csr_rec.assignment_id,20);
4145: hr_utility.set_location('csr_rec.date_earned = ' ||to_char( csr_rec.date_earned,'dd-mon-yyyy'),20);
4146: hr_utility.set_location('csr_rec.pre_effective_date = ' ||to_char( csr_rec.pre_effective_date,'dd-mon-yyyy'),20);
4147: hr_utility.set_location('csr_rec.time_period_id = ' || csr_rec.time_period_id,20);
4148:
4141: LOOP
4142: hr_utility.set_location('csr_rec.master_assignment_action_id = ' || csr_rec.master_assignment_action_id,20);
4143: hr_utility.set_location('csr_rec.pre_assignment_action_id = ' || csr_rec.pre_assignment_action_id,20);
4144: hr_utility.set_location('csr_rec.assignment_id = ' || csr_rec.assignment_id,20);
4145: hr_utility.set_location('csr_rec.date_earned = ' ||to_char( csr_rec.date_earned,'dd-mon-yyyy'),20);
4146: hr_utility.set_location('csr_rec.pre_effective_date = ' ||to_char( csr_rec.pre_effective_date,'dd-mon-yyyy'),20);
4147: hr_utility.set_location('csr_rec.time_period_id = ' || csr_rec.time_period_id,20);
4148:
4149: OPEN cur_assgn_payroll(csr_rec.assignment_id,csr_rec.date_earned);
4142: hr_utility.set_location('csr_rec.master_assignment_action_id = ' || csr_rec.master_assignment_action_id,20);
4143: hr_utility.set_location('csr_rec.pre_assignment_action_id = ' || csr_rec.pre_assignment_action_id,20);
4144: hr_utility.set_location('csr_rec.assignment_id = ' || csr_rec.assignment_id,20);
4145: hr_utility.set_location('csr_rec.date_earned = ' ||to_char( csr_rec.date_earned,'dd-mon-yyyy'),20);
4146: hr_utility.set_location('csr_rec.pre_effective_date = ' ||to_char( csr_rec.pre_effective_date,'dd-mon-yyyy'),20);
4147: hr_utility.set_location('csr_rec.time_period_id = ' || csr_rec.time_period_id,20);
4148:
4149: OPEN cur_assgn_payroll(csr_rec.assignment_id,csr_rec.date_earned);
4150: FETCH cur_assgn_payroll INTO l_payroll_id,l_person_id,l_pos_id;
4143: hr_utility.set_location('csr_rec.pre_assignment_action_id = ' || csr_rec.pre_assignment_action_id,20);
4144: hr_utility.set_location('csr_rec.assignment_id = ' || csr_rec.assignment_id,20);
4145: hr_utility.set_location('csr_rec.date_earned = ' ||to_char( csr_rec.date_earned,'dd-mon-yyyy'),20);
4146: hr_utility.set_location('csr_rec.pre_effective_date = ' ||to_char( csr_rec.pre_effective_date,'dd-mon-yyyy'),20);
4147: hr_utility.set_location('csr_rec.time_period_id = ' || csr_rec.time_period_id,20);
4148:
4149: OPEN cur_assgn_payroll(csr_rec.assignment_id,csr_rec.date_earned);
4150: FETCH cur_assgn_payroll INTO l_payroll_id,l_person_id,l_pos_id;
4151: CLOSE cur_assgn_payroll;
4153: l_ppsn_override:=null; -- 7291676
4154: open csr_ppsn_override(csr_rec.assignment_id);
4155: fetch csr_ppsn_override into l_ppsn_override;
4156: close csr_ppsn_override;
4157: hr_utility.set_location('PPSN Override value = ' || l_ppsn_override,20);
4158:
4159:
4160: --Fetch the action sequence of latest payroll run child action locked by latest P45
4161: --For the assignment 4468864
4162: OPEN cur_get_latest_p45(g_archive_pact,l_person_id);
4163: FETCH cur_get_latest_p45 INTO l_concat_sequence;
4164:
4165: IF cur_get_latest_p45%NOTFOUND THEN
4166: hr_utility.set_location('Action Sequence notfound = ' || l_lat_act_seq,21);
4167: l_lat_act_seq := 0;
4168: l_prev_src_id := 0;
4169: END IF;
4170:
4170:
4171: l_lat_act_seq := nvl(substr(l_concat_sequence,1,15),0);
4172: l_prev_src_id := nvl(substr(l_concat_sequence,16),0);
4173:
4174: hr_utility.set_location('Action Sequence = ' || l_lat_act_seq,21);
4175: CLOSE cur_get_latest_p45;
4176:
4177: hr_utility.set_location('Action Sequence = ' || l_lat_act_seq,21);
4178:
4173:
4174: hr_utility.set_location('Action Sequence = ' || l_lat_act_seq,21);
4175: CLOSE cur_get_latest_p45;
4176:
4177: hr_utility.set_location('Action Sequence = ' || l_lat_act_seq,21);
4178:
4179: -- Bug Fix 3817846
4180: -- OPEN cur_child_pay_action(csr_rec.assignment_id, csr_rec.date_earned);
4181: -- Bug Fix 4001524
4184:
4185: l_child_pay_action_ppsn := NULL;
4186: OPEN cur_child_pay_action_ppsn(l_person_id,g_archive_end_date,l_lat_act_seq,l_ppsn_override);
4187: FETCH cur_child_pay_action_ppsn INTO l_child_pay_action_ppsn;
4188: hr_utility.set_location('Child Action PPSN ='||l_child_pay_action_ppsn,20);
4189: CLOSE cur_child_pay_action_ppsn;
4190:
4191: l_child_pay_action := NULL;
4192: OPEN cur_child_pay_action(l_person_id,g_archive_end_date,l_lat_act_seq);
4194:
4195: if (l_child_pay_action_ppsn is null) THEN
4196: l_child_pay_action_ppsn:=l_child_pay_action;
4197: end if;
4198: hr_utility.set_location('Child Action PPSN after assigning ='||l_child_pay_action_ppsn,20);
4199:
4200: -- hr_utility.set_location('Child Action PPSN ='|| l_child_pay_action_ppsn,24);
4201: hr_utility.set_location('Child Action ='||l_child_pay_action,24);
4202:
4196: l_child_pay_action_ppsn:=l_child_pay_action;
4197: end if;
4198: hr_utility.set_location('Child Action PPSN after assigning ='||l_child_pay_action_ppsn,20);
4199:
4200: -- hr_utility.set_location('Child Action PPSN ='|| l_child_pay_action_ppsn,24);
4201: hr_utility.set_location('Child Action ='||l_child_pay_action,24);
4202:
4203: -------------- Moved here for bug 5386432 ----
4204: get_termination_date(p_action_context_id => p_assactid,
4197: end if;
4198: hr_utility.set_location('Child Action PPSN after assigning ='||l_child_pay_action_ppsn,20);
4199:
4200: -- hr_utility.set_location('Child Action PPSN ='|| l_child_pay_action_ppsn,24);
4201: hr_utility.set_location('Child Action ='||l_child_pay_action,24);
4202:
4203: -------------- Moved here for bug 5386432 ----
4204: get_termination_date(p_action_context_id => p_assactid,
4205: p_assignment_id => csr_rec.assignment_id,
4217: -- Fetch the Payroll action of Last P45 5005788
4218: OPEN cur_get_p45_pact(l_last_p45_action);
4219: FETCH cur_get_p45_pact INTO l_last_p45_pact;
4220: CLOSE cur_get_p45_pact;
4221: hr_utility.set_location(' l_termination_date = '||l_termination_date,30);
4222: hr_utility.set_location(' l_supp_pymt_date = '||l_supp_pymt_date,30);
4223: hr_utility.set_location(' l_supp_flag = '||l_supp_flag,30);
4224:
4225: ------------------
4218: OPEN cur_get_p45_pact(l_last_p45_action);
4219: FETCH cur_get_p45_pact INTO l_last_p45_pact;
4220: CLOSE cur_get_p45_pact;
4221: hr_utility.set_location(' l_termination_date = '||l_termination_date,30);
4222: hr_utility.set_location(' l_supp_pymt_date = '||l_supp_pymt_date,30);
4223: hr_utility.set_location(' l_supp_flag = '||l_supp_flag,30);
4224:
4225: ------------------
4226: IF ((l_child_pay_action IS NULL) and l_supp_flag = 'Y' ) THEN
4219: FETCH cur_get_p45_pact INTO l_last_p45_pact;
4220: CLOSE cur_get_p45_pact;
4221: hr_utility.set_location(' l_termination_date = '||l_termination_date,30);
4222: hr_utility.set_location(' l_supp_pymt_date = '||l_supp_pymt_date,30);
4223: hr_utility.set_location(' l_supp_flag = '||l_supp_flag,30);
4224:
4225: ------------------
4226: IF ((l_child_pay_action IS NULL) and l_supp_flag = 'Y' ) THEN
4227: NULL;
4243: , prepayid => NULL
4244: , status => 'C'
4245: , source_act => p_assactid);
4246:
4247: hr_utility.set_location('creating lock4 ' || l_actid || ' to ' || l_child_pay_action,30);
4248: -- bug 5386432, checks l_child_pay_action is not null, since for zero
4249: -- earnigns there will not child actions, so cant lock any
4250: IF l_child_pay_action IS NOT NULL THEN
4251: hr_nonrun_asact.insint(
4278: CLOSE cur_get_p45_pact; */
4279:
4280:
4281:
4282: hr_utility.set_location('sg Person Id ='||l_person_id,32);
4283: hr_utility.set_location('sg Termination Date ='||l_termination_date,33);
4284: hr_utility.set_location('sg Payroll action ='||g_archive_pact,34);
4285: hr_utility.set_location('sg P45 action ='||l_last_p45_action,35);
4286:
4279:
4280:
4281:
4282: hr_utility.set_location('sg Person Id ='||l_person_id,32);
4283: hr_utility.set_location('sg Termination Date ='||l_termination_date,33);
4284: hr_utility.set_location('sg Payroll action ='||g_archive_pact,34);
4285: hr_utility.set_location('sg P45 action ='||l_last_p45_action,35);
4286:
4287: IF l_last_p45_action IS NOT NULL THEN
4280:
4281:
4282: hr_utility.set_location('sg Person Id ='||l_person_id,32);
4283: hr_utility.set_location('sg Termination Date ='||l_termination_date,33);
4284: hr_utility.set_location('sg Payroll action ='||g_archive_pact,34);
4285: hr_utility.set_location('sg P45 action ='||l_last_p45_action,35);
4286:
4287: IF l_last_p45_action IS NOT NULL THEN
4288: hr_nonrun_asact.insint(
4281:
4282: hr_utility.set_location('sg Person Id ='||l_person_id,32);
4283: hr_utility.set_location('sg Termination Date ='||l_termination_date,33);
4284: hr_utility.set_location('sg Payroll action ='||g_archive_pact,34);
4285: hr_utility.set_location('sg P45 action ='||l_last_p45_action,35);
4286:
4287: IF l_last_p45_action IS NOT NULL THEN
4288: hr_nonrun_asact.insint(
4289: lockingactid => l_actid
4310:
4311: -- Statutory Balances are archived for all Separate Payment assignment actions
4312: -- and the last (i.e. highest action_sequence) Process Separately assignment action
4313: -- (EMEA BALANCES)
4314: hr_utility.set_location('Archive User Balances - Complete',60);
4315: -- archive statutory balances
4316: hr_utility.set_location('Archive Statutory Balances - Starting',70);
4317: hr_utility.set_location('g_max_statutory_balance_index = '|| g_max_statutory_balance_index,70);
4318:
4312: -- and the last (i.e. highest action_sequence) Process Separately assignment action
4313: -- (EMEA BALANCES)
4314: hr_utility.set_location('Archive User Balances - Complete',60);
4315: -- archive statutory balances
4316: hr_utility.set_location('Archive Statutory Balances - Starting',70);
4317: hr_utility.set_location('g_max_statutory_balance_index = '|| g_max_statutory_balance_index,70);
4318:
4319:
4320: hr_utility.set_location('PPSN Override value = ' || l_ppsn_override,70);
4313: -- (EMEA BALANCES)
4314: hr_utility.set_location('Archive User Balances - Complete',60);
4315: -- archive statutory balances
4316: hr_utility.set_location('Archive Statutory Balances - Starting',70);
4317: hr_utility.set_location('g_max_statutory_balance_index = '|| g_max_statutory_balance_index,70);
4318:
4319:
4320: hr_utility.set_location('PPSN Override value = ' || l_ppsn_override,70);
4321:
4316: hr_utility.set_location('Archive Statutory Balances - Starting',70);
4317: hr_utility.set_location('g_max_statutory_balance_index = '|| g_max_statutory_balance_index,70);
4318:
4319:
4320: hr_utility.set_location('PPSN Override value = ' || l_ppsn_override,70);
4321:
4322: FOR l_index IN 1 .. g_max_statutory_balance_index
4323: LOOP
4324:
4323: LOOP
4324:
4325: if (l_ppsn_override is null) then
4326:
4327: hr_utility.set_location('l_index = ' || l_index,70);
4328: hr_utility.set_location('balance_name ='||g_statutory_balance_table(l_index).balance_name,70);
4329: hr_utility.set_location('database_item_suffix ='||g_statutory_balance_table(l_index).database_item_suffix,70);
4330: /*
4331: --Bug:2448728.Passing the prepayment assignment action id to p_source_id as the _PAYMENTS
4324:
4325: if (l_ppsn_override is null) then
4326:
4327: hr_utility.set_location('l_index = ' || l_index,70);
4328: hr_utility.set_location('balance_name ='||g_statutory_balance_table(l_index).balance_name,70);
4329: hr_utility.set_location('database_item_suffix ='||g_statutory_balance_table(l_index).database_item_suffix,70);
4330: /*
4331: --Bug:2448728.Passing the prepayment assignment action id to p_source_id as the _PAYMENTS
4332: --balances are fed only during pre Payments.
4325: if (l_ppsn_override is null) then
4326:
4327: hr_utility.set_location('l_index = ' || l_index,70);
4328: hr_utility.set_location('balance_name ='||g_statutory_balance_table(l_index).balance_name,70);
4329: hr_utility.set_location('database_item_suffix ='||g_statutory_balance_table(l_index).database_item_suffix,70);
4330: /*
4331: --Bug:2448728.Passing the prepayment assignment action id to p_source_id as the _PAYMENTS
4332: --balances are fed only during pre Payments.
4333: If g_statutory_balance_table(l_index).balance_name = 'Total Pay' Then
4383:
4384: END IF;
4385:
4386: ELSE /* if ppsn override is present */
4387: hr_utility.set_location('entered the else block in the archve code ' ,70);
4388: hr_utility.set_location('l_index = ' || l_index,70);
4389: hr_utility.set_location('balance_name ='||g_statutory_balance_table_ppsn(l_index).balance_name,70);
4390: hr_utility.set_location('database_item_suffix ='||g_statutory_balance_table_ppsn(l_index).database_item_suffix,70);
4391:
4384: END IF;
4385:
4386: ELSE /* if ppsn override is present */
4387: hr_utility.set_location('entered the else block in the archve code ' ,70);
4388: hr_utility.set_location('l_index = ' || l_index,70);
4389: hr_utility.set_location('balance_name ='||g_statutory_balance_table_ppsn(l_index).balance_name,70);
4390: hr_utility.set_location('database_item_suffix ='||g_statutory_balance_table_ppsn(l_index).database_item_suffix,70);
4391:
4392: -- IF (l_index < 20) THEN -- Bug 5015438 13359530
4385:
4386: ELSE /* if ppsn override is present */
4387: hr_utility.set_location('entered the else block in the archve code ' ,70);
4388: hr_utility.set_location('l_index = ' || l_index,70);
4389: hr_utility.set_location('balance_name ='||g_statutory_balance_table_ppsn(l_index).balance_name,70);
4390: hr_utility.set_location('database_item_suffix ='||g_statutory_balance_table_ppsn(l_index).database_item_suffix,70);
4391:
4392: -- IF (l_index < 20) THEN -- Bug 5015438 13359530
4393: IF (l_index < 24) THEN
4386: ELSE /* if ppsn override is present */
4387: hr_utility.set_location('entered the else block in the archve code ' ,70);
4388: hr_utility.set_location('l_index = ' || l_index,70);
4389: hr_utility.set_location('balance_name ='||g_statutory_balance_table_ppsn(l_index).balance_name,70);
4390: hr_utility.set_location('database_item_suffix ='||g_statutory_balance_table_ppsn(l_index).database_item_suffix,70);
4391:
4392: -- IF (l_index < 20) THEN -- Bug 5015438 13359530
4393: IF (l_index < 24) THEN
4394: pay_ie_p45_archive.process_balance (
4408: , p_prev_src_id => l_prev_src_id);
4409:
4410: ELSE
4411: IF (l_supp_flag = 'Y') THEN
4412: hr_utility.set_location('entered the if block and supp flag is y ' ,70);
4413: pay_ie_p45_archive.process_supp_balance (
4414: p_action_context_id => l_action_context_id
4415: , p_assignment_id => csr_rec.assignment_id
4416: , p_person_id => l_person_id
4433: END IF; -- ppsn override if condition
4434: -- End If;
4435: END LOOP;
4436: l_ppsn_override:=null; -- 7291676
4437: hr_utility.set_location('Archive Statutory Balances - Complete',70);
4438: l_record_count := l_record_count + 1;
4439: END IF;
4440: END IF;
4441: CLOSE cur_child_pay_action;
4440: END IF;
4441: CLOSE cur_child_pay_action;
4442: l_date_earned := csr_rec.date_earned;
4443: END LOOP;
4444: hr_utility.set_location('Leaving '|| l_proc,80);
4445: END archive_code;
4446:
4447: --------------------------------------------------------------------------------
4448: -- Bug 2643489: Function to return balnce values archived by P45 Archive Process
4495: l_def_bal_id pay_action_information.action_information1%TYPE := NULL;
4496:
4497: BEGIN
4498:
4499: --hr_utility.trace_on(null,'P45XML');
4500: OPEN csr_check_override_present(p_assignment_action_id);
4501: FETCH csr_check_override_present INTO l_ppsn_override;
4502:
4503: IF csr_check_override_present%found and l_ppsn_override is not null THEN
4506: l_ppsn_override_flag:='N';
4507: END IF;
4508: CLOSE csr_check_override_present;
4509:
4510: hr_utility.set_location('l_ppsn_override_flag '||l_ppsn_override_flag,400);
4511:
4512: IF p_assignment_action_id IS NOT NULL AND p_balance_name IS NOT NULL THEN
4513: OPEN csr_get_def_bal(p_payroll_action_id,p_balance_name,l_ppsn_override_flag);
4514: FETCH csr_get_def_bal INTO l_def_bal_id;
4512: IF p_assignment_action_id IS NOT NULL AND p_balance_name IS NOT NULL THEN
4513: OPEN csr_get_def_bal(p_payroll_action_id,p_balance_name,l_ppsn_override_flag);
4514: FETCH csr_get_def_bal INTO l_def_bal_id;
4515: CLOSE csr_get_def_bal;
4516: hr_utility.set_location('p_payroll_action_id '||p_payroll_action_id,400);
4517: hr_utility.set_location('p_balance_name '||p_balance_name,400);
4518: hr_utility.set_location('l_def_bal_id '||l_def_bal_id,400);
4519:
4520: IF l_def_bal_id IS NOT NULL THEN
4513: OPEN csr_get_def_bal(p_payroll_action_id,p_balance_name,l_ppsn_override_flag);
4514: FETCH csr_get_def_bal INTO l_def_bal_id;
4515: CLOSE csr_get_def_bal;
4516: hr_utility.set_location('p_payroll_action_id '||p_payroll_action_id,400);
4517: hr_utility.set_location('p_balance_name '||p_balance_name,400);
4518: hr_utility.set_location('l_def_bal_id '||l_def_bal_id,400);
4519:
4520: IF l_def_bal_id IS NOT NULL THEN
4521: OPEN csr_get_arc_bal_value(p_assignment_action_id,l_def_bal_id);
4514: FETCH csr_get_def_bal INTO l_def_bal_id;
4515: CLOSE csr_get_def_bal;
4516: hr_utility.set_location('p_payroll_action_id '||p_payroll_action_id,400);
4517: hr_utility.set_location('p_balance_name '||p_balance_name,400);
4518: hr_utility.set_location('l_def_bal_id '||l_def_bal_id,400);
4519:
4520: IF l_def_bal_id IS NOT NULL THEN
4521: OPEN csr_get_arc_bal_value(p_assignment_action_id,l_def_bal_id);
4522: FETCH csr_get_arc_bal_value into l_bal_value;
4524: END IF;
4525:
4526: END IF;
4527: /*Bug 3986018*/
4528: hr_utility.set_location('l_def_bal_id '||l_def_bal_id,400);
4529:
4530: return(nvl(l_bal_value,0));
4531:
4532: END get_arc_bal_value;