DBA Data[Home] [Help]

APPS.PAY_AU_PAYMENT_SUMMARY_REPORT dependencies on PAY_MAG_TAPE

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

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

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

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

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

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

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'

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

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

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

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

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

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

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

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

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

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

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

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;

Line 425: l_template_name := 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;
428:
429: END LOOP;

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

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

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

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

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

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

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

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

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;

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

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

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

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

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

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

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;

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

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

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

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;

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

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;

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

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;

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

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:

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

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