2: /* $Header: JTFGTCGB.pls 115.8 2004/07/09 18:51:14 applrt ship $ */
3:
4: ---- Generate primary key from sequence
5: CURSOR dsp_tpl_seq IS
6: SELECT jtf_dsp_tpl_ctg_s1.NEXTVAL
7: FROM DUAL;
8:
9: ---------------------------------------------------------------------
10: -- NOTES
76: OPEN dsp_tpl_seq;
77: FETCH dsp_tpl_seq INTO l_dsp_tpl_seq_id;
78: CLOSE dsp_tpl_seq;
79:
80: INSERT INTO JTF_DSP_TPL_CTG (
81: TPL_CTG_ID,
82: OBJECT_VERSION_NUMBER,
83: LAST_UPDATE_DATE,
84: LAST_UPDATED_BY,
324: l_deliverable_id number;
325: l_index NUMBER;
326:
327: CURSOR category_cur(p_tpl_ctg_id IN NUMBER) IS
328: SELECT category_id ,ITEM_ID from jtf_dsp_tpl_ctg where
329: tpl_ctg_id = p_tpl_ctg_id;
330:
331: BEGIN
332:
362: FETCH category_cur into l_category_id,l_deliverable_id;
363: CLOSE category_cur;
364:
365:
366: DELETE FROM JTF_DSP_TPL_CTG WHERE
367: TPL_CTG_ID = p_tpl_ctg_id_tbl(l_index);
368:
369:
370: JTF_LogicalContent_grp.delete_category_dlv( l_category_id,
436: -- 1. Raises an exception if the api_version is not valid
437: -- 2. Raises an exception if the category_id is missing or invalid
438: -- 3. Raises an exception if any invalid template_id is passed in
439: -- p_template_id_tbl
440: -- 4. Creates a category to templates relationship (JTF_DSP_TPL_CTG)
441: ---------------------------------------------------------------------
442: PROCEDURE add_ctg_tpl(
443: p_api_version IN NUMBER,
444: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
585: --------------------- initialize -----------------------
586: SAVEPOINT delete_deliverable;
587:
588: --- Delete the deliverable from the table
589: delete from jtf_dsp_tpl_ctg where
590: item_id = p_template_id;
591:
592:
593: EXCEPTION
612: --------------------- initialize -----------------------
613: SAVEPOINT delete_category;
614:
615: --- Delete the deliverable from the table
616: delete from jtf_dsp_tpl_ctg where
617: category_id = p_category_id;
618:
619: EXCEPTION
620: