376: -- Find it from Balance values from 11 to 16
377: TEL_DATA(l_counter).TagName := 'INCOME';
378: IF LR_REPORT_DETAILS.ACTION_INFORMATION8 = 'M'
379: THEN
380: TEL_DATA(l_counter).TagValue := TO_CHAR(NVL(FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION10) +
381: FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION11) +
382: FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION12),0) ,'999G999G990D99' );
383: ELSIF LR_REPORT_DETAILS.ACTION_INFORMATION8 = 'A'
384: THEN
377: TEL_DATA(l_counter).TagName := 'INCOME';
378: IF LR_REPORT_DETAILS.ACTION_INFORMATION8 = 'M'
379: THEN
380: TEL_DATA(l_counter).TagValue := TO_CHAR(NVL(FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION10) +
381: FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION11) +
382: FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION12),0) ,'999G999G990D99' );
383: ELSIF LR_REPORT_DETAILS.ACTION_INFORMATION8 = 'A'
384: THEN
385: TEL_DATA(l_counter).TagValue := TO_CHAR(NVL(FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION13) +
378: IF LR_REPORT_DETAILS.ACTION_INFORMATION8 = 'M'
379: THEN
380: TEL_DATA(l_counter).TagValue := TO_CHAR(NVL(FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION10) +
381: FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION11) +
382: FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION12),0) ,'999G999G990D99' );
383: ELSIF LR_REPORT_DETAILS.ACTION_INFORMATION8 = 'A'
384: THEN
385: TEL_DATA(l_counter).TagValue := TO_CHAR(NVL(FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION13) +
386: FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION14) +
381: FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION11) +
382: FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION12),0) ,'999G999G990D99' );
383: ELSIF LR_REPORT_DETAILS.ACTION_INFORMATION8 = 'A'
384: THEN
385: TEL_DATA(l_counter).TagValue := TO_CHAR(NVL(FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION13) +
386: FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION14) +
387: FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION15) ,0) ,'999G999G990D99' );
388: ELSIF LR_REPORT_DETAILS.ACTION_INFORMATION8 = 'Q'
389: THEN
382: FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION12),0) ,'999G999G990D99' );
383: ELSIF LR_REPORT_DETAILS.ACTION_INFORMATION8 = 'A'
384: THEN
385: TEL_DATA(l_counter).TagValue := TO_CHAR(NVL(FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION13) +
386: FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION14) +
387: FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION15) ,0) ,'999G999G990D99' );
388: ELSIF LR_REPORT_DETAILS.ACTION_INFORMATION8 = 'Q'
389: THEN
390: TEL_DATA(l_counter).TagValue := TO_CHAR(NVL(FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PER1_DETAILS.ACTION_INFORMATION13) +
383: ELSIF LR_REPORT_DETAILS.ACTION_INFORMATION8 = 'A'
384: THEN
385: TEL_DATA(l_counter).TagValue := TO_CHAR(NVL(FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION13) +
386: FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION14) +
387: FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION15) ,0) ,'999G999G990D99' );
388: ELSIF LR_REPORT_DETAILS.ACTION_INFORMATION8 = 'Q'
389: THEN
390: TEL_DATA(l_counter).TagValue := TO_CHAR(NVL(FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PER1_DETAILS.ACTION_INFORMATION13) +
391: FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PER1_DETAILS.ACTION_INFORMATION14) +
386: FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION14) +
387: FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION15) ,0) ,'999G999G990D99' );
388: ELSIF LR_REPORT_DETAILS.ACTION_INFORMATION8 = 'Q'
389: THEN
390: TEL_DATA(l_counter).TagValue := TO_CHAR(NVL(FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PER1_DETAILS.ACTION_INFORMATION13) +
391: FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PER1_DETAILS.ACTION_INFORMATION14) +
392: FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PER1_DETAILS.ACTION_INFORMATION15) ,0) ,'999G999G990D99' );
393: END IF;
394:
387: FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION15) ,0) ,'999G999G990D99' );
388: ELSIF LR_REPORT_DETAILS.ACTION_INFORMATION8 = 'Q'
389: THEN
390: TEL_DATA(l_counter).TagValue := TO_CHAR(NVL(FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PER1_DETAILS.ACTION_INFORMATION13) +
391: FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PER1_DETAILS.ACTION_INFORMATION14) +
392: FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PER1_DETAILS.ACTION_INFORMATION15) ,0) ,'999G999G990D99' );
393: END IF;
394:
395: l_counter := l_counter + 1;
388: ELSIF LR_REPORT_DETAILS.ACTION_INFORMATION8 = 'Q'
389: THEN
390: TEL_DATA(l_counter).TagValue := TO_CHAR(NVL(FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PER1_DETAILS.ACTION_INFORMATION13) +
391: FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PER1_DETAILS.ACTION_INFORMATION14) +
392: FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PER1_DETAILS.ACTION_INFORMATION15) ,0) ,'999G999G990D99' );
393: END IF;
394:
395: l_counter := l_counter + 1;
396: -- Find it from Balance values
510: -- Find if from g_effective date of Report prameters
511:
512: -- Find it from Balance values from 11 to 16
513: TEL_DATA(l_counter).TagName := 'INCOME';
514: TEL_DATA(l_counter).TagValue := TO_CHAR(NVL(FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION13) +
515: FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION14) +
516: FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION15) ,0) ,'999G999G990D99' );
517: l_counter := l_counter + 1;
518:
511:
512: -- Find it from Balance values from 11 to 16
513: TEL_DATA(l_counter).TagName := 'INCOME';
514: TEL_DATA(l_counter).TagValue := TO_CHAR(NVL(FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION13) +
515: FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION14) +
516: FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION15) ,0) ,'999G999G990D99' );
517: l_counter := l_counter + 1;
518:
519: /* -- Find it from Balance values
512: -- Find it from Balance values from 11 to 16
513: TEL_DATA(l_counter).TagName := 'INCOME';
514: TEL_DATA(l_counter).TagValue := TO_CHAR(NVL(FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION13) +
515: FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION14) +
516: FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION15) ,0) ,'999G999G990D99' );
517: l_counter := l_counter + 1;
518:
519: /* -- Find it from Balance values
520: -- In case of Annual Report or Start and Termination we need to report this field
518:
519: /* -- Find it from Balance values
520: -- In case of Annual Report or Start and Termination we need to report this field
521: TEL_DATA(l_counter).TagName := 'BENEFIT_IN_KIND';
522: TEL_DATA(l_counter).TagValue := TO_CHAR(NVL(FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION14) ,0) ,'999G999G990D99' );
523: l_counter := l_counter + 1;
524: */
525:
526: TEL_DATA(l_counter).TagName := 'TERMINATION_DATE';
648: -- Find it from Balance values from 11 to 16
649: TEL_DATA(l_counter).TagName := 'INCOME';
650: IF LR_REPORT_DETAILS.ACTION_INFORMATION8 = 'M'
651: THEN
652: TEL_DATA(l_counter).TagValue :=TO_CHAR(NVL( FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION10) +
653: FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION11) +
654: FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION12),0) ,'999G999G990D99' );
655: ELSIF LR_REPORT_DETAILS.ACTION_INFORMATION8 = 'A'
656: THEN
649: TEL_DATA(l_counter).TagName := 'INCOME';
650: IF LR_REPORT_DETAILS.ACTION_INFORMATION8 = 'M'
651: THEN
652: TEL_DATA(l_counter).TagValue :=TO_CHAR(NVL( FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION10) +
653: FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION11) +
654: FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION12),0) ,'999G999G990D99' );
655: ELSIF LR_REPORT_DETAILS.ACTION_INFORMATION8 = 'A'
656: THEN
657: TEL_DATA(l_counter).TagValue := TO_CHAR(NVL(FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION13) +
650: IF LR_REPORT_DETAILS.ACTION_INFORMATION8 = 'M'
651: THEN
652: TEL_DATA(l_counter).TagValue :=TO_CHAR(NVL( FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION10) +
653: FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION11) +
654: FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION12),0) ,'999G999G990D99' );
655: ELSIF LR_REPORT_DETAILS.ACTION_INFORMATION8 = 'A'
656: THEN
657: TEL_DATA(l_counter).TagValue := TO_CHAR(NVL(FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION13) +
658: FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION14) +
653: FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION11) +
654: FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION12),0) ,'999G999G990D99' );
655: ELSIF LR_REPORT_DETAILS.ACTION_INFORMATION8 = 'A'
656: THEN
657: TEL_DATA(l_counter).TagValue := TO_CHAR(NVL(FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION13) +
658: FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION14) +
659: FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION15) ,0) ,'999G999G990D99' );
660: ELSIF LR_REPORT_DETAILS.ACTION_INFORMATION8 = 'Q'
661: THEN
654: FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION12),0) ,'999G999G990D99' );
655: ELSIF LR_REPORT_DETAILS.ACTION_INFORMATION8 = 'A'
656: THEN
657: TEL_DATA(l_counter).TagValue := TO_CHAR(NVL(FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION13) +
658: FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION14) +
659: FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION15) ,0) ,'999G999G990D99' );
660: ELSIF LR_REPORT_DETAILS.ACTION_INFORMATION8 = 'Q'
661: THEN
662: TEL_DATA(l_counter).TagValue := TO_CHAR(NVL(FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PER1_DETAILS.ACTION_INFORMATION13) +
655: ELSIF LR_REPORT_DETAILS.ACTION_INFORMATION8 = 'A'
656: THEN
657: TEL_DATA(l_counter).TagValue := TO_CHAR(NVL(FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION13) +
658: FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION14) +
659: FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION15) ,0) ,'999G999G990D99' );
660: ELSIF LR_REPORT_DETAILS.ACTION_INFORMATION8 = 'Q'
661: THEN
662: TEL_DATA(l_counter).TagValue := TO_CHAR(NVL(FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PER1_DETAILS.ACTION_INFORMATION13) +
663: FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PER1_DETAILS.ACTION_INFORMATION14) +
658: FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION14) +
659: FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION15) ,0) ,'999G999G990D99' );
660: ELSIF LR_REPORT_DETAILS.ACTION_INFORMATION8 = 'Q'
661: THEN
662: TEL_DATA(l_counter).TagValue := TO_CHAR(NVL(FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PER1_DETAILS.ACTION_INFORMATION13) +
663: FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PER1_DETAILS.ACTION_INFORMATION14) +
664: FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PER1_DETAILS.ACTION_INFORMATION15),0) ,'999G999G990D99' );
665: END IF;
666:
659: FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION15) ,0) ,'999G999G990D99' );
660: ELSIF LR_REPORT_DETAILS.ACTION_INFORMATION8 = 'Q'
661: THEN
662: TEL_DATA(l_counter).TagValue := TO_CHAR(NVL(FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PER1_DETAILS.ACTION_INFORMATION13) +
663: FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PER1_DETAILS.ACTION_INFORMATION14) +
664: FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PER1_DETAILS.ACTION_INFORMATION15),0) ,'999G999G990D99' );
665: END IF;
666:
667: l_counter := l_counter + 1;
660: ELSIF LR_REPORT_DETAILS.ACTION_INFORMATION8 = 'Q'
661: THEN
662: TEL_DATA(l_counter).TagValue := TO_CHAR(NVL(FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PER1_DETAILS.ACTION_INFORMATION13) +
663: FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PER1_DETAILS.ACTION_INFORMATION14) +
664: FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PER1_DETAILS.ACTION_INFORMATION15),0) ,'999G999G990D99' );
665: END IF;
666:
667: l_counter := l_counter + 1;
668: -- Find it from Balance values
668: -- Find it from Balance values
669:
670: /*
671: TEL_DATA(l_counter).TagName := 'BENEFIT_IN_KIND';
672: TEL_DATA(l_counter).TagValue := TO_CHAR(NVL(FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION11),0) ,'999G999G990D99' );
673: l_counter := l_counter + 1;
674:
675: */
676: TEL_DATA(l_counter).TagName := 'TERMINATION_DATE';
686: TEL_DATA(l_counter).TagValue := lr_TEL_PERSON_DETAILS.ACTION_INFORMATION17;
687: l_counter := l_counter + 1;
688:
689: TEL_DATA(l_counter).TagName := 'YEARLY_TEL_INCOME_PRIOR';
690: TEL_DATA(l_counter).TagValue := TO_CHAR(NVL(FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION18) + FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION19) ,0) ,'999G999G990D99' );
691: l_counter := l_counter + 1;
692:
693: IF NVL(FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION18) + FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION19) ,0) > 0 THEN
694:
689: TEL_DATA(l_counter).TagName := 'YEARLY_TEL_INCOME_PRIOR';
690: TEL_DATA(l_counter).TagValue := TO_CHAR(NVL(FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION18) + FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION19) ,0) ,'999G999G990D99' );
691: l_counter := l_counter + 1;
692:
693: IF NVL(FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION18) + FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION19) ,0) > 0 THEN
694:
695: TEL_DATA(l_counter).TagName := 'TARGET_YEAR_FOR_TERM';
696: TEL_DATA(l_counter).TagValue := TO_CHAR(fnd_date.canonical_to_date(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION16),'YYYY');
697: l_counter := l_counter + 1;
699: END IF;
700:
701: /*
702: TEL_DATA(l_counter).TagName := 'BENEFIT_IN_KIND_PRIOR';
703: TEL_DATA(l_counter).TagValue := TO_CHAR(NVL(FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION20) ,0) ,'999G999G990D99' );
704: l_counter := l_counter + 1;
705:
706: TEL_DATA(l_counter).TagName :='LEL_EMPLOYMENT_START_DATE';
707: TEL_DATA(l_counter).TagValue := NULL;