1 PACKAGE IGF_AP_GEN_001 AS
2 /* $Header: IGFAP44S.pls 120.1 2005/07/05 08:39:51 appldev ship $ */
3
4 -- Function to get Program Attempt Start Date
5 FUNCTION get_prog_att_start_dt(cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE)
6 RETURN DATE;
7
8 -- Function to get Anticipated Completion Date
9 FUNCTION get_anticip_compl_date(cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE)
10 RETURN DATE;
11
12 -- Function to get Class Standing
13 FUNCTION get_class_standing(cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE)
14 RETURN VARCHAR2;
15
16 -- Function to get Program Type
17 FUNCTION get_enrl_program_type(cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE)
18 RETURN VARCHAR2;
19
20 -- Function to get Key Program
21 PROCEDURE get_key_program(cp_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
22 cp_course_cd OUT NOCOPY VARCHAR2,
23 cp_version_number OUT NOCOPY NUMBER);
24
25 -- Procedure to get enrollment term record details
26 PROCEDURE get_term_enrlmnt_dtl(cp_fa_base_id IN IGF_AP_FA_BASE_REC_ALL.BASE_ID%TYPE,
27 cp_term_enr_dtl_rec OUT NOCOPY IGS_EN_SPA_TERMS%ROWTYPE);
28
29 FUNCTION get_enr_eff_dt_alias_val(cp_cal_type IN igs_Ca_inst.cal_type%TYPE,
30 cp_sequence_number IN igs_ca_inst.sequence_number%TYPE)
31 RETURN DATE;
32
33 --FA 156 Changes
34 ---Procedure to get Effective Term Dates
35 PROCEDURE get_term_dates(
36 p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
37 p_ld_cal_type IN igs_Ca_inst.cal_type%TYPE,
38 p_ld_sequence_number IN igs_ca_inst.sequence_number%TYPE,
39 p_ld_start_date OUT NOCOPY DATE,
40 p_ld_end_date OUT NOCOPY DATE
41 );
42
43 ---Procedure to get Effective Date
44 FUNCTION get_date_alias_val(
45 p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
46 p_cal_type IN igs_ca_inst.cal_type%TYPE,
47 p_sequence_number IN igs_ca_inst.sequence_number%TYPE,
48 p_date_alias IN igs_ca_da_inst.dt_alias%TYPE
49 ) RETURN DATE;
50
51 PROCEDURE get_context_data_for_term(
52 p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
53 p_ld_cal_type IN igs_ca_inst.cal_type%TYPE,
54 p_ld_sequence_number IN igs_ca_inst.sequence_number%TYPE,
55 p_program_cd OUT NOCOPY igs_ps_ver_all.course_cd%TYPE,
56 p_version_num OUT NOCOPY igs_ps_ver_all.version_number%TYPE,
57 p_program_type OUT NOCOPY igs_ps_ver_all.course_type%TYPE,
58 p_org_unit OUT NOCOPY igs_ps_ver_all.responsible_org_unit_cd%TYPE
59 );
60
61 END IGF_AP_GEN_001;