DBA Data[Home] [Help]

APPS.PAY_AU_PAYMENT_SUMMARY_REPORT dependencies on PAY_MAG_TAPE

Line 651: hr_utility.set_location('mag_internal ' || pay_mag_tape.internal_prm_names(l_count) , 105);

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

Line 652: hr_utility.set_location('mag_internal ' || pay_mag_tape.internal_prm_values(l_count) , 115);

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));

Line 653: l_passed_sort_order:=pay_mag_tape.internal_prm_names(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);

Line 654: IF pay_mag_tape.internal_prm_names(l_count) = 'TRANSFER_PAYROLL_ACTION_ID'

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'

Line 656: l_payroll_action_id := to_number(pay_mag_tape.internal_prm_values(l_count));

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);

Line 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);

Line 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);

Line 669: l_sort_order3 := 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);
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);

Line 672: l_sort_order4 := pay_mag_tape.internal_prm_values(l_count);

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

Line 675: ELSIF pay_mag_tape.internal_prm_names(l_count) = 'DUPLEX_PRINT_FLAG'

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 */

Line 677: l_duplex_print_flag := 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 */
680: ELSIF pay_mag_tape.internal_prm_names(l_count) = 'TMPL'
681: THEN

Line 680: ELSIF pay_mag_tape.internal_prm_names(l_count) = 'TMPL'

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;

Line 682: l_template_name := 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;
685:
686: END LOOP;

Line 800: pay_mag_tape.internal_prm_names(1) := 'NO_OF_PARAMETERS';

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';

Line 801: pay_mag_tape.internal_prm_values(1) := '5';

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);

Line 802: pay_mag_tape.internal_prm_names(2) := 'NEW_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);
806: pay_mag_tape.internal_prm_names(4) := 'PAYROLL_ACTION_ID';

Line 803: pay_mag_tape.internal_prm_values(2) := to_char(l_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';
807: pay_mag_tape.internal_prm_values(4) := to_char(l_payroll_action_id);

Line 804: pay_mag_tape.internal_prm_names(3) := 'PS_REQUEST_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';

Line 805: pay_mag_tape.internal_prm_values(3) := to_char(ps_request_id);

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;

Line 806: pay_mag_tape.internal_prm_names(4) := 'PAYROLL_ACTION_ID';

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';

Line 807: pay_mag_tape.internal_prm_values(4) := to_char(l_payroll_action_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';
811: pay_mag_tape.internal_prm_values(6) :=l_sort_order2;

Line 808: pay_mag_tape.internal_prm_names(5) := 'SORT_ORDER1';

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';

Line 809: pay_mag_tape.internal_prm_values(5) :=l_sort_order1;

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;

Line 810: pay_mag_tape.internal_prm_names(6) := 'SORT_ORDER2';

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';

Line 811: pay_mag_tape.internal_prm_values(6) :=l_sort_order2;

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;

Line 812: pay_mag_tape.internal_prm_names(7) := 'SORT_ORDER3';

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;

Line 813: pay_mag_tape.internal_prm_values(7) :=l_sort_order3;

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;

Line 814: pay_mag_tape.internal_prm_names(8) := 'SORT_ORDER4';

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:

Line 815: pay_mag_tape.internal_prm_values(8) :=l_sort_order4;

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: ---