DBA Data[Home] [Help]

APPS.IGS_AS_SU_ATMPT_PAT_PKG dependencies on IGS_AS_GEN_001

Line 161: --svanukur 29-APR-03 Passed uoo_id to IGS_AS_GEN_001.ASSP_DEL_SUAAP_SUAAI, IGS_AS_VAL_SUAAP.assp_val_suaap_actv as part of MUS build, # 2829262

157: -- FOR EACH ROW
158: -------------------------------------------------------------------------------------------
159: --Change History:
160: --Who When What
161: --svanukur 29-APR-03 Passed uoo_id to IGS_AS_GEN_001.ASSP_DEL_SUAAP_SUAAI, IGS_AS_VAL_SUAAP.assp_val_suaap_actv as part of MUS build, # 2829262
162: -------------------------------------------------------------------------------------------
163: PROCEDURE AfterRowInsertUpdate2(
164: p_inserting IN BOOLEAN DEFAULT FALSE,
165: p_updating IN BOOLEAN DEFAULT FALSE,

Line 194: -- Check if IGS_AS_GEN_001.ASSP_DEL_SUAAP_DFLT has not disabled the trigger.

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,
197: new_references.course_cd,
198: new_references.unit_cd,

Line 196: IF IGS_AS_GEN_001.ASSP_DEL_SUAAP_SUAAI( new_references.person_id,

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,
197: new_references.course_cd,
198: new_references.unit_cd,
199: new_references.cal_type,
200: new_references.ci_sequence_number,

Line 218: -- Store away the rowid as the routine IGS_AS_GEN_001.ASSP_DEL_SUAAP_SUAAI will cause the

214: APP_EXCEPTION.RAISE_EXCEPTION;
215: END IF;
216: -- Logically delete unit_ass_pattern_items within the pattern to the student
217: -- (IGS_AS_SU_ATMPT_ITM).
218: -- Store away the rowid as the routine IGS_AS_GEN_001.ASSP_DEL_SUAAP_SUAAI will cause the
219: -- trigger to be mutating.
220: -- IGS_AS_VAL_SUAAP.genp_set_rowid(l_rowid);
221: END IF;
222: END IF;