DBA Data[Home] [Help]

APPS.IGS_AS_SU_SETATMPT_PKG dependencies on IGS_EN_GEN_013

Line 166: -- Warning: disabling has been done for IGS_EN_GEN_013.ENRP_UPD_SUSA_END_DT and

162: CLOSE c_us_valid;
163: END IF;
164:
165: -- If trigger has not been disabled, perform required processing
166: -- Warning: disabling has been done for IGS_EN_GEN_013.ENRP_UPD_SUSA_END_DT and
167: -- IGS_EN_GEN_013.ENRP_UPD_SUSA_SCI processing which occurs within the after statment
168: -- trigger. If wishing to disable the triggers, use a different table name as
169: -- an identifier eg. 'STUDENT_UNIT_SET_ATTEMPT2'
170: -- IGS_GE_NOTE: Any alterations to susa triggers should be applied to module

Line 167: -- IGS_EN_GEN_013.ENRP_UPD_SUSA_SCI processing which occurs within the after statment

163: END IF;
164:
165: -- If trigger has not been disabled, perform required processing
166: -- Warning: disabling has been done for IGS_EN_GEN_013.ENRP_UPD_SUSA_END_DT and
167: -- IGS_EN_GEN_013.ENRP_UPD_SUSA_SCI processing which occurs within the after statment
168: -- trigger. If wishing to disable the triggers, use a different table name as
169: -- an identifier eg. 'STUDENT_UNIT_SET_ATTEMPT2'
170: -- IGS_GE_NOTE: Any alterations to susa triggers should be applied to module
171: -- enrp_val_susa.

Line 461: IF IGS_EN_GEN_013.ENRP_UPD_SUSA_END_DT(

457: -- through to any descendant unit sets (Inserted records cannot have
458: -- children at that point).
459: IF p_updating AND
460: new_references.end_dt IS NOT NULL THEN
461: IF IGS_EN_GEN_013.ENRP_UPD_SUSA_END_DT(
462: new_references.person_id,
463: new_references.course_cd,
464: new_references.unit_set_cd,
465: new_references.sequence_number,

Line 508: IF IGS_EN_GEN_013.ENRP_UPD_SUSA_SCI(

504: -- then unset any descendant unit sets. (Only concerned with update
505: -- as unit set cannot have descendant at the point of creation).
506: IF p_updating AND
507: new_references.student_confirmed_ind = 'N' THEN
508: IF IGS_EN_GEN_013.ENRP_UPD_SUSA_SCI(
509: new_references.person_id,
510: new_references.course_cd,
511: new_references.unit_set_cd,
512: new_references.sequence_number,

Line 576: -- Warning: disabling has been done for IGS_EN_GEN_013.ENRP_UPD_SUSA_END_DT and

572:
573:
574: BEGIN
575: -- If trigger has not been disabled, perform required processing
576: -- Warning: disabling has been done for IGS_EN_GEN_013.ENRP_UPD_SUSA_END_DT and
577: -- IGS_EN_GEN_013.ENRP_UPD_SUSA_SCI processing which occurs within the after statment
578: -- trigger. If wishing to disable the triggers, use a different table name as
579: -- an identifier eg. 'STUDENT_UNIT_SET_ATTEMPT2'
580: IF igs_as_val_suaap.genp_val_sdtt_sess('IGS_AS_SU_SETATMPT') THEN

Line 577: -- IGS_EN_GEN_013.ENRP_UPD_SUSA_SCI processing which occurs within the after statment

573:
574: BEGIN
575: -- If trigger has not been disabled, perform required processing
576: -- Warning: disabling has been done for IGS_EN_GEN_013.ENRP_UPD_SUSA_END_DT and
577: -- IGS_EN_GEN_013.ENRP_UPD_SUSA_SCI processing which occurs within the after statment
578: -- trigger. If wishing to disable the triggers, use a different table name as
579: -- an identifier eg. 'STUDENT_UNIT_SET_ATTEMPT2'
580: IF igs_as_val_suaap.genp_val_sdtt_sess('IGS_AS_SU_SETATMPT') THEN
581: -- Validate the the IGS_PS_UNIT set is able to be created