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

Line 19: -- in igf_sl_lor_all table and obsoleting

15: -------------------------------------------------------------------------------------
16:
17: -- bkkumar 06-oct-2003 Bug 3104228 FA 122 Loans Enhancements
18: -- a) Impact of adding the relationship_cd
19: -- in igf_sl_lor_all table and obsoleting
20: -- BORW_LENDER_ID, DUNS_BORW_LENDER_ID,
21: -- GUARANTOR_ID, DUNS_GUARNT_ID,
22: -- LENDER_ID, DUNS_LENDER_ID
23: -- LEND_NON_ED_BRC_ID, RECIPIENT_ID

Line 30: chg_batch_id,appl_send_error_codes from igf_sl_lor

26: --------------------------------------------------------------------------------------
27: veramach 23-SEP-2003 Bug 3104228: Obsoleted lend_apprv_denied_code,lend_apprv_denied_date,cl_rec_status_last_update,
28: cl_rec_status,mpn_confirm_code,appl_loan_phase_code_chg,appl_loan_phase_code,
29: p_ssn_chg_date,p_dob_chg_date,s_ssn_chg_date,s_dob_chg_date,s_local_addr_chg_date,
30: chg_batch_id,appl_send_error_codes from igf_sl_lor
31: veramach 16-SEP-2003 FA 122 loan enhancements build
32: 1.Added update_pnote_status method
33: 2.Changed cursors c_stafford_det and c_plus_det to remove references of igf_sl_plus_borw.
34: 3.the borrower info is now derived using igf_sl_gen.get_person_details procedure

Line 46: Added Elec_mpn_ind , Borr_sign_ind in igf_sl_lor_pkg

42: formatting and substr of 9 chars is done.
43: Code added to display the Parameters passed.
44: Who When What
45: masehgal 19-Feb-2002 # 2216956 FACR007
46: Added Elec_mpn_ind , Borr_sign_ind in igf_sl_lor_pkg
47: ***************************************************************/
48:
49: g_debug_runtime_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
50:

Line 76: Added Elec_mpn_ind , Borr_sign_ind in igf_sl_lor_pkg

72: 3.changed c_dl_orig_recs cursor -added 2 where clauses on ci_cal_type and ci_sequence_number and
73: changed the signature to take lookup_type and pnote_status as arguments
74:
75: masehgal 19-Feb-2002 # 2216956 FACR007
76: Added Elec_mpn_ind , Borr_sign_ind in igf_sl_lor_pkg
77: ****************************************************************/
78:
79: student_dtl_rec igf_sl_gen.person_dtl_rec;
80: student_dtl_cur igf_sl_gen.person_dtl_cur;

Line 93: CURSOR c_lor_rec( x_loan_id igf_sl_lor.loan_id%TYPE ) IS

89: SELECT pnote_print_ind, ci_alternate_code
90: FROM igf_sl_dl_setup_v
91: WHERE ci_cal_type = x_ci_cal_type AND ci_sequence_number = x_ci_sequence_number;
92:
93: CURSOR c_lor_rec( x_loan_id igf_sl_lor.loan_id%TYPE ) IS
94: SELECT igf_sl_lor.*
95: FROM igf_sl_lor
96: WHERE loan_id = x_loan_id FOR UPDATE OF igf_sl_lor.pnote_status NOWAIT;
97:

Line 94: SELECT igf_sl_lor.*

90: FROM igf_sl_dl_setup_v
91: WHERE ci_cal_type = x_ci_cal_type AND ci_sequence_number = x_ci_sequence_number;
92:
93: CURSOR c_lor_rec( x_loan_id igf_sl_lor.loan_id%TYPE ) IS
94: SELECT igf_sl_lor.*
95: FROM igf_sl_lor
96: WHERE loan_id = x_loan_id FOR UPDATE OF igf_sl_lor.pnote_status NOWAIT;
97:
98: CURSOR c_dl_orig_recs( x_ci_cal_type igf_sl_lor_v.ci_cal_type%TYPE,

Line 95: FROM igf_sl_lor

91: WHERE ci_cal_type = x_ci_cal_type AND ci_sequence_number = x_ci_sequence_number;
92:
93: CURSOR c_lor_rec( x_loan_id igf_sl_lor.loan_id%TYPE ) IS
94: SELECT igf_sl_lor.*
95: FROM igf_sl_lor
96: WHERE loan_id = x_loan_id FOR UPDATE OF igf_sl_lor.pnote_status NOWAIT;
97:
98: CURSOR c_dl_orig_recs( x_ci_cal_type igf_sl_lor_v.ci_cal_type%TYPE,
99: x_ci_sequence_number igf_sl_lor_v.ci_sequence_number%TYPE,

Line 96: WHERE loan_id = x_loan_id FOR UPDATE OF igf_sl_lor.pnote_status NOWAIT;

92:
93: CURSOR c_lor_rec( x_loan_id igf_sl_lor.loan_id%TYPE ) IS
94: SELECT igf_sl_lor.*
95: FROM igf_sl_lor
96: WHERE loan_id = x_loan_id FOR UPDATE OF igf_sl_lor.pnote_status NOWAIT;
97:
98: CURSOR c_dl_orig_recs( x_ci_cal_type igf_sl_lor_v.ci_cal_type%TYPE,
99: x_ci_sequence_number igf_sl_lor_v.ci_sequence_number%TYPE,
100: x_loan_number igf_sl_lor_v.loan_number%TYPE,

Line 98: CURSOR c_dl_orig_recs( x_ci_cal_type igf_sl_lor_v.ci_cal_type%TYPE,

94: SELECT igf_sl_lor.*
95: FROM igf_sl_lor
96: WHERE loan_id = x_loan_id FOR UPDATE OF igf_sl_lor.pnote_status NOWAIT;
97:
98: CURSOR c_dl_orig_recs( x_ci_cal_type igf_sl_lor_v.ci_cal_type%TYPE,
99: x_ci_sequence_number igf_sl_lor_v.ci_sequence_number%TYPE,
100: x_loan_number igf_sl_lor_v.loan_number%TYPE,
101: x_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
102: x_pnote_status igf_sl_lor_v.pnote_status%TYPE,

Line 99: x_ci_sequence_number igf_sl_lor_v.ci_sequence_number%TYPE,

95: FROM igf_sl_lor
96: WHERE loan_id = x_loan_id FOR UPDATE OF igf_sl_lor.pnote_status NOWAIT;
97:
98: CURSOR c_dl_orig_recs( x_ci_cal_type igf_sl_lor_v.ci_cal_type%TYPE,
99: x_ci_sequence_number igf_sl_lor_v.ci_sequence_number%TYPE,
100: x_loan_number igf_sl_lor_v.loan_number%TYPE,
101: x_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
102: x_pnote_status igf_sl_lor_v.pnote_status%TYPE,
103: x_lookup_type igf_lookups_view.lookup_type%TYPE

Line 100: x_loan_number igf_sl_lor_v.loan_number%TYPE,

96: WHERE loan_id = x_loan_id FOR UPDATE OF igf_sl_lor.pnote_status NOWAIT;
97:
98: CURSOR c_dl_orig_recs( x_ci_cal_type igf_sl_lor_v.ci_cal_type%TYPE,
99: x_ci_sequence_number igf_sl_lor_v.ci_sequence_number%TYPE,
100: x_loan_number igf_sl_lor_v.loan_number%TYPE,
101: x_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
102: x_pnote_status igf_sl_lor_v.pnote_status%TYPE,
103: x_lookup_type igf_lookups_view.lookup_type%TYPE
104: ) IS

Line 102: x_pnote_status igf_sl_lor_v.pnote_status%TYPE,

98: CURSOR c_dl_orig_recs( x_ci_cal_type igf_sl_lor_v.ci_cal_type%TYPE,
99: x_ci_sequence_number igf_sl_lor_v.ci_sequence_number%TYPE,
100: x_loan_number igf_sl_lor_v.loan_number%TYPE,
101: x_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
102: x_pnote_status igf_sl_lor_v.pnote_status%TYPE,
103: x_lookup_type igf_lookups_view.lookup_type%TYPE
104: ) IS
105: SELECT lor.loan_id
106: FROM igf_sl_lor_v lor, igf_ap_fa_base_rec fa

Line 106: FROM igf_sl_lor_v lor, igf_ap_fa_base_rec fa

102: x_pnote_status igf_sl_lor_v.pnote_status%TYPE,
103: x_lookup_type igf_lookups_view.lookup_type%TYPE
104: ) IS
105: SELECT lor.loan_id
106: FROM igf_sl_lor_v lor, igf_ap_fa_base_rec fa
107: WHERE lor.pnote_status = x_pnote_status AND
108: lor.student_id = fa.person_id AND
109: fa.base_id = NVL(x_base_id,fa.base_id) AND
110: lor.fed_fund_code IN ( SELECT DISTINCT lookup_code

Line 158: FROM igf_sl_lor lor,

154: parent.given_names p_first_name,
155: parent.surname p_last_name,
156: parent.middle_name p_middle_name,
157: parent.birth_dt p_date_of_birth
158: FROM igf_sl_lor lor,
159: igf_sl_loans loans,
160: igf_aw_award awd,
161: igf_ap_fa_base_rec fa,
162: igf_ap_person_v prsn,

Line 175: FROM igf_sl_lor_v

171:
172: --Get the Student Person,Parent Person and Loan Number for the current Loan ID
173: CURSOR cur_get_loans(p_ln_id igf_sl_loans_all.loan_id%TYPE) IS
174: SELECT student_id,p_person_id,loan_number
175: FROM igf_sl_lor_v
176: WHERE loan_id=p_ln_id;
177:
178: l_loan_rec cur_get_loans%ROWTYPE;
179: l_loan_rec_det cur_get_loans%ROWTYPE;

Line 206: l_pnote_status igf_sl_lor_v.pnote_status%TYPE;

202: r_stafford_det c_stafford_det%ROWTYPE;
203: r_plus_det c_plus_det%ROWTYPE;
204:
205: l_lookup_type igf_lookups_view.lookup_type%TYPE;
206: l_pnote_status igf_sl_lor_v.pnote_status%TYPE;
207:
208: l_current_per_num igf_aw_award_v.person_number%TYPE;
209:
210: SKIP_LOAN_RECORD EXCEPTION;

Line 241: -- Update pnote status in igf_sl_lor table from G to P

237: --Created by : veramach, Oracle India
238: --Date created: 22-SEP-2003
239: --
240: --Purpose:
241: -- Update pnote status in igf_sl_lor table from G to P
242: --
243: --Known limitations/enhancements and/or remarks:
244: --
245: --Change History:

Line 249: -- TBH Impact change done in igf_sl_lor_pkg.update_row().

245: --Change History:
246: --Who When What
247: -------------------------------------------------------------------------------------
248: --akomurav 28-FEB-2006 Build FA161 and FA162.
249: -- TBH Impact change done in igf_sl_lor_pkg.update_row().
250: ----------------------------------------------------------------------------------
251: --bkkumar 06-oct-2003 Bug 3104228 FA 122 Loans Enhancements
252: -- Impact of adding the relationship_cd
253: -- in igf_sl_lor_all table and obsoleting

Line 253: -- in igf_sl_lor_all table and obsoleting

249: -- TBH Impact change done in igf_sl_lor_pkg.update_row().
250: ----------------------------------------------------------------------------------
251: --bkkumar 06-oct-2003 Bug 3104228 FA 122 Loans Enhancements
252: -- Impact of adding the relationship_cd
253: -- in igf_sl_lor_all table and obsoleting
254: -- BORW_LENDER_ID, DUNS_BORW_LENDER_ID,
255: -- GUARANTOR_ID, DUNS_GUARNT_ID,
256: -- LENDER_ID, DUNS_LENDER_ID
257: -- LEND_NON_ED_BRC_ID, RECIPIENT_ID

Line 264: -- chg_batch_id,appl_send_error_codes from igf_sl_lor

260: ----------------------------------------------------------------------------------
261: --veramach 23-SEP-2003 Bug 3104228: Obsoleted lend_apprv_denied_code,lend_apprv_denied_date,cl_rec_status_last_update,
262: -- cl_rec_status,mpn_confirm_code,appl_loan_phase_code_chg,appl_loan_phase_code,
263: -- p_ssn_chg_date,p_dob_chg_date,s_ssn_chg_date,s_dob_chg_date,s_local_addr_chg_date,
264: -- chg_batch_id,appl_send_error_codes from igf_sl_lor
265: -------------------------------------------------------------------
266:
267: BEGIN
268: /* If the loan id is processed,

Line 275: l_debug_str := l_debug_str || ' Before updating igf_sl_lor : loan_id ' || p_loan_id;

271: FOR r_dl_lor_rec IN c_lor_rec( p_loan_id )
272: LOOP
273: BEGIN
274: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_runtime_level) THEN
275: l_debug_str := l_debug_str || ' Before updating igf_sl_lor : loan_id ' || p_loan_id;
276: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_print_pnote.update_pnote_status.debug', l_debug_str);
277: l_debug_str := NULL;
278: END IF;
279:

Line 280: igf_sl_lor_pkg.update_row (

276: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_print_pnote.update_pnote_status.debug', l_debug_str);
277: l_debug_str := NULL;
278: END IF;
279:
280: igf_sl_lor_pkg.update_row (
281: X_mode => 'R',
282: x_rowid => r_dl_lor_rec.row_id,
283: x_origination_id => r_dl_lor_rec.origination_id,
284: x_loan_id => p_loan_id,

Line 409: l_debug_str := l_debug_str || 'Updated igf_sl_lor : loan_id ' || p_loan_id;

405: x_acad_begin_date => r_dl_lor_rec.acad_begin_date,
406: x_acad_end_date => r_dl_lor_rec.acad_end_date
407: );
408: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_runtime_level) THEN
409: l_debug_str := l_debug_str || 'Updated igf_sl_lor : loan_id ' || p_loan_id;
410: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_print_pnote.update_pnote_status.debug', l_debug_str);
411: l_debug_str := NULL;
412: END IF;
413: