APPS.JTF_LOGICALCONTENT_GRP dependencies on JTF_DSP_OBJ_LGL_CTNT

Line 7: SELECT jtf_dsp_obj_lgl_ctnt_s1.NEXTVAL

3:
4:
5: --- Generate primary key for the table
6: CURSOR obj_lgl_ctnt_id_seq IS
7: SELECT jtf_dsp_obj_lgl_ctnt_s1.NEXTVAL
8: FROM DUAL;
9:
10:
11: PROCEDURE delete_logical_content(

Line 61: delete from jtf_dsp_obj_lgl_ctnt where

57: end if;
58:
59: --dbms_output.put_line('delete_logical_content: passed the object existence');
60:
61: delete from jtf_dsp_obj_lgl_ctnt where
62: obj_lgl_ctnt_id = p_lgl_ctnt_rec.obj_lgl_ctnt_id and
63: object_version_number = p_lgl_ctnt_rec.object_version_number;
64: else
65: raise jtf_dspmgrvalidation_grp.lglctnt_id_req_exception;

Line 296: delete from JTF_DSP_OBJ_LGL_CTNT where

292: if jtf_dspmgrvalidation_grp.check_lgl_ctnt_id_exists(p_lgl_ctnt_rec.obj_lgl_ctnt_id,
293: p_lgl_ctnt_rec.object_version_number) = false then
294: raise FND_API.g_exc_error;
295: end if;
296: delete from JTF_DSP_OBJ_LGL_CTNT where
297: obj_lgl_ctnt_id = p_lgl_ctnt_rec.obj_lgl_ctnt_id and
298: object_version_number = p_lgl_ctnt_rec.object_version_number and
299: object_type = l_object_type;
300: else

Line 308: INSERT INTO JTF_DSP_OBJ_LGL_CTNT (

304: OPEN obj_lgl_ctnt_id_seq;
305: FETCH obj_lgl_ctnt_id_seq INTO l_obj_lgl_ctnt_id;
306: CLOSE obj_lgl_ctnt_id_seq;
307:
308: INSERT INTO JTF_DSP_OBJ_LGL_CTNT (
309: OBJ_LGL_CTNT_ID,
310: OBJECT_VERSION_NUMBER,
311: LAST_UPDATE_DATE,
312: LAST_UPDATED_BY,

Line 343: UPDATE JTF_DSP_OBJ_LGL_CTNT SET

339: p_lgl_ctnt_rec.object_version_number) = false then
340: raise FND_API.g_exc_error;
341: end if;
342:
343: UPDATE JTF_DSP_OBJ_LGL_CTNT SET
344: LAST_UPDATE_DATE = SYSDATE,
345: LAST_UPDATED_BY = FND_GLOBAL.user_id,
346: LAST_UPDATE_LOGIN= FND_GLOBAL.user_id,
347: OBJECT_ID = p_lgl_ctnt_rec.object_id,

Line 589: DELETE FROM JTF_DSP_OBJ_LGL_CTNT where

585: if jtf_dspmgrvalidation_grp.check_section_exists(p_section_id) = false then
586: raise FND_API.g_exc_error;
587: end if;
588:
589: DELETE FROM JTF_DSP_OBJ_LGL_CTNT where
590: OBJECT_TYPE = 'S' and
591: OBJECT_ID = p_section_id;
592:
593: EXCEPTION

Line 610: UPDATE JTF_DSP_OBJ_LGL_CTNT SET

606:
607: if p_deliverable_id is not null
608: then
609:
610: UPDATE JTF_DSP_OBJ_LGL_CTNT SET
611: ITEM_ID = null where
612: ITEM_ID = p_deliverable_id ;
613:
614: end if;

Line 632: DELETE FROM JTF_DSP_OBJ_LGL_CTNT where

628: -- SAVEPOINT delete_category;
629:
630: if p_category_id is not null
631: then
632: DELETE FROM JTF_DSP_OBJ_LGL_CTNT where
633: OBJECT_TYPE = 'C' and
634: OBJECT_ID = p_category_id;
635: end if;
636:

Line 652: DELETE FROM JTF_DSP_OBJ_LGL_CTNT where

648: -- SAVEPOINT delete_item;
649:
650: if p_item_id is not null
651: then
652: DELETE FROM JTF_DSP_OBJ_LGL_CTNT where
653: OBJECT_TYPE = 'I' and
654: OBJECT_ID = p_item_id;
655: end if;
656:

Line 674: delete JTF_DSP_OBJ_LGL_CTNT

670:
671: if p_context_id is not null
672: then
673:
674: delete JTF_DSP_OBJ_LGL_CTNT
675: where context_id = p_context_id;
676: end if;
677:
678: EXCEPTION

Line 696: UPDATE JTF_DSP_OBJ_LGL_CTNT

692: if p_category_id is not null and
693: p_deliverable_id is not null
694: then
695:
696: UPDATE JTF_DSP_OBJ_LGL_CTNT
697: set item_id = null
698: where object_type = 'C' and
699: object_id = p_category_id and
700: ITEM_ID = p_deliverable_id;