APPS.IGF_DB_DL_ORIG_ACK dependencies on IGF_SL_DL_BATCH

Line 35: PROCEDURE disb_load_data(p_dbth_id OUT NOCOPY igf_sl_dl_batch.dbth_id%TYPE,

31:
32: -- Procedure to Load the Data from the Data File into the Interface tables.
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

Line 36: p_batch_id OUT NOCOPY igf_sl_dl_batch.batch_id%TYPE,

32: -- Procedure to Load the Data from the Data File into the Interface tables.
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: /*************************************************************

Line 74: l_dbth_id igf_sl_dl_batch.dbth_id%TYPE;

70: l_rec_batch_type VARCHAR2(100);
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;

Line 179: fnd_message.set_token('REASON', igf_aw_gen.lookup_desc('IGF_SL_DL_BATCH_REJ',l_rec_batch_rej_code));

175:
176: IF l_rec_batch_rej_code IS NOT NULL THEN
177: fnd_message.set_name('IGF','IGF_GE_BATCH_REJECTED');
178: fnd_message.set_token('BATCH', l_rec_batch_id);
179: fnd_message.set_token('REASON', igf_aw_gen.lookup_desc('IGF_SL_DL_BATCH_REJ',l_rec_batch_rej_code));
180: igs_ge_msg_stack.add;
181: RAISE FILE_NOT_LOADED;
182: -- Message : Batch #BATCH was rejected. Reason : #REASON.
183:

Line 188: igf_sl_dl_batch_pkg.insert_row (

184: END IF;
185:
186:
187: l_rowid := NULL;
188: igf_sl_dl_batch_pkg.insert_row (
189: x_mode => 'R',
190: x_rowid => l_rowid,
191: x_dbth_id => l_dbth_id,
192: x_batch_id => l_rec_batch_id,

Line 315: l_dbth_id igf_sl_dl_batch.dbth_id%TYPE; -- ## Variable for the batch ID

311: Removed if condition IF lcur_awdisb.booking_batch_id IS NOT NULL THEN.
312: ridas 31-Jan-2006 Bug #4951401. Added procedure igf_aw_gen.set_org_id()
313: ***************************************************************/
314:
315: l_dbth_id igf_sl_dl_batch.dbth_id%TYPE; -- ## Variable for the batch ID
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:

Line 316: l_batch_type igf_sl_dl_batch.batch_type%TYPE;

312: ridas 31-Jan-2006 Bug #4951401. Added procedure igf_aw_gen.set_org_id()
313: ***************************************************************/
314:
315: l_dbth_id igf_sl_dl_batch.dbth_id%TYPE; -- ## Variable for the batch ID
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;

Line 318: l_batch_id igf_sl_dl_batch.batch_id%TYPE;

314:
315: l_dbth_id igf_sl_dl_batch.dbth_id%TYPE; -- ## Variable for the batch ID
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;

Line 345: CURSOR cur_db_resp(l_dbth_id igf_sl_dl_batch.dbth_id%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)
346: IS
347: SELECT *
348: FROM igf_db_dl_disb_resp
349: WHERE dbth_id = l_dbth_id