APPS.IGI_IAC_BOOK_CONTROLS_PKG SQL Statements

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

Line: 18

  PROCEDURE insert_row (

    x_rowid                             IN OUT NOCOPY VARCHAR2,

    x_book_type_code                    IN     VARCHAR2,

    x_gl_je_source                      IN     VARCHAR2,

    x_je_iac_deprn_category             IN     VARCHAR2,

    x_je_iac_reval_category             IN     VARCHAR2,

    x_je_iac_txn_category               IN     VARCHAR2,

    x_period_num_for_catchup            IN     NUMBER,

    x_mode                              IN     VARCHAR2

  ) AS

  /*

  ||  Created By :

  ||  Created On : 29-APR-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     igi_iac_book_controls

      WHERE    book_type_code = x_book_type_code;

Line: 66

    x_last_update_date           DATE;

Line: 68

    x_last_updated_by            NUMBER;

Line: 70

    x_last_update_login          NUMBER;

Line: 78

    x_last_update_date := SYSDATE;

Line: 82

      x_last_updated_by := 1;

Line: 84

      x_last_update_login := 0;

Line: 88

      x_last_updated_by := fnd_global.user_id;

Line: 90

      IF (x_last_updated_by IS NULL) THEN

        x_last_updated_by := -1;

Line: 96

      x_last_update_login := fnd_global.login_id;

Line: 98

      IF (x_last_update_login IS NULL) THEN

        x_last_update_login := -1;

Line: 107

      igi_iac_debug_pkg.debug_other_msg(g_error_level,g_path||'insert_row',FALSE);

Line: 112

    INSERT INTO igi_iac_book_controls (

      book_type_code,

      gl_je_source,

      je_iac_deprn_category,

      je_iac_reval_category,

      je_iac_txn_category,

      period_num_for_catchup,

      org_id,

      creation_date,

      created_by,

      last_update_date,

      last_updated_by,

      last_update_login

    ) VALUES (

      x_book_type_code,

      x_gl_je_source,

      x_je_iac_deprn_category,

      x_je_iac_reval_category,

      x_je_iac_txn_category,

      x_period_num_for_catchup,

      x_org_id,

      x_last_update_date,

      x_last_updated_by,

      x_last_update_date,

      x_last_updated_by,

      x_last_update_login

    );

Line: 184

  END insert_row;

Line: 228

      SELECT

        book_type_code,

        gl_je_source,

        je_iac_deprn_category,

        je_iac_reval_category,

        je_iac_txn_category,

        period_num_for_catchup

      FROM  igi_iac_book_controls

      WHERE rowid = x_rowid

      FOR UPDATE NOWAIT;

Line: 264

      fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

Line: 316

  PROCEDURE update_row (

    x_rowid                             IN     VARCHAR2,

    x_book_type_code                    IN     VARCHAR2,

    x_gl_je_source                      IN     VARCHAR2,

    x_je_iac_deprn_category             IN     VARCHAR2,

    x_je_iac_reval_category             IN     VARCHAR2,

    x_je_iac_txn_category               IN     VARCHAR2,

    x_period_num_for_catchup            IN     NUMBER,

    x_mode                              IN     VARCHAR2

  ) AS

  /*

  ||  Created By :

  ||  Created On : 29-APR-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: 356

    x_last_updated_by            NUMBER;

Line: 358

    x_last_update_login          NUMBER;

Line: 366

    x_last_update_date := SYSDATE;

Line: 370

      x_last_updated_by := 1;

Line: 372

      x_last_update_login := 0;

Line: 376

      x_last_updated_by := fnd_global.user_id;

Line: 378

      IF x_last_updated_by IS NULL THEN

        x_last_updated_by := -1;

Line: 384

      x_last_update_login := fnd_global.login_id;

Line: 386

      IF (x_last_update_login IS NULL) THEN

        x_last_update_login := -1;

Line: 395

      igi_iac_debug_pkg.debug_other_msg(g_error_level,g_path||'update_row',FALSE);

Line: 404

    UPDATE igi_iac_book_controls

      SET

        book_type_code                    = x_book_type_code,

        gl_je_source                      = x_gl_je_source,

        je_iac_deprn_category             = x_je_iac_deprn_category,

        je_iac_reval_category             = x_je_iac_reval_category,

        je_iac_txn_category               = x_je_iac_txn_category,

        period_num_for_catchup            = x_period_num_for_catchup,

        last_update_date                  = x_last_update_date,

        last_updated_by                   = x_last_updated_by,

        last_update_login                 = x_last_update_login

      WHERE rowid = x_rowid;

Line: 438

  END update_row;

Line: 446

  PROCEDURE delete_row (

    x_rowid IN VARCHAR2

  ) AS

  /*

  ||  Created By :

  ||  Created On : 29-APR-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





    DELETE FROM igi_iac_book_controls

    WHERE rowid = x_rowid;

Line: 490

  END delete_row;

Line: 500

    SELECT

 NVL ( TO_NUMBER ( DECODE ( SUBSTRB ( USERENV ('CLIENT_INFO' ), 1, 1  ), ' ', NULL,  SUBSTRB (USERENV ('CLIENT_INFO'),1,10)  )   ), NULL  ) org_id FROM dual;