APPS.JTF_PREFAB_LOAD_DIST_PUB SQL Statements

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

Line: 11

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

  p_policy_id           IN      jtf_prefab_prbs.policy_id%TYPE,
  p_uri                 IN      jtf_prefab_prbs.uri%TYPE,
  p_user_id             IN      jtf_prefab_prbs.user_id%TYPE,
  p_responsibility_id   IN      jtf_prefab_prbs.responsibility_id%TYPE,
  p_application_id      IN      jtf_prefab_prbs.application_id%TYPE,
  p_prefab_hostname     IN      jtf_prefab_prbs.prefab_hostname%TYPE,

  p_object_version_number OUT NOCOPY   jtf_prefab_prbs.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_PRB';

Line: 35

        SAVEPOINT INSERT_PRB;

Line: 60

        INSERT INTO jtf_prefab_prbs(prb_id,
                                    object_version_number,
                                    created_by,
                                    creation_date,
                                    last_updated_by,
                                    last_update_date,
                                    last_update_login,
                                    -- security_group_id,
                                    policy_id,
                                    uri,
                                    user_id,
                                    responsibility_id,
                                    application_id,
                                    prefab_hostname)
        VALUES (jtf_prefab_prbs_s.NEXTVAL,
                p_object_version_number,
                G_USER_ID,
                SYSDATE,
                G_USER_ID,
                SYSDATE,
                G_LOGIN_ID,
                -- NULL,
                p_policy_id,
                p_uri,
                p_user_id,
                p_responsibility_id,
                p_application_id,
                p_prefab_hostname);

Line: 104

                ROLLBACK TO INSERT_PRB;

Line: 112

                ROLLBACK TO INSERT_PRB;

Line: 120

                ROLLBACK TO INSERT_PRB;

Line: 131

END INSERT_PRB;