eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_ZA_IRP5_ARCHIVE_PKG dependencies on PAY_ARCHIVE

Line 429: l_context_no := pay_archive.g_context_values.sz;

425:
426: hr_utility.set_location('l_pact_id is ' || l_pact_id, 999);
427:
428: -- Clear the PL/SQL table that contains the contexts
429: l_context_no := pay_archive.g_context_values.sz;
430: hr_utility.set_location('l_context_no ' ||l_context_no,1);
431: for i in 1..l_context_no loop
432:
433:

Line 435: pay_archive.g_context_values.name(i) := NULL;

431: for i in 1..l_context_no loop
432:
433:
434:
435: pay_archive.g_context_values.name(i) := NULL;
436: pay_archive.g_context_values.value(i) := NULL;
437:
438: end loop;
439:

Line 436: pay_archive.g_context_values.value(i) := NULL;

432:
433:
434:
435: pay_archive.g_context_values.name(i) := NULL;
436: pay_archive.g_context_values.value(i) := NULL;
437:
438: end loop;
439:
440: pay_archive.g_context_values.sz := 0;

Line 440: pay_archive.g_context_values.sz := 0;

436: pay_archive.g_context_values.value(i) := NULL;
437:
438: end loop;
439:
440: pay_archive.g_context_values.sz := 0;
441: l_count := 0;
442:
443: /* Set up the assignment id, date earned and payroll id contexts */
444: l_count := l_count + 1;

Line 445: pay_archive.g_context_values.name(l_count) := 'ASSIGNMENT_ID';

441: l_count := 0;
442:
443: /* Set up the assignment id, date earned and payroll id contexts */
444: l_count := l_count + 1;
445: pay_archive.g_context_values.name(l_count) := 'ASSIGNMENT_ID';
446: pay_archive.g_context_values.value(l_count) := asgid;
447: hr_utility.set_location('pay_archive.g_context_values.name(l_count) ' ||pay_archive.g_context_values.name(l_count),1);
448: hr_utility.set_location('pay_archive.g_context_values.value(l_count) ' ||pay_archive.g_context_values.value(l_count),1);
449:

Line 446: pay_archive.g_context_values.value(l_count) := asgid;

442:
443: /* Set up the assignment id, date earned and payroll id contexts */
444: l_count := l_count + 1;
445: pay_archive.g_context_values.name(l_count) := 'ASSIGNMENT_ID';
446: pay_archive.g_context_values.value(l_count) := asgid;
447: hr_utility.set_location('pay_archive.g_context_values.name(l_count) ' ||pay_archive.g_context_values.name(l_count),1);
448: hr_utility.set_location('pay_archive.g_context_values.value(l_count) ' ||pay_archive.g_context_values.value(l_count),1);
449:
450:

Line 447: hr_utility.set_location('pay_archive.g_context_values.name(l_count) ' ||pay_archive.g_context_values.name(l_count),1);

443: /* Set up the assignment id, date earned and payroll id contexts */
444: l_count := l_count + 1;
445: pay_archive.g_context_values.name(l_count) := 'ASSIGNMENT_ID';
446: pay_archive.g_context_values.value(l_count) := asgid;
447: hr_utility.set_location('pay_archive.g_context_values.name(l_count) ' ||pay_archive.g_context_values.name(l_count),1);
448: hr_utility.set_location('pay_archive.g_context_values.value(l_count) ' ||pay_archive.g_context_values.value(l_count),1);
449:
450:
451: l_count := l_count + 1;

Line 448: hr_utility.set_location('pay_archive.g_context_values.value(l_count) ' ||pay_archive.g_context_values.value(l_count),1);

444: l_count := l_count + 1;
445: pay_archive.g_context_values.name(l_count) := 'ASSIGNMENT_ID';
446: pay_archive.g_context_values.value(l_count) := asgid;
447: hr_utility.set_location('pay_archive.g_context_values.name(l_count) ' ||pay_archive.g_context_values.name(l_count),1);
448: hr_utility.set_location('pay_archive.g_context_values.value(l_count) ' ||pay_archive.g_context_values.value(l_count),1);
449:
450:
451: l_count := l_count + 1;
452: pay_archive.g_context_values.name(l_count) := 'PAYROLL_ID';

Line 452: pay_archive.g_context_values.name(l_count) := 'PAYROLL_ID';

448: hr_utility.set_location('pay_archive.g_context_values.value(l_count) ' ||pay_archive.g_context_values.value(l_count),1);
449:
450:
451: l_count := l_count + 1;
452: pay_archive.g_context_values.name(l_count) := 'PAYROLL_ID';
453: pay_archive.g_context_values.value(l_count) := l_payroll_id;
454:
455: hr_utility.set_location('pay_archive.g_context_values.name(l_count) ' ||pay_archive.g_context_values.name(l_count),1);
456: hr_utility.set_location('pay_archive.g_context_values.value(l_count) ' ||pay_archive.g_context_values.value(l_count),1);

Line 453: pay_archive.g_context_values.value(l_count) := l_payroll_id;

449:
450:
451: l_count := l_count + 1;
452: pay_archive.g_context_values.name(l_count) := 'PAYROLL_ID';
453: pay_archive.g_context_values.value(l_count) := l_payroll_id;
454:
455: hr_utility.set_location('pay_archive.g_context_values.name(l_count) ' ||pay_archive.g_context_values.name(l_count),1);
456: hr_utility.set_location('pay_archive.g_context_values.value(l_count) ' ||pay_archive.g_context_values.value(l_count),1);
457:

Line 455: hr_utility.set_location('pay_archive.g_context_values.name(l_count) ' ||pay_archive.g_context_values.name(l_count),1);

451: l_count := l_count + 1;
452: pay_archive.g_context_values.name(l_count) := 'PAYROLL_ID';
453: pay_archive.g_context_values.value(l_count) := l_payroll_id;
454:
455: hr_utility.set_location('pay_archive.g_context_values.name(l_count) ' ||pay_archive.g_context_values.name(l_count),1);
456: hr_utility.set_location('pay_archive.g_context_values.value(l_count) ' ||pay_archive.g_context_values.value(l_count),1);
457:
458: l_count := l_count + 1;
459: pay_archive.g_context_values.name(l_count) := 'DATE_EARNED';

Line 456: hr_utility.set_location('pay_archive.g_context_values.value(l_count) ' ||pay_archive.g_context_values.value(l_count),1);

452: pay_archive.g_context_values.name(l_count) := 'PAYROLL_ID';
453: pay_archive.g_context_values.value(l_count) := l_payroll_id;
454:
455: hr_utility.set_location('pay_archive.g_context_values.name(l_count) ' ||pay_archive.g_context_values.name(l_count),1);
456: hr_utility.set_location('pay_archive.g_context_values.value(l_count) ' ||pay_archive.g_context_values.value(l_count),1);
457:
458: l_count := l_count + 1;
459: pay_archive.g_context_values.name(l_count) := 'DATE_EARNED';
460: pay_archive.g_context_values.value(l_count) := l_eff_date;

Line 459: pay_archive.g_context_values.name(l_count) := 'DATE_EARNED';

455: hr_utility.set_location('pay_archive.g_context_values.name(l_count) ' ||pay_archive.g_context_values.name(l_count),1);
456: hr_utility.set_location('pay_archive.g_context_values.value(l_count) ' ||pay_archive.g_context_values.value(l_count),1);
457:
458: l_count := l_count + 1;
459: pay_archive.g_context_values.name(l_count) := 'DATE_EARNED';
460: pay_archive.g_context_values.value(l_count) := l_eff_date;
461: hr_utility.set_location('pay_archive.g_context_values.name(l_count) ' ||pay_archive.g_context_values.name(l_count),1);
462: hr_utility.set_location('pay_archive.g_context_values.value(l_count) ' ||pay_archive.g_context_values.value(l_count),1);
463: -- Select the maximum action_sequence of an assignment action, for which

Line 460: pay_archive.g_context_values.value(l_count) := l_eff_date;

456: hr_utility.set_location('pay_archive.g_context_values.value(l_count) ' ||pay_archive.g_context_values.value(l_count),1);
457:
458: l_count := l_count + 1;
459: pay_archive.g_context_values.name(l_count) := 'DATE_EARNED';
460: pay_archive.g_context_values.value(l_count) := l_eff_date;
461: hr_utility.set_location('pay_archive.g_context_values.name(l_count) ' ||pay_archive.g_context_values.name(l_count),1);
462: hr_utility.set_location('pay_archive.g_context_values.value(l_count) ' ||pay_archive.g_context_values.value(l_count),1);
463: -- Select the maximum action_sequence of an assignment action, for which
464: -- a ZA_Tax_On_Lump_Sums element was processed in the same period, and

Line 461: hr_utility.set_location('pay_archive.g_context_values.name(l_count) ' ||pay_archive.g_context_values.name(l_count),1);

457:
458: l_count := l_count + 1;
459: pay_archive.g_context_values.name(l_count) := 'DATE_EARNED';
460: pay_archive.g_context_values.value(l_count) := l_eff_date;
461: hr_utility.set_location('pay_archive.g_context_values.name(l_count) ' ||pay_archive.g_context_values.name(l_count),1);
462: hr_utility.set_location('pay_archive.g_context_values.value(l_count) ' ||pay_archive.g_context_values.value(l_count),1);
463: -- Select the maximum action_sequence of an assignment action, for which
464: -- a ZA_Tax_On_Lump_Sums element was processed in the same period, and
465: -- for which a previous archive assignment action did not archive of the

Line 462: hr_utility.set_location('pay_archive.g_context_values.value(l_count) ' ||pay_archive.g_context_values.value(l_count),1);

458: l_count := l_count + 1;
459: pay_archive.g_context_values.name(l_count) := 'DATE_EARNED';
460: pay_archive.g_context_values.value(l_count) := l_eff_date;
461: hr_utility.set_location('pay_archive.g_context_values.name(l_count) ' ||pay_archive.g_context_values.name(l_count),1);
462: hr_utility.set_location('pay_archive.g_context_values.value(l_count) ' ||pay_archive.g_context_values.value(l_count),1);
463: -- Select the maximum action_sequence of an assignment action, for which
464: -- a ZA_Tax_On_Lump_Sums element was processed in the same period, and
465: -- for which a previous archive assignment action did not archive of the
466: -- same period into A_PAY_PROC_PERIOD_ID

Line 510: pay_archive.g_context_values.name(l_count) := 'ASSIGNMENT_ACTION_ID';

506: and action_sequence = aaseq;
507:
508: -- Assignment Action ID of a max(action_sequence) Payroll Run
509: l_count := l_count + 1;
510: pay_archive.g_context_values.name(l_count) := 'ASSIGNMENT_ACTION_ID';
511: pay_archive.g_context_values.value(l_count) := aaid;
512: pay_archive.balance_aa := aaid;
513: hr_utility.set_location('pay_archive.g_context_values.name(l_count) ' ||pay_archive.g_context_values.name(l_count),1);
514: hr_utility.set_location('pay_archive.g_context_values.value(l_count) ' ||pay_archive.g_context_values.value(l_count),1);

Line 511: pay_archive.g_context_values.value(l_count) := aaid;

507:
508: -- Assignment Action ID of a max(action_sequence) Payroll Run
509: l_count := l_count + 1;
510: pay_archive.g_context_values.name(l_count) := 'ASSIGNMENT_ACTION_ID';
511: pay_archive.g_context_values.value(l_count) := aaid;
512: pay_archive.balance_aa := aaid;
513: hr_utility.set_location('pay_archive.g_context_values.name(l_count) ' ||pay_archive.g_context_values.name(l_count),1);
514: hr_utility.set_location('pay_archive.g_context_values.value(l_count) ' ||pay_archive.g_context_values.value(l_count),1);
515:

Line 512: pay_archive.balance_aa := aaid;

508: -- Assignment Action ID of a max(action_sequence) Payroll Run
509: l_count := l_count + 1;
510: pay_archive.g_context_values.name(l_count) := 'ASSIGNMENT_ACTION_ID';
511: pay_archive.g_context_values.value(l_count) := aaid;
512: pay_archive.balance_aa := aaid;
513: hr_utility.set_location('pay_archive.g_context_values.name(l_count) ' ||pay_archive.g_context_values.name(l_count),1);
514: hr_utility.set_location('pay_archive.g_context_values.value(l_count) ' ||pay_archive.g_context_values.value(l_count),1);
515:
516: l_count := l_count + 1;

Line 513: hr_utility.set_location('pay_archive.g_context_values.name(l_count) ' ||pay_archive.g_context_values.name(l_count),1);

509: l_count := l_count + 1;
510: pay_archive.g_context_values.name(l_count) := 'ASSIGNMENT_ACTION_ID';
511: pay_archive.g_context_values.value(l_count) := aaid;
512: pay_archive.balance_aa := aaid;
513: hr_utility.set_location('pay_archive.g_context_values.name(l_count) ' ||pay_archive.g_context_values.name(l_count),1);
514: hr_utility.set_location('pay_archive.g_context_values.value(l_count) ' ||pay_archive.g_context_values.value(l_count),1);
515:
516: l_count := l_count + 1;
517: pay_archive.g_context_values.name(l_count) := 'PAYROLL_ACTION_ID';

Line 514: hr_utility.set_location('pay_archive.g_context_values.value(l_count) ' ||pay_archive.g_context_values.value(l_count),1);

510: pay_archive.g_context_values.name(l_count) := 'ASSIGNMENT_ACTION_ID';
511: pay_archive.g_context_values.value(l_count) := aaid;
512: pay_archive.balance_aa := aaid;
513: hr_utility.set_location('pay_archive.g_context_values.name(l_count) ' ||pay_archive.g_context_values.name(l_count),1);
514: hr_utility.set_location('pay_archive.g_context_values.value(l_count) ' ||pay_archive.g_context_values.value(l_count),1);
515:
516: l_count := l_count + 1;
517: pay_archive.g_context_values.name(l_count) := 'PAYROLL_ACTION_ID';
518: pay_archive.g_context_values.value(l_count) := paid;

Line 517: pay_archive.g_context_values.name(l_count) := 'PAYROLL_ACTION_ID';

513: hr_utility.set_location('pay_archive.g_context_values.name(l_count) ' ||pay_archive.g_context_values.name(l_count),1);
514: hr_utility.set_location('pay_archive.g_context_values.value(l_count) ' ||pay_archive.g_context_values.value(l_count),1);
515:
516: l_count := l_count + 1;
517: pay_archive.g_context_values.name(l_count) := 'PAYROLL_ACTION_ID';
518: pay_archive.g_context_values.value(l_count) := paid;
519: hr_utility.set_location('pay_archive.g_context_values.name(l_count) ' ||pay_archive.g_context_values.name(l_count),1);
520: hr_utility.set_location('pay_archive.g_context_values.value(l_count) ' ||pay_archive.g_context_values.value(l_count),1);
521:

Line 518: pay_archive.g_context_values.value(l_count) := paid;

514: hr_utility.set_location('pay_archive.g_context_values.value(l_count) ' ||pay_archive.g_context_values.value(l_count),1);
515:
516: l_count := l_count + 1;
517: pay_archive.g_context_values.name(l_count) := 'PAYROLL_ACTION_ID';
518: pay_archive.g_context_values.value(l_count) := paid;
519: hr_utility.set_location('pay_archive.g_context_values.name(l_count) ' ||pay_archive.g_context_values.name(l_count),1);
520: hr_utility.set_location('pay_archive.g_context_values.value(l_count) ' ||pay_archive.g_context_values.value(l_count),1);
521:
522: -- Save the current count

Line 519: hr_utility.set_location('pay_archive.g_context_values.name(l_count) ' ||pay_archive.g_context_values.name(l_count),1);

515:
516: l_count := l_count + 1;
517: pay_archive.g_context_values.name(l_count) := 'PAYROLL_ACTION_ID';
518: pay_archive.g_context_values.value(l_count) := paid;
519: hr_utility.set_location('pay_archive.g_context_values.name(l_count) ' ||pay_archive.g_context_values.name(l_count),1);
520: hr_utility.set_location('pay_archive.g_context_values.value(l_count) ' ||pay_archive.g_context_values.value(l_count),1);
521:
522: -- Save the current count
523: l_flag := l_count;

Line 520: hr_utility.set_location('pay_archive.g_context_values.value(l_count) ' ||pay_archive.g_context_values.value(l_count),1);

516: l_count := l_count + 1;
517: pay_archive.g_context_values.name(l_count) := 'PAYROLL_ACTION_ID';
518: pay_archive.g_context_values.value(l_count) := paid;
519: hr_utility.set_location('pay_archive.g_context_values.name(l_count) ' ||pay_archive.g_context_values.name(l_count),1);
520: hr_utility.set_location('pay_archive.g_context_values.value(l_count) ' ||pay_archive.g_context_values.value(l_count),1);
521:
522: -- Save the current count
523: l_flag := l_count;
524:

Line 530: pay_archive.g_context_values.name(l_count) := 'SOURCE_NUMBER';

526: -- execute cursor only if the certificate is main certificate
527: IF l_main_crt_flag = 0 then
528: for clrrev in curclr(aaid) loop
529: l_count := l_count + 1;
530: pay_archive.g_context_values.name(l_count) := 'SOURCE_NUMBER';
531: pay_archive.g_context_values.value(l_count) := clrrev.clearance_number;
532: hr_utility.set_location('pay_archive.g_context_values.name(l_count) ' ||pay_archive.g_context_values.name(l_count),1);
533: hr_utility.set_location('pay_archive.g_context_values.value(l_count) ' ||pay_archive.g_context_values.value(l_count),1);
534: end loop;

Line 531: pay_archive.g_context_values.value(l_count) := clrrev.clearance_number;

527: IF l_main_crt_flag = 0 then
528: for clrrev in curclr(aaid) loop
529: l_count := l_count + 1;
530: pay_archive.g_context_values.name(l_count) := 'SOURCE_NUMBER';
531: pay_archive.g_context_values.value(l_count) := clrrev.clearance_number;
532: hr_utility.set_location('pay_archive.g_context_values.name(l_count) ' ||pay_archive.g_context_values.name(l_count),1);
533: hr_utility.set_location('pay_archive.g_context_values.value(l_count) ' ||pay_archive.g_context_values.value(l_count),1);
534: end loop;
535: END if;

Line 532: hr_utility.set_location('pay_archive.g_context_values.name(l_count) ' ||pay_archive.g_context_values.name(l_count),1);

528: for clrrev in curclr(aaid) loop
529: l_count := l_count + 1;
530: pay_archive.g_context_values.name(l_count) := 'SOURCE_NUMBER';
531: pay_archive.g_context_values.value(l_count) := clrrev.clearance_number;
532: hr_utility.set_location('pay_archive.g_context_values.name(l_count) ' ||pay_archive.g_context_values.name(l_count),1);
533: hr_utility.set_location('pay_archive.g_context_values.value(l_count) ' ||pay_archive.g_context_values.value(l_count),1);
534: end loop;
535: END if;
536: -- Make sure that at least one Clearance Number exist,

Line 533: hr_utility.set_location('pay_archive.g_context_values.value(l_count) ' ||pay_archive.g_context_values.value(l_count),1);

529: l_count := l_count + 1;
530: pay_archive.g_context_values.name(l_count) := 'SOURCE_NUMBER';
531: pay_archive.g_context_values.value(l_count) := clrrev.clearance_number;
532: hr_utility.set_location('pay_archive.g_context_values.name(l_count) ' ||pay_archive.g_context_values.name(l_count),1);
533: hr_utility.set_location('pay_archive.g_context_values.value(l_count) ' ||pay_archive.g_context_values.value(l_count),1);
534: end loop;
535: END if;
536: -- Make sure that at least one Clearance Number exist,
537: -- otherwise create a dummy one

Line 541: pay_archive.g_context_values.name(l_count) := 'SOURCE_NUMBER';

537: -- otherwise create a dummy one
538: if l_flag = l_count then
539:
540: l_count := l_count + 1;
541: pay_archive.g_context_values.name(l_count) := 'SOURCE_NUMBER';
542: pay_archive.g_context_values.value(l_count) := '99999999999';
543: hr_utility.set_location('pay_archive.g_context_values.name(l_count) ' ||pay_archive.g_context_values.name(l_count),2);
544: hr_utility.set_location('pay_archive.g_context_values.value(l_count) ' ||pay_archive.g_context_values.value(l_count),2);
545: end if;

Line 542: pay_archive.g_context_values.value(l_count) := '99999999999';

538: if l_flag = l_count then
539:
540: l_count := l_count + 1;
541: pay_archive.g_context_values.name(l_count) := 'SOURCE_NUMBER';
542: pay_archive.g_context_values.value(l_count) := '99999999999';
543: hr_utility.set_location('pay_archive.g_context_values.name(l_count) ' ||pay_archive.g_context_values.name(l_count),2);
544: hr_utility.set_location('pay_archive.g_context_values.value(l_count) ' ||pay_archive.g_context_values.value(l_count),2);
545: end if;
546: l_flag := l_count;

Line 543: hr_utility.set_location('pay_archive.g_context_values.name(l_count) ' ||pay_archive.g_context_values.name(l_count),2);

539:
540: l_count := l_count + 1;
541: pay_archive.g_context_values.name(l_count) := 'SOURCE_NUMBER';
542: pay_archive.g_context_values.value(l_count) := '99999999999';
543: hr_utility.set_location('pay_archive.g_context_values.name(l_count) ' ||pay_archive.g_context_values.name(l_count),2);
544: hr_utility.set_location('pay_archive.g_context_values.value(l_count) ' ||pay_archive.g_context_values.value(l_count),2);
545: end if;
546: l_flag := l_count;
547: l_dir_no :=1;

Line 544: hr_utility.set_location('pay_archive.g_context_values.value(l_count) ' ||pay_archive.g_context_values.value(l_count),2);

540: l_count := l_count + 1;
541: pay_archive.g_context_values.name(l_count) := 'SOURCE_NUMBER';
542: pay_archive.g_context_values.value(l_count) := '99999999999';
543: hr_utility.set_location('pay_archive.g_context_values.name(l_count) ' ||pay_archive.g_context_values.name(l_count),2);
544: hr_utility.set_location('pay_archive.g_context_values.value(l_count) ' ||pay_archive.g_context_values.value(l_count),2);
545: end if;
546: l_flag := l_count;
547: l_dir_no :=1;
548:

Line 553: pay_archive.g_context_values.name(l_count) := 'SOURCE_TEXT';

549: IF l_main_crt_flag > 0 then
550: for dirnumrev in curdirnum (asgid,l_pact_id) loop
551: IF l_main_crt_flag = l_dir_no then
552: l_count := l_count + 1;
553: pay_archive.g_context_values.name(l_count) := 'SOURCE_TEXT';
554: pay_archive.g_context_values.value(l_count) := dirnumrev.directive_number;
555: hr_utility.set_location('pay_archive.g_context_values.name(l_count) ' ||pay_archive.g_context_values.name(l_count),1);
556: hr_utility.set_location('pay_archive.g_context_values.value(l_count) ' ||pay_archive.g_context_values.value(l_count),1);
557: END if;

Line 554: pay_archive.g_context_values.value(l_count) := dirnumrev.directive_number;

550: for dirnumrev in curdirnum (asgid,l_pact_id) loop
551: IF l_main_crt_flag = l_dir_no then
552: l_count := l_count + 1;
553: pay_archive.g_context_values.name(l_count) := 'SOURCE_TEXT';
554: pay_archive.g_context_values.value(l_count) := dirnumrev.directive_number;
555: hr_utility.set_location('pay_archive.g_context_values.name(l_count) ' ||pay_archive.g_context_values.name(l_count),1);
556: hr_utility.set_location('pay_archive.g_context_values.value(l_count) ' ||pay_archive.g_context_values.value(l_count),1);
557: END if;
558: l_dir_no := l_dir_no +1;

Line 555: hr_utility.set_location('pay_archive.g_context_values.name(l_count) ' ||pay_archive.g_context_values.name(l_count),1);

551: IF l_main_crt_flag = l_dir_no then
552: l_count := l_count + 1;
553: pay_archive.g_context_values.name(l_count) := 'SOURCE_TEXT';
554: pay_archive.g_context_values.value(l_count) := dirnumrev.directive_number;
555: hr_utility.set_location('pay_archive.g_context_values.name(l_count) ' ||pay_archive.g_context_values.name(l_count),1);
556: hr_utility.set_location('pay_archive.g_context_values.value(l_count) ' ||pay_archive.g_context_values.value(l_count),1);
557: END if;
558: l_dir_no := l_dir_no +1;
559: end loop;

Line 556: hr_utility.set_location('pay_archive.g_context_values.value(l_count) ' ||pay_archive.g_context_values.value(l_count),1);

552: l_count := l_count + 1;
553: pay_archive.g_context_values.name(l_count) := 'SOURCE_TEXT';
554: pay_archive.g_context_values.value(l_count) := dirnumrev.directive_number;
555: hr_utility.set_location('pay_archive.g_context_values.name(l_count) ' ||pay_archive.g_context_values.name(l_count),1);
556: hr_utility.set_location('pay_archive.g_context_values.value(l_count) ' ||pay_archive.g_context_values.value(l_count),1);
557: END if;
558: l_dir_no := l_dir_no +1;
559: end loop;
560: -- Setting default Tax directive Number

Line 563: pay_archive.g_context_values.name(l_count) := 'SOURCE_TEXT';

559: end loop;
560: -- Setting default Tax directive Number
561: if l_flag = l_count then
562: l_count := l_count + 1;
563: pay_archive.g_context_values.name(l_count) := 'SOURCE_TEXT';
564: pay_archive.g_context_values.value(l_count) := 'To Be Advised';
565: hr_utility.set_location('pay_archive.g_context_values.name(l_count) ' ||pay_archive.g_context_values.name(l_count),2);
566: hr_utility.set_location('pay_archive.g_context_values.value(l_count) ' ||pay_archive.g_context_values.value(l_count),2);
567: end if;

Line 564: pay_archive.g_context_values.value(l_count) := 'To Be Advised';

560: -- Setting default Tax directive Number
561: if l_flag = l_count then
562: l_count := l_count + 1;
563: pay_archive.g_context_values.name(l_count) := 'SOURCE_TEXT';
564: pay_archive.g_context_values.value(l_count) := 'To Be Advised';
565: hr_utility.set_location('pay_archive.g_context_values.name(l_count) ' ||pay_archive.g_context_values.name(l_count),2);
566: hr_utility.set_location('pay_archive.g_context_values.value(l_count) ' ||pay_archive.g_context_values.value(l_count),2);
567: end if;
568: else

Line 565: hr_utility.set_location('pay_archive.g_context_values.name(l_count) ' ||pay_archive.g_context_values.name(l_count),2);

561: if l_flag = l_count then
562: l_count := l_count + 1;
563: pay_archive.g_context_values.name(l_count) := 'SOURCE_TEXT';
564: pay_archive.g_context_values.value(l_count) := 'To Be Advised';
565: hr_utility.set_location('pay_archive.g_context_values.name(l_count) ' ||pay_archive.g_context_values.name(l_count),2);
566: hr_utility.set_location('pay_archive.g_context_values.value(l_count) ' ||pay_archive.g_context_values.value(l_count),2);
567: end if;
568: else
569: -- setting Context for Main Certificate

Line 566: hr_utility.set_location('pay_archive.g_context_values.value(l_count) ' ||pay_archive.g_context_values.value(l_count),2);

562: l_count := l_count + 1;
563: pay_archive.g_context_values.name(l_count) := 'SOURCE_TEXT';
564: pay_archive.g_context_values.value(l_count) := 'To Be Advised';
565: hr_utility.set_location('pay_archive.g_context_values.name(l_count) ' ||pay_archive.g_context_values.name(l_count),2);
566: hr_utility.set_location('pay_archive.g_context_values.value(l_count) ' ||pay_archive.g_context_values.value(l_count),2);
567: end if;
568: else
569: -- setting Context for Main Certificate
570: l_count := l_count + 1;

Line 572: pay_archive.g_context_values.name(l_count) := 'SOURCE_TEXT';

568: else
569: -- setting Context for Main Certificate
570: l_count := l_count + 1;
571: hr_utility.set_location('setting Context for Main Certificate ' ,3);
572: pay_archive.g_context_values.name(l_count) := 'SOURCE_TEXT';
573: pay_archive.g_context_values.value(l_count) := 'To Be Advised';
574:
575: END if;
576:

Line 573: pay_archive.g_context_values.value(l_count) := 'To Be Advised';

569: -- setting Context for Main Certificate
570: l_count := l_count + 1;
571: hr_utility.set_location('setting Context for Main Certificate ' ,3);
572: pay_archive.g_context_values.name(l_count) := 'SOURCE_TEXT';
573: pay_archive.g_context_values.value(l_count) := 'To Be Advised';
574:
575: END if;
576:
577:

Line 583: pay_archive.g_context_values.name(l_count) := 'SOURCE_ID';

579:
580: -- Populate the PL/SQL table with Deduction SARS codes
581: for sarrec in cursars loop
582: l_count := l_count + 1;
583: pay_archive.g_context_values.name(l_count) := 'SOURCE_ID';
584: pay_archive.g_context_values.value(l_count) := sarrec.code;
585: end loop;
586:
587: pay_archive.g_context_values.sz := l_count;

Line 584: pay_archive.g_context_values.value(l_count) := sarrec.code;

580: -- Populate the PL/SQL table with Deduction SARS codes
581: for sarrec in cursars loop
582: l_count := l_count + 1;
583: pay_archive.g_context_values.name(l_count) := 'SOURCE_ID';
584: pay_archive.g_context_values.value(l_count) := sarrec.code;
585: end loop;
586:
587: pay_archive.g_context_values.sz := l_count;
588: --hr_utility.trace_off;

Line 587: pay_archive.g_context_values.sz := l_count;

583: pay_archive.g_context_values.name(l_count) := 'SOURCE_ID';
584: pay_archive.g_context_values.value(l_count) := sarrec.code;
585: end loop;
586:
587: pay_archive.g_context_values.sz := l_count;
588: --hr_utility.trace_off;
589:
590: end archive_data;
591:

Line 696: pay_archive.archive_aa is the Assignment Action ID of the

692: Arguments :
693: Notes : The balances are placed in the PL/SQL table in the following
694: order: current PTD, future PTD, current YTD, future YTD
695: g_ls_assactid is the Assignment Action ID of a Payroll Run
696: pay_archive.archive_aa is the Assignment Action ID of the
697: Archiver
698: --------------------------------------------------------------------------*/
699: function get_lump_sum
700: (

Line 721: Where paa_arch.assignment_action_id = pay_archive.archive_aa;*/

717: -- Get and cache the Lump Sum Indicator
718: /* Select decode(count(source_action_id),0,'N','Y')
719: into g_ls_indicator
720: From pay_assignment_actions paa_arch
721: Where paa_arch.assignment_action_id = pay_archive.archive_aa;*/
722:
723: Select decode(count(*), 0 ,'Y', 'N')
724: into g_ls_indicator
725: From pay_payroll_actions ppa_arch,

Line 727: where paa_arch.assignment_action_id = pay_archive.archive_aa

723: Select decode(count(*), 0 ,'Y', 'N')
724: into g_ls_indicator
725: From pay_payroll_actions ppa_arch,
726: pay_assignment_actions paa_arch
727: where paa_arch.assignment_action_id = pay_archive.archive_aa
728: and ppa_arch.payroll_action_id = paa_arch.payroll_action_id
729: and paa_arch.assignment_action_id =
730: (
731: select max(paa.assignment_action_id)

Line 769: Where paa_arch.assignment_action_id = pay_archive.archive_aa;*/

765: -- Get and cache the Lump Sum Indicator
766: /* Select decode(count(source_action_id),0,'N','Y')
767: into g_ls_indicator
768: From pay_assignment_actions paa_arch
769: Where paa_arch.assignment_action_id = pay_archive.archive_aa;*/
770:
771: Select decode(count(*), 0 ,'Y', 'N')
772: into g_ls_indicator
773: From pay_payroll_actions ppa_arch,

Line 775: where paa_arch.assignment_action_id = pay_archive.archive_aa

771: Select decode(count(*), 0 ,'Y', 'N')
772: into g_ls_indicator
773: From pay_payroll_actions ppa_arch,
774: pay_assignment_actions paa_arch
775: where paa_arch.assignment_action_id = pay_archive.archive_aa
776: and ppa_arch.payroll_action_id = paa_arch.payroll_action_id
777: and paa_arch.assignment_action_id =
778: (
779: select max(paa.assignment_action_id)