eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMD_SPEC_VRS_PUB dependencies on GMD_SPEC_VRS_PUB

Line 1: PACKAGE BODY GMD_SPEC_VRS_PUB AS

1: PACKAGE BODY GMD_SPEC_VRS_PUB AS
2: /* $Header: GMDPSVRB.pls 120.0.12020000.2 2012/07/17 10:08:25 mtou ship $
3: +=========================================================================+
4: | Copyright (c) 2000 Oracle Corporation |
5: | TVP, Reading, England |

Line 9: | Package Name : GMD_SPEC_VRS_PUB |

5: | TVP, Reading, England |
6: | All rights reserved |
7: +=========================================================================+
8: | File Name : GMDPSVRB.pls |
9: | Package Name : GMD_SPEC_VRS_PUB |
10: | Type : PUBLIC |
11: | |
12: | Contents: |
13: | |

Line 25: API Name : GMD_SPEC_VRS_PUB

21: | 02-May-2005 Convergence Changes |
22: | 01-JUNE-2012 P A Lowe bug 14103219 |
23: | relax defaulting of SVR status to 100 if its passed by user |
24: +=========================================================================+
25: API Name : GMD_SPEC_VRS_PUB
26: Type : Public
27: Function : This package contains public procedures used to process
28: spec validity rules.
29: Pre-reqs : N/A

Line 44: G_PKG_NAME CONSTANT VARCHAR2(30):='GMD_SPEC_VRS_PUB';

40:
41:
42: /* Global variables */
43:
44: G_PKG_NAME CONSTANT VARCHAR2(30):='GMD_SPEC_VRS_PUB';
45:
46: /*
47: +=========================================================================+
48: | Name : CREATE_INVENTORY_SPEC_VRS |

Line 72: , p_inventory_spec_vrs_tbl IN GMD_SPEC_VRS_PUB.inventory_spec_vrs_tbl

68: ( p_api_version IN NUMBER
69: , p_init_msg_list IN VARCHAR2
70: , p_commit IN VARCHAR2
71: , p_validation_level IN VARCHAR2
72: , p_inventory_spec_vrs_tbl IN GMD_SPEC_VRS_PUB.inventory_spec_vrs_tbl
73: , p_user_name IN VARCHAR2
74: , x_inventory_spec_vrs_tbl OUT NOCOPY GMD_SPEC_VRS_PUB.inventory_spec_vrs_tbl
75: , x_return_status OUT NOCOPY VARCHAR2
76: , x_msg_count OUT NOCOPY NUMBER

Line 74: , x_inventory_spec_vrs_tbl OUT NOCOPY GMD_SPEC_VRS_PUB.inventory_spec_vrs_tbl

70: , p_commit IN VARCHAR2
71: , p_validation_level IN VARCHAR2
72: , p_inventory_spec_vrs_tbl IN GMD_SPEC_VRS_PUB.inventory_spec_vrs_tbl
73: , p_user_name IN VARCHAR2
74: , x_inventory_spec_vrs_tbl OUT NOCOPY GMD_SPEC_VRS_PUB.inventory_spec_vrs_tbl
75: , x_return_status OUT NOCOPY VARCHAR2
76: , x_msg_count OUT NOCOPY NUMBER
77: , x_msg_data OUT NOCOPY VARCHAR2
78: )

Line 88: l_inventory_spec_vrs_tbl GMD_SPEC_VRS_PUB.inventory_spec_vrs_tbl;

84: l_return_status VARCHAR2(1):=FND_API.G_RET_STS_SUCCESS;
85: l_spec GMD_SPECIFICATIONS%ROWTYPE;
86: l_inventory_spec_vrs GMD_INVENTORY_SPEC_VRS%ROWTYPE;
87: l_inventory_spec_vrs_out GMD_INVENTORY_SPEC_VRS%ROWTYPE;
88: l_inventory_spec_vrs_tbl GMD_SPEC_VRS_PUB.inventory_spec_vrs_tbl;
89: l_rowid ROWID;
90: l_user_id NUMBER(15);
91:
92: BEGIN

Line 252: , p_wip_spec_vrs_tbl IN GMD_SPEC_VRS_PUB.wip_spec_vrs_tbl

248: ( p_api_version IN NUMBER
249: , p_init_msg_list IN VARCHAR2
250: , p_commit IN VARCHAR2
251: , p_validation_level IN VARCHAR2
252: , p_wip_spec_vrs_tbl IN GMD_SPEC_VRS_PUB.wip_spec_vrs_tbl
253: , p_user_name IN VARCHAR2
254: , x_wip_spec_vrs_tbl OUT NOCOPY GMD_SPEC_VRS_PUB.wip_spec_vrs_tbl
255: , x_return_status OUT NOCOPY VARCHAR2
256: , x_msg_count OUT NOCOPY NUMBER

Line 254: , x_wip_spec_vrs_tbl OUT NOCOPY GMD_SPEC_VRS_PUB.wip_spec_vrs_tbl

250: , p_commit IN VARCHAR2
251: , p_validation_level IN VARCHAR2
252: , p_wip_spec_vrs_tbl IN GMD_SPEC_VRS_PUB.wip_spec_vrs_tbl
253: , p_user_name IN VARCHAR2
254: , x_wip_spec_vrs_tbl OUT NOCOPY GMD_SPEC_VRS_PUB.wip_spec_vrs_tbl
255: , x_return_status OUT NOCOPY VARCHAR2
256: , x_msg_count OUT NOCOPY NUMBER
257: , x_msg_data OUT NOCOPY VARCHAR2
258: )

Line 268: l_wip_spec_vrs_tbl GMD_SPEC_VRS_PUB.wip_spec_vrs_tbl;

264: l_return_status VARCHAR2(1):=FND_API.G_RET_STS_SUCCESS;
265: l_spec GMD_SPECIFICATIONS%ROWTYPE;
266: l_wip_spec_vrs GMD_WIP_SPEC_VRS%ROWTYPE;
267: l_wip_spec_vrs_out GMD_WIP_SPEC_VRS%ROWTYPE;
268: l_wip_spec_vrs_tbl GMD_SPEC_VRS_PUB.wip_spec_vrs_tbl;
269: l_rowid ROWID;
270: l_user_id NUMBER(15);
271:
272: BEGIN

Line 431: , p_customer_spec_vrs_tbl IN GMD_SPEC_VRS_PUB.customer_spec_vrs_tbl

427: ( p_api_version IN NUMBER
428: , p_init_msg_list IN VARCHAR2
429: , p_commit IN VARCHAR2
430: , p_validation_level IN VARCHAR2
431: , p_customer_spec_vrs_tbl IN GMD_SPEC_VRS_PUB.customer_spec_vrs_tbl
432: , p_user_name IN VARCHAR2
433: , x_customer_spec_vrs_tbl OUT NOCOPY GMD_SPEC_VRS_PUB.customer_spec_vrs_tbl
434: , x_return_status OUT NOCOPY VARCHAR2
435: , x_msg_count OUT NOCOPY NUMBER

Line 433: , x_customer_spec_vrs_tbl OUT NOCOPY GMD_SPEC_VRS_PUB.customer_spec_vrs_tbl

429: , p_commit IN VARCHAR2
430: , p_validation_level IN VARCHAR2
431: , p_customer_spec_vrs_tbl IN GMD_SPEC_VRS_PUB.customer_spec_vrs_tbl
432: , p_user_name IN VARCHAR2
433: , x_customer_spec_vrs_tbl OUT NOCOPY GMD_SPEC_VRS_PUB.customer_spec_vrs_tbl
434: , x_return_status OUT NOCOPY VARCHAR2
435: , x_msg_count OUT NOCOPY NUMBER
436: , x_msg_data OUT NOCOPY VARCHAR2
437: )

Line 446: l_customer_spec_vrs_tbl GMD_SPEC_VRS_PUB.customer_spec_vrs_tbl;

442: l_msg_data VARCHAR2(2000);
443: l_return_status VARCHAR2(1):=FND_API.G_RET_STS_SUCCESS;
444: l_customer_spec_vrs GMD_CUSTOMER_SPEC_VRS%ROWTYPE;
445: l_customer_spec_vrs_out GMD_CUSTOMER_SPEC_VRS%ROWTYPE;
446: l_customer_spec_vrs_tbl GMD_SPEC_VRS_PUB.customer_spec_vrs_tbl;
447: l_user_id NUMBER(15);
448:
449: BEGIN
450:

Line 604: , p_supplier_spec_vrs_tbl IN GMD_SPEC_VRS_PUB.supplier_spec_vrs_tbl

600: ( p_api_version IN NUMBER
601: , p_init_msg_list IN VARCHAR2
602: , p_commit IN VARCHAR2
603: , p_validation_level IN VARCHAR2
604: , p_supplier_spec_vrs_tbl IN GMD_SPEC_VRS_PUB.supplier_spec_vrs_tbl
605: , p_user_name IN VARCHAR2
606: , x_supplier_spec_vrs_tbl OUT NOCOPY GMD_SPEC_VRS_PUB.supplier_spec_vrs_tbl
607: , x_return_status OUT NOCOPY VARCHAR2
608: , x_msg_count OUT NOCOPY NUMBER

Line 606: , x_supplier_spec_vrs_tbl OUT NOCOPY GMD_SPEC_VRS_PUB.supplier_spec_vrs_tbl

602: , p_commit IN VARCHAR2
603: , p_validation_level IN VARCHAR2
604: , p_supplier_spec_vrs_tbl IN GMD_SPEC_VRS_PUB.supplier_spec_vrs_tbl
605: , p_user_name IN VARCHAR2
606: , x_supplier_spec_vrs_tbl OUT NOCOPY GMD_SPEC_VRS_PUB.supplier_spec_vrs_tbl
607: , x_return_status OUT NOCOPY VARCHAR2
608: , x_msg_count OUT NOCOPY NUMBER
609: , x_msg_data OUT NOCOPY VARCHAR2
610: )

Line 619: l_supplier_spec_vrs_tbl GMD_SPEC_VRS_PUB.supplier_spec_vrs_tbl;

615: l_msg_data VARCHAR2(2000);
616: l_return_status VARCHAR2(1):=FND_API.G_RET_STS_SUCCESS;
617: l_supplier_spec_vrs GMD_SUPPLIER_SPEC_VRS%ROWTYPE;
618: l_supplier_spec_vrs_out GMD_SUPPLIER_SPEC_VRS%ROWTYPE;
619: l_supplier_spec_vrs_tbl GMD_SPEC_VRS_PUB.supplier_spec_vrs_tbl;
620: l_user_id NUMBER(15);
621:
622: BEGIN
623:

Line 780: , p_monitoring_spec_vrs_tbl IN GMD_SPEC_VRS_PUB.monitoring_spec_vrs_tbl

776: ( p_api_version IN NUMBER
777: , p_init_msg_list IN VARCHAR2
778: , p_commit IN VARCHAR2
779: , p_validation_level IN VARCHAR2
780: , p_monitoring_spec_vrs_tbl IN GMD_SPEC_VRS_PUB.monitoring_spec_vrs_tbl
781: , p_user_name IN VARCHAR2
782: , x_monitoring_spec_vrs_tbl OUT NOCOPY GMD_SPEC_VRS_PUB.monitoring_spec_vrs_tbl
783: , x_return_status OUT NOCOPY VARCHAR2
784: , x_msg_count OUT NOCOPY NUMBER

Line 782: , x_monitoring_spec_vrs_tbl OUT NOCOPY GMD_SPEC_VRS_PUB.monitoring_spec_vrs_tbl

778: , p_commit IN VARCHAR2
779: , p_validation_level IN VARCHAR2
780: , p_monitoring_spec_vrs_tbl IN GMD_SPEC_VRS_PUB.monitoring_spec_vrs_tbl
781: , p_user_name IN VARCHAR2
782: , x_monitoring_spec_vrs_tbl OUT NOCOPY GMD_SPEC_VRS_PUB.monitoring_spec_vrs_tbl
783: , x_return_status OUT NOCOPY VARCHAR2
784: , x_msg_count OUT NOCOPY NUMBER
785: , x_msg_data OUT NOCOPY VARCHAR2
786: )

Line 795: l_monitoring_spec_vrs_tbl GMD_SPEC_VRS_PUB.monitoring_spec_vrs_tbl;

791: l_msg_data VARCHAR2(2000);
792: l_return_status VARCHAR2(1):=FND_API.G_RET_STS_SUCCESS;
793: l_monitoring_spec_vrs GMD_MONITORING_SPEC_VRS%ROWTYPE;
794: l_monitoring_spec_vrs_out GMD_MONITORING_SPEC_VRS%ROWTYPE;
795: l_monitoring_spec_vrs_tbl GMD_SPEC_VRS_PUB.monitoring_spec_vrs_tbl;
796: l_user_id NUMBER(15);
797:
798: BEGIN
799:

Line 969: , p_inventory_spec_vrs_tbl IN GMD_SPEC_VRS_PUB.inventory_spec_vrs_tbl

965: ( p_api_version IN NUMBER
966: , p_init_msg_list IN VARCHAR2
967: , p_commit IN VARCHAR2
968: , p_validation_level IN VARCHAR2
969: , p_inventory_spec_vrs_tbl IN GMD_SPEC_VRS_PUB.inventory_spec_vrs_tbl
970: , p_user_name IN VARCHAR2
971: , x_deleted_rows OUT NOCOPY NUMBER
972: , x_return_status OUT NOCOPY VARCHAR2
973: , x_msg_count OUT NOCOPY NUMBER

Line 1186: , p_wip_spec_vrs_tbl IN GMD_SPEC_VRS_PUB.wip_spec_vrs_tbl

1182: ( p_api_version IN NUMBER
1183: , p_init_msg_list IN VARCHAR2
1184: , p_commit IN VARCHAR2
1185: , p_validation_level IN VARCHAR2
1186: , p_wip_spec_vrs_tbl IN GMD_SPEC_VRS_PUB.wip_spec_vrs_tbl
1187: , p_user_name IN VARCHAR2
1188: , x_deleted_rows OUT NOCOPY NUMBER
1189: , x_return_status OUT NOCOPY VARCHAR2
1190: , x_msg_count OUT NOCOPY NUMBER

Line 1400: , p_customer_spec_vrs_tbl IN GMD_SPEC_VRS_PUB.customer_spec_vrs_tbl

1396: ( p_api_version IN NUMBER
1397: , p_init_msg_list IN VARCHAR2
1398: , p_commit IN VARCHAR2
1399: , p_validation_level IN VARCHAR2
1400: , p_customer_spec_vrs_tbl IN GMD_SPEC_VRS_PUB.customer_spec_vrs_tbl
1401: , p_user_name IN VARCHAR2
1402: , x_deleted_rows OUT NOCOPY NUMBER
1403: , x_return_status OUT NOCOPY VARCHAR2
1404: , x_msg_count OUT NOCOPY NUMBER

Line 1614: , p_supplier_spec_vrs_tbl IN GMD_SPEC_VRS_PUB.supplier_spec_vrs_tbl

1610: ( p_api_version IN NUMBER
1611: , p_init_msg_list IN VARCHAR2
1612: , p_commit IN VARCHAR2
1613: , p_validation_level IN VARCHAR2
1614: , p_supplier_spec_vrs_tbl IN GMD_SPEC_VRS_PUB.supplier_spec_vrs_tbl
1615: , p_user_name IN VARCHAR2
1616: , x_deleted_rows OUT NOCOPY NUMBER
1617: , x_return_status OUT NOCOPY VARCHAR2
1618: , x_msg_count OUT NOCOPY NUMBER

Line 1830: , p_monitoring_spec_vrs_tbl IN GMD_SPEC_VRS_PUB.MONITORING_spec_vrs_tbl

1826: ( p_api_version IN NUMBER
1827: , p_init_msg_list IN VARCHAR2
1828: , p_commit IN VARCHAR2
1829: , p_validation_level IN VARCHAR2
1830: , p_monitoring_spec_vrs_tbl IN GMD_SPEC_VRS_PUB.MONITORING_spec_vrs_tbl
1831: , p_user_name IN VARCHAR2
1832: , x_deleted_rows OUT NOCOPY NUMBER
1833: , x_return_status OUT NOCOPY VARCHAR2
1834: , x_msg_count OUT NOCOPY NUMBER

Line 2018: END GMD_SPEC_VRS_PUB;

2014: , p_data => x_msg_data
2015: );
2016:
2017: END DELETE_MONITORING_SPEC_VRS;
2018: END GMD_SPEC_VRS_PUB;