APPS.IGF_SL_DL_PNOTE_ACK dependencies on IGF_SL_DL_BATCH

Line 121: PROCEDURE dl_load_data(p_dbth_id OUT NOCOPY igf_sl_dl_batch.dbth_id%TYPE,

117: -- Procedure to Load the Data from the Data File into the Interface tables.
118: -- Before loading, it does lot of checks to ensure it is the right file
119: -- and returns the dbth_id, for further processing.
120:
121: PROCEDURE dl_load_data(p_dbth_id OUT NOCOPY igf_sl_dl_batch.dbth_id%TYPE,
122: p_dl_version OUT NOCOPY igf_sl_dl_file_type.dl_version%TYPE,
123: p_dl_loan_catg OUT NOCOPY igf_sl_dl_file_type.dl_loan_catg%TYPE)
124: AS
125: /*************************************************************

Line 153: l_dbth_id igf_sl_dl_batch.dbth_id%TYPE;

149: l_rec_batch_rej_code VARCHAR2(100);
150: l_rec_batch_type VARCHAR2(100);
151:
152: l_rowid VARCHAR2(25);
153: l_dbth_id igf_sl_dl_batch.dbth_id%TYPE;
154: l_dl_version igf_lookups_view.lookup_code%TYPE;
155: l_dl_file_type igf_sl_dl_file_type.dl_file_type%TYPE;
156: l_dl_loan_catg igf_sl_dl_file_type.dl_loan_catg%TYPE;
157:

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

273:
274: IF l_rec_batch_rej_code IS NOT NULL THEN
275: fnd_message.set_name('IGF','IGF_GE_BATCH_REJECTED');
276: fnd_message.set_token('BATCH', l_rec_batch_id);
277: fnd_message.set_token('REASON', igf_aw_gen.lookup_desc('IGF_SL_DL_BATCH_REJ',l_rec_batch_rej_code));
278: igs_ge_msg_stack.add;
279:
280: -- Message : Batch #BATCH was rejected. Reason : #REASON.
281: RAISE FILE_NOT_LOADED;

Line 286: igf_sl_dl_batch_pkg.insert_row (

282: END IF;
283:
284:
285: l_rowid := NULL;
286: igf_sl_dl_batch_pkg.insert_row (
287: x_mode => 'R',
288: x_rowid => l_rowid,
289: X_dbth_id => l_dbth_id,
290: X_batch_id => l_rec_batch_id,

Line 466: l_dbth_id igf_sl_dl_batch.dbth_id%TYPE;

462: Added Stud_sign_ind , Borr_sign_ind
463: (reverse chronological order - newest change first)
464: ***************************************************************/
465:
466: l_dbth_id igf_sl_dl_batch.dbth_id%TYPE;
467: l_batch_type igf_sl_dl_batch.batch_type%TYPE;
468: l_rec_present VARCHAR2(10);
469: l_rec_updated VARCHAR2(10);
470: l_stat VARCHAR2(30);

Line 467: l_batch_type igf_sl_dl_batch.batch_type%TYPE;

463: (reverse chronological order - newest change first)
464: ***************************************************************/
465:
466: l_dbth_id igf_sl_dl_batch.dbth_id%TYPE;
467: l_batch_type igf_sl_dl_batch.batch_type%TYPE;
468: l_rec_present VARCHAR2(10);
469: l_rec_updated VARCHAR2(10);
470: l_stat VARCHAR2(30);
471:

Line 478: SELECT igf_sl_dl_batch.* FROM igf_sl_dl_batch

474:
475: -- ## Cursor to get the batch Records
476:
477: CURSOR cur_batch IS
478: SELECT igf_sl_dl_batch.* FROM igf_sl_dl_batch
479: WHERE dbth_id = l_dbth_id;
480:
481: -- ## Cursor to Fetch the Unprocessed Records from Promissory Note
482: -- ## Table

Line 484: CURSOR cur_pnote_resp(l_dbth_id igf_sl_dl_batch.dbth_id%TYPE) IS

480:
481: -- ## Cursor to Fetch the Unprocessed Records from Promissory Note
482: -- ## Table
483:
484: CURSOR cur_pnote_resp(l_dbth_id igf_sl_dl_batch.dbth_id%TYPE) IS
485: SELECT igf_sl_dl_pnote_resp.* FROM igf_sl_dl_pnote_resp
486: WHERE dbth_id = l_dbth_id
487: AND status = 'N';
488: