APPS.IBE_TPLCATEGORY_GRP SQL Statements

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

Line: 11

  SELECT ibe_dsp_tpl_ctg_s1.NEXTVAL
    FROM DUAL;

Line: 78

            INSERT INTO IBE_DSP_TPL_CTG (
              TPL_CTG_ID,
              OBJECT_VERSION_NUMBER,
              LAST_UPDATE_DATE,
              LAST_UPDATED_BY,
              CREATION_DATE,
              CREATED_BY,
              LAST_UPDATE_LOGIN,
              ITEM_ID,
              CATEGORY_ID )
           VALUES (
              l_dsp_tpl_seq_id,
              1,
              SYSDATE,
              FND_GLOBAL.user_id,
              SYSDATE,
              FND_GLOBAL.user_id,
              FND_GLOBAL.user_id,
              p_template_id,
              p_category_id);

Line: 296

PROCEDURE delete_tpl_ctg_relation(
  p_api_version        IN   NUMBER,
  p_init_msg_list      IN   VARCHAR2 := FND_API.g_false,
  p_commit             IN   VARCHAR2 := FND_API.g_false,
  x_return_status      OUT NOCOPY  VARCHAR2,
  x_msg_count          OUT NOCOPY  NUMBER,
  x_msg_data           OUT NOCOPY  VARCHAR2,
  p_tpl_ctg_id_tbl     IN   tpl_ctg_id_TBL_TYPE )
IS
  l_api_name    CONSTANT VARCHAR2(30) := 'delete_tpl_ctg_relation';

Line: 312

    SELECT  category_id ,ITEM_ID
      FROM  ibe_dsp_tpl_ctg
      WHERE tpl_ctg_id = p_tpl_ctg_id;

Line: 317

  SAVEPOINT delete_tpl_ctg_relation;

Line: 337

      SAVEPOINT delete_ctg_relation;

Line: 347

        DELETE FROM IBE_DSP_TPL_CTG
          WHERE TPL_CTG_ID  = p_tpl_ctg_id_tbl(l_index);

Line: 350

        IBE_LogicalContent_grp.delete_category_dlv(
          l_category_id,
          l_deliverable_id);

Line: 356

         ROLLBACK TO delete_ctg_relation;

Line: 374

     ROLLBACK TO delete_tpl_ctg_relation;

Line: 382

     ROLLBACK TO delete_tpl_ctg_relation;

Line: 390

     ROLLBACK TO delete_tpl_ctg_relation;

Line: 402

END delete_tpl_ctg_relation;

Line: 541

PROCEDURE delete_deliverable(p_template_id IN NUMBER )
IS
BEGIN
  --------------------- initialize -----------------------+
  SAVEPOINT delete_deliverable;

Line: 548

  DELETE FROM ibe_dsp_tpl_ctg
    WHERE item_id = p_template_id;

Line: 552

     ROLLBACK TO delete_deliverable;

Line: 553

END delete_deliverable;

Line: 561

PROCEDURE delete_category(p_category_id      IN  NUMBER )
IS
BEGIN
  --------------------- initialize -----------------------+
  SAVEPOINT delete_category;

Line: 568

  DELETE FROM ibe_dsp_tpl_ctg
    WHERE category_id = p_category_id;

Line: 572

     ROLLBACK TO delete_category;

Line: 573

END delete_category;