APPS.IGF_SL_DL_CHG_ACK dependencies on IGF_SL_DL_CHG_RESP

Line 45: p_status igf_sl_dl_chg_resp.status%TYPE);

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,
48: p_loan_status IN igf_sl_loans_all.loan_status%TYPE,
49: p_loan_chg_status IN igf_sl_loans.loan_chg_status%TYPE,

Line 272: igf_sl_dl_chg_resp_pkg.insert_row (

268: FOR l_incr in 1..10 LOOP
269:
270: IF RTRIM(substr(orec.record_data, 24+(56*(l_incr-1)), 4)) IS NOT NULL THEN
271: l_rowid := NULL;
272: igf_sl_dl_chg_resp_pkg.insert_row (
273: x_mode => 'R',
274: x_rowid => l_rowid,
275: X_resp_num => l_lor_resp_num,
276: X_dbth_id => l_dbth_id,

Line 360: FROM igf_sl_dl_chg_resp

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
360: FROM igf_sl_dl_chg_resp
361: WHERE dbth_id = l_dbth_id
362: AND status = 'N'
363: GROUP BY loan_number;
364:

Line 386: FROM igf_sl_dl_chg_resp resp,igf_sl_dl_chg_fld chgfld

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
387: WHERE loan_number =p_loan_number
388: AND dbth_id =p_dbth_id
389: AND status ='N'
390: AND resp.chg_code = chgfld.chg_code

Line 491: FROM igf_sl_dl_chg_resp rchg

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
493: AND rchg.loan_number = l_loan_number
494: AND rchg.loan_ident_err_code IS NOT NULL
495: AND rchg.status = 'N';

Line 501: FROM igf_sl_dl_chg_resp rchg,

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
503: WHERE rchg.dbth_id = l_dbth_id
504: AND rchg.loan_number = l_loan_number
505: AND rchg.reject_code IS NOT NULL

Line 584: END LOOP; -- End of igf_sl_dl_chg_resp table LOOP.

580: fnd_file.put_line(FND_FILE.LOG,'');
581: fnd_file.put_line(FND_FILE.LOG,'');
582: END IF;
583:
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 (

Line 637: p_status igf_sl_dl_chg_resp.status%TYPE)

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: /*************************************************************
640: Created By : venagara
641: Date Created On : 2000/11/22

Line 652: SELECT igf_sl_dl_chg_resp.* FROM igf_sl_dl_chg_resp

648: ***************************************************************/
649:
650: lv_row_id VARCHAR2(25);
651: CURSOR c_tbh_cur IS
652: SELECT igf_sl_dl_chg_resp.* FROM igf_sl_dl_chg_resp
653: WHERE dbth_id = p_dbth_id
654: AND loan_number = p_loan_number;
655: BEGIN
656:

Line 661: igf_sl_dl_chg_resp_pkg.update_row (

657: FOR tbh_rec in c_tbh_cur LOOP
658:
659: tbh_rec.status := p_status;
660:
661: igf_sl_dl_chg_resp_pkg.update_row (
662: X_Mode => 'R',
663: x_rowid => tbh_rec.row_id,
664: x_resp_num => tbh_rec.resp_num,
665: x_dbth_id => tbh_rec.dbth_id,