1 PACKAGE GMD_SPEC_VRS_PUB AS
2 /* $Header: GMDPSVRS.pls 120.1 2006/10/04 11:51:29 srakrish noship $*/
3 /*#
4 * This interface is used for processing QC Spec Validity Rules.
5 * This package defines and implements the procedures and datatypes
6 * required for inserting, deleting QC Spec Validity Rules.
7 * @rep:scope public
8 * @rep:product GMD
9 * @rep:lifecycle active
10 * @rep:displayname QC Spec Validity Rules package
11 * @rep:compatibility S
12 * @rep:category BUSINESS_ENTITY GMD_QC_SPEC_VR
13 */
14
15
16
17 /* A Table type Definition */
18
19 TYPE INVENTORY_SPEC_VRS_TBL IS TABLE OF GMD_INVENTORY_SPEC_VRS%ROWTYPE
20 INDEX BY BINARY_INTEGER;
21
22 TYPE WIP_SPEC_VRS_TBL IS TABLE OF GMD_WIP_SPEC_VRS%ROWTYPE
23 INDEX BY BINARY_INTEGER;
24
25 TYPE CUSTOMER_SPEC_VRS_TBL IS TABLE OF GMD_CUSTOMER_SPEC_VRS%ROWTYPE
26 INDEX BY BINARY_INTEGER;
27
28 TYPE SUPPLIER_SPEC_VRS_TBL IS TABLE OF GMD_SUPPLIER_SPEC_VRS%ROWTYPE
29 INDEX BY BINARY_INTEGER;
30
31 TYPE MONITORING_SPEC_VRS_TBL IS TABLE OF GMD_MONITORING_SPEC_VRS%ROWTYPE
32 INDEX BY BINARY_INTEGER;
33
34 /* Define Procedures And Functions : */
35
36
37 /*#
38 * Creates multiple inventory spec validity rules.
39 * Accepts a table of Inventory Spec Validity Rule definitions, validates
40 * each table entry and if found valid, inserts a corresponding row
41 * into gmd_inventory_spec_vrs.
42 * @param p_api_version API version field
43 * @param p_init_msg_list Flag to indicate if message list is initialized
44 * @param p_commit Flag to check for commit
45 * @param p_validation_level For future use
46 * @param p_inventory_spec_vrs_tbl Input table structure for Inventory Specification Validity Rule data
47 * @param p_user_name Login User Name
48 * @param x_inventory_spec_vrs_tbl Table structure containing inserted Inventory Specification Validity Rules
49 * @param x_return_status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
50 * @param x_msg_count Number of messages on message stack
51 * @param x_msg_data Actual message data on message stack
52 * @rep:scope public
53 * @rep:lifecycle active
54 * @rep:displayname Create Inventory Spec Validity Rules procedure
55 * @rep:compatibility S
56 */
57
58 PROCEDURE CREATE_INVENTORY_SPEC_VRS
59 ( p_api_version IN NUMBER
60 , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
61 , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
62 , p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL
63 , p_inventory_spec_vrs_tbl IN GMD_SPEC_VRS_PUB.inventory_spec_vrs_tbl
64 , p_user_name IN VARCHAR2
65 , x_inventory_spec_vrs_tbl OUT NOCOPY GMD_SPEC_VRS_PUB.inventory_spec_vrs_tbl
66 , x_return_status OUT NOCOPY VARCHAR2
67 , x_msg_count OUT NOCOPY NUMBER
68 , x_msg_data OUT NOCOPY VARCHAR2
69 );
70
71
72 /*#
73 * Creates multiple WIP spec validity rules.
74 * Accepts a table of WIP Spec Validity Rule definitions, validates
75 * each table entry and if found valid, inserts a corresponding row
76 * into gmd_wip_spec_vrs.
77 * @param p_api_version API version field
78 * @param p_init_msg_list Flag to indicate message list is initialized
79 * @param p_commit Flag to check for commit
80 * @param p_validation_level For future use
81 * @param p_wip_spec_vrs_tbl Input table structure for WIP Specification Validity Rule data
82 * @param p_user_name Login User Name
83 * @param x_wip_spec_vrs_tbl Table structure containing inserted WIP Specification Validity Rules
84 * @param x_return_status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
85 * @param x_msg_count Number of messages on message stack
86 * @param x_msg_data Actual message data on message stack
87 * @rep:scope public
88 * @rep:lifecycle active
89 * @rep:displayname Create WIP Spec Validity Vules procedure
90 * @rep:compatibility S
91 */
92
93 PROCEDURE CREATE_WIP_SPEC_VRS
94 ( p_api_version IN NUMBER
95 , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
96 , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
97 , p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL
98 , p_wip_spec_vrs_tbl IN GMD_SPEC_VRS_PUB.wip_spec_vrs_tbl
99 , p_user_name IN VARCHAR2
100 , x_wip_spec_vrs_tbl OUT NOCOPY GMD_SPEC_VRS_PUB.wip_spec_vrs_tbl
101 , x_return_status OUT NOCOPY VARCHAR2
102 , x_msg_count OUT NOCOPY NUMBER
103 , x_msg_data OUT NOCOPY VARCHAR2
104 );
105
106 /*#
107 * Inserts multiple customer spec validity rules.
108 * Accepts a table of Customer Spec Validity Rule definitions, validates
109 * each table entry and if found valid, inserts a corresponding row
110 * into gmd_customer_spec_vrs.
111 * @param p_api_version API version field
112 * @param p_init_msg_list Flag to indicate message list is initialized
113 * @param p_commit Flag to check for commit
114 * @param p_validation_level For future use
115 * @param p_customer_spec_vrs_tbl Input table structure for Customer Specification Validity Rule data
116 * @param p_user_name Login User Name
117 * @param x_customer_spec_vrs_tbl Table structure containing inserted Customer Specification Validity Rules
118 * @param x_return_status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
119 * @param x_msg_count Number of messages on message stack
120 * @param x_msg_data Actual message data on message stack
121 * @rep:scope public
122 * @rep:lifecycle active
123 * @rep:displayname Create Customer Spec Validity Rules procedure
124 * @rep:compatibility S
125 */
126
127 PROCEDURE CREATE_CUSTOMER_SPEC_VRS
128 ( p_api_version IN NUMBER
129 , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
130 , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
131 , p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL
132 , p_customer_spec_vrs_tbl IN GMD_SPEC_VRS_PUB.customer_spec_vrs_tbl
133 , p_user_name IN VARCHAR2
134 , x_customer_spec_vrs_tbl OUT NOCOPY GMD_SPEC_VRS_PUB.customer_spec_vrs_tbl
135 , x_return_status OUT NOCOPY VARCHAR2
136 , x_msg_count OUT NOCOPY NUMBER
137 , x_msg_data OUT NOCOPY VARCHAR2
138 );
139
140
141 /*#
142 * Creates multiple supplier spec validity rules.
143 * Accepts a table of Supplier Spec Validity Rule definitions, validates
144 * each table entry and if found valid, inserts a corresponding row
145 * into gmd_supplier_spec_vrs.
146 * @param p_api_version API version field
147 * @param p_init_msg_list Flag to indicate message list is initialized
148 * @param p_commit Flag to check for commit
149 * @param p_validation_level For future use
150 * @param p_supplier_spec_vrs_tbl Input table structure for Supplier Specification Validity Rule data
151 * @param p_user_name Login User Name
152 * @param x_supplier_spec_vrs_tbl Table structure containing inserted Customer Specification Validity Rules
153 * @param x_return_status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
154 * @param x_msg_count Number of messages on message stack
155 * @param x_msg_data Actual message data on message stack
156 * @rep:scope public
157 * @rep:lifecycle active
158 * @rep:displayname Create Supplier Spec Validity Rules procedure
159 * @rep:compatibility S
160 */
161
162 PROCEDURE CREATE_SUPPLIER_SPEC_VRS
163 ( p_api_version IN NUMBER
164 , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
165 , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
166 , p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL
167 , p_supplier_spec_vrs_tbl IN GMD_SPEC_VRS_PUB.supplier_spec_vrs_tbl
168 , p_user_name IN VARCHAR2
169 , x_supplier_spec_vrs_tbl OUT NOCOPY GMD_SPEC_VRS_PUB.supplier_spec_vrs_tbl
170 , x_return_status OUT NOCOPY VARCHAR2
171 , x_msg_count OUT NOCOPY NUMBER
172 , x_msg_data OUT NOCOPY VARCHAR2
173 );
174
175 /*#
176 * Creates multiple monitoring spec validity rules.
177 * Accepts a table of Monitoring Spec Validity Rule definitions, validates
178 * each table entry and if found valid, inserts a corresponding row
179 * into gmd_monitoring_spec_vrs.
180 * @param p_api_version API version field
181 * @param p_init_msg_list Flag to indicate message list is initialized
182 * @param p_commit Flag to check for commit
183 * @param p_validation_level For future use
184 * @param p_monitoring_spec_vrs_tbl Input table structure for Monitoring Specification Validity Rule data
185 * @param p_user_name Login User Name
186 * @param x_monitoring_spec_vrs_tbl Table structure containing inserted Monitoring Specification Validity Rules
187 * @param x_return_status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
188 * @param x_msg_count Number of messages on message stack
189 * @param x_msg_data Actual message data on message stack
190 * @rep:scope public
191 * @rep:lifecycle active
192 * @rep:displayname Create Monitoring Spec Validity Rules procedure
193 * @rep:compatibility S
194 */
195
196 PROCEDURE CREATE_MONITORING_SPEC_VRS
197 ( p_api_version IN NUMBER
198 , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
199 , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
200 , p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL
201 , p_monitoring_spec_vrs_tbl IN GMD_SPEC_VRS_PUB.monitoring_spec_vrs_tbl
202 , p_user_name IN VARCHAR2
203 , x_monitoring_spec_vrs_tbl OUT NOCOPY GMD_SPEC_VRS_PUB.monitoring_spec_vrs_tbl
204 , x_return_status OUT NOCOPY VARCHAR2
205 , x_msg_count OUT NOCOPY NUMBER
206 , x_msg_data OUT NOCOPY VARCHAR2
207 );
208
209
210 /*#
211 * Deletes multiple inventory spec validity rules.
212 * Accepts a table of Inventory Spec Validity Rule definitions, validates
213 * each table entry to ensure the corresponding row is not already
214 * delete marked. Where validation is successful, a logical delete.
215 * is performed setting delete_mark=1.
216 * @param p_api_version API version field
217 * @param p_init_msg_list Flag to indicate message list is initialized
218 * @param p_commit Flag to check for commit
219 * @param p_validation_level For future use
220 * @param p_inventory_spec_vrs_tbl Input table structure for Inventory Specification Validity Rule data
221 * @param p_user_name Login User Name
222 * @param x_deleted_rows Number of rows deleted
223 * @param x_return_status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
224 * @param x_msg_count Number of messages on message stack
225 * @param x_msg_data Actual message data on message stack
226 * @rep:scope public
227 * @rep:lifecycle active
228 * @rep:displayname Delete Inventory Specification Validity Rules procedure
229 * @rep:compatibility S
230 */
231
232 PROCEDURE DELETE_INVENTORY_SPEC_VRS
233 ( p_api_version IN NUMBER
234 , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
235 , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
236 , p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL
237 , p_inventory_spec_vrs_tbl IN GMD_SPEC_VRS_PUB.inventory_spec_vrs_tbl
238 , p_user_name IN VARCHAR2 DEFAULT NULL
239 , x_deleted_rows OUT NOCOPY NUMBER
240 , x_return_status OUT NOCOPY VARCHAR2
241 , x_msg_count OUT NOCOPY NUMBER
242 , x_msg_data OUT NOCOPY VARCHAR2
243 );
244
245
246 /*#
247 * Deletes multiple WIP spec validity rules.
248 * Accepts a table of WIP Spec Validity Rule definitions, validates
249 * each table entry to ensure the corresponding row is not already
250 * delete marked. Where validation is successful, a logical delete.
251 * is performed setting delete_mark=1.
252 * @param p_api_version API version field
253 * @param p_init_msg_list Flag to indicate message list is initialized
254 * @param p_commit Flag to check for commit
255 * @param p_validation_level For future use
256 * @param p_wip_spec_vrs_tbl Input table structure for WIP Specification Validity Rule data
257 * @param p_user_name Login User Name
258 * @param x_deleted_rows Number of rows deleted
259 * @param x_return_status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
260 * @param x_msg_count Number of messages on message stack
261 * @param x_msg_data Actual message data on message stack
262 * @rep:scope public
263 * @rep:lifecycle active
264 * @rep:displayname Delete WIP Specification Validity Rules procedure
265 * @rep:compatibility S
266 */
267
268 PROCEDURE DELETE_WIP_SPEC_VRS
269 ( p_api_version IN NUMBER
270 , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
271 , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
272 , p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL
273 , p_wip_spec_vrs_tbl IN GMD_SPEC_VRS_PUB.wip_spec_vrs_tbl
274 , p_user_name IN VARCHAR2 DEFAULT NULL
275 , x_deleted_rows OUT NOCOPY NUMBER
276 , x_return_status OUT NOCOPY VARCHAR2
277 , x_msg_count OUT NOCOPY NUMBER
278 , x_msg_data OUT NOCOPY VARCHAR2
279 );
280
281
282 /*#
283 * Deletes multiple customer spec validity rules.
284 * Accepts a table of Customer Spec Validity Rule definitions, validates
285 * each table entry to ensure the corresponding row is not already
286 * marked for delete. If validation is successful, a logical delete.
287 * is performed setting delete_mark=1.
288 * @param p_api_version API version field
289 * @param p_init_msg_list Flag to indicate message list is initialized
290 * @param p_commit Flag to check for commit
291 * @param p_validation_level For future use
292 * @param p_customer_spec_vrs_tbl Input table structure for Customer Specification Validity Rule data
293 * @param p_user_name Login User Name
294 * @param x_deleted_rows Number of rows deleted
295 * @param x_return_status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
296 * @param x_msg_count Number of messages on message stack
297 * @param x_msg_data Actual message data on message stack
298 * @rep:scope public
299 * @rep:lifecycle active
300 * @rep:displayname Delete Customer Specification Validity Rules procedure
301 * @rep:compatibility S
302 */
303
304 PROCEDURE DELETE_CUSTOMER_SPEC_VRS
305 ( p_api_version IN NUMBER
306 , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
307 , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
308 , p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL
309 , p_customer_spec_vrs_tbl IN GMD_SPEC_VRS_PUB.customer_spec_vrs_tbl
310 , p_user_name IN VARCHAR2 DEFAULT NULL
311 , x_deleted_rows OUT NOCOPY NUMBER
312 , x_return_status OUT NOCOPY VARCHAR2
313 , x_msg_count OUT NOCOPY NUMBER
314 , x_msg_data OUT NOCOPY VARCHAR2
315 );
316
317
318
319
320 /*#
321 * Deletes multiple supplier spec validity rules.
322 * Accepts a table of Supplier Spec Validity Rule definitions, validates
323 * each table entry to ensure the corresponding row is not already
324 * delete marked. Where validation is successful, a logical delete.
325 * is performed setting delete_mark=1.
329 * @param p_validation_level For future use
326 * @param p_api_version API version field
327 * @param p_init_msg_list Flag to indicate message list is initialized
328 * @param p_commit Flag to check for commit
330 * @param p_supplier_spec_vrs_tbl Input table structure for Supplier Specification Validity Rule data
331 * @param p_user_name Login User Name
332 * @param x_deleted_rows Number of rows deleted
333 * @param x_return_status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
334 * @param x_msg_count Number of messages on message stack
335 * @param x_msg_data Actual message data on message stack
336 * @rep:scope public
337 * @rep:lifecycle active
338 * @rep:displayname Delete Supplier Specification Validity Rules procedure
339 * @rep:compatibility S
340 */
341
342 PROCEDURE DELETE_SUPPLIER_SPEC_VRS
343 ( p_api_version IN NUMBER
344 , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
345 , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
346 , p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL
347 , p_supplier_spec_vrs_tbl IN GMD_SPEC_VRS_PUB.supplier_spec_vrs_tbl
348 , p_user_name IN VARCHAR2 DEFAULT NULL
349 , x_deleted_rows OUT NOCOPY NUMBER
350 , x_return_status OUT NOCOPY VARCHAR2
351 , x_msg_count OUT NOCOPY NUMBER
352 , x_msg_data OUT NOCOPY VARCHAR2
353 );
354
355
356 /*#
357 * Deletes multiple monitoring spec validity rules.
358 * Accepts a table of Monitoring Spec Validity Rule definitions. Validates
359 * each table entry to ensure the corresponding row is not already
360 * delete marked. Where validation is successful, a logical delete.
361 * is performed setting delete_mark=1.
362 * @param p_api_version API version field
363 * @param p_init_msg_list Flag to indicate message list is initialized
364 * @param p_commit Flag to check for commit
365 * @param p_validation_level For future use
366 * @param p_monitoring_spec_vrs_tbl Input table structure for Monitoring Specification Validity Rule data
367 * @param p_user_name Login User Name
368 * @param x_deleted_rows Number of rows deleted
369 * @param x_return_status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
370 * @param x_msg_count Number of messages on message stack
371 * @param x_msg_data Actual message data on message stack
372 * @rep:scope public
373 * @rep:lifecycle active
374 * @rep:displayname Delete Monitoring Specification Validity Rules procedure
375 * @rep:compatibility S
376 */
377
378 PROCEDURE DELETE_MONITORING_SPEC_VRS
379 ( p_api_version IN NUMBER
380 , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
381 , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
382 , p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL
383 , p_monitoring_spec_vrs_tbl IN GMD_SPEC_VRS_PUB.MONITORING_spec_vrs_tbl
384 , p_user_name IN VARCHAR2 DEFAULT NULL
385 , x_deleted_rows OUT NOCOPY NUMBER
386 , x_return_status OUT NOCOPY VARCHAR2
387 , x_msg_count OUT NOCOPY NUMBER
388 , x_msg_data OUT NOCOPY VARCHAR2
389 );
390
391 END GMD_SPEC_VRS_PUB;