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_SL_CL_ORIG_ACK dependencies on IGF_SL_LOAD_FILE_T

Line 177: Format_1_rec igf_sl_load_file_t%ROWTYPE;

173: ORDER BY clrp1.clrp1_id
174: FOR UPDATE OF resp_record_status NOWAIT;
175:
176:
177: Format_1_rec igf_sl_load_file_t%ROWTYPE;
178: Format_1_rec_temp igf_sl_load_file_t%ROWTYPE;
179: loaded_1rec cur_resp1_records%ROWTYPE;
180: g_cbth_id igf_sl_cl_batch_all.cbth_id%TYPE;
181: l_loan_number igf_sl_loans_all.loan_number%TYPE;

Line 178: Format_1_rec_temp igf_sl_load_file_t%ROWTYPE;

174: FOR UPDATE OF resp_record_status NOWAIT;
175:
176:
177: Format_1_rec igf_sl_load_file_t%ROWTYPE;
178: Format_1_rec_temp igf_sl_load_file_t%ROWTYPE;
179: loaded_1rec cur_resp1_records%ROWTYPE;
180: g_cbth_id igf_sl_cl_batch_all.cbth_id%TYPE;
181: l_loan_number igf_sl_loans_all.loan_number%TYPE;
182: p_disb_title VARCHAR2(1000);

Line 217: p_r4_record igf_sl_load_file_t.record_data%TYPE);

213: -- Declaration of a Procedure for inserting the @4 Records as per New DLD
214: --
215:
216: PROCEDURE insert_into_resp_r4(p_clrp1_id igf_sl_cl_resp_r1_all.clrp1_id%TYPE,
217: p_r4_record igf_sl_load_file_t.record_data%TYPE);
218:
219: --
220: -- Procedure to show the difference in information bet OFA and File Details
221: --

Line 318: Header_rec igf_sl_load_file_t%ROWTYPE;

314: ***************************************************************/
315:
316:
317: l_row_id VARCHAR2(25);
318: Header_rec igf_sl_load_file_t%ROWTYPE;
319: l_trailer VARCHAR2(2);
320: l_log_msg VARCHAR2(100);
321: l_file_creation_date DATE;
322: l_file_trans_date DATE;

Line 333: CURSOR cur_Hrecord ( p_file_type igf_sl_load_file_t.file_type%TYPE,

329: -- which is being obsoleted.
330:
331: -- To Fetch the @H records from Load file Table
332:
333: CURSOR cur_Hrecord ( p_file_type igf_sl_load_file_t.file_type%TYPE,
334: p_record_data igf_sl_load_file_t.record_data%TYPE)
335: IS
336: SELECT * FROM igf_sl_load_file_t
337: WHERE file_type = p_file_type

Line 334: p_record_data igf_sl_load_file_t.record_data%TYPE)

330:
331: -- To Fetch the @H records from Load file Table
332:
333: CURSOR cur_Hrecord ( p_file_type igf_sl_load_file_t.file_type%TYPE,
334: p_record_data igf_sl_load_file_t.record_data%TYPE)
335: IS
336: SELECT * FROM igf_sl_load_file_t
337: WHERE file_type = p_file_type
338: AND LTRIM(RTRIM(SUBSTR(record_data,1,2))) = p_record_data

Line 336: SELECT * FROM igf_sl_load_file_t

332:
333: CURSOR cur_Hrecord ( p_file_type igf_sl_load_file_t.file_type%TYPE,
334: p_record_data igf_sl_load_file_t.record_data%TYPE)
335: IS
336: SELECT * FROM igf_sl_load_file_t
337: WHERE file_type = p_file_type
338: AND LTRIM(RTRIM(SUBSTR(record_data,1,2))) = p_record_data
339: AND lort_id = 1
340: ORDER By lort_id;

Line 344: CURSOR cur_Trecord ( p_file_type igf_sl_load_file_t.file_type%TYPE,

340: ORDER By lort_id;
341:
342: -- To Fetch the Trailer Record from Load File Table
343:
344: CURSOR cur_Trecord ( p_file_type igf_sl_load_file_t.file_type%TYPE,
345: p_record_data igf_sl_load_file_t.record_data%TYPE)
346: IS
347: SELECT 'x' FROM igf_sl_load_file_t
348: WHERE lort_id = (SELECT MAX(lort_id) FROM igf_sl_load_file_t

Line 345: p_record_data igf_sl_load_file_t.record_data%TYPE)

341:
342: -- To Fetch the Trailer Record from Load File Table
343:
344: CURSOR cur_Trecord ( p_file_type igf_sl_load_file_t.file_type%TYPE,
345: p_record_data igf_sl_load_file_t.record_data%TYPE)
346: IS
347: SELECT 'x' FROM igf_sl_load_file_t
348: WHERE lort_id = (SELECT MAX(lort_id) FROM igf_sl_load_file_t
349: WHERE file_type = p_file_type)

Line 347: SELECT 'x' FROM igf_sl_load_file_t

343:
344: CURSOR cur_Trecord ( p_file_type igf_sl_load_file_t.file_type%TYPE,
345: p_record_data igf_sl_load_file_t.record_data%TYPE)
346: IS
347: SELECT 'x' FROM igf_sl_load_file_t
348: WHERE lort_id = (SELECT MAX(lort_id) FROM igf_sl_load_file_t
349: WHERE file_type = p_file_type)
350: AND file_type = p_file_type
351: AND SUBSTR(record_data,1,2) = p_record_data ;

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

344: CURSOR cur_Trecord ( p_file_type igf_sl_load_file_t.file_type%TYPE,
345: p_record_data igf_sl_load_file_t.record_data%TYPE)
346: IS
347: SELECT 'x' FROM igf_sl_load_file_t
348: WHERE lort_id = (SELECT MAX(lort_id) FROM igf_sl_load_file_t
349: WHERE file_type = p_file_type)
350: AND file_type = p_file_type
351: AND SUBSTR(record_data,1,2) = p_record_data ;
352:

Line 574: CURSOR cur_1records (p_file_type igf_sl_load_file_t.file_type%TYPE,

570: l_loan_active igf_sl_loans_all.active%TYPE;
571: l_resp_record_status igf_sl_cl_resp_r1_all.resp_record_status%TYPE;
572:
573: -- To select all the @1 Records from the Load Table
574: CURSOR cur_1records (p_file_type igf_sl_load_file_t.file_type%TYPE,
575: p_record_data igf_sl_load_file_t.record_data%TYPE)
576: IS
577: SELECT * FROM igf_sl_load_file_t
578: WHERE SUBSTR(record_data,1,2)= p_record_data

Line 575: p_record_data igf_sl_load_file_t.record_data%TYPE)

571: l_resp_record_status igf_sl_cl_resp_r1_all.resp_record_status%TYPE;
572:
573: -- To select all the @1 Records from the Load Table
574: CURSOR cur_1records (p_file_type igf_sl_load_file_t.file_type%TYPE,
575: p_record_data igf_sl_load_file_t.record_data%TYPE)
576: IS
577: SELECT * FROM igf_sl_load_file_t
578: WHERE SUBSTR(record_data,1,2)= p_record_data
579: AND file_type= p_file_type

Line 577: SELECT * FROM igf_sl_load_file_t

573: -- To select all the @1 Records from the Load Table
574: CURSOR cur_1records (p_file_type igf_sl_load_file_t.file_type%TYPE,
575: p_record_data igf_sl_load_file_t.record_data%TYPE)
576: IS
577: SELECT * FROM igf_sl_load_file_t
578: WHERE SUBSTR(record_data,1,2)= p_record_data
579: AND file_type= p_file_type
580: ORDER BY lort_id;
581:

Line 1183: CURSOR cur_other_records ( p_file_type igf_sl_load_file_t.file_type%TYPE)

1179:
1180:
1181: --Select all the Records which are not @1 Records but @8 Records.
1182:
1183: CURSOR cur_other_records ( p_file_type igf_sl_load_file_t.file_type%TYPE)
1184: IS
1185: SELECT * FROM igf_sl_load_file_t
1186: WHERE file_type = p_file_type
1187: AND lort_id > Format_1_rec.lort_id;

Line 1185: SELECT * FROM igf_sl_load_file_t

1181: --Select all the Records which are not @1 Records but @8 Records.
1182:
1183: CURSOR cur_other_records ( p_file_type igf_sl_load_file_t.file_type%TYPE)
1184: IS
1185: SELECT * FROM igf_sl_load_file_t
1186: WHERE file_type = p_file_type
1187: AND lort_id > Format_1_rec.lort_id;
1188:
1189: TYPE r8_rec_type IS RECORD (

Line 3974: p_r4_record igf_sl_load_file_t.record_data%TYPE)

3970:
3971: --Procedure Definition for Inserting into igf_sl_resp_r4 w.r.to new DLD
3972:
3973: PROCEDURE insert_into_resp_r4(p_clrp1_id igf_sl_cl_resp_r1_all.clrp1_id%TYPE,
3974: p_r4_record igf_sl_load_file_t.record_data%TYPE)
3975:
3976: /***************************************************************
3977: Created By : mesriniv
3978: Date Created By : 2001/05/13