APPS.IBE_COPY_LOGICALCONTENT_GRP dependencies on IBE_DSP_OBJ_LGL_CTNT

Line 20: SELECT ibe_dsp_obj_lgl_ctnt_s1.NEXTVAL

16: |___________________________________________________________________________|*/
17: l_true VARCHAR2(1) := FND_API.G_TRUE;
18: --- Generate primary key for the table
19: CURSOR obj_lgl_ctnt_id_seq IS
20: SELECT ibe_dsp_obj_lgl_ctnt_s1.NEXTVAL
21: FROM DUAL;
22:
23: PROCEDURE copy_lgl_ctnt(
24: p_api_version IN NUMBER,

Line 71: from ibe_dsp_obj_lgl_ctnt

67: l_from_deliverable_ids.extend();
68: BEGIN
69: select item_id
70: into l_deliverable_id
71: from ibe_dsp_obj_lgl_ctnt
72: where context_id = l_context_id
73: and object_id = p_from_product_id;
74: l_from_deliverable_ids(i) := l_deliverable_id;
75:

Line 204: from ibe_dsp_obj_lgl_ctnt

200: END IF;
201:
202: select obj_lgl_ctnt_id, object_version_number,item_id
203: into l_ctnt_id, l_version_number, l_item_id
204: from ibe_dsp_obj_lgl_ctnt
205: where context_id = l_context_id
206: and object_id = l_to_product_id;
207:
208: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 214: DELETE FROM IBE_DSP_OBJ_LGL_ctnt

210: END IF;
211:
212: -- update the existing record
213: IF (l_deliverable_id is null) then
214: DELETE FROM IBE_DSP_OBJ_LGL_ctnt
215: WHERE obj_lgl_ctnt_id = l_ctnt_id
216: AND object_version_number = l_version_number
217: AND object_type = l_object_type;
218:

Line 226: UPDATE IBE_DSP_OBJ_LGL_CTNT

222:
223:
224: ELSE
225: if (l_item_id <> l_deliverable_id) THEN
226: UPDATE IBE_DSP_OBJ_LGL_CTNT
227: SET LAST_UPDATE_DATE = SYSDATE,
228: LAST_UPDATED_BY = FND_GLOBAL.user_id,
229: LAST_UPDATE_LOGIN = FND_GLOBAL.user_id,
230: OBJECT_ID = l_to_product_id,

Line 260: INSERT INTO IBE_DSP_OBJ_LGL_CTNT (

256: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
257: IBE_Util.Debug('begin insert new rec for target product, seq id='||l_obj_lgl_ctnt_id);
258: END IF;
259:
260: INSERT INTO IBE_DSP_OBJ_LGL_CTNT (
261: OBJ_LGL_CTNT_ID,
262: OBJECT_VERSION_NUMBER,
263: LAST_UPDATE_DATE,
264: LAST_UPDATED_BY,