APPS.IGF_AP_GEN_001 dependencies on IGS_CA_INST

Line 29: FUNCTION get_enr_eff_dt_alias_val(cp_cal_type IN igs_Ca_inst.cal_type%TYPE,

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

Line 30: cp_sequence_number IN igs_ca_inst.sequence_number%TYPE)

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

Line 37: p_ld_cal_type IN igs_Ca_inst.cal_type%TYPE,

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

Line 38: p_ld_sequence_number IN igs_ca_inst.sequence_number%TYPE,

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:

Line 46: p_cal_type IN igs_ca_inst.cal_type%TYPE,

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:

Line 47: p_sequence_number IN igs_ca_inst.sequence_number%TYPE,

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(

Line 53: p_ld_cal_type IN igs_ca_inst.cal_type%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,

Line 54: p_ld_sequence_number IN igs_ca_inst.sequence_number%TYPE,

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