APPS.IGF_SL_DL_PRINT_PNOTE dependencies on IGF_SL_LOANS

Line 59: p_loan_number IN igf_sl_loans_v.loan_number%TYPE,

55: RETCODE OUT NOCOPY NUMBER,
56: p_award_year IN VARCHAR2,
57: p_loan_catg IN igf_lookups_view.lookup_code%TYPE,
58: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
59: p_loan_number IN igf_sl_loans_v.loan_number%TYPE,
60: p_org_id IN NUMBER
61: )AS
62: /***************************************************************
63: Created By : avenkatr

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 129: FROM igf_sl_loans loans,

125: prsn.given_names,
126: prsn.surname,
127: prsn.middle_name,
128: prsn.birth_dt
129: FROM igf_sl_loans loans,
130: igf_aw_award awd,
131: igf_ap_fa_base_rec fa,
132: igf_ap_person_v prsn
133: WHERE loans.loan_id = x_loan_id

Line 139: x_loan_id igf_sl_loans.loan_id%TYPE

135: AND awd.base_id = fa.base_id
136: AND fa.person_id = prsn.person_id;
137:
138: CURSOR c_plus_det(
139: x_loan_id igf_sl_loans.loan_id%TYPE
140: ) IS
141: SELECT loans.loan_number,
142: awd.offered_amt loan_amt_offered,
143: awd.accepted_amt loan_amt_accepted,

Line 159: igf_sl_loans loans,

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,
163: igs_pe_person_v parent

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