APPS.JTF_MSITE_PRTY_ACCSS_PKG SQL Statements

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

Line: 7

PROCEDURE insert_row
  (
   p_msite_prty_accss_id                IN NUMBER,
   p_object_version_number              IN NUMBER,
   p_msite_id                           IN NUMBER,
   p_party_id                           IN NUMBER,
   p_start_date_active                  IN DATE,
   p_end_date_active                    IN DATE,
   p_security_group_id                  IN NUMBER,
   p_creation_date                      IN DATE,
   p_created_by                         IN NUMBER,
   p_last_update_date                   IN DATE,
   p_last_updated_by                    IN NUMBER,
   p_last_update_login                  IN NUMBER,
   x_rowid                              OUT VARCHAR2,
   x_msite_prty_accss_id                OUT NUMBER
  )
IS
  CURSOR c IS SELECT rowid FROM jtf_msite_prty_accss
    WHERE msite_prty_accss_id = x_msite_prty_accss_id;

Line: 27

  CURSOR c2 IS SELECT jtf_msite_prty_accss_s1.nextval FROM dual;

Line: 42

  INSERT INTO jtf_msite_prty_accss
    (
    msite_prty_accss_id,
    object_version_number,
    msite_id,
    party_id,
    start_date_active,
    end_date_active,
    security_group_id,
    creation_date,
    created_by,
    last_update_date,
    last_updated_by,
    last_update_login
    )
    VALUES
    (
    x_msite_prty_accss_id,
    p_object_version_number,
    p_msite_id,
    p_party_id,
    p_start_date_active,
    decode(p_end_date_active, FND_API.G_MISS_DATE, NULL, p_end_date_active),
    decode(p_security_group_id, FND_API.G_MISS_NUM, NULL, p_security_group_id),
    decode(p_creation_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
           p_creation_date),
    decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
           NULL, FND_GLOBAL.user_id, p_created_by),
    decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
           p_last_update_date),
    decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
           NULL, FND_GLOBAL.user_id, p_last_updated_by),
    decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
           NULL, FND_GLOBAL.login_id, p_last_update_login)
    );

Line: 87

END insert_row;

Line: 89

PROCEDURE update_row
  (
   p_msite_prty_accss_id                IN NUMBER,
   p_object_version_number              IN NUMBER   := FND_API.G_MISS_NUM,
   p_start_date_active                  IN DATE,
   p_end_date_active                    IN DATE,
   p_security_group_id                  IN NUMBER,
   p_last_update_date                   IN DATE,
   p_last_updated_by                    IN NUMBER,
   p_last_update_login                  IN NUMBER
  )
IS
BEGIN

  -- update base
  UPDATE jtf_msite_prty_accss SET
    object_version_number = object_version_number + 1,
    start_date_active = decode(p_start_date_active, FND_API.G_MISS_DATE,
                               start_date_active, p_start_date_active),
    end_date_active = decode(p_end_date_active, FND_API.G_MISS_DATE,
                             end_date_active, p_end_date_active),
    security_group_id = decode(p_security_group_id, FND_API.G_MISS_NUM,
                               security_group_id, p_security_group_id),
    last_update_date = decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate,
                              NULL, sysdate, p_last_update_date),
    last_updated_by = decode(p_last_updated_by, FND_API.G_MISS_NUM,
                             FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
                             p_last_updated_by),
    last_update_login = decode(p_last_update_login, FND_API.G_MISS_NUM,
                             FND_GLOBAL.login_id, NULL, FND_GLOBAL.login_id,
                             p_last_update_login)
    WHERE msite_prty_accss_id = p_msite_prty_accss_id
    AND object_version_number = decode(p_object_version_number,
                                       FND_API.G_MISS_NUM,
                                       object_version_number,
                                       p_object_version_number);

Line: 129

END update_row;

Line: 134

PROCEDURE delete_row
  (
   p_msite_prty_accss_id IN NUMBER
  )
IS
BEGIN

  DELETE FROM jtf_msite_prty_accss
    WHERE msite_prty_accss_id = p_msite_prty_accss_id;

Line: 148

END delete_row;