APPS.IGF_SL_CL_CHG_PRC dependencies on IGF_AP_FA_BASE_REC_ALL

Line 28: FUNCTION validate_ssn ( p_n_person_id igf_ap_fa_base_rec_all.person_id%TYPE)

24: PROCEDURE log_to_fnd ( p_v_module IN VARCHAR2,
25: p_v_string IN VARCHAR2
26: );
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,

Line 85: CURSOR c_igf_ap_fa_base_rec (cp_n_base_id igf_ap_fa_base_rec_all.base_id%TYPE) IS

81: SELECT awd.base_id
82: FROM igf_aw_award_all awd
83: WHERE awd.award_id = cp_n_award_id;
84:
85: CURSOR c_igf_ap_fa_base_rec (cp_n_base_id igf_ap_fa_base_rec_all.base_id%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:

Line 87: FROM igf_ap_fa_base_rec_all fabase

83: WHERE awd.award_id = cp_n_award_id;
84:
85: CURSOR c_igf_ap_fa_base_rec (cp_n_base_id igf_ap_fa_base_rec_all.base_id%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

Line 99: l_n_person_id igf_ap_fa_base_rec_all.person_id%TYPE;

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;
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;

Line 102: l_n_base_id igf_ap_fa_base_rec_all.base_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;
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;

Line 379: FUNCTION validate_ssn ( p_n_person_id igf_ap_fa_base_rec_all.person_id%TYPE)

375: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_sl_cl_chg_prc. '||p_v_module||' Debug', p_v_string);
376: END IF;
377: END log_to_fnd;
378:
379: FUNCTION validate_ssn ( p_n_person_id igf_ap_fa_base_rec_all.person_id%TYPE)
380: RETURN BOOLEAN AS
381: ------------------------------------------------------------------
382: --Created by : Sanil Madathil, Oracle IDC
383: --Date created: 18 October 2004