eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_EN_GEN_007 dependencies on IGS_EN_SU_ATTEMPT_H

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.

Line 86: cp_person_id IGS_EN_SU_ATTEMPT_H.person_id%TYPE,

82: BEGIN
83: DECLARE
84: CURSOR c_suah(
85: cp_column_name user_tab_columns.column_name%TYPE,
86: cp_person_id IGS_EN_SU_ATTEMPT_H.person_id%TYPE,
87: cp_course_cd IGS_EN_SU_ATTEMPT_H.course_cd%TYPE,
88: cp_uoo_id IGS_EN_SU_ATTEMPT_H.uoo_id%TYPE,
89: cp_hist_end_dt IGS_EN_SU_ATTEMPT_H.hist_end_dt%TYPE) IS
90: SELECT DECODE ( cp_column_name,

Line 87: cp_course_cd IGS_EN_SU_ATTEMPT_H.course_cd%TYPE,

83: DECLARE
84: CURSOR c_suah(
85: cp_column_name user_tab_columns.column_name%TYPE,
86: cp_person_id IGS_EN_SU_ATTEMPT_H.person_id%TYPE,
87: cp_course_cd IGS_EN_SU_ATTEMPT_H.course_cd%TYPE,
88: cp_uoo_id IGS_EN_SU_ATTEMPT_H.uoo_id%TYPE,
89: cp_hist_end_dt IGS_EN_SU_ATTEMPT_H.hist_end_dt%TYPE) IS
90: SELECT DECODE ( cp_column_name,
91: 'VERSION_NUMBER', TO_CHAR(suah.version_number),

Line 88: cp_uoo_id IGS_EN_SU_ATTEMPT_H.uoo_id%TYPE,

84: CURSOR c_suah(
85: cp_column_name user_tab_columns.column_name%TYPE,
86: cp_person_id IGS_EN_SU_ATTEMPT_H.person_id%TYPE,
87: cp_course_cd IGS_EN_SU_ATTEMPT_H.course_cd%TYPE,
88: cp_uoo_id IGS_EN_SU_ATTEMPT_H.uoo_id%TYPE,
89: cp_hist_end_dt IGS_EN_SU_ATTEMPT_H.hist_end_dt%TYPE) IS
90: SELECT DECODE ( cp_column_name,
91: 'VERSION_NUMBER', TO_CHAR(suah.version_number),
92: 'LOCATION_CD', suah.location_cd,

Line 89: cp_hist_end_dt IGS_EN_SU_ATTEMPT_H.hist_end_dt%TYPE) IS

85: cp_column_name user_tab_columns.column_name%TYPE,
86: cp_person_id IGS_EN_SU_ATTEMPT_H.person_id%TYPE,
87: cp_course_cd IGS_EN_SU_ATTEMPT_H.course_cd%TYPE,
88: cp_uoo_id IGS_EN_SU_ATTEMPT_H.uoo_id%TYPE,
89: cp_hist_end_dt IGS_EN_SU_ATTEMPT_H.hist_end_dt%TYPE) IS
90: SELECT DECODE ( cp_column_name,
91: 'VERSION_NUMBER', TO_CHAR(suah.version_number),
92: 'LOCATION_CD', suah.location_cd,
93: 'UNIT_CLASS', suah.unit_class,

Line 109: FROM IGS_EN_SU_ATTEMPT_H suah

105: 'OVERRIDE_EFTSU', TO_CHAR(suah.override_eftsu),
106: 'OVERRIDE_ACHIEVABLE_CP', TO_CHAR(suah.override_achievable_cp),
107: 'OVERRIDE_OUTCOME_DUE_DT', igs_ge_date.igscharDT(suah.override_outcome_due_dt),
108: 'OVERRIDE_CREDIT_REASON', suah.override_credit_reason)
109: FROM IGS_EN_SU_ATTEMPT_H suah
110: WHERE suah.person_id = cp_person_id AND
111: suah.course_cd = cp_course_cd AND
112: suah.uoo_id = cp_uoo_id AND
113: suah.hist_start_dt >= cp_hist_end_dt