APPS.IGI_IAC_REVALUATIONS_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 OUT NOCOPY  NUMBER,
    X_book_type_code                    IN      VARCHAR2,
    X_revaluation_date                  IN      DATE,
    X_revaluation_period                IN      VARCHAR2,
    X_status                            IN      VARCHAR2,
    X_reval_request_id                  IN      NUMBER,
    X_create_request_id                 IN      NUMBER,
    X_calling_program                   IN      VARCHAR2,
    X_mode                              IN      VARCHAR2,
    X_event_id                          IN      NUMBER            -- for R12 SLA upgrade

  ) AS

    CURSOR c IS
        SELECT   rowid
        FROM     igi_iac_revaluations
        WHERE    revaluation_id = X_revaluation_id;

Line: 37

        SELECT    igi_iac_revaluations_s.NEXTVAL
        FROM      sys.dual;

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_name VARCHAR2(150) := g_path||'insert_row';

Line: 50

        x_last_update_date := SYSDATE;

Line: 58

        x_last_updated_by := fnd_global.user_id;

Line: 59

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

Line: 63

        x_last_update_login := fnd_global.login_id;

Line: 64

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

Line: 81

    INSERT INTO igi_iac_revaluations
        (revaluation_id,
        book_type_code,
        revaluation_date,
        revaluation_period,
        status,
        reval_request_id,
        create_request_id,
        calling_program,
        last_update_date,
        created_by,
        last_update_login,
        last_updated_by,
        creation_date,
	event_id)                               -- for R12 SLA upgrade
    VALUES
        (X_revaluation_id,
        X_book_type_code,
        X_revaluation_date,
        X_revaluation_period,
        X_status,
        X_reval_request_id,
        X_create_request_id,
        X_calling_program,
        X_last_update_date,
        X_created_by,
        X_last_update_login,
        X_last_updated_by,
        X_creation_date,
	X_event_id);                            -- for R12 SLA upgrade

Line: 120

  END insert_row;

Line: 122

  PROCEDURE delete_row (
    x_revaluation_id     IN      NUMBER
  ) AS
  BEGIN

    DELETE FROM igi_iac_revaluations
    WHERE revaluation_id = x_revaluation_id;

Line: 134

  END delete_row;