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_ORIG_ACK dependencies on IGF_SL_LOR

Line 21: -- in igf_sl_lor_all table and obsoleting

17: -- veramach 29-Jan-2004 bug 3408092 added 2004-2005 in dl_version checks
18: -----------------------------------------------------------------------------------
19: -- bkkumar 06-oct-2003 Bug 3104228 FA 122 Loans Enhancements
20: -- a) Impact of adding the relationship_cd
21: -- in igf_sl_lor_all table and obsoleting
22: -- BORW_LENDER_ID, DUNS_BORW_LENDER_ID,
23: -- GUARANTOR_ID, DUNS_GUARNT_ID,
24: -- LENDER_ID, DUNS_LENDER_ID
25: -- LEND_NON_ED_BRC_ID, RECIPIENT_ID

Line 32: -- igf_sl_lor_loc_all table.

28: -- b) Also the DUNS_BORW_LENDER_ID
29: -- DUNS_GUARNT_ID
30: -- DUNS_LENDER_ID
31: -- DUNS_RECIP_ID columns are osboleted from the
32: -- igf_sl_lor_loc_all table.
33: -----------------------------------------------------------------------------------------------------------------------------
34: -- veramach 23-SEP-2003 Bug 3104228: Obsoleted lend_apprv_denied_code,lend_apprv_denied_date,cl_rec_status_last_update,
35: -- cl_rec_status,mpn_confirm_code,appl_loan_phase_code_chg,appl_loan_phase_code,
36: -- p_ssn_chg_date,p_dob_chg_date,s_ssn_chg_date,s_dob_chg_date,s_local_addr_chg_date,

Line 37: -- chg_batch_id,appl_send_error_codes from igf_sl_lor

33: -----------------------------------------------------------------------------------------------------------------------------
34: -- veramach 23-SEP-2003 Bug 3104228: Obsoleted lend_apprv_denied_code,lend_apprv_denied_date,cl_rec_status_last_update,
35: -- cl_rec_status,mpn_confirm_code,appl_loan_phase_code_chg,appl_loan_phase_code,
36: -- p_ssn_chg_date,p_dob_chg_date,s_ssn_chg_date,s_dob_chg_date,s_local_addr_chg_date,
37: -- chg_batch_id,appl_send_error_codes from igf_sl_lor
38: -- Obsoleted lend_apprv_denied_code,lend_apprv_denied_date,cl_rec_status_last_update,
39: -- cl_rec_status,mpn_confirm_code,appl_loan_phase_code_chg,appl_loan_phase_code,
40: -- p_ssn_chg_date,p_dob_chg_date,s_ssn_chg_date,s_dob_chg_date,s_local_addr_chg_date,
41: -- chg_batch_id from igf_sl_lor_loc

Line 41: -- chg_batch_id from igf_sl_lor_loc

37: -- chg_batch_id,appl_send_error_codes from igf_sl_lor
38: -- Obsoleted lend_apprv_denied_code,lend_apprv_denied_date,cl_rec_status_last_update,
39: -- cl_rec_status,mpn_confirm_code,appl_loan_phase_code_chg,appl_loan_phase_code,
40: -- p_ssn_chg_date,p_dob_chg_date,s_ssn_chg_date,s_dob_chg_date,s_local_addr_chg_date,
41: -- chg_batch_id from igf_sl_lor_loc
42: ------------------------------------------------------------------------------------------------------------------------------
43: ---------------------------------------------------------------------------
44: -- sjadhav 28-Mar-2003 Bug 2863960 added code 'X' for orign records
45: ---------------------------------------------------------------------------

Line 54: -- Modified the tbh call of igf_sl_lor table

50: -- Changes as per TD
51: -- Added dl_credit_ack
52: ---------------------------------------------------------------------------
53: -- adhawan 19-feb-2002 Bug 2216956
54: -- Modified the tbh call of igf_sl_lor table
55: -- to include elec_mpn_ind ,
56: -- borr_sign_ind,stud_sign_ind,
57: -- borr_credit_auth_code
58: -- Modified the tbh call of

Line 88: -- of IGF_SL_LOR, IGF_SL_LOR_LOC tables.

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
91: -- is set to 'G' (Ready to Print)
92: ---------------------------------------------------------------------------

Line 90: -- then the pnote_status field of IGF_SL_LOR

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
91: -- is set to 'G' (Ready to Print)
92: ---------------------------------------------------------------------------
93: -- Created By : venagara
94: -- Date Created On : 2000/11/22

Line 100: g_lor_loc_rec igf_sl_lor_loc%ROWTYPE;

96: -- Know limitations, enhancements or remarks
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;

Line 111: PROCEDURE upd_lor_loc_record(p_loan_id igf_sl_lor.loan_id%TYPE, p_process VARCHAR2);

107: PROCEDURE upd_lor_record(p_loan_number IN igf_sl_loans.loan_number%TYPE,
108: p_process IN VARCHAR2,
109: p_rec_present OUT NOCOPY VARCHAR2,
110: p_rec_updated OUT NOCOPY VARCHAR2 );
111: PROCEDURE upd_lor_loc_record(p_loan_id igf_sl_lor.loan_id%TYPE, p_process VARCHAR2);
112:
113:
114:
115:

Line 559: -- Use this to update igf_sl_lor_loc table, with old values.

555: FOR resp_rec IN cur_lor_resp(l_dbth_id) LOOP
556: l_rec_present := 'N';
557: l_rec_updated := 'N';
558:
559: -- Use this to update igf_sl_lor_loc table, with old values.
560: g_lor_loc_rec.orig_status_flag := resp_rec.orig_status_flag;
561: g_lor_loc_rec.orig_ack_date := resp_rec.orig_ack_date;
562: g_lor_loc_rec.pnote_status := resp_rec.pnote_status;
563:

Line 574: -- Update the IGF_SL_LOR record.

570: g_lor_loc_rec.pnote_status_date := resp_rec.orig_ack_date;
571: g_lor_loc_rec.pnote_mpn_ind := resp_rec.pnote_id;
572: g_sl_dl_lor_resp.elec_mpn_ind := resp_rec.elec_mpn_ind;
573:
574: -- Update the IGF_SL_LOR record.
575: -- MN 27-Dec-2004 15:33 - Following matrix will be used to update the loan status based on responses for PLUS loans.
576: -- B = Rejected Origination
577: -- C = Accepted Origination/Credit Check Accepted (PLUS only)
578: -- D = Accepted Origination/Credit Check Denied (PLUS only)

Line 675: -- Use this to update igf_sl_lor_loc table, with old values.

671:
672: l_rec_present := 'N';
673: l_rec_updated := 'N';
674:
675: -- Use this to update igf_sl_lor_loc table, with old values.
676: g_lor_loc_rec.credit_override := crresp_rec.credit_override;
677: g_lor_loc_rec.credit_decision_date := crresp_rec.credit_decision_date;
678: g_lor_loc_rec.pnote_status := crresp_rec.mpn_status;
679: g_lor_loc_rec.pnote_status_date := crresp_rec.credit_decision_date;

Line 691: -- Update the IGF_SL_LOR record.

687: g_sl_dl_lor_resp.elec_mpn_ind := crresp_rec.mpn_type;
688: g_lor_loc_rec.pnote_accept_amt := crresp_rec.endorser_amount;
689:
690:
691: -- Update the IGF_SL_LOR record.
692: upd_lor_record(crresp_rec.loan_number, 'CREDIT_ACK', l_rec_present, l_rec_updated);
693:
694: IF l_rec_present = 'N' THEN
695: fnd_message.set_name('IGF','IGF_SL_NO_LOAN_NUMBER');

Line 796: -- in igf_sl_lor_all table and obsoleting

792: -- Modified cursor c_lar_cur for better performance.
793: ---------------------------------------------------------------------------------------------
794: -- bkkumar 06-oct-2003 Bug 3104228 FA 122 Loans Enhancements
795: -- a) Impact of adding the relationship_cd
796: -- in igf_sl_lor_all table and obsoleting
797: -- BORW_LENDER_ID, DUNS_BORW_LENDER_ID,
798: -- GUARANTOR_ID, DUNS_GUARNT_ID,
799: -- LENDER_ID, DUNS_LENDER_ID
800: -- LEND_NON_ED_BRC_ID, RECIPIENT_ID

Line 808: chg_batch_id,appl_send_error_codes from igf_sl_lor

804: veramach 23-SEP-2003 Bug 3104228:
805: 1. Obsoleted lend_apprv_denied_code,lend_apprv_denied_date,cl_rec_status_last_update,
806: cl_rec_status,mpn_confirm_code,appl_loan_phase_code_chg,appl_loan_phase_code,
807: p_ssn_chg_date,p_dob_chg_date,s_ssn_chg_date,s_dob_chg_date,s_local_addr_chg_date,
808: chg_batch_id,appl_send_error_codes from igf_sl_lor
809: 2. Obsoleted lend_apprv_denied_code,lend_apprv_denied_date,cl_rec_status_last_update,
810: cl_rec_status,mpn_confirm_code,appl_loan_phase_code_chg,appl_loan_phase_code,
811: p_ssn_chg_date,p_dob_chg_date,s_ssn_chg_date,s_dob_chg_date,s_local_addr_chg_date,
812: chg_batch_id from igf_sl_lor_loc

Line 812: chg_batch_id from igf_sl_lor_loc

808: chg_batch_id,appl_send_error_codes from igf_sl_lor
809: 2. Obsoleted lend_apprv_denied_code,lend_apprv_denied_date,cl_rec_status_last_update,
810: cl_rec_status,mpn_confirm_code,appl_loan_phase_code_chg,appl_loan_phase_code,
811: p_ssn_chg_date,p_dob_chg_date,s_ssn_chg_date,s_dob_chg_date,s_local_addr_chg_date,
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

Line 817: pnote_mpn_ind field of IGF_SL_LOR table.

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:
821: (reverse chronological order - newest change first)

Line 819: field of IGF_SL_LOR is set to 'G' (Ready to Print)

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:
821: (reverse chronological order - newest change first)
822: ***************************************************************/
823:

Line 828: SELECT igf_sl_lor.* FROM igf_sl_lor

824: l_row_id VARCHAR2(25);
825: l_print_opt igf_sl_dl_setup.pnote_print_ind%TYPE;
826:
827: CURSOR c_tbh_cur IS
828: SELECT igf_sl_lor.* FROM igf_sl_lor
829: WHERE loan_id = (SELECT loan_id FROM igf_sl_loans lar
830: WHERE loan_number = p_loan_number)
831: FOR UPDATE OF igf_sl_lor.sch_cert_date NOWAIT;
832:

Line 831: FOR UPDATE OF igf_sl_lor.sch_cert_date NOWAIT;

827: CURSOR c_tbh_cur IS
828: SELECT igf_sl_lor.* FROM igf_sl_lor
829: WHERE loan_id = (SELECT loan_id FROM igf_sl_loans lar
830: WHERE loan_number = p_loan_number)
831: FOR UPDATE OF igf_sl_lor.sch_cert_date NOWAIT;
832:
833: CURSOR c_lar_cur(c_loan_id igf_sl_loans.loan_id%TYPE)
834: IS
835: SELECT loan.rowid row_id,

Line 915: igf_sl_lor_pkg.update_row (

911: IF p_rec_updated = 'Y' THEN
912:
913: -- Delete all previous reject records, for Response process.
914: igf_sl_edit.delete_edit(p_loan_number, 'R');
915: igf_sl_lor_pkg.update_row (
916: x_mode => 'R',
917: x_rowid => tbh_rec.row_id,
918: x_origination_id => tbh_rec.origination_id,
919: x_loan_id => tbh_rec.loan_id,

Line 1139: PROCEDURE upd_lor_loc_record(p_loan_id igf_sl_lor.loan_id%TYPE, p_process VARCHAR2)

1135: END upd_lor_record;
1136:
1137:
1138:
1139: PROCEDURE upd_lor_loc_record(p_loan_id igf_sl_lor.loan_id%TYPE, p_process VARCHAR2)
1140: AS
1141: /*************************************************************
1142: Created By : venagara
1143: Date Created On : 2000/11/22

Line 1154: -- igf_sl_lor_loc_all table.

1150: -- The DUNS_BORW_LENDER_ID,
1151: -- DUNS_GUARNT_ID,
1152: -- DUNS_LENDER_ID,
1153: -- DUNS_RECIP_ID columns are osboleted from the
1154: -- igf_sl_lor_loc_all table.
1155: -----------------------------------------------------------------------------------------------------------
1156: veramach 23-SEP-2003 Bug 3104228:
1157: 1. Obsoleted lend_apprv_denied_code,lend_apprv_denied_date,cl_rec_status_last_update,
1158: cl_rec_status,mpn_confirm_code,appl_loan_phase_code_chg,appl_loan_phase_code,

Line 1160: chg_batch_id,appl_send_error_codes from igf_sl_lor

1156: veramach 23-SEP-2003 Bug 3104228:
1157: 1. Obsoleted lend_apprv_denied_code,lend_apprv_denied_date,cl_rec_status_last_update,
1158: cl_rec_status,mpn_confirm_code,appl_loan_phase_code_chg,appl_loan_phase_code,
1159: p_ssn_chg_date,p_dob_chg_date,s_ssn_chg_date,s_dob_chg_date,s_local_addr_chg_date,
1160: chg_batch_id,appl_send_error_codes from igf_sl_lor
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

Line 1164: chg_batch_id from igf_sl_lor_loc

1160: chg_batch_id,appl_send_error_codes from igf_sl_lor
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)

Line 1166: pnote_mpn_ind field of IGF_SL_LOR_LOC table.

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: ***************************************************************/
1170:

Line 1174: igf_sl_lor_loc.*

1170:
1171: CURSOR c_tbh_cur
1172: IS
1173: SELECT
1174: igf_sl_lor_loc.*
1175: FROM
1176: igf_sl_lor_loc
1177: WHERE loan_id = p_loan_id
1178: FOR UPDATE OF igf_sl_lor_loc.loan_status NOWAIT;

Line 1176: igf_sl_lor_loc

1172: IS
1173: SELECT
1174: igf_sl_lor_loc.*
1175: FROM
1176: igf_sl_lor_loc
1177: WHERE loan_id = p_loan_id
1178: FOR UPDATE OF igf_sl_lor_loc.loan_status NOWAIT;
1179:
1180: BEGIN

Line 1178: FOR UPDATE OF igf_sl_lor_loc.loan_status NOWAIT;

1174: igf_sl_lor_loc.*
1175: FROM
1176: igf_sl_lor_loc
1177: WHERE loan_id = p_loan_id
1178: FOR UPDATE OF igf_sl_lor_loc.loan_status NOWAIT;
1179:
1180: BEGIN
1181:
1182: FOR tbh_rec in c_tbh_cur LOOP

Line 1202: igf_sl_lor_loc_pkg.update_row (

1198:
1199: tbh_rec.loan_status := g_lor_loc_rec.loan_status;
1200: tbh_rec.loan_status_date := g_lor_loc_rec.loan_status_date;
1201:
1202: igf_sl_lor_loc_pkg.update_row (
1203: x_mode => 'R',
1204: x_rowid => tbh_rec.row_id,
1205: x_loan_id => tbh_rec.loan_id,
1206: x_origination_id => tbh_rec.origination_id,