APPS.IGS_EN_GEN_007 dependencies on IGS_GE_DATE

Line 94: 'ENROLLED_DT', igs_ge_date.igscharDT(suah.enrolled_dt),

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,
94: 'ENROLLED_DT', igs_ge_date.igscharDT(suah.enrolled_dt),
95: 'UNIT_ATTEMPT_STATUS', suah.unit_attempt_status,
96: 'ADMINISTRATIVE_UNIT_STATUS', suah.ADMINISTRATIVE_UNIT_STATUS,
97: 'DISCONTINUED_DT', igs_ge_date.igscharDT(suah.discontinued_dt),
98: 'RULE_WAIVED_DT', igs_ge_date.igscharDT(suah.rule_waived_dt),

Line 97: 'DISCONTINUED_DT', igs_ge_date.igscharDT(suah.discontinued_dt),

93: 'UNIT_CLASS', suah.unit_class,
94: 'ENROLLED_DT', igs_ge_date.igscharDT(suah.enrolled_dt),
95: 'UNIT_ATTEMPT_STATUS', suah.unit_attempt_status,
96: 'ADMINISTRATIVE_UNIT_STATUS', suah.ADMINISTRATIVE_UNIT_STATUS,
97: 'DISCONTINUED_DT', igs_ge_date.igscharDT(suah.discontinued_dt),
98: 'RULE_WAIVED_DT', igs_ge_date.igscharDT(suah.rule_waived_dt),
99: 'RULE_WAIVED_PERSON_ID', TO_CHAR(suah.rule_waived_person_id),
100: 'NO_ASSESSMENT_IND', suah.no_assessment_ind,
101: 'EXAM_LOCATION_CD', suah.exam_location_cd,

Line 98: 'RULE_WAIVED_DT', igs_ge_date.igscharDT(suah.rule_waived_dt),

94: 'ENROLLED_DT', igs_ge_date.igscharDT(suah.enrolled_dt),
95: 'UNIT_ATTEMPT_STATUS', suah.unit_attempt_status,
96: 'ADMINISTRATIVE_UNIT_STATUS', suah.ADMINISTRATIVE_UNIT_STATUS,
97: 'DISCONTINUED_DT', igs_ge_date.igscharDT(suah.discontinued_dt),
98: 'RULE_WAIVED_DT', igs_ge_date.igscharDT(suah.rule_waived_dt),
99: 'RULE_WAIVED_PERSON_ID', TO_CHAR(suah.rule_waived_person_id),
100: 'NO_ASSESSMENT_IND', suah.no_assessment_ind,
101: 'EXAM_LOCATION_CD', suah.exam_location_cd,
102: 'SUP_VERSION_NUMBER', TO_CHAR(suah.sup_version_number),

Line 107: 'OVERRIDE_OUTCOME_DUE_DT', igs_ge_date.igscharDT(suah.override_outcome_due_dt),

103: 'ALTERNATIVE_TITLE', suah.alternative_title,
104: 'OVERRIDE_ENROLLED_CP', TO_CHAR(suah.override_enrolled_cp),
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

Line 145: || ', p_hist_end_dt - ' || igs_ge_date.igscharDT(p_hist_end_dt)

141: || ', p_course_cd - ' || p_course_cd
142: || ', p_unit_cd - ' || p_unit_cd
143: || ', p_cal_type - ' || p_cal_type
144: || ', p_ci_sequence_number - ' || TO_CHAR(p_ci_sequence_number)
145: || ', p_hist_end_dt - ' || igs_ge_date.igscharDT(p_hist_end_dt)
146: || ', p_uoo_id - ' || TO_CHAR(p_uoo_id);
147:
148: RAISE;
149: END enrp_get_suah_col;