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_ORIG_ACK dependencies on IGF_LOOKUPS_VIEW

Line 75: l_dl_version igf_lookups_view.lookup_code%TYPE;

71:
72:
73: l_rowid VARCHAR2(25);
74: l_dbth_id igf_sl_dl_batch.dbth_id%TYPE;
75: l_dl_version igf_lookups_view.lookup_code%TYPE;
76: l_dl_file_type igf_sl_dl_file_type.dl_file_type%TYPE;
77: l_dl_loan_catg igf_sl_dl_file_type.dl_loan_catg%TYPE;
78: x_ddrp_id igf_db_dl_disb_resp.ddrp_id%TYPE;
79: -- ## Cursor for formulating the header

Line 330: l_loan_number_desc igf_lookups_view.meaning%TYPE;

326: l_mesg_str1 VARCHAR2(4000); -- ## String to put in the log file
327: l_mesg_str2 VARCHAR2(4000); -- ## String to put in the log file
328: l_mesg_str3 VARCHAR2(4000); -- ## String to put in the log file
329:
330: l_loan_number_desc igf_lookups_view.meaning%TYPE;
331: l_disb_num_desc igf_lookups_view.meaning%TYPE;
332: l_disb_seq_num_desc igf_lookups_view.meaning%TYPE;
333: l_disb_gross_amt_desc igf_lookups_view.meaning%TYPE;
334: l_disb_net_amt_desc igf_lookups_view.meaning%TYPE;

Line 331: l_disb_num_desc igf_lookups_view.meaning%TYPE;

327: l_mesg_str2 VARCHAR2(4000); -- ## String to put in the log file
328: l_mesg_str3 VARCHAR2(4000); -- ## String to put in the log file
329:
330: l_loan_number_desc igf_lookups_view.meaning%TYPE;
331: l_disb_num_desc igf_lookups_view.meaning%TYPE;
332: l_disb_seq_num_desc igf_lookups_view.meaning%TYPE;
333: l_disb_gross_amt_desc igf_lookups_view.meaning%TYPE;
334: l_disb_net_amt_desc igf_lookups_view.meaning%TYPE;
335: l_int_rebate_amt_desc igf_lookups_view.meaning%TYPE;

Line 332: l_disb_seq_num_desc igf_lookups_view.meaning%TYPE;

328: l_mesg_str3 VARCHAR2(4000); -- ## String to put in the log file
329:
330: l_loan_number_desc igf_lookups_view.meaning%TYPE;
331: l_disb_num_desc igf_lookups_view.meaning%TYPE;
332: l_disb_seq_num_desc igf_lookups_view.meaning%TYPE;
333: l_disb_gross_amt_desc igf_lookups_view.meaning%TYPE;
334: l_disb_net_amt_desc igf_lookups_view.meaning%TYPE;
335: l_int_rebate_amt_desc igf_lookups_view.meaning%TYPE;
336: l_fee_1_desc igf_lookups_view.meaning%TYPE;

Line 333: l_disb_gross_amt_desc igf_lookups_view.meaning%TYPE;

329:
330: l_loan_number_desc igf_lookups_view.meaning%TYPE;
331: l_disb_num_desc igf_lookups_view.meaning%TYPE;
332: l_disb_seq_num_desc igf_lookups_view.meaning%TYPE;
333: l_disb_gross_amt_desc igf_lookups_view.meaning%TYPE;
334: l_disb_net_amt_desc igf_lookups_view.meaning%TYPE;
335: l_int_rebate_amt_desc igf_lookups_view.meaning%TYPE;
336: l_fee_1_desc igf_lookups_view.meaning%TYPE;
337: l_sch_code_status_desc igf_lookups_view.meaning%TYPE;

Line 334: l_disb_net_amt_desc igf_lookups_view.meaning%TYPE;

330: l_loan_number_desc igf_lookups_view.meaning%TYPE;
331: l_disb_num_desc igf_lookups_view.meaning%TYPE;
332: l_disb_seq_num_desc igf_lookups_view.meaning%TYPE;
333: l_disb_gross_amt_desc igf_lookups_view.meaning%TYPE;
334: l_disb_net_amt_desc igf_lookups_view.meaning%TYPE;
335: l_int_rebate_amt_desc igf_lookups_view.meaning%TYPE;
336: l_fee_1_desc igf_lookups_view.meaning%TYPE;
337: l_sch_code_status_desc igf_lookups_view.meaning%TYPE;
338: l_loan_num_status_desc igf_lookups_view.meaning%TYPE;

Line 335: l_int_rebate_amt_desc igf_lookups_view.meaning%TYPE;

331: l_disb_num_desc igf_lookups_view.meaning%TYPE;
332: l_disb_seq_num_desc igf_lookups_view.meaning%TYPE;
333: l_disb_gross_amt_desc igf_lookups_view.meaning%TYPE;
334: l_disb_net_amt_desc igf_lookups_view.meaning%TYPE;
335: l_int_rebate_amt_desc igf_lookups_view.meaning%TYPE;
336: l_fee_1_desc igf_lookups_view.meaning%TYPE;
337: l_sch_code_status_desc igf_lookups_view.meaning%TYPE;
338: l_loan_num_status_desc igf_lookups_view.meaning%TYPE;
339: l_disb_num_status_desc igf_lookups_view.meaning%TYPE;

Line 336: l_fee_1_desc igf_lookups_view.meaning%TYPE;

332: l_disb_seq_num_desc igf_lookups_view.meaning%TYPE;
333: l_disb_gross_amt_desc igf_lookups_view.meaning%TYPE;
334: l_disb_net_amt_desc igf_lookups_view.meaning%TYPE;
335: l_int_rebate_amt_desc igf_lookups_view.meaning%TYPE;
336: l_fee_1_desc igf_lookups_view.meaning%TYPE;
337: l_sch_code_status_desc igf_lookups_view.meaning%TYPE;
338: l_loan_num_status_desc igf_lookups_view.meaning%TYPE;
339: l_disb_num_status_desc igf_lookups_view.meaning%TYPE;
340: l_disb_seq_num_status_desc igf_lookups_view.meaning%TYPE;

Line 337: l_sch_code_status_desc igf_lookups_view.meaning%TYPE;

333: l_disb_gross_amt_desc igf_lookups_view.meaning%TYPE;
334: l_disb_net_amt_desc igf_lookups_view.meaning%TYPE;
335: l_int_rebate_amt_desc igf_lookups_view.meaning%TYPE;
336: l_fee_1_desc igf_lookups_view.meaning%TYPE;
337: l_sch_code_status_desc igf_lookups_view.meaning%TYPE;
338: l_loan_num_status_desc igf_lookups_view.meaning%TYPE;
339: l_disb_num_status_desc igf_lookups_view.meaning%TYPE;
340: l_disb_seq_num_status_desc igf_lookups_view.meaning%TYPE;
341: l_disb_date_desc igf_lookups_view.meaning%TYPE;

Line 338: l_loan_num_status_desc igf_lookups_view.meaning%TYPE;

334: l_disb_net_amt_desc igf_lookups_view.meaning%TYPE;
335: l_int_rebate_amt_desc igf_lookups_view.meaning%TYPE;
336: l_fee_1_desc igf_lookups_view.meaning%TYPE;
337: l_sch_code_status_desc igf_lookups_view.meaning%TYPE;
338: l_loan_num_status_desc igf_lookups_view.meaning%TYPE;
339: l_disb_num_status_desc igf_lookups_view.meaning%TYPE;
340: l_disb_seq_num_status_desc igf_lookups_view.meaning%TYPE;
341: l_disb_date_desc igf_lookups_view.meaning%TYPE;
342:

Line 339: l_disb_num_status_desc igf_lookups_view.meaning%TYPE;

335: l_int_rebate_amt_desc igf_lookups_view.meaning%TYPE;
336: l_fee_1_desc igf_lookups_view.meaning%TYPE;
337: l_sch_code_status_desc igf_lookups_view.meaning%TYPE;
338: l_loan_num_status_desc igf_lookups_view.meaning%TYPE;
339: l_disb_num_status_desc igf_lookups_view.meaning%TYPE;
340: l_disb_seq_num_status_desc igf_lookups_view.meaning%TYPE;
341: l_disb_date_desc igf_lookups_view.meaning%TYPE;
342:
343: -- ## Cursor to get the Disbursement Details to Process the acknowlegement Process

Line 340: l_disb_seq_num_status_desc igf_lookups_view.meaning%TYPE;

336: l_fee_1_desc igf_lookups_view.meaning%TYPE;
337: l_sch_code_status_desc igf_lookups_view.meaning%TYPE;
338: l_loan_num_status_desc igf_lookups_view.meaning%TYPE;
339: l_disb_num_status_desc igf_lookups_view.meaning%TYPE;
340: l_disb_seq_num_status_desc igf_lookups_view.meaning%TYPE;
341: l_disb_date_desc igf_lookups_view.meaning%TYPE;
342:
343: -- ## Cursor to get the Disbursement Details to Process the acknowlegement Process
344:

Line 341: l_disb_date_desc igf_lookups_view.meaning%TYPE;

337: l_sch_code_status_desc igf_lookups_view.meaning%TYPE;
338: l_loan_num_status_desc igf_lookups_view.meaning%TYPE;
339: l_disb_num_status_desc igf_lookups_view.meaning%TYPE;
340: l_disb_seq_num_status_desc igf_lookups_view.meaning%TYPE;
341: l_disb_date_desc igf_lookups_view.meaning%TYPE;
342:
343: -- ## Cursor to get the Disbursement Details to Process the acknowlegement Process
344:
345: CURSOR cur_db_resp(l_dbth_id igf_sl_dl_batch.dbth_id%TYPE)