1 PACKAGE INV_ITEM_CATEGORY_PVT AS
2 /* $Header: INVVCATS.pls 120.0 2005/05/25 06:27:54 appldev noship $ */
3
4
5 ----------------------- Global variables and constants -----------------------
6
7 g_MISS_CHAR CONSTANT VARCHAR2(1) := fnd_api.g_MISS_CHAR;
8 g_MISS_NUM CONSTANT NUMBER := fnd_api.g_MISS_NUM;
9 g_MISS_DATE CONSTANT DATE := fnd_api.g_MISS_DATE;
10 g_YES CONSTANT VARCHAR2(1) := 'Y';
11 g_NO CONSTANT VARCHAR2(1) := 'N';
12
13 -- Validation level
14
15 g_VALIDATE_NONE CONSTANT NUMBER := 0;
16 g_VALIDATE_RULES CONSTANT NUMBER := 10;
17 g_VALIDATE_IDS CONSTANT NUMBER := 20;
18 g_VALIDATE_VALUES CONSTANT NUMBER := 30;
19 g_VALIDATE_ALL CONSTANT NUMBER := 100;
20
21
22 --------------------------------- Exceptions ---------------------------------
23 /*
24 Numeric_Or_Value_Error EXCEPTION;
25 PRAGMA exception_init (Numeric_Or_Value_Error, -6502);
26 */
27
28
29 -------------------------- Global type declarations --------------------------
30
31 --, p_IPD_Item_tbl IN INV_Item_Types.IPD_Item_tbl_type
32
33 ------------------------------------------------------------------------------
34
35
36 ------------------------- Create_Category_Assignment -------------------------
37
38 PROCEDURE Create_Category_Assignment
39 (
40 p_api_version IN NUMBER
41 , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_FALSE
42 , p_commit IN VARCHAR2 DEFAULT fnd_api.g_FALSE
43 , p_validation_level IN NUMBER DEFAULT INV_ITEM_CATEGORY_PVT.g_VALIDATE_ALL
44 , p_inventory_item_id IN NUMBER
45 , p_organization_id IN NUMBER
46 , p_category_set_id IN NUMBER
47 , p_category_id IN NUMBER
48 , p_transaction_id IN NUMBER DEFAULT -9999
49 , p_request_id IN NUMBER DEFAULT NULL
50 , x_return_status OUT NOCOPY VARCHAR2
51 , x_msg_count OUT NOCOPY NUMBER
52 , x_msg_data OUT NOCOPY VARCHAR2
53 );
54
55
56 ------------------------- Delete_Category_Assignment -------------------------
57
58 PROCEDURE Delete_Category_Assignment
59 (
60 p_api_version IN NUMBER
61 , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_FALSE
62 , p_commit IN VARCHAR2 DEFAULT fnd_api.g_FALSE
63 , p_inventory_item_id IN NUMBER
64 , p_organization_id IN NUMBER
65 , p_category_set_id IN NUMBER
66 , p_category_id IN NUMBER
67 , p_transaction_id IN NUMBER DEFAULT -9999
68 , x_return_status OUT NOCOPY VARCHAR2
69 , x_msg_count OUT NOCOPY NUMBER
70 , x_msg_data OUT NOCOPY VARCHAR2
71 );
72
73
74 -- API to create a valid Category in Category Sets
75 -----------------------------------------------------------------------------
76 PROCEDURE Create_Valid_Category(
77 p_api_version IN NUMBER,
78 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
79 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
80 p_category_set_id IN NUMBER,
81 p_category_id IN NUMBER,
82 p_parent_category_id IN NUMBER,
83 x_return_status OUT NOCOPY VARCHAR2,
84 x_errorcode OUT NOCOPY NUMBER,
85 x_msg_count OUT NOCOPY NUMBER,
86 x_msg_data OUT NOCOPY VARCHAR2
87 );
88 -- Start OF comments
89 -- API name : Create_Valid_Category
90 -- TYPE : Private and USed by ENI Upgrade program alone
91 -- Pre-reqs : 11.5.10 level
92 -- FUNCTION : Create a record in mtl_category_set_valid_cats.
93 -- This sets the PUB API package level variable
94 -- and calls the corresponding PUB API procedure.
95 -- This will NOT do validations for ENABLED_FLAG and DISABLE_DATE
96 --
97 -- Parameters:
98 -- IN : p_api_version IN NUMBER (required)
99 -- API Version of this procedure
100 --
101 -- p_init_msg_level IN VARCHAR2 (optional)
102 -- DEFAULT = FND_API.G_FALSE,
103 --
104 -- p_commit IN VARCHAR2 (optional)
105 -- DEFAULT = FND_API.G_FALSE,
106 --
107 -- p_category_set_id IN NUMBER (required)
108 -- category_set_id
109 --
110 -- p_category_id IN NUMBER (required)
111 -- category_id
112 --
113 -- p_parent_category_id IN NUMBER (required)
114 -- parent of current category id
115 --
116 -- OUT : x_msg_count OUT NUMBER,
117 -- number of messages in the message list
118 --
119 -- x_msg_data OUT VARCHAR2,
120 -- if number of messages is 1, then this parameter
121 -- contains the message itself
122 --
123 -- X_return_status OUT NUMBER
124 -- Result of all the operations
125 -- FND_API.G_RET_STS_SUCCESS if success
126 -- FND_API.G_RET_STS_ERROR if error
127 -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error
128 --
129 -- X_ErrorCode OUT NUMBER
130 -- RETURN value OF the x_errorcode
131 -- check only if x_return_status <> fnd_api.g_ret_sts_success
132 -- These errors are unrecoverable and the API failed as a result of this
133 -- XXX - Error reason/message (will be updated after implementation)
134 -- -1 - unexpected error - all operations have been rollbacked
135 --
136 -- Version: Current Version 1.0
137 -- Previous Version : None
138 -- Notes :
139 --
140 -- END OF comments
141 -----------------------------------------------------------------------------
142
143 -- Update Valid Category
144 -- API to update a valid Category in Category Sets
145 -----------------------------------------------------------------------------
146 PROCEDURE Update_Valid_Category(
147 p_api_version IN NUMBER,
148 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
149 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
150 p_category_set_id IN NUMBER,
151 p_category_id IN NUMBER,
152 p_parent_category_id IN NUMBER,
153 x_return_status OUT NOCOPY VARCHAR2,
154 x_errorcode OUT NOCOPY NUMBER,
155 x_msg_count OUT NOCOPY NUMBER,
156 x_msg_data OUT NOCOPY VARCHAR2
157 );
158 -- Start OF comments
159 -- API name : Update_Valid_Category
160 -- TYPE : Private and USed by ENI Upgrade program alone
161 -- Pre-reqs : 11.5.10 level
162 -- FUNCTION : Update a record in mtl_category_set_valid_cats.
163 -- This sets the PUB API package level variable
164 -- and calls the corresponding PUB API procedure.
165 -- This will NOT do validations for ENABLED_FLAG and DISABLE_DATE
166 --
167 -- Parameters:
168 -- IN : p_api_version IN NUMBER (required)
169 -- API Version of this procedure
170 --
171 -- p_init_msg_level IN VARCHAR2 (optional)
172 -- DEFAULT = FND_API.G_FALSE,
173 --
174 -- p_commit IN VARCHAR2 (optional)
175 -- DEFAULT = FND_API.G_FALSE,
176 --
177 -- p_category_set_id IN NUMBER (required)
178 -- category_set_id
179 --
180 -- p_category_id IN NUMBER (required)
181 -- category_id
182 --
183 -- p_parent_category_id IN NUMBER (required)
184 -- parent of current category id
185 -- OUT : x_msg_count OUT NUMBER,
186 -- number of messages in the message list
187 --
188 -- x_msg_data OUT VARCHAR2,
189 -- if number of messages is 1, then this parameter
190 -- contains the message itself
191 --
192 -- X_return_status OUT NUMBER
193 -- Result of all the operations
194 -- FND_API.G_RET_STS_SUCCESS if success
195 -- FND_API.G_RET_STS_ERROR if error
196 -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error
197 --
198 -- X_ErrorCode OUT NUMBER
199 -- RETURN value OF the x_errorcode
200 -- check only if x_return_status <> fnd_api.g_ret_sts_success
201 -- These errors are unrecoverable and the API failed as a result of this
202 -- XXX - Error reason/message (will be updated after implementation)
203 -- -1 - unexpected error - all operations have been rollbacked
204 --
205 -- Version: Current Version 1.0
206 -- Previous Version : None
207 -- Notes :
208 --
209 -- END OF comments
210 -----------------------------------------------------------------------------
211
212 --* Added for Bug #3991044
213 ------------------------- Update_Category_Assignment -------------------------
214
215 PROCEDURE Update_Category_Assignment
216 (
217 p_api_version IN NUMBER
218 , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_FALSE
219 , p_commit IN VARCHAR2 DEFAULT fnd_api.g_FALSE
220 , p_inventory_item_id IN NUMBER
221 , p_organization_id IN NUMBER
222 , p_category_set_id IN NUMBER
223 , p_category_id IN NUMBER
224 , p_old_category_id IN NUMBER
225 , p_transaction_id IN NUMBER DEFAULT -9999
226 , x_return_status OUT NOCOPY VARCHAR2
227 , x_msg_count OUT NOCOPY NUMBER
228 , x_msg_data OUT NOCOPY VARCHAR2
229 );
230 --* End of Bug #3991044
231
232 END INV_ITEM_CATEGORY_PVT;