eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_PREFAB_UD_KEY_PUB SQL Statements

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

Line: 11


PROCEDURE INSERT_UD_KEY(
  p_api_version         IN      NUMBER,
  p_init_msg_list       IN      VARCHAR2        := FND_API.G_FALSE,
  p_commit              IN      VARCHAR2        := FND_API.G_FALSE,

  p_ud_key_id           OUT  NOCOPY     jtf_prefab_ud_keys_b.ud_key_id%TYPE,
  p_application_id      IN      jtf_prefab_ud_keys_b.application_id%TYPE,
  p_ud_key_name         IN      jtf_prefab_ud_keys_b.ud_key_name%TYPE,
  p_description         IN      jtf_prefab_ud_keys_tl.description%TYPE,
  p_filename            IN      jtf_prefab_ud_keys_b.filename%TYPE,
  p_user_defined_keys   IN      jtf_prefab_ud_keys_b.user_defined_keys%TYPE,
  p_enabled_flag        IN      jtf_prefab_ud_keys_b.enabled_flag%TYPE,

  p_object_version_number OUT  NOCOPY   jtf_prefab_ud_keys_b.object_version_number%TYPE,

  x_return_status       OUT  NOCOPY     VARCHAR2,
  x_msg_count           OUT  NOCOPY     NUMBER,
  x_msg_data            OUT  NOCOPY     VARCHAR2
) AS
        -- local variables --
        l_api_name              CONSTANT VARCHAR2(30)   := 'INSERT_UD_KEY';

Line: 36


          SELECT jtf_prefab_ud_keys_b_s.NEXTVAL from dual;

Line: 39


        SAVEPOINT INSERT_UD_KEY;

Line: 67


        JTF_PREFAB_UD_KEYS_PKG.INSERT_ROW(l_row_id,
                                          p_ud_key_id,
                                          p_object_version_number,
                                          NULL,
                                          p_application_id,
                                          p_ud_key_name,
                                          p_filename,
                                          p_user_defined_keys,
                                          p_enabled_flag,
                                          p_description,
                                          SYSDATE,
                                          G_USER_ID,
                                          SYSDATE,
                                          G_USER_ID,
                                          G_LOGIN_ID);

Line: 83


        INSERT INTO jtf_prefab_ud_keys (ud_key_id,
                                        object_version_number,
                                        created_by,
                                        creation_date,
                                        last_updated_by,
                                        last_update_date,
                                        last_update_login,
                                        security_group_id,
                                        application_id,
                                        ud_key_name,
                                        description,
                                        filename,
                                        user_defined_keys,
                                        enabled_flag)
        VALUES (p_ud_key_id,
                p_object_version_number,
                G_USER_ID,
                SYSDATE,
                G_USER_ID,
                SYSDATE,
                G_LOGIN_ID,
                NULL,
                p_application_id,
                p_ud_key_name,
                p_description,
                p_filename,
                p_user_defined_keys,
                p_enabled_flag);

Line: 128


                ROLLBACK TO INSERT_UD_KEY;

Line: 136


                ROLLBACK TO INSERT_UD_KEY;

Line: 144


                ROLLBACK TO INSERT_UD_KEY;

Line: 155


END INSERT_UD_KEY;

Line: 157


PROCEDURE UPDATE_UD_KEY(
  p_api_version         IN      NUMBER,
  p_init_msg_list       IN      VARCHAR2        := FND_API.G_FALSE,
  p_commit              IN      VARCHAR2        := FND_API.G_FALSE,

  p_ud_key_id           IN      jtf_prefab_ud_keys_b.ud_key_id%TYPE,
  p_application_id      IN      jtf_prefab_ud_keys_b.application_id%TYPE,
  p_ud_key_name         IN      jtf_prefab_ud_keys_b.ud_key_name%TYPE,
  p_description         IN      jtf_prefab_ud_keys_tl.description%TYPE,
  p_filename            IN      jtf_prefab_ud_keys_b.filename%TYPE,
  p_user_defined_keys   IN      jtf_prefab_ud_keys_b.user_defined_keys%TYPE,
  p_enabled_flag        IN      jtf_prefab_ud_keys_b.enabled_flag%TYPE,

  p_object_version_number IN OUT  NOCOPY jtf_prefab_ud_keys_b.object_version_number%TYPE,

  x_return_status       OUT  NOCOPY     VARCHAR2,
  x_msg_count           OUT  NOCOPY     NUMBER,
  x_msg_data            OUT  NOCOPY     VARCHAR2
) AS
        -- local variables --
        l_api_name              CONSTANT VARCHAR2(30)   := 'UPDATE_UD_KEY';

Line: 182


        SAVEPOINT UPDATE_UD_KEY;

Line: 205


        JTF_PREFAB_UD_KEYS_PKG.UPDATE_ROW(p_ud_key_id,
                                          p_object_version_number,
                                          NULL,
                                          p_application_id,
                                          p_ud_key_name,
                                          p_filename,
                                          p_user_defined_keys,
                                          p_enabled_flag,
                                          p_description,
                                          SYSDATE,
                                          G_USER_ID,
                                          G_LOGIN_ID);

Line: 219


        UPDATE jtf_prefab_ud_keys
        SET object_version_number = p_object_version_number,
            last_updated_by = G_USER_ID,
            last_update_date = SYSDATE,
            last_update_login = G_LOGIN_ID,
            description = p_description,
            filename = p_filename,
            user_defined_keys = p_user_defined_keys,
            enabled_flag = p_enabled_flag
        WHERE ud_key_id = p_ud_key_id;

Line: 246


                ROLLBACK TO UPDATE_UD_KEY;

Line: 254


                ROLLBACK TO UPDATE_UD_KEY;

Line: 262


                ROLLBACK TO UPDATE_UD_KEY;

Line: 273


END UPDATE_UD_KEY;

Line: 275


procedure DELETE_UD_KEY(
  p_api_version         IN      NUMBER,
  p_init_msg_list       IN      VARCHAR2        := FND_API.G_FALSE,
  p_commit              IN      VARCHAR2        := FND_API.G_FALSE,

  p_ud_key_id           IN      jtf_prefab_ud_keys_b.ud_key_id%TYPE,

  p_object_version_number IN    jtf_prefab_ud_keys_b.object_version_number%TYPE,

  x_return_status       OUT  NOCOPY     VARCHAR2,
  x_msg_count           OUT  NOCOPY     NUMBER,
  x_msg_data            OUT  NOCOPY     VARCHAR2
) AS
        l_api_name              CONSTANT VARCHAR2(30) := 'DELETE_UD_KEY';

Line: 293


        SAVEPOINT DELETE_UD_KEY;

Line: 316


        JTF_PREFAB_UD_KEYS_PKG.DELETE_ROW(p_ud_key_id);

Line: 319


        DELETE FROM jtf_prefab_ud_keys
        WHERE ud_key_id = p_ud_key_id;

Line: 338


                ROLLBACK TO DELETE_UD_KEY;

Line: 346


                ROLLBACK TO DELETE_UD_KEY;

Line: 354


                ROLLBACK TO DELETE_UD_KEY;

Line: 365


END DELETE_UD_KEY;