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:
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:
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;
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;
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:
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:
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;
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';
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);
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:
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';
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;
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
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
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
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
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);
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:
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;
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';
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;
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:
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
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;
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:
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;
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;
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,
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
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;
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;
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;
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:
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;
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;
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;
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
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;
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
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
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;
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:
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:
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;
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;
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:
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: (
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,
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)
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,
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)