549: p_body_text7 OUT NOCOPY VARCHAR2,
550: p_body_text8 OUT NOCOPY VARCHAR2 ) IS
551:
552: BEGIN
553: p_body_regards := fnd_message.get_string('PQH','PQH_RGDS_TENURE_RPT_TXT');
554:
555: IF p_report_id = 'NT' THEN -- Non-Tenure
556:
557: p_body_text1 := fnd_message.get_string('PQH','PQH_NT_TENURE_RPT_TXT');
553: p_body_regards := fnd_message.get_string('PQH','PQH_RGDS_TENURE_RPT_TXT');
554:
555: IF p_report_id = 'NT' THEN -- Non-Tenure
556:
557: p_body_text1 := fnd_message.get_string('PQH','PQH_NT_TENURE_RPT_TXT');
558:
559: ELSIF p_report_id = 'TS' THEN -- Tenure Status
560: p_body_text1 := fnd_message.get_string('PQH','PQH_TS_TENURE_RPT_TXT');
561:
556:
557: p_body_text1 := fnd_message.get_string('PQH','PQH_NT_TENURE_RPT_TXT');
558:
559: ELSIF p_report_id = 'TS' THEN -- Tenure Status
560: p_body_text1 := fnd_message.get_string('PQH','PQH_TS_TENURE_RPT_TXT');
561:
562: ELSIF p_report_id = 'TT' THEN -- Tenure Track
563: p_body_text1 := fnd_message.get_string('PQH','PQH_TT_TENURE_RPT_TXT1');
564:
559: ELSIF p_report_id = 'TS' THEN -- Tenure Status
560: p_body_text1 := fnd_message.get_string('PQH','PQH_TS_TENURE_RPT_TXT');
561:
562: ELSIF p_report_id = 'TT' THEN -- Tenure Track
563: p_body_text1 := fnd_message.get_string('PQH','PQH_TT_TENURE_RPT_TXT1');
564:
565: p_body_text2 := fnd_message.get_string('PQH','PQH_TT_TENURE_RPT_TXT2');
566:
567: p_body_text3 := fnd_message.get_string('PQH','PQH_TT_TENURE_RPT_TXT3');
561:
562: ELSIF p_report_id = 'TT' THEN -- Tenure Track
563: p_body_text1 := fnd_message.get_string('PQH','PQH_TT_TENURE_RPT_TXT1');
564:
565: p_body_text2 := fnd_message.get_string('PQH','PQH_TT_TENURE_RPT_TXT2');
566:
567: p_body_text3 := fnd_message.get_string('PQH','PQH_TT_TENURE_RPT_TXT3');
568:
569: p_body_text4 := fnd_message.get_string('PQH','PQH_TT_TENURE_RPT_TXT4');
563: p_body_text1 := fnd_message.get_string('PQH','PQH_TT_TENURE_RPT_TXT1');
564:
565: p_body_text2 := fnd_message.get_string('PQH','PQH_TT_TENURE_RPT_TXT2');
566:
567: p_body_text3 := fnd_message.get_string('PQH','PQH_TT_TENURE_RPT_TXT3');
568:
569: p_body_text4 := fnd_message.get_string('PQH','PQH_TT_TENURE_RPT_TXT4');
570:
571: ELSIF p_report_id = 'RW' THEN -- Review
565: p_body_text2 := fnd_message.get_string('PQH','PQH_TT_TENURE_RPT_TXT2');
566:
567: p_body_text3 := fnd_message.get_string('PQH','PQH_TT_TENURE_RPT_TXT3');
568:
569: p_body_text4 := fnd_message.get_string('PQH','PQH_TT_TENURE_RPT_TXT4');
570:
571: ELSIF p_report_id = 'RW' THEN -- Review
572:
573: p_body_text1 := fnd_message.get_string('PQH','PQH_RW_TENURE_RPT_TXT1');
569: p_body_text4 := fnd_message.get_string('PQH','PQH_TT_TENURE_RPT_TXT4');
570:
571: ELSIF p_report_id = 'RW' THEN -- Review
572:
573: p_body_text1 := fnd_message.get_string('PQH','PQH_RW_TENURE_RPT_TXT1');
574:
575: p_body_text2 := fnd_message.get_string('PQH','PQH_RW_TENURE_RPT_TXT2');
576:
577: ELSIF p_report_id = 'AS' THEN -- Annual Status
571: ELSIF p_report_id = 'RW' THEN -- Review
572:
573: p_body_text1 := fnd_message.get_string('PQH','PQH_RW_TENURE_RPT_TXT1');
574:
575: p_body_text2 := fnd_message.get_string('PQH','PQH_RW_TENURE_RPT_TXT2');
576:
577: ELSIF p_report_id = 'AS' THEN -- Annual Status
578:
579: p_body_text1 := fnd_message.get_string('PQH','PQH_AS_TENURE_RPT_TXT1');
575: p_body_text2 := fnd_message.get_string('PQH','PQH_RW_TENURE_RPT_TXT2');
576:
577: ELSIF p_report_id = 'AS' THEN -- Annual Status
578:
579: p_body_text1 := fnd_message.get_string('PQH','PQH_AS_TENURE_RPT_TXT1');
580:
581: p_body_text2 := fnd_message.get_string('PQH','PQH_AS_TENURE_RPT_TXT2');
582:
583: p_body_text3 := fnd_message.get_string('PQH','PQH_AS_TENURE_RPT_TXT3');
577: ELSIF p_report_id = 'AS' THEN -- Annual Status
578:
579: p_body_text1 := fnd_message.get_string('PQH','PQH_AS_TENURE_RPT_TXT1');
580:
581: p_body_text2 := fnd_message.get_string('PQH','PQH_AS_TENURE_RPT_TXT2');
582:
583: p_body_text3 := fnd_message.get_string('PQH','PQH_AS_TENURE_RPT_TXT3');
584:
585: p_body_text4 := fnd_message.get_string('PQH','PQH_AS_TENURE_RPT_TXT4');
579: p_body_text1 := fnd_message.get_string('PQH','PQH_AS_TENURE_RPT_TXT1');
580:
581: p_body_text2 := fnd_message.get_string('PQH','PQH_AS_TENURE_RPT_TXT2');
582:
583: p_body_text3 := fnd_message.get_string('PQH','PQH_AS_TENURE_RPT_TXT3');
584:
585: p_body_text4 := fnd_message.get_string('PQH','PQH_AS_TENURE_RPT_TXT4');
586:
587: p_body_text5 := fnd_message.get_string('PQH','PQH_AS_TENURE_RPT_TXT5');
581: p_body_text2 := fnd_message.get_string('PQH','PQH_AS_TENURE_RPT_TXT2');
582:
583: p_body_text3 := fnd_message.get_string('PQH','PQH_AS_TENURE_RPT_TXT3');
584:
585: p_body_text4 := fnd_message.get_string('PQH','PQH_AS_TENURE_RPT_TXT4');
586:
587: p_body_text5 := fnd_message.get_string('PQH','PQH_AS_TENURE_RPT_TXT5');
588:
589: p_body_text6 := fnd_message.get_string('PQH','PQH_AS_TENURE_RPT_TXT6');
583: p_body_text3 := fnd_message.get_string('PQH','PQH_AS_TENURE_RPT_TXT3');
584:
585: p_body_text4 := fnd_message.get_string('PQH','PQH_AS_TENURE_RPT_TXT4');
586:
587: p_body_text5 := fnd_message.get_string('PQH','PQH_AS_TENURE_RPT_TXT5');
588:
589: p_body_text6 := fnd_message.get_string('PQH','PQH_AS_TENURE_RPT_TXT6');
590:
591: p_body_text7 := fnd_message.get_string('PQH','PQH_AS_TENURE_RPT_TXT7');
585: p_body_text4 := fnd_message.get_string('PQH','PQH_AS_TENURE_RPT_TXT4');
586:
587: p_body_text5 := fnd_message.get_string('PQH','PQH_AS_TENURE_RPT_TXT5');
588:
589: p_body_text6 := fnd_message.get_string('PQH','PQH_AS_TENURE_RPT_TXT6');
590:
591: p_body_text7 := fnd_message.get_string('PQH','PQH_AS_TENURE_RPT_TXT7');
592:
593: ELSIF p_report_id = 'CE' THEN
587: p_body_text5 := fnd_message.get_string('PQH','PQH_AS_TENURE_RPT_TXT5');
588:
589: p_body_text6 := fnd_message.get_string('PQH','PQH_AS_TENURE_RPT_TXT6');
590:
591: p_body_text7 := fnd_message.get_string('PQH','PQH_AS_TENURE_RPT_TXT7');
592:
593: ELSIF p_report_id = 'CE' THEN
594:
595: p_body_text1 := fnd_message.get_string('PQH','PQH_CE_TENURE_RPT_TXT');
591: p_body_text7 := fnd_message.get_string('PQH','PQH_AS_TENURE_RPT_TXT7');
592:
593: ELSIF p_report_id = 'CE' THEN
594:
595: p_body_text1 := fnd_message.get_string('PQH','PQH_CE_TENURE_RPT_TXT');
596: END IF;
597:
598: END;
599: END pqh_tenure_detail;