DBA Data[Home] [Help]

APPS.IGS_AS_SU_ATMPT_ITM_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 22

    x_logical_delete_dt            IN     DATE DEFAULT NULL,
    x_s_default_ind                IN     VARCHAR2 DEFAULT NULL,
    x_ass_pattern_id               IN     NUMBER DEFAULT NULL,
    x_creation_date                IN     DATE DEFAULT NULL,
    x_created_by                   IN     NUMBER DEFAULT NULL,
    x_last_update_date             IN     DATE DEFAULT NULL,
    x_last_updated_by              IN     NUMBER DEFAULT NULL,
    x_last_update_login            IN     NUMBER DEFAULT NULL,
    x_grading_schema_cd            IN     VARCHAR2 DEFAULT NULL,
    x_gs_version_number            IN     NUMBER DEFAULT NULL,
    x_grade                        IN     VARCHAR2 DEFAULT NULL,
    x_outcome_comment_code         IN     VARCHAR2 DEFAULT NULL,
    x_mark                         IN     NUMBER DEFAULT NULL,
    x_attribute_category           IN     VARCHAR2 DEFAULT NULL,
    x_attribute1                   IN     VARCHAR2 DEFAULT NULL,
    x_attribute2                   IN     VARCHAR2 DEFAULT NULL,
    x_attribute3                   IN     VARCHAR2 DEFAULT NULL,
    x_attribute4                   IN     VARCHAR2 DEFAULT NULL,
    x_attribute5                   IN     VARCHAR2 DEFAULT NULL,
    x_attribute6                   IN     VARCHAR2 DEFAULT NULL,
    x_attribute7                   IN     VARCHAR2 DEFAULT NULL,
    x_attribute8                   IN     VARCHAR2 DEFAULT NULL,
    x_attribute9                   IN     VARCHAR2 DEFAULT NULL,
    x_attribute10                  IN     VARCHAR2 DEFAULT NULL,
    x_attribute11                  IN     VARCHAR2 DEFAULT NULL,
    x_attribute12                  IN     VARCHAR2 DEFAULT NULL,
    x_attribute13                  IN     VARCHAR2 DEFAULT NULL,
    x_attribute14                  IN     VARCHAR2 DEFAULT NULL,
    x_attribute15                  IN     VARCHAR2 DEFAULT NULL,
    x_attribute16                  IN     VARCHAR2 DEFAULT NULL,
    x_attribute17                  IN     VARCHAR2 DEFAULT NULL,
    x_attribute18                  IN     VARCHAR2 DEFAULT NULL,
    x_attribute19                  IN     VARCHAR2 DEFAULT NULL,
    x_attribute20                  IN     VARCHAR2 DEFAULT NULL,
    x_uoo_id                       IN     NUMBER DEFAULT NULL,
    x_unit_section_ass_item_id     IN     NUMBER DEFAULT NULL,
    x_unit_ass_item_id             IN     NUMBER DEFAULT NULL,
    x_sua_ass_item_group_id        IN     NUMBER DEFAULT NULL,
    x_midterm_mandatory_type_code  IN     VARCHAR2 DEFAULT NULL,
    x_midterm_weight_qty           IN     NUMBER DEFAULT NULL,
    x_final_mandatory_type_code    IN     VARCHAR2 DEFAULT NULL,
    x_final_weight_qty             IN     NUMBER DEFAULT NULL,
    x_submitted_date               IN     DATE DEFAULT NULL,
    x_waived_flag                  IN     VARCHAR2 DEFAULT NULL,
    x_penalty_applied_flag         IN     VARCHAR2 DEFAULT NULL
  ) AS
    CURSOR cur_old_ref_values IS
      SELECT *
      FROM   igs_as_su_atmpt_itm
      WHERE  ROWID = x_rowid;
Line: 79

        AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT')) THEN
      fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
Line: 99

    new_references.logical_delete_dt := x_logical_delete_dt;
Line: 139

    IF (p_action = 'UPDATE') THEN
      new_references.creation_date := old_references.creation_date;
Line: 146

    new_references.last_update_date := x_last_update_date;
Line: 147

    new_references.last_updated_by := x_last_updated_by;
Line: 148

    new_references.last_update_login := x_last_update_login;
Line: 151

  PROCEDURE beforerowinsertupdate1 (
    p_inserting                    IN     BOOLEAN DEFAULT FALSE,
    p_updating                     IN     BOOLEAN DEFAULT FALSE,
    p_deleting                     IN     BOOLEAN DEFAULT FALSE
  ) /***********************************************************************************************************
    |Change  History :
    |Who             When                        What
    |
    |Aiyer         19-Apr-2002                   Modified for the bug #2323692
    |                                            Check that the Outcome comments field should have a comment when grqde or marks field
    |                                            is changed.
    *=======================================================================*************************************/
    AS
    v_message_name              VARCHAR2 (30);
Line: 168

      SELECT tt.s_tracking_type,
             trs.s_tracking_status
      FROM   igs_tr_item tri,
             igs_tr_type tt,
             igs_tr_status trs
      WHERE  tri.tracking_id = cp_tracking_id
      AND    tri.tracking_type = tt.tracking_type
      AND    tri.tracking_status = trs.tracking_status;
Line: 182

    IF p_inserting THEN
      IF igs_as_val_scap.assp_val_suaai_ins (
           new_references.person_id,
           new_references.course_cd,
           new_references.unit_cd,
           new_references.cal_type,
           new_references.ci_sequence_number,
           new_references.ass_id,
           v_message_name,
           new_references.uoo_id
         ) = FALSE THEN
        -- Check message number and return the more appropriate message
        -- when status is completed.
        IF v_message_name = 'IGS_CA_AA_CIR_FK' THEN
          NULL;
Line: 260

  END beforerowinsertupdate1;
Line: 280

      igs_as_suaai_ouhist_pkg.insert_row (
        x_rowid                        => l_rowid,
        x_person_id                    => old_references.person_id,
        x_course_cd                    => old_references.course_cd,
        x_unit_cd                      => old_references.unit_cd,
        x_cal_type                     => old_references.cal_type,
        x_ci_sequence_number           => old_references.ci_sequence_number,
        x_ass_id                       => old_references.ass_id,
        x_creation_dt                  => old_references.creation_dt,
        x_grading_schema_cd            => old_references.grading_schema_cd,
        x_gs_version_number            => old_references.gs_version_number,
        x_grade                        => old_references.grade,
        x_outcome_dt                   => old_references.outcome_dt,
        x_mark                         => old_references.mark,
        x_outcome_comment_code         => old_references.outcome_comment_code,
        x_hist_start_dt                => old_references.last_update_date,
        x_hist_end_dt                  => new_references.last_update_date,
        x_hist_who                     => old_references.last_updated_by,
        x_mode                         => 'R',
        x_uoo_id                       => old_references.uoo_id,
        x_sua_ass_item_group_id        => old_references.sua_ass_item_group_id,
        x_midterm_mandatory_type_code  => old_references.midterm_mandatory_type_code,
        x_midterm_weight_qty           => old_references.midterm_weight_qty,
        x_final_mandatory_type_code    => old_references.final_mandatory_type_code,
        x_final_weight_qty             => old_references.final_weight_qty,
        x_submitted_date               => old_references.submitted_date,
        x_waived_flag                  => old_references.waived_flag,
        x_penalty_applied_flag         => old_references.penalty_applied_flag
      );
Line: 311

  PROCEDURE afterrowinsertupdate2 (
    p_inserting                    IN     BOOLEAN DEFAULT FALSE,
    p_updating                     IN     BOOLEAN DEFAULT FALSE,
    p_deleting                     IN     BOOLEAN DEFAULT FALSE
  ) AS
    v_message_name VARCHAR2 (30);
Line: 318

    IF p_inserting
       OR (p_updating
           AND new_references.attempt_number <> old_references.attempt_number
          ) THEN
      IF igs_as_val_suaai.assp_val_suaai_atmpt (
           new_references.person_id,
           new_references.course_cd,
           new_references.unit_cd,
           new_references.cal_type,
           new_references.ci_sequence_number,
           new_references.ass_id,
           new_references.creation_dt,
           new_references.attempt_number,
           v_message_name,
           new_references.uoo_id
         ) = FALSE THEN
        fnd_message.set_name ('IGS', v_message_name);
Line: 346

  END afterrowinsertupdate2;
Line: 358

      fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
Line: 369

      fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
Line: 378

      fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
Line: 386

      SELECT ROWID
      FROM   igs_as_spl_cons_appl
      WHERE  course_cd = old_references.course_cd
      AND    person_id = old_references.person_id
      AND    ass_id = old_references.ass_id
      AND    creation_dt = old_references.creation_dt
      AND    uoo_id = old_references.uoo_id;
Line: 395

      igs_as_spl_cons_appl_pkg.delete_row (x_rowid => igs_as_spl_cons_appl_rec.ROWID);
Line: 420

      SELECT     ROWID
      FROM       igs_as_su_atmpt_itm
      WHERE      course_cd = x_course_cd
      AND        person_id = x_person_id
      AND        ass_id = x_ass_id
      AND        creation_dt = x_creation_dt
      AND        uoo_id = x_uoo_id
      FOR UPDATE NOWAIT;
Line: 443

      SELECT ROWID
      FROM   igs_as_su_atmpt_itm
      WHERE  ass_id = x_ass_id;
Line: 470

      SELECT ROWID
      FROM   igs_as_su_atmpt_itm
      WHERE  sua_ass_item_group_id = x_sua_ass_item_group_id;
Line: 489

      SELECT ROWID
      FROM   igs_as_su_atmpt_itm
      WHERE  tracking_id = x_tracking_id;
Line: 513

      SELECT ROWID
      FROM   igs_as_su_atmpt_itm
      WHERE  grading_schema_cd = x_grading_schema_cd
      AND    gs_version_number = x_gs_version_number
      AND    grade = x_grade;
Line: 535

      SELECT ROWID
      FROM   igs_as_su_atmpt_itm
      WHERE  outcome_comment_code = x_outcome_comment_code;
Line: 571

    x_logical_delete_dt            IN     DATE DEFAULT NULL,
    x_s_default_ind                IN     VARCHAR2 DEFAULT NULL,
    x_ass_pattern_id               IN     NUMBER DEFAULT NULL,
    x_creation_date                IN     DATE DEFAULT NULL,
    x_created_by                   IN     NUMBER DEFAULT NULL,
    x_last_update_date             IN     DATE DEFAULT NULL,
    x_last_updated_by              IN     NUMBER DEFAULT NULL,
    x_last_update_login            IN     NUMBER DEFAULT NULL,
    x_grading_schema_cd            IN     VARCHAR2 DEFAULT NULL,
    x_gs_version_number            IN     NUMBER DEFAULT NULL,
    x_grade                        IN     VARCHAR2 DEFAULT NULL,
    x_outcome_comment_code         IN     VARCHAR2 DEFAULT NULL,
    x_mark                         IN     NUMBER DEFAULT NULL,
    x_attribute_category           IN     VARCHAR2 DEFAULT NULL,
    x_attribute1                   IN     VARCHAR2 DEFAULT NULL,
    x_attribute2                   IN     VARCHAR2 DEFAULT NULL,
    x_attribute3                   IN     VARCHAR2 DEFAULT NULL,
    x_attribute4                   IN     VARCHAR2 DEFAULT NULL,
    x_attribute5                   IN     VARCHAR2 DEFAULT NULL,
    x_attribute6                   IN     VARCHAR2 DEFAULT NULL,
    x_attribute7                   IN     VARCHAR2 DEFAULT NULL,
    x_attribute8                   IN     VARCHAR2 DEFAULT NULL,
    x_attribute9                   IN     VARCHAR2 DEFAULT NULL,
    x_attribute10                  IN     VARCHAR2 DEFAULT NULL,
    x_attribute11                  IN     VARCHAR2 DEFAULT NULL,
    x_attribute12                  IN     VARCHAR2 DEFAULT NULL,
    x_attribute13                  IN     VARCHAR2 DEFAULT NULL,
    x_attribute14                  IN     VARCHAR2 DEFAULT NULL,
    x_attribute15                  IN     VARCHAR2 DEFAULT NULL,
    x_attribute16                  IN     VARCHAR2 DEFAULT NULL,
    x_attribute17                  IN     VARCHAR2 DEFAULT NULL,
    x_attribute18                  IN     VARCHAR2 DEFAULT NULL,
    x_attribute19                  IN     VARCHAR2 DEFAULT NULL,
    x_attribute20                  IN     VARCHAR2 DEFAULT NULL,
    x_uoo_id                       IN     NUMBER DEFAULT NULL,
    x_unit_section_ass_item_id     IN     NUMBER DEFAULT NULL,
    x_unit_ass_item_id             IN     NUMBER DEFAULT NULL,
    x_sua_ass_item_group_id        IN     NUMBER DEFAULT NULL,
    x_midterm_mandatory_type_code  IN     VARCHAR2 DEFAULT NULL,
    x_midterm_weight_qty           IN     NUMBER DEFAULT NULL,
    x_final_mandatory_type_code    IN     VARCHAR2 DEFAULT NULL,
    x_final_weight_qty             IN     NUMBER DEFAULT NULL,
    x_submitted_date               IN     DATE DEFAULT NULL,
    x_waived_flag                  IN     VARCHAR2 DEFAULT NULL,
    x_penalty_applied_flag         IN     VARCHAR2 DEFAULT NULL
  ) AS
  BEGIN
    set_column_values (
      p_action,
      x_rowid,
      x_person_id,
      x_course_cd,
      x_unit_cd,
      x_cal_type,
      x_ci_sequence_number,
      x_ass_id,
      x_creation_dt,
      x_attempt_number,
      x_outcome_dt,
      x_override_due_dt,
      x_tracking_id,
      x_logical_delete_dt,
      x_s_default_ind,
      x_ass_pattern_id,
      x_creation_date,
      x_created_by,
      x_last_update_date,
      x_last_updated_by,
      x_last_update_login,
      x_grading_schema_cd,
      x_gs_version_number,
      x_grade,
      x_outcome_comment_code,
      x_mark,
      x_attribute_category,
      x_attribute1,
      x_attribute2,
      x_attribute3,
      x_attribute4,
      x_attribute5,
      x_attribute6,
      x_attribute7,
      x_attribute8,
      x_attribute9,
      x_attribute10,
      x_attribute11,
      x_attribute12,
      x_attribute13,
      x_attribute14,
      x_attribute15,
      x_attribute16,
      x_attribute17,
      x_attribute18,
      x_attribute19,
      x_attribute20,
      x_uoo_id,
      x_unit_section_ass_item_id,
      x_unit_ass_item_id,
      x_sua_ass_item_group_id,
      x_midterm_mandatory_type_code,
      x_midterm_weight_qty,
      x_final_mandatory_type_code,
      x_final_weight_qty,
      x_submitted_date,
      x_waived_flag,
      x_penalty_applied_flag
    );
Line: 678

    IF (p_action = 'INSERT') THEN
      -- Call all the procedures related to Before Insert.
      beforerowinsertupdate1 (p_inserting => TRUE);
Line: 694

    ELSIF (p_action = 'UPDATE') THEN
      -- Call all the procedures related to Before Update.
      beforerowinsertupdate1 (p_updating => TRUE);
Line: 699

    ELSIF (p_action = 'DELETE') THEN
      -- Call all the procedures related to Before Delete.
      NULL;
Line: 702

    ELSIF (p_action = 'VALIDATE_INSERT') THEN
      IF get_pk_for_validation (
           new_references.course_cd,
           new_references.person_id,
           new_references.ass_id,
           new_references.creation_dt,
           new_references.uoo_id
         ) THEN
        fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
Line: 715

    ELSIF (p_action = 'VALIDATE_UPDATE') THEN
      check_constraints;
Line: 717

    ELSIF (p_action = 'VALIDATE_DELETE') THEN
      check_child_existance;
Line: 725

    IF (p_action = 'INSERT') THEN
      -- Call all the procedures related to After Insert.
      afterrowinsertupdate2 (p_inserting => TRUE);
Line: 728

    ELSIF (p_action = 'UPDATE') THEN
      -- Call all the procedures related to After Update.
      afterrowinsertupdate2 (p_updating => TRUE);
Line: 734

  PROCEDURE insert_row (
    x_rowid                        IN OUT NOCOPY VARCHAR2,
    x_person_id                    IN     NUMBER,
    x_course_cd                    IN     VARCHAR2,
    x_unit_cd                      IN     VARCHAR2,
    x_cal_type                     IN     VARCHAR2,
    x_ci_sequence_number           IN     NUMBER,
    x_ass_id                       IN     NUMBER,
    x_creation_dt                  IN     DATE,
    x_attempt_number               IN     NUMBER,
    x_outcome_dt                   IN     DATE,
    x_override_due_dt              IN     DATE,
    x_tracking_id                  IN     NUMBER,
    x_logical_delete_dt            IN     DATE,
    x_s_default_ind                IN     VARCHAR2,
    x_ass_pattern_id               IN     NUMBER,
    x_mode                         IN     VARCHAR2 DEFAULT 'R',
    x_grading_schema_cd            IN     VARCHAR2,
    x_gs_version_number            IN     NUMBER,
    x_grade                        IN     VARCHAR2,
    x_outcome_comment_code         IN     VARCHAR2,
    x_mark                         IN     NUMBER,
    x_attribute_category           IN     VARCHAR2,
    x_attribute1                   IN     VARCHAR2,
    x_attribute2                   IN     VARCHAR2,
    x_attribute3                   IN     VARCHAR2,
    x_attribute4                   IN     VARCHAR2,
    x_attribute5                   IN     VARCHAR2,
    x_attribute6                   IN     VARCHAR2,
    x_attribute7                   IN     VARCHAR2,
    x_attribute8                   IN     VARCHAR2,
    x_attribute9                   IN     VARCHAR2,
    x_attribute10                  IN     VARCHAR2,
    x_attribute11                  IN     VARCHAR2,
    x_attribute12                  IN     VARCHAR2,
    x_attribute13                  IN     VARCHAR2,
    x_attribute14                  IN     VARCHAR2,
    x_attribute15                  IN     VARCHAR2,
    x_attribute16                  IN     VARCHAR2,
    x_attribute17                  IN     VARCHAR2,
    x_attribute18                  IN     VARCHAR2,
    x_attribute19                  IN     VARCHAR2,
    x_attribute20                  IN     VARCHAR2,
    x_uoo_id                       IN     NUMBER,
    x_unit_section_ass_item_id     IN     NUMBER,
    x_unit_ass_item_id             IN     NUMBER,
    x_sua_ass_item_group_id        IN     NUMBER,
    x_midterm_mandatory_type_code  IN     VARCHAR2,
    x_midterm_weight_qty           IN     NUMBER,
    x_final_mandatory_type_code    IN     VARCHAR2,
    x_final_weight_qty             IN     NUMBER,
    x_submitted_date               IN     DATE,
    x_waived_flag                  IN     VARCHAR2,
    x_penalty_applied_flag         IN     VARCHAR2
  ) AS
    CURSOR c IS
      SELECT ROWID
      FROM   igs_as_su_atmpt_itm
      WHERE  person_id = x_person_id
      AND    course_cd = x_course_cd
      AND    ass_id = x_ass_id
      AND    creation_dt = l_altered_creation_dt
      AND    uoo_id = x_uoo_id;
Line: 797

    x_last_update_date       DATE;
Line: 798

    x_last_updated_by        NUMBER;
Line: 799

    x_last_update_login      NUMBER;
Line: 803

    x_program_update_date    DATE;
Line: 810

    x_last_update_date := SYSDATE;
Line: 812

      x_last_updated_by := 1;
Line: 813

      x_last_update_login := 0;
Line: 815

      x_last_updated_by := fnd_global.user_id;
Line: 816

      IF x_last_updated_by IS NULL THEN
        x_last_updated_by := -1;
Line: 819

      x_last_update_login := fnd_global.login_id;
Line: 820

      IF x_last_update_login IS NULL THEN
        x_last_update_login := -1;
Line: 830

        x_program_update_date := NULL;
Line: 832

        x_program_update_date := SYSDATE;
Line: 840

      p_action                       => 'INSERT',
      x_rowid                        => x_rowid,
      x_ass_id                       => x_ass_id,
      x_ass_pattern_id               => x_ass_pattern_id,
      x_attempt_number               => NVL (x_attempt_number, 1),
      x_cal_type                     => x_cal_type,
      x_ci_sequence_number           => x_ci_sequence_number,
      x_course_cd                    => x_course_cd,
      x_creation_dt                  => l_altered_creation_dt,
      x_logical_delete_dt            => x_logical_delete_dt,
      x_outcome_dt                   => x_outcome_dt,
      x_override_due_dt              => x_override_due_dt,
      x_person_id                    => x_person_id,
      x_s_default_ind                => NVL (x_s_default_ind, 'N'),
      x_tracking_id                  => x_tracking_id,
      x_unit_cd                      => x_unit_cd,
      x_creation_date                => x_last_update_date,
      x_created_by                   => x_last_updated_by,
      x_last_update_date             => x_last_update_date,
      x_last_updated_by              => x_last_updated_by,
      x_last_update_login            => x_last_update_login,
      x_grading_schema_cd            => x_grading_schema_cd,
      x_gs_version_number            => x_gs_version_number,
      x_grade                        => x_grade,
      x_outcome_comment_code         => x_outcome_comment_code,
      x_mark                         => x_mark,
      x_attribute_category           => x_attribute_category,
      x_attribute1                   => x_attribute1,
      x_attribute2                   => x_attribute2,
      x_attribute3                   => x_attribute3,
      x_attribute4                   => x_attribute4,
      x_attribute5                   => x_attribute5,
      x_attribute6                   => x_attribute6,
      x_attribute7                   => x_attribute7,
      x_attribute8                   => x_attribute8,
      x_attribute9                   => x_attribute9,
      x_attribute10                  => x_attribute10,
      x_attribute11                  => x_attribute11,
      x_attribute12                  => x_attribute12,
      x_attribute13                  => x_attribute13,
      x_attribute14                  => x_attribute14,
      x_attribute15                  => x_attribute15,
      x_attribute16                  => x_attribute16,
      x_attribute17                  => x_attribute17,
      x_attribute18                  => x_attribute18,
      x_attribute19                  => x_attribute19,
      x_attribute20                  => x_attribute20,
      x_uoo_id                       => x_uoo_id,
      x_unit_section_ass_item_id     => x_unit_section_ass_item_id,
      x_unit_ass_item_id             => x_unit_ass_item_id,
      x_sua_ass_item_group_id        => x_sua_ass_item_group_id,
      x_midterm_mandatory_type_code  => x_midterm_mandatory_type_code,
      x_midterm_weight_qty           => x_midterm_weight_qty,
      x_final_mandatory_type_code    => x_final_mandatory_type_code,
      x_final_weight_qty             => x_final_weight_qty,
      x_submitted_date               => x_submitted_date,
      x_waived_flag                  => x_waived_flag,
      x_penalty_applied_flag         => x_penalty_applied_flag
    );
Line: 903

  INSERT INTO igs_as_su_atmpt_itm
                (person_id, course_cd, unit_cd, cal_type,
                 ci_sequence_number, ass_id, creation_dt,
                 attempt_number, outcome_dt, override_due_dt,
                 tracking_id, logical_delete_dt, s_default_ind,
                 ass_pattern_id, creation_date, created_by, last_update_date,
                 last_updated_by, last_update_login, request_id, program_id, program_application_id,
                 program_update_date, grading_schema_cd, gs_version_number,
                 grade, outcome_comment_code, mark,
                 attribute_category, attribute1, attribute2,
                 attribute3, attribute4, attribute5,
                 attribute6, attribute7, attribute8,
                 attribute9, attribute10, attribute11,
                 attribute12, attribute13, attribute14,
                 attribute15, attribute16, attribute17,
                 attribute18, attribute19, attribute20,
                 uoo_id, unit_section_ass_item_id, unit_ass_item_id,
                 sua_ass_item_group_id, midterm_mandatory_type_code,
                 midterm_weight_qty, final_mandatory_type_code,
                 final_weight_qty, submitted_date, waived_flag,
                 penalty_applied_flag)
         VALUES (new_references.person_id, new_references.course_cd, new_references.unit_cd, new_references.cal_type,
                 new_references.ci_sequence_number, new_references.ass_id, new_references.creation_dt,
                 new_references.attempt_number, new_references.outcome_dt, new_references.override_due_dt,
                 new_references.tracking_id, new_references.logical_delete_dt, new_references.s_default_ind,
                 new_references.ass_pattern_id, x_last_update_date, x_last_updated_by, x_last_update_date,
                 x_last_updated_by, x_last_update_login, x_request_id, x_program_id, x_program_application_id,
                 x_program_update_date, new_references.grading_schema_cd, new_references.gs_version_number,
                 new_references.grade, new_references.outcome_comment_code, new_references.mark,
                 new_references.attribute_category, new_references.attribute1, new_references.attribute2,
                 new_references.attribute3, new_references.attribute4, new_references.attribute5,
                 new_references.attribute6, new_references.attribute7, new_references.attribute8,
                 new_references.attribute9, new_references.attribute10, new_references.attribute11,
                 new_references.attribute12, new_references.attribute13, new_references.attribute14,
                 new_references.attribute15, new_references.attribute16, new_references.attribute17,
                 new_references.attribute18, new_references.attribute19, new_references.attribute20,
                 new_references.uoo_id, new_references.unit_section_ass_item_id, new_references.unit_ass_item_id,
                 new_references.sua_ass_item_group_id, new_references.midterm_mandatory_type_code,
                 new_references.midterm_weight_qty, new_references.final_mandatory_type_code,
                 new_references.final_weight_qty, new_references.submitted_date, new_references.waived_flag,
                 new_references.penalty_applied_flag);
Line: 955

    after_dml (p_action => 'INSERT', x_rowid => x_rowid);
Line: 969

 END insert_row;
Line: 984

    x_logical_delete_dt            IN     DATE,
    x_s_default_ind                IN     VARCHAR2,
    x_ass_pattern_id               IN     NUMBER,
    x_grading_schema_cd            IN     VARCHAR2,
    x_gs_version_number            IN     NUMBER,
    x_grade                        IN     VARCHAR2,
    x_outcome_comment_code         IN     VARCHAR2,
    x_mark                         IN     NUMBER,
    x_attribute_category           IN     VARCHAR2,
    x_attribute1                   IN     VARCHAR2,
    x_attribute2                   IN     VARCHAR2,
    x_attribute3                   IN     VARCHAR2,
    x_attribute4                   IN     VARCHAR2,
    x_attribute5                   IN     VARCHAR2,
    x_attribute6                   IN     VARCHAR2,
    x_attribute7                   IN     VARCHAR2,
    x_attribute8                   IN     VARCHAR2,
    x_attribute9                   IN     VARCHAR2,
    x_attribute10                  IN     VARCHAR2,
    x_attribute11                  IN     VARCHAR2,
    x_attribute12                  IN     VARCHAR2,
    x_attribute13                  IN     VARCHAR2,
    x_attribute14                  IN     VARCHAR2,
    x_attribute15                  IN     VARCHAR2,
    x_attribute16                  IN     VARCHAR2,
    x_attribute17                  IN     VARCHAR2,
    x_attribute18                  IN     VARCHAR2,
    x_attribute19                  IN     VARCHAR2,
    x_attribute20                  IN     VARCHAR2,
    x_uoo_id                       IN     NUMBER,
    x_unit_section_ass_item_id     IN     NUMBER,
    x_unit_ass_item_id             IN     NUMBER,
    x_sua_ass_item_group_id        IN     NUMBER,
    x_midterm_mandatory_type_code  IN     VARCHAR2,
    x_midterm_weight_qty           IN     NUMBER,
    x_final_mandatory_type_code    IN     VARCHAR2,
    x_final_weight_qty             IN     NUMBER,
    x_submitted_date               IN     DATE,
    x_waived_flag                  IN     VARCHAR2,
    x_penalty_applied_flag         IN     VARCHAR2
  ) AS
    CURSOR c1 IS
      SELECT     attempt_number,
                 outcome_dt,
                 override_due_dt,
                 tracking_id,
                 logical_delete_dt,
                 s_default_ind,
                 ass_pattern_id,
                 grading_schema_cd,
                 gs_version_number,
                 grade,
                 outcome_comment_code,
                 mark,
                 attribute_category,
                 attribute1,
                 attribute2,
                 attribute3,
                 attribute4,
                 attribute5,
                 attribute6,
                 attribute7,
                 attribute8,
                 attribute9,
                 attribute10,
                 attribute11,
                 attribute12,
                 attribute13,
                 attribute14,
                 attribute15,
                 attribute16,
                 attribute17,
                 attribute18,
                 attribute19,
                 attribute20,
                 uoo_id,
                 unit_section_ass_item_id,
                 unit_ass_item_id,
                 sua_ass_item_group_id,
                 midterm_mandatory_type_code,
                 midterm_weight_qty,
                 final_mandatory_type_code,
                 final_weight_qty,
                 submitted_date,
                 waived_flag,
                 penalty_applied_flag
      FROM       igs_as_su_atmpt_itm
      WHERE      ROWID = x_rowid
      FOR UPDATE NOWAIT;
Line: 1078

      fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
Line: 1101

        AND ((TRUNC (tlinfo.logical_delete_dt) = TRUNC (x_logical_delete_dt))
             OR ((tlinfo.logical_delete_dt IS NULL)
                 AND (x_logical_delete_dt IS NULL)
                )
            )
        AND (tlinfo.s_default_ind = x_s_default_ind)
        AND ((tlinfo.ass_pattern_id = x_ass_pattern_id)
             OR ((tlinfo.ass_pattern_id IS NULL)
                 AND (x_ass_pattern_id IS NULL)
                )
            )
        AND ((tlinfo.grading_schema_cd = x_grading_schema_cd)
             OR ((tlinfo.grading_schema_cd IS NULL)
                 AND (x_grading_schema_cd IS NULL)
                )
            )
        AND ((tlinfo.gs_version_number = x_gs_version_number)
             OR ((tlinfo.gs_version_number IS NULL)
                 AND (x_gs_version_number IS NULL)
                )
            )
        AND ((tlinfo.grade = x_grade)
             OR ((tlinfo.grade IS NULL)
                 AND (x_grade IS NULL)
                )
            )
        AND ((tlinfo.outcome_comment_code = x_outcome_comment_code)
             OR ((tlinfo.outcome_comment_code IS NULL)
                 AND (x_outcome_comment_code IS NULL)
                )
            )
        AND ((tlinfo.mark = x_mark)
             OR ((tlinfo.mark IS NULL)
                 AND (x_mark IS NULL)
                )
            )
        AND ((tlinfo.attribute_category = x_attribute_category)
             OR ((tlinfo.attribute_category IS NULL)
                 AND (x_attribute_category IS NULL)
                )
            )
        AND ((tlinfo.attribute1 = x_attribute1)
             OR ((tlinfo.attribute1 IS NULL)
                 AND (x_attribute1 IS NULL)
                )
            )
        AND ((tlinfo.attribute2 = x_attribute2)
             OR ((tlinfo.attribute2 IS NULL)
                 AND (x_attribute2 IS NULL)
                )
            )
        AND ((tlinfo.attribute3 = x_attribute3)
             OR ((tlinfo.attribute3 IS NULL)
                 AND (x_attribute3 IS NULL)
                )
            )
        AND ((tlinfo.attribute4 = x_attribute4)
             OR ((tlinfo.attribute4 IS NULL)
                 AND (x_attribute4 IS NULL)
                )
            )
        AND ((tlinfo.attribute5 = x_attribute5)
             OR ((tlinfo.attribute5 IS NULL)
                 AND (x_attribute5 IS NULL)
                )
            )
        AND ((tlinfo.attribute6 = x_attribute6)
             OR ((tlinfo.attribute6 IS NULL)
                 AND (x_attribute6 IS NULL)
                )
            )
        AND ((tlinfo.attribute7 = x_attribute7)
             OR ((tlinfo.attribute7 IS NULL)
                 AND (x_attribute7 IS NULL)
                )
            )
        AND ((tlinfo.attribute8 = x_attribute8)
             OR ((tlinfo.attribute8 IS NULL)
                 AND (x_attribute8 IS NULL)
                )
            )
        AND ((tlinfo.attribute9 = x_attribute9)
             OR ((tlinfo.attribute9 IS NULL)
                 AND (x_attribute9 IS NULL)
                )
            )
        AND ((tlinfo.attribute10 = x_attribute10)
             OR ((tlinfo.attribute10 IS NULL)
                 AND (x_attribute10 IS NULL)
                )
            )
        AND ((tlinfo.attribute11 = x_attribute11)
             OR ((tlinfo.attribute11 IS NULL)
                 AND (x_attribute11 IS NULL)
                )
            )
        AND ((tlinfo.attribute12 = x_attribute12)
             OR ((tlinfo.attribute12 IS NULL)
                 AND (x_attribute12 IS NULL)
                )
            )
        AND ((tlinfo.attribute13 = x_attribute13)
             OR ((tlinfo.attribute13 IS NULL)
                 AND (x_attribute13 IS NULL)
                )
            )
        AND ((tlinfo.attribute14 = x_attribute14)
             OR ((tlinfo.attribute14 IS NULL)
                 AND (x_attribute14 IS NULL)
                )
            )
        AND ((tlinfo.attribute15 = x_attribute15)
             OR ((tlinfo.attribute15 IS NULL)
                 AND (x_attribute15 IS NULL)
                )
            )
        AND ((tlinfo.attribute16 = x_attribute16)
             OR ((tlinfo.attribute16 IS NULL)
                 AND (x_attribute16 IS NULL)
                )
            )
        AND ((tlinfo.attribute17 = x_attribute17)
             OR ((tlinfo.attribute17 IS NULL)
                 AND (x_attribute17 IS NULL)
                )
            )
        AND ((tlinfo.attribute18 = x_attribute18)
             OR ((tlinfo.attribute18 IS NULL)
                 AND (x_attribute18 IS NULL)
                )
            )
        AND ((tlinfo.attribute19 = x_attribute19)
             OR ((tlinfo.attribute19 IS NULL)
                 AND (x_attribute19 IS NULL)
                )
            )
        AND ((tlinfo.attribute20 = x_attribute20)
             OR ((tlinfo.attribute20 IS NULL)
                 AND (x_attribute20 IS NULL)
                )
            )
        AND ((tlinfo.attribute19 = x_attribute19)
             OR ((tlinfo.attribute19 IS NULL)
                 AND (x_attribute19 IS NULL)
                )
            )
        AND ((tlinfo.unit_section_ass_item_id = x_unit_section_ass_item_id)
             OR ((tlinfo.unit_section_ass_item_id IS NULL)
                 AND (x_unit_section_ass_item_id IS NULL)
                )
            )
        AND ((tlinfo.unit_ass_item_id = x_unit_ass_item_id)
             OR ((tlinfo.unit_ass_item_id IS NULL)
                 AND (x_unit_ass_item_id IS NULL)
                )
            )
        AND ((tlinfo.sua_ass_item_group_id = x_sua_ass_item_group_id)
             OR ((tlinfo.sua_ass_item_group_id IS NULL)
                 AND (x_sua_ass_item_group_id IS NULL)
                )
            )
        AND ((tlinfo.midterm_mandatory_type_code = x_midterm_mandatory_type_code)
             OR ((tlinfo.midterm_mandatory_type_code IS NULL)
                 AND (x_midterm_mandatory_type_code IS NULL)
                )
            )
        AND ((tlinfo.midterm_weight_qty = x_midterm_weight_qty)
             OR ((tlinfo.midterm_weight_qty IS NULL)
                 AND (x_midterm_weight_qty IS NULL)
                )
            )
        AND ((tlinfo.final_mandatory_type_code = x_final_mandatory_type_code)
             OR ((tlinfo.final_mandatory_type_code IS NULL)
                 AND (x_final_mandatory_type_code IS NULL)
                )
            )
        AND ((tlinfo.final_weight_qty = x_final_weight_qty)
             OR ((tlinfo.final_weight_qty IS NULL)
                 AND (x_final_weight_qty IS NULL)
                )
            )
        AND ((tlinfo.submitted_date = x_submitted_date)
             OR ((tlinfo.submitted_date IS NULL)
                 AND (x_submitted_date IS NULL)
                )
            )
        AND ((tlinfo.waived_flag = x_waived_flag)
             OR ((tlinfo.waived_flag IS NULL)
                 AND (x_waived_flag IS NULL)
                )
            )
        AND ((tlinfo.penalty_applied_flag = x_penalty_applied_flag)
             OR ((tlinfo.penalty_applied_flag IS NULL)
                 AND (x_penalty_applied_flag IS NULL)
                )
            )
       ) THEN
      NULL;
Line: 1307

  PROCEDURE update_row (
    x_rowid                        IN     VARCHAR2,
    x_person_id                    IN     NUMBER,
    x_course_cd                    IN     VARCHAR2,
    x_unit_cd                      IN     VARCHAR2,
    x_cal_type                     IN     VARCHAR2,
    x_ci_sequence_number           IN     NUMBER,
    x_ass_id                       IN     NUMBER,
    x_creation_dt                  IN     DATE,
    x_attempt_number               IN     NUMBER,
    x_outcome_dt                   IN     DATE,
    x_override_due_dt              IN     DATE,
    x_tracking_id                  IN     NUMBER,
    x_logical_delete_dt            IN     DATE,
    x_s_default_ind                IN     VARCHAR2,
    x_ass_pattern_id               IN     NUMBER,
    x_mode                         IN     VARCHAR2 DEFAULT 'R',
    x_grading_schema_cd            IN     VARCHAR2,
    x_gs_version_number            IN     NUMBER,
    x_grade                        IN     VARCHAR2,
    x_outcome_comment_code         IN     VARCHAR2,
    x_mark                         IN     NUMBER,
    x_attribute_category           IN     VARCHAR2,
    x_attribute1                   IN     VARCHAR2,
    x_attribute2                   IN     VARCHAR2,
    x_attribute3                   IN     VARCHAR2,
    x_attribute4                   IN     VARCHAR2,
    x_attribute5                   IN     VARCHAR2,
    x_attribute6                   IN     VARCHAR2,
    x_attribute7                   IN     VARCHAR2,
    x_attribute8                   IN     VARCHAR2,
    x_attribute9                   IN     VARCHAR2,
    x_attribute10                  IN     VARCHAR2,
    x_attribute11                  IN     VARCHAR2,
    x_attribute12                  IN     VARCHAR2,
    x_attribute13                  IN     VARCHAR2,
    x_attribute14                  IN     VARCHAR2,
    x_attribute15                  IN     VARCHAR2,
    x_attribute16                  IN     VARCHAR2,
    x_attribute17                  IN     VARCHAR2,
    x_attribute18                  IN     VARCHAR2,
    x_attribute19                  IN     VARCHAR2,
    x_attribute20                  IN     VARCHAR2,
    x_uoo_id                       IN     NUMBER,
    x_unit_section_ass_item_id     IN     NUMBER,
    x_unit_ass_item_id             IN     NUMBER,
    x_sua_ass_item_group_id        IN     NUMBER,
    x_midterm_mandatory_type_code  IN     VARCHAR2,
    x_midterm_weight_qty           IN     NUMBER,
    x_final_mandatory_type_code    IN     VARCHAR2,
    x_final_weight_qty             IN     NUMBER,
    x_submitted_date               IN     DATE,
    x_waived_flag                  IN     VARCHAR2,
    x_penalty_applied_flag         IN     VARCHAR2
  ) AS
    x_last_update_date       DATE;
Line: 1363

    x_last_updated_by        NUMBER;
Line: 1364

    x_last_update_login      NUMBER;
Line: 1368

    x_program_update_date    DATE;
Line: 1370

    x_last_update_date := SYSDATE;
Line: 1372

      x_last_updated_by := 1;
Line: 1373

      x_last_update_login := 0;
Line: 1375

      x_last_updated_by := fnd_global.user_id;
Line: 1376

      IF x_last_updated_by IS NULL THEN
        x_last_updated_by := -1;
Line: 1379

      x_last_update_login := fnd_global.login_id;
Line: 1380

      IF x_last_update_login IS NULL THEN
        x_last_update_login := -1;
Line: 1389

      p_action                       => 'UPDATE',
      x_rowid                        => x_rowid,
      x_ass_id                       => x_ass_id,
      x_ass_pattern_id               => x_ass_pattern_id,
      x_attempt_number               => x_attempt_number,
      x_cal_type                     => x_cal_type,
      x_ci_sequence_number           => x_ci_sequence_number,
      x_course_cd                    => x_course_cd,
      x_creation_dt                  => x_creation_dt,
      x_logical_delete_dt            => x_logical_delete_dt,
      x_outcome_dt                   => x_outcome_dt,
      x_override_due_dt              => x_override_due_dt,
      x_person_id                    => x_person_id,
      x_s_default_ind                => x_s_default_ind,
      x_tracking_id                  => x_tracking_id,
      x_unit_cd                      => x_unit_cd,
      x_creation_date                => x_last_update_date,
      x_created_by                   => x_last_updated_by,
      x_last_update_date             => x_last_update_date,
      x_last_updated_by              => x_last_updated_by,
      x_last_update_login            => x_last_update_login,
      x_grading_schema_cd            => x_grading_schema_cd,
      x_gs_version_number            => x_gs_version_number,
      x_grade                        => x_grade,
      x_outcome_comment_code         => x_outcome_comment_code,
      x_mark                         => x_mark,
      x_attribute_category           => x_attribute_category,
      x_attribute1                   => x_attribute1,
      x_attribute2                   => x_attribute2,
      x_attribute3                   => x_attribute3,
      x_attribute4                   => x_attribute4,
      x_attribute5                   => x_attribute5,
      x_attribute6                   => x_attribute6,
      x_attribute7                   => x_attribute7,
      x_attribute8                   => x_attribute8,
      x_attribute9                   => x_attribute9,
      x_attribute10                  => x_attribute10,
      x_attribute11                  => x_attribute11,
      x_attribute12                  => x_attribute12,
      x_attribute13                  => x_attribute13,
      x_attribute14                  => x_attribute14,
      x_attribute15                  => x_attribute15,
      x_attribute16                  => x_attribute16,
      x_attribute17                  => x_attribute17,
      x_attribute18                  => x_attribute18,
      x_attribute19                  => x_attribute19,
      x_attribute20                  => x_attribute20,
      x_uoo_id                       => x_uoo_id,
      x_unit_section_ass_item_id     => x_unit_section_ass_item_id,
      x_unit_ass_item_id             => x_unit_ass_item_id,
      x_sua_ass_item_group_id        => x_sua_ass_item_group_id,
      x_midterm_mandatory_type_code  => x_midterm_mandatory_type_code,
      x_midterm_weight_qty           => x_midterm_weight_qty,
      x_final_mandatory_type_code    => x_final_mandatory_type_code,
      x_final_weight_qty             => x_final_weight_qty,
      x_submitted_date               => x_submitted_date,
      x_waived_flag                  => x_waived_flag,
      x_penalty_applied_flag         => x_penalty_applied_flag
    );
Line: 1456

        x_program_update_date := old_references.program_update_date;
Line: 1458

        x_program_update_date := SYSDATE;
Line: 1464

  UPDATE igs_as_su_atmpt_itm
       SET attempt_number = new_references.attempt_number,
           outcome_dt = new_references.outcome_dt,
           override_due_dt = new_references.override_due_dt,
           tracking_id = new_references.tracking_id,
           logical_delete_dt = new_references.logical_delete_dt,
           s_default_ind = new_references.s_default_ind,
           ass_pattern_id = new_references.ass_pattern_id,
           last_update_date = x_last_update_date,
           last_updated_by = x_last_updated_by,
           last_update_login = x_last_update_login,
           request_id = x_request_id,
           program_id = x_program_id,
           program_application_id = x_program_application_id,
           program_update_date = x_program_update_date,
           grading_schema_cd = new_references.grading_schema_cd,
           gs_version_number = new_references.gs_version_number,
           grade = new_references.grade,
           outcome_comment_code = new_references.outcome_comment_code,
           mark = new_references.mark,
           attribute_category = new_references.attribute_category,
           attribute1 = new_references.attribute1,
           attribute2 = new_references.attribute2,
           attribute3 = new_references.attribute3,
           attribute4 = new_references.attribute4,
           attribute5 = new_references.attribute5,
           attribute6 = new_references.attribute6,
           attribute7 = new_references.attribute7,
           attribute8 = new_references.attribute8,
           attribute9 = new_references.attribute9,
           attribute10 = new_references.attribute10,
           attribute11 = new_references.attribute11,
           attribute12 = new_references.attribute12,
           attribute13 = new_references.attribute13,
           attribute14 = new_references.attribute14,
           attribute15 = new_references.attribute15,
           attribute16 = new_references.attribute16,
           attribute17 = new_references.attribute17,
           attribute18 = new_references.attribute18,
           attribute19 = new_references.attribute19,
           attribute20 = new_references.attribute20,
           unit_section_ass_item_id = new_references.unit_section_ass_item_id,
           unit_ass_item_id = new_references.unit_ass_item_id,
           sua_ass_item_group_id = new_references.sua_ass_item_group_id,
           midterm_mandatory_type_code = new_references.midterm_mandatory_type_code,
           midterm_weight_qty = new_references.midterm_weight_qty,
           final_mandatory_type_code = new_references.final_mandatory_type_code,
           final_weight_qty = new_references.final_weight_qty,
           submitted_date = new_references.submitted_date,
           waived_flag = new_references.waived_flag,
           penalty_applied_flag = new_references.penalty_applied_flag
     WHERE ROWID = x_rowid;
Line: 1526

    after_dml (p_action => 'UPDATE', x_rowid => x_rowid);
Line: 1540

 END update_row;
Line: 1555

    x_logical_delete_dt            IN     DATE,
    x_s_default_ind                IN     VARCHAR2,
    x_ass_pattern_id               IN     NUMBER,
    x_mode                         IN     VARCHAR2 DEFAULT 'R',
    x_grading_schema_cd            IN     VARCHAR2,
    x_gs_version_number            IN     NUMBER,
    x_grade                        IN     VARCHAR2,
    x_outcome_comment_code         IN     VARCHAR2,
    x_mark                         IN     NUMBER,
    x_attribute_category           IN     VARCHAR2,
    x_attribute1                   IN     VARCHAR2,
    x_attribute2                   IN     VARCHAR2,
    x_attribute3                   IN     VARCHAR2,
    x_attribute4                   IN     VARCHAR2,
    x_attribute5                   IN     VARCHAR2,
    x_attribute6                   IN     VARCHAR2,
    x_attribute7                   IN     VARCHAR2,
    x_attribute8                   IN     VARCHAR2,
    x_attribute9                   IN     VARCHAR2,
    x_attribute10                  IN     VARCHAR2,
    x_attribute11                  IN     VARCHAR2,
    x_attribute12                  IN     VARCHAR2,
    x_attribute13                  IN     VARCHAR2,
    x_attribute14                  IN     VARCHAR2,
    x_attribute15                  IN     VARCHAR2,
    x_attribute16                  IN     VARCHAR2,
    x_attribute17                  IN     VARCHAR2,
    x_attribute18                  IN     VARCHAR2,
    x_attribute19                  IN     VARCHAR2,
    x_attribute20                  IN     VARCHAR2,
    x_uoo_id                       IN     NUMBER,
    x_unit_section_ass_item_id     IN     NUMBER,
    x_unit_ass_item_id             IN     NUMBER,
    x_sua_ass_item_group_id        IN     NUMBER,
    x_midterm_mandatory_type_code  IN     VARCHAR2,
    x_midterm_weight_qty           IN     NUMBER,
    x_final_mandatory_type_code    IN     VARCHAR2,
    x_final_weight_qty             IN     NUMBER,
    x_submitted_date               IN     DATE,
    x_waived_flag                  IN     VARCHAR2,
    x_penalty_applied_flag         IN     VARCHAR2
  ) AS
    CURSOR c1 IS
      SELECT ROWID
      FROM   igs_as_su_atmpt_itm
      WHERE  person_id = x_person_id
      AND    course_cd = x_course_cd
      AND    ass_id = x_ass_id
      AND    creation_dt = x_creation_dt
      AND    uoo_id = x_uoo_id;
Line: 1610

      insert_row (
        x_rowid,
        x_person_id,
        x_course_cd,
        x_unit_cd,
        x_cal_type,
        x_ci_sequence_number,
        x_ass_id,
        x_creation_dt,
        x_attempt_number,
        x_outcome_dt,
        x_override_due_dt,
        x_tracking_id,
        x_logical_delete_dt,
        x_s_default_ind,
        x_ass_pattern_id,
        x_mode,
        x_grading_schema_cd,
        x_gs_version_number,
        x_grade,
        x_outcome_comment_code,
        x_mark,
        x_attribute_category,
        x_attribute1,
        x_attribute2,
        x_attribute3,
        x_attribute4,
        x_attribute5,
        x_attribute6,
        x_attribute7,
        x_attribute8,
        x_attribute9,
        x_attribute10,
        x_attribute11,
        x_attribute12,
        x_attribute13,
        x_attribute14,
        x_attribute15,
        x_attribute16,
        x_attribute17,
        x_attribute18,
        x_attribute19,
        x_attribute20,
        x_uoo_id,
        x_unit_section_ass_item_id,
        x_unit_ass_item_id,
        x_sua_ass_item_group_id,
        x_midterm_mandatory_type_code,
        x_midterm_weight_qty,
        x_final_mandatory_type_code,
        x_final_weight_qty,
        x_submitted_date,
        x_waived_flag,
        x_penalty_applied_flag
      );
Line: 1668

    update_row (
      x_rowid,
      x_person_id,
      x_course_cd,
      x_unit_cd,
      x_cal_type,
      x_ci_sequence_number,
      x_ass_id,
      x_creation_dt,
      x_attempt_number,
      x_outcome_dt,
      x_override_due_dt,
      x_tracking_id,
      x_logical_delete_dt,
      x_s_default_ind,
      x_ass_pattern_id,
      x_mode,
      x_grading_schema_cd,
      x_gs_version_number,
      x_grade,
      x_outcome_comment_code,
      x_mark,
      x_attribute_category,
      x_attribute1,
      x_attribute2,
      x_attribute3,
      x_attribute4,
      x_attribute5,
      x_attribute6,
      x_attribute7,
      x_attribute8,
      x_attribute9,
      x_attribute10,
      x_attribute11,
      x_attribute12,
      x_attribute13,
      x_attribute14,
      x_attribute15,
      x_attribute16,
      x_attribute17,
      x_attribute18,
      x_attribute19,
      x_attribute20,
      x_uoo_id,
      x_unit_section_ass_item_id,
      x_unit_ass_item_id,
      x_sua_ass_item_group_id,
      x_midterm_mandatory_type_code,
      x_midterm_weight_qty,
      x_final_mandatory_type_code,
      x_final_weight_qty,
      x_submitted_date,
      x_waived_flag,
      x_penalty_applied_flag
    );
Line: 1725

  PROCEDURE delete_row (x_rowid IN VARCHAR2,
  x_mode IN VARCHAR2) AS
  BEGIN
    before_dml (p_action => 'DELETE', x_rowid => x_rowid);
Line: 1732

  DELETE FROM igs_as_su_atmpt_itm
          WHERE ROWID = x_rowid;
Line: 1744

    after_dml (p_action => 'DELETE', x_rowid => x_rowid);
Line: 1745

  END delete_row;