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_DATE

Line 153: FND_DATE.DATE_TO_DISPLAYDATE(IGS_AS_PRC_TRANSCRPT.gt_grd_dtl_table(

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
157: ||' CONFERRED ON ' ||

Line 158: 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
157: ||' CONFERRED 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 ' ||

Line 163: 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 ||
167: ' TO BE CONFERRED AT A FORTHCOMING GRADUATION CEREMONY.';

Line 171: FND_DATE.DATE_TO_DISPLAYDATE(IGS_AS_PRC_TRANSCRPT.gt_grd_dtl_table(

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
175: v_out_string := fnd_global.local_chr(10) || 'COURSE REQUIREMENTS COMPLETED ON ' ||

Line 176: 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
180: v_out_string := NULL;

Line 187: FND_DATE.DATE_TO_DISPLAYDATE(IGS_AS_PRC_TRANSCRPT.gt_grd_dtl_table(

183: IF p_s_letter_parameter_type = 'TRN_GRD_LN' THEN
184: IF IGS_AS_PRC_TRANSCRPT.gt_grd_dtl_table(v_index).v_type
185: = 'COMP_GRAD' THEN
186: v_out_string := 'COURSE REQUIREMENTS COMPLETED ON ' ||
187: FND_DATE.DATE_TO_DISPLAYDATE(IGS_AS_PRC_TRANSCRPT.gt_grd_dtl_table(
188: v_index).v_completion_dt) || '. AWARD OF ' ||
189: IGS_AS_PRC_TRANSCRPT.gt_grd_dtl_table(
190: v_index).v_award_title
191: ||' CONFERRED ON ' ||

Line 192: FND_DATE.DATE_TO_DISPLAYDATE(IGS_AS_PRC_TRANSCRPT.gt_grd_dtl_table(

188: v_index).v_completion_dt) || '. AWARD OF ' ||
189: IGS_AS_PRC_TRANSCRPT.gt_grd_dtl_table(
190: v_index).v_award_title
191: ||' CONFERRED ON ' ||
192: FND_DATE.DATE_TO_DISPLAYDATE(IGS_AS_PRC_TRANSCRPT.gt_grd_dtl_table(
193: v_index).v_conferral_dt);
194: ELSIF IGS_AS_PRC_TRANSCRPT.gt_grd_dtl_table(v_index).v_type
195: = 'COMP_ELIG' THEN
196: v_out_string := 'COURSE REQUIREMENTS COMPLETED ON ' ||

Line 197: FND_DATE.DATE_TO_DISPLAYDATE(IGS_AS_PRC_TRANSCRPT.gt_grd_dtl_table(

193: v_index).v_conferral_dt);
194: ELSIF IGS_AS_PRC_TRANSCRPT.gt_grd_dtl_table(v_index).v_type
195: = 'COMP_ELIG' THEN
196: v_out_string := 'COURSE REQUIREMENTS COMPLETED ON ' ||
197: FND_DATE.DATE_TO_DISPLAYDATE(IGS_AS_PRC_TRANSCRPT.gt_grd_dtl_table(
198: v_index).v_completion_dt) || '. AWARD OF ' ||
199: IGS_AS_PRC_TRANSCRPT.gt_grd_dtl_table(
200: v_index).v_award_title ||
201: ' TO BE CONFERRED AT A FORTHCOMING GRADUATION CEREMONY.';

Line 205: FND_DATE.DATE_TO_DISPLAYDATE(IGS_AS_PRC_TRANSCRPT.gt_grd_dtl_table(

201: ' TO BE CONFERRED AT A FORTHCOMING GRADUATION CEREMONY.';
202: ELSIF IGS_AS_PRC_TRANSCRPT.gt_grd_dtl_table(v_index).v_type
203: = 'COMP_NOAWD' THEN
204: v_out_string := 'COURSE REQUIREMENTS COMPLETED ON ' ||
205: FND_DATE.DATE_TO_DISPLAYDATE(IGS_AS_PRC_TRANSCRPT.gt_grd_dtl_table(
206: v_index).v_completion_dt) || '. PROCEEDING TO A HIGHER AWARD.';
207: ELSIF IGS_AS_PRC_TRANSCRPT.gt_grd_dtl_table(v_index).v_type
208: = 'COMPLETED' THEN
209: v_out_string := 'COURSE REQUIREMENTS COMPLETED ON ' ||

Line 210: FND_DATE.DATE_TO_DISPLAYDATE(IGS_AS_PRC_TRANSCRPT.gt_grd_dtl_table(

206: v_index).v_completion_dt) || '. PROCEEDING TO A HIGHER AWARD.';
207: ELSIF IGS_AS_PRC_TRANSCRPT.gt_grd_dtl_table(v_index).v_type
208: = 'COMPLETED' THEN
209: v_out_string := 'COURSE REQUIREMENTS COMPLETED ON ' ||
210: FND_DATE.DATE_TO_DISPLAYDATE(IGS_AS_PRC_TRANSCRPT.gt_grd_dtl_table(
211: v_index).v_completion_dt);
212: END IF;
213: ELSE
214: v_out_string := NULL;

Line 502: FND_DATE.DATE_TO_DISPLAYDATE(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
505: v_out_string := NVL(IGS_AS_PRC_TRANSCRPT.gt_susa_dtl_table(
506: v_index).v_title,'-') || ' COMPLETED ON ' ||

Line 507: FND_DATE.DATE_TO_DISPLAYDATE(IGS_AS_PRC_TRANSCRPT.gt_susa_dtl_table(

503: v_index).v_completion_dt);
504: ELSE
505: v_out_string := NVL(IGS_AS_PRC_TRANSCRPT.gt_susa_dtl_table(
506: v_index).v_title,'-') || ' COMPLETED ON ' ||
507: FND_DATE.DATE_TO_DISPLAYDATE(IGS_AS_PRC_TRANSCRPT.gt_susa_dtl_table(
508: v_index).v_completion_dt);
509: END IF;
510: END IF;
511: ELSIF p_s_letter_parameter_type = cst_trn_uss_al THEN

Line 519: FND_DATE.DATE_TO_DISPLAYDATE(IGS_AS_PRC_TRANSCRPT.gt_susa_dtl_table(

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);
521: ELSE
522: v_out_string := NVL(IGS_AS_PRC_TRANSCRPT.gt_susa_dtl_table(
523: v_index).v_title,'-')

Line 525: FND_DATE.DATE_TO_DISPLAYDATE(IGS_AS_PRC_TRANSCRPT.gt_susa_dtl_table(

521: ELSE
522: v_out_string := NVL(IGS_AS_PRC_TRANSCRPT.gt_susa_dtl_table(
523: v_index).v_title,'-')
524: || ' SELECTED ON ' ||
525: FND_DATE.DATE_TO_DISPLAYDATE(IGS_AS_PRC_TRANSCRPT.gt_susa_dtl_table(
526: v_index).v_selection_dt);
527: END IF;
528: END IF;
529: ELSIF p_s_letter_parameter_type = cst_trn_usc_ps THEN

Line 539: FND_DATE.DATE_TO_DISPLAYDATE(IGS_AS_PRC_TRANSCRPT.gt_susa_dtl_table(v_index).v_completion_dt);

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
541: v_out_string := NVL(IGS_AS_PRC_TRANSCRPT.gt_susa_dtl_table(
542: v_index).v_title,'-')
543: || ' COMPLETED ON ' ||

Line 544: FND_DATE.DATE_TO_DISPLAYDATE(IGS_AS_PRC_TRANSCRPT.gt_susa_dtl_table(

540: ELSE
541: v_out_string := NVL(IGS_AS_PRC_TRANSCRPT.gt_susa_dtl_table(
542: v_index).v_title,'-')
543: || ' COMPLETED ON ' ||
544: FND_DATE.DATE_TO_DISPLAYDATE(IGS_AS_PRC_TRANSCRPT.gt_susa_dtl_table(
545: v_index).v_completion_dt);
546: END IF;
547: END IF;
548: END IF;

Line 559: FND_DATE.DATE_TO_DISPLAYDATE(IGS_AS_PRC_TRANSCRPT.gt_susa_dtl_table(

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);
561: ELSE
562: v_out_string := NVL(IGS_AS_PRC_TRANSCRPT.gt_susa_dtl_table(
563: v_index).v_title,'-')

Line 565: FND_DATE.DATE_TO_DISPLAYDATE(IGS_AS_PRC_TRANSCRPT.gt_susa_dtl_table(

561: ELSE
562: v_out_string := NVL(IGS_AS_PRC_TRANSCRPT.gt_susa_dtl_table(
563: v_index).v_title,'-')
564: || ' SELECTED ON ' ||
565: FND_DATE.DATE_TO_DISPLAYDATE(IGS_AS_PRC_TRANSCRPT.gt_susa_dtl_table(
566: v_index).v_selection_dt);
567: END IF;
568: END IF;
569: END IF;

Line 897: FND_DATE.DATE_TO_DISPLAYDATE(IGS_AS_PRC_TRANSCRPT.gt_sct_dtl_table(

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

Line 906: FND_DATE.DATE_TO_DISPLAYDATE(IGS_AS_PRC_TRANSCRPT.gt_sct_dtl_table(

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

Line 916: FND_DATE.DATE_TO_DISPLAYDATE(IGS_AS_PRC_TRANSCRPT.gt_sct_dtl_table(

912: NVL(IGS_AS_PRC_TRANSCRPT.gt_sct_dtl_table(
913: v_index).v_from_course,'-') || ' TO COURSE ' ||
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 ' ||

Line 925: FND_DATE.DATE_TO_DISPLAYDATE(IGS_AS_PRC_TRANSCRPT.gt_sct_dtl_table(

921: NVL(IGS_AS_PRC_TRANSCRPT.gt_sct_dtl_table(
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

Line 1106: FND_DATE.DATE_TO_DISPLAYDATE(IGS_AS_PRC_TRANSCRPT.gt_stdg_dtl_table(v_index).v_int_start_dt

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
1110: v_out_string := fnd_global.local_chr(10) || 'ENROLMENT LAPSED ON ' ||

Line 1108: FND_DATE.DATE_TO_DISPLAYDATE(IGS_AS_PRC_TRANSCRPT.gt_stdg_dtl_table(v_index).v_int_end_dt);

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

Line 1111: FND_DATE.DATE_TO_DISPLAYDATE(IGS_AS_PRC_TRANSCRPT.gt_stdg_dtl_table(v_index).v_lapsed_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 ' ||
1115: FND_DATE.DATE_TO_DISPLAYDATE(IGS_AS_PRC_TRANSCRPT.gt_stdg_dtl_table(

Line 1115: FND_DATE.DATE_TO_DISPLAYDATE(IGS_AS_PRC_TRANSCRPT.gt_stdg_dtl_table(

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
1119: v_out_string := NULL;

Line 1125: FND_DATE.DATE_TO_DISPLAYDATE(IGS_AS_PRC_TRANSCRPT.gt_stdg_dtl_table(v_index).v_int_start_dt

1121: ELSE
1122: IF p_s_letter_parameter_type = 'TRN_STDG' THEN
1123: IF IGS_AS_PRC_TRANSCRPT.gt_stdg_dtl_table(v_index).v_type = 'INTERMIT' THEN
1124: v_out_string := 'COURSE ENROLMENT INTERMITTED FROM ' ||
1125: FND_DATE.DATE_TO_DISPLAYDATE(IGS_AS_PRC_TRANSCRPT.gt_stdg_dtl_table(v_index).v_int_start_dt
1126: ) || ' TO ' ||
1127: FND_DATE.DATE_TO_DISPLAYDATE(IGS_AS_PRC_TRANSCRPT.gt_stdg_dtl_table(v_index).v_int_end_dt
1128: );
1129: ELSIF IGS_AS_PRC_TRANSCRPT.gt_stdg_dtl_table(v_index).v_type = 'LAPSED' THEN

Line 1127: FND_DATE.DATE_TO_DISPLAYDATE(IGS_AS_PRC_TRANSCRPT.gt_stdg_dtl_table(v_index).v_int_end_dt

1123: IF IGS_AS_PRC_TRANSCRPT.gt_stdg_dtl_table(v_index).v_type = 'INTERMIT' THEN
1124: v_out_string := 'COURSE ENROLMENT INTERMITTED FROM ' ||
1125: FND_DATE.DATE_TO_DISPLAYDATE(IGS_AS_PRC_TRANSCRPT.gt_stdg_dtl_table(v_index).v_int_start_dt
1126: ) || ' TO ' ||
1127: FND_DATE.DATE_TO_DISPLAYDATE(IGS_AS_PRC_TRANSCRPT.gt_stdg_dtl_table(v_index).v_int_end_dt
1128: );
1129: ELSIF IGS_AS_PRC_TRANSCRPT.gt_stdg_dtl_table(v_index).v_type = 'LAPSED' THEN
1130: v_out_string := 'ENROLEMENT LAPSED ON ' ||
1131: FND_DATE.DATE_TO_DISPLAYDATE(IGS_AS_PRC_TRANSCRPT.gt_stdg_dtl_table(v_index).v_lapsed_dt

Line 1131: FND_DATE.DATE_TO_DISPLAYDATE(IGS_AS_PRC_TRANSCRPT.gt_stdg_dtl_table(v_index).v_lapsed_dt

1127: FND_DATE.DATE_TO_DISPLAYDATE(IGS_AS_PRC_TRANSCRPT.gt_stdg_dtl_table(v_index).v_int_end_dt
1128: );
1129: ELSIF IGS_AS_PRC_TRANSCRPT.gt_stdg_dtl_table(v_index).v_type = 'LAPSED' THEN
1130: v_out_string := 'ENROLEMENT LAPSED ON ' ||
1131: FND_DATE.DATE_TO_DISPLAYDATE(IGS_AS_PRC_TRANSCRPT.gt_stdg_dtl_table(v_index).v_lapsed_dt
1132: );
1133: ELSIF IGS_AS_PRC_TRANSCRPT.gt_stdg_dtl_table(v_index).v_type
1134: = 'DISCONTIN' THEN
1135: v_out_string := 'COURSE ENROLMENT DISCONTINUED ON ' ||

Line 1136: FND_DATE.DATE_TO_DISPLAYDATE(IGS_AS_PRC_TRANSCRPT.gt_stdg_dtl_table(

1132: );
1133: ELSIF IGS_AS_PRC_TRANSCRPT.gt_stdg_dtl_table(v_index).v_type
1134: = 'DISCONTIN' THEN
1135: v_out_string := 'COURSE ENROLMENT DISCONTINUED ON ' ||
1136: FND_DATE.DATE_TO_DISPLAYDATE(IGS_AS_PRC_TRANSCRPT.gt_stdg_dtl_table(
1137: v_index).v_discontinued_dt);
1138: END IF;
1139: ELSE
1140: v_out_string := NULL;

Line 2378: v_out_string := NVL(FND_DATE.DATE_TO_DISPLAYDATE(

2374: ELSIF p_s_letter_parameter_type = cst_trn_crs_cd THEN
2375: v_out_string := NVL(
2376: IGS_AS_PRC_TRANSCRPT.gt_sca_dtl_table(v_index).v_course_cd,'-');
2377: ELSIF p_s_letter_parameter_type = cst_trn_crs_dt THEN
2378: v_out_string := NVL(FND_DATE.DATE_TO_DISPLAYDATE(
2379: IGS_AS_PRC_TRANSCRPT.gt_sca_dtl_table(v_index).v_commencement_dt
2380: ),'-');
2381: ELSIF p_s_letter_parameter_type = cst_trn_crs_at THEN
2382: v_out_string := NVL(