APPS.IGF_SL_DL_ORIG_ACK dependencies on IGF_SL_DL_LOR_RESP

Line 86: -- IGF_SL_DL_LOR_RESP table into

82: ---------------------------------------------------------------------------
83: -- rboddu 18/05/2001 ENH BUG NO: 1769051
84: -- ENH DESCRIPTION: Loan Processing-Nov 2001
85: -- Uploaded pnote_id field of
86: -- IGF_SL_DL_LOR_RESP table into
87: -- pnote_mpn_ind field
88: -- of IGF_SL_LOR, IGF_SL_LOR_LOC tables.
89: -- If School is configured to print,
90: -- then the pnote_status field of IGF_SL_LOR

Line 101: g_sl_dl_lor_resp igf_sl_dl_lor_resp%ROWTYPE;

97: ---------------------------------------------------------------------------
98:
99:
100: g_lor_loc_rec igf_sl_lor_loc%ROWTYPE;
101: g_sl_dl_lor_resp igf_sl_dl_lor_resp%ROWTYPE;
102: g_entry_point VARCHAR2(10) DEFAULT 'NULL';
103: file_not_loaded EXCEPTION;
104: yr_full_participant EXCEPTION;
105:

Line 346: igf_sl_dl_lor_resp_pkg.insert_row (

342: IF l_dl_loan_catg in ('DL_STAFFORD','DL_PLUS') THEN
343: FOR orec IN c_trans LOOP
344: l_actual_rec := l_actual_rec + 1;
345: l_rowid := NULL;
346: igf_sl_dl_lor_resp_pkg.insert_row (
347: x_mode => 'R',
348: x_rowid => l_rowid,
349: x_lor_resp_num => l_lor_resp_num,
350: x_dbth_id => l_dbth_id,

Line 406: igf_sl_dl_lor_resp_pkg.insert_row (

402: IF l_dl_loan_catg in ('DL_STAFFORD','DL_PLUS') THEN
403: FOR orec IN c_trans LOOP
404: l_actual_rec := l_actual_rec + 1;
405: l_rowid := NULL;
406: igf_sl_dl_lor_resp_pkg.insert_row (
407: x_mode => 'R',
408: x_rowid => l_rowid,
409: x_lor_resp_num => l_lor_resp_num,
410: x_dbth_id => l_dbth_id,

Line 527: SELECT igf_sl_dl_lor_resp.*

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
530: AND status = 'N';
531:

Line 528: FROM igf_sl_dl_lor_resp

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
530: AND status = 'N';
531:
532: CURSOR cur_lor_crresp(l_dbth_id igf_sl_dl_batch.dbth_id%TYPE)

Line 642: igf_sl_dl_lor_resp_pkg.update_row (

638: END IF;
639: END IF;
640:
641: -- Update the Response File's transaction record with the Processing Status
642: igf_sl_dl_lor_resp_pkg.update_row (
643: x_mode => 'R',
644: x_rowid => resp_rec.row_id,
645: x_lor_resp_num => resp_rec.lor_resp_num,
646: x_dbth_id => resp_rec.dbth_id,

Line 661: END LOOP; -- End of igf_sl_dl_lor_resp table LOOP.

657: x_elec_mpn_ind => resp_rec.elec_mpn_ind
658: );
659:
660:
661: END LOOP; -- End of igf_sl_dl_lor_resp table LOOP.
662:
663:
664: ELSIF l_dl_loan_catg = 'DL_PLUS_CREDIT' THEN
665:

Line 816: rboddu 18/05/2001 uploaded pnote_id field of IGF_SL_DL_LOR_RESP table into

812: chg_batch_id from igf_sl_lor_loc
813:
814: agairola 15-MAR-2002 Modified the Update Row call of the IGF_SL_LOANS_PKG
815: added as part of the Refunds DLD - 2144600
816: rboddu 18/05/2001 uploaded pnote_id field of IGF_SL_DL_LOR_RESP table into
817: pnote_mpn_ind field of IGF_SL_LOR table.
818: If School is configured to print then the pnote_status
819: field of IGF_SL_LOR is set to 'G' (Ready to Print)
820:

Line 1165: rboddu 18/05/2001 uploaded pnote_id field of IGF_SL_DL_LOR_RESP table into

1161: 2. Obsoleted lend_apprv_denied_code,lend_apprv_denied_date,cl_rec_status_last_update,
1162: cl_rec_status,mpn_confirm_code,appl_loan_phase_code_chg,appl_loan_phase_code,
1163: p_ssn_chg_date,p_dob_chg_date,s_ssn_chg_date,s_dob_chg_date,s_local_addr_chg_date,
1164: chg_batch_id from igf_sl_lor_loc
1165: rboddu 18/05/2001 uploaded pnote_id field of IGF_SL_DL_LOR_RESP table into
1166: pnote_mpn_ind field of IGF_SL_LOR_LOC table.
1167:
1168: (reverse chronological order - newest change first)
1169: ***************************************************************/