APPS.IGS_AS_SU_ATMPT_PAT_PKG dependencies on IGS_GE_DATE

Line 131: (NVL(new_references.logical_delete_dt, IGS_GE_DATE.IGSDATE('1900/01/01'))

127: CLOSE c_sua;
128: -- Check if IGS_AS_GEN_004.ASSP_INS_SUAAP_DFLT has not disabled the trigger
129: -- and the logical delete date is not set.
130: IF IGS_AS_VAL_SUAAP.GENP_VAL_SDTT_SESS('IGS_AS_SU_ATMPT_PAT') AND
131: (NVL(new_references.logical_delete_dt, IGS_GE_DATE.IGSDATE('1900/01/01'))
132: = NVL(old_references.logical_delete_dt, IGS_GE_DATE.IGSDATE('1900/01/01'))) THEN
133: -- Allocate unit_ass_pattern_items within the pattern to the student
134: -- (IGS_AS_SU_ATMPT_ITM).
135: IF IGS_AS_GEN_004.ASSP_INS_SUAAP_SUAAI(new_references.person_id,

Line 132: = NVL(old_references.logical_delete_dt, IGS_GE_DATE.IGSDATE('1900/01/01'))) THEN

128: -- Check if IGS_AS_GEN_004.ASSP_INS_SUAAP_DFLT has not disabled the trigger
129: -- and the logical delete date is not set.
130: IF IGS_AS_VAL_SUAAP.GENP_VAL_SDTT_SESS('IGS_AS_SU_ATMPT_PAT') AND
131: (NVL(new_references.logical_delete_dt, IGS_GE_DATE.IGSDATE('1900/01/01'))
132: = NVL(old_references.logical_delete_dt, IGS_GE_DATE.IGSDATE('1900/01/01'))) THEN
133: -- Allocate unit_ass_pattern_items within the pattern to the student
134: -- (IGS_AS_SU_ATMPT_ITM).
135: IF IGS_AS_GEN_004.ASSP_INS_SUAAP_SUAAI(new_references.person_id,
136: new_references.course_cd,

Line 191: (NVL(new_references.logical_delete_dt, IGS_GE_DATE.IGSDATE('1900/01/01'))

187: -- Cannot call assp_val_suaap_activ because trigger will be mutating.
188: -- Save the rowid of the current row.
189: END IF;
190: IF p_updating AND
191: (NVL(new_references.logical_delete_dt, IGS_GE_DATE.IGSDATE('1900/01/01'))
192: <> NVL(old_references.logical_delete_dt, IGS_GE_DATE.IGSDATE('1900/01/01'))) THEN
193: -- If logically p_deleting the suaap record.
194: -- Check if IGS_AS_GEN_001.ASSP_DEL_SUAAP_DFLT has not disabled the trigger.
195: IF IGS_AS_VAL_SUAAP.GENP_VAL_SDTT_SESS('IGS_AS_SU_ATMPT_PAT') THEN

Line 192: <> NVL(old_references.logical_delete_dt, IGS_GE_DATE.IGSDATE('1900/01/01'))) THEN

188: -- Save the rowid of the current row.
189: END IF;
190: IF p_updating AND
191: (NVL(new_references.logical_delete_dt, IGS_GE_DATE.IGSDATE('1900/01/01'))
192: <> NVL(old_references.logical_delete_dt, IGS_GE_DATE.IGSDATE('1900/01/01'))) THEN
193: -- If logically p_deleting the suaap record.
194: -- Check if IGS_AS_GEN_001.ASSP_DEL_SUAAP_DFLT has not disabled the trigger.
195: IF IGS_AS_VAL_SUAAP.GENP_VAL_SDTT_SESS('IGS_AS_SU_ATMPT_PAT') THEN
196: IF IGS_AS_GEN_001.ASSP_DEL_SUAAP_SUAAI( new_references.person_id,