647: Begin
648: LOOP
649: l_count := l_count + 1;
650: hr_utility.set_location('Before payroll action' , 25);
651: hr_utility.set_location('mag_internal ' || pay_mag_tape.internal_prm_names(l_count) , 105);
652: hr_utility.set_location('mag_internal ' || pay_mag_tape.internal_prm_values(l_count) , 115);
653: l_passed_sort_order:=pay_mag_tape.internal_prm_names(l_count);
654: IF pay_mag_tape.internal_prm_names(l_count) = 'TRANSFER_PAYROLL_ACTION_ID'
655: THEN
648: LOOP
649: l_count := l_count + 1;
650: hr_utility.set_location('Before payroll action' , 25);
651: hr_utility.set_location('mag_internal ' || pay_mag_tape.internal_prm_names(l_count) , 105);
652: hr_utility.set_location('mag_internal ' || pay_mag_tape.internal_prm_values(l_count) , 115);
653: l_passed_sort_order:=pay_mag_tape.internal_prm_names(l_count);
654: IF pay_mag_tape.internal_prm_names(l_count) = 'TRANSFER_PAYROLL_ACTION_ID'
655: THEN
656: l_payroll_action_id := to_number(pay_mag_tape.internal_prm_values(l_count));
649: l_count := l_count + 1;
650: hr_utility.set_location('Before payroll action' , 25);
651: hr_utility.set_location('mag_internal ' || pay_mag_tape.internal_prm_names(l_count) , 105);
652: hr_utility.set_location('mag_internal ' || pay_mag_tape.internal_prm_values(l_count) , 115);
653: l_passed_sort_order:=pay_mag_tape.internal_prm_names(l_count);
654: IF pay_mag_tape.internal_prm_names(l_count) = 'TRANSFER_PAYROLL_ACTION_ID'
655: THEN
656: l_payroll_action_id := to_number(pay_mag_tape.internal_prm_values(l_count));
657: hr_utility.set_location('payroll_action ',0);
650: hr_utility.set_location('Before payroll action' , 25);
651: hr_utility.set_location('mag_internal ' || pay_mag_tape.internal_prm_names(l_count) , 105);
652: hr_utility.set_location('mag_internal ' || pay_mag_tape.internal_prm_values(l_count) , 115);
653: l_passed_sort_order:=pay_mag_tape.internal_prm_names(l_count);
654: IF pay_mag_tape.internal_prm_names(l_count) = 'TRANSFER_PAYROLL_ACTION_ID'
655: THEN
656: l_payroll_action_id := to_number(pay_mag_tape.internal_prm_values(l_count));
657: hr_utility.set_location('payroll_action ',0);
658: ELSIF l_passed_sort_order= 'SORT_ORDER1'
652: hr_utility.set_location('mag_internal ' || pay_mag_tape.internal_prm_values(l_count) , 115);
653: l_passed_sort_order:=pay_mag_tape.internal_prm_names(l_count);
654: IF pay_mag_tape.internal_prm_names(l_count) = 'TRANSFER_PAYROLL_ACTION_ID'
655: THEN
656: l_payroll_action_id := to_number(pay_mag_tape.internal_prm_values(l_count));
657: hr_utility.set_location('payroll_action ',0);
658: ELSIF l_passed_sort_order= 'SORT_ORDER1'
659: THEN
660: l_sort_order1 := pay_mag_tape.internal_prm_values(l_count);
656: l_payroll_action_id := to_number(pay_mag_tape.internal_prm_values(l_count));
657: hr_utility.set_location('payroll_action ',0);
658: ELSIF l_passed_sort_order= 'SORT_ORDER1'
659: THEN
660: l_sort_order1 := pay_mag_tape.internal_prm_values(l_count);
661: hr_utility.set_location('in sort order1 ',1);
662: ELSIF l_passed_sort_order= 'SORT_ORDER2'
663: THEN
664: l_sort_order2 := pay_mag_tape.internal_prm_values(l_count);
660: l_sort_order1 := pay_mag_tape.internal_prm_values(l_count);
661: hr_utility.set_location('in sort order1 ',1);
662: ELSIF l_passed_sort_order= 'SORT_ORDER2'
663: THEN
664: l_sort_order2 := pay_mag_tape.internal_prm_values(l_count);
665: hr_utility.set_location('in sort_order 2 ',2);
666: ELSIF l_passed_sort_order= 'SORT_ORDER3'
667: THEN
668: hr_utility.set_location('in sort_order3 ',3);
665: hr_utility.set_location('in sort_order 2 ',2);
666: ELSIF l_passed_sort_order= 'SORT_ORDER3'
667: THEN
668: hr_utility.set_location('in sort_order3 ',3);
669: l_sort_order3 := pay_mag_tape.internal_prm_values(l_count);
670: ELSIF l_passed_sort_order= 'SORT_ORDER4'
671: THEN
672: l_sort_order4 := pay_mag_tape.internal_prm_values(l_count);
673: hr_utility.set_location('in sort_orderr4 ',4);
668: hr_utility.set_location('in sort_order3 ',3);
669: l_sort_order3 := pay_mag_tape.internal_prm_values(l_count);
670: ELSIF l_passed_sort_order= 'SORT_ORDER4'
671: THEN
672: l_sort_order4 := pay_mag_tape.internal_prm_values(l_count);
673: hr_utility.set_location('in sort_orderr4 ',4);
674: /* Bug 3132172 Duplex Printing Support*/
675: ELSIF pay_mag_tape.internal_prm_names(l_count) = 'DUPLEX_PRINT_FLAG'
676: THEN
671: THEN
672: l_sort_order4 := pay_mag_tape.internal_prm_values(l_count);
673: hr_utility.set_location('in sort_orderr4 ',4);
674: /* Bug 3132172 Duplex Printing Support*/
675: ELSIF pay_mag_tape.internal_prm_names(l_count) = 'DUPLEX_PRINT_FLAG'
676: THEN
677: l_duplex_print_flag := pay_mag_tape.internal_prm_values(l_count);
678: hr_utility.set_location('in duplex_print_flag',5);
679: /* Bug 4859876 - Template Code for PDF Output */
673: hr_utility.set_location('in sort_orderr4 ',4);
674: /* Bug 3132172 Duplex Printing Support*/
675: ELSIF pay_mag_tape.internal_prm_names(l_count) = 'DUPLEX_PRINT_FLAG'
676: THEN
677: l_duplex_print_flag := pay_mag_tape.internal_prm_values(l_count);
678: hr_utility.set_location('in duplex_print_flag',5);
679: /* Bug 4859876 - Template Code for PDF Output */
680: ELSIF pay_mag_tape.internal_prm_names(l_count) = 'TMPL'
681: THEN
676: THEN
677: l_duplex_print_flag := pay_mag_tape.internal_prm_values(l_count);
678: hr_utility.set_location('in duplex_print_flag',5);
679: /* Bug 4859876 - Template Code for PDF Output */
680: ELSIF pay_mag_tape.internal_prm_names(l_count) = 'TMPL'
681: THEN
682: l_template_name := pay_mag_tape.internal_prm_values(l_count);
683: hr_utility.set_location('in Template Names'||l_template_name,6);
684: END IF;
678: hr_utility.set_location('in duplex_print_flag',5);
679: /* Bug 4859876 - Template Code for PDF Output */
680: ELSIF pay_mag_tape.internal_prm_names(l_count) = 'TMPL'
681: THEN
682: l_template_name := pay_mag_tape.internal_prm_values(l_count);
683: hr_utility.set_location('in Template Names'||l_template_name,6);
684: END IF;
685:
686: END LOOP;
796: OPEN csr_get_formula_id('AU_PS_REPORT');
797: FETCH csr_get_formula_id INTO l_formula_id;
798: CLOSE csr_get_formula_id;
799:
800: pay_mag_tape.internal_prm_names(1) := 'NO_OF_PARAMETERS';
801: pay_mag_tape.internal_prm_values(1) := '5';
802: pay_mag_tape.internal_prm_names(2) := 'NEW_FORMULA_ID';
803: pay_mag_tape.internal_prm_values(2) := to_char(l_formula_id);
804: pay_mag_tape.internal_prm_names(3) := 'PS_REQUEST_ID';
797: FETCH csr_get_formula_id INTO l_formula_id;
798: CLOSE csr_get_formula_id;
799:
800: pay_mag_tape.internal_prm_names(1) := 'NO_OF_PARAMETERS';
801: pay_mag_tape.internal_prm_values(1) := '5';
802: pay_mag_tape.internal_prm_names(2) := 'NEW_FORMULA_ID';
803: pay_mag_tape.internal_prm_values(2) := to_char(l_formula_id);
804: pay_mag_tape.internal_prm_names(3) := 'PS_REQUEST_ID';
805: pay_mag_tape.internal_prm_values(3) := to_char(ps_request_id);
798: CLOSE csr_get_formula_id;
799:
800: pay_mag_tape.internal_prm_names(1) := 'NO_OF_PARAMETERS';
801: pay_mag_tape.internal_prm_values(1) := '5';
802: pay_mag_tape.internal_prm_names(2) := 'NEW_FORMULA_ID';
803: pay_mag_tape.internal_prm_values(2) := to_char(l_formula_id);
804: pay_mag_tape.internal_prm_names(3) := 'PS_REQUEST_ID';
805: pay_mag_tape.internal_prm_values(3) := to_char(ps_request_id);
806: pay_mag_tape.internal_prm_names(4) := 'PAYROLL_ACTION_ID';
799:
800: pay_mag_tape.internal_prm_names(1) := 'NO_OF_PARAMETERS';
801: pay_mag_tape.internal_prm_values(1) := '5';
802: pay_mag_tape.internal_prm_names(2) := 'NEW_FORMULA_ID';
803: pay_mag_tape.internal_prm_values(2) := to_char(l_formula_id);
804: pay_mag_tape.internal_prm_names(3) := 'PS_REQUEST_ID';
805: pay_mag_tape.internal_prm_values(3) := to_char(ps_request_id);
806: pay_mag_tape.internal_prm_names(4) := 'PAYROLL_ACTION_ID';
807: pay_mag_tape.internal_prm_values(4) := to_char(l_payroll_action_id);
800: pay_mag_tape.internal_prm_names(1) := 'NO_OF_PARAMETERS';
801: pay_mag_tape.internal_prm_values(1) := '5';
802: pay_mag_tape.internal_prm_names(2) := 'NEW_FORMULA_ID';
803: pay_mag_tape.internal_prm_values(2) := to_char(l_formula_id);
804: pay_mag_tape.internal_prm_names(3) := 'PS_REQUEST_ID';
805: pay_mag_tape.internal_prm_values(3) := to_char(ps_request_id);
806: pay_mag_tape.internal_prm_names(4) := 'PAYROLL_ACTION_ID';
807: pay_mag_tape.internal_prm_values(4) := to_char(l_payroll_action_id);
808: pay_mag_tape.internal_prm_names(5) := 'SORT_ORDER1';
801: pay_mag_tape.internal_prm_values(1) := '5';
802: pay_mag_tape.internal_prm_names(2) := 'NEW_FORMULA_ID';
803: pay_mag_tape.internal_prm_values(2) := to_char(l_formula_id);
804: pay_mag_tape.internal_prm_names(3) := 'PS_REQUEST_ID';
805: pay_mag_tape.internal_prm_values(3) := to_char(ps_request_id);
806: pay_mag_tape.internal_prm_names(4) := 'PAYROLL_ACTION_ID';
807: pay_mag_tape.internal_prm_values(4) := to_char(l_payroll_action_id);
808: pay_mag_tape.internal_prm_names(5) := 'SORT_ORDER1';
809: pay_mag_tape.internal_prm_values(5) :=l_sort_order1;
802: pay_mag_tape.internal_prm_names(2) := 'NEW_FORMULA_ID';
803: pay_mag_tape.internal_prm_values(2) := to_char(l_formula_id);
804: pay_mag_tape.internal_prm_names(3) := 'PS_REQUEST_ID';
805: pay_mag_tape.internal_prm_values(3) := to_char(ps_request_id);
806: pay_mag_tape.internal_prm_names(4) := 'PAYROLL_ACTION_ID';
807: pay_mag_tape.internal_prm_values(4) := to_char(l_payroll_action_id);
808: pay_mag_tape.internal_prm_names(5) := 'SORT_ORDER1';
809: pay_mag_tape.internal_prm_values(5) :=l_sort_order1;
810: pay_mag_tape.internal_prm_names(6) := 'SORT_ORDER2';
803: pay_mag_tape.internal_prm_values(2) := to_char(l_formula_id);
804: pay_mag_tape.internal_prm_names(3) := 'PS_REQUEST_ID';
805: pay_mag_tape.internal_prm_values(3) := to_char(ps_request_id);
806: pay_mag_tape.internal_prm_names(4) := 'PAYROLL_ACTION_ID';
807: pay_mag_tape.internal_prm_values(4) := to_char(l_payroll_action_id);
808: pay_mag_tape.internal_prm_names(5) := 'SORT_ORDER1';
809: pay_mag_tape.internal_prm_values(5) :=l_sort_order1;
810: pay_mag_tape.internal_prm_names(6) := 'SORT_ORDER2';
811: pay_mag_tape.internal_prm_values(6) :=l_sort_order2;
804: pay_mag_tape.internal_prm_names(3) := 'PS_REQUEST_ID';
805: pay_mag_tape.internal_prm_values(3) := to_char(ps_request_id);
806: pay_mag_tape.internal_prm_names(4) := 'PAYROLL_ACTION_ID';
807: pay_mag_tape.internal_prm_values(4) := to_char(l_payroll_action_id);
808: pay_mag_tape.internal_prm_names(5) := 'SORT_ORDER1';
809: pay_mag_tape.internal_prm_values(5) :=l_sort_order1;
810: pay_mag_tape.internal_prm_names(6) := 'SORT_ORDER2';
811: pay_mag_tape.internal_prm_values(6) :=l_sort_order2;
812: pay_mag_tape.internal_prm_names(7) := 'SORT_ORDER3';
805: pay_mag_tape.internal_prm_values(3) := to_char(ps_request_id);
806: pay_mag_tape.internal_prm_names(4) := 'PAYROLL_ACTION_ID';
807: pay_mag_tape.internal_prm_values(4) := to_char(l_payroll_action_id);
808: pay_mag_tape.internal_prm_names(5) := 'SORT_ORDER1';
809: pay_mag_tape.internal_prm_values(5) :=l_sort_order1;
810: pay_mag_tape.internal_prm_names(6) := 'SORT_ORDER2';
811: pay_mag_tape.internal_prm_values(6) :=l_sort_order2;
812: pay_mag_tape.internal_prm_names(7) := 'SORT_ORDER3';
813: pay_mag_tape.internal_prm_values(7) :=l_sort_order3;
806: pay_mag_tape.internal_prm_names(4) := 'PAYROLL_ACTION_ID';
807: pay_mag_tape.internal_prm_values(4) := to_char(l_payroll_action_id);
808: pay_mag_tape.internal_prm_names(5) := 'SORT_ORDER1';
809: pay_mag_tape.internal_prm_values(5) :=l_sort_order1;
810: pay_mag_tape.internal_prm_names(6) := 'SORT_ORDER2';
811: pay_mag_tape.internal_prm_values(6) :=l_sort_order2;
812: pay_mag_tape.internal_prm_names(7) := 'SORT_ORDER3';
813: pay_mag_tape.internal_prm_values(7) :=l_sort_order3;
814: pay_mag_tape.internal_prm_names(8) := 'SORT_ORDER4';
807: pay_mag_tape.internal_prm_values(4) := to_char(l_payroll_action_id);
808: pay_mag_tape.internal_prm_names(5) := 'SORT_ORDER1';
809: pay_mag_tape.internal_prm_values(5) :=l_sort_order1;
810: pay_mag_tape.internal_prm_names(6) := 'SORT_ORDER2';
811: pay_mag_tape.internal_prm_values(6) :=l_sort_order2;
812: pay_mag_tape.internal_prm_names(7) := 'SORT_ORDER3';
813: pay_mag_tape.internal_prm_values(7) :=l_sort_order3;
814: pay_mag_tape.internal_prm_names(8) := 'SORT_ORDER4';
815: pay_mag_tape.internal_prm_values(8) :=l_sort_order4;
808: pay_mag_tape.internal_prm_names(5) := 'SORT_ORDER1';
809: pay_mag_tape.internal_prm_values(5) :=l_sort_order1;
810: pay_mag_tape.internal_prm_names(6) := 'SORT_ORDER2';
811: pay_mag_tape.internal_prm_values(6) :=l_sort_order2;
812: pay_mag_tape.internal_prm_names(7) := 'SORT_ORDER3';
813: pay_mag_tape.internal_prm_values(7) :=l_sort_order3;
814: pay_mag_tape.internal_prm_names(8) := 'SORT_ORDER4';
815: pay_mag_tape.internal_prm_values(8) :=l_sort_order4;
816: -- hr_utility.trace_off;
809: pay_mag_tape.internal_prm_values(5) :=l_sort_order1;
810: pay_mag_tape.internal_prm_names(6) := 'SORT_ORDER2';
811: pay_mag_tape.internal_prm_values(6) :=l_sort_order2;
812: pay_mag_tape.internal_prm_names(7) := 'SORT_ORDER3';
813: pay_mag_tape.internal_prm_values(7) :=l_sort_order3;
814: pay_mag_tape.internal_prm_names(8) := 'SORT_ORDER4';
815: pay_mag_tape.internal_prm_values(8) :=l_sort_order4;
816: -- hr_utility.trace_off;
817: end spawn_archive_reports;
810: pay_mag_tape.internal_prm_names(6) := 'SORT_ORDER2';
811: pay_mag_tape.internal_prm_values(6) :=l_sort_order2;
812: pay_mag_tape.internal_prm_names(7) := 'SORT_ORDER3';
813: pay_mag_tape.internal_prm_values(7) :=l_sort_order3;
814: pay_mag_tape.internal_prm_names(8) := 'SORT_ORDER4';
815: pay_mag_tape.internal_prm_values(8) :=l_sort_order4;
816: -- hr_utility.trace_off;
817: end spawn_archive_reports;
818:
811: pay_mag_tape.internal_prm_values(6) :=l_sort_order2;
812: pay_mag_tape.internal_prm_names(7) := 'SORT_ORDER3';
813: pay_mag_tape.internal_prm_values(7) :=l_sort_order3;
814: pay_mag_tape.internal_prm_names(8) := 'SORT_ORDER4';
815: pay_mag_tape.internal_prm_values(8) :=l_sort_order4;
816: -- hr_utility.trace_off;
817: end spawn_archive_reports;
818:
819: ---