APPS.IGI_IAC_REVAL_ASSET_RULES_PKG SQL Statements

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

Line: 16

  PROCEDURE insert_row (
        X_rowid                         IN OUT NOCOPY  VARCHAR2,
        X_revaluation_id                IN      NUMBER,
        X_book_type_code                IN      VARCHAR2,
        X_category_id                   IN      NUMBER,
        X_asset_id                      IN      NUMBER,
        X_revaluation_factor            IN      NUMBER,
        X_revaluation_type              IN      VARCHAR2,
        X_new_cost                      IN      NUMBER,
        X_current_cost                  IN      NUMBER,
        X_selected_for_reval_flag       IN      VARCHAR2,
        X_selected_for_calc_flag        IN      VARCHAR2,
        X_allow_prof_update             IN      VARCHAR2,
        X_mode                          IN      VARCHAR2
  ) AS

    CURSOR c IS
        SELECT   rowid
        FROM     igi_iac_reval_asset_rules
        WHERE    revaluation_id = X_revaluation_id
        AND      asset_id = X_asset_id
        AND      book_type_code = X_book_type_code
        AND      category_id = X_category_id;

Line: 40

    X_last_update_date           DATE;

Line: 41

    X_last_updated_by            NUMBER;

Line: 42

    X_last_update_login          NUMBER;

Line: 45

    l_path 			 VARCHAR2(150) := g_path||'insert_row';

Line: 49

        x_last_update_date := SYSDATE;

Line: 57

        x_last_updated_by := fnd_global.user_id;

Line: 58

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

Line: 62

        x_last_update_login := fnd_global.login_id;

Line: 63

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

Line: 72

    INSERT INTO igi_iac_reval_asset_rules
        (revaluation_id,
        book_type_code,
        category_id,
        asset_id,
        revaluation_factor,
        revaluation_type,
        new_cost,
        current_cost,
        selected_for_reval_flag,
        selected_for_calc_flag,
        created_by,
        creation_date,
        last_update_login,
        last_update_date,
        last_updated_by,
        allow_prof_update)
    VALUES
        (X_revaluation_id,
        X_book_type_code,
        X_category_id,
        X_asset_id,
        X_revaluation_factor,
        X_revaluation_type,
        X_new_cost,
        X_current_cost,
        X_selected_for_reval_flag,
        X_selected_for_calc_flag,
        X_created_by,
        X_creation_date,
        X_last_update_login,
        X_last_update_date,
        X_last_updated_by,
        X_allow_prof_update);

Line: 115

  END insert_row;

Line: 117

  PROCEDURE delete_row (
    x_asset_id          IN      NUMBER,
    x_book_type_code    IN      VARCHAR2,
    x_revaluation_id     IN      NUMBER
  ) AS
  BEGIN

    DELETE FROM igi_iac_reval_asset_rules
    WHERE asset_id = x_asset_id
    AND book_type_code = x_book_type_code
    AND revaluation_id = x_revaluation_id;

Line: 133

  END delete_row;