DBA Data[Home] [Help]

APPS.IGS_EN_GEN_014 dependencies on IGS_EN_SU_ATTEMPT_ALL

Line 17: p_person_id IGS_EN_SU_ATTEMPT_ALL.person_id%TYPE ,

13: -- as a part of Bug# 3784635
14: -------------------------------------------------------------------------------------------
15:
16: Function Enrs_Clc_Sua_Cp(
17: p_person_id IGS_EN_SU_ATTEMPT_ALL.person_id%TYPE ,
18: p_course_cd IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,
19: p_crv_version_number IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,
20: p_unit_cd IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,
21: p_unit_version_number IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,

Line 20: p_unit_cd IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,

16: Function Enrs_Clc_Sua_Cp(
17: p_person_id IGS_EN_SU_ATTEMPT_ALL.person_id%TYPE ,
18: p_course_cd IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,
19: p_crv_version_number IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,
20: p_unit_cd IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,
21: p_unit_version_number IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,
22: p_teach_cal_type IGS_EN_SU_ATTEMPT_ALL.cal_type%TYPE ,
23: p_teach_sequence_number IGS_EN_SU_ATTEMPT_ALL.ci_sequence_number%TYPE ,
24: p_uoo_id IN NUMBER ,

Line 21: p_unit_version_number IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,

17: p_person_id IGS_EN_SU_ATTEMPT_ALL.person_id%TYPE ,
18: p_course_cd IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,
19: p_crv_version_number IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,
20: p_unit_cd IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,
21: p_unit_version_number IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,
22: p_teach_cal_type IGS_EN_SU_ATTEMPT_ALL.cal_type%TYPE ,
23: p_teach_sequence_number IGS_EN_SU_ATTEMPT_ALL.ci_sequence_number%TYPE ,
24: p_uoo_id IN NUMBER ,
25: p_load_cal_type IGS_CA_INST_ALL.cal_type%TYPE ,

Line 22: p_teach_cal_type IGS_EN_SU_ATTEMPT_ALL.cal_type%TYPE ,

18: p_course_cd IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,
19: p_crv_version_number IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,
20: p_unit_cd IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,
21: p_unit_version_number IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,
22: p_teach_cal_type IGS_EN_SU_ATTEMPT_ALL.cal_type%TYPE ,
23: p_teach_sequence_number IGS_EN_SU_ATTEMPT_ALL.ci_sequence_number%TYPE ,
24: p_uoo_id IN NUMBER ,
25: p_load_cal_type IGS_CA_INST_ALL.cal_type%TYPE ,
26: p_load_sequence_number IGS_CA_INST_ALL.sequence_number%TYPE ,

Line 23: p_teach_sequence_number IGS_EN_SU_ATTEMPT_ALL.ci_sequence_number%TYPE ,

19: p_crv_version_number IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,
20: p_unit_cd IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,
21: p_unit_version_number IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,
22: p_teach_cal_type IGS_EN_SU_ATTEMPT_ALL.cal_type%TYPE ,
23: p_teach_sequence_number IGS_EN_SU_ATTEMPT_ALL.ci_sequence_number%TYPE ,
24: p_uoo_id IN NUMBER ,
25: p_load_cal_type IGS_CA_INST_ALL.cal_type%TYPE ,
26: p_load_sequence_number IGS_CA_INST_ALL.sequence_number%TYPE ,
27: p_override_enrolled_cp IN NUMBER ,

Line 63: p_person_id IGS_EN_SU_ATTEMPT_ALL.person_id%TYPE ,

59: END;
60: END enrs_clc_sua_cp;
61:
62: Function Enrs_Clc_Sua_Eftsu(
63: p_person_id IGS_EN_SU_ATTEMPT_ALL.person_id%TYPE ,
64: p_course_cd IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,
65: p_crv_version_number IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,
66: p_unit_cd IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,
67: p_unit_version_number IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,

Line 66: p_unit_cd IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,

62: Function Enrs_Clc_Sua_Eftsu(
63: p_person_id IGS_EN_SU_ATTEMPT_ALL.person_id%TYPE ,
64: p_course_cd IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,
65: p_crv_version_number IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,
66: p_unit_cd IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,
67: p_unit_version_number IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,
68: p_teach_cal_type IGS_EN_SU_ATTEMPT_ALL.cal_type%TYPE ,
69: p_teach_sequence_number IGS_EN_SU_ATTEMPT_ALL.ci_sequence_number%TYPE ,
70: p_uoo_id IN NUMBER ,

Line 67: p_unit_version_number IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,

63: p_person_id IGS_EN_SU_ATTEMPT_ALL.person_id%TYPE ,
64: p_course_cd IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,
65: p_crv_version_number IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,
66: p_unit_cd IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,
67: p_unit_version_number IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,
68: p_teach_cal_type IGS_EN_SU_ATTEMPT_ALL.cal_type%TYPE ,
69: p_teach_sequence_number IGS_EN_SU_ATTEMPT_ALL.ci_sequence_number%TYPE ,
70: p_uoo_id IN NUMBER ,
71: p_load_cal_type IGS_CA_INST_ALL.cal_type%TYPE ,

Line 68: p_teach_cal_type IGS_EN_SU_ATTEMPT_ALL.cal_type%TYPE ,

64: p_course_cd IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,
65: p_crv_version_number IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,
66: p_unit_cd IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,
67: p_unit_version_number IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,
68: p_teach_cal_type IGS_EN_SU_ATTEMPT_ALL.cal_type%TYPE ,
69: p_teach_sequence_number IGS_EN_SU_ATTEMPT_ALL.ci_sequence_number%TYPE ,
70: p_uoo_id IN NUMBER ,
71: p_load_cal_type IGS_CA_INST_ALL.cal_type%TYPE ,
72: p_load_sequence_number IGS_CA_INST_ALL.sequence_number%TYPE ,

Line 69: p_teach_sequence_number IGS_EN_SU_ATTEMPT_ALL.ci_sequence_number%TYPE ,

65: p_crv_version_number IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,
66: p_unit_cd IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,
67: p_unit_version_number IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,
68: p_teach_cal_type IGS_EN_SU_ATTEMPT_ALL.cal_type%TYPE ,
69: p_teach_sequence_number IGS_EN_SU_ATTEMPT_ALL.ci_sequence_number%TYPE ,
70: p_uoo_id IN NUMBER ,
71: p_load_cal_type IGS_CA_INST_ALL.cal_type%TYPE ,
72: p_load_sequence_number IGS_CA_INST_ALL.sequence_number%TYPE ,
73: p_override_enrolled_cp IN NUMBER ,