DBA Data[Home] [Help]

APPS.IGS_EN_GEN_007 dependencies on IGS_EN_SU_ATTEMPT_H_ALL

Line 17: p_person_id IN IGS_EN_SU_ATTEMPT_H_ALL.person_id%TYPE ,

13: PRAGMA RESTRICT_REFERENCES(Enrp_Get_Student_Ind, WNDS);
14:
15: FUNCTION Enrp_Get_Suah_Col(
16: p_column_name IN user_tab_columns.column_name%TYPE ,
17: p_person_id IN IGS_EN_SU_ATTEMPT_H_ALL.person_id%TYPE ,
18: p_course_cd IN IGS_EN_SU_ATTEMPT_H_ALL.course_cd%TYPE ,
19: p_unit_cd IN IGS_EN_SU_ATTEMPT_H_ALL.unit_cd%TYPE ,
20: p_cal_type IN IGS_EN_SU_ATTEMPT_H_ALL.cal_type%TYPE ,
21: p_ci_sequence_number IN IGS_EN_SU_ATTEMPT_H_ALL.ci_sequence_number%TYPE ,

Line 18: p_course_cd IN IGS_EN_SU_ATTEMPT_H_ALL.course_cd%TYPE ,

14:
15: FUNCTION Enrp_Get_Suah_Col(
16: p_column_name IN user_tab_columns.column_name%TYPE ,
17: p_person_id IN IGS_EN_SU_ATTEMPT_H_ALL.person_id%TYPE ,
18: p_course_cd IN IGS_EN_SU_ATTEMPT_H_ALL.course_cd%TYPE ,
19: p_unit_cd IN IGS_EN_SU_ATTEMPT_H_ALL.unit_cd%TYPE ,
20: p_cal_type IN IGS_EN_SU_ATTEMPT_H_ALL.cal_type%TYPE ,
21: p_ci_sequence_number IN IGS_EN_SU_ATTEMPT_H_ALL.ci_sequence_number%TYPE ,
22: p_hist_end_dt IN IGS_EN_SU_ATTEMPT_H_ALL.hist_end_dt%TYPE,

Line 19: p_unit_cd IN IGS_EN_SU_ATTEMPT_H_ALL.unit_cd%TYPE ,

15: FUNCTION Enrp_Get_Suah_Col(
16: p_column_name IN user_tab_columns.column_name%TYPE ,
17: p_person_id IN IGS_EN_SU_ATTEMPT_H_ALL.person_id%TYPE ,
18: p_course_cd IN IGS_EN_SU_ATTEMPT_H_ALL.course_cd%TYPE ,
19: p_unit_cd IN IGS_EN_SU_ATTEMPT_H_ALL.unit_cd%TYPE ,
20: p_cal_type IN IGS_EN_SU_ATTEMPT_H_ALL.cal_type%TYPE ,
21: p_ci_sequence_number IN IGS_EN_SU_ATTEMPT_H_ALL.ci_sequence_number%TYPE ,
22: p_hist_end_dt IN IGS_EN_SU_ATTEMPT_H_ALL.hist_end_dt%TYPE,
23: p_uoo_id IN IGS_EN_SU_ATTEMPT_H_ALL.uoo_id%TYPE)

Line 20: p_cal_type IN IGS_EN_SU_ATTEMPT_H_ALL.cal_type%TYPE ,

16: p_column_name IN user_tab_columns.column_name%TYPE ,
17: p_person_id IN IGS_EN_SU_ATTEMPT_H_ALL.person_id%TYPE ,
18: p_course_cd IN IGS_EN_SU_ATTEMPT_H_ALL.course_cd%TYPE ,
19: p_unit_cd IN IGS_EN_SU_ATTEMPT_H_ALL.unit_cd%TYPE ,
20: p_cal_type IN IGS_EN_SU_ATTEMPT_H_ALL.cal_type%TYPE ,
21: p_ci_sequence_number IN IGS_EN_SU_ATTEMPT_H_ALL.ci_sequence_number%TYPE ,
22: p_hist_end_dt IN IGS_EN_SU_ATTEMPT_H_ALL.hist_end_dt%TYPE,
23: p_uoo_id IN IGS_EN_SU_ATTEMPT_H_ALL.uoo_id%TYPE)
24: RETURN VARCHAR2;

Line 21: p_ci_sequence_number IN IGS_EN_SU_ATTEMPT_H_ALL.ci_sequence_number%TYPE ,

17: p_person_id IN IGS_EN_SU_ATTEMPT_H_ALL.person_id%TYPE ,
18: p_course_cd IN IGS_EN_SU_ATTEMPT_H_ALL.course_cd%TYPE ,
19: p_unit_cd IN IGS_EN_SU_ATTEMPT_H_ALL.unit_cd%TYPE ,
20: p_cal_type IN IGS_EN_SU_ATTEMPT_H_ALL.cal_type%TYPE ,
21: p_ci_sequence_number IN IGS_EN_SU_ATTEMPT_H_ALL.ci_sequence_number%TYPE ,
22: p_hist_end_dt IN IGS_EN_SU_ATTEMPT_H_ALL.hist_end_dt%TYPE,
23: p_uoo_id IN IGS_EN_SU_ATTEMPT_H_ALL.uoo_id%TYPE)
24: RETURN VARCHAR2;
25: PRAGMA RESTRICT_REFERENCES(Enrp_Get_Suah_Col, WNDS);

Line 22: p_hist_end_dt IN IGS_EN_SU_ATTEMPT_H_ALL.hist_end_dt%TYPE,

18: p_course_cd IN IGS_EN_SU_ATTEMPT_H_ALL.course_cd%TYPE ,
19: p_unit_cd IN IGS_EN_SU_ATTEMPT_H_ALL.unit_cd%TYPE ,
20: p_cal_type IN IGS_EN_SU_ATTEMPT_H_ALL.cal_type%TYPE ,
21: p_ci_sequence_number IN IGS_EN_SU_ATTEMPT_H_ALL.ci_sequence_number%TYPE ,
22: p_hist_end_dt IN IGS_EN_SU_ATTEMPT_H_ALL.hist_end_dt%TYPE,
23: p_uoo_id IN IGS_EN_SU_ATTEMPT_H_ALL.uoo_id%TYPE)
24: RETURN VARCHAR2;
25: PRAGMA RESTRICT_REFERENCES(Enrp_Get_Suah_Col, WNDS);
26:

Line 23: p_uoo_id IN IGS_EN_SU_ATTEMPT_H_ALL.uoo_id%TYPE)

19: p_unit_cd IN IGS_EN_SU_ATTEMPT_H_ALL.unit_cd%TYPE ,
20: p_cal_type IN IGS_EN_SU_ATTEMPT_H_ALL.cal_type%TYPE ,
21: p_ci_sequence_number IN IGS_EN_SU_ATTEMPT_H_ALL.ci_sequence_number%TYPE ,
22: p_hist_end_dt IN IGS_EN_SU_ATTEMPT_H_ALL.hist_end_dt%TYPE,
23: p_uoo_id IN IGS_EN_SU_ATTEMPT_H_ALL.uoo_id%TYPE)
24: RETURN VARCHAR2;
25: PRAGMA RESTRICT_REFERENCES(Enrp_Get_Suah_Col, WNDS);
26:
27: FUNCTION Enrp_Get_Sua_Incur(