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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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