APPS.IGS_PR_GEN_006 dependencies on IGS_GE_DATE

Line 96: TRUNC(NVL(p_new_applied_dt, IGS_GE_DATE.IGSDATE('9999/01/01'))) <>

92: -- If the student progression outcome details have been changed
93: -- return the correct applied date.
94: p_out_applied_dt := NULL;
95: IF p_decision_status <> 'APPROVED' OR
96: TRUNC(NVL(p_new_applied_dt, IGS_GE_DATE.IGSDATE('9999/01/01'))) <>
97: TRUNC(NVL(p_old_applied_dt, IGS_GE_DATE.IGSDATE('9999/01/01'))) THEN
98: RETURN TRUE;
99: END IF;
100: IF NVL(p_old_encmb_course_group_cd, 'NULL') <>

Line 97: TRUNC(NVL(p_old_applied_dt, IGS_GE_DATE.IGSDATE('9999/01/01'))) THEN

93: -- return the correct applied date.
94: p_out_applied_dt := NULL;
95: IF p_decision_status <> 'APPROVED' OR
96: TRUNC(NVL(p_new_applied_dt, IGS_GE_DATE.IGSDATE('9999/01/01'))) <>
97: TRUNC(NVL(p_old_applied_dt, IGS_GE_DATE.IGSDATE('9999/01/01'))) THEN
98: RETURN TRUE;
99: END IF;
100: IF NVL(p_old_encmb_course_group_cd, 'NULL') <>
101: NVL(p_new_encmb_course_group_cd, 'NULL') OR

Line 106: TRUNC(NVL(p_old_expiry_dt, IGS_GE_DATE.IGSDATE('0001/01/01'))) <>

102: NVL(p_old_restricted_enrolment_cp, 0) <>
103: NVL(p_new_restricted_enrolment_cp, 0) OR
104: NVL(p_old_restricted_attend_type, 'NULL') <>
105: NVL(p_new_restricted_attend_type, 'NULL') OR
106: TRUNC(NVL(p_old_expiry_dt, IGS_GE_DATE.IGSDATE('0001/01/01'))) <>
107: TRUNC(NVL(p_new_expiry_dt, IGS_GE_DATE.IGSDATE('0001/01/01'))) OR
108: NVL(p_old_duration, 0) <>
109: NVL(p_new_duration, 0) OR
110: NVL(p_old_duration_type, 'NULL') <>

Line 107: TRUNC(NVL(p_new_expiry_dt, IGS_GE_DATE.IGSDATE('0001/01/01'))) OR

103: NVL(p_new_restricted_enrolment_cp, 0) OR
104: NVL(p_old_restricted_attend_type, 'NULL') <>
105: NVL(p_new_restricted_attend_type, 'NULL') OR
106: TRUNC(NVL(p_old_expiry_dt, IGS_GE_DATE.IGSDATE('0001/01/01'))) <>
107: TRUNC(NVL(p_new_expiry_dt, IGS_GE_DATE.IGSDATE('0001/01/01'))) OR
108: NVL(p_old_duration, 0) <>
109: NVL(p_new_duration, 0) OR
110: NVL(p_old_duration_type, 'NULL') <>
111: NVL(p_new_duration_type, 'NULL') THEN

Line 113: TRUNC(IGS_GE_DATE.IGSDATE('0001/01/01')) THEN

109: NVL(p_new_duration, 0) OR
110: NVL(p_old_duration_type, 'NULL') <>
111: NVL(p_new_duration_type, 'NULL') THEN
112: IF TRUNC(p_new_applied_dt) <>
113: TRUNC(IGS_GE_DATE.IGSDATE('0001/01/01')) THEN
114: p_out_applied_dt := IGS_GE_DATE.IGSDATE('0001/01/01');
115: RETURN FALSE;
116: END IF;
117: END IF;

Line 114: p_out_applied_dt := IGS_GE_DATE.IGSDATE('0001/01/01');

110: NVL(p_old_duration_type, 'NULL') <>
111: NVL(p_new_duration_type, 'NULL') THEN
112: IF TRUNC(p_new_applied_dt) <>
113: TRUNC(IGS_GE_DATE.IGSDATE('0001/01/01')) THEN
114: p_out_applied_dt := IGS_GE_DATE.IGSDATE('0001/01/01');
115: RETURN FALSE;
116: END IF;
117: END IF;
118: RETURN TRUE;

Line 3848: IF NVL(v_pen_expiry_dt,IGS_GE_DATE.IGSDATE('9999/01/01')) <>

3844: NULL,
3845: v_expiry_dt);
3846: END IF;
3847:
3848: IF NVL(v_pen_expiry_dt,IGS_GE_DATE.IGSDATE('9999/01/01')) <>
3849: NVL(v_expiry_dt, IGS_GE_DATE.IGSDATE('9999/01/01')) THEN
3850: IF NVL(v_expiry_dt, IGS_GE_DATE.IGSDATE('9999/01/01')) < gcst_sysdate THEN
3851: v_action_expiry_dt := gcst_sysdatetime;
3852: ELSE

Line 3849: NVL(v_expiry_dt, IGS_GE_DATE.IGSDATE('9999/01/01')) THEN

3845: v_expiry_dt);
3846: END IF;
3847:
3848: IF NVL(v_pen_expiry_dt,IGS_GE_DATE.IGSDATE('9999/01/01')) <>
3849: NVL(v_expiry_dt, IGS_GE_DATE.IGSDATE('9999/01/01')) THEN
3850: IF NVL(v_expiry_dt, IGS_GE_DATE.IGSDATE('9999/01/01')) < gcst_sysdate THEN
3851: v_action_expiry_dt := gcst_sysdatetime;
3852: ELSE
3853: v_action_expiry_dt := v_expiry_dt;

Line 3850: IF NVL(v_expiry_dt, IGS_GE_DATE.IGSDATE('9999/01/01')) < gcst_sysdate THEN

3846: END IF;
3847:
3848: IF NVL(v_pen_expiry_dt,IGS_GE_DATE.IGSDATE('9999/01/01')) <>
3849: NVL(v_expiry_dt, IGS_GE_DATE.IGSDATE('9999/01/01')) THEN
3850: IF NVL(v_expiry_dt, IGS_GE_DATE.IGSDATE('9999/01/01')) < gcst_sysdate THEN
3851: v_action_expiry_dt := gcst_sysdatetime;
3852: ELSE
3853: v_action_expiry_dt := v_expiry_dt;
3854: END IF;