1 PACKAGE ICX_CAT_POPULATE_CATG_GRP AS
2 /* $Header: ICXGPPCS.pls 120.1 2005/11/09 10:39:57 sbgeorge noship $*/
3
4 -- Start of comments
5 -- API name : populateCategoryChange
6 -- * Type : Group
7 -- * Pre-reqs : None.
8 -- * Function : Takes care of creating and updating the category in ip datamodel
9 -- if the category belongs to purchasing category set. This
10 -- procedure is called by Inventory on category creation, updation
11 -- and category translation updation in mtl_categories_b
12 -- and mtl_categories_tl from forms / html interface
13 -- * Parameters :
14 -- IN : p_api_version IN NUMBER Required
15 -- p_init_msg_list IN VARCHAR2 Optional
16 -- Default = FND_API.G_FALSE
17 -- p_commit IN VARCHAR2 Optional
18 -- Default = FND_API.G_FALSE
19 -- p_validation_level IN NUMBER Optional
20 -- Default = FND_API.G_VALID_LEVEL_FULL
21 -- p_dml_type IN VARCHAR2 Required
22 -- Corresponds to the dml action done to the
23 -- category. The allowed values
24 -- are "CREATE/UPDATE/DELETE"
25 -- p_structure_id IN NUMBER Required
26 -- Corresponds to the column STRUCTURE_ID in
27 -- the table MTL_CATEGORIES_B, and identifies the
28 -- structure_id of the category.
29 -- p_category_name IN VARCHAR2 Required
30 -- Corresponds to the column CONCATENATED_SEGMENTS in
31 -- the table MTL_CATEGORIES_KFV.
32 -- p_category_id IN NUMBER Required
33 -- Corresponds to the column CATEGORY_ID in
34 -- the table MTL_CATEGORIES_B, and identifies the
35 -- category.
36 -- OUT : x_return_status OUT NOCOPY VARCHAR2(1)
37 -- * Version : Current version 1.0
38 -- Previous version 1.0
39 -- Initial version 1.0
40 --
41 -- Notes : 1. As per the inventory team, deleting a category is not allowed
42 -- from category forms / html interface.
43 -- 2. No bulk operations (i.e loading data from an interface table)
44 -- are allowed on category
45 --
46 -- End of comments
47 PROCEDURE populateCategoryChange
48 ( p_api_version IN NUMBER ,
49 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
50 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
51 p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL ,
52 x_return_status OUT NOCOPY VARCHAR2 ,
53 p_dml_type IN VARCHAR2 ,
54 p_structure_id IN NUMBER ,
55 p_category_name IN VARCHAR2 ,
56 p_category_id IN NUMBER
57 );
58
59 -- Start of comments
60 -- API name : populateValidCategorySetInsert
61 -- * Type : Group
62 -- * Pre-reqs : None.
63 -- * Function : Takes care of creating the category in ip datamodel
64 -- if the category belongs to purchasing category set. This
65 -- procedure is called by Inventory when a category is added to the
66 -- valid category set (MTL_CATEGORY_SET_VALID_CATS)
67 -- from forms / html interface.
68 -- * Parameters :
69 -- IN : p_api_version IN NUMBER Required
70 -- p_init_msg_list IN VARCHAR2 Optional
71 -- Default = FND_API.G_FALSE
72 -- p_commit IN VARCHAR2 Optional
73 -- Default = FND_API.G_FALSE
74 -- p_validation_level IN NUMBER Optional
75 -- Default = FND_API.G_VALID_LEVEL_FULL
76 -- p_category_set_id IN NUMBER Required
77 -- Corresponds to the column CATEGORY_SET_ID in
78 -- the table MTL_CATEGORY_SET_VALID_CATS, and
79 -- identifies the category_set_id of the category.
80 -- p_category_id IN NUMBER Required
81 -- Corresponds to the column CATEGORY_ID in
82 -- the table MTL_CATEGORIES_B, and identifies the
83 -- category.
84 -- OUT : x_return_status OUT NOCOPY VARCHAR2(1)
85 -- * Version : Current version 1.0
86 -- Previous version 1.0
87 -- Initial version 1.0
88 --
89 -- Notes : 1. As per the inventory team, No bulk operations
90 -- (i.e loading data from an interface table)
91 -- are allowed on valid cat sets.
92 --
93 -- End of comments
94 PROCEDURE populateValidCategorySetInsert
95 ( p_api_version IN NUMBER ,
96 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
97 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
98 p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL ,
99 x_return_status OUT NOCOPY VARCHAR2 ,
100 p_category_set_id IN NUMBER ,
101 p_category_id IN NUMBER
102 );
103
104 -- Start of comments
105 -- API name : populateValidCategorySetUpdate
106 -- * Type : Group
107 -- * Pre-reqs : None.
108 -- * Function : Takes care of deleting and creating the category in ip datamodel
109 -- if the category belongs to purchasing category set. This
110 -- procedure is called by Inventory when a category is updated to a
111 -- new category in valid category set (MTL_CATEGORY_SET_VALID_CATS)
112 -- from forms / html interface.
113 -- * Parameters :
114 -- IN : p_api_version IN NUMBER Required
115 -- p_init_msg_list IN VARCHAR2 Optional
116 -- Default = FND_API.G_FALSE
117 -- p_commit IN VARCHAR2 Optional
118 -- Default = FND_API.G_FALSE
119 -- p_validation_level IN NUMBER Optional
120 -- Default = FND_API.G_VALID_LEVEL_FULL
121 -- p_category_set_id IN NUMBER Required
122 -- Corresponds to the column CATEGORY_SET_ID in
123 -- the table MTL_CATEGORY_SET_VALID_CATS, and
124 -- identifies the category_set_id of the category.
125 -- p_old_category_id IN NUMBER Required
126 -- Corresponds to the column CATEGORY_ID in
127 -- the table MTL_CATEGORIES_B, and identifies the
128 -- category that needs to be deleted.
129 -- p_new_category_id IN NUMBER Required
130 -- Corresponds to the column CATEGORY_ID in
131 -- the table MTL_CATEGORIES_B, and identifies the
132 -- category that needs to be added.
133 -- OUT : x_return_status OUT NOCOPY VARCHAR2(1)
134 -- * Version : Current version 1.0
135 -- Previous version 1.0
136 -- Initial version 1.0
137 --
138 -- Notes : 1. As per the inventory team, No bulk operations
139 -- (i.e loading data from an interface table)
140 -- are allowed on valid cat sets.
141 --
142 -- End of comments
143 PROCEDURE populateValidCategorySetUpdate
144 ( p_api_version IN NUMBER ,
145 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
146 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
147 p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL ,
148 x_return_status OUT NOCOPY VARCHAR2 ,
149 p_category_set_id IN NUMBER ,
150 p_old_category_id IN NUMBER ,
151 p_new_category_id IN NUMBER
152 );
153
154 -- Start of comments
155 -- API name : populateValidCategorySetDelete
156 -- * Type : Group
157 -- * Pre-reqs : None.
158 -- * Function : Takes care of deleting the category in ip datamodel
159 -- if the category belongs to purchasing category set. This
160 -- procedure is called by Inventory when a category is deleted
161 -- from the valid category set (MTL_CATEGORY_SET_VALID_CATS)
162 -- from forms / html interface.
163 -- * Parameters :
164 -- IN : p_api_version IN NUMBER Required
165 -- p_init_msg_list IN VARCHAR2 Optional
166 -- Default = FND_API.G_FALSE
167 -- p_commit IN VARCHAR2 Optional
168 -- Default = FND_API.G_FALSE
169 -- p_validation_level IN NUMBER Optional
170 -- Default = FND_API.G_VALID_LEVEL_FULL
171 -- p_category_set_id IN NUMBER Required
172 -- Corresponds to the column CATEGORY_SET_ID in
173 -- the table MTL_CATEGORY_SET_VALID_CATS, and
174 -- identifies the category_set_id of the category.
175 -- p_category_id IN NUMBER Required
176 -- Corresponds to the column CATEGORY_ID in
177 -- the table MTL_CATEGORIES_B, and identifies the
178 -- category to be deleted.
179 -- OUT : x_return_status OUT NOCOPY VARCHAR2(1)
180 -- * Version : Current version 1.0
181 -- Previous version 1.0
182 -- Initial version 1.0
183 --
184 -- Notes : 1. As per the inventory team, No bulk operations
185 -- (i.e loading data from an interface table)
186 -- are allowed on valid cat sets.
187 --
188 -- End of comments
189 PROCEDURE populateValidCategorySetDelete
190 ( p_api_version IN NUMBER ,
191 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
192 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
193 p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL ,
194 x_return_status OUT NOCOPY VARCHAR2 ,
198
195 p_category_set_id IN NUMBER ,
196 p_category_id IN NUMBER
197 );
199 END ICX_CAT_POPULATE_CATG_GRP;