APPS.IGF_SL_DL_PRINT_PNOTE dependencies on IGF_SL_LOANS_ALL

Line 120: x_loan_id igf_sl_loans_all.LOAN_ID%TYPE

116: fa.ci_cal_type = x_ci_cal_type AND
117: fa.ci_sequence_number = x_ci_sequence_number;
118:
119: CURSOR c_stafford_det(
120: x_loan_id igf_sl_loans_all.LOAN_ID%TYPE
121: ) IS
122: SELECT loans.loan_number,
123: fa.person_id student_id,
124: prsn.api_person_id s_ssn,

Line 173: CURSOR cur_get_loans(p_ln_id igf_sl_loans_all.loan_id%TYPE) IS

169: AND NVL( lor.p_person_id, 0) = parent.person_id (+);
170:
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:

Line 197: l_prnt_ln igf_sl_loans_all.loan_number%TYPE;

193: l_heading VARCHAR2(100);
194: l_stud_number igf_aw_award_v.person_number%TYPE;
195: l_parent_number igf_aw_award_v.person_number%TYPE;
196: l_ret BOOLEAN DEFAULT FALSE;
197: l_prnt_ln igf_sl_loans_all.loan_number%TYPE;
198:
199: r_pnote c_pnote_check%ROWTYPE;
200: r_dl_orig_rec c_dl_orig_recs%ROWTYPE;
201: r_dl_lor_rec c_lor_rec%ROWTYPE;

Line 213: PROCEDURE log_message(p_stud_id igf_ap_fa_base_rec_all.person_id%TYPE,p_ln_number igf_sl_loans_all.loan_number%TYPE) IS

209:
210: SKIP_LOAN_RECORD EXCEPTION;
211:
212: --Internal Procedure to display LOG Message
213: PROCEDURE log_message(p_stud_id igf_ap_fa_base_rec_all.person_id%TYPE,p_ln_number igf_sl_loans_all.loan_number%TYPE) IS
214: /***************************************************************
215: Created By : mesriniv
216: Date Created By : 2002/06/25
217: Purpose :

Line 234: p_loan_id igf_sl_loans_all.loan_id%TYPE

230: fnd_file.put_line(fnd_file.log,fnd_message.get);
231: END log_message;
232:
233: PROCEDURE update_pnote_status(
234: p_loan_id igf_sl_loans_all.loan_id%TYPE
235: ) AS
236: ------------------------------------------------------------------
237: --Created by : veramach, Oracle India
238: --Date created: 22-SEP-2003