390: Begin
391: LOOP
392: l_count := l_count + 1;
393: hr_utility.set_location('Before payroll action' , 25);
394: hr_utility.set_location('mag_internal ' || pay_mag_tape.internal_prm_names(l_count) , 105);
395: hr_utility.set_location('mag_internal ' || pay_mag_tape.internal_prm_values(l_count) , 115);
396: l_passed_sort_order:=pay_mag_tape.internal_prm_names(l_count);
397: IF pay_mag_tape.internal_prm_names(l_count) = 'TRANSFER_PAYROLL_ACTION_ID'
398: THEN
391: LOOP
392: l_count := l_count + 1;
393: hr_utility.set_location('Before payroll action' , 25);
394: hr_utility.set_location('mag_internal ' || pay_mag_tape.internal_prm_names(l_count) , 105);
395: hr_utility.set_location('mag_internal ' || pay_mag_tape.internal_prm_values(l_count) , 115);
396: l_passed_sort_order:=pay_mag_tape.internal_prm_names(l_count);
397: IF pay_mag_tape.internal_prm_names(l_count) = 'TRANSFER_PAYROLL_ACTION_ID'
398: THEN
399: l_payroll_action_id := to_number(pay_mag_tape.internal_prm_values(l_count));
392: l_count := l_count + 1;
393: hr_utility.set_location('Before payroll action' , 25);
394: hr_utility.set_location('mag_internal ' || pay_mag_tape.internal_prm_names(l_count) , 105);
395: hr_utility.set_location('mag_internal ' || pay_mag_tape.internal_prm_values(l_count) , 115);
396: l_passed_sort_order:=pay_mag_tape.internal_prm_names(l_count);
397: IF pay_mag_tape.internal_prm_names(l_count) = 'TRANSFER_PAYROLL_ACTION_ID'
398: THEN
399: l_payroll_action_id := to_number(pay_mag_tape.internal_prm_values(l_count));
400: hr_utility.set_location('payroll_action ',0);
393: hr_utility.set_location('Before payroll action' , 25);
394: hr_utility.set_location('mag_internal ' || pay_mag_tape.internal_prm_names(l_count) , 105);
395: hr_utility.set_location('mag_internal ' || pay_mag_tape.internal_prm_values(l_count) , 115);
396: l_passed_sort_order:=pay_mag_tape.internal_prm_names(l_count);
397: IF pay_mag_tape.internal_prm_names(l_count) = 'TRANSFER_PAYROLL_ACTION_ID'
398: THEN
399: l_payroll_action_id := to_number(pay_mag_tape.internal_prm_values(l_count));
400: hr_utility.set_location('payroll_action ',0);
401: ELSIF l_passed_sort_order= 'SORT_ORDER1'
395: hr_utility.set_location('mag_internal ' || pay_mag_tape.internal_prm_values(l_count) , 115);
396: l_passed_sort_order:=pay_mag_tape.internal_prm_names(l_count);
397: IF pay_mag_tape.internal_prm_names(l_count) = 'TRANSFER_PAYROLL_ACTION_ID'
398: THEN
399: l_payroll_action_id := to_number(pay_mag_tape.internal_prm_values(l_count));
400: hr_utility.set_location('payroll_action ',0);
401: ELSIF l_passed_sort_order= 'SORT_ORDER1'
402: THEN
403: l_sort_order1 := pay_mag_tape.internal_prm_values(l_count);
399: l_payroll_action_id := to_number(pay_mag_tape.internal_prm_values(l_count));
400: hr_utility.set_location('payroll_action ',0);
401: ELSIF l_passed_sort_order= 'SORT_ORDER1'
402: THEN
403: l_sort_order1 := pay_mag_tape.internal_prm_values(l_count);
404: hr_utility.set_location('in sort order1 ',1);
405: ELSIF l_passed_sort_order= 'SORT_ORDER2'
406: THEN
407: l_sort_order2 := pay_mag_tape.internal_prm_values(l_count);
403: l_sort_order1 := pay_mag_tape.internal_prm_values(l_count);
404: hr_utility.set_location('in sort order1 ',1);
405: ELSIF l_passed_sort_order= 'SORT_ORDER2'
406: THEN
407: l_sort_order2 := pay_mag_tape.internal_prm_values(l_count);
408: hr_utility.set_location('in sort_order 2 ',2);
409: ELSIF l_passed_sort_order= 'SORT_ORDER3'
410: THEN
411: hr_utility.set_location('in sort_order3 ',3);
408: hr_utility.set_location('in sort_order 2 ',2);
409: ELSIF l_passed_sort_order= 'SORT_ORDER3'
410: THEN
411: hr_utility.set_location('in sort_order3 ',3);
412: l_sort_order3 := pay_mag_tape.internal_prm_values(l_count);
413: ELSIF l_passed_sort_order= 'SORT_ORDER4'
414: THEN
415: l_sort_order4 := pay_mag_tape.internal_prm_values(l_count);
416: hr_utility.set_location('in sort_orderr4 ',4);
411: hr_utility.set_location('in sort_order3 ',3);
412: l_sort_order3 := pay_mag_tape.internal_prm_values(l_count);
413: ELSIF l_passed_sort_order= 'SORT_ORDER4'
414: THEN
415: l_sort_order4 := pay_mag_tape.internal_prm_values(l_count);
416: hr_utility.set_location('in sort_orderr4 ',4);
417: /* Bug 3132172 Duplex Printing Support*/
418: ELSIF pay_mag_tape.internal_prm_names(l_count) = 'DUPLEX_PRINT_FLAG'
419: THEN
414: THEN
415: l_sort_order4 := pay_mag_tape.internal_prm_values(l_count);
416: hr_utility.set_location('in sort_orderr4 ',4);
417: /* Bug 3132172 Duplex Printing Support*/
418: ELSIF pay_mag_tape.internal_prm_names(l_count) = 'DUPLEX_PRINT_FLAG'
419: THEN
420: l_duplex_print_flag := pay_mag_tape.internal_prm_values(l_count);
421: hr_utility.set_location('in duplex_print_flag',5);
422: /* Bug 4859876 - Template Code for PDF Output */
416: hr_utility.set_location('in sort_orderr4 ',4);
417: /* Bug 3132172 Duplex Printing Support*/
418: ELSIF pay_mag_tape.internal_prm_names(l_count) = 'DUPLEX_PRINT_FLAG'
419: THEN
420: l_duplex_print_flag := pay_mag_tape.internal_prm_values(l_count);
421: hr_utility.set_location('in duplex_print_flag',5);
422: /* Bug 4859876 - Template Code for PDF Output */
423: ELSIF pay_mag_tape.internal_prm_names(l_count) = 'TMPL'
424: THEN
419: THEN
420: l_duplex_print_flag := pay_mag_tape.internal_prm_values(l_count);
421: hr_utility.set_location('in duplex_print_flag',5);
422: /* Bug 4859876 - Template Code for PDF Output */
423: ELSIF pay_mag_tape.internal_prm_names(l_count) = 'TMPL'
424: THEN
425: l_template_name := pay_mag_tape.internal_prm_values(l_count);
426: hr_utility.set_location('in Template Names'||l_template_name,6);
427: END IF;
421: hr_utility.set_location('in duplex_print_flag',5);
422: /* Bug 4859876 - Template Code for PDF Output */
423: ELSIF pay_mag_tape.internal_prm_names(l_count) = 'TMPL'
424: THEN
425: l_template_name := pay_mag_tape.internal_prm_values(l_count);
426: hr_utility.set_location('in Template Names'||l_template_name,6);
427: END IF;
428:
429: END LOOP;
539: OPEN csr_get_formula_id('AU_PS_REPORT');
540: FETCH csr_get_formula_id INTO l_formula_id;
541: CLOSE csr_get_formula_id;
542:
543: pay_mag_tape.internal_prm_names(1) := 'NO_OF_PARAMETERS';
544: pay_mag_tape.internal_prm_values(1) := '5';
545: pay_mag_tape.internal_prm_names(2) := 'NEW_FORMULA_ID';
546: pay_mag_tape.internal_prm_values(2) := to_char(l_formula_id);
547: pay_mag_tape.internal_prm_names(3) := 'PS_REQUEST_ID';
540: FETCH csr_get_formula_id INTO l_formula_id;
541: CLOSE csr_get_formula_id;
542:
543: pay_mag_tape.internal_prm_names(1) := 'NO_OF_PARAMETERS';
544: pay_mag_tape.internal_prm_values(1) := '5';
545: pay_mag_tape.internal_prm_names(2) := 'NEW_FORMULA_ID';
546: pay_mag_tape.internal_prm_values(2) := to_char(l_formula_id);
547: pay_mag_tape.internal_prm_names(3) := 'PS_REQUEST_ID';
548: pay_mag_tape.internal_prm_values(3) := to_char(ps_request_id);
541: CLOSE csr_get_formula_id;
542:
543: pay_mag_tape.internal_prm_names(1) := 'NO_OF_PARAMETERS';
544: pay_mag_tape.internal_prm_values(1) := '5';
545: pay_mag_tape.internal_prm_names(2) := 'NEW_FORMULA_ID';
546: pay_mag_tape.internal_prm_values(2) := to_char(l_formula_id);
547: pay_mag_tape.internal_prm_names(3) := 'PS_REQUEST_ID';
548: pay_mag_tape.internal_prm_values(3) := to_char(ps_request_id);
549: pay_mag_tape.internal_prm_names(4) := 'PAYROLL_ACTION_ID';
542:
543: pay_mag_tape.internal_prm_names(1) := 'NO_OF_PARAMETERS';
544: pay_mag_tape.internal_prm_values(1) := '5';
545: pay_mag_tape.internal_prm_names(2) := 'NEW_FORMULA_ID';
546: pay_mag_tape.internal_prm_values(2) := to_char(l_formula_id);
547: pay_mag_tape.internal_prm_names(3) := 'PS_REQUEST_ID';
548: pay_mag_tape.internal_prm_values(3) := to_char(ps_request_id);
549: pay_mag_tape.internal_prm_names(4) := 'PAYROLL_ACTION_ID';
550: pay_mag_tape.internal_prm_values(4) := to_char(l_payroll_action_id);
543: pay_mag_tape.internal_prm_names(1) := 'NO_OF_PARAMETERS';
544: pay_mag_tape.internal_prm_values(1) := '5';
545: pay_mag_tape.internal_prm_names(2) := 'NEW_FORMULA_ID';
546: pay_mag_tape.internal_prm_values(2) := to_char(l_formula_id);
547: pay_mag_tape.internal_prm_names(3) := 'PS_REQUEST_ID';
548: pay_mag_tape.internal_prm_values(3) := to_char(ps_request_id);
549: pay_mag_tape.internal_prm_names(4) := 'PAYROLL_ACTION_ID';
550: pay_mag_tape.internal_prm_values(4) := to_char(l_payroll_action_id);
551: pay_mag_tape.internal_prm_names(5) := 'SORT_ORDER1';
544: pay_mag_tape.internal_prm_values(1) := '5';
545: pay_mag_tape.internal_prm_names(2) := 'NEW_FORMULA_ID';
546: pay_mag_tape.internal_prm_values(2) := to_char(l_formula_id);
547: pay_mag_tape.internal_prm_names(3) := 'PS_REQUEST_ID';
548: pay_mag_tape.internal_prm_values(3) := to_char(ps_request_id);
549: pay_mag_tape.internal_prm_names(4) := 'PAYROLL_ACTION_ID';
550: pay_mag_tape.internal_prm_values(4) := to_char(l_payroll_action_id);
551: pay_mag_tape.internal_prm_names(5) := 'SORT_ORDER1';
552: pay_mag_tape.internal_prm_values(5) :=l_sort_order1;
545: pay_mag_tape.internal_prm_names(2) := 'NEW_FORMULA_ID';
546: pay_mag_tape.internal_prm_values(2) := to_char(l_formula_id);
547: pay_mag_tape.internal_prm_names(3) := 'PS_REQUEST_ID';
548: pay_mag_tape.internal_prm_values(3) := to_char(ps_request_id);
549: pay_mag_tape.internal_prm_names(4) := 'PAYROLL_ACTION_ID';
550: pay_mag_tape.internal_prm_values(4) := to_char(l_payroll_action_id);
551: pay_mag_tape.internal_prm_names(5) := 'SORT_ORDER1';
552: pay_mag_tape.internal_prm_values(5) :=l_sort_order1;
553: pay_mag_tape.internal_prm_names(6) := 'SORT_ORDER2';
546: pay_mag_tape.internal_prm_values(2) := to_char(l_formula_id);
547: pay_mag_tape.internal_prm_names(3) := 'PS_REQUEST_ID';
548: pay_mag_tape.internal_prm_values(3) := to_char(ps_request_id);
549: pay_mag_tape.internal_prm_names(4) := 'PAYROLL_ACTION_ID';
550: pay_mag_tape.internal_prm_values(4) := to_char(l_payroll_action_id);
551: pay_mag_tape.internal_prm_names(5) := 'SORT_ORDER1';
552: pay_mag_tape.internal_prm_values(5) :=l_sort_order1;
553: pay_mag_tape.internal_prm_names(6) := 'SORT_ORDER2';
554: pay_mag_tape.internal_prm_values(6) :=l_sort_order2;
547: pay_mag_tape.internal_prm_names(3) := 'PS_REQUEST_ID';
548: pay_mag_tape.internal_prm_values(3) := to_char(ps_request_id);
549: pay_mag_tape.internal_prm_names(4) := 'PAYROLL_ACTION_ID';
550: pay_mag_tape.internal_prm_values(4) := to_char(l_payroll_action_id);
551: pay_mag_tape.internal_prm_names(5) := 'SORT_ORDER1';
552: pay_mag_tape.internal_prm_values(5) :=l_sort_order1;
553: pay_mag_tape.internal_prm_names(6) := 'SORT_ORDER2';
554: pay_mag_tape.internal_prm_values(6) :=l_sort_order2;
555: pay_mag_tape.internal_prm_names(7) := 'SORT_ORDER3';
548: pay_mag_tape.internal_prm_values(3) := to_char(ps_request_id);
549: pay_mag_tape.internal_prm_names(4) := 'PAYROLL_ACTION_ID';
550: pay_mag_tape.internal_prm_values(4) := to_char(l_payroll_action_id);
551: pay_mag_tape.internal_prm_names(5) := 'SORT_ORDER1';
552: pay_mag_tape.internal_prm_values(5) :=l_sort_order1;
553: pay_mag_tape.internal_prm_names(6) := 'SORT_ORDER2';
554: pay_mag_tape.internal_prm_values(6) :=l_sort_order2;
555: pay_mag_tape.internal_prm_names(7) := 'SORT_ORDER3';
556: pay_mag_tape.internal_prm_values(7) :=l_sort_order3;
549: pay_mag_tape.internal_prm_names(4) := 'PAYROLL_ACTION_ID';
550: pay_mag_tape.internal_prm_values(4) := to_char(l_payroll_action_id);
551: pay_mag_tape.internal_prm_names(5) := 'SORT_ORDER1';
552: pay_mag_tape.internal_prm_values(5) :=l_sort_order1;
553: pay_mag_tape.internal_prm_names(6) := 'SORT_ORDER2';
554: pay_mag_tape.internal_prm_values(6) :=l_sort_order2;
555: pay_mag_tape.internal_prm_names(7) := 'SORT_ORDER3';
556: pay_mag_tape.internal_prm_values(7) :=l_sort_order3;
557: pay_mag_tape.internal_prm_names(8) := 'SORT_ORDER4';
550: pay_mag_tape.internal_prm_values(4) := to_char(l_payroll_action_id);
551: pay_mag_tape.internal_prm_names(5) := 'SORT_ORDER1';
552: pay_mag_tape.internal_prm_values(5) :=l_sort_order1;
553: pay_mag_tape.internal_prm_names(6) := 'SORT_ORDER2';
554: pay_mag_tape.internal_prm_values(6) :=l_sort_order2;
555: pay_mag_tape.internal_prm_names(7) := 'SORT_ORDER3';
556: pay_mag_tape.internal_prm_values(7) :=l_sort_order3;
557: pay_mag_tape.internal_prm_names(8) := 'SORT_ORDER4';
558: pay_mag_tape.internal_prm_values(8) :=l_sort_order4;
551: pay_mag_tape.internal_prm_names(5) := 'SORT_ORDER1';
552: pay_mag_tape.internal_prm_values(5) :=l_sort_order1;
553: pay_mag_tape.internal_prm_names(6) := 'SORT_ORDER2';
554: pay_mag_tape.internal_prm_values(6) :=l_sort_order2;
555: pay_mag_tape.internal_prm_names(7) := 'SORT_ORDER3';
556: pay_mag_tape.internal_prm_values(7) :=l_sort_order3;
557: pay_mag_tape.internal_prm_names(8) := 'SORT_ORDER4';
558: pay_mag_tape.internal_prm_values(8) :=l_sort_order4;
559: -- hr_utility.trace_off;
552: pay_mag_tape.internal_prm_values(5) :=l_sort_order1;
553: pay_mag_tape.internal_prm_names(6) := 'SORT_ORDER2';
554: pay_mag_tape.internal_prm_values(6) :=l_sort_order2;
555: pay_mag_tape.internal_prm_names(7) := 'SORT_ORDER3';
556: pay_mag_tape.internal_prm_values(7) :=l_sort_order3;
557: pay_mag_tape.internal_prm_names(8) := 'SORT_ORDER4';
558: pay_mag_tape.internal_prm_values(8) :=l_sort_order4;
559: -- hr_utility.trace_off;
560: end spawn_archive_reports;
553: pay_mag_tape.internal_prm_names(6) := 'SORT_ORDER2';
554: pay_mag_tape.internal_prm_values(6) :=l_sort_order2;
555: pay_mag_tape.internal_prm_names(7) := 'SORT_ORDER3';
556: pay_mag_tape.internal_prm_values(7) :=l_sort_order3;
557: pay_mag_tape.internal_prm_names(8) := 'SORT_ORDER4';
558: pay_mag_tape.internal_prm_values(8) :=l_sort_order4;
559: -- hr_utility.trace_off;
560: end spawn_archive_reports;
561:
554: pay_mag_tape.internal_prm_values(6) :=l_sort_order2;
555: pay_mag_tape.internal_prm_names(7) := 'SORT_ORDER3';
556: pay_mag_tape.internal_prm_values(7) :=l_sort_order3;
557: pay_mag_tape.internal_prm_names(8) := 'SORT_ORDER4';
558: pay_mag_tape.internal_prm_values(8) :=l_sort_order4;
559: -- hr_utility.trace_off;
560: end spawn_archive_reports;
561:
562: ---