DBA Data[Home] [Help]

APPS.IGS_AS_SU_ATMPT_PAT_PKG dependencies on IGS_AS_GEN_004

Line 80: --svanukur 29-APR-03 Passed uoo_id to IGS_AS_GEN_004.ASSP_INS_SUAAP_SUAAI as part of MUS build, # 2829262

76:
77: -------------------------------------------------------------------------------------------
78: --Change History:
79: --Who When What
80: --svanukur 29-APR-03 Passed uoo_id to IGS_AS_GEN_004.ASSP_INS_SUAAP_SUAAI as part of MUS build, # 2829262
81: -------------------------------------------------------------------------------------------
82:
83:
84: PROCEDURE BeforeRowInsertUpdate1(

Line 128: -- Check if IGS_AS_GEN_004.ASSP_INS_SUAAP_DFLT has not disabled the trigger

124: CLOSE c_sua;
125: RAISE NO_DATA_FOUND;
126: END IF;
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

Line 135: IF IGS_AS_GEN_004.ASSP_INS_SUAAP_SUAAI(new_references.person_id,

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,
137: new_references.unit_cd,
138: v_version_number,
139: new_references.cal_type,