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_CL_VALIDATION dependencies on IGF_AP_FA_BASE_REC

Line 175: p_ci_cal_type IN igf_ap_fa_base_rec_all.ci_cal_type%TYPE,

171: END check_for_reqd;
172:
173:
174: FUNCTION cl_lar_validate(
175: p_ci_cal_type IN igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
176: p_ci_sequence_number IN igf_ap_fa_base_rec_all.ci_sequence_number%TYPE,
177: p_loan_number IN igf_sl_loans_all.loan_number%TYPE,
178: p_loan_catg IN igf_lookups_view.lookup_code%TYPE,
179: p_call_mode IN VARCHAR2,

Line 176: p_ci_sequence_number IN igf_ap_fa_base_rec_all.ci_sequence_number%TYPE,

172:
173:
174: FUNCTION cl_lar_validate(
175: p_ci_cal_type IN igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
176: p_ci_sequence_number IN igf_ap_fa_base_rec_all.ci_sequence_number%TYPE,
177: p_loan_number IN igf_sl_loans_all.loan_number%TYPE,
178: p_loan_catg IN igf_lookups_view.lookup_code%TYPE,
179: p_call_mode IN VARCHAR2,
180: p_school_id IN VARCHAR2,

Line 245: l_n_coa igf_ap_fa_base_rec_all.coa_f%TYPE;

241:
242: parent_dtl_rec igf_sl_gen.person_dtl_rec;
243: parent_dtl_cur igf_sl_gen.person_dtl_cur;
244:
245: l_n_coa igf_ap_fa_base_rec_all.coa_f%TYPE;
246: l_n_efc igf_ap_fa_base_rec_all.efc_f%TYPE;
247: l_n_pell_efc NUMBER;
248: l_n_efc_f NUMBER;
249: lvc_check_loan VARCHAR2(3);

Line 246: l_n_efc igf_ap_fa_base_rec_all.efc_f%TYPE;

242: parent_dtl_rec igf_sl_gen.person_dtl_rec;
243: parent_dtl_cur igf_sl_gen.person_dtl_cur;
244:
245: l_n_coa igf_ap_fa_base_rec_all.coa_f%TYPE;
246: l_n_efc igf_ap_fa_base_rec_all.efc_f%TYPE;
247: l_n_pell_efc NUMBER;
248: l_n_efc_f NUMBER;
249: lvc_check_loan VARCHAR2(3);
250: lv_complete BOOLEAN := TRUE;

Line 259: p_cal_type igf_ap_fa_base_rec.ci_cal_type%TYPE;

255: p_fed_fund_2 igf_aw_fund_cat.fed_fund_code%TYPE;
256: p_status_1 igf_sl_loans.loan_status%TYPE;
257: p_status_2 igf_sl_loans.loan_status%TYPE;
258: p_status_3 igf_sl_loans.loan_status%TYPE;
259: p_cal_type igf_ap_fa_base_rec.ci_cal_type%TYPE;
260: p_seq_number igf_ap_fa_base_rec.ci_sequence_number%TYPE;
261:
262: -- Query optimized by using the table igf_sl_cl_recipient instead of the view igf_sl_cl_recipient_v (bug #3691137)
263:

Line 260: p_seq_number igf_ap_fa_base_rec.ci_sequence_number%TYPE;

256: p_status_1 igf_sl_loans.loan_status%TYPE;
257: p_status_2 igf_sl_loans.loan_status%TYPE;
258: p_status_3 igf_sl_loans.loan_status%TYPE;
259: p_cal_type igf_ap_fa_base_rec.ci_cal_type%TYPE;
260: p_seq_number igf_ap_fa_base_rec.ci_sequence_number%TYPE;
261:
262: -- Query optimized by using the table igf_sl_cl_recipient instead of the view igf_sl_cl_recipient_v (bug #3691137)
263:
264: -- masehgal # 2593215 there was a call to begin/end date fetching functions of SL11B.

Line 278: p_cal_type igf_ap_fa_base_rec.ci_cal_type%TYPE,

274: p_fed_fund_2 igf_aw_fund_cat.fed_fund_code%TYPE,
275: p_status_1 igf_sl_loans.loan_status%TYPE,
276: p_status_2 igf_sl_loans.loan_status%TYPE,
277: p_status_3 igf_sl_loans.loan_status%TYPE,
278: p_cal_type igf_ap_fa_base_rec.ci_cal_type%TYPE,
279: p_seq_number igf_ap_fa_base_rec.ci_sequence_number%TYPE,
280: p_active igf_sl_loans.active%TYPE,
281: p_school_id VARCHAR2,
282: p_base_id VARCHAR2

Line 279: p_seq_number igf_ap_fa_base_rec.ci_sequence_number%TYPE,

275: p_status_1 igf_sl_loans.loan_status%TYPE,
276: p_status_2 igf_sl_loans.loan_status%TYPE,
277: p_status_3 igf_sl_loans.loan_status%TYPE,
278: p_cal_type igf_ap_fa_base_rec.ci_cal_type%TYPE,
279: p_seq_number igf_ap_fa_base_rec.ci_sequence_number%TYPE,
280: p_active igf_sl_loans.active%TYPE,
281: p_school_id VARCHAR2,
282: p_base_id VARCHAR2
283: )IS

Line 337: igf_ap_fa_base_rec fabase,

333: igf_sl_lor lor,
334: igf_aw_award awd,
335: igf_aw_fund_mast fmast,
336: igf_aw_fund_cat fcat,
337: igf_ap_fa_base_rec fabase,
338: igf_sl_cl_recipient recip
339: WHERE fabase.ci_cal_type = p_cal_type
340: AND fabase.ci_sequence_number = p_seq_number
341: AND fabase.base_id = awd.base_id

Line 596: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,

592: END LOOP;
593: END cl_alt_borr_cosig_validation;
594:
595: PROCEDURE loan_limit_validation (
596: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
597: p_fund_type IN igf_aw_fund_cat.fed_fund_code%TYPE,
598: p_award_id IN igf_aw_award_all.award_id%TYPE,
599: p_msg_name OUT NOCOPY fnd_new_messages.message_name%TYPE
600: )

Line 747: fnd_message.set_token('P_RECORD','IGF_AP_FA_BASE_REC');

743: FETCH cur_isir_depend_status INTO lv_dependency_status;
744: IF cur_isir_depend_status%NOTFOUND THEN
745: CLOSE cur_isir_depend_status;
746: fnd_message.set_name('IGF','IGF_GE_REC_NO_DATA_FOUND');
747: fnd_message.set_token('P_RECORD','IGF_AP_FA_BASE_REC');
748: igs_ge_msg_stack.add;
749: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
750: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate', 'cur_isir_depend_status cursor failed');
751: END IF;