APPS.IGF_SL_AWARD dependencies on IGS_CA_INST_ALL

Line 32: PROCEDURE get_loan_amts(p_ci_cal_type IN igs_ca_inst_all.cal_type%TYPE,

28: g_rel_code igf_sl_cl_setup.relationship_cd%TYPE;
29: g_person_id igf_sl_cl_pref_lenders.person_id%TYPE;
30: g_party_id igf_sl_cl_setup.party_id%TYPE;
31:
32: PROCEDURE get_loan_amts(p_ci_cal_type IN igs_ca_inst_all.cal_type%TYPE,
33: p_ci_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
34: p_fed_fund_code IN igf_aw_fund_cat_all.fed_fund_code%TYPE,
35: p_gross_amt IN igf_aw_awd_disb_all.disb_gross_amt%TYPE,
36: p_rebate_amt OUT NOCOPY igf_aw_awd_disb_all.int_rebate_amt%TYPE,

Line 33: p_ci_seq_num IN igs_ca_inst_all.sequence_number%TYPE,

29: g_person_id igf_sl_cl_pref_lenders.person_id%TYPE;
30: g_party_id igf_sl_cl_setup.party_id%TYPE;
31:
32: PROCEDURE get_loan_amts(p_ci_cal_type IN igs_ca_inst_all.cal_type%TYPE,
33: p_ci_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
34: p_fed_fund_code IN igf_aw_fund_cat_all.fed_fund_code%TYPE,
35: p_gross_amt IN igf_aw_awd_disb_all.disb_gross_amt%TYPE,
36: p_rebate_amt OUT NOCOPY igf_aw_awd_disb_all.int_rebate_amt%TYPE,
37: p_loan_fee_amt OUT NOCOPY igf_aw_awd_disb_all.fee_1%TYPE,

Line 48: p_cal_type IN igs_ca_inst_all.cal_type%TYPE,

44: --
45: -----------------------------------------------------------------------------------
46: PROCEDURE pick_setup(
47: p_base_id IN igf_aw_award_all.base_id%TYPE,
48: p_cal_type IN igs_ca_inst_all.cal_type%TYPE,
49: p_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
50: p_rel_code OUT NOCOPY igf_sl_cl_setup.relationship_cd%TYPE,
51: p_person_id OUT NOCOPY igf_sl_cl_pref_lenders.person_id%TYPE,
52: p_party_id OUT NOCOPY igf_sl_cl_setup.party_id%TYPE,

Line 49: p_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,

45: -----------------------------------------------------------------------------------
46: PROCEDURE pick_setup(
47: p_base_id IN igf_aw_award_all.base_id%TYPE,
48: p_cal_type IN igs_ca_inst_all.cal_type%TYPE,
49: p_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
50: p_rel_code OUT NOCOPY igf_sl_cl_setup.relationship_cd%TYPE,
51: p_person_id OUT NOCOPY igf_sl_cl_pref_lenders.person_id%TYPE,
52: p_party_id OUT NOCOPY igf_sl_cl_setup.party_id%TYPE,
53: p_alt_rel_code IN igf_aw_fund_cat_all.alt_rel_code%TYPE DEFAULT NULL

Line 98: p_cal_type IN igs_ca_inst_all.cal_type%TYPE,

94: RETURN VARCHAR2;
95:
96: PROCEDURE recalc_fees(
97: p_base_id IN igf_aw_award_all.base_id%TYPE,
98: p_cal_type IN igs_ca_inst_all.cal_type%TYPE,
99: p_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
100: p_rel_code IN igf_sl_cl_setup.relationship_cd%TYPE,
101: p_award_id IN igf_sl_loans.award_id%TYPE
102: );

Line 99: p_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,

95:
96: PROCEDURE recalc_fees(
97: p_base_id IN igf_aw_award_all.base_id%TYPE,
98: p_cal_type IN igs_ca_inst_all.cal_type%TYPE,
99: p_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
100: p_rel_code IN igf_sl_cl_setup.relationship_cd%TYPE,
101: p_award_id IN igf_sl_loans.award_id%TYPE
102: );
103: