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