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_GR_ESS_ESD_DATA dependencies on FND_DATE

Line 55: p_ess_rec.acct_schedule_date := fnd_date.STRING_TO_DATE(SUBSTR(p_record_data,51,8),'YYYYMMDD');

51: p_ess_rec.rep_pell_id := SUBSTR(p_record_data,2,6);
52: p_ess_rec.duns_id := SUBSTR(p_record_data,8,11);
53: p_ess_rec.gaps_award_num := SUBSTR(p_record_data,30,16);
54: p_ess_rec.acct_schedule_number := SUBSTR(p_record_data,46,5);
55: p_ess_rec.acct_schedule_date := fnd_date.STRING_TO_DATE(SUBSTR(p_record_data,51,8),'YYYYMMDD');
56: p_ess_rec.prev_obligation_amt := TO_NUMBER(SUBSTR(p_record_data,59,11))/100;
57: p_ess_rec.obligation_adj_amt := TO_NUMBER(SUBSTR(p_record_data,70,11))/100;
58: p_ess_rec.curr_obligation_amt := TO_NUMBER(SUBSTR(p_record_data,81,11))/100;
59: p_ess_rec.prev_obligation_pymt_amt := TO_NUMBER(SUBSTR(p_record_data,92,11))/100;

Line 67: p_ess_rec.gaps_last_date := fnd_date.STRING_TO_DATE(SUBSTR(p_record_data,178,8),'YYYYMMDD');

63: p_ess_rec.ytd_accepted_disb_amt := TO_NUMBER(SUBSTR(p_record_data,132,11))/100;
64: p_ess_rec.ytd_posted_disb_amt := TO_NUMBER(SUBSTR(p_record_data,143,11))/100;
65: p_ess_rec.ytd_admin_cost_allowance := TO_NUMBER(SUBSTR(p_record_data,154,11))/100;
66: p_ess_rec.caps_drwn_dn_pymts := TO_NUMBER(SUBSTR(p_record_data,165,13))/100;
67: p_ess_rec.gaps_last_date := fnd_date.STRING_TO_DATE(SUBSTR(p_record_data,178,8),'YYYYMMDD');
68:
69:
70: EXCEPTION
71: WHEN OTHERS THEN -- Number / Date format exception

Line 83: p_ess_rec.acct_schedule_date := fnd_date.STRING_TO_DATE(SUBSTR(p_record_data,51,8),'YYYYMMDD');

79: p_ess_rec.rep_pell_id := SUBSTR(p_record_data,2,6);
80: p_ess_rec.duns_id := SUBSTR(p_record_data,8,11);
81: p_ess_rec.gaps_award_num := SUBSTR(p_record_data,30,16);
82: p_ess_rec.acct_schedule_number := NULL;
83: p_ess_rec.acct_schedule_date := fnd_date.STRING_TO_DATE(SUBSTR(p_record_data,51,8),'YYYYMMDD');
84: p_ess_rec.prev_obligation_amt := TO_NUMBER(SUBSTR(p_record_data,59,11))/100;
85: p_ess_rec.obligation_adj_amt := TO_NUMBER(SUBSTR(p_record_data,70,11))/100;
86: p_ess_rec.curr_obligation_amt := TO_NUMBER(SUBSTR(p_record_data,81,11))/100;
87: p_ess_rec.prev_obligation_pymt_amt := TO_NUMBER(SUBSTR(p_record_data,92,11))/100;

Line 95: p_ess_rec.gaps_last_date := fnd_date.STRING_TO_DATE(SUBSTR(p_record_data,178,8),'YYYYMMDD');

91: p_ess_rec.ytd_accepted_disb_amt := TO_NUMBER(SUBSTR(p_record_data,132,11))/100;
92: p_ess_rec.ytd_posted_disb_amt := NULL;
93: p_ess_rec.ytd_admin_cost_allowance := TO_NUMBER(SUBSTR(p_record_data,154,11))/100;
94: p_ess_rec.caps_drwn_dn_pymts := TO_NUMBER(SUBSTR(p_record_data,165,13))/100;
95: p_ess_rec.gaps_last_date := fnd_date.STRING_TO_DATE(SUBSTR(p_record_data,178,8),'YYYYMMDD');
96:
97:
98: EXCEPTION
99: WHEN OTHERS THEN -- Number / Date format exception

Line 147: p_esd_rec.transaction_date := fnd_date.STRING_TO_DATE(SUBSTR(p_record_data,46,8),'YYYYMMDD');

143: BEGIN
144: p_esd_rec.rep_pell_id := SUBSTR(p_record_data,2,6);
145: p_esd_rec.duns_id := SUBSTR(p_record_data,8,11);
146: p_esd_rec.gaps_award_num := SUBSTR(p_record_data,30,16);
147: p_esd_rec.transaction_date := fnd_date.STRING_TO_DATE(SUBSTR(p_record_data,46,8),'YYYYMMDD');
148: p_esd_rec.db_cr_flag := SUBSTR(p_record_data,54,1);
149: p_esd_rec.adj_amt := TO_NUMBER(SUBSTR(p_record_data,55,11))/100;
150: p_esd_rec.gaps_process_date := fnd_date.STRING_TO_DATE(SUBSTR(p_record_data,66,8),'YYYYMMDD');
151: p_esd_rec.adj_batch_id := SUBSTR(p_record_data,74,26);

Line 150: p_esd_rec.gaps_process_date := fnd_date.STRING_TO_DATE(SUBSTR(p_record_data,66,8),'YYYYMMDD');

146: p_esd_rec.gaps_award_num := SUBSTR(p_record_data,30,16);
147: p_esd_rec.transaction_date := fnd_date.STRING_TO_DATE(SUBSTR(p_record_data,46,8),'YYYYMMDD');
148: p_esd_rec.db_cr_flag := SUBSTR(p_record_data,54,1);
149: p_esd_rec.adj_amt := TO_NUMBER(SUBSTR(p_record_data,55,11))/100;
150: p_esd_rec.gaps_process_date := fnd_date.STRING_TO_DATE(SUBSTR(p_record_data,66,8),'YYYYMMDD');
151: p_esd_rec.adj_batch_id := SUBSTR(p_record_data,74,26);
152:
153: EXCEPTION
154: WHEN OTHERS THEN -- Number / Date format exception

Line 164: p_esd_rec.transaction_date := fnd_date.STRING_TO_DATE(SUBSTR(p_record_data,46,8),'YYYYMMDD');

160: BEGIN
161: p_esd_rec.rep_pell_id := SUBSTR(p_record_data,2,6);
162: p_esd_rec.duns_id := SUBSTR(p_record_data,8,11);
163: p_esd_rec.gaps_award_num := SUBSTR(p_record_data,30,16);
164: p_esd_rec.transaction_date := fnd_date.STRING_TO_DATE(SUBSTR(p_record_data,46,8),'YYYYMMDD');
165: p_esd_rec.db_cr_flag := SUBSTR(p_record_data,54,1);
166: p_esd_rec.adj_amt := TO_NUMBER(SUBSTR(p_record_data,55,11))/100;
167: p_esd_rec.gaps_process_date := fnd_date.STRING_TO_DATE(SUBSTR(p_record_data,66,8),'YYYYMMDD');
168: p_esd_rec.adj_batch_id := SUBSTR(p_record_data,74,30);

Line 167: p_esd_rec.gaps_process_date := fnd_date.STRING_TO_DATE(SUBSTR(p_record_data,66,8),'YYYYMMDD');

163: p_esd_rec.gaps_award_num := SUBSTR(p_record_data,30,16);
164: p_esd_rec.transaction_date := fnd_date.STRING_TO_DATE(SUBSTR(p_record_data,46,8),'YYYYMMDD');
165: p_esd_rec.db_cr_flag := SUBSTR(p_record_data,54,1);
166: p_esd_rec.adj_amt := TO_NUMBER(SUBSTR(p_record_data,55,11))/100;
167: p_esd_rec.gaps_process_date := fnd_date.STRING_TO_DATE(SUBSTR(p_record_data,66,8),'YYYYMMDD');
168: p_esd_rec.adj_batch_id := SUBSTR(p_record_data,74,30);
169:
170: EXCEPTION
171: WHEN OTHERS THEN -- Number / Date format exception