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 IGF_SL_LOAD_FILE_T

Line 21: FUNCTION valid_header ( p_c_file_type IN igf_sl_load_file_t.file_type%TYPE, p_c_batch_id OUT NOCOPY igf_sl_dl_batch.batch_id%TYPE,

17: INV_HDR_OR_TLR EXCEPTION;
18: INVALID_FILE EXCEPTION;
19: INV_TRL_NUM EXCEPTION;
20:
21: FUNCTION valid_header ( p_c_file_type IN igf_sl_load_file_t.file_type%TYPE, p_c_batch_id OUT NOCOPY igf_sl_dl_batch.batch_id%TYPE,
22: p_c_message_class OUT NOCOPY igf_sl_dl_batch.message_class%TYPE, p_d_bth_creation_date OUT NOCOPY igf_sl_dl_batch.bth_creation_date%TYPE,
23: p_c_rej_code OUT NOCOPY igf_sl_dl_batch.batch_rej_code%TYPE, p_c_batch_type OUT NOCOPY igf_sl_dl_batch.batch_type%TYPE) RETURN BOOLEAN;
24:
25: FUNCTION valid_trailer ( p_c_file_type IN igf_sl_load_file_t.file_type%TYPE, p_n_last_lort_id OUT NOCOPY NUMBER ,

Line 25: FUNCTION valid_trailer ( p_c_file_type IN igf_sl_load_file_t.file_type%TYPE, p_n_last_lort_id OUT NOCOPY NUMBER ,

21: FUNCTION valid_header ( p_c_file_type IN igf_sl_load_file_t.file_type%TYPE, p_c_batch_id OUT NOCOPY igf_sl_dl_batch.batch_id%TYPE,
22: p_c_message_class OUT NOCOPY igf_sl_dl_batch.message_class%TYPE, p_d_bth_creation_date OUT NOCOPY igf_sl_dl_batch.bth_creation_date%TYPE,
23: p_c_rej_code OUT NOCOPY igf_sl_dl_batch.batch_rej_code%TYPE, p_c_batch_type OUT NOCOPY igf_sl_dl_batch.batch_type%TYPE) RETURN BOOLEAN;
24:
25: FUNCTION valid_trailer ( p_c_file_type IN igf_sl_load_file_t.file_type%TYPE, p_n_last_lort_id OUT NOCOPY NUMBER ,
26: p_n_rec_num OUT NOCOPY NUMBER, p_n_rec_accept OUT NOCOPY NUMBER,
27: p_n_rec_reject OUT NOCOPY NUMBER, p_n_rec_pending OUT NOCOPY NUMBER) RETURN BOOLEAN ;
28:
29: FUNCTION valid_header ( p_c_file_type IN igf_sl_load_file_t.file_type%TYPE, p_c_batch_id OUT NOCOPY igf_sl_dl_batch.batch_id%TYPE,

Line 29: FUNCTION valid_header ( p_c_file_type IN igf_sl_load_file_t.file_type%TYPE, p_c_batch_id OUT NOCOPY igf_sl_dl_batch.batch_id%TYPE,

25: FUNCTION valid_trailer ( p_c_file_type IN igf_sl_load_file_t.file_type%TYPE, p_n_last_lort_id OUT NOCOPY NUMBER ,
26: p_n_rec_num OUT NOCOPY NUMBER, p_n_rec_accept OUT NOCOPY NUMBER,
27: p_n_rec_reject OUT NOCOPY NUMBER, p_n_rec_pending OUT NOCOPY NUMBER) RETURN BOOLEAN ;
28:
29: FUNCTION valid_header ( p_c_file_type IN igf_sl_load_file_t.file_type%TYPE, p_c_batch_id OUT NOCOPY igf_sl_dl_batch.batch_id%TYPE,
30: p_c_message_class OUT NOCOPY igf_sl_dl_batch.message_class%TYPE, p_d_bth_creation_date OUT NOCOPY igf_sl_dl_batch.bth_creation_date%TYPE,
31: p_c_rej_code OUT NOCOPY igf_sl_dl_batch.batch_rej_code%TYPE, p_c_batch_type OUT NOCOPY igf_sl_dl_batch.batch_type%TYPE) RETURN BOOLEAN AS
32: /***************************************************************
33: Created By : smvk

Line 41: CURSOR c_header (cp_c_file_type IN igf_sl_load_file_t.file_type%TYPE) IS

37: Change History :2154941
38: Who When What
39:
40: ***************************************************************/
41: CURSOR c_header (cp_c_file_type IN igf_sl_load_file_t.file_type%TYPE) IS
42: SELECT RTRIM(LTRIM(SUBSTR(record_data, 15, 8))) message_class,
43: RTRIM(LTRIM(SUBSTR(record_data, 23, 2))) batch_type,
44: RTRIM(LTRIM(SUBSTR(record_data, 23, 23))) batch_id,
45: to_date(SUBSTR(record_data, 46, 16),'YYYYMMDDHH24MISS') bth_creation_date,

Line 48: FROM igf_sl_load_file_t

44: RTRIM(LTRIM(SUBSTR(record_data, 23, 23))) batch_id,
45: to_date(SUBSTR(record_data, 46, 16),'YYYYMMDDHH24MISS') bth_creation_date,
46: RTRIM(LTRIM(SUBSTR(record_data, 60, 2))) batch_rej_code
47:
48: FROM igf_sl_load_file_t
49: WHERE lort_id = 1
50: AND record_data LIKE 'DL HEADER%'
51: AND file_type = cp_c_file_type;
52:

Line 72: FUNCTION valid_trailer ( p_c_file_type IN igf_sl_load_file_t.file_type%TYPE, p_n_last_lort_id OUT NOCOPY NUMBER ,

68: RETURN FALSE;
69: END IF;
70: END valid_header;
71:
72: FUNCTION valid_trailer ( p_c_file_type IN igf_sl_load_file_t.file_type%TYPE, p_n_last_lort_id OUT NOCOPY NUMBER ,
73: p_n_rec_num OUT NOCOPY NUMBER, p_n_rec_accept OUT NOCOPY NUMBER,
74: p_n_rec_reject OUT NOCOPY NUMBER, p_n_rec_pending OUT NOCOPY NUMBER) RETURN BOOLEAN AS
75:
76: /***************************************************************

Line 86: CURSOR c_trailer (cp_c_file_type IN igf_sl_load_file_t.file_type%TYPE) IS

82: Who When What
83:
84: ***************************************************************/
85:
86: CURSOR c_trailer (cp_c_file_type IN igf_sl_load_file_t.file_type%TYPE) IS
87: SELECT lort_id last_lort_id,
88: RTRIM(SUBSTR(record_data,15,7)) number_rec,
89: RTRIM(SUBSTR(record_data,22,5)) accept_rec,
90: RTRIM(SUBSTR(record_data,27,5)) reject_rec,

Line 92: FROM igf_sl_load_file_t

88: RTRIM(SUBSTR(record_data,15,7)) number_rec,
89: RTRIM(SUBSTR(record_data,22,5)) accept_rec,
90: RTRIM(SUBSTR(record_data,27,5)) reject_rec,
91: RTRIM(SUBSTR(record_data,32,5)) pending_rec
92: FROM igf_sl_load_file_t
93: WHERE lort_id = (SELECT MAX(lort_id) FROM igf_sl_load_file_t)
94: AND record_data LIKE 'DL TRAILER%'
95: AND file_type = cp_c_file_type;
96:

Line 93: WHERE lort_id = (SELECT MAX(lort_id) FROM igf_sl_load_file_t)

89: RTRIM(SUBSTR(record_data,22,5)) accept_rec,
90: RTRIM(SUBSTR(record_data,27,5)) reject_rec,
91: RTRIM(SUBSTR(record_data,32,5)) pending_rec
92: FROM igf_sl_load_file_t
93: WHERE lort_id = (SELECT MAX(lort_id) FROM igf_sl_load_file_t)
94: AND record_data LIKE 'DL TRAILER%'
95: AND file_type = cp_c_file_type;
96:
97: rec_trailer c_trailer%ROWTYPE;

Line 121: Purpose : To load the table igf_db_ytd_sum from igf_sl_load_file_t table

117: PROCEDURE load_ytd_summary(p_school_code VARCHAR2, p_award_year igf_sl_dl_setup_v.ci_alternate_code%TYPE) AS
118: /***************************************************************
119: Created By : adhawan
120: Date Created By : 22-jan-2002
121: Purpose : To load the table igf_db_ytd_sum from igf_sl_load_file_t table
122: Known Limitations,Enhancements or Remarks:
123: Change History :2154941
124: Who When What
125: ugummall 15-OCT-2003 Bug # 3102439. FA 126 Multiple FA Offices.

Line 134: SELECT record_data FROM igf_sl_load_file_t ,igf_db_ytd_smr ln

130: adhawan 22-jan-2002 Disbursements build
131: ***************************************************************/
132:
133: CURSOR c_batch IS
134: SELECT record_data FROM igf_sl_load_file_t ,igf_db_ytd_smr ln
135: WHERE file_type ='DL_YTDS' AND
136: SUBSTR(record_data,1,1)='Y' AND
137: SUBSTR(record_data,2,23) =ln.batch_id;
138: c_batch_rec c_batch%ROWTYPE;

Line 140: CURSOR c_ytd_summary(cp_c_last_lort_id igf_sl_load_file_t.lort_id%TYPE) IS

136: SUBSTR(record_data,1,1)='Y' AND
137: SUBSTR(record_data,2,23) =ln.batch_id;
138: c_batch_rec c_batch%ROWTYPE;
139:
140: CURSOR c_ytd_summary(cp_c_last_lort_id igf_sl_load_file_t.lort_id%TYPE) IS
141: SELECT record_data FROM
142: igf_sl_load_file_t
143: WHERE lort_id BETWEEN 2 AND (cp_c_last_lort_id-1)
144: AND file_type ='DL_YTDS'

Line 142: igf_sl_load_file_t

138: c_batch_rec c_batch%ROWTYPE;
139:
140: CURSOR c_ytd_summary(cp_c_last_lort_id igf_sl_load_file_t.lort_id%TYPE) IS
141: SELECT record_data FROM
142: igf_sl_load_file_t
143: WHERE lort_id BETWEEN 2 AND (cp_c_last_lort_id-1)
144: AND file_type ='DL_YTDS'
145: AND SUBSTR(record_data,1,1)='Y'
146: AND SUBSTR(record_data,25,6)=p_school_code

Line 316: Purpose : To load igf_db_ytd_dtl from igf_sl_load_file_t

312: PROCEDURE load_ytd_detail(p_school_code VARCHAR2, p_award_year igf_sl_dl_setup_v.ci_alternate_code%TYPE, p_c_dl_version igf_sl_dl_setup_v.DL_VERSION%TYPE) AS
313: /***************************************************************
314: Created By : adhawan
315: Date Created By : 22-jan-2002
316: Purpose : To load igf_db_ytd_dtl from igf_sl_load_file_t
317: Known Limitations,Enhancements or Remarks:
318: Change History :2154941
319: Who When What
320: ugummall 15-OCT-2003 Bug # 3102439. FA 126 Multiple FA Offices.

Line 331: SELECT record_data FROM igf_sl_load_file_t ,igf_db_ytd_dtl ln

327:
328: l_loaded_batch_id igf_db_ytd_dtl.batch_id%TYPE;
329: -- To ensure whether the batch is loaded , if yes then the records should not be loaded again
330: CURSOR c_batch IS
331: SELECT record_data FROM igf_sl_load_file_t ,igf_db_ytd_dtl ln
332: WHERE file_type ='DL_YTDD' AND
333: SUBSTR(record_data,1,1)='D' AND
334: SUBSTR(record_data,2,23) =ln.batch_id ;
335: c_batch_rec c_batch%ROWTYPE;

Line 338: CURSOR c_ytd_detail (cp_c_last_lort_id igf_sl_load_file_t.lort_id%TYPE) IS

334: SUBSTR(record_data,2,23) =ln.batch_id ;
335: c_batch_rec c_batch%ROWTYPE;
336:
337:
338: CURSOR c_ytd_detail (cp_c_last_lort_id igf_sl_load_file_t.lort_id%TYPE) IS
339: SELECT record_data FROM
340: igf_sl_load_file_t , igf_sl_loans_v sl
341: WHERE lort_id BETWEEN 2 AND (cp_c_last_lort_id-1)
342: AND file_type ='DL_YTDD'

Line 340: igf_sl_load_file_t , igf_sl_loans_v sl

336:
337:
338: CURSOR c_ytd_detail (cp_c_last_lort_id igf_sl_load_file_t.lort_id%TYPE) IS
339: SELECT record_data FROM
340: igf_sl_load_file_t , igf_sl_loans_v sl
341: WHERE lort_id BETWEEN 2 AND (cp_c_last_lort_id-1)
342: AND file_type ='DL_YTDD'
343: AND SUBSTR(record_data,1,1)='D'
344: AND SUBSTR(record_data,25,6)=p_school_code -- To select only those records who have a school code passed as parameter

Line 584: -- Calling the procedure to load the data from igf_sl_load_file_t to igf_db_ytd_smr table

580:
581: END IF;
582: CLOSE c_get_ver;
583:
584: -- Calling the procedure to load the data from igf_sl_load_file_t to igf_db_ytd_smr table
585: load_ytd_summary(P_SCHOOL_CODE, l_award_year);
586:
587: EXCEPTION
588: WHEN INV_TRL_NUM THEN

Line 676: -- Calling the procedure to load the data from igf_sl_load_file_t to igf_db_ytd_dtl table

672: END IF;
673:
674: CLOSE c_get_ver;
675:
676: -- Calling the procedure to load the data from igf_sl_load_file_t to igf_db_ytd_dtl table
677: load_ytd_detail(P_SCHOOL_CODE, l_award_year, c_get_ver_rec.dl_version);
678:
679: EXCEPTION
680: WHEN INV_TRL_NUM THEN