DBA Data[Home] [Help]

APPS.IGS_EN_GEN_007 dependencies on IGS_EN_SU_ATTEMPT_H_ALL

Line 67: p_person_id IN IGS_EN_SU_ATTEMPT_H_ALL.person_id%TYPE ,

63: END enrp_get_student_ind;
64:
65: FUNCTION Enrp_Get_Suah_Col(
66: p_column_name IN user_tab_columns.column_name%TYPE ,
67: p_person_id IN IGS_EN_SU_ATTEMPT_H_ALL.person_id%TYPE ,
68: p_course_cd IN IGS_EN_SU_ATTEMPT_H_ALL.course_cd%TYPE ,
69: p_unit_cd IN IGS_EN_SU_ATTEMPT_H_ALL.unit_cd%TYPE ,
70: p_cal_type IN IGS_EN_SU_ATTEMPT_H_ALL.cal_type%TYPE ,
71: p_ci_sequence_number IN IGS_EN_SU_ATTEMPT_H_ALL.ci_sequence_number%TYPE ,

Line 68: p_course_cd IN IGS_EN_SU_ATTEMPT_H_ALL.course_cd%TYPE ,

64:
65: FUNCTION Enrp_Get_Suah_Col(
66: p_column_name IN user_tab_columns.column_name%TYPE ,
67: p_person_id IN IGS_EN_SU_ATTEMPT_H_ALL.person_id%TYPE ,
68: p_course_cd IN IGS_EN_SU_ATTEMPT_H_ALL.course_cd%TYPE ,
69: p_unit_cd IN IGS_EN_SU_ATTEMPT_H_ALL.unit_cd%TYPE ,
70: p_cal_type IN IGS_EN_SU_ATTEMPT_H_ALL.cal_type%TYPE ,
71: p_ci_sequence_number IN IGS_EN_SU_ATTEMPT_H_ALL.ci_sequence_number%TYPE ,
72: p_hist_end_dt IN IGS_EN_SU_ATTEMPT_H_ALL.hist_end_dt%TYPE,

Line 69: p_unit_cd IN IGS_EN_SU_ATTEMPT_H_ALL.unit_cd%TYPE ,

65: FUNCTION Enrp_Get_Suah_Col(
66: p_column_name IN user_tab_columns.column_name%TYPE ,
67: p_person_id IN IGS_EN_SU_ATTEMPT_H_ALL.person_id%TYPE ,
68: p_course_cd IN IGS_EN_SU_ATTEMPT_H_ALL.course_cd%TYPE ,
69: p_unit_cd IN IGS_EN_SU_ATTEMPT_H_ALL.unit_cd%TYPE ,
70: p_cal_type IN IGS_EN_SU_ATTEMPT_H_ALL.cal_type%TYPE ,
71: p_ci_sequence_number IN IGS_EN_SU_ATTEMPT_H_ALL.ci_sequence_number%TYPE ,
72: p_hist_end_dt IN IGS_EN_SU_ATTEMPT_H_ALL.hist_end_dt%TYPE,
73: p_uoo_id IN IGS_EN_SU_ATTEMPT_H_ALL.UOO_ID%TYPE)

Line 70: p_cal_type IN IGS_EN_SU_ATTEMPT_H_ALL.cal_type%TYPE ,

66: p_column_name IN user_tab_columns.column_name%TYPE ,
67: p_person_id IN IGS_EN_SU_ATTEMPT_H_ALL.person_id%TYPE ,
68: p_course_cd IN IGS_EN_SU_ATTEMPT_H_ALL.course_cd%TYPE ,
69: p_unit_cd IN IGS_EN_SU_ATTEMPT_H_ALL.unit_cd%TYPE ,
70: p_cal_type IN IGS_EN_SU_ATTEMPT_H_ALL.cal_type%TYPE ,
71: p_ci_sequence_number IN IGS_EN_SU_ATTEMPT_H_ALL.ci_sequence_number%TYPE ,
72: p_hist_end_dt IN IGS_EN_SU_ATTEMPT_H_ALL.hist_end_dt%TYPE,
73: p_uoo_id IN IGS_EN_SU_ATTEMPT_H_ALL.UOO_ID%TYPE)
74: -------------------------------------------------------------------------------------------

Line 71: p_ci_sequence_number IN IGS_EN_SU_ATTEMPT_H_ALL.ci_sequence_number%TYPE ,

67: p_person_id IN IGS_EN_SU_ATTEMPT_H_ALL.person_id%TYPE ,
68: p_course_cd IN IGS_EN_SU_ATTEMPT_H_ALL.course_cd%TYPE ,
69: p_unit_cd IN IGS_EN_SU_ATTEMPT_H_ALL.unit_cd%TYPE ,
70: p_cal_type IN IGS_EN_SU_ATTEMPT_H_ALL.cal_type%TYPE ,
71: p_ci_sequence_number IN IGS_EN_SU_ATTEMPT_H_ALL.ci_sequence_number%TYPE ,
72: p_hist_end_dt IN IGS_EN_SU_ATTEMPT_H_ALL.hist_end_dt%TYPE,
73: p_uoo_id IN IGS_EN_SU_ATTEMPT_H_ALL.UOO_ID%TYPE)
74: -------------------------------------------------------------------------------------------
75: --Change History:

Line 72: p_hist_end_dt IN IGS_EN_SU_ATTEMPT_H_ALL.hist_end_dt%TYPE,

68: p_course_cd IN IGS_EN_SU_ATTEMPT_H_ALL.course_cd%TYPE ,
69: p_unit_cd IN IGS_EN_SU_ATTEMPT_H_ALL.unit_cd%TYPE ,
70: p_cal_type IN IGS_EN_SU_ATTEMPT_H_ALL.cal_type%TYPE ,
71: p_ci_sequence_number IN IGS_EN_SU_ATTEMPT_H_ALL.ci_sequence_number%TYPE ,
72: p_hist_end_dt IN IGS_EN_SU_ATTEMPT_H_ALL.hist_end_dt%TYPE,
73: p_uoo_id IN IGS_EN_SU_ATTEMPT_H_ALL.UOO_ID%TYPE)
74: -------------------------------------------------------------------------------------------
75: --Change History:
76: --Who When What

Line 73: p_uoo_id IN IGS_EN_SU_ATTEMPT_H_ALL.UOO_ID%TYPE)

69: p_unit_cd IN IGS_EN_SU_ATTEMPT_H_ALL.unit_cd%TYPE ,
70: p_cal_type IN IGS_EN_SU_ATTEMPT_H_ALL.cal_type%TYPE ,
71: p_ci_sequence_number IN IGS_EN_SU_ATTEMPT_H_ALL.ci_sequence_number%TYPE ,
72: p_hist_end_dt IN IGS_EN_SU_ATTEMPT_H_ALL.hist_end_dt%TYPE,
73: p_uoo_id IN IGS_EN_SU_ATTEMPT_H_ALL.UOO_ID%TYPE)
74: -------------------------------------------------------------------------------------------
75: --Change History:
76: --Who When What
77: --kkillams 25-04-2003 New paramater p_uoo_id is added to the function and c_suah cursor modified.