APPS.IBE_LOGICALCONTENT_GRP SQL Statements

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

Line: 10

  SELECT ibe_dsp_obj_lgl_ctnt_s1.NEXTVAL
    FROM DUAL;

Line: 14

PROCEDURE delete_logical_content(
  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_object_type		IN  VARCHAR2,
  p_lgl_ctnt_rec	IN OBJ_LGL_CTNT_REC_TYPE )
IS
  l_api_name    CONSTANT VARCHAR2(30) := 'delete_logical_content';

Line: 32

  SAVEPOINT delete_logical_content;

Line: 60

    DELETE FROM ibe_dsp_obj_lgl_ctnt
      WHERE obj_lgl_ctnt_id       = p_lgl_ctnt_rec.obj_lgl_ctnt_id
      AND   object_version_number = p_lgl_ctnt_rec.object_version_number;

Line: 83

     ROLLBACK TO delete_logical_content;

Line: 91

     ROLLBACK TO delete_logical_content;

Line: 99

     ROLLBACK TO delete_logical_content;

Line: 109

     ROLLBACK TO delete_logical_content;

Line: 119

END delete_logical_content;

Line: 254

    DELETE FROM IBE_DSP_OBJ_LGL_ctnt
      WHERE obj_lgl_ctnt_id       = p_lgl_ctnt_rec.obj_lgl_ctnt_id
      AND   object_version_number = p_lgl_ctnt_rec.object_version_number
      AND   object_type           = l_object_type;

Line: 265

      INSERT INTO IBE_DSP_OBJ_LGL_CTNT (
        OBJ_LGL_CTNT_ID,
        OBJECT_VERSION_NUMBER,
        LAST_UPDATE_DATE,
        LAST_UPDATED_BY,
        CREATION_DATE,
        CREATED_BY,
        LAST_UPDATE_LOGIN,
        OBJECT_ID,
        OBJECT_TYPE,
        CONTEXT_ID,
        ITEM_ID )
      VALUES (
        l_obj_lgl_ctnt_id,
        1,
        SYSDATE,
        FND_GLOBAL.user_id,
        SYSDATE,
        FND_GLOBAL.user_id,
        FND_GLOBAL.user_id,
        p_lgl_ctnt_rec.object_id,
        l_object_type,
        p_lgl_ctnt_rec.context_id,
        p_lgl_ctnt_rec.deliverable_id);

Line: 298

      UPDATE IBE_DSP_OBJ_LGL_CTNT
      SET    LAST_UPDATE_DATE  = SYSDATE,
             LAST_UPDATED_BY   = FND_GLOBAL.user_id,
             LAST_UPDATE_LOGIN = FND_GLOBAL.user_id,
             OBJECT_ID         = p_lgl_ctnt_rec.object_id,
             OBJECT_TYPE       = l_object_type,
             CONTEXT_id        = p_lgl_ctnt_rec.context_id,
             ITEM_id           = p_lgl_ctnt_rec.deliverable_id ,
             OBJECT_VERSION_NUMBER = p_lgl_ctnt_rec.object_version_number + 1
      WHERE OBJ_LGL_CTNT_id        = p_lgl_ctnt_rec.obj_lgl_ctnt_id
      AND   OBJECT_VERSION_NUMBER  = p_lgl_ctnt_rec.object_version_number;

Line: 381

PROCEDURE save_delete_lgl_ctnt(
  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_object_type_code	IN  VARCHAR2,
  p_lgl_ctnt_tbl	IN  OBJ_LGL_CTNT_TBL_TYPE )
IS
  l_api_name    CONSTANT VARCHAR2(30) := 'save_delete_itm_lgl_ctnt';

Line: 402

  SAVEPOINT save_delete_itm_lgl_ctnt;

Line: 429

    IF p_lgl_ctnt_tbl(l_index).obj_lgl_ctnt_delete = FND_API.g_true
    THEN
      delete_logical_content(
        p_api_version,
        FND_API.g_false,
        FND_API.g_false,
        l_return_status,
        l_msg_count,
        l_msg_data,
        p_object_type_code,
        p_lgl_ctnt_tbl(l_index));

Line: 441

    ELSIF p_lgl_ctnt_tbl(l_index).obj_lgl_ctnt_delete = FND_API.g_false
    THEN
      save_logical_content(
        p_api_version,
        FND_API.g_false,
        p_commit,
        l_return_status,
        l_msg_count,
        l_msg_data,
        p_object_type_code,
        p_lgl_ctnt_tbl(l_index));

Line: 466

     ROLLBACK TO save_delete_itm_lgl_ctnt;

Line: 474

     ROLLBACK TO save_delete_itm_lgl_ctnt;

Line: 482

     ROLLBACK TO save_delete_itm_lgl_ctnt;

Line: 492

END save_delete_lgl_ctnt;

Line: 494

PROCEDURE delete_section(p_section_id IN  NUMBER )
IS
  l_api_name    CONSTANT VARCHAR2(30) := 'delete_section';

Line: 498

  SAVEPOINT delete_section;

Line: 506

  DELETE FROM IBE_DSP_OBJ_LGL_ctnt
    WHERE OBJECT_TYPE = 'S'
    AND   OBJECT_ID = p_section_id;

Line: 511

     ROLLBACK TO delete_section;

Line: 512

END delete_section;

Line: 514

PROCEDURE delete_deliverable(p_deliverable_id IN NUMBER)
IS
  l_api_name    CONSTANT VARCHAR2(30) := 'delete_deliverable';

Line: 518

  SAVEPOINT delete_deliverable;

Line: 522

    UPDATE  IBE_DSP_OBJ_LGL_CTNT SET
      ITEM_ID = null where
      ITEM_ID = p_deliverable_id ;

Line: 528

     ROLLBACK TO delete_deliverable;

Line: 529

END delete_deliverable;

Line: 531

PROCEDURE delete_category(p_category_id IN NUMBER)
IS
  l_api_name    CONSTANT VARCHAR2(30) := 'delete_category';

Line: 538

    DELETE FROM IBE_DSP_OBJ_LGL_ctnt
      WHERE OBJECT_TYPE = 'C'
      AND   OBJECT_ID = p_category_id;

Line: 542

END delete_category;

Line: 544

PROCEDURE delete_item(p_item_id IN NUMBER )
IS
  l_api_name    CONSTANT VARCHAR2(30) := 'delete_item';

Line: 551

    DELETE FROM IBE_DSP_OBJ_LGL_ctnt
      WHERE OBJECT_TYPE = 'I'
      AND   OBJECT_id   = p_item_id;

Line: 555

END delete_item;

Line: 557

PROCEDURE delete_context(p_context_id IN NUMBER )
IS
  l_api_name    CONSTANT VARCHAR2(30) := 'delete_context';

Line: 561

  SAVEPOINT delete_context;

Line: 565

    DELETE IBE_DSP_OBJ_LGL_CTNT
      WHERE context_id = p_context_id;

Line: 570

     ROLLBACK TO delete_context;

Line: 571

END delete_context;

Line: 573

PROCEDURE delete_category_dlv(
          p_category_id       IN   NUMBER,
          p_deliverable_id    IN   NUMBER )
IS
  l_api_name    CONSTANT VARCHAR2(30) := 'delete_category_dlv';

Line: 579

  SAVEPOINT delete_category_dlv;

Line: 584

    UPDATE  IBE_DSP_OBJ_LGL_CTNT
       SET  item_id = NULL
      WHERE object_type  = 'C'
      AND   object_id    = p_category_id
      AND   item_id      = p_deliverable_id;

Line: 592

     ROLLBACK TO delete_category_dlv;

Line: 593

END delete_category_dlv;