DBA Data[Home] [Help]

APPS.GMD_SPEC_VRS_PUB dependencies on FND_API

Line 60: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

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

Line 61: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

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

Line 62: , p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL

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

Line 95: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

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

Line 96: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

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

Line 97: , p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL

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

Line 129: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

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

Line 130: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

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

Line 131: , p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL

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

Line 164: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

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

Line 165: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

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

Line 166: , p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL

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

Line 198: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

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

Line 199: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

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

Line 200: , p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL

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

Line 234: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

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

Line 235: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

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

Line 236: , p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL

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

Line 270: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

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

Line 271: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

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

Line 272: , p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL

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

Line 306: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

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

Line 307: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

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

Line 308: , p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL

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

Line 344: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

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

Line 345: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

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

Line 346: , p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL

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

Line 380: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

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

Line 381: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

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

Line 382: , p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL

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