APPS.IGS_AS_SU_ATMPT_PAT_PKG dependencies on IGS_AS_VAL_SUAAP

Line 7: -- is changed to igs_as_val_suaap.genp_val_sdtt_sess

3: -------------------------------------------------------------------------------------------
4: --Change History:
5: --Who When What
6: --smadathi 24-AUG-2001 Bug No. 1956374 .The reference to igs_as_val_uai.genp_val_sdtt_sess
7: -- is changed to igs_as_val_suaap.genp_val_sdtt_sess
8: --svanukur 29-APR-03 Added new column uoo_id, redefined primary Key from
9: -- (person_id,course_cd,unit_cd,cal_type,ci_sequence_number,ass_pattern_id,creation_dt) to
10: -- (person_id,course_cd,uoo_id,ass_pattern_id,creation_dt)redefined FK
11: -- to (PERSON_ID, COURSE_CD,UOO_ID)as part of MUS build, # 2829262

Line 106: IF IGS_AS_VAL_SUAAP.assp_val_suaap_ins(new_references.person_id,

102: -- If p_inserting, validate that the assessment pattern is applicable to the
103: -- student IGS_PS_UNIT attempt and that the IGS_PS_UNIT attempt status is ENROLLED or
104: -- UNCONFIRMED.
105: IF p_inserting THEN
106: IF IGS_AS_VAL_SUAAP.assp_val_suaap_ins(new_references.person_id,
107: new_references.course_cd,
108: new_references.unit_cd,
109: new_references.cal_type,
110: new_references.ci_sequence_number,

Line 130: IF IGS_AS_VAL_SUAAP.GENP_VAL_SDTT_SESS('IGS_AS_SU_ATMPT_PAT') AND

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
133: -- Allocate unit_ass_pattern_items within the pattern to the student
134: -- (IGS_AS_SU_ATMPT_ITM).

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 173: IF IGS_AS_VAL_SUAAP.assp_val_suaap_actv( new_references.person_id,

169: v_error_count NUMBER(5);
170: v_warning_count NUMBER;
171: BEGIN
172: IF p_inserting THEN
173: IF IGS_AS_VAL_SUAAP.assp_val_suaap_actv( new_references.person_id,
174: new_references.course_cd,
175: new_references.unit_cd,
176: new_references.cal_type,
177: new_references.ci_sequence_number,

Line 195: IF IGS_AS_VAL_SUAAP.GENP_VAL_SDTT_SESS('IGS_AS_SU_ATMPT_PAT') THEN

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,
199: new_references.cal_type,

Line 220: -- IGS_AS_VAL_SUAAP.genp_set_rowid(l_rowid);

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;
223: END AfterRowInsertUpdate2;
224: -- Trigger description :-