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

Line 92: p_ytd_orig_row.accpt_disb_dt1 := fnd_date.string_to_date(SUBSTR( p_record_data, 69, 8), 'YYYYMMDD');

88: p_ytd_orig_row.ed_use := SUBSTR( p_record_data, 42, 5);
89: p_ytd_orig_row.inst_cross_ref_code := SUBSTR( p_record_data, 47, 13);
90: p_ytd_orig_row.action_code := SUBSTR( p_record_data, 60, 1);
91: p_ytd_orig_row.accpt_awd_amt := TO_NUMBER(SUBSTR( p_record_data, 62, 7))/100;
92: p_ytd_orig_row.accpt_disb_dt1 := fnd_date.string_to_date(SUBSTR( p_record_data, 69, 8), 'YYYYMMDD');
93: p_ytd_orig_row.accpt_disb_dt2 := fnd_date.string_to_date(SUBSTR( p_record_data, 77, 8), 'YYYYMMDD');
94: p_ytd_orig_row.accpt_disb_dt3 := fnd_date.string_to_date(SUBSTR( p_record_data, 85, 8), 'YYYYMMDD');
95: p_ytd_orig_row.accpt_disb_dt4 := fnd_date.string_to_date(SUBSTR( p_record_data, 93, 8), 'YYYYMMDD');
96: p_ytd_orig_row.accpt_disb_dt5 := fnd_date.string_to_date(SUBSTR( p_record_data, 101, 8), 'YYYYMMDD');

Line 93: p_ytd_orig_row.accpt_disb_dt2 := fnd_date.string_to_date(SUBSTR( p_record_data, 77, 8), 'YYYYMMDD');

89: p_ytd_orig_row.inst_cross_ref_code := SUBSTR( p_record_data, 47, 13);
90: p_ytd_orig_row.action_code := SUBSTR( p_record_data, 60, 1);
91: p_ytd_orig_row.accpt_awd_amt := TO_NUMBER(SUBSTR( p_record_data, 62, 7))/100;
92: p_ytd_orig_row.accpt_disb_dt1 := fnd_date.string_to_date(SUBSTR( p_record_data, 69, 8), 'YYYYMMDD');
93: p_ytd_orig_row.accpt_disb_dt2 := fnd_date.string_to_date(SUBSTR( p_record_data, 77, 8), 'YYYYMMDD');
94: p_ytd_orig_row.accpt_disb_dt3 := fnd_date.string_to_date(SUBSTR( p_record_data, 85, 8), 'YYYYMMDD');
95: p_ytd_orig_row.accpt_disb_dt4 := fnd_date.string_to_date(SUBSTR( p_record_data, 93, 8), 'YYYYMMDD');
96: p_ytd_orig_row.accpt_disb_dt5 := fnd_date.string_to_date(SUBSTR( p_record_data, 101, 8), 'YYYYMMDD');
97: p_ytd_orig_row.accpt_disb_dt6 := fnd_date.string_to_date(SUBSTR( p_record_data, 109, 8), 'YYYYMMDD');

Line 94: p_ytd_orig_row.accpt_disb_dt3 := fnd_date.string_to_date(SUBSTR( p_record_data, 85, 8), 'YYYYMMDD');

90: p_ytd_orig_row.action_code := SUBSTR( p_record_data, 60, 1);
91: p_ytd_orig_row.accpt_awd_amt := TO_NUMBER(SUBSTR( p_record_data, 62, 7))/100;
92: p_ytd_orig_row.accpt_disb_dt1 := fnd_date.string_to_date(SUBSTR( p_record_data, 69, 8), 'YYYYMMDD');
93: p_ytd_orig_row.accpt_disb_dt2 := fnd_date.string_to_date(SUBSTR( p_record_data, 77, 8), 'YYYYMMDD');
94: p_ytd_orig_row.accpt_disb_dt3 := fnd_date.string_to_date(SUBSTR( p_record_data, 85, 8), 'YYYYMMDD');
95: p_ytd_orig_row.accpt_disb_dt4 := fnd_date.string_to_date(SUBSTR( p_record_data, 93, 8), 'YYYYMMDD');
96: p_ytd_orig_row.accpt_disb_dt5 := fnd_date.string_to_date(SUBSTR( p_record_data, 101, 8), 'YYYYMMDD');
97: p_ytd_orig_row.accpt_disb_dt6 := fnd_date.string_to_date(SUBSTR( p_record_data, 109, 8), 'YYYYMMDD');
98: p_ytd_orig_row.accpt_disb_dt7 := fnd_date.string_to_date(SUBSTR( p_record_data, 117, 8), 'YYYYMMDD');

Line 95: p_ytd_orig_row.accpt_disb_dt4 := fnd_date.string_to_date(SUBSTR( p_record_data, 93, 8), 'YYYYMMDD');

91: p_ytd_orig_row.accpt_awd_amt := TO_NUMBER(SUBSTR( p_record_data, 62, 7))/100;
92: p_ytd_orig_row.accpt_disb_dt1 := fnd_date.string_to_date(SUBSTR( p_record_data, 69, 8), 'YYYYMMDD');
93: p_ytd_orig_row.accpt_disb_dt2 := fnd_date.string_to_date(SUBSTR( p_record_data, 77, 8), 'YYYYMMDD');
94: p_ytd_orig_row.accpt_disb_dt3 := fnd_date.string_to_date(SUBSTR( p_record_data, 85, 8), 'YYYYMMDD');
95: p_ytd_orig_row.accpt_disb_dt4 := fnd_date.string_to_date(SUBSTR( p_record_data, 93, 8), 'YYYYMMDD');
96: p_ytd_orig_row.accpt_disb_dt5 := fnd_date.string_to_date(SUBSTR( p_record_data, 101, 8), 'YYYYMMDD');
97: p_ytd_orig_row.accpt_disb_dt6 := fnd_date.string_to_date(SUBSTR( p_record_data, 109, 8), 'YYYYMMDD');
98: p_ytd_orig_row.accpt_disb_dt7 := fnd_date.string_to_date(SUBSTR( p_record_data, 117, 8), 'YYYYMMDD');
99: p_ytd_orig_row.accpt_disb_dt8 := fnd_date.string_to_date(SUBSTR( p_record_data, 125, 8), 'YYYYMMDD');

Line 96: p_ytd_orig_row.accpt_disb_dt5 := fnd_date.string_to_date(SUBSTR( p_record_data, 101, 8), 'YYYYMMDD');

92: p_ytd_orig_row.accpt_disb_dt1 := fnd_date.string_to_date(SUBSTR( p_record_data, 69, 8), 'YYYYMMDD');
93: p_ytd_orig_row.accpt_disb_dt2 := fnd_date.string_to_date(SUBSTR( p_record_data, 77, 8), 'YYYYMMDD');
94: p_ytd_orig_row.accpt_disb_dt3 := fnd_date.string_to_date(SUBSTR( p_record_data, 85, 8), 'YYYYMMDD');
95: p_ytd_orig_row.accpt_disb_dt4 := fnd_date.string_to_date(SUBSTR( p_record_data, 93, 8), 'YYYYMMDD');
96: p_ytd_orig_row.accpt_disb_dt5 := fnd_date.string_to_date(SUBSTR( p_record_data, 101, 8), 'YYYYMMDD');
97: p_ytd_orig_row.accpt_disb_dt6 := fnd_date.string_to_date(SUBSTR( p_record_data, 109, 8), 'YYYYMMDD');
98: p_ytd_orig_row.accpt_disb_dt7 := fnd_date.string_to_date(SUBSTR( p_record_data, 117, 8), 'YYYYMMDD');
99: p_ytd_orig_row.accpt_disb_dt8 := fnd_date.string_to_date(SUBSTR( p_record_data, 125, 8), 'YYYYMMDD');
100: p_ytd_orig_row.accpt_disb_dt9 := fnd_date.string_to_date(SUBSTR( p_record_data, 133, 8), 'YYYYMMDD');

Line 97: p_ytd_orig_row.accpt_disb_dt6 := fnd_date.string_to_date(SUBSTR( p_record_data, 109, 8), 'YYYYMMDD');

93: p_ytd_orig_row.accpt_disb_dt2 := fnd_date.string_to_date(SUBSTR( p_record_data, 77, 8), 'YYYYMMDD');
94: p_ytd_orig_row.accpt_disb_dt3 := fnd_date.string_to_date(SUBSTR( p_record_data, 85, 8), 'YYYYMMDD');
95: p_ytd_orig_row.accpt_disb_dt4 := fnd_date.string_to_date(SUBSTR( p_record_data, 93, 8), 'YYYYMMDD');
96: p_ytd_orig_row.accpt_disb_dt5 := fnd_date.string_to_date(SUBSTR( p_record_data, 101, 8), 'YYYYMMDD');
97: p_ytd_orig_row.accpt_disb_dt6 := fnd_date.string_to_date(SUBSTR( p_record_data, 109, 8), 'YYYYMMDD');
98: p_ytd_orig_row.accpt_disb_dt7 := fnd_date.string_to_date(SUBSTR( p_record_data, 117, 8), 'YYYYMMDD');
99: p_ytd_orig_row.accpt_disb_dt8 := fnd_date.string_to_date(SUBSTR( p_record_data, 125, 8), 'YYYYMMDD');
100: p_ytd_orig_row.accpt_disb_dt9 := fnd_date.string_to_date(SUBSTR( p_record_data, 133, 8), 'YYYYMMDD');
101: p_ytd_orig_row.accpt_disb_dt10 := fnd_date.string_to_date(SUBSTR( p_record_data, 141, 8), 'YYYYMMDD');

Line 98: p_ytd_orig_row.accpt_disb_dt7 := fnd_date.string_to_date(SUBSTR( p_record_data, 117, 8), 'YYYYMMDD');

94: p_ytd_orig_row.accpt_disb_dt3 := fnd_date.string_to_date(SUBSTR( p_record_data, 85, 8), 'YYYYMMDD');
95: p_ytd_orig_row.accpt_disb_dt4 := fnd_date.string_to_date(SUBSTR( p_record_data, 93, 8), 'YYYYMMDD');
96: p_ytd_orig_row.accpt_disb_dt5 := fnd_date.string_to_date(SUBSTR( p_record_data, 101, 8), 'YYYYMMDD');
97: p_ytd_orig_row.accpt_disb_dt6 := fnd_date.string_to_date(SUBSTR( p_record_data, 109, 8), 'YYYYMMDD');
98: p_ytd_orig_row.accpt_disb_dt7 := fnd_date.string_to_date(SUBSTR( p_record_data, 117, 8), 'YYYYMMDD');
99: p_ytd_orig_row.accpt_disb_dt8 := fnd_date.string_to_date(SUBSTR( p_record_data, 125, 8), 'YYYYMMDD');
100: p_ytd_orig_row.accpt_disb_dt9 := fnd_date.string_to_date(SUBSTR( p_record_data, 133, 8), 'YYYYMMDD');
101: p_ytd_orig_row.accpt_disb_dt10 := fnd_date.string_to_date(SUBSTR( p_record_data, 141, 8), 'YYYYMMDD');
102: p_ytd_orig_row.accpt_disb_dt11 := fnd_date.string_to_date(SUBSTR( p_record_data, 149, 8), 'YYYYMMDD');

Line 99: p_ytd_orig_row.accpt_disb_dt8 := fnd_date.string_to_date(SUBSTR( p_record_data, 125, 8), 'YYYYMMDD');

95: p_ytd_orig_row.accpt_disb_dt4 := fnd_date.string_to_date(SUBSTR( p_record_data, 93, 8), 'YYYYMMDD');
96: p_ytd_orig_row.accpt_disb_dt5 := fnd_date.string_to_date(SUBSTR( p_record_data, 101, 8), 'YYYYMMDD');
97: p_ytd_orig_row.accpt_disb_dt6 := fnd_date.string_to_date(SUBSTR( p_record_data, 109, 8), 'YYYYMMDD');
98: p_ytd_orig_row.accpt_disb_dt7 := fnd_date.string_to_date(SUBSTR( p_record_data, 117, 8), 'YYYYMMDD');
99: p_ytd_orig_row.accpt_disb_dt8 := fnd_date.string_to_date(SUBSTR( p_record_data, 125, 8), 'YYYYMMDD');
100: p_ytd_orig_row.accpt_disb_dt9 := fnd_date.string_to_date(SUBSTR( p_record_data, 133, 8), 'YYYYMMDD');
101: p_ytd_orig_row.accpt_disb_dt10 := fnd_date.string_to_date(SUBSTR( p_record_data, 141, 8), 'YYYYMMDD');
102: p_ytd_orig_row.accpt_disb_dt11 := fnd_date.string_to_date(SUBSTR( p_record_data, 149, 8), 'YYYYMMDD');
103: p_ytd_orig_row.accpt_disb_dt12 := fnd_date.string_to_date(SUBSTR( p_record_data, 157, 8), 'YYYYMMDD');

Line 100: p_ytd_orig_row.accpt_disb_dt9 := fnd_date.string_to_date(SUBSTR( p_record_data, 133, 8), 'YYYYMMDD');

96: p_ytd_orig_row.accpt_disb_dt5 := fnd_date.string_to_date(SUBSTR( p_record_data, 101, 8), 'YYYYMMDD');
97: p_ytd_orig_row.accpt_disb_dt6 := fnd_date.string_to_date(SUBSTR( p_record_data, 109, 8), 'YYYYMMDD');
98: p_ytd_orig_row.accpt_disb_dt7 := fnd_date.string_to_date(SUBSTR( p_record_data, 117, 8), 'YYYYMMDD');
99: p_ytd_orig_row.accpt_disb_dt8 := fnd_date.string_to_date(SUBSTR( p_record_data, 125, 8), 'YYYYMMDD');
100: p_ytd_orig_row.accpt_disb_dt9 := fnd_date.string_to_date(SUBSTR( p_record_data, 133, 8), 'YYYYMMDD');
101: p_ytd_orig_row.accpt_disb_dt10 := fnd_date.string_to_date(SUBSTR( p_record_data, 141, 8), 'YYYYMMDD');
102: p_ytd_orig_row.accpt_disb_dt11 := fnd_date.string_to_date(SUBSTR( p_record_data, 149, 8), 'YYYYMMDD');
103: p_ytd_orig_row.accpt_disb_dt12 := fnd_date.string_to_date(SUBSTR( p_record_data, 157, 8), 'YYYYMMDD');
104: p_ytd_orig_row.accpt_disb_dt13 := fnd_date.string_to_date(SUBSTR( p_record_data, 165, 8), 'YYYYMMDD');

Line 101: p_ytd_orig_row.accpt_disb_dt10 := fnd_date.string_to_date(SUBSTR( p_record_data, 141, 8), 'YYYYMMDD');

97: p_ytd_orig_row.accpt_disb_dt6 := fnd_date.string_to_date(SUBSTR( p_record_data, 109, 8), 'YYYYMMDD');
98: p_ytd_orig_row.accpt_disb_dt7 := fnd_date.string_to_date(SUBSTR( p_record_data, 117, 8), 'YYYYMMDD');
99: p_ytd_orig_row.accpt_disb_dt8 := fnd_date.string_to_date(SUBSTR( p_record_data, 125, 8), 'YYYYMMDD');
100: p_ytd_orig_row.accpt_disb_dt9 := fnd_date.string_to_date(SUBSTR( p_record_data, 133, 8), 'YYYYMMDD');
101: p_ytd_orig_row.accpt_disb_dt10 := fnd_date.string_to_date(SUBSTR( p_record_data, 141, 8), 'YYYYMMDD');
102: p_ytd_orig_row.accpt_disb_dt11 := fnd_date.string_to_date(SUBSTR( p_record_data, 149, 8), 'YYYYMMDD');
103: p_ytd_orig_row.accpt_disb_dt12 := fnd_date.string_to_date(SUBSTR( p_record_data, 157, 8), 'YYYYMMDD');
104: p_ytd_orig_row.accpt_disb_dt13 := fnd_date.string_to_date(SUBSTR( p_record_data, 165, 8), 'YYYYMMDD');
105: p_ytd_orig_row.accpt_disb_dt14 := fnd_date.string_to_date(SUBSTR( p_record_data, 173, 8), 'YYYYMMDD');

Line 102: p_ytd_orig_row.accpt_disb_dt11 := fnd_date.string_to_date(SUBSTR( p_record_data, 149, 8), 'YYYYMMDD');

98: p_ytd_orig_row.accpt_disb_dt7 := fnd_date.string_to_date(SUBSTR( p_record_data, 117, 8), 'YYYYMMDD');
99: p_ytd_orig_row.accpt_disb_dt8 := fnd_date.string_to_date(SUBSTR( p_record_data, 125, 8), 'YYYYMMDD');
100: p_ytd_orig_row.accpt_disb_dt9 := fnd_date.string_to_date(SUBSTR( p_record_data, 133, 8), 'YYYYMMDD');
101: p_ytd_orig_row.accpt_disb_dt10 := fnd_date.string_to_date(SUBSTR( p_record_data, 141, 8), 'YYYYMMDD');
102: p_ytd_orig_row.accpt_disb_dt11 := fnd_date.string_to_date(SUBSTR( p_record_data, 149, 8), 'YYYYMMDD');
103: p_ytd_orig_row.accpt_disb_dt12 := fnd_date.string_to_date(SUBSTR( p_record_data, 157, 8), 'YYYYMMDD');
104: p_ytd_orig_row.accpt_disb_dt13 := fnd_date.string_to_date(SUBSTR( p_record_data, 165, 8), 'YYYYMMDD');
105: p_ytd_orig_row.accpt_disb_dt14 := fnd_date.string_to_date(SUBSTR( p_record_data, 173, 8), 'YYYYMMDD');
106: p_ytd_orig_row.accpt_disb_dt15 := fnd_date.string_to_date(SUBSTR( p_record_data, 181, 8), 'YYYYMMDD');

Line 103: p_ytd_orig_row.accpt_disb_dt12 := fnd_date.string_to_date(SUBSTR( p_record_data, 157, 8), 'YYYYMMDD');

99: p_ytd_orig_row.accpt_disb_dt8 := fnd_date.string_to_date(SUBSTR( p_record_data, 125, 8), 'YYYYMMDD');
100: p_ytd_orig_row.accpt_disb_dt9 := fnd_date.string_to_date(SUBSTR( p_record_data, 133, 8), 'YYYYMMDD');
101: p_ytd_orig_row.accpt_disb_dt10 := fnd_date.string_to_date(SUBSTR( p_record_data, 141, 8), 'YYYYMMDD');
102: p_ytd_orig_row.accpt_disb_dt11 := fnd_date.string_to_date(SUBSTR( p_record_data, 149, 8), 'YYYYMMDD');
103: p_ytd_orig_row.accpt_disb_dt12 := fnd_date.string_to_date(SUBSTR( p_record_data, 157, 8), 'YYYYMMDD');
104: p_ytd_orig_row.accpt_disb_dt13 := fnd_date.string_to_date(SUBSTR( p_record_data, 165, 8), 'YYYYMMDD');
105: p_ytd_orig_row.accpt_disb_dt14 := fnd_date.string_to_date(SUBSTR( p_record_data, 173, 8), 'YYYYMMDD');
106: p_ytd_orig_row.accpt_disb_dt15 := fnd_date.string_to_date(SUBSTR( p_record_data, 181, 8), 'YYYYMMDD');
107: p_ytd_orig_row.accpt_enrl_dt := fnd_date.string_to_date(SUBSTR( p_record_data, 189, 8), 'YYYYMMDD');

Line 104: p_ytd_orig_row.accpt_disb_dt13 := fnd_date.string_to_date(SUBSTR( p_record_data, 165, 8), 'YYYYMMDD');

100: p_ytd_orig_row.accpt_disb_dt9 := fnd_date.string_to_date(SUBSTR( p_record_data, 133, 8), 'YYYYMMDD');
101: p_ytd_orig_row.accpt_disb_dt10 := fnd_date.string_to_date(SUBSTR( p_record_data, 141, 8), 'YYYYMMDD');
102: p_ytd_orig_row.accpt_disb_dt11 := fnd_date.string_to_date(SUBSTR( p_record_data, 149, 8), 'YYYYMMDD');
103: p_ytd_orig_row.accpt_disb_dt12 := fnd_date.string_to_date(SUBSTR( p_record_data, 157, 8), 'YYYYMMDD');
104: p_ytd_orig_row.accpt_disb_dt13 := fnd_date.string_to_date(SUBSTR( p_record_data, 165, 8), 'YYYYMMDD');
105: p_ytd_orig_row.accpt_disb_dt14 := fnd_date.string_to_date(SUBSTR( p_record_data, 173, 8), 'YYYYMMDD');
106: p_ytd_orig_row.accpt_disb_dt15 := fnd_date.string_to_date(SUBSTR( p_record_data, 181, 8), 'YYYYMMDD');
107: p_ytd_orig_row.accpt_enrl_dt := fnd_date.string_to_date(SUBSTR( p_record_data, 189, 8), 'YYYYMMDD');
108: p_ytd_orig_row.accpt_low_tut_flg := SUBSTR( p_record_data, 197, 1);

Line 105: p_ytd_orig_row.accpt_disb_dt14 := fnd_date.string_to_date(SUBSTR( p_record_data, 173, 8), 'YYYYMMDD');

101: p_ytd_orig_row.accpt_disb_dt10 := fnd_date.string_to_date(SUBSTR( p_record_data, 141, 8), 'YYYYMMDD');
102: p_ytd_orig_row.accpt_disb_dt11 := fnd_date.string_to_date(SUBSTR( p_record_data, 149, 8), 'YYYYMMDD');
103: p_ytd_orig_row.accpt_disb_dt12 := fnd_date.string_to_date(SUBSTR( p_record_data, 157, 8), 'YYYYMMDD');
104: p_ytd_orig_row.accpt_disb_dt13 := fnd_date.string_to_date(SUBSTR( p_record_data, 165, 8), 'YYYYMMDD');
105: p_ytd_orig_row.accpt_disb_dt14 := fnd_date.string_to_date(SUBSTR( p_record_data, 173, 8), 'YYYYMMDD');
106: p_ytd_orig_row.accpt_disb_dt15 := fnd_date.string_to_date(SUBSTR( p_record_data, 181, 8), 'YYYYMMDD');
107: p_ytd_orig_row.accpt_enrl_dt := fnd_date.string_to_date(SUBSTR( p_record_data, 189, 8), 'YYYYMMDD');
108: p_ytd_orig_row.accpt_low_tut_flg := SUBSTR( p_record_data, 197, 1);
109: p_ytd_orig_row.accpt_ver_stat_flg := SUBSTR( p_record_data, 198, 1);

Line 106: p_ytd_orig_row.accpt_disb_dt15 := fnd_date.string_to_date(SUBSTR( p_record_data, 181, 8), 'YYYYMMDD');

102: p_ytd_orig_row.accpt_disb_dt11 := fnd_date.string_to_date(SUBSTR( p_record_data, 149, 8), 'YYYYMMDD');
103: p_ytd_orig_row.accpt_disb_dt12 := fnd_date.string_to_date(SUBSTR( p_record_data, 157, 8), 'YYYYMMDD');
104: p_ytd_orig_row.accpt_disb_dt13 := fnd_date.string_to_date(SUBSTR( p_record_data, 165, 8), 'YYYYMMDD');
105: p_ytd_orig_row.accpt_disb_dt14 := fnd_date.string_to_date(SUBSTR( p_record_data, 173, 8), 'YYYYMMDD');
106: p_ytd_orig_row.accpt_disb_dt15 := fnd_date.string_to_date(SUBSTR( p_record_data, 181, 8), 'YYYYMMDD');
107: p_ytd_orig_row.accpt_enrl_dt := fnd_date.string_to_date(SUBSTR( p_record_data, 189, 8), 'YYYYMMDD');
108: p_ytd_orig_row.accpt_low_tut_flg := SUBSTR( p_record_data, 197, 1);
109: p_ytd_orig_row.accpt_ver_stat_flg := SUBSTR( p_record_data, 198, 1);
110: p_ytd_orig_row.accpt_incr_pell_cd := SUBSTR( p_record_data, 199, 1);

Line 107: p_ytd_orig_row.accpt_enrl_dt := fnd_date.string_to_date(SUBSTR( p_record_data, 189, 8), 'YYYYMMDD');

103: p_ytd_orig_row.accpt_disb_dt12 := fnd_date.string_to_date(SUBSTR( p_record_data, 157, 8), 'YYYYMMDD');
104: p_ytd_orig_row.accpt_disb_dt13 := fnd_date.string_to_date(SUBSTR( p_record_data, 165, 8), 'YYYYMMDD');
105: p_ytd_orig_row.accpt_disb_dt14 := fnd_date.string_to_date(SUBSTR( p_record_data, 173, 8), 'YYYYMMDD');
106: p_ytd_orig_row.accpt_disb_dt15 := fnd_date.string_to_date(SUBSTR( p_record_data, 181, 8), 'YYYYMMDD');
107: p_ytd_orig_row.accpt_enrl_dt := fnd_date.string_to_date(SUBSTR( p_record_data, 189, 8), 'YYYYMMDD');
108: p_ytd_orig_row.accpt_low_tut_flg := SUBSTR( p_record_data, 197, 1);
109: p_ytd_orig_row.accpt_ver_stat_flg := SUBSTR( p_record_data, 198, 1);
110: p_ytd_orig_row.accpt_incr_pell_cd := SUBSTR( p_record_data, 199, 1);
111: p_ytd_orig_row.accpt_tran_num := SUBSTR( p_record_data, 200, 2);

Line 126: p_ytd_orig_row.stud_dob := fnd_date.string_to_date(SUBSTR( p_record_data, 295, 8), 'YYYYMMDD');

122: p_ytd_orig_row.inst_seq_num := SUBSTR( p_record_data, 230, 3);
123: p_ytd_orig_row.sch_full_time_pell := TO_NUMBER(SUBSTR( p_record_data, 252, 5));
124: p_ytd_orig_row.stud_name := SUBSTR( p_record_data, 257, 29);
125: p_ytd_orig_row.ssn := SUBSTR( p_record_data, 286, 9);
126: p_ytd_orig_row.stud_dob := fnd_date.string_to_date(SUBSTR( p_record_data, 295, 8), 'YYYYMMDD');
127: p_ytd_orig_row.cps_ver_sel_cd := fnd_date.string_to_date(SUBSTR( p_record_data, 303, 1), 'YYYYMMDD');
128: p_ytd_orig_row.ytd_disb_amt := TO_NUMBER(SUBSTR( p_record_data, 304, 7))/100;
129: p_ytd_orig_row.batch_id := SUBSTR( p_record_data, 311, 26);
130: p_ytd_orig_row.process_date := fnd_date.string_to_date(SUBSTR( p_record_data, 337, 8), 'YYYYMMDD');

Line 127: p_ytd_orig_row.cps_ver_sel_cd := fnd_date.string_to_date(SUBSTR( p_record_data, 303, 1), 'YYYYMMDD');

123: p_ytd_orig_row.sch_full_time_pell := TO_NUMBER(SUBSTR( p_record_data, 252, 5));
124: p_ytd_orig_row.stud_name := SUBSTR( p_record_data, 257, 29);
125: p_ytd_orig_row.ssn := SUBSTR( p_record_data, 286, 9);
126: p_ytd_orig_row.stud_dob := fnd_date.string_to_date(SUBSTR( p_record_data, 295, 8), 'YYYYMMDD');
127: p_ytd_orig_row.cps_ver_sel_cd := fnd_date.string_to_date(SUBSTR( p_record_data, 303, 1), 'YYYYMMDD');
128: p_ytd_orig_row.ytd_disb_amt := TO_NUMBER(SUBSTR( p_record_data, 304, 7))/100;
129: p_ytd_orig_row.batch_id := SUBSTR( p_record_data, 311, 26);
130: p_ytd_orig_row.process_date := fnd_date.string_to_date(SUBSTR( p_record_data, 337, 8), 'YYYYMMDD');
131:

Line 130: p_ytd_orig_row.process_date := fnd_date.string_to_date(SUBSTR( p_record_data, 337, 8), 'YYYYMMDD');

126: p_ytd_orig_row.stud_dob := fnd_date.string_to_date(SUBSTR( p_record_data, 295, 8), 'YYYYMMDD');
127: p_ytd_orig_row.cps_ver_sel_cd := fnd_date.string_to_date(SUBSTR( p_record_data, 303, 1), 'YYYYMMDD');
128: p_ytd_orig_row.ytd_disb_amt := TO_NUMBER(SUBSTR( p_record_data, 304, 7))/100;
129: p_ytd_orig_row.batch_id := SUBSTR( p_record_data, 311, 26);
130: p_ytd_orig_row.process_date := fnd_date.string_to_date(SUBSTR( p_record_data, 337, 8), 'YYYYMMDD');
131:
132: END IF;
133:
134: EXCEPTION

Line 149: p_ytd_orig_row.accpt_disb_dt1 := fnd_date.string_to_date(SUBSTR( p_record_data, 69, 8), 'YYYYMMDD');

145: p_ytd_orig_row.ed_use := SUBSTR( p_record_data, 42, 5);
146: p_ytd_orig_row.inst_cross_ref_code := SUBSTR( p_record_data, 47, 13);
147: p_ytd_orig_row.action_code := SUBSTR( p_record_data, 60, 1);
148: p_ytd_orig_row.accpt_awd_amt := TO_NUMBER(SUBSTR( p_record_data, 62, 7))/100;
149: p_ytd_orig_row.accpt_disb_dt1 := fnd_date.string_to_date(SUBSTR( p_record_data, 69, 8), 'YYYYMMDD');
150: p_ytd_orig_row.accpt_disb_dt2 := fnd_date.string_to_date(SUBSTR( p_record_data, 77, 8), 'YYYYMMDD');
151: p_ytd_orig_row.accpt_disb_dt3 := fnd_date.string_to_date(SUBSTR( p_record_data, 85, 8), 'YYYYMMDD');
152: p_ytd_orig_row.accpt_disb_dt4 := fnd_date.string_to_date(SUBSTR( p_record_data, 93, 8), 'YYYYMMDD');
153: p_ytd_orig_row.accpt_disb_dt5 := fnd_date.string_to_date(SUBSTR( p_record_data, 101, 8), 'YYYYMMDD');

Line 150: p_ytd_orig_row.accpt_disb_dt2 := fnd_date.string_to_date(SUBSTR( p_record_data, 77, 8), 'YYYYMMDD');

146: p_ytd_orig_row.inst_cross_ref_code := SUBSTR( p_record_data, 47, 13);
147: p_ytd_orig_row.action_code := SUBSTR( p_record_data, 60, 1);
148: p_ytd_orig_row.accpt_awd_amt := TO_NUMBER(SUBSTR( p_record_data, 62, 7))/100;
149: p_ytd_orig_row.accpt_disb_dt1 := fnd_date.string_to_date(SUBSTR( p_record_data, 69, 8), 'YYYYMMDD');
150: p_ytd_orig_row.accpt_disb_dt2 := fnd_date.string_to_date(SUBSTR( p_record_data, 77, 8), 'YYYYMMDD');
151: p_ytd_orig_row.accpt_disb_dt3 := fnd_date.string_to_date(SUBSTR( p_record_data, 85, 8), 'YYYYMMDD');
152: p_ytd_orig_row.accpt_disb_dt4 := fnd_date.string_to_date(SUBSTR( p_record_data, 93, 8), 'YYYYMMDD');
153: p_ytd_orig_row.accpt_disb_dt5 := fnd_date.string_to_date(SUBSTR( p_record_data, 101, 8), 'YYYYMMDD');
154: p_ytd_orig_row.accpt_disb_dt6 := fnd_date.string_to_date(SUBSTR( p_record_data, 109, 8), 'YYYYMMDD');

Line 151: p_ytd_orig_row.accpt_disb_dt3 := fnd_date.string_to_date(SUBSTR( p_record_data, 85, 8), 'YYYYMMDD');

147: p_ytd_orig_row.action_code := SUBSTR( p_record_data, 60, 1);
148: p_ytd_orig_row.accpt_awd_amt := TO_NUMBER(SUBSTR( p_record_data, 62, 7))/100;
149: p_ytd_orig_row.accpt_disb_dt1 := fnd_date.string_to_date(SUBSTR( p_record_data, 69, 8), 'YYYYMMDD');
150: p_ytd_orig_row.accpt_disb_dt2 := fnd_date.string_to_date(SUBSTR( p_record_data, 77, 8), 'YYYYMMDD');
151: p_ytd_orig_row.accpt_disb_dt3 := fnd_date.string_to_date(SUBSTR( p_record_data, 85, 8), 'YYYYMMDD');
152: p_ytd_orig_row.accpt_disb_dt4 := fnd_date.string_to_date(SUBSTR( p_record_data, 93, 8), 'YYYYMMDD');
153: p_ytd_orig_row.accpt_disb_dt5 := fnd_date.string_to_date(SUBSTR( p_record_data, 101, 8), 'YYYYMMDD');
154: p_ytd_orig_row.accpt_disb_dt6 := fnd_date.string_to_date(SUBSTR( p_record_data, 109, 8), 'YYYYMMDD');
155: p_ytd_orig_row.accpt_disb_dt7 := fnd_date.string_to_date(SUBSTR( p_record_data, 117, 8), 'YYYYMMDD');

Line 152: p_ytd_orig_row.accpt_disb_dt4 := fnd_date.string_to_date(SUBSTR( p_record_data, 93, 8), 'YYYYMMDD');

148: p_ytd_orig_row.accpt_awd_amt := TO_NUMBER(SUBSTR( p_record_data, 62, 7))/100;
149: p_ytd_orig_row.accpt_disb_dt1 := fnd_date.string_to_date(SUBSTR( p_record_data, 69, 8), 'YYYYMMDD');
150: p_ytd_orig_row.accpt_disb_dt2 := fnd_date.string_to_date(SUBSTR( p_record_data, 77, 8), 'YYYYMMDD');
151: p_ytd_orig_row.accpt_disb_dt3 := fnd_date.string_to_date(SUBSTR( p_record_data, 85, 8), 'YYYYMMDD');
152: p_ytd_orig_row.accpt_disb_dt4 := fnd_date.string_to_date(SUBSTR( p_record_data, 93, 8), 'YYYYMMDD');
153: p_ytd_orig_row.accpt_disb_dt5 := fnd_date.string_to_date(SUBSTR( p_record_data, 101, 8), 'YYYYMMDD');
154: p_ytd_orig_row.accpt_disb_dt6 := fnd_date.string_to_date(SUBSTR( p_record_data, 109, 8), 'YYYYMMDD');
155: p_ytd_orig_row.accpt_disb_dt7 := fnd_date.string_to_date(SUBSTR( p_record_data, 117, 8), 'YYYYMMDD');
156: p_ytd_orig_row.accpt_disb_dt8 := fnd_date.string_to_date(SUBSTR( p_record_data, 125, 8), 'YYYYMMDD');

Line 153: p_ytd_orig_row.accpt_disb_dt5 := fnd_date.string_to_date(SUBSTR( p_record_data, 101, 8), 'YYYYMMDD');

149: p_ytd_orig_row.accpt_disb_dt1 := fnd_date.string_to_date(SUBSTR( p_record_data, 69, 8), 'YYYYMMDD');
150: p_ytd_orig_row.accpt_disb_dt2 := fnd_date.string_to_date(SUBSTR( p_record_data, 77, 8), 'YYYYMMDD');
151: p_ytd_orig_row.accpt_disb_dt3 := fnd_date.string_to_date(SUBSTR( p_record_data, 85, 8), 'YYYYMMDD');
152: p_ytd_orig_row.accpt_disb_dt4 := fnd_date.string_to_date(SUBSTR( p_record_data, 93, 8), 'YYYYMMDD');
153: p_ytd_orig_row.accpt_disb_dt5 := fnd_date.string_to_date(SUBSTR( p_record_data, 101, 8), 'YYYYMMDD');
154: p_ytd_orig_row.accpt_disb_dt6 := fnd_date.string_to_date(SUBSTR( p_record_data, 109, 8), 'YYYYMMDD');
155: p_ytd_orig_row.accpt_disb_dt7 := fnd_date.string_to_date(SUBSTR( p_record_data, 117, 8), 'YYYYMMDD');
156: p_ytd_orig_row.accpt_disb_dt8 := fnd_date.string_to_date(SUBSTR( p_record_data, 125, 8), 'YYYYMMDD');
157: p_ytd_orig_row.accpt_disb_dt9 := fnd_date.string_to_date(SUBSTR( p_record_data, 133, 8), 'YYYYMMDD');

Line 154: p_ytd_orig_row.accpt_disb_dt6 := fnd_date.string_to_date(SUBSTR( p_record_data, 109, 8), 'YYYYMMDD');

150: p_ytd_orig_row.accpt_disb_dt2 := fnd_date.string_to_date(SUBSTR( p_record_data, 77, 8), 'YYYYMMDD');
151: p_ytd_orig_row.accpt_disb_dt3 := fnd_date.string_to_date(SUBSTR( p_record_data, 85, 8), 'YYYYMMDD');
152: p_ytd_orig_row.accpt_disb_dt4 := fnd_date.string_to_date(SUBSTR( p_record_data, 93, 8), 'YYYYMMDD');
153: p_ytd_orig_row.accpt_disb_dt5 := fnd_date.string_to_date(SUBSTR( p_record_data, 101, 8), 'YYYYMMDD');
154: p_ytd_orig_row.accpt_disb_dt6 := fnd_date.string_to_date(SUBSTR( p_record_data, 109, 8), 'YYYYMMDD');
155: p_ytd_orig_row.accpt_disb_dt7 := fnd_date.string_to_date(SUBSTR( p_record_data, 117, 8), 'YYYYMMDD');
156: p_ytd_orig_row.accpt_disb_dt8 := fnd_date.string_to_date(SUBSTR( p_record_data, 125, 8), 'YYYYMMDD');
157: p_ytd_orig_row.accpt_disb_dt9 := fnd_date.string_to_date(SUBSTR( p_record_data, 133, 8), 'YYYYMMDD');
158: p_ytd_orig_row.accpt_disb_dt10 := fnd_date.string_to_date(SUBSTR( p_record_data, 141, 8), 'YYYYMMDD');

Line 155: p_ytd_orig_row.accpt_disb_dt7 := fnd_date.string_to_date(SUBSTR( p_record_data, 117, 8), 'YYYYMMDD');

151: p_ytd_orig_row.accpt_disb_dt3 := fnd_date.string_to_date(SUBSTR( p_record_data, 85, 8), 'YYYYMMDD');
152: p_ytd_orig_row.accpt_disb_dt4 := fnd_date.string_to_date(SUBSTR( p_record_data, 93, 8), 'YYYYMMDD');
153: p_ytd_orig_row.accpt_disb_dt5 := fnd_date.string_to_date(SUBSTR( p_record_data, 101, 8), 'YYYYMMDD');
154: p_ytd_orig_row.accpt_disb_dt6 := fnd_date.string_to_date(SUBSTR( p_record_data, 109, 8), 'YYYYMMDD');
155: p_ytd_orig_row.accpt_disb_dt7 := fnd_date.string_to_date(SUBSTR( p_record_data, 117, 8), 'YYYYMMDD');
156: p_ytd_orig_row.accpt_disb_dt8 := fnd_date.string_to_date(SUBSTR( p_record_data, 125, 8), 'YYYYMMDD');
157: p_ytd_orig_row.accpt_disb_dt9 := fnd_date.string_to_date(SUBSTR( p_record_data, 133, 8), 'YYYYMMDD');
158: p_ytd_orig_row.accpt_disb_dt10 := fnd_date.string_to_date(SUBSTR( p_record_data, 141, 8), 'YYYYMMDD');
159: p_ytd_orig_row.accpt_disb_dt11 := fnd_date.string_to_date(SUBSTR( p_record_data, 149, 8), 'YYYYMMDD');

Line 156: p_ytd_orig_row.accpt_disb_dt8 := fnd_date.string_to_date(SUBSTR( p_record_data, 125, 8), 'YYYYMMDD');

152: p_ytd_orig_row.accpt_disb_dt4 := fnd_date.string_to_date(SUBSTR( p_record_data, 93, 8), 'YYYYMMDD');
153: p_ytd_orig_row.accpt_disb_dt5 := fnd_date.string_to_date(SUBSTR( p_record_data, 101, 8), 'YYYYMMDD');
154: p_ytd_orig_row.accpt_disb_dt6 := fnd_date.string_to_date(SUBSTR( p_record_data, 109, 8), 'YYYYMMDD');
155: p_ytd_orig_row.accpt_disb_dt7 := fnd_date.string_to_date(SUBSTR( p_record_data, 117, 8), 'YYYYMMDD');
156: p_ytd_orig_row.accpt_disb_dt8 := fnd_date.string_to_date(SUBSTR( p_record_data, 125, 8), 'YYYYMMDD');
157: p_ytd_orig_row.accpt_disb_dt9 := fnd_date.string_to_date(SUBSTR( p_record_data, 133, 8), 'YYYYMMDD');
158: p_ytd_orig_row.accpt_disb_dt10 := fnd_date.string_to_date(SUBSTR( p_record_data, 141, 8), 'YYYYMMDD');
159: p_ytd_orig_row.accpt_disb_dt11 := fnd_date.string_to_date(SUBSTR( p_record_data, 149, 8), 'YYYYMMDD');
160: p_ytd_orig_row.accpt_disb_dt12 := fnd_date.string_to_date(SUBSTR( p_record_data, 157, 8), 'YYYYMMDD');

Line 157: p_ytd_orig_row.accpt_disb_dt9 := fnd_date.string_to_date(SUBSTR( p_record_data, 133, 8), 'YYYYMMDD');

153: p_ytd_orig_row.accpt_disb_dt5 := fnd_date.string_to_date(SUBSTR( p_record_data, 101, 8), 'YYYYMMDD');
154: p_ytd_orig_row.accpt_disb_dt6 := fnd_date.string_to_date(SUBSTR( p_record_data, 109, 8), 'YYYYMMDD');
155: p_ytd_orig_row.accpt_disb_dt7 := fnd_date.string_to_date(SUBSTR( p_record_data, 117, 8), 'YYYYMMDD');
156: p_ytd_orig_row.accpt_disb_dt8 := fnd_date.string_to_date(SUBSTR( p_record_data, 125, 8), 'YYYYMMDD');
157: p_ytd_orig_row.accpt_disb_dt9 := fnd_date.string_to_date(SUBSTR( p_record_data, 133, 8), 'YYYYMMDD');
158: p_ytd_orig_row.accpt_disb_dt10 := fnd_date.string_to_date(SUBSTR( p_record_data, 141, 8), 'YYYYMMDD');
159: p_ytd_orig_row.accpt_disb_dt11 := fnd_date.string_to_date(SUBSTR( p_record_data, 149, 8), 'YYYYMMDD');
160: p_ytd_orig_row.accpt_disb_dt12 := fnd_date.string_to_date(SUBSTR( p_record_data, 157, 8), 'YYYYMMDD');
161: p_ytd_orig_row.accpt_disb_dt13 := fnd_date.string_to_date(SUBSTR( p_record_data, 165, 8), 'YYYYMMDD');

Line 158: p_ytd_orig_row.accpt_disb_dt10 := fnd_date.string_to_date(SUBSTR( p_record_data, 141, 8), 'YYYYMMDD');

154: p_ytd_orig_row.accpt_disb_dt6 := fnd_date.string_to_date(SUBSTR( p_record_data, 109, 8), 'YYYYMMDD');
155: p_ytd_orig_row.accpt_disb_dt7 := fnd_date.string_to_date(SUBSTR( p_record_data, 117, 8), 'YYYYMMDD');
156: p_ytd_orig_row.accpt_disb_dt8 := fnd_date.string_to_date(SUBSTR( p_record_data, 125, 8), 'YYYYMMDD');
157: p_ytd_orig_row.accpt_disb_dt9 := fnd_date.string_to_date(SUBSTR( p_record_data, 133, 8), 'YYYYMMDD');
158: p_ytd_orig_row.accpt_disb_dt10 := fnd_date.string_to_date(SUBSTR( p_record_data, 141, 8), 'YYYYMMDD');
159: p_ytd_orig_row.accpt_disb_dt11 := fnd_date.string_to_date(SUBSTR( p_record_data, 149, 8), 'YYYYMMDD');
160: p_ytd_orig_row.accpt_disb_dt12 := fnd_date.string_to_date(SUBSTR( p_record_data, 157, 8), 'YYYYMMDD');
161: p_ytd_orig_row.accpt_disb_dt13 := fnd_date.string_to_date(SUBSTR( p_record_data, 165, 8), 'YYYYMMDD');
162: p_ytd_orig_row.accpt_disb_dt14 := fnd_date.string_to_date(SUBSTR( p_record_data, 173, 8), 'YYYYMMDD');

Line 159: p_ytd_orig_row.accpt_disb_dt11 := fnd_date.string_to_date(SUBSTR( p_record_data, 149, 8), 'YYYYMMDD');

155: p_ytd_orig_row.accpt_disb_dt7 := fnd_date.string_to_date(SUBSTR( p_record_data, 117, 8), 'YYYYMMDD');
156: p_ytd_orig_row.accpt_disb_dt8 := fnd_date.string_to_date(SUBSTR( p_record_data, 125, 8), 'YYYYMMDD');
157: p_ytd_orig_row.accpt_disb_dt9 := fnd_date.string_to_date(SUBSTR( p_record_data, 133, 8), 'YYYYMMDD');
158: p_ytd_orig_row.accpt_disb_dt10 := fnd_date.string_to_date(SUBSTR( p_record_data, 141, 8), 'YYYYMMDD');
159: p_ytd_orig_row.accpt_disb_dt11 := fnd_date.string_to_date(SUBSTR( p_record_data, 149, 8), 'YYYYMMDD');
160: p_ytd_orig_row.accpt_disb_dt12 := fnd_date.string_to_date(SUBSTR( p_record_data, 157, 8), 'YYYYMMDD');
161: p_ytd_orig_row.accpt_disb_dt13 := fnd_date.string_to_date(SUBSTR( p_record_data, 165, 8), 'YYYYMMDD');
162: p_ytd_orig_row.accpt_disb_dt14 := fnd_date.string_to_date(SUBSTR( p_record_data, 173, 8), 'YYYYMMDD');
163: p_ytd_orig_row.accpt_disb_dt15 := fnd_date.string_to_date(SUBSTR( p_record_data, 181, 8), 'YYYYMMDD');

Line 160: p_ytd_orig_row.accpt_disb_dt12 := fnd_date.string_to_date(SUBSTR( p_record_data, 157, 8), 'YYYYMMDD');

156: p_ytd_orig_row.accpt_disb_dt8 := fnd_date.string_to_date(SUBSTR( p_record_data, 125, 8), 'YYYYMMDD');
157: p_ytd_orig_row.accpt_disb_dt9 := fnd_date.string_to_date(SUBSTR( p_record_data, 133, 8), 'YYYYMMDD');
158: p_ytd_orig_row.accpt_disb_dt10 := fnd_date.string_to_date(SUBSTR( p_record_data, 141, 8), 'YYYYMMDD');
159: p_ytd_orig_row.accpt_disb_dt11 := fnd_date.string_to_date(SUBSTR( p_record_data, 149, 8), 'YYYYMMDD');
160: p_ytd_orig_row.accpt_disb_dt12 := fnd_date.string_to_date(SUBSTR( p_record_data, 157, 8), 'YYYYMMDD');
161: p_ytd_orig_row.accpt_disb_dt13 := fnd_date.string_to_date(SUBSTR( p_record_data, 165, 8), 'YYYYMMDD');
162: p_ytd_orig_row.accpt_disb_dt14 := fnd_date.string_to_date(SUBSTR( p_record_data, 173, 8), 'YYYYMMDD');
163: p_ytd_orig_row.accpt_disb_dt15 := fnd_date.string_to_date(SUBSTR( p_record_data, 181, 8), 'YYYYMMDD');
164: p_ytd_orig_row.accpt_enrl_dt := fnd_date.string_to_date(SUBSTR( p_record_data, 189, 8), 'YYYYMMDD');

Line 161: p_ytd_orig_row.accpt_disb_dt13 := fnd_date.string_to_date(SUBSTR( p_record_data, 165, 8), 'YYYYMMDD');

157: p_ytd_orig_row.accpt_disb_dt9 := fnd_date.string_to_date(SUBSTR( p_record_data, 133, 8), 'YYYYMMDD');
158: p_ytd_orig_row.accpt_disb_dt10 := fnd_date.string_to_date(SUBSTR( p_record_data, 141, 8), 'YYYYMMDD');
159: p_ytd_orig_row.accpt_disb_dt11 := fnd_date.string_to_date(SUBSTR( p_record_data, 149, 8), 'YYYYMMDD');
160: p_ytd_orig_row.accpt_disb_dt12 := fnd_date.string_to_date(SUBSTR( p_record_data, 157, 8), 'YYYYMMDD');
161: p_ytd_orig_row.accpt_disb_dt13 := fnd_date.string_to_date(SUBSTR( p_record_data, 165, 8), 'YYYYMMDD');
162: p_ytd_orig_row.accpt_disb_dt14 := fnd_date.string_to_date(SUBSTR( p_record_data, 173, 8), 'YYYYMMDD');
163: p_ytd_orig_row.accpt_disb_dt15 := fnd_date.string_to_date(SUBSTR( p_record_data, 181, 8), 'YYYYMMDD');
164: p_ytd_orig_row.accpt_enrl_dt := fnd_date.string_to_date(SUBSTR( p_record_data, 189, 8), 'YYYYMMDD');
165: p_ytd_orig_row.accpt_low_tut_flg := SUBSTR( p_record_data, 197, 1);

Line 162: p_ytd_orig_row.accpt_disb_dt14 := fnd_date.string_to_date(SUBSTR( p_record_data, 173, 8), 'YYYYMMDD');

158: p_ytd_orig_row.accpt_disb_dt10 := fnd_date.string_to_date(SUBSTR( p_record_data, 141, 8), 'YYYYMMDD');
159: p_ytd_orig_row.accpt_disb_dt11 := fnd_date.string_to_date(SUBSTR( p_record_data, 149, 8), 'YYYYMMDD');
160: p_ytd_orig_row.accpt_disb_dt12 := fnd_date.string_to_date(SUBSTR( p_record_data, 157, 8), 'YYYYMMDD');
161: p_ytd_orig_row.accpt_disb_dt13 := fnd_date.string_to_date(SUBSTR( p_record_data, 165, 8), 'YYYYMMDD');
162: p_ytd_orig_row.accpt_disb_dt14 := fnd_date.string_to_date(SUBSTR( p_record_data, 173, 8), 'YYYYMMDD');
163: p_ytd_orig_row.accpt_disb_dt15 := fnd_date.string_to_date(SUBSTR( p_record_data, 181, 8), 'YYYYMMDD');
164: p_ytd_orig_row.accpt_enrl_dt := fnd_date.string_to_date(SUBSTR( p_record_data, 189, 8), 'YYYYMMDD');
165: p_ytd_orig_row.accpt_low_tut_flg := SUBSTR( p_record_data, 197, 1);
166: p_ytd_orig_row.accpt_ver_stat_flg := SUBSTR( p_record_data, 198, 1);

Line 163: p_ytd_orig_row.accpt_disb_dt15 := fnd_date.string_to_date(SUBSTR( p_record_data, 181, 8), 'YYYYMMDD');

159: p_ytd_orig_row.accpt_disb_dt11 := fnd_date.string_to_date(SUBSTR( p_record_data, 149, 8), 'YYYYMMDD');
160: p_ytd_orig_row.accpt_disb_dt12 := fnd_date.string_to_date(SUBSTR( p_record_data, 157, 8), 'YYYYMMDD');
161: p_ytd_orig_row.accpt_disb_dt13 := fnd_date.string_to_date(SUBSTR( p_record_data, 165, 8), 'YYYYMMDD');
162: p_ytd_orig_row.accpt_disb_dt14 := fnd_date.string_to_date(SUBSTR( p_record_data, 173, 8), 'YYYYMMDD');
163: p_ytd_orig_row.accpt_disb_dt15 := fnd_date.string_to_date(SUBSTR( p_record_data, 181, 8), 'YYYYMMDD');
164: p_ytd_orig_row.accpt_enrl_dt := fnd_date.string_to_date(SUBSTR( p_record_data, 189, 8), 'YYYYMMDD');
165: p_ytd_orig_row.accpt_low_tut_flg := SUBSTR( p_record_data, 197, 1);
166: p_ytd_orig_row.accpt_ver_stat_flg := SUBSTR( p_record_data, 198, 1);
167: p_ytd_orig_row.accpt_incr_pell_cd := SUBSTR( p_record_data, 199, 1);

Line 164: p_ytd_orig_row.accpt_enrl_dt := fnd_date.string_to_date(SUBSTR( p_record_data, 189, 8), 'YYYYMMDD');

160: p_ytd_orig_row.accpt_disb_dt12 := fnd_date.string_to_date(SUBSTR( p_record_data, 157, 8), 'YYYYMMDD');
161: p_ytd_orig_row.accpt_disb_dt13 := fnd_date.string_to_date(SUBSTR( p_record_data, 165, 8), 'YYYYMMDD');
162: p_ytd_orig_row.accpt_disb_dt14 := fnd_date.string_to_date(SUBSTR( p_record_data, 173, 8), 'YYYYMMDD');
163: p_ytd_orig_row.accpt_disb_dt15 := fnd_date.string_to_date(SUBSTR( p_record_data, 181, 8), 'YYYYMMDD');
164: p_ytd_orig_row.accpt_enrl_dt := fnd_date.string_to_date(SUBSTR( p_record_data, 189, 8), 'YYYYMMDD');
165: p_ytd_orig_row.accpt_low_tut_flg := SUBSTR( p_record_data, 197, 1);
166: p_ytd_orig_row.accpt_ver_stat_flg := SUBSTR( p_record_data, 198, 1);
167: p_ytd_orig_row.accpt_incr_pell_cd := SUBSTR( p_record_data, 199, 1);
168: p_ytd_orig_row.accpt_tran_num := SUBSTR( p_record_data, 200, 2);

Line 183: p_ytd_orig_row.stud_dob := fnd_date.string_to_date(SUBSTR( p_record_data, 295, 8), 'YYYYMMDD');

179: p_ytd_orig_row.inst_seq_num := SUBSTR( p_record_data, 230, 3);
180: p_ytd_orig_row.sch_full_time_pell := TO_NUMBER(SUBSTR( p_record_data, 252, 5));
181: p_ytd_orig_row.stud_name := SUBSTR( p_record_data, 257, 29);
182: p_ytd_orig_row.ssn := SUBSTR( p_record_data, 286, 9);
183: p_ytd_orig_row.stud_dob := fnd_date.string_to_date(SUBSTR( p_record_data, 295, 8), 'YYYYMMDD');
184: p_ytd_orig_row.cps_ver_sel_cd := SUBSTR( p_record_data, 303, 1);
185: p_ytd_orig_row.ytd_disb_amt := TO_NUMBER(SUBSTR( p_record_data, 304, 7))/100;
186: p_ytd_orig_row.batch_id := NULL;
187: p_ytd_orig_row.process_date := fnd_date.string_to_date(SUBSTR( p_record_data, 337, 8), 'YYYYMMDD');

Line 187: p_ytd_orig_row.process_date := fnd_date.string_to_date(SUBSTR( p_record_data, 337, 8), 'YYYYMMDD');

183: p_ytd_orig_row.stud_dob := fnd_date.string_to_date(SUBSTR( p_record_data, 295, 8), 'YYYYMMDD');
184: p_ytd_orig_row.cps_ver_sel_cd := SUBSTR( p_record_data, 303, 1);
185: p_ytd_orig_row.ytd_disb_amt := TO_NUMBER(SUBSTR( p_record_data, 304, 7))/100;
186: p_ytd_orig_row.batch_id := NULL;
187: p_ytd_orig_row.process_date := fnd_date.string_to_date(SUBSTR( p_record_data, 337, 8), 'YYYYMMDD');
188:
189:
190: ELSE
191: RAISE igf_gr_gen.no_file_version;

Line 275: p_ytd_disb_row.disb_dt := fnd_date.string_to_date(SUBSTR( p_record_data, 49, 8), 'YYYYMMDD');

271: p_ytd_disb_row.action_code := SUBSTR( p_record_data, 38, 1);
272: p_ytd_disb_row.disb_ref_num := SUBSTR( p_record_data, 39, 2);
273: p_ytd_disb_row.disb_accpt_amt := TO_NUMBER(SUBSTR( p_record_data, 41, 7))/100;
274: p_ytd_disb_row.db_cr_flag := SUBSTR( p_record_data, 48, 1);
275: p_ytd_disb_row.disb_dt := fnd_date.string_to_date(SUBSTR( p_record_data, 49, 8), 'YYYYMMDD');
276: p_ytd_disb_row.pymt_prd_start_dt := fnd_date.string_to_date(SUBSTR( p_record_data, 94, 8), 'YYYYMMDD');
277: p_ytd_disb_row.disb_batch_id := SUBSTR( p_record_data, 139, 26);
278:
279: END IF;

Line 276: p_ytd_disb_row.pymt_prd_start_dt := fnd_date.string_to_date(SUBSTR( p_record_data, 94, 8), 'YYYYMMDD');

272: p_ytd_disb_row.disb_ref_num := SUBSTR( p_record_data, 39, 2);
273: p_ytd_disb_row.disb_accpt_amt := TO_NUMBER(SUBSTR( p_record_data, 41, 7))/100;
274: p_ytd_disb_row.db_cr_flag := SUBSTR( p_record_data, 48, 1);
275: p_ytd_disb_row.disb_dt := fnd_date.string_to_date(SUBSTR( p_record_data, 49, 8), 'YYYYMMDD');
276: p_ytd_disb_row.pymt_prd_start_dt := fnd_date.string_to_date(SUBSTR( p_record_data, 94, 8), 'YYYYMMDD');
277: p_ytd_disb_row.disb_batch_id := SUBSTR( p_record_data, 139, 26);
278:
279: END IF;
280:

Line 294: p_ytd_disb_row.disb_dt := fnd_date.string_to_date(SUBSTR( p_record_data, 49, 8), 'YYYYMMDD');

290: p_ytd_disb_row.action_code := SUBSTR( p_record_data, 38, 1);
291: p_ytd_disb_row.disb_ref_num := SUBSTR( p_record_data, 39, 2);
292: p_ytd_disb_row.disb_accpt_amt := TO_NUMBER(SUBSTR( p_record_data, 41, 7))/100;
293: p_ytd_disb_row.db_cr_flag := SUBSTR( p_record_data, 48, 1);
294: p_ytd_disb_row.disb_dt := fnd_date.string_to_date(SUBSTR( p_record_data, 49, 8), 'YYYYMMDD');
295: p_ytd_disb_row.pymt_prd_start_dt := fnd_date.string_to_date(SUBSTR( p_record_data, 58, 8), 'YYYYMMDD');
296: p_ytd_disb_row.disb_batch_id := SUBSTR( p_record_data, 104, 26);
297: p_ytd_disb_row.disb_process_date := fnd_date.string_to_date(SUBSTR(p_record_data, 130, 8), 'YYYYMMDD');
298: p_ytd_disb_row.routing_id_txt := SUBSTR(p_record_data, 138, 8);

Line 295: p_ytd_disb_row.pymt_prd_start_dt := fnd_date.string_to_date(SUBSTR( p_record_data, 58, 8), 'YYYYMMDD');

291: p_ytd_disb_row.disb_ref_num := SUBSTR( p_record_data, 39, 2);
292: p_ytd_disb_row.disb_accpt_amt := TO_NUMBER(SUBSTR( p_record_data, 41, 7))/100;
293: p_ytd_disb_row.db_cr_flag := SUBSTR( p_record_data, 48, 1);
294: p_ytd_disb_row.disb_dt := fnd_date.string_to_date(SUBSTR( p_record_data, 49, 8), 'YYYYMMDD');
295: p_ytd_disb_row.pymt_prd_start_dt := fnd_date.string_to_date(SUBSTR( p_record_data, 58, 8), 'YYYYMMDD');
296: p_ytd_disb_row.disb_batch_id := SUBSTR( p_record_data, 104, 26);
297: p_ytd_disb_row.disb_process_date := fnd_date.string_to_date(SUBSTR(p_record_data, 130, 8), 'YYYYMMDD');
298: p_ytd_disb_row.routing_id_txt := SUBSTR(p_record_data, 138, 8);
299: p_ytd_disb_row.fin_award_year_num := TO_NUMBER(SUBSTR(p_record_data, 146, 4));

Line 297: p_ytd_disb_row.disb_process_date := fnd_date.string_to_date(SUBSTR(p_record_data, 130, 8), 'YYYYMMDD');

293: p_ytd_disb_row.db_cr_flag := SUBSTR( p_record_data, 48, 1);
294: p_ytd_disb_row.disb_dt := fnd_date.string_to_date(SUBSTR( p_record_data, 49, 8), 'YYYYMMDD');
295: p_ytd_disb_row.pymt_prd_start_dt := fnd_date.string_to_date(SUBSTR( p_record_data, 58, 8), 'YYYYMMDD');
296: p_ytd_disb_row.disb_batch_id := SUBSTR( p_record_data, 104, 26);
297: p_ytd_disb_row.disb_process_date := fnd_date.string_to_date(SUBSTR(p_record_data, 130, 8), 'YYYYMMDD');
298: p_ytd_disb_row.routing_id_txt := SUBSTR(p_record_data, 138, 8);
299: p_ytd_disb_row.fin_award_year_num := TO_NUMBER(SUBSTR(p_record_data, 146, 4));
300: p_ytd_disb_row.attend_entity_id_txt := SUBSTR(p_record_data, 150, 6);
301: p_ytd_disb_row.student_name := SUBSTR(p_record_data, 156, 29);

Line 303: p_ytd_disb_row.student_birth_date := fnd_date.string_to_date(SUBSTR(p_record_data, 194, 8), 'YYYYMMDD');

299: p_ytd_disb_row.fin_award_year_num := TO_NUMBER(SUBSTR(p_record_data, 146, 4));
300: p_ytd_disb_row.attend_entity_id_txt := SUBSTR(p_record_data, 150, 6);
301: p_ytd_disb_row.student_name := SUBSTR(p_record_data, 156, 29);
302: p_ytd_disb_row.current_ssn_txt := SUBSTR(p_record_data, 185, 9);
303: p_ytd_disb_row.student_birth_date := fnd_date.string_to_date(SUBSTR(p_record_data, 194, 8), 'YYYYMMDD');
304: p_ytd_disb_row.disb_seq_num := TO_NUMBER(SUBSTR(p_record_data, 202, 2));
305: p_ytd_disb_row.disb_rel_ind := SUBSTR(p_record_data, 204, 1);
306: p_ytd_disb_row.prev_disb_seq_num := TO_NUMBER(SUBSTR(p_record_data, 205, 2));
307: