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.IGF_DB_DL_RECONC dependencies on FND_DATE

Line 227: l_dl_ytds_rec.stat_end_dt :=FND_DATE.STRING_TO_DATE(SUBSTR(loadrec.record_data,35,8),'YYYYMMDD');

223: l_dl_ytds_rec.batch_id :=SUBSTR(loadrec.record_data, 2,23);
224: l_dl_ytds_rec.school_code :=SUBSTR(loadrec.record_data, 25,6);
225: l_dl_ytds_rec.region_code :=SUBSTR(loadrec.record_data,31,2);
226: l_dl_ytds_rec.state_code :=SUBSTR(loadrec.record_data,33,2);
227: l_dl_ytds_rec.stat_end_dt :=FND_DATE.STRING_TO_DATE(SUBSTR(loadrec.record_data,35,8),'YYYYMMDD');
228: l_dl_ytds_rec.process_dt :=FND_DATE.STRING_TO_DATE(SUBSTR(loadrec.record_data,43,8),'YYYYMMDD');
229: l_dl_ytds_rec.disb_smr_type :=SUBSTR(loadrec.record_data,51,2);
230: l_dl_ytds_rec.bkd_gross :=SUBSTR(loadrec.record_data,53,11);
231: l_dl_ytds_rec.bkd_fee :=SUBSTR(loadrec.record_data,64,11);

Line 228: l_dl_ytds_rec.process_dt :=FND_DATE.STRING_TO_DATE(SUBSTR(loadrec.record_data,43,8),'YYYYMMDD');

224: l_dl_ytds_rec.school_code :=SUBSTR(loadrec.record_data, 25,6);
225: l_dl_ytds_rec.region_code :=SUBSTR(loadrec.record_data,31,2);
226: l_dl_ytds_rec.state_code :=SUBSTR(loadrec.record_data,33,2);
227: l_dl_ytds_rec.stat_end_dt :=FND_DATE.STRING_TO_DATE(SUBSTR(loadrec.record_data,35,8),'YYYYMMDD');
228: l_dl_ytds_rec.process_dt :=FND_DATE.STRING_TO_DATE(SUBSTR(loadrec.record_data,43,8),'YYYYMMDD');
229: l_dl_ytds_rec.disb_smr_type :=SUBSTR(loadrec.record_data,51,2);
230: l_dl_ytds_rec.bkd_gross :=SUBSTR(loadrec.record_data,53,11);
231: l_dl_ytds_rec.bkd_fee :=SUBSTR(loadrec.record_data,64,11);
232: l_dl_ytds_rec.bkd_int_rebate :=SUBSTR(loadrec.record_data,75,11);

Line 425: l_dl_ytds_rec_det.stat_end_dt := FND_DATE.STRING_TO_DATE(SUBSTR(loadrec.record_data,35,8),'YYYYMMDD');

421: l_dl_ytds_rec_det.batch_id := SUBSTR(loadrec.record_data,2,23);
422: l_dl_ytds_rec_det.school_code := SUBSTR(loadrec.record_data,25,6);
423: l_dl_ytds_rec_det.region_code := SUBSTR(loadrec.record_data,31,2);
424: l_dl_ytds_rec_det.state_code := SUBSTR(loadrec.record_data,33,2);
425: l_dl_ytds_rec_det.stat_end_dt := FND_DATE.STRING_TO_DATE(SUBSTR(loadrec.record_data,35,8),'YYYYMMDD');
426: l_dl_ytds_rec_det.process_dt := FND_DATE.STRING_TO_DATE(SUBSTR(loadrec.record_data,43,8),'YYYYMMDD');
427: l_dl_ytds_rec_det.loan_number := SUBSTR(loadrec.record_data,51,21);
428: l_dl_ytds_rec_det.loan_bkd_dt := FND_DATE.STRING_TO_DATE(SUBSTR(loadrec.record_data,72,8),'YYYYMMDD');
429: l_dl_ytds_rec_det.disb_bkd_dt := FND_DATE.STRING_TO_DATE(SUBSTR(loadrec.record_data,80,8),'YYYYMMDD');

Line 426: l_dl_ytds_rec_det.process_dt := FND_DATE.STRING_TO_DATE(SUBSTR(loadrec.record_data,43,8),'YYYYMMDD');

422: l_dl_ytds_rec_det.school_code := SUBSTR(loadrec.record_data,25,6);
423: l_dl_ytds_rec_det.region_code := SUBSTR(loadrec.record_data,31,2);
424: l_dl_ytds_rec_det.state_code := SUBSTR(loadrec.record_data,33,2);
425: l_dl_ytds_rec_det.stat_end_dt := FND_DATE.STRING_TO_DATE(SUBSTR(loadrec.record_data,35,8),'YYYYMMDD');
426: l_dl_ytds_rec_det.process_dt := FND_DATE.STRING_TO_DATE(SUBSTR(loadrec.record_data,43,8),'YYYYMMDD');
427: l_dl_ytds_rec_det.loan_number := SUBSTR(loadrec.record_data,51,21);
428: l_dl_ytds_rec_det.loan_bkd_dt := FND_DATE.STRING_TO_DATE(SUBSTR(loadrec.record_data,72,8),'YYYYMMDD');
429: l_dl_ytds_rec_det.disb_bkd_dt := FND_DATE.STRING_TO_DATE(SUBSTR(loadrec.record_data,80,8),'YYYYMMDD');
430: l_dl_ytds_rec_det.disb_gross := LTRIM(RTRIM(SUBSTR(loadrec.record_data,88,5)));

Line 428: l_dl_ytds_rec_det.loan_bkd_dt := FND_DATE.STRING_TO_DATE(SUBSTR(loadrec.record_data,72,8),'YYYYMMDD');

424: l_dl_ytds_rec_det.state_code := SUBSTR(loadrec.record_data,33,2);
425: l_dl_ytds_rec_det.stat_end_dt := FND_DATE.STRING_TO_DATE(SUBSTR(loadrec.record_data,35,8),'YYYYMMDD');
426: l_dl_ytds_rec_det.process_dt := FND_DATE.STRING_TO_DATE(SUBSTR(loadrec.record_data,43,8),'YYYYMMDD');
427: l_dl_ytds_rec_det.loan_number := SUBSTR(loadrec.record_data,51,21);
428: l_dl_ytds_rec_det.loan_bkd_dt := FND_DATE.STRING_TO_DATE(SUBSTR(loadrec.record_data,72,8),'YYYYMMDD');
429: l_dl_ytds_rec_det.disb_bkd_dt := FND_DATE.STRING_TO_DATE(SUBSTR(loadrec.record_data,80,8),'YYYYMMDD');
430: l_dl_ytds_rec_det.disb_gross := LTRIM(RTRIM(SUBSTR(loadrec.record_data,88,5)));
431: l_dl_ytds_rec_det.disb_fee := LTRIM(RTRIM(SUBSTR(loadrec.record_data,93,5)));
432: l_dl_ytds_rec_det.disb_int_rebate := LTRIM(RTRIM(SUBSTR(loadrec.record_data,98,5)));

Line 429: l_dl_ytds_rec_det.disb_bkd_dt := FND_DATE.STRING_TO_DATE(SUBSTR(loadrec.record_data,80,8),'YYYYMMDD');

425: l_dl_ytds_rec_det.stat_end_dt := FND_DATE.STRING_TO_DATE(SUBSTR(loadrec.record_data,35,8),'YYYYMMDD');
426: l_dl_ytds_rec_det.process_dt := FND_DATE.STRING_TO_DATE(SUBSTR(loadrec.record_data,43,8),'YYYYMMDD');
427: l_dl_ytds_rec_det.loan_number := SUBSTR(loadrec.record_data,51,21);
428: l_dl_ytds_rec_det.loan_bkd_dt := FND_DATE.STRING_TO_DATE(SUBSTR(loadrec.record_data,72,8),'YYYYMMDD');
429: l_dl_ytds_rec_det.disb_bkd_dt := FND_DATE.STRING_TO_DATE(SUBSTR(loadrec.record_data,80,8),'YYYYMMDD');
430: l_dl_ytds_rec_det.disb_gross := LTRIM(RTRIM(SUBSTR(loadrec.record_data,88,5)));
431: l_dl_ytds_rec_det.disb_fee := LTRIM(RTRIM(SUBSTR(loadrec.record_data,93,5)));
432: l_dl_ytds_rec_det.disb_int_rebate := LTRIM(RTRIM(SUBSTR(loadrec.record_data,98,5)));
433: l_dl_ytds_rec_det.disb_net := LTRIM(RTRIM(SUBSTR(loadrec.record_data,103,5)));

Line 438: l_dl_ytds_rec_det.trans_dt := FND_DATE.STRING_TO_DATE(SUBSTR(loadrec.record_data,119,8),'YYYYMMDD');

434: l_dl_ytds_rec_det.disb_net_adj := LTRIM(RTRIM(SUBSTR(loadrec.record_data,108,6)));
435: l_dl_ytds_rec_det.disb_num := LTRIM(RTRIM(SUBSTR(loadrec.record_data,114,2)));
436: l_dl_ytds_rec_det.disb_seq_num := LTRIM(RTRIM(SUBSTR(loadrec.record_data,116,2)));
437: l_dl_ytds_rec_det.trans_type := LTRIM(RTRIM(SUBSTR(loadrec.record_data,118,1)));
438: l_dl_ytds_rec_det.trans_dt := FND_DATE.STRING_TO_DATE(SUBSTR(loadrec.record_data,119,8),'YYYYMMDD');
439: l_dl_ytds_rec_det.total_gross := LTRIM(RTRIM(SUBSTR(loadrec.record_data,127,5)));
440: l_dl_ytds_rec_det.total_fee := LTRIM(RTRIM(SUBSTR(loadrec.record_data,132,5)));
441: l_dl_ytds_rec_det.total_int_rebate := LTRIM(RTRIM(SUBSTR(loadrec.record_data,137,5)));
442: l_dl_ytds_rec_det.total_net := LTRIM(RTRIM(SUBSTR(loadrec.record_data,142,5)));