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.IGS_AS_PRC_TRANSCRPT dependencies on FND_GLOBAL

Line 152: v_out_string := fnd_global.local_chr(10) || 'COURSE REQUIREMENTS COMPLETED ON ' ||

148: IF p_record_number = 1 THEN -- first time through, do a page throw.
149: IF p_s_letter_parameter_type = 'TRN_GRD_LN' THEN
150: IF IGS_AS_PRC_TRANSCRPT.gt_grd_dtl_table(v_index).v_type
151: = 'COMP_GRAD' THEN
152: v_out_string := fnd_global.local_chr(10) || 'COURSE REQUIREMENTS COMPLETED ON ' ||
153: FND_DATE.DATE_TO_DISPLAYDATE(IGS_AS_PRC_TRANSCRPT.gt_grd_dtl_table(
154: v_index).v_completion_dt) || '. AWARD OF ' ||
155: IGS_AS_PRC_TRANSCRPT.gt_grd_dtl_table(
156: v_index).v_award_title

Line 162: v_out_string := fnd_global.local_chr(10) || 'COURSE REQUIREMENTS COMPLETED ON ' ||

158: FND_DATE.DATE_TO_DISPLAYDATE(IGS_AS_PRC_TRANSCRPT.gt_grd_dtl_table(
159: v_index).v_conferral_dt);
160: ELSIF IGS_AS_PRC_TRANSCRPT.gt_grd_dtl_table(v_index).v_type
161: = 'COMP_ELIG' THEN
162: v_out_string := fnd_global.local_chr(10) || 'COURSE REQUIREMENTS COMPLETED ON ' ||
163: FND_DATE.DATE_TO_DISPLAYDATE(IGS_AS_PRC_TRANSCRPT.gt_grd_dtl_table(
164: v_index).v_completion_dt) || '. AWARD OF ' ||
165: IGS_AS_PRC_TRANSCRPT.gt_grd_dtl_table(
166: v_index).v_award_title ||

Line 170: v_out_string := fnd_global.local_chr(10) || 'COURSE REQUIREMENTS COMPLETED ON ' ||

166: v_index).v_award_title ||
167: ' TO BE CONFERRED AT A FORTHCOMING GRADUATION CEREMONY.';
168: ELSIF IGS_AS_PRC_TRANSCRPT.gt_grd_dtl_table(v_index).v_type
169: = 'COMP_NOAWD' THEN
170: v_out_string := fnd_global.local_chr(10) || 'COURSE REQUIREMENTS COMPLETED ON ' ||
171: FND_DATE.DATE_TO_DISPLAYDATE(IGS_AS_PRC_TRANSCRPT.gt_grd_dtl_table(
172: v_index).v_completion_dt) || '. PROCEEDING TO A HIGHER AWARD.';
173: ELSIF IGS_AS_PRC_TRANSCRPT.gt_grd_dtl_table(v_index).v_type
174: = 'COMPLETED' THEN

Line 175: v_out_string := fnd_global.local_chr(10) || 'COURSE REQUIREMENTS COMPLETED ON ' ||

171: FND_DATE.DATE_TO_DISPLAYDATE(IGS_AS_PRC_TRANSCRPT.gt_grd_dtl_table(
172: v_index).v_completion_dt) || '. PROCEEDING TO A HIGHER AWARD.';
173: ELSIF IGS_AS_PRC_TRANSCRPT.gt_grd_dtl_table(v_index).v_type
174: = 'COMPLETED' THEN
175: v_out_string := fnd_global.local_chr(10) || 'COURSE REQUIREMENTS COMPLETED ON ' ||
176: FND_DATE.DATE_TO_DISPLAYDATE(IGS_AS_PRC_TRANSCRPT.gt_grd_dtl_table(
177: v_index).v_completion_dt);
178: END IF;
179: ELSE

Line 342: v_out_string := fnd_global.local_chr(10) || 'THESIS TITLE: ' ||

338: IF p_s_letter_parameter_type = 'TRN_RES_LN' THEN
339: IF p_record_number = 1 THEN
340: IF IGS_AS_PRC_TRANSCRPT.gt_res_dtl_table(v_index).v_final_title_ind
341: = 'Y' THEN
342: v_out_string := fnd_global.local_chr(10) || 'THESIS TITLE: ' ||
343: IGS_AS_PRC_TRANSCRPT.gt_res_dtl_table(v_index).v_title;
344: ELSE
345: v_out_string := fnd_global.local_chr(10) || 'WORKING THESIS TITLE: ' ||
346: IGS_AS_PRC_TRANSCRPT.gt_res_dtl_table(v_index).v_title;

Line 345: v_out_string := fnd_global.local_chr(10) || 'WORKING THESIS TITLE: ' ||

341: = 'Y' THEN
342: v_out_string := fnd_global.local_chr(10) || 'THESIS TITLE: ' ||
343: IGS_AS_PRC_TRANSCRPT.gt_res_dtl_table(v_index).v_title;
344: ELSE
345: v_out_string := fnd_global.local_chr(10) || 'WORKING THESIS TITLE: ' ||
346: IGS_AS_PRC_TRANSCRPT.gt_res_dtl_table(v_index).v_title;
347: END IF;
348: ELSE
349: IF IGS_AS_PRC_TRANSCRPT.gt_res_dtl_table(v_index).v_final_title_ind

Line 500: v_out_string := fnd_global.local_chr(10) || NVL(IGS_AS_PRC_TRANSCRPT.gt_susa_dtl_table(

496: -- all completed UNIT sets
497: IF IGS_AS_PRC_TRANSCRPT.gt_susa_dtl_table(
498: v_index).v_completion_dt IS NOT NULL THEN
499: IF p_record_number = 1 THEN
500: v_out_string := fnd_global.local_chr(10) || NVL(IGS_AS_PRC_TRANSCRPT.gt_susa_dtl_table(
501: v_index).v_title,'-') || ' COMPLETED ON ' ||
502: FND_DATE.DATE_TO_DISPLAYDATE(IGS_AS_PRC_TRANSCRPT.gt_susa_dtl_table(
503: v_index).v_completion_dt);
504: ELSE

Line 516: v_out_string := fnd_global.local_chr(10) || NVL(IGS_AS_PRC_TRANSCRPT.gt_susa_dtl_table(

512: -- all selected UNIT sets.
513: IF IGS_AS_PRC_TRANSCRPT.gt_susa_dtl_table(
514: v_index).v_selection_dt IS NOT NULL THEN
515: IF p_record_number = 1 THEN
516: v_out_string := fnd_global.local_chr(10) || NVL(IGS_AS_PRC_TRANSCRPT.gt_susa_dtl_table(
517: v_index).v_title,'-')
518: || ' SELECTED ON ' ||
519: FND_DATE.DATE_TO_DISPLAYDATE(IGS_AS_PRC_TRANSCRPT.gt_susa_dtl_table(
520: v_index).v_selection_dt);

Line 536: v_out_string := fnd_global.local_chr(10) || NVL(IGS_AS_PRC_TRANSCRPT.gt_susa_dtl_table(

532: v_index).v_primary_set_ind = 'Y' THEN
533: IF IGS_AS_PRC_TRANSCRPT.gt_susa_dtl_table(
534: v_index).v_completion_dt IS NOT NULL THEN
535: IF p_record_number = 1 THEN
536: v_out_string := fnd_global.local_chr(10) || NVL(IGS_AS_PRC_TRANSCRPT.gt_susa_dtl_table(
537: v_index).v_title,'-')
538: || ' COMPLETED ON ' ||
539: FND_DATE.DATE_TO_DISPLAYDATE(IGS_AS_PRC_TRANSCRPT.gt_susa_dtl_table(v_index).v_completion_dt);
540: ELSE

Line 556: v_out_string := fnd_global.local_chr(10) || NVL(IGS_AS_PRC_TRANSCRPT.gt_susa_dtl_table(

552: v_index).v_primary_set_ind = 'Y' THEN
553: IF IGS_AS_PRC_TRANSCRPT.gt_susa_dtl_table(
554: v_index).v_selection_dt IS NOT NULL THEN
555: IF p_record_number = 1 THEN
556: v_out_string := fnd_global.local_chr(10) || NVL(IGS_AS_PRC_TRANSCRPT.gt_susa_dtl_table(
557: v_index).v_title,'-')
558: || ' SELECTED ON ' ||
559: FND_DATE.DATE_TO_DISPLAYDATE(IGS_AS_PRC_TRANSCRPT.gt_susa_dtl_table(
560: v_index).v_selection_dt);

Line 749: || fnd_global.local_chr(09) ||

745: IF v_index <= IGS_AS_PRC_TRANSCRPT.gv_sut_dtl_index THEN
746: IF p_s_letter_parameter_type = cst_trn_sut_ln THEN
747: v_out_string := RPAD(NVL(IGS_AS_PRC_TRANSCRPT.gt_sut_dtl_table(
748: v_index).v_teach_alternate_code,'-'),10)
749: || fnd_global.local_chr(09) ||
750: RPAD(NVL(IGS_AS_PRC_TRANSCRPT.gt_sut_dtl_table(
751: v_index).v_unit_cd,'-'),10)
752: || fnd_global.local_chr(09) ||
753: RPAD(NVL(IGS_AS_PRC_TRANSCRPT.gt_sut_dtl_table(

Line 752: || fnd_global.local_chr(09) ||

748: v_index).v_teach_alternate_code,'-'),10)
749: || fnd_global.local_chr(09) ||
750: RPAD(NVL(IGS_AS_PRC_TRANSCRPT.gt_sut_dtl_table(
751: v_index).v_unit_cd,'-'),10)
752: || fnd_global.local_chr(09) ||
753: RPAD(NVL(IGS_AS_PRC_TRANSCRPT.gt_sut_dtl_table(
754: v_index).v_title,'-'),40);
755: ELSIF p_s_letter_parameter_type = cst_trn_sut_cd THEN
756: v_out_string := NVL(IGS_AS_PRC_TRANSCRPT.gt_sut_dtl_table(

Line 892: v_out_string := fnd_global.local_chr(10) || 'TRANSFERRED FROM COURSE ' ||

888: IF v_index <= IGS_AS_PRC_TRANSCRPT.gv_sct_dtl_index THEN
889: IF p_s_letter_parameter_type = 'TRN_SCT' THEN
890: IF p_record_number = 1 THEN
891: IF IGS_AS_PRC_TRANSCRPT.gt_sct_dtl_table(v_index).v_unit_ind = 'Y' THEN
892: v_out_string := fnd_global.local_chr(10) || 'TRANSFERRED FROM COURSE ' ||
893: NVL(IGS_AS_PRC_TRANSCRPT.gt_sct_dtl_table(
894: v_index).v_from_course,'-') || ' TO COURSE ' ||
895: NVL(IGS_AS_PRC_TRANSCRPT.gt_sct_dtl_table(
896: v_index).v_to_course,'-') || ' ON ' ||

Line 899: '. UNIT ATTEMPTS TRANSFERRED:' || fnd_global.local_chr(10);

895: NVL(IGS_AS_PRC_TRANSCRPT.gt_sct_dtl_table(
896: v_index).v_to_course,'-') || ' ON ' ||
897: FND_DATE.DATE_TO_DISPLAYDATE(IGS_AS_PRC_TRANSCRPT.gt_sct_dtl_table(
898: v_index).v_transfer_dt) ||
899: '. UNIT ATTEMPTS TRANSFERRED:' || fnd_global.local_chr(10);
900: ELSE
901: v_out_string := fnd_global.local_chr(10) || 'TRANSFERRED FROM COURSE ' ||
902: NVL(IGS_AS_PRC_TRANSCRPT.gt_sct_dtl_table(
903: v_index).v_from_course,'-') || ' TO COURSE ' ||

Line 901: v_out_string := fnd_global.local_chr(10) || 'TRANSFERRED FROM COURSE ' ||

897: FND_DATE.DATE_TO_DISPLAYDATE(IGS_AS_PRC_TRANSCRPT.gt_sct_dtl_table(
898: v_index).v_transfer_dt) ||
899: '. UNIT ATTEMPTS TRANSFERRED:' || fnd_global.local_chr(10);
900: ELSE
901: v_out_string := fnd_global.local_chr(10) || 'TRANSFERRED FROM COURSE ' ||
902: NVL(IGS_AS_PRC_TRANSCRPT.gt_sct_dtl_table(
903: v_index).v_from_course,'-') || ' TO COURSE ' ||
904: NVL(IGS_AS_PRC_TRANSCRPT.gt_sct_dtl_table(
905: v_index).v_to_course,'-') || ' ON ' ||

Line 907: v_index).v_transfer_dt) || '.' || fnd_global.local_chr(10);

903: v_index).v_from_course,'-') || ' TO COURSE ' ||
904: NVL(IGS_AS_PRC_TRANSCRPT.gt_sct_dtl_table(
905: v_index).v_to_course,'-') || ' ON ' ||
906: FND_DATE.DATE_TO_DISPLAYDATE(IGS_AS_PRC_TRANSCRPT.gt_sct_dtl_table(
907: v_index).v_transfer_dt) || '.' || fnd_global.local_chr(10);
908: END IF;
909: ELSE
910: IF IGS_AS_PRC_TRANSCRPT.gt_sct_dtl_table(v_index).v_unit_ind = 'Y' THEN
911: v_out_string := 'TRANSFERRED FROM COURSE ' ||

Line 918: '. UNIT ATTEMPTS TRANSFERRED:' || fnd_global.local_chr(10);

914: NVL(IGS_AS_PRC_TRANSCRPT.gt_sct_dtl_table(
915: v_index).v_to_course,'-') || ' ON ' ||
916: FND_DATE.DATE_TO_DISPLAYDATE(IGS_AS_PRC_TRANSCRPT.gt_sct_dtl_table(
917: v_index).v_transfer_dt) ||
918: '. UNIT ATTEMPTS TRANSFERRED:' || fnd_global.local_chr(10);
919: ELSE
920: v_out_string := 'TRANSFERRED FROM COURSE ' ||
921: NVL(IGS_AS_PRC_TRANSCRPT.gt_sct_dtl_table(
922: v_index).v_from_course,'-') || ' TO COURSE ' ||

Line 926: v_index).v_transfer_dt) || '.' || fnd_global.local_chr(10);

922: v_index).v_from_course,'-') || ' TO COURSE ' ||
923: NVL(IGS_AS_PRC_TRANSCRPT.gt_sct_dtl_table(
924: v_index).v_to_course,'-') || ' ON ' ||
925: FND_DATE.DATE_TO_DISPLAYDATE(IGS_AS_PRC_TRANSCRPT.gt_sct_dtl_table(
926: v_index).v_transfer_dt) || '.' || fnd_global.local_chr(10);
927: END IF;
928: END IF;
929: ELSE
930: v_out_string := NULL;

Line 1105: v_out_string := fnd_global.local_chr(10) || 'COURSE ENROLMENT INTERMITTED FROM ' ||

1101: IF v_index <= IGS_AS_PRC_TRANSCRPT.gv_stdg_dtl_index THEN
1102: IF p_record_number = 1 THEN -- first time through, do a page throw.
1103: IF p_s_letter_parameter_type = 'TRN_STDG' THEN
1104: IF IGS_AS_PRC_TRANSCRPT.gt_stdg_dtl_table(v_index).v_type = 'INTERMIT' THEN
1105: v_out_string := fnd_global.local_chr(10) || 'COURSE ENROLMENT INTERMITTED FROM ' ||
1106: FND_DATE.DATE_TO_DISPLAYDATE(IGS_AS_PRC_TRANSCRPT.gt_stdg_dtl_table(v_index).v_int_start_dt
1107: ) || ' TO ' ||
1108: FND_DATE.DATE_TO_DISPLAYDATE(IGS_AS_PRC_TRANSCRPT.gt_stdg_dtl_table(v_index).v_int_end_dt);
1109: ELSIF IGS_AS_PRC_TRANSCRPT.gt_stdg_dtl_table(v_index).v_type = 'LAPSED' THEN

Line 1110: v_out_string := fnd_global.local_chr(10) || 'ENROLMENT LAPSED ON ' ||

1106: FND_DATE.DATE_TO_DISPLAYDATE(IGS_AS_PRC_TRANSCRPT.gt_stdg_dtl_table(v_index).v_int_start_dt
1107: ) || ' TO ' ||
1108: FND_DATE.DATE_TO_DISPLAYDATE(IGS_AS_PRC_TRANSCRPT.gt_stdg_dtl_table(v_index).v_int_end_dt);
1109: ELSIF IGS_AS_PRC_TRANSCRPT.gt_stdg_dtl_table(v_index).v_type = 'LAPSED' THEN
1110: v_out_string := fnd_global.local_chr(10) || 'ENROLMENT LAPSED ON ' ||
1111: FND_DATE.DATE_TO_DISPLAYDATE(IGS_AS_PRC_TRANSCRPT.gt_stdg_dtl_table(v_index).v_lapsed_dt);
1112: ELSIF IGS_AS_PRC_TRANSCRPT.gt_stdg_dtl_table(v_index).v_type
1113: = 'DISCONTIN' THEN
1114: v_out_string := fnd_global.local_chr(10) || 'COURSE ENROLMENT DISCONTINUED ON ' ||

Line 1114: v_out_string := fnd_global.local_chr(10) || 'COURSE ENROLMENT DISCONTINUED ON ' ||

1110: v_out_string := fnd_global.local_chr(10) || 'ENROLMENT LAPSED ON ' ||
1111: FND_DATE.DATE_TO_DISPLAYDATE(IGS_AS_PRC_TRANSCRPT.gt_stdg_dtl_table(v_index).v_lapsed_dt);
1112: ELSIF IGS_AS_PRC_TRANSCRPT.gt_stdg_dtl_table(v_index).v_type
1113: = 'DISCONTIN' THEN
1114: v_out_string := fnd_global.local_chr(10) || 'COURSE ENROLMENT DISCONTINUED ON ' ||
1115: FND_DATE.DATE_TO_DISPLAYDATE(IGS_AS_PRC_TRANSCRPT.gt_stdg_dtl_table(
1116: v_index).v_discontinued_dt);
1117: END IF;
1118: ELSE

Line 1412: || fnd_global.local_chr(09) ||

1408: IF v_index <= IGS_AS_PRC_TRANSCRPT.gv_sua_dtl_index THEN
1409: IF p_s_letter_parameter_type = cst_trn_sua_ln THEN
1410: v_out_string := RPAD(NVL(IGS_AS_PRC_TRANSCRPT.gt_sua_dtl_table(
1411: v_index).v_teach_alternate_code,'-'),10)
1412: || fnd_global.local_chr(09) ||
1413: RPAD(NVL(IGS_AS_PRC_TRANSCRPT.gt_sua_dtl_table(
1414: v_index).v_unit_cd,'-'),10)
1415: || fnd_global.local_chr(09) ||
1416: RPAD(NVL(IGS_AS_PRC_TRANSCRPT.gt_sua_dtl_table(

Line 1415: || fnd_global.local_chr(09) ||

1411: v_index).v_teach_alternate_code,'-'),10)
1412: || fnd_global.local_chr(09) ||
1413: RPAD(NVL(IGS_AS_PRC_TRANSCRPT.gt_sua_dtl_table(
1414: v_index).v_unit_cd,'-'),10)
1415: || fnd_global.local_chr(09) ||
1416: RPAD(NVL(IGS_AS_PRC_TRANSCRPT.gt_sua_dtl_table(
1417: v_index).v_title,'-'),40);
1418: ELSIF p_s_letter_parameter_type = cst_trn_sua_cd THEN
1419: v_out_string := NVL(IGS_AS_PRC_TRANSCRPT.gt_sua_dtl_table(

Line 1426: v_out_string := fnd_global.local_chr(10) || NVL(IGS_AS_PRC_TRANSCRPT.gt_sua_dtl_table(

1422: v_out_string := NVL(IGS_AS_PRC_TRANSCRPT.gt_sua_dtl_table(
1423: v_index).v_short_title,'-');
1424: ELSIF p_s_letter_parameter_type = cst_trn_sua_pd THEN
1425: IF p_record_number = 1 THEN
1426: v_out_string := fnd_global.local_chr(10) || NVL(IGS_AS_PRC_TRANSCRPT.gt_sua_dtl_table(
1427: v_index).v_teach_alternate_code,'-');
1428: ELSE
1429: v_out_string := NVL(IGS_AS_PRC_TRANSCRPT.gt_sua_dtl_table(
1430: v_index).v_teach_alternate_code,'-');

Line 1588: '-'),50) || fnd_global.local_chr(09) ||

1584: IF v_index <= IGS_AS_PRC_TRANSCRPT.gv_asule_dtl_index THEN
1585: IF p_s_letter_parameter_type = cst_trn_asl_ln THEN
1586: v_out_string := RPAD(NVL(
1587: IGS_AS_PRC_TRANSCRPT.gt_asule_dtl_table(v_index).v_description,
1588: '-'),50) || fnd_global.local_chr(09) ||
1589: RPAD(NVL(TO_CHAR(
1590: IGS_AS_PRC_TRANSCRPT.gt_asule_dtl_table(v_index).v_cp_granted
1591: ,'990D99'),'-'),7) || fnd_global.local_chr(09) ||
1592: RPAD(NVL(IGS_AS_PRC_TRANSCRPT.gt_asule_dtl_table(v_index).v_unit_level,

Line 1591: ,'990D99'),'-'),7) || fnd_global.local_chr(09) ||

1587: IGS_AS_PRC_TRANSCRPT.gt_asule_dtl_table(v_index).v_description,
1588: '-'),50) || fnd_global.local_chr(09) ||
1589: RPAD(NVL(TO_CHAR(
1590: IGS_AS_PRC_TRANSCRPT.gt_asule_dtl_table(v_index).v_cp_granted
1591: ,'990D99'),'-'),7) || fnd_global.local_chr(09) ||
1592: RPAD(NVL(IGS_AS_PRC_TRANSCRPT.gt_asule_dtl_table(v_index).v_unit_level,
1593: '-'),1);
1594: ELSIF p_s_letter_parameter_type = cst_trn_asl_ds THEN
1595: v_out_string := NVL(

Line 1770: '-'),10) || fnd_global.local_chr(09) ||

1766: IF v_index <= IGS_AS_PRC_TRANSCRPT.gv_asu_dtl_index THEN
1767: IF p_s_letter_parameter_type = cst_trn_asu_ln THEN
1768: v_out_string := RPAD(NVL(
1769: IGS_AS_PRC_TRANSCRPT.gt_asu_dtl_table(v_index).v_unit_cd,
1770: '-'),10) || fnd_global.local_chr(09) ||
1771: RPAD(NVL(IGS_AS_PRC_TRANSCRPT.gt_asu_dtl_table(v_index).v_title,
1772: '-'),40) || fnd_global.local_chr(09) ||
1773: RPAD(NVL(TO_CHAR(
1774: IGS_AS_PRC_TRANSCRPT.gt_asu_dtl_table(v_index).v_cp_achievable

Line 1772: '-'),40) || fnd_global.local_chr(09) ||

1768: v_out_string := RPAD(NVL(
1769: IGS_AS_PRC_TRANSCRPT.gt_asu_dtl_table(v_index).v_unit_cd,
1770: '-'),10) || fnd_global.local_chr(09) ||
1771: RPAD(NVL(IGS_AS_PRC_TRANSCRPT.gt_asu_dtl_table(v_index).v_title,
1772: '-'),40) || fnd_global.local_chr(09) ||
1773: RPAD(NVL(TO_CHAR(
1774: IGS_AS_PRC_TRANSCRPT.gt_asu_dtl_table(v_index).v_cp_achievable
1775: ,'990D99'),'-'),7) || fnd_global.local_chr(09) ||
1776: RPAD(NVL(IGS_AS_PRC_TRANSCRPT.gt_asu_dtl_table(v_index).v_unit_level,

Line 1775: ,'990D99'),'-'),7) || fnd_global.local_chr(09) ||

1771: RPAD(NVL(IGS_AS_PRC_TRANSCRPT.gt_asu_dtl_table(v_index).v_title,
1772: '-'),40) || fnd_global.local_chr(09) ||
1773: RPAD(NVL(TO_CHAR(
1774: IGS_AS_PRC_TRANSCRPT.gt_asu_dtl_table(v_index).v_cp_achievable
1775: ,'990D99'),'-'),7) || fnd_global.local_chr(09) ||
1776: RPAD(NVL(IGS_AS_PRC_TRANSCRPT.gt_asu_dtl_table(v_index).v_unit_level,
1777: '-'),1);
1778: ELSIF p_s_letter_parameter_type = cst_trn_asu_cd THEN
1779: v_out_string := NVL(

Line 1934: v_out_string := fnd_global.local_chr(10) || RPAD(NVL(

1930: v_out_string := NULL;
1931: IF v_index <= IGS_AS_PRC_TRANSCRPT.gv_adv_dtl_index THEN
1932: IF p_s_letter_parameter_type = cst_trn_adv_ln THEN
1933: IF p_record_number = 1 THEN
1934: v_out_string := fnd_global.local_chr(10) || RPAD(NVL(
1935: IGS_AS_PRC_TRANSCRPT.gt_adv_dtl_table(v_index).v_title,'-'),50) || fnd_global.local_chr(10);
1936: ELSE
1937: v_out_string := RPAD(NVL(
1938: IGS_AS_PRC_TRANSCRPT.gt_adv_dtl_table(v_index).v_title,'-'),50) || fnd_global.local_chr(10);

Line 1935: IGS_AS_PRC_TRANSCRPT.gt_adv_dtl_table(v_index).v_title,'-'),50) || fnd_global.local_chr(10);

1931: IF v_index <= IGS_AS_PRC_TRANSCRPT.gv_adv_dtl_index THEN
1932: IF p_s_letter_parameter_type = cst_trn_adv_ln THEN
1933: IF p_record_number = 1 THEN
1934: v_out_string := fnd_global.local_chr(10) || RPAD(NVL(
1935: IGS_AS_PRC_TRANSCRPT.gt_adv_dtl_table(v_index).v_title,'-'),50) || fnd_global.local_chr(10);
1936: ELSE
1937: v_out_string := RPAD(NVL(
1938: IGS_AS_PRC_TRANSCRPT.gt_adv_dtl_table(v_index).v_title,'-'),50) || fnd_global.local_chr(10);
1939: END IF;

Line 1938: IGS_AS_PRC_TRANSCRPT.gt_adv_dtl_table(v_index).v_title,'-'),50) || fnd_global.local_chr(10);

1934: v_out_string := fnd_global.local_chr(10) || RPAD(NVL(
1935: IGS_AS_PRC_TRANSCRPT.gt_adv_dtl_table(v_index).v_title,'-'),50) || fnd_global.local_chr(10);
1936: ELSE
1937: v_out_string := RPAD(NVL(
1938: IGS_AS_PRC_TRANSCRPT.gt_adv_dtl_table(v_index).v_title,'-'),50) || fnd_global.local_chr(10);
1939: END IF;
1940: END IF;
1941: END IF;
1942: RETURN v_out_string;

Line 2368: v_out_string := fnd_global.local_chr(10) || RPAD(NVL(

2364: v_index := p_record_number;
2365: v_out_string := NULL;
2366: IF v_index <= IGS_AS_PRC_TRANSCRPT.gv_sca_dtl_index THEN
2367: IF p_s_letter_parameter_type = cst_trn_course THEN
2368: v_out_string := fnd_global.local_chr(10) || RPAD(NVL(
2369: IGS_AS_PRC_TRANSCRPT.gt_sca_dtl_table(v_index).v_acad_alternate_code,'-'),10)
2370: || ' ' ||
2371: RPAD(NVL(IGS_AS_PRC_TRANSCRPT.gt_sca_dtl_table(v_index).v_course_cd,'-'),10)
2372: || ' ' ||