APPS.IBE_LOGICALCONTENT_GRP dependencies on IBE_DSP_OBJ_LGL_CTNT

Line 10: SELECT ibe_dsp_obj_lgl_ctnt_s1.NEXTVAL

6: -- *********************************************************************************
7:
8: --- Generate primary key for the table
9: CURSOR obj_lgl_ctnt_id_seq IS
10: SELECT ibe_dsp_obj_lgl_ctnt_s1.NEXTVAL
11: FROM DUAL;
12:
13:
14: PROCEDURE delete_logical_content(

Line 60: DELETE FROM ibe_dsp_obj_lgl_ctnt

56: THEN
57: RAISE FND_API.g_exc_error;
58: END IF;
59:
60: DELETE FROM ibe_dsp_obj_lgl_ctnt
61: WHERE obj_lgl_ctnt_id = p_lgl_ctnt_rec.obj_lgl_ctnt_id
62: AND object_version_number = p_lgl_ctnt_rec.object_version_number;
63: ELSE
64: RAISE ibe_dspmgrvalidation_grp.lglctnt_id_req_exception;

Line 254: DELETE FROM IBE_DSP_OBJ_LGL_ctnt

250: THEN
251: RAISE FND_API.g_exc_error;
252: END IF;
253:
254: DELETE FROM IBE_DSP_OBJ_LGL_ctnt
255: WHERE obj_lgl_ctnt_id = p_lgl_ctnt_rec.obj_lgl_ctnt_id
256: AND object_version_number = p_lgl_ctnt_rec.object_version_number
257: AND object_type = l_object_type;
258: ELSE

Line 265: INSERT INTO IBE_DSP_OBJ_LGL_CTNT (

261: OPEN obj_lgl_ctnt_id_seq;
262: FETCH obj_lgl_ctnt_id_seq INTO l_obj_lgl_ctnt_id;
263: CLOSE obj_lgl_ctnt_id_seq;
264:
265: INSERT INTO IBE_DSP_OBJ_LGL_CTNT (
266: OBJ_LGL_CTNT_ID,
267: OBJECT_VERSION_NUMBER,
268: LAST_UPDATE_DATE,
269: LAST_UPDATED_BY,

Line 298: UPDATE IBE_DSP_OBJ_LGL_CTNT

294: THEN
295: RAISE FND_API.g_exc_error;
296: END IF;
297:
298: UPDATE IBE_DSP_OBJ_LGL_CTNT
299: SET LAST_UPDATE_DATE = SYSDATE,
300: LAST_UPDATED_BY = FND_GLOBAL.user_id,
301: LAST_UPDATE_LOGIN = FND_GLOBAL.user_id,
302: OBJECT_ID = p_lgl_ctnt_rec.object_id,

Line 506: DELETE FROM IBE_DSP_OBJ_LGL_ctnt

502: THEN
503: RAISE FND_API.g_exc_error;
504: END IF;
505:
506: DELETE FROM IBE_DSP_OBJ_LGL_ctnt
507: WHERE OBJECT_TYPE = 'S'
508: AND OBJECT_ID = p_section_id;
509: EXCEPTION
510: WHEN OTHERS THEN

Line 522: UPDATE IBE_DSP_OBJ_LGL_CTNT SET

518: SAVEPOINT delete_deliverable;
519:
520: IF p_deliverable_id IS NOT NULL
521: THEN
522: UPDATE IBE_DSP_OBJ_LGL_CTNT SET
523: ITEM_ID = null where
524: ITEM_ID = p_deliverable_id ;
525: END IF;
526: EXCEPTION

Line 538: DELETE FROM IBE_DSP_OBJ_LGL_ctnt

534: BEGIN
535: -- SAVEPOINT delete_category;
536: IF p_category_id IS NOT NULL
537: THEN
538: DELETE FROM IBE_DSP_OBJ_LGL_ctnt
539: WHERE OBJECT_TYPE = 'C'
540: AND OBJECT_ID = p_category_id;
541: END IF;
542: END delete_category;

Line 551: DELETE FROM IBE_DSP_OBJ_LGL_ctnt

547: BEGIN
548: -- SAVEPOINT delete_item;
549: IF p_item_id IS NOT NULL
550: THEN
551: DELETE FROM IBE_DSP_OBJ_LGL_ctnt
552: WHERE OBJECT_TYPE = 'I'
553: AND OBJECT_id = p_item_id;
554: END IF;
555: END delete_item;

Line 565: DELETE IBE_DSP_OBJ_LGL_CTNT

561: SAVEPOINT delete_context;
562:
563: IF p_context_id IS NOT NULL
564: THEN
565: DELETE IBE_DSP_OBJ_LGL_CTNT
566: WHERE context_id = p_context_id;
567: END IF;
568: EXCEPTION
569: WHEN OTHERS THEN

Line 584: UPDATE IBE_DSP_OBJ_LGL_CTNT

580:
581: IF p_category_id IS NOT NULL AND
582: p_deliverable_id IS NOT NULL
583: THEN
584: UPDATE IBE_DSP_OBJ_LGL_CTNT
585: SET item_id = NULL
586: WHERE object_type = 'C'
587: AND object_id = p_category_id
588: AND item_id = p_deliverable_id;