1 PACKAGE IGF_SP_GEN_001 AS
2 /* $Header: IGFSP04S.pls 120.1 2006/05/15 23:51:36 svuppala noship $ */
3
4 ------------------------------------------------------------------------------------
5 --Created by : smanglm ( Oracle IDC)
6 --Date created: 2002/01/11
7 --
8 --Purpose: Created as part of the build for DLD Sponsorship
9 -- This package has generic fucntion which can be used by the system.
10 -- They are;
11 -- i) get_credit_points
12 -- ii) get_program_charge
13 -- iii) check_unit_attempt
14 -- iv) check_min_att_type
15 -- v) get_fee_cls_charge
16 --
17 --Known limitations/enhancements and/or remarks:
18 --
19 --Change History:
20 --Who When What
21 --svuppala 16-May-2006 Bug# 5194095 Replaced function get_program_charge by procedure get_sponsor_amts.
22 -- Removed get_fee_cls_charge.
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,
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,
36 x_eligible_amount OUT NOCOPY NUMBER,
37 x_new_spnsp_amount OUT NOCOPY NUMBER
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,
47 p_unit_version_number IN igs_ps_unit_ver.version_number%TYPE,
48 p_msg_count OUT NOCOPY NUMBER,
49 p_msg_data OUT NOCOPY VARCHAR2)
50 RETURN BOOLEAN;
51
52 END IGF_SP_GEN_001;