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_GET_SUAEH_DTL dependencies on IGS_GE_DATE

Line 39: 'ENROLLED_DT', IGS_GE_DATE.IGSCHARDT(enrolled_dt),

35: DECODE (cp_column_name,
36: 'VERSION_NUMBER', TO_CHAR(version_number),
37: 'LOCATION_CD', location_cd,
38: 'UNIT_CLASS', unit_class,
39: 'ENROLLED_DT', IGS_GE_DATE.IGSCHARDT(enrolled_dt),
40: 'UNIT_ATTEMPT_STATUS', unit_attempt_status,
41: 'ADMINISTRATIVE_UNIT_STATUS', administrative_unit_status,
42: 'DISCONTINUED_DT', IGS_GE_DATE.IGSCHARDT(discontinued_dt),
43: 'RULE_WAIVED_DT', IGS_GE_DATE.IGSCHARDT(rule_waived_dt),

Line 42: 'DISCONTINUED_DT', IGS_GE_DATE.IGSCHARDT(discontinued_dt),

38: 'UNIT_CLASS', unit_class,
39: 'ENROLLED_DT', IGS_GE_DATE.IGSCHARDT(enrolled_dt),
40: 'UNIT_ATTEMPT_STATUS', unit_attempt_status,
41: 'ADMINISTRATIVE_UNIT_STATUS', administrative_unit_status,
42: 'DISCONTINUED_DT', IGS_GE_DATE.IGSCHARDT(discontinued_dt),
43: 'RULE_WAIVED_DT', IGS_GE_DATE.IGSCHARDT(rule_waived_dt),
44: 'RULE_WAIVED_PERSON_ID', TO_CHAR(rule_waived_person_id),
45: 'NO_ASSESSMENT_IND', no_assessment_ind,
46: 'EXAM_LOCATION_CD', exam_location_cd,

Line 43: 'RULE_WAIVED_DT', IGS_GE_DATE.IGSCHARDT(rule_waived_dt),

39: 'ENROLLED_DT', IGS_GE_DATE.IGSCHARDT(enrolled_dt),
40: 'UNIT_ATTEMPT_STATUS', unit_attempt_status,
41: 'ADMINISTRATIVE_UNIT_STATUS', administrative_unit_status,
42: 'DISCONTINUED_DT', IGS_GE_DATE.IGSCHARDT(discontinued_dt),
43: 'RULE_WAIVED_DT', IGS_GE_DATE.IGSCHARDT(rule_waived_dt),
44: 'RULE_WAIVED_PERSON_ID', TO_CHAR(rule_waived_person_id),
45: 'NO_ASSESSMENT_IND', no_assessment_ind,
46: 'EXAM_LOCATION_CD', exam_location_cd,
47: 'SUP_VERSION_NUMBER', TO_CHAR(sup_version_number),

Line 52: 'OVERRIDE_OUTCOME_DUE_DT', IGS_GE_DATE.IGSCHARDT(override_outcome_due_dt),

48: 'ALTERNATIVE_TITLE', alternative_title,
49: 'OVERRIDE_ENROLLED_CP', TO_CHAR(override_enrolled_cp),
50: 'OVERRIDE_EFTSU', TO_CHAR(override_eftsu),
51: 'OVERRIDE_ACHIEVABLE_CP', TO_CHAR(override_achievable_cp),
52: 'OVERRIDE_OUTCOME_DUE_DT', IGS_GE_DATE.IGSCHARDT(override_outcome_due_dt),
53: 'OVERRIDE_CREDIT_REASON', override_credit_reason)
54: FROM IGS_EN_SU_ATTEMPT
55: WHERE person_id = cp_person_id AND
56: course_cd = cp_course_cd AND

Line 71: 'ENROLLED_DT', IGS_GE_DATE.IGSCHARDT(enrolled_dt),

67: DECODE (cp_column_name,
68: 'VERSION_NUMBER', TO_CHAR(version_number),
69: 'LOCATION_CD', location_cd,
70: 'UNIT_CLASS', unit_class,
71: 'ENROLLED_DT', IGS_GE_DATE.IGSCHARDT(enrolled_dt),
72: 'UNIT_ATTEMPT_STATUS', unit_attempt_status,
73: 'ADMINISTRATIVE_UNIT_STATUS', administrative_unit_status,
74: 'DISCONTINUED_DT', IGS_GE_DATE.IGSCHARDT(discontinued_dt),
75: 'RULE_WAIVED_DT', IGS_GE_DATE.IGSCHARDT(rule_waived_dt),

Line 74: 'DISCONTINUED_DT', IGS_GE_DATE.IGSCHARDT(discontinued_dt),

70: 'UNIT_CLASS', unit_class,
71: 'ENROLLED_DT', IGS_GE_DATE.IGSCHARDT(enrolled_dt),
72: 'UNIT_ATTEMPT_STATUS', unit_attempt_status,
73: 'ADMINISTRATIVE_UNIT_STATUS', administrative_unit_status,
74: 'DISCONTINUED_DT', IGS_GE_DATE.IGSCHARDT(discontinued_dt),
75: 'RULE_WAIVED_DT', IGS_GE_DATE.IGSCHARDT(rule_waived_dt),
76: 'RULE_WAIVED_PERSON_ID', TO_CHAR(rule_waived_person_id),
77: 'NO_ASSESSMENT_IND', no_assessment_ind,
78: 'EXAM_LOCATION_CD', exam_location_cd,

Line 75: 'RULE_WAIVED_DT', IGS_GE_DATE.IGSCHARDT(rule_waived_dt),

71: 'ENROLLED_DT', IGS_GE_DATE.IGSCHARDT(enrolled_dt),
72: 'UNIT_ATTEMPT_STATUS', unit_attempt_status,
73: 'ADMINISTRATIVE_UNIT_STATUS', administrative_unit_status,
74: 'DISCONTINUED_DT', IGS_GE_DATE.IGSCHARDT(discontinued_dt),
75: 'RULE_WAIVED_DT', IGS_GE_DATE.IGSCHARDT(rule_waived_dt),
76: 'RULE_WAIVED_PERSON_ID', TO_CHAR(rule_waived_person_id),
77: 'NO_ASSESSMENT_IND', no_assessment_ind,
78: 'EXAM_LOCATION_CD', exam_location_cd,
79: 'SUP_VERSION_NUMBER', TO_CHAR(sup_version_number),

Line 84: 'OVERRIDE_OUTCOME_DUE_DT', IGS_GE_DATE.IGSCHARDT(override_outcome_due_dt),

80: 'ALTERNATIVE_TITLE', alternative_title,
81: 'OVERRIDE_ENROLLED_CP', TO_CHAR(override_enrolled_cp),
82: 'OVERRIDE_EFTSU', TO_CHAR(override_eftsu),
83: 'OVERRIDE_ACHIEVABLE_CP', TO_CHAR(override_achievable_cp),
84: 'OVERRIDE_OUTCOME_DUE_DT', IGS_GE_DATE.IGSCHARDT(override_outcome_due_dt),
85: 'OVERRIDE_CREDIT_REASON', override_credit_reason)
86: FROM IGS_EN_SU_ATTEMPT_H
87: WHERE person_id = cp_person_id AND
88: course_cd = cp_course_cd AND

Line 223: || ' p_hist_start_dt - ' || IGS_GE_DATE.IGSCHARDT(p_hist_start_dt)

219: || ' p_unit_cd - ' || p_unit_cd
220: || ' p_cal_type - ' || p_cal_type
221: || ' p_ci_seq_num - ' || TO_CHAR(p_ci_seq_num)
222: || ' p_unit_attempt_status - ' || p_unit_attempt_status
223: || ' p_hist_start_dt - ' || IGS_GE_DATE.IGSCHARDT(p_hist_start_dt)
224: || ' p_uoo_id - '||TO_CHAR(p_uoo_id);
225: RAISE;
226: END enrp_get_suaeh_col;
227: --

Line 301: RETURN IGS_GE_DATE.IGSDATE(IGS_GE_DATE.IGSCHAR(SYSDATE)||' 23:59:59');

297: -- All prior 'DISCONTINued histories are converted to match
298: -- the current student unit attempt.
299: -- End the history at the same time as the current
300: -- student unit attempt ie. now
301: RETURN IGS_GE_DATE.IGSDATE(IGS_GE_DATE.IGSCHAR(SYSDATE)||' 23:59:59');
302: ELSE -- history is not discontinued
303: -- Cannot be effectively discontinued before being
304: -- effectively enrolled.
305: -- All histories prior to discontinuation are considered

Line 313: RETURN IGS_GE_DATE.IGSDATE(IGS_GE_DATE.IGSCHAR(SYSDATE)||' 23:59:59');

309: ELSIF v_current_uas = 'ENROLLED' THEN
310: -- All histories converted to the ENROLLED definition.
311: -- End the history at the same time as the current
312: -- student unit attempt ie. now
313: RETURN IGS_GE_DATE.IGSDATE(IGS_GE_DATE.IGSCHAR(SYSDATE)||' 23:59:59');
314: ELSIF v_current_uas = 'UNCONFIRM' THEN
315: -- All histories converted to the UNCONFIRMed definition.
316: -- End the history at the same time as the current
317: -- student unit attempt ie. now

Line 318: RETURN IGS_GE_DATE.IGSDATE(IGS_GE_DATE.IGSCHAR(SYSDATE)||' 23:59:59');

314: ELSIF v_current_uas = 'UNCONFIRM' THEN
315: -- All histories converted to the UNCONFIRMed definition.
316: -- End the history at the same time as the current
317: -- student unit attempt ie. now
318: RETURN IGS_GE_DATE.IGSDATE(IGS_GE_DATE.IGSCHAR(SYSDATE)||' 23:59:59');
319: ELSE
320: IF v_current_e_dt IS NOT NULL THEN
321: -- attempt to find the last enrolled history entry
322: OPEN c_last_e_suah(

Line 353: || ' p_hist_end_dt - '|| IGS_GE_DATE.IGSCHAR(p_hist_end_dt)

349: || ' p_course_cd - '|| p_course_cd
350: || ' p_unit_cd - '|| p_unit_cd
351: || ' p_cal_type - '|| p_cal_type
352: || ' p_ci_sequence_num - '|| TO_CHAR(p_ci_sequence_num)
353: || ' p_hist_end_dt - '|| IGS_GE_DATE.IGSCHAR(p_hist_end_dt)
354: || ' p_unit_attempt_status - '|| p_unit_attempt_status
355: || ' p_uoo_id - '||TO_CHAR(p_uoo_id);
356: RAISE;
357: END enrp_get_suaeh_eff_end;

Line 481: || ' p_hist_start_dt - '|| IGS_GE_DATE.IGSCHAR(p_hist_start_dt)

477: || ' p_course_cd - '|| p_course_cd
478: || ' p_unit_cd - '|| p_unit_cd
479: || ' p_cal_type - '|| p_cal_type
480: || ' p_ci_sequence_num - '|| TO_CHAR(p_ci_sequence_num)
481: || ' p_hist_start_dt - '|| IGS_GE_DATE.IGSCHAR(p_hist_start_dt)
482: || ' p_unit_attempt_status - '|| p_unit_attempt_status
483: || ' p_uoo_id - '||TO_CHAR(p_uoo_id);
484: RAISE;
485: END enrp_get_suaeh_eff_st;