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_SL_DL_FILE_TYPE

Line 37: p_dl_version OUT NOCOPY igf_sl_dl_file_type.dl_version%TYPE,

33: -- Before loading, it does lot of checks to ensure it is the right file
34: -- and returns the dbth_id, for further processing.
35: PROCEDURE disb_load_data(p_dbth_id OUT NOCOPY igf_sl_dl_batch.dbth_id%TYPE,
36: p_batch_id OUT NOCOPY igf_sl_dl_batch.batch_id%TYPE,
37: p_dl_version OUT NOCOPY igf_sl_dl_file_type.dl_version%TYPE,
38: p_dl_file_type OUT NOCOPY igf_sl_dl_file_type.dl_loan_catg%TYPE)
39: AS
40: /*************************************************************
41: Created By : Prajeesh Chandran .K

Line 38: p_dl_file_type OUT NOCOPY igf_sl_dl_file_type.dl_loan_catg%TYPE)

34: -- and returns the dbth_id, for further processing.
35: PROCEDURE disb_load_data(p_dbth_id OUT NOCOPY igf_sl_dl_batch.dbth_id%TYPE,
36: p_batch_id OUT NOCOPY igf_sl_dl_batch.batch_id%TYPE,
37: p_dl_version OUT NOCOPY igf_sl_dl_file_type.dl_version%TYPE,
38: p_dl_file_type OUT NOCOPY igf_sl_dl_file_type.dl_loan_catg%TYPE)
39: AS
40: /*************************************************************
41: Created By : Prajeesh Chandran .K
42: Date Created On : 2000/12/20

Line 76: l_dl_file_type igf_sl_dl_file_type.dl_file_type%TYPE;

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
80:

Line 77: l_dl_loan_catg igf_sl_dl_file_type.dl_loan_catg%TYPE;

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
80:
81: CURSOR c_header

Line 320: l_dl_version igf_sl_dl_file_type.dl_version%TYPE;

316: l_batch_type igf_sl_dl_batch.batch_type%TYPE;
317: l_stat VARCHAR2(30);
318: l_batch_id igf_sl_dl_batch.batch_id%TYPE;
319:
320: l_dl_version igf_sl_dl_file_type.dl_version%TYPE;
321: l_dl_file_type igf_sl_dl_file_type.dl_file_type%TYPE;
322: l_disb_status igf_aw_db_chg_dtls.disb_status%TYPE;
323: l_disb_status_date igf_aw_db_chg_dtls.disb_status_date%TYPE;
324: l_disb_ack_date igf_db_dl_disb_resp.ack_date%TYPE DEFAULT NULL;

Line 321: l_dl_file_type igf_sl_dl_file_type.dl_file_type%TYPE;

317: l_stat VARCHAR2(30);
318: l_batch_id igf_sl_dl_batch.batch_id%TYPE;
319:
320: l_dl_version igf_sl_dl_file_type.dl_version%TYPE;
321: l_dl_file_type igf_sl_dl_file_type.dl_file_type%TYPE;
322: l_disb_status igf_aw_db_chg_dtls.disb_status%TYPE;
323: l_disb_status_date igf_aw_db_chg_dtls.disb_status_date%TYPE;
324: l_disb_ack_date igf_db_dl_disb_resp.ack_date%TYPE DEFAULT NULL;
325: