1 PACKAGE IBE_TplCategory_GRP AUTHID CURRENT_USER AS
2 /* $Header: IBEGTCGS.pls 115.1 2002/12/14 07:51:09 schak ship $ */
3
4
5 -- HISTORY
6 -- 12/12/02 SCHAK Modified for NOCOPY (Bug # 2691704) Changes.
7 -- *********************************************************************************
8
9 g_pkg_name CONSTANT VARCHAR2(30) :='IBE_TplCategory_GRP';
10 g_api_version CONSTANT NUMBER := 1.0;
11
12 TYPE category_id_tbl_type IS TABLE OF NUMBER(15)
13 INDEX BY BINARY_INTEGER;
14
15 TYPE template_id_tbl_type IS TABLE OF NUMBER(15)
16 INDEX BY BINARY_INTEGER;
17
18 TYPE tpl_ctg_id_tbl_type IS TABLE OF NUMBER(15)
19 INDEX BY BINARY_INTEGER;
20
21 -----------------------------------------------------------------------+
22 -- NOTES
23 -- 1. Raises an exception if the api_version is not valid
24 -- 2. Raises an exception if the template_id is missing or invalid
25 -- The template_id should have DELIVERABLE_TYPE_CODE = TEMPLATE
26 -- and APPLICABLE_TO_CODE = CATEGORY (JTF_AMV_ITEMS_B)
27 -- 3. Raises an exception if any invalid category is passed in
28 -- p_category_id_tbl
29 --
30 ---------------------------------------------------------------------+
31 PROCEDURE add_tpl_ctg(
32 p_api_version IN NUMBER,
33 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
34 p_commit IN VARCHAR2 := FND_API.g_false,
35 x_return_status OUT NOCOPY VARCHAR2,
36 x_msg_count OUT NOCOPY NUMBER,
37 x_msg_data OUT NOCOPY VARCHAR2,
38 p_template_id IN NUMBER,
39 p_category_id_tbl IN category_id_tbl_type );
40
41 -----------------------------------------------------------------------+
42 -- NOTES
43 -- 1. Raise exception if the p_api_version doesn't match.
44 -- 2. Deletes the association of the template to the category
45 -- 3. Deletes the category to template association in IBE_OBJ_LGL_CTNT
46 -- for all display contexts
47 --------------------------------------------------------------------+
48 PROCEDURE delete_tpl_ctg_relation(
49 p_api_version IN NUMBER,
50 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
51 p_commit IN VARCHAR2 := FND_API.g_false,
52 x_return_status OUT NOCOPY VARCHAR2,
53 x_msg_count OUT NOCOPY NUMBER,
54 x_msg_data OUT NOCOPY VARCHAR2,
55 p_tpl_ctg_id_tbl IN tpl_ctg_id_tbl_type );
56
57 -----------------------------------------------------------------------+
58 -- NOTES
59 -- 1. Raises an exception if the api_version is not valid
60 -- 2. Raises an exception if the category_id is missing or invalid
61 -- 3. Raises an exception if any invalid template_id is passed in
62 -- p_template_id_tbl
63 -- 4. Creates a category to templates relationship (IBE_DSP_TPL_CTG)
64 ---------------------------------------------------------------------+
65 PROCEDURE add_ctg_tpl(
66 p_api_version IN NUMBER,
67 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
68 p_commit IN VARCHAR2 := FND_API.g_false,
69 x_return_status OUT NOCOPY VARCHAR2,
70 x_msg_count OUT NOCOPY NUMBER,
71 x_msg_data OUT NOCOPY VARCHAR2,
72 p_category_id IN NUMBER,
73 p_template_id_tbl IN template_id_tbl_type );
74
75 -----------------------------------------------------------------------+
76 -- NOTES
77 -- 1. Deletes all the category-template_id association for the
78 -- template id passed
79 -- Note : This method should not be called from the application
80 ---------------------------------------------------------------------+
81 PROCEDURE delete_deliverable(p_template_id IN NUMBER );
82
83 -----------------------------------------------------------------------+
84 -- NOTES
85 -- 1. Deletes all the category-template_id association for the
86 -- category id passed
87 -- Note : This method should not be called from the application
88 ---------------------------------------------------------------------+
89 PROCEDURE delete_category (p_category_id IN NUMBER );
90
91 END IBE_TplCategory_GRP;