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_CHG_PRC dependencies on IGF_SL_CLCHSN_DTLS

Line 31: PROCEDURE validate_chg (p_n_clchgsnd_id IN igf_sl_clchsn_dtls.clchgsnd_id%TYPE,

27:
28: FUNCTION validate_ssn ( p_n_person_id igf_ap_fa_base_rec_all.person_id%TYPE)
29: RETURN BOOLEAN;
30:
31: PROCEDURE validate_chg (p_n_clchgsnd_id IN igf_sl_clchsn_dtls.clchgsnd_id%TYPE,
32: p_b_return_status OUT NOCOPY BOOLEAN,
33: p_v_message_name OUT NOCOPY VARCHAR2,
34: p_t_message_tokens OUT NOCOPY token_tab%TYPE
35: ) AS

Line 62: CURSOR c_igf_sl_clchsn_dtls (cp_n_clchgsnd_id igf_sl_clchsn_dtls.clchgsnd_id%TYPE) IS

58: igf_sl_loans_v islv
59: WHERE isl.loan_id = islv.loan_id and
60: isl.loan_id = cp_n_loan_id;
61:
62: CURSOR c_igf_sl_clchsn_dtls (cp_n_clchgsnd_id igf_sl_clchsn_dtls.clchgsnd_id%TYPE) IS
63: SELECT clchgsnd.award_id
64: ,clchgsnd.loan_number_txt
65: FROM igf_sl_clchsn_dtls clchgsnd
66: WHERE clchgsnd.clchgsnd_id = cp_n_clchgsnd_id;

Line 65: FROM igf_sl_clchsn_dtls clchgsnd

61:
62: CURSOR c_igf_sl_clchsn_dtls (cp_n_clchgsnd_id igf_sl_clchsn_dtls.clchgsnd_id%TYPE) IS
63: SELECT clchgsnd.award_id
64: ,clchgsnd.loan_number_txt
65: FROM igf_sl_clchsn_dtls clchgsnd
66: WHERE clchgsnd.clchgsnd_id = cp_n_clchgsnd_id;
67:
68: CURSOR c_igf_sl_loans (cp_v_loan_number igf_sl_loans_all.loan_number%TYPE) IS
69: SELECT lar.loan_id

Line 96: l_n_clchgsnd_id igf_sl_clchsn_dtls.clchgsnd_id%TYPE;

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;
98: l_v_loan_number igf_sl_loans_all.loan_number%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;

Line 138: OPEN c_igf_sl_clchsn_dtls (cp_n_clchgsnd_id => l_n_clchgsnd_id);

134: --p_v_message_name would be set and p_b_return_status would be set to FALSE
135: l_n_clchgsnd_id := p_n_clchgsnd_id;
136:
137: -- validating the loan type code
138: OPEN c_igf_sl_clchsn_dtls (cp_n_clchgsnd_id => l_n_clchgsnd_id);
139: FETCH c_igf_sl_clchsn_dtls INTO l_n_award_id,l_v_loan_number;
140: CLOSE c_igf_sl_clchsn_dtls;
141:
142: log_to_fnd(p_v_module => ' validate_chg',

Line 139: FETCH c_igf_sl_clchsn_dtls INTO l_n_award_id,l_v_loan_number;

135: l_n_clchgsnd_id := p_n_clchgsnd_id;
136:
137: -- validating the loan type code
138: OPEN c_igf_sl_clchsn_dtls (cp_n_clchgsnd_id => l_n_clchgsnd_id);
139: FETCH c_igf_sl_clchsn_dtls INTO l_n_award_id,l_v_loan_number;
140: CLOSE c_igf_sl_clchsn_dtls;
141:
142: log_to_fnd(p_v_module => ' validate_chg',
143: p_v_string => ' Validating the loan type code for award id = '||l_n_award_id

Line 140: CLOSE c_igf_sl_clchsn_dtls;

136:
137: -- validating the loan type code
138: OPEN c_igf_sl_clchsn_dtls (cp_n_clchgsnd_id => l_n_clchgsnd_id);
139: FETCH c_igf_sl_clchsn_dtls INTO l_n_award_id,l_v_loan_number;
140: CLOSE c_igf_sl_clchsn_dtls;
141:
142: log_to_fnd(p_v_module => ' validate_chg',
143: p_v_string => ' Validating the loan type code for award id = '||l_n_award_id
144: );