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_SL_DL_CHG_ACK dependencies on IGF_SL_DL_BATCH

Line 43: PROCEDURE upd_dl_chg_resp(p_dbth_id igf_sl_dl_batch.dbth_id%TYPE,

39: NOT_PHASE_IN_PARTICIPANT exception ;
40:
41:
42: /* FORWARD DECLARATION OF PRIVATE PROCEDURES */
43: PROCEDURE upd_dl_chg_resp(p_dbth_id igf_sl_dl_batch.dbth_id%TYPE,
44: p_loan_number igf_sl_loans.loan_number%TYPE,
45: p_status igf_sl_dl_chg_resp.status%TYPE);
46:
47: PROCEDURE upd_loan_record(p_loan_number IN igf_sl_loans.loan_number%TYPE,

Line 62: PROCEDURE dl_load_data(p_dbth_id OUT NOCOPY igf_sl_dl_batch.dbth_id%TYPE)

58: -- Procedure which loads the Data loaded by SQL*Loader into the
59: -- temp table, parses it as according to the DL File Spec and
60: -- loads it into the DL interface tables.
61:
62: PROCEDURE dl_load_data(p_dbth_id OUT NOCOPY igf_sl_dl_batch.dbth_id%TYPE)
63: AS
64: /*************************************************************
65: Created By : venagara
66: Date Created On : 2000/11/22

Line 94: l_dbth_id igf_sl_dl_batch.dbth_id%TYPE;

90: l_rec_batch_rej_code VARCHAR2(100);
91: l_rec_batch_type VARCHAR2(100);
92:
93: l_rowid VARCHAR2(25);
94: l_dbth_id igf_sl_dl_batch.dbth_id%TYPE;
95: l_dl_file_type igf_sl_dl_file_type.dl_file_type%TYPE;
96: l_dl_loan_catg igf_sl_dl_file_type.dl_loan_catg%TYPE;
97:
98: -- Cursor to parse and load the Header record.

Line 123: CURSOR c_dbth(l_batch_id igf_sl_dl_batch.batch_id%TYPE,

119: AND record_data like 'DL TRAILER%'
120: AND file_type = 'DL_CHG_ACK';
121:
122: -- Cursor to check the Batch Details, if the same Batch is loaded again.
123: CURSOR c_dbth(l_batch_id igf_sl_dl_batch.batch_id%TYPE,
124: l_message_class igf_sl_dl_batch.message_class%TYPE,
125: l_bth_creation_date VARCHAR2,
126: l_batch_type igf_sl_dl_batch.batch_type%TYPE)
127: IS

Line 124: l_message_class igf_sl_dl_batch.message_class%TYPE,

120: AND file_type = 'DL_CHG_ACK';
121:
122: -- Cursor to check the Batch Details, if the same Batch is loaded again.
123: CURSOR c_dbth(l_batch_id igf_sl_dl_batch.batch_id%TYPE,
124: l_message_class igf_sl_dl_batch.message_class%TYPE,
125: l_bth_creation_date VARCHAR2,
126: l_batch_type igf_sl_dl_batch.batch_type%TYPE)
127: IS
128: SELECT 'x' FROM igf_sl_dl_batch

Line 126: l_batch_type igf_sl_dl_batch.batch_type%TYPE)

122: -- Cursor to check the Batch Details, if the same Batch is loaded again.
123: CURSOR c_dbth(l_batch_id igf_sl_dl_batch.batch_id%TYPE,
124: l_message_class igf_sl_dl_batch.message_class%TYPE,
125: l_bth_creation_date VARCHAR2,
126: l_batch_type igf_sl_dl_batch.batch_type%TYPE)
127: IS
128: SELECT 'x' FROM igf_sl_dl_batch
129: WHERE batch_id = l_batch_id
130: AND message_class = l_message_class

Line 128: SELECT 'x' FROM igf_sl_dl_batch

124: l_message_class igf_sl_dl_batch.message_class%TYPE,
125: l_bth_creation_date VARCHAR2,
126: l_batch_type igf_sl_dl_batch.batch_type%TYPE)
127: IS
128: SELECT 'x' FROM igf_sl_dl_batch
129: WHERE batch_id = l_batch_id
130: AND message_class = l_message_class
131: AND to_char(bth_creation_date,'YYYYMMDDHH24MISS') = l_bth_creation_date
132: AND batch_type = l_batch_type;

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

214: -- Check if the entire batch was rejected for any reason or not
215: IF LTRIM(RTRIM(l_rec_batch_rej_code)) IS NOT NULL THEN
216: fnd_message.set_name('IGF','IGF_GE_BATCH_REJECTED');
217: fnd_message.set_token('BATCH', l_rec_batch_id);
218: fnd_message.set_token('REASON', igf_aw_gen.lookup_desc('IGF_SL_DL_BATCH_REJ',l_rec_batch_rej_code));
219: -- Message : Batch #BATCH was rejected. Reason : #REASON.
220: igs_ge_msg_stack.add;
221: RAISE FILE_NOT_LOADED;
222: END IF;

Line 235: -- Insert the Batch Details into the igf_sl_dl_batch table.

231: RAISE FILE_ALREADY_LOADED;
232: END IF;
233:
234: l_rowid := NULL;
235: -- Insert the Batch Details into the igf_sl_dl_batch table.
236: igf_sl_dl_batch_pkg.insert_row (
237: x_mode => 'R',
238: x_rowid => l_rowid,
239: X_dbth_id => l_dbth_id,

Line 236: igf_sl_dl_batch_pkg.insert_row (

232: END IF;
233:
234: l_rowid := NULL;
235: -- Insert the Batch Details into the igf_sl_dl_batch table.
236: igf_sl_dl_batch_pkg.insert_row (
237: x_mode => 'R',
238: x_rowid => l_rowid,
239: X_dbth_id => l_dbth_id,
240: X_batch_id => l_rec_batch_id,

Line 341: l_dbth_id igf_sl_dl_batch.dbth_id%TYPE;

337:
338: (reverse chronological order - newest change first)
339: ***************************************************************/
340:
341: l_dbth_id igf_sl_dl_batch.dbth_id%TYPE;
342: l_batch_type igf_sl_dl_batch.batch_type%TYPE;
343: l_rec_present VARCHAR2(10);
344: l_stat VARCHAR2(30);
345: l_loan_chg_status igf_lookups_view.lookup_code%TYPE;

Line 342: l_batch_type igf_sl_dl_batch.batch_type%TYPE;

338: (reverse chronological order - newest change first)
339: ***************************************************************/
340:
341: l_dbth_id igf_sl_dl_batch.dbth_id%TYPE;
342: l_batch_type igf_sl_dl_batch.batch_type%TYPE;
343: l_rec_present VARCHAR2(10);
344: l_stat VARCHAR2(30);
345: l_loan_chg_status igf_lookups_view.lookup_code%TYPE;
346: l_sub_col_heading VARCHAR2(1000) DEFAULT NULL;

Line 349: SELECT igf_sl_dl_batch.* FROM igf_sl_dl_batch

345: l_loan_chg_status igf_lookups_view.lookup_code%TYPE;
346: l_sub_col_heading VARCHAR2(1000) DEFAULT NULL;
347:
348: CURSOR cur_batch IS
349: SELECT igf_sl_dl_batch.* FROM igf_sl_dl_batch
350: WHERE dbth_id = l_dbth_id
351: AND status = 'N';
352:
353: -- Get the Count of Records which have Reject Codes, for each change SENT

Line 355: CURSOR cur_chg_resp(l_dbth_id igf_sl_dl_batch.dbth_id%TYPE) IS

351: AND status = 'N';
352:
353: -- Get the Count of Records which have Reject Codes, for each change SENT
354: -- OR Count of Records which have Errors for the ENTIRE Line SENT
355: CURSOR cur_chg_resp(l_dbth_id igf_sl_dl_batch.dbth_id%TYPE) IS
356: SELECT loan_number,
357: NVL(SUM(DECODE(loan_ident_err_code,NULL,0,1)),0) loan_err_count,
358: NVL(SUM(DECODE(reject_code,NULL,1,0)),0) accept_count,
359: NVL(SUM(DECODE(reject_code,NULL,0,1)),0) reject_count

Line 382: p_dbth_id igf_sl_dl_batch.dbth_id%TYPE,

378: --Added code as part of Bug :- 2383350 Loan Cancellation
379: --Check if the received file has the change code as LOAN_AMT_ACCEPTED
380: --for the particular Loan Number
381: CURSOR cur_get_loan_accp_amt(p_loan_number igf_sl_loans_all.loan_number%TYPE,
382: p_dbth_id igf_sl_dl_batch.dbth_id%TYPE,
383: p_loan_catg igf_sl_dl_chg_fld.loan_catg%TYPE
384: ) IS
385: SELECT resp.new_value
386: FROM igf_sl_dl_chg_resp resp,igf_sl_dl_chg_fld chgfld

Line 488: CURSOR cur_loan_err_resp(l_dbth_id igf_sl_dl_batch.dbth_id%TYPE,

484: /************* Show Reject Details on the LOG File ***************/
485: DECLARE
486:
487: -- Loan Error for the ENTIRE line are retrieved here.
488: CURSOR cur_loan_err_resp(l_dbth_id igf_sl_dl_batch.dbth_id%TYPE,
489: l_loan_number igf_sl_loans.loan_number%TYPE) IS
490: SELECT DISTINCT rchg.loan_ident_err_code
491: FROM igf_sl_dl_chg_resp rchg
492: WHERE rchg.dbth_id = l_dbth_id

Line 498: CURSOR cur_chg_rej_resp(l_dbth_id igf_sl_dl_batch.dbth_id%TYPE,

494: AND rchg.loan_ident_err_code IS NOT NULL
495: AND rchg.status = 'N';
496:
497: -- Reject Codes for Individual Field Changes are retrieved here.
498: CURSOR cur_chg_rej_resp(l_dbth_id igf_sl_dl_batch.dbth_id%TYPE,
499: l_loan_number igf_sl_loans.loan_number%TYPE) IS
500: SELECT fld_name, cchgv.description fld_desc, rchg.reject_code, rchg.new_value
501: FROM igf_sl_dl_chg_resp rchg,
502: igf_sl_dl_chg_fld_v cchgv

Line 588: igf_sl_dl_batch_pkg.update_row (

584: END LOOP; -- End of igf_sl_dl_chg_resp table LOOP.
585:
586:
587: -- Update the DL_BATCH record as Successfully Uploaded.
588: igf_sl_dl_batch_pkg.update_row (
589: X_Mode => 'R',
590: x_rowid => dbth_rec.row_id,
591: x_dbth_id => dbth_rec.dbth_id,
592: x_batch_id => dbth_rec.batch_id,

Line 635: PROCEDURE upd_dl_chg_resp(p_dbth_id igf_sl_dl_batch.dbth_id%TYPE,

631:
632:
633:
634:
635: PROCEDURE upd_dl_chg_resp(p_dbth_id igf_sl_dl_batch.dbth_id%TYPE,
636: p_loan_number igf_sl_loans.loan_number%TYPE,
637: p_status igf_sl_dl_chg_resp.status%TYPE)
638: IS
639: /*************************************************************