DBA Data[Home] [Help]

APPS.IGS_EN_GEN_014 dependencies on IGS_EN_SU_ATTEMPT_ALL

Line 14: p_person_id IGS_EN_SU_ATTEMPT_ALL.person_id%TYPE ,

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

Line 17: p_unit_cd IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,

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

Line 18: p_unit_version_number IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,

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

Line 19: p_teach_cal_type IGS_EN_SU_ATTEMPT_ALL.cal_type%TYPE ,

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

Line 20: p_teach_sequence_number IGS_EN_SU_ATTEMPT_ALL.ci_sequence_number%TYPE ,

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

Line 34: p_person_id IGS_EN_SU_ATTEMPT_ALL.person_id%TYPE ,

30: RETURN NUMBER;
31: PRAGMA RESTRICT_REFERENCES(Enrs_Clc_Sua_Cp, WNDS, WNPS);
32:
33: Function Enrs_Clc_Sua_Eftsu(
34: p_person_id IGS_EN_SU_ATTEMPT_ALL.person_id%TYPE ,
35: p_course_cd IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,
36: p_crv_version_number IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,
37: p_unit_cd IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,
38: p_unit_version_number IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,

Line 37: p_unit_cd IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,

33: Function Enrs_Clc_Sua_Eftsu(
34: p_person_id IGS_EN_SU_ATTEMPT_ALL.person_id%TYPE ,
35: p_course_cd IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,
36: p_crv_version_number IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,
37: p_unit_cd IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,
38: p_unit_version_number IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,
39: p_teach_cal_type IGS_EN_SU_ATTEMPT_ALL.cal_type%TYPE ,
40: p_teach_sequence_number IGS_EN_SU_ATTEMPT_ALL.ci_sequence_number%TYPE ,
41: p_uoo_id IN NUMBER ,

Line 38: p_unit_version_number IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,

34: p_person_id IGS_EN_SU_ATTEMPT_ALL.person_id%TYPE ,
35: p_course_cd IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,
36: p_crv_version_number IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,
37: p_unit_cd IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,
38: p_unit_version_number IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,
39: p_teach_cal_type IGS_EN_SU_ATTEMPT_ALL.cal_type%TYPE ,
40: p_teach_sequence_number IGS_EN_SU_ATTEMPT_ALL.ci_sequence_number%TYPE ,
41: p_uoo_id IN NUMBER ,
42: p_load_cal_type IGS_CA_INST_ALL.cal_type%TYPE ,

Line 39: p_teach_cal_type IGS_EN_SU_ATTEMPT_ALL.cal_type%TYPE ,

35: p_course_cd IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,
36: p_crv_version_number IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,
37: p_unit_cd IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,
38: p_unit_version_number IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,
39: p_teach_cal_type IGS_EN_SU_ATTEMPT_ALL.cal_type%TYPE ,
40: p_teach_sequence_number IGS_EN_SU_ATTEMPT_ALL.ci_sequence_number%TYPE ,
41: p_uoo_id IN NUMBER ,
42: p_load_cal_type IGS_CA_INST_ALL.cal_type%TYPE ,
43: p_load_sequence_number IGS_CA_INST_ALL.sequence_number%TYPE ,

Line 40: p_teach_sequence_number IGS_EN_SU_ATTEMPT_ALL.ci_sequence_number%TYPE ,

36: p_crv_version_number IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,
37: p_unit_cd IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,
38: p_unit_version_number IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,
39: p_teach_cal_type IGS_EN_SU_ATTEMPT_ALL.cal_type%TYPE ,
40: p_teach_sequence_number IGS_EN_SU_ATTEMPT_ALL.ci_sequence_number%TYPE ,
41: p_uoo_id IN NUMBER ,
42: p_load_cal_type IGS_CA_INST_ALL.cal_type%TYPE ,
43: p_load_sequence_number IGS_CA_INST_ALL.sequence_number%TYPE ,
44: p_override_enrolled_cp IN NUMBER ,