APPS.IBE_TPLCATEGORY_GRP dependencies on IBE_DSP_TPL_CTG

Line 11: SELECT ibe_dsp_tpl_ctg_s1.NEXTVAL

7: -- *********************************************************************************
8:
9: ---- Generate primary key from sequence
10: CURSOR dsp_tpl_seq IS
11: SELECT ibe_dsp_tpl_ctg_s1.NEXTVAL
12: FROM DUAL;
13:
14: ---------------------------------------------------------------------+
15: -- NOTES

Line 78: INSERT INTO IBE_DSP_TPL_CTG (

74: OPEN dsp_tpl_seq;
75: FETCH dsp_tpl_seq INTO l_dsp_tpl_seq_id;
76: CLOSE dsp_tpl_seq;
77:
78: INSERT INTO IBE_DSP_TPL_CTG (
79: TPL_CTG_ID,
80: OBJECT_VERSION_NUMBER,
81: LAST_UPDATE_DATE,
82: LAST_UPDATED_BY,

Line 313: FROM ibe_dsp_tpl_ctg

309: l_index NUMBER;
310:
311: CURSOR category_cur(p_tpl_ctg_id IN NUMBER) IS
312: SELECT category_id ,ITEM_ID
313: FROM ibe_dsp_tpl_ctg
314: WHERE tpl_ctg_id = p_tpl_ctg_id;
315: BEGIN
316: --------------------- initialize -----------------------+
317: SAVEPOINT delete_tpl_ctg_relation;

Line 347: DELETE FROM IBE_DSP_TPL_CTG

343: OPEN category_cur(p_tpl_ctg_id_tbl(l_index) );
344: FETCH category_cur into l_category_id,l_deliverable_id;
345: CLOSE category_cur;
346:
347: DELETE FROM IBE_DSP_TPL_CTG
348: WHERE TPL_CTG_ID = p_tpl_ctg_id_tbl(l_index);
349:
350: IBE_LogicalContent_grp.delete_category_dlv(
351: l_category_id,

Line 410: -- 4. Creates a category to templates relationship (IBE_DSP_TPL_CTG)

406: -- 1. Raises an exception if the api_version is not valid
407: -- 2. Raises an exception if the category_id is missing or invalid
408: -- 3. Raises an exception if any invalid template_id is passed in
409: -- p_template_id_tbl
410: -- 4. Creates a category to templates relationship (IBE_DSP_TPL_CTG)
411: ---------------------------------------------------------------------+
412: PROCEDURE add_ctg_tpl(
413: p_api_version IN NUMBER,
414: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

Line 548: DELETE FROM ibe_dsp_tpl_ctg

544: --------------------- initialize -----------------------+
545: SAVEPOINT delete_deliverable;
546:
547: --- Delete the deliverable from the table
548: DELETE FROM ibe_dsp_tpl_ctg
549: WHERE item_id = p_template_id;
550: EXCEPTION
551: WHEN OTHERS THEN
552: ROLLBACK TO delete_deliverable;

Line 568: DELETE FROM ibe_dsp_tpl_ctg

564: --------------------- initialize -----------------------+
565: SAVEPOINT delete_category;
566:
567: --- Delete the deliverable from the table
568: DELETE FROM ibe_dsp_tpl_ctg
569: WHERE category_id = p_category_id;
570: EXCEPTION
571: WHEN OTHERS THEN
572: ROLLBACK TO delete_category;