DBA Data[Home] [Help]

APPS.IGF_DB_YTD_SMR_PKG SQL Statements

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

Line: 32

    x_last_update_date                  IN     DATE    ,
    x_last_updated_by                   IN     NUMBER  ,
    x_last_update_login                 IN     NUMBER
  ) AS
  /*
  ||  Created By : rasingh
  ||  Created On : 23-JAN-2002
  ||  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     igf_db_ytd_smr_all
      WHERE    rowid = x_rowid;
Line: 59

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

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

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

    new_references.last_update_date                  := x_last_update_date;
Line: 98

    new_references.last_updated_by                   := x_last_updated_by;
Line: 99

    new_references.last_update_login                 := x_last_update_login;
Line: 117

      SELECT   rowid
      FROM     igf_db_ytd_smr_all
      WHERE    ytds_id = x_ytds_id
      FOR UPDATE NOWAIT;
Line: 163

    x_last_update_date                  IN     DATE    ,
    x_last_updated_by                   IN     NUMBER  ,
    x_last_update_login                 IN     NUMBER
  ) AS
  /*
  ||  Created By : rasingh
  ||  Created On : 23-JAN-2002
  ||  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_ytds_id,
      x_dl_version,
      x_record_type,
      x_batch_id,
      x_school_code,
      x_stat_end_dt,
      x_process_dt,
      x_disb_smr_type,
      x_bkd_gross,
      x_bkd_fee,
      x_bkd_int_rebate,
      x_bkd_net,
      x_unbkd_gross,
      x_unbkd_fee,
      x_unbkd_int_rebate,
      x_unbkd_net,
      x_region_code,
      x_state_code,
      x_rec_count,
      x_creation_date,
      x_created_by,
      x_last_update_date,
      x_last_updated_by,
      x_last_update_login
    );
Line: 208

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

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

  PROCEDURE insert_row (
    x_rowid                             IN OUT NOCOPY VARCHAR2,
    x_ytds_id                           IN OUT NOCOPY NUMBER,
    x_dl_version                        IN     VARCHAR2,
    x_record_type                       IN     VARCHAR2,
    x_batch_id                          IN     VARCHAR2,
    x_school_code                       IN     VARCHAR2,
    x_stat_end_dt                       IN     DATE,
    x_process_dt                        IN     DATE,
    x_disb_smr_type                     IN     VARCHAR2,
    x_bkd_gross                         IN     NUMBER,
    x_bkd_fee                           IN     NUMBER,
    x_bkd_int_rebate                    IN     NUMBER,
    x_bkd_net                           IN     NUMBER,
    x_unbkd_gross                       IN     NUMBER,
    x_unbkd_fee                         IN     NUMBER,
    x_unbkd_int_rebate                  IN     NUMBER,
    x_unbkd_net                         IN     NUMBER,
    x_region_code                       IN     VARCHAR2,
    x_state_code                        IN     VARCHAR2,
    x_rec_count                         IN     NUMBER  ,
    x_mode                              IN     VARCHAR2
  ) AS
  /*
  ||  Created By : rasingh
  ||  Created On : 23-JAN-2002
  ||  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)
  */
    CURSOR c IS
      SELECT   rowid
      FROM     igf_db_ytd_smr_all
      WHERE    ytds_id                           = x_ytds_id;
Line: 270

    x_last_update_date           DATE;
Line: 271

    x_last_updated_by            NUMBER;
Line: 272

    x_last_update_login          NUMBER;
Line: 276

    x_program_update_date        DATE;
Line: 280

    x_last_update_date := SYSDATE;
Line: 282

      x_last_updated_by := 1;
Line: 283

      x_last_update_login := 0;
Line: 285

      x_last_updated_by := fnd_global.user_id;
Line: 286

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

      x_last_update_login := fnd_global.login_id;
Line: 290

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

        x_program_update_date    := NULL;
Line: 303

        x_program_update_date    := SYSDATE;
Line: 311

    SELECT    igf_db_ytd_smr_s.NEXTVAL
    INTO      x_ytds_id
    FROM      dual;
Line: 318

      p_action                            => 'INSERT',
      x_rowid                             => x_rowid,
      x_ytds_id                           => x_ytds_id,
      x_dl_version                        => x_dl_version,
      x_record_type                       => x_record_type,
      x_batch_id                          => x_batch_id,
      x_school_code                       => x_school_code,
      x_stat_end_dt                       => x_stat_end_dt,
      x_process_dt                        => x_process_dt,
      x_disb_smr_type                     => x_disb_smr_type,
      x_bkd_gross                         => x_bkd_gross,
      x_bkd_fee                           => x_bkd_fee,
      x_bkd_int_rebate                    => x_bkd_int_rebate,
      x_bkd_net                           => x_bkd_net,
      x_unbkd_gross                       => x_unbkd_gross,
      x_unbkd_fee                         => x_unbkd_fee,
      x_unbkd_int_rebate                  => x_unbkd_int_rebate,
      x_unbkd_net                         => x_unbkd_net,
      x_region_code                       => x_region_code,
      x_state_code                        => x_state_code,
      x_rec_count                         => x_rec_count,
      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: 347

    INSERT INTO igf_db_ytd_smr_all (
      ytds_id,
      dl_version,
      record_type,
      batch_id,
      school_code,
      stat_end_dt,
      process_dt,
      disb_smr_type,
      bkd_gross,
      bkd_fee,
      bkd_int_rebate,
      bkd_net,
      unbkd_gross,
      unbkd_fee,
      unbkd_int_rebate,
      unbkd_net,
      region_code,
      state_code ,
      rec_count  ,
      org_id,
      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.ytds_id,
      new_references.dl_version,
      new_references.record_type,
      new_references.batch_id,
      new_references.school_code,
      new_references.stat_end_dt,
      new_references.process_dt,
      new_references.disb_smr_type,
      new_references.bkd_gross,
      new_references.bkd_fee,
      new_references.bkd_int_rebate,
      new_references.bkd_net,
      new_references.unbkd_gross,
      new_references.unbkd_fee,
      new_references.unbkd_int_rebate,
      new_references.unbkd_net,
      new_references.region_code,
      new_references.state_code ,
      new_references.rec_count  ,
      new_references.org_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
    );
Line: 417

  END insert_row;
Line: 452

      SELECT
        dl_version,
        record_type,
        batch_id,
        school_code,
        stat_end_dt,
        process_dt,
        disb_smr_type,
        bkd_gross,
        bkd_fee,
        bkd_int_rebate,
        bkd_net,
        unbkd_gross,
        unbkd_fee,
        unbkd_int_rebate,
        unbkd_net,
        region_code,
        state_code ,
        rec_count
      FROM  igf_db_ytd_smr_all
      WHERE rowid = x_rowid
      FOR UPDATE NOWAIT;
Line: 482

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

  PROCEDURE update_row (
    x_rowid                             IN     VARCHAR2,
    x_ytds_id                           IN     NUMBER,
    x_dl_version                        IN     VARCHAR2,
    x_record_type                       IN     VARCHAR2,
    x_batch_id                          IN     VARCHAR2,
    x_school_code                       IN     VARCHAR2,
    x_stat_end_dt                       IN     DATE,
    x_process_dt                        IN     DATE,
    x_disb_smr_type                     IN     VARCHAR2,
    x_bkd_gross                         IN     NUMBER,
    x_bkd_fee                           IN     NUMBER,
    x_bkd_int_rebate                    IN     NUMBER,
    x_bkd_net                           IN     NUMBER,
    x_unbkd_gross                       IN     NUMBER,
    x_unbkd_fee                         IN     NUMBER,
    x_unbkd_int_rebate                  IN     NUMBER,
    x_unbkd_net                         IN     NUMBER,
    x_region_code                       IN     VARCHAR2,
    x_state_code                        IN     VARCHAR2,
    x_rec_count                         IN     NUMBER  ,
    x_mode                              IN     VARCHAR2
  ) AS
  /*
  ||  Created By : rasingh
  ||  Created On : 23-JAN-2002
  ||  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: 555

    x_last_updated_by            NUMBER;
Line: 556

    x_last_update_login          NUMBER;
Line: 560

    x_program_update_date        DATE;
Line: 564

    x_last_update_date := SYSDATE;
Line: 566

      x_last_updated_by := 1;
Line: 567

      x_last_update_login := 0;
Line: 569

      x_last_updated_by := fnd_global.user_id;
Line: 570

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

      x_last_update_login := fnd_global.login_id;
Line: 574

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

      p_action                            => 'UPDATE',
      x_rowid                             => x_rowid,
      x_ytds_id                           => x_ytds_id,
      x_dl_version                        => x_dl_version,
      x_record_type                       => x_record_type,
      x_batch_id                          => x_batch_id,
      x_school_code                       => x_school_code,
      x_stat_end_dt                       => x_stat_end_dt,
      x_process_dt                        => x_process_dt,
      x_disb_smr_type                     => x_disb_smr_type,
      x_bkd_gross                         => x_bkd_gross,
      x_bkd_fee                           => x_bkd_fee,
      x_bkd_int_rebate                    => x_bkd_int_rebate,
      x_bkd_net                           => x_bkd_net,
      x_unbkd_gross                       => x_unbkd_gross,
      x_unbkd_fee                         => x_unbkd_fee,
      x_unbkd_int_rebate                  => x_unbkd_int_rebate,
      x_unbkd_net                         => x_unbkd_net,
      x_region_code                       => x_region_code,
      x_state_code                        => x_state_code,
      x_rec_count                         => x_rec_count,
      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: 620

        x_program_update_date := old_references.program_update_date;
Line: 622

        x_program_update_date := SYSDATE;
Line: 626

    UPDATE igf_db_ytd_smr_all
      SET
        dl_version                        = new_references.dl_version,
        record_type                       = new_references.record_type,
        batch_id                          = new_references.batch_id,
        school_code                       = new_references.school_code,
        stat_end_dt                       = new_references.stat_end_dt,
        process_dt                        = new_references.process_dt,
        disb_smr_type                     = new_references.disb_smr_type,
        bkd_gross                         = new_references.bkd_gross,
        bkd_fee                           = new_references.bkd_fee,
        bkd_int_rebate                    = new_references.bkd_int_rebate,
        bkd_net                           = new_references.bkd_net,
        unbkd_gross                       = new_references.unbkd_gross,
        unbkd_fee                         = new_references.unbkd_fee,
        unbkd_int_rebate                  = new_references.unbkd_int_rebate,
        unbkd_net                         = new_references.unbkd_net,
        region_code                       = new_references.region_code,
        state_code                        = new_references.state_code,
        rec_count                         = new_references.rec_count,
        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: 659

  END update_row;
Line: 688

  ||  Purpose : Adds a row if there is no existing row, otherwise updates existing row in the table.
  ||  Known limitations, enhancements or remarks :
  ||  Change History :
  ||  Who             When            What
  ||  (reverse chronological order - newest change first)
  */
    CURSOR c1 IS
      SELECT   rowid
      FROM     igf_db_ytd_smr_all
      WHERE    ytds_id                           = x_ytds_id;
Line: 706

      insert_row (
        x_rowid,
        x_ytds_id,
        x_dl_version,
        x_record_type,
        x_batch_id,
        x_school_code,
        x_stat_end_dt,
        x_process_dt,
        x_disb_smr_type,
        x_bkd_gross,
        x_bkd_fee,
        x_bkd_int_rebate,
        x_bkd_net,
        x_unbkd_gross,
        x_unbkd_fee,
        x_unbkd_int_rebate,
        x_unbkd_net,
        x_region_code,
        x_state_code,
        x_rec_count,
        x_mode
      );
Line: 733

    update_row (
      x_rowid,
      x_ytds_id,
      x_dl_version,
      x_record_type,
      x_batch_id,
      x_school_code,
      x_stat_end_dt,
      x_process_dt,
      x_disb_smr_type,
      x_bkd_gross,
      x_bkd_fee,
      x_bkd_int_rebate,
      x_bkd_net,
      x_unbkd_gross,
      x_unbkd_fee,
      x_unbkd_int_rebate,
      x_unbkd_net,
      x_region_code,
      x_state_code,
      x_rec_count,
      x_mode
    );
Line: 760

  PROCEDURE delete_row (
    x_rowid IN VARCHAR2
  ) AS
  /*
  ||  Created By : rasingh
  ||  Created On : 23-JAN-2002
  ||  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: 779

    DELETE FROM igf_db_ytd_smr_all
    WHERE rowid = x_rowid;
Line: 786

  END delete_row;