DBA Data[Home] [Help]

APPS.IGF_SP_GEN_001 dependencies on IGS_CA_INST

Line 27: p_v_fee_cal_type IN igs_ca_inst_all.cal_type%TYPE,

23:
24: -------------------------------------------------------------------------------------
25:
26: PROCEDURE get_sponsor_amts ( p_n_person_id IN hz_parties.party_id%TYPE,
27: p_v_fee_cal_type IN igs_ca_inst_all.cal_type%TYPE,
28: p_n_fee_seq_number IN igs_ca_inst_all.sequence_number%TYPE,
29: p_v_fund_code IN igf_aw_fund_cat_all.fund_code%TYPE,
30: p_v_ld_cal_type IN igs_ca_inst_all.cal_type%TYPE,
31: p_n_ld_seq_number IN igs_ca_inst_all.sequence_number%TYPE,

Line 28: p_n_fee_seq_number IN igs_ca_inst_all.sequence_number%TYPE,

24: -------------------------------------------------------------------------------------
25:
26: PROCEDURE get_sponsor_amts ( p_n_person_id IN hz_parties.party_id%TYPE,
27: p_v_fee_cal_type IN igs_ca_inst_all.cal_type%TYPE,
28: p_n_fee_seq_number IN igs_ca_inst_all.sequence_number%TYPE,
29: p_v_fund_code IN igf_aw_fund_cat_all.fund_code%TYPE,
30: p_v_ld_cal_type IN igs_ca_inst_all.cal_type%TYPE,
31: p_n_ld_seq_number IN igs_ca_inst_all.sequence_number%TYPE,
32: p_v_fee_class IN igs_fi_fee_type_all.fee_class%TYPE,

Line 30: p_v_ld_cal_type IN igs_ca_inst_all.cal_type%TYPE,

26: PROCEDURE get_sponsor_amts ( p_n_person_id IN hz_parties.party_id%TYPE,
27: p_v_fee_cal_type IN igs_ca_inst_all.cal_type%TYPE,
28: p_n_fee_seq_number IN igs_ca_inst_all.sequence_number%TYPE,
29: p_v_fund_code IN igf_aw_fund_cat_all.fund_code%TYPE,
30: p_v_ld_cal_type IN igs_ca_inst_all.cal_type%TYPE,
31: p_n_ld_seq_number IN igs_ca_inst_all.sequence_number%TYPE,
32: p_v_fee_class IN igs_fi_fee_type_all.fee_class%TYPE,
33: p_v_course_cd IN igs_fi_inv_int_all.course_cd%TYPE,
34: p_v_unit_cd IN igs_ps_unit_ofr_opt.unit_cd%TYPE,

Line 31: p_n_ld_seq_number IN igs_ca_inst_all.sequence_number%TYPE,

27: p_v_fee_cal_type IN igs_ca_inst_all.cal_type%TYPE,
28: p_n_fee_seq_number IN igs_ca_inst_all.sequence_number%TYPE,
29: p_v_fund_code IN igf_aw_fund_cat_all.fund_code%TYPE,
30: p_v_ld_cal_type IN igs_ca_inst_all.cal_type%TYPE,
31: p_n_ld_seq_number IN igs_ca_inst_all.sequence_number%TYPE,
32: p_v_fee_class IN igs_fi_fee_type_all.fee_class%TYPE,
33: p_v_course_cd IN igs_fi_inv_int_all.course_cd%TYPE,
34: p_v_unit_cd IN igs_ps_unit_ofr_opt.unit_cd%TYPE,
35: p_n_unit_ver_num IN igs_ps_unit_ofr_opt_all.version_number%TYPE,

Line 42: p_ld_cal_type IN igs_ca_inst.cal_type%TYPE,

38: );
39:
40: FUNCTION check_unit_attempt
41: (p_person_id IN igs_pe_person.person_id%TYPE,
42: p_ld_cal_type IN igs_ca_inst.cal_type%TYPE,
43: p_ld_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
44: p_course_cd IN igs_ps_ver.course_cd%TYPE,
45: p_course_version_number IN igs_ps_ver.version_number%TYPE,
46: p_unit_cd IN igs_ps_unit_ver.unit_cd%TYPE,

Line 43: p_ld_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,

39:
40: FUNCTION check_unit_attempt
41: (p_person_id IN igs_pe_person.person_id%TYPE,
42: p_ld_cal_type IN igs_ca_inst.cal_type%TYPE,
43: p_ld_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
44: p_course_cd IN igs_ps_ver.course_cd%TYPE,
45: p_course_version_number IN igs_ps_ver.version_number%TYPE,
46: p_unit_cd IN igs_ps_unit_ver.unit_cd%TYPE,
47: p_unit_version_number IN igs_ps_unit_ver.version_number%TYPE,