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.

[Home] [Help]

APPS.IGF_SL_CL_CHG_PRC dependencies on IGF_SL_CL_RECIPIENT

Line 90: CURSOR c_igf_sl_cl_recipient (cp_v_relationship_cd igf_sl_cl_recipient.relationship_cd%TYPE) IS

86: SELECT fabase.person_id
87: FROM igf_ap_fa_base_rec_all fabase
88: WHERE fabase.base_id = cp_n_base_id;
89:
90: CURSOR c_igf_sl_cl_recipient (cp_v_relationship_cd igf_sl_cl_recipient.relationship_cd%TYPE) IS
91: SELECT rcpt.guarantor_id
92: ,rcpt.lender_id
93: FROM igf_sl_cl_recipient rcpt
94: WHERE relationship_cd = cp_v_relationship_cd;

Line 93: FROM igf_sl_cl_recipient rcpt

89:
90: CURSOR c_igf_sl_cl_recipient (cp_v_relationship_cd igf_sl_cl_recipient.relationship_cd%TYPE) IS
91: SELECT rcpt.guarantor_id
92: ,rcpt.lender_id
93: FROM igf_sl_cl_recipient rcpt
94: WHERE relationship_cd = cp_v_relationship_cd;
95:
96: l_n_clchgsnd_id igf_sl_clchsn_dtls.clchgsnd_id%TYPE;
97: l_n_award_id igf_aw_award_all.award_id%TYPE;

Line 103: l_v_relationship_cd igf_sl_cl_recipient.relationship_cd%TYPE;

99: l_n_person_id igf_ap_fa_base_rec_all.person_id%TYPE;
100: l_n_loan_id igf_sl_loans_all.loan_id%TYPE;
101: l_v_school_id igs_pe_alt_pers_id.person_id_type%TYPE;
102: l_n_base_id igf_ap_fa_base_rec_all.base_id%TYPE;
103: l_v_relationship_cd igf_sl_cl_recipient.relationship_cd%TYPE;
104: l_v_guarantor_id igf_sl_guarantor.guarantor_id%TYPE;
105: l_v_lender_id igf_sl_lender.lender_id%TYPE;
106: l_n_cl_seq_number igf_sl_lor_all.cl_seq_number%TYPE;
107: l_v_fed_fund_code igf_aw_fund_cat_all.fed_fund_code%TYPE;

Line 247: OPEN c_igf_sl_cl_recipient (cp_v_relationship_cd => l_v_relationship_cd);

243: log_to_fnd(p_v_module => 'validate_chg',
244: p_v_string => 'Validating the Guarantor ID and Lender id required fields for relatioship code = '||l_v_relationship_cd
245: );
246:
247: OPEN c_igf_sl_cl_recipient (cp_v_relationship_cd => l_v_relationship_cd);
248: FETCH c_igf_sl_cl_recipient INTO l_v_guarantor_id ,l_v_lender_id;
249: CLOSE c_igf_sl_cl_recipient ;
250:
251: IF l_v_guarantor_id IS NULL THEN

Line 248: FETCH c_igf_sl_cl_recipient INTO l_v_guarantor_id ,l_v_lender_id;

244: p_v_string => 'Validating the Guarantor ID and Lender id required fields for relatioship code = '||l_v_relationship_cd
245: );
246:
247: OPEN c_igf_sl_cl_recipient (cp_v_relationship_cd => l_v_relationship_cd);
248: FETCH c_igf_sl_cl_recipient INTO l_v_guarantor_id ,l_v_lender_id;
249: CLOSE c_igf_sl_cl_recipient ;
250:
251: IF l_v_guarantor_id IS NULL THEN
252: p_v_message_name := 'IGF_SL_CL_CHG_GID_REQD';

Line 249: CLOSE c_igf_sl_cl_recipient ;

245: );
246:
247: OPEN c_igf_sl_cl_recipient (cp_v_relationship_cd => l_v_relationship_cd);
248: FETCH c_igf_sl_cl_recipient INTO l_v_guarantor_id ,l_v_lender_id;
249: CLOSE c_igf_sl_cl_recipient ;
250:
251: IF l_v_guarantor_id IS NULL THEN
252: p_v_message_name := 'IGF_SL_CL_CHG_GID_REQD';
253: p_b_return_status := FALSE;