APPS.IGF_SL_DL_ORIG_ACK dependencies on IGF_SL_DL_BATCH

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

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

Line 150: l_dbth_id igf_sl_dl_batch.dbth_id%TYPE;

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

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

302:
303: IF l_rec_batch_rej_code IS NOT NULL THEN
304: fnd_message.set_name('IGF','IGF_GE_BATCH_REJECTED');
305: fnd_message.set_token('BATCH', l_rec_batch_id);
306: fnd_message.set_token('REASON', igf_aw_gen.lookup_desc('IGF_SL_DL_BATCH_REJ',l_rec_batch_rej_code));
307: fnd_file.put_line(fnd_file.log,fnd_message.get);
308: RAISE file_not_loaded;
309: END IF;
310:

Line 313: igf_sl_dl_batch_pkg.insert_row (

309: END IF;
310:
311:
312: l_rowid := NULL;
313: igf_sl_dl_batch_pkg.insert_row (
314: x_mode => 'R',
315: x_rowid => l_rowid,
316: x_dbth_id => l_dbth_id,
317: x_batch_id => l_rec_batch_id,

Line 509: l_dbth_id igf_sl_dl_batch.dbth_id%TYPE;

505:
506: (reverse chronological order - newest change first)
507: ***************************************************************/
508:
509: l_dbth_id igf_sl_dl_batch.dbth_id%TYPE;
510: l_batch_type igf_sl_dl_batch.batch_type%TYPE;
511: l_rec_present VARCHAR2(10);
512: l_rec_updated VARCHAR2(10);
513: l_stat VARCHAR2(30);

Line 510: l_batch_type igf_sl_dl_batch.batch_type%TYPE;

506: (reverse chronological order - newest change first)
507: ***************************************************************/
508:
509: l_dbth_id igf_sl_dl_batch.dbth_id%TYPE;
510: l_batch_type igf_sl_dl_batch.batch_type%TYPE;
511: l_rec_present VARCHAR2(10);
512: l_rec_updated VARCHAR2(10);
513: l_stat VARCHAR2(30);
514:

Line 520: SELECT igf_sl_dl_batch.*

516: l_dl_loan_catg igf_sl_dl_file_type.dl_loan_catg%TYPE;
517:
518: CURSOR cur_batch
519: IS
520: SELECT igf_sl_dl_batch.*
521: FROM igf_sl_dl_batch
522: WHERE dbth_id = l_dbth_id
523: AND status = 'N';
524:

Line 521: FROM igf_sl_dl_batch

517:
518: CURSOR cur_batch
519: IS
520: SELECT igf_sl_dl_batch.*
521: FROM igf_sl_dl_batch
522: WHERE dbth_id = l_dbth_id
523: AND status = 'N';
524:
525: CURSOR cur_lor_resp(l_dbth_id igf_sl_dl_batch.dbth_id%TYPE)

Line 525: CURSOR cur_lor_resp(l_dbth_id igf_sl_dl_batch.dbth_id%TYPE)

521: FROM igf_sl_dl_batch
522: WHERE dbth_id = l_dbth_id
523: AND status = 'N';
524:
525: CURSOR cur_lor_resp(l_dbth_id igf_sl_dl_batch.dbth_id%TYPE)
526: IS
527: SELECT igf_sl_dl_lor_resp.*
528: FROM igf_sl_dl_lor_resp
529: WHERE dbth_id = l_dbth_id

Line 532: CURSOR cur_lor_crresp(l_dbth_id igf_sl_dl_batch.dbth_id%TYPE)

528: FROM igf_sl_dl_lor_resp
529: WHERE dbth_id = l_dbth_id
530: AND status = 'N';
531:
532: CURSOR cur_lor_crresp(l_dbth_id igf_sl_dl_batch.dbth_id%TYPE)
533: IS
534: SELECT igf_sl_dl_lor_crresp.*
535: FROM igf_sl_dl_lor_crresp
536: WHERE dbth_id = l_dbth_id

Line 738: igf_sl_dl_batch_pkg.update_row (

734:
735: END IF; -- End of Condition for l_dl_loan_catg
736:
737: -- Update the DL_BATCH record as Successfully Uploaded.
738: igf_sl_dl_batch_pkg.update_row (
739: x_mode => 'R',
740: x_rowid => dbth_rec.row_id,
741: x_dbth_id => dbth_rec.dbth_id,
742: x_batch_id => dbth_rec.batch_id,