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_FI_TELR dependencies on FND_NUMBER

Line 380: TEL_DATA(l_counter).TagValue := TO_CHAR(NVL(FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION10) +

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

Line 381: FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION11) +

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

Line 382: FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION12),0) ,'999G999G990D99' );

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

Line 385: TEL_DATA(l_counter).TagValue := TO_CHAR(NVL(FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION13) +

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

Line 386: FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION14) +

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

Line 387: FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION15) ,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) +
391: FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PER1_DETAILS.ACTION_INFORMATION14) +

Line 390: TEL_DATA(l_counter).TagValue := TO_CHAR(NVL(FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PER1_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) +
392: FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PER1_DETAILS.ACTION_INFORMATION15) ,0) ,'999G999G990D99' );
393: END IF;
394:

Line 391: FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PER1_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:
395: l_counter := l_counter + 1;

Line 392: FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PER1_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;
396: -- Find it from Balance values

Line 514: TEL_DATA(l_counter).TagValue := TO_CHAR(NVL(FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION13) +

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:

Line 515: FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION14) +

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

Line 516: FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION15) ,0) ,'999G999G990D99' );

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

Line 522: TEL_DATA(l_counter).TagValue := TO_CHAR(NVL(FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION14) ,0) ,'999G999G990D99' );

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

Line 652: TEL_DATA(l_counter).TagValue :=TO_CHAR(NVL( FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION10) +

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

Line 653: FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION11) +

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

Line 654: FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION12),0) ,'999G999G990D99' );

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

Line 657: TEL_DATA(l_counter).TagValue := TO_CHAR(NVL(FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION13) +

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

Line 658: FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION14) +

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

Line 659: FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION15) ,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) +
663: FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PER1_DETAILS.ACTION_INFORMATION14) +

Line 662: TEL_DATA(l_counter).TagValue := TO_CHAR(NVL(FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PER1_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) +
664: FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PER1_DETAILS.ACTION_INFORMATION15),0) ,'999G999G990D99' );
665: END IF;
666:

Line 663: FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PER1_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:
667: l_counter := l_counter + 1;

Line 664: FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PER1_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;
668: -- Find it from Balance values

Line 672: TEL_DATA(l_counter).TagValue := TO_CHAR(NVL(FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION11),0) ,'999G999G990D99' );

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

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

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:

Line 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

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;

Line 703: TEL_DATA(l_counter).TagValue := TO_CHAR(NVL(FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION20) ,0) ,'999G999G990D99' );

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;