DBA Data[Home] [Help]

APPS.IGS_FI_LB_RECT_ERRS_PKG SQL Statements

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

Line: 63

    x_last_update_date                  IN     DATE,
    x_last_updated_by                   IN     NUMBER,
    x_last_update_login                 IN     NUMBER
  ) AS
  /*
  ||  Created By : [email protected]
  ||  Created On : 05-JUN-2003
  ||  Purpose : Initialises the Old and New references for the columns of the table.
  ||  Known limitations, enhancements or remarks :
  ||  Change History :
  ||  Who             When            What
  ||  (reverse chronological order - newest change first)
  */

    CURSOR cur_old_ref_values IS
      SELECT   *
      FROM     igs_fi_lb_rect_errs
      WHERE    rowid = x_rowid;
Line: 90

    IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
      CLOSE cur_old_ref_values;
Line: 92

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

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

    new_references.last_update_date                  := x_last_update_date;
Line: 160

    new_references.last_updated_by                   := x_last_updated_by;
Line: 161

    new_references.last_update_login                 := x_last_update_login;
Line: 184

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

      SELECT   rowid
      FROM     igs_fi_lb_rect_errs
      WHERE    lockbox_receipt_error_id = x_lockbox_receipt_error_id
      FOR UPDATE NOWAIT;
Line: 300

    x_last_update_date                  IN     DATE,
    x_last_updated_by                   IN     NUMBER,
    x_last_update_login                 IN     NUMBER
  ) AS
  /*
  ||  Created By : [email protected]
  ||  Created On : 05-JUN-2003
  ||  Purpose : Initialises the columns, Checks Constraints, Calls the
  ||            Trigger Handlers for the table, before any DML operation.
  ||  Known limitations, enhancements or remarks :
  ||  Change History :
  ||  Who             When            What
  ||  (reverse chronological order - newest change first)
  */
  BEGIN

    set_column_values (
      p_action,
      x_rowid,
      x_lockbox_receipt_error_id,
      x_lockbox_interface_id,
      x_item_number,
      x_lockbox_name,
      x_receipt_amt,
      x_batch_name,
      x_party_number,
      x_payer_name,
      x_check_cd,
      x_deposit_date,
      x_credit_type_cd,
      x_fee_cal_instance_cd,
      x_charge_cd1,
      x_charge_cd2,
      x_charge_cd3,
      x_charge_cd4,
      x_charge_cd5,
      x_charge_cd6,
      x_charge_cd7,
      x_charge_cd8,
      x_applied_amt1,
      x_applied_amt2,
      x_applied_amt3,
      x_applied_amt4,
      x_applied_amt5,
      x_applied_amt6,
      x_applied_amt7,
      x_applied_amt8,
      x_adm_application_id,
      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_creation_date,
      x_created_by,
      x_last_update_date,
      x_last_updated_by,
      x_last_update_login
    );
Line: 376

    IF (p_action = 'INSERT') THEN
      -- Call all the procedures related to Before Insert.
      IF ( get_pk_for_validation(
             new_references.lockbox_receipt_error_id
           )
         ) THEN
        fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
Line: 387

    ELSIF (p_action = 'UPDATE') THEN
      -- Call all the procedures related to Before Update.
      check_parent_existance;
Line: 390

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

    ELSIF (p_action = 'VALIDATE_INSERT') THEN
      -- Call all the procedures related to Before Insert.
      IF ( get_pk_for_validation (
             new_references.lockbox_receipt_error_id
           )
         ) THEN
        fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
Line: 403

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

  PROCEDURE insert_row (
    x_rowid                             IN OUT NOCOPY VARCHAR2,
    x_lockbox_receipt_error_id          IN OUT NOCOPY NUMBER,
    x_lockbox_interface_id              IN     NUMBER,
    x_item_number                       IN     NUMBER,
    x_lockbox_name                      IN     VARCHAR2,
    x_receipt_amt                       IN     NUMBER,
    x_batch_name                        IN     VARCHAR2,
    x_party_number                      IN     VARCHAR2,
    x_payer_name                        IN     VARCHAR2,
    x_check_cd                          IN     VARCHAR2,
    x_deposit_date                      IN     DATE,
    x_credit_type_cd                    IN     VARCHAR2,
    x_fee_cal_instance_cd               IN     VARCHAR2,
    x_charge_cd1                        IN     VARCHAR2,
    x_charge_cd2                        IN     VARCHAR2,
    x_charge_cd3                        IN     VARCHAR2,
    x_charge_cd4                        IN     VARCHAR2,
    x_charge_cd5                        IN     VARCHAR2,
    x_charge_cd6                        IN     VARCHAR2,
    x_charge_cd7                        IN     VARCHAR2,
    x_charge_cd8                        IN     VARCHAR2,
    x_applied_amt1                      IN     NUMBER,
    x_applied_amt2                      IN     NUMBER,
    x_applied_amt3                      IN     NUMBER,
    x_applied_amt4                      IN     NUMBER,
    x_applied_amt5                      IN     NUMBER,
    x_applied_amt6                      IN     NUMBER,
    x_applied_amt7                      IN     NUMBER,
    x_applied_amt8                      IN     NUMBER,
    x_adm_application_id                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_mode                              IN     VARCHAR2
  ) AS
  /*
  ||  Created By : [email protected]
  ||  Created On : 05-JUN-2003
  ||  Purpose : Handles the INSERT DML logic for the table.
  ||  Known limitations, enhancements or remarks :
  ||  Change History :
  ||  Who             When            What
  ||  (reverse chronological order - newest change first)
  */

    x_last_update_date           DATE;
Line: 475

    x_last_updated_by            NUMBER;
Line: 476

    x_last_update_login          NUMBER;
Line: 480

    x_program_update_date        DATE;
Line: 484

    x_last_update_date := SYSDATE;
Line: 486

      x_last_updated_by := 1;
Line: 487

      x_last_update_login := 0;
Line: 489

      x_last_updated_by := fnd_global.user_id;
Line: 490

      IF (x_last_updated_by IS NULL) THEN
        x_last_updated_by := -1;
Line: 493

      x_last_update_login := fnd_global.login_id;
Line: 494

      IF (x_last_update_login IS NULL) THEN
        x_last_update_login := -1;
Line: 505

        x_program_update_date    := NULL;
Line: 507

        x_program_update_date    := SYSDATE;
Line: 511

      fnd_message.set_token ('ROUTINE', 'IGS_FI_LB_RECT_ERRS_PKG.INSERT_ROW');
Line: 516

    SELECT igs_fi_lb_rect_errs_s.NEXTVAL
    INTO x_lockbox_receipt_error_id
    FROM dual;
Line: 521

      p_action                            => 'INSERT',
      x_rowid                             => x_rowid,
      x_lockbox_receipt_error_id          => x_lockbox_receipt_error_id,
      x_lockbox_interface_id              => x_lockbox_interface_id,
      x_item_number                       => x_item_number,
      x_lockbox_name                      => x_lockbox_name,
      x_receipt_amt                       => x_receipt_amt,
      x_batch_name                        => x_batch_name,
      x_party_number                      => x_party_number,
      x_payer_name                        => x_payer_name,
      x_check_cd                          => x_check_cd,
      x_deposit_date                      => x_deposit_date,
      x_credit_type_cd                    => x_credit_type_cd,
      x_fee_cal_instance_cd               => x_fee_cal_instance_cd,
      x_charge_cd1                        => x_charge_cd1,
      x_charge_cd2                        => x_charge_cd2,
      x_charge_cd3                        => x_charge_cd3,
      x_charge_cd4                        => x_charge_cd4,
      x_charge_cd5                        => x_charge_cd5,
      x_charge_cd6                        => x_charge_cd6,
      x_charge_cd7                        => x_charge_cd7,
      x_charge_cd8                        => x_charge_cd8,
      x_applied_amt1                      => x_applied_amt1,
      x_applied_amt2                      => x_applied_amt2,
      x_applied_amt3                      => x_applied_amt3,
      x_applied_amt4                      => x_applied_amt4,
      x_applied_amt5                      => x_applied_amt5,
      x_applied_amt6                      => x_applied_amt6,
      x_applied_amt7                      => x_applied_amt7,
      x_applied_amt8                      => x_applied_amt8,
      x_adm_application_id                => x_adm_application_id,
      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_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
    );
Line: 580

    INSERT INTO igs_fi_lb_rect_errs (
      lockbox_receipt_error_id,
      lockbox_interface_id,
      item_number,
      lockbox_name,
      receipt_amt,
      batch_name,
      party_number,
      payer_name,
      check_cd,
      deposit_date,
      credit_type_cd,
      fee_cal_instance_cd,
      charge_cd1,
      charge_cd2,
      charge_cd3,
      charge_cd4,
      charge_cd5,
      charge_cd6,
      charge_cd7,
      charge_cd8,
      applied_amt1,
      applied_amt2,
      applied_amt3,
      applied_amt4,
      applied_amt5,
      applied_amt6,
      applied_amt7,
      applied_amt8,
      adm_application_id,
      attribute_category,
      attribute1,
      attribute2,
      attribute3,
      attribute4,
      attribute5,
      attribute6,
      attribute7,
      attribute8,
      attribute9,
      attribute10,
      attribute11,
      attribute12,
      attribute13,
      attribute14,
      attribute15,
      attribute16,
      attribute17,
      attribute18,
      attribute19,
      attribute20,
      creation_date,
      created_by,
      last_update_date,
      last_updated_by,
      last_update_login,
      request_id,
      program_id,
      program_application_id,
      program_update_date
    ) VALUES (
      new_references.lockbox_receipt_error_id,
      new_references.lockbox_interface_id,
      new_references.item_number,
      new_references.lockbox_name,
      new_references.receipt_amt,
      new_references.batch_name,
      new_references.party_number,
      new_references.payer_name,
      new_references.check_cd,
      new_references.deposit_date,
      new_references.credit_type_cd,
      new_references.fee_cal_instance_cd,
      new_references.charge_cd1,
      new_references.charge_cd2,
      new_references.charge_cd3,
      new_references.charge_cd4,
      new_references.charge_cd5,
      new_references.charge_cd6,
      new_references.charge_cd7,
      new_references.charge_cd8,
      new_references.applied_amt1,
      new_references.applied_amt2,
      new_references.applied_amt3,
      new_references.applied_amt4,
      new_references.applied_amt5,
      new_references.applied_amt6,
      new_references.applied_amt7,
      new_references.applied_amt8,
      new_references.adm_application_id,
      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,
      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
    ) RETURNING ROWID INTO x_rowid;
Line: 702

  END insert_row;
Line: 768

      SELECT
        lockbox_interface_id,
        item_number,
        lockbox_name,
        receipt_amt,
        batch_name,
        party_number,
        payer_name,
        check_cd,
        deposit_date,
        credit_type_cd,
        fee_cal_instance_cd,
        charge_cd1,
        charge_cd2,
        charge_cd3,
        charge_cd4,
        charge_cd5,
        charge_cd6,
        charge_cd7,
        charge_cd8,
        applied_amt1,
        applied_amt2,
        applied_amt3,
        applied_amt4,
        applied_amt5,
        applied_amt6,
        applied_amt7,
        applied_amt8,
        adm_application_id,
        attribute_category,
        attribute1,
        attribute2,
        attribute3,
        attribute4,
        attribute5,
        attribute6,
        attribute7,
        attribute8,
        attribute9,
        attribute10,
        attribute11,
        attribute12,
        attribute13,
        attribute14,
        attribute15,
        attribute16,
        attribute17,
        attribute18,
        attribute19,
        attribute20
      FROM  igs_fi_lb_rect_errs
      WHERE rowid = x_rowid
      FOR UPDATE NOWAIT;
Line: 829

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

  PROCEDURE update_row (
    x_rowid                             IN     VARCHAR2,
    x_lockbox_receipt_error_id          IN     NUMBER,
    x_lockbox_interface_id              IN     NUMBER,
    x_item_number                       IN     NUMBER,
    x_lockbox_name                      IN     VARCHAR2,
    x_receipt_amt                       IN     NUMBER,
    x_batch_name                        IN     VARCHAR2,
    x_party_number                      IN     VARCHAR2,
    x_payer_name                        IN     VARCHAR2,
    x_check_cd                          IN     VARCHAR2,
    x_deposit_date                      IN     DATE,
    x_credit_type_cd                    IN     VARCHAR2,
    x_fee_cal_instance_cd               IN     VARCHAR2,
    x_charge_cd1                        IN     VARCHAR2,
    x_charge_cd2                        IN     VARCHAR2,
    x_charge_cd3                        IN     VARCHAR2,
    x_charge_cd4                        IN     VARCHAR2,
    x_charge_cd5                        IN     VARCHAR2,
    x_charge_cd6                        IN     VARCHAR2,
    x_charge_cd7                        IN     VARCHAR2,
    x_charge_cd8                        IN     VARCHAR2,
    x_applied_amt1                      IN     NUMBER,
    x_applied_amt2                      IN     NUMBER,
    x_applied_amt3                      IN     NUMBER,
    x_applied_amt4                      IN     NUMBER,
    x_applied_amt5                      IN     NUMBER,
    x_applied_amt6                      IN     NUMBER,
    x_applied_amt7                      IN     NUMBER,
    x_applied_amt8                      IN     NUMBER,
    x_adm_application_id                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_mode                              IN     VARCHAR2
  ) AS
  /*
  ||  Created By : [email protected]
  ||  Created On : 05-JUN-2003
  ||  Purpose : Handles the UPDATE DML logic for the table.
  ||  Known limitations, enhancements or remarks :
  ||  Change History :
  ||  Who             When            What
  ||  (reverse chronological order - newest change first)
  */
    x_last_update_date           DATE ;
Line: 964

    x_last_updated_by            NUMBER;
Line: 965

    x_last_update_login          NUMBER;
Line: 969

    x_program_update_date        DATE;
Line: 973

    x_last_update_date := SYSDATE;
Line: 975

      x_last_updated_by := 1;
Line: 976

      x_last_update_login := 0;
Line: 978

      x_last_updated_by := fnd_global.user_id;
Line: 979

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

      x_last_update_login := fnd_global.login_id;
Line: 983

      IF (x_last_update_login IS NULL) THEN
        x_last_update_login := -1;
Line: 988

      fnd_message.set_token ('ROUTINE', 'IGS_FI_LB_RECT_ERRS_PKG.UPDATE_ROW');
Line: 994

      p_action                            => 'UPDATE',
      x_rowid                             => x_rowid,
      x_lockbox_receipt_error_id          => x_lockbox_receipt_error_id,
      x_lockbox_interface_id              => x_lockbox_interface_id,
      x_item_number                       => x_item_number,
      x_lockbox_name                      => x_lockbox_name,
      x_receipt_amt                       => x_receipt_amt,
      x_batch_name                        => x_batch_name,
      x_party_number                      => x_party_number,
      x_payer_name                        => x_payer_name,
      x_check_cd                          => x_check_cd,
      x_deposit_date                      => x_deposit_date,
      x_credit_type_cd                    => x_credit_type_cd,
      x_fee_cal_instance_cd               => x_fee_cal_instance_cd,
      x_charge_cd1                        => x_charge_cd1,
      x_charge_cd2                        => x_charge_cd2,
      x_charge_cd3                        => x_charge_cd3,
      x_charge_cd4                        => x_charge_cd4,
      x_charge_cd5                        => x_charge_cd5,
      x_charge_cd6                        => x_charge_cd6,
      x_charge_cd7                        => x_charge_cd7,
      x_charge_cd8                        => x_charge_cd8,
      x_applied_amt1                      => x_applied_amt1,
      x_applied_amt2                      => x_applied_amt2,
      x_applied_amt3                      => x_applied_amt3,
      x_applied_amt4                      => x_applied_amt4,
      x_applied_amt5                      => x_applied_amt5,
      x_applied_amt6                      => x_applied_amt6,
      x_applied_amt7                      => x_applied_amt7,
      x_applied_amt8                      => x_applied_amt8,
      x_adm_application_id                => x_adm_application_id,
      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_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
    );
Line: 1061

        x_program_update_date := old_references.program_update_date;
Line: 1063

        x_program_update_date := SYSDATE;
Line: 1067

    UPDATE igs_fi_lb_rect_errs
      SET
        lockbox_interface_id              = new_references.lockbox_interface_id,
        item_number                       = new_references.item_number,
        lockbox_name                      = new_references.lockbox_name,
        receipt_amt                       = new_references.receipt_amt,
        batch_name                        = new_references.batch_name,
        party_number                      = new_references.party_number,
        payer_name                        = new_references.payer_name,
        check_cd                          = new_references.check_cd,
        deposit_date                      = new_references.deposit_date,
        credit_type_cd                    = new_references.credit_type_cd,
        fee_cal_instance_cd               = new_references.fee_cal_instance_cd,
        charge_cd1                        = new_references.charge_cd1,
        charge_cd2                        = new_references.charge_cd2,
        charge_cd3                        = new_references.charge_cd3,
        charge_cd4                        = new_references.charge_cd4,
        charge_cd5                        = new_references.charge_cd5,
        charge_cd6                        = new_references.charge_cd6,
        charge_cd7                        = new_references.charge_cd7,
        charge_cd8                        = new_references.charge_cd8,
        applied_amt1                      = new_references.applied_amt1,
        applied_amt2                      = new_references.applied_amt2,
        applied_amt3                      = new_references.applied_amt3,
        applied_amt4                      = new_references.applied_amt4,
        applied_amt5                      = new_references.applied_amt5,
        applied_amt6                      = new_references.applied_amt6,
        applied_amt7                      = new_references.applied_amt7,
        applied_amt8                      = new_references.applied_amt8,
        adm_application_id                = new_references.adm_application_id,
        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,
        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
      WHERE rowid = x_rowid;
Line: 1131

  END update_row;
Line: 1133

  PROCEDURE delete_row (
    x_rowid IN VARCHAR2
  ) AS
  /*
  ||  Created By : [email protected]
  ||  Created On : 05-JUN-2003
  ||  Purpose : Handles the DELETE DML logic for the table.
  ||  Known limitations, enhancements or remarks :
  ||  Change History :
  ||  Who             When            What
  ||  (reverse chronological order - newest change first)
  */
  BEGIN

    before_dml (
      p_action => 'DELETE',
      x_rowid => x_rowid
    );
Line: 1152

    DELETE FROM igs_fi_lb_rect_errs
    WHERE rowid = x_rowid;
Line: 1159

  END delete_row;