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 2005/05/25 19:03:59 appldev noship $
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 23: API Name : GMD_SPEC_VRS_PUB

19: | HISTORY |
20: | 03-AUG-2002 K.Y.Hunt |
21: | 02-May-2005 Convergence Changes |
22: +=========================================================================+
23: API Name : GMD_SPEC_VRS_PUB
24: Type : Public
25: Function : This package contains public procedures used to process
26: spec validity rules.
27: Pre-reqs : N/A

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

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

Line 70: , p_inventory_spec_vrs_tbl IN GMD_SPEC_VRS_PUB.inventory_spec_vrs_tbl

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

Line 72: , x_inventory_spec_vrs_tbl OUT NOCOPY GMD_SPEC_VRS_PUB.inventory_spec_vrs_tbl

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

Line 86: l_inventory_spec_vrs_tbl GMD_SPEC_VRS_PUB.inventory_spec_vrs_tbl;

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

Line 248: , p_wip_spec_vrs_tbl IN GMD_SPEC_VRS_PUB.wip_spec_vrs_tbl

244: ( p_api_version IN NUMBER
245: , p_init_msg_list IN VARCHAR2
246: , p_commit IN VARCHAR2
247: , p_validation_level IN VARCHAR2
248: , p_wip_spec_vrs_tbl IN GMD_SPEC_VRS_PUB.wip_spec_vrs_tbl
249: , p_user_name IN VARCHAR2
250: , x_wip_spec_vrs_tbl OUT NOCOPY GMD_SPEC_VRS_PUB.wip_spec_vrs_tbl
251: , x_return_status OUT NOCOPY VARCHAR2
252: , x_msg_count OUT NOCOPY NUMBER

Line 250: , x_wip_spec_vrs_tbl OUT NOCOPY GMD_SPEC_VRS_PUB.wip_spec_vrs_tbl

246: , p_commit IN VARCHAR2
247: , p_validation_level IN VARCHAR2
248: , p_wip_spec_vrs_tbl IN GMD_SPEC_VRS_PUB.wip_spec_vrs_tbl
249: , p_user_name IN VARCHAR2
250: , x_wip_spec_vrs_tbl OUT NOCOPY GMD_SPEC_VRS_PUB.wip_spec_vrs_tbl
251: , x_return_status OUT NOCOPY VARCHAR2
252: , x_msg_count OUT NOCOPY NUMBER
253: , x_msg_data OUT NOCOPY VARCHAR2
254: )

Line 264: l_wip_spec_vrs_tbl GMD_SPEC_VRS_PUB.wip_spec_vrs_tbl;

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

Line 425: , p_customer_spec_vrs_tbl IN GMD_SPEC_VRS_PUB.customer_spec_vrs_tbl

421: ( p_api_version IN NUMBER
422: , p_init_msg_list IN VARCHAR2
423: , p_commit IN VARCHAR2
424: , p_validation_level IN VARCHAR2
425: , p_customer_spec_vrs_tbl IN GMD_SPEC_VRS_PUB.customer_spec_vrs_tbl
426: , p_user_name IN VARCHAR2
427: , x_customer_spec_vrs_tbl OUT NOCOPY GMD_SPEC_VRS_PUB.customer_spec_vrs_tbl
428: , x_return_status OUT NOCOPY VARCHAR2
429: , x_msg_count OUT NOCOPY NUMBER

Line 427: , x_customer_spec_vrs_tbl OUT NOCOPY GMD_SPEC_VRS_PUB.customer_spec_vrs_tbl

423: , p_commit IN VARCHAR2
424: , p_validation_level IN VARCHAR2
425: , p_customer_spec_vrs_tbl IN GMD_SPEC_VRS_PUB.customer_spec_vrs_tbl
426: , p_user_name IN VARCHAR2
427: , x_customer_spec_vrs_tbl OUT NOCOPY GMD_SPEC_VRS_PUB.customer_spec_vrs_tbl
428: , x_return_status OUT NOCOPY VARCHAR2
429: , x_msg_count OUT NOCOPY NUMBER
430: , x_msg_data OUT NOCOPY VARCHAR2
431: )

Line 440: l_customer_spec_vrs_tbl GMD_SPEC_VRS_PUB.customer_spec_vrs_tbl;

436: l_msg_data VARCHAR2(2000);
437: l_return_status VARCHAR2(1):=FND_API.G_RET_STS_SUCCESS;
438: l_customer_spec_vrs GMD_CUSTOMER_SPEC_VRS%ROWTYPE;
439: l_customer_spec_vrs_out GMD_CUSTOMER_SPEC_VRS%ROWTYPE;
440: l_customer_spec_vrs_tbl GMD_SPEC_VRS_PUB.customer_spec_vrs_tbl;
441: l_user_id NUMBER(15);
442:
443: BEGIN
444:

Line 596: , p_supplier_spec_vrs_tbl IN GMD_SPEC_VRS_PUB.supplier_spec_vrs_tbl

592: ( p_api_version IN NUMBER
593: , p_init_msg_list IN VARCHAR2
594: , p_commit IN VARCHAR2
595: , p_validation_level IN VARCHAR2
596: , p_supplier_spec_vrs_tbl IN GMD_SPEC_VRS_PUB.supplier_spec_vrs_tbl
597: , p_user_name IN VARCHAR2
598: , x_supplier_spec_vrs_tbl OUT NOCOPY GMD_SPEC_VRS_PUB.supplier_spec_vrs_tbl
599: , x_return_status OUT NOCOPY VARCHAR2
600: , x_msg_count OUT NOCOPY NUMBER

Line 598: , x_supplier_spec_vrs_tbl OUT NOCOPY GMD_SPEC_VRS_PUB.supplier_spec_vrs_tbl

594: , p_commit IN VARCHAR2
595: , p_validation_level IN VARCHAR2
596: , p_supplier_spec_vrs_tbl IN GMD_SPEC_VRS_PUB.supplier_spec_vrs_tbl
597: , p_user_name IN VARCHAR2
598: , x_supplier_spec_vrs_tbl OUT NOCOPY GMD_SPEC_VRS_PUB.supplier_spec_vrs_tbl
599: , x_return_status OUT NOCOPY VARCHAR2
600: , x_msg_count OUT NOCOPY NUMBER
601: , x_msg_data OUT NOCOPY VARCHAR2
602: )

Line 611: l_supplier_spec_vrs_tbl GMD_SPEC_VRS_PUB.supplier_spec_vrs_tbl;

607: l_msg_data VARCHAR2(2000);
608: l_return_status VARCHAR2(1):=FND_API.G_RET_STS_SUCCESS;
609: l_supplier_spec_vrs GMD_SUPPLIER_SPEC_VRS%ROWTYPE;
610: l_supplier_spec_vrs_out GMD_SUPPLIER_SPEC_VRS%ROWTYPE;
611: l_supplier_spec_vrs_tbl GMD_SPEC_VRS_PUB.supplier_spec_vrs_tbl;
612: l_user_id NUMBER(15);
613:
614: BEGIN
615:

Line 770: , p_monitoring_spec_vrs_tbl IN GMD_SPEC_VRS_PUB.monitoring_spec_vrs_tbl

766: ( p_api_version IN NUMBER
767: , p_init_msg_list IN VARCHAR2
768: , p_commit IN VARCHAR2
769: , p_validation_level IN VARCHAR2
770: , p_monitoring_spec_vrs_tbl IN GMD_SPEC_VRS_PUB.monitoring_spec_vrs_tbl
771: , p_user_name IN VARCHAR2
772: , x_monitoring_spec_vrs_tbl OUT NOCOPY GMD_SPEC_VRS_PUB.monitoring_spec_vrs_tbl
773: , x_return_status OUT NOCOPY VARCHAR2
774: , x_msg_count OUT NOCOPY NUMBER

Line 772: , x_monitoring_spec_vrs_tbl OUT NOCOPY GMD_SPEC_VRS_PUB.monitoring_spec_vrs_tbl

768: , p_commit IN VARCHAR2
769: , p_validation_level IN VARCHAR2
770: , p_monitoring_spec_vrs_tbl IN GMD_SPEC_VRS_PUB.monitoring_spec_vrs_tbl
771: , p_user_name IN VARCHAR2
772: , x_monitoring_spec_vrs_tbl OUT NOCOPY GMD_SPEC_VRS_PUB.monitoring_spec_vrs_tbl
773: , x_return_status OUT NOCOPY VARCHAR2
774: , x_msg_count OUT NOCOPY NUMBER
775: , x_msg_data OUT NOCOPY VARCHAR2
776: )

Line 785: l_monitoring_spec_vrs_tbl GMD_SPEC_VRS_PUB.monitoring_spec_vrs_tbl;

781: l_msg_data VARCHAR2(2000);
782: l_return_status VARCHAR2(1):=FND_API.G_RET_STS_SUCCESS;
783: l_monitoring_spec_vrs GMD_MONITORING_SPEC_VRS%ROWTYPE;
784: l_monitoring_spec_vrs_out GMD_MONITORING_SPEC_VRS%ROWTYPE;
785: l_monitoring_spec_vrs_tbl GMD_SPEC_VRS_PUB.monitoring_spec_vrs_tbl;
786: l_user_id NUMBER(15);
787:
788: BEGIN
789:

Line 957: , p_inventory_spec_vrs_tbl IN GMD_SPEC_VRS_PUB.inventory_spec_vrs_tbl

953: ( p_api_version IN NUMBER
954: , p_init_msg_list IN VARCHAR2
955: , p_commit IN VARCHAR2
956: , p_validation_level IN VARCHAR2
957: , p_inventory_spec_vrs_tbl IN GMD_SPEC_VRS_PUB.inventory_spec_vrs_tbl
958: , p_user_name IN VARCHAR2
959: , x_deleted_rows OUT NOCOPY NUMBER
960: , x_return_status OUT NOCOPY VARCHAR2
961: , x_msg_count OUT NOCOPY NUMBER

Line 1174: , p_wip_spec_vrs_tbl IN GMD_SPEC_VRS_PUB.wip_spec_vrs_tbl

1170: ( p_api_version IN NUMBER
1171: , p_init_msg_list IN VARCHAR2
1172: , p_commit IN VARCHAR2
1173: , p_validation_level IN VARCHAR2
1174: , p_wip_spec_vrs_tbl IN GMD_SPEC_VRS_PUB.wip_spec_vrs_tbl
1175: , p_user_name IN VARCHAR2
1176: , x_deleted_rows OUT NOCOPY NUMBER
1177: , x_return_status OUT NOCOPY VARCHAR2
1178: , x_msg_count OUT NOCOPY NUMBER

Line 1388: , p_customer_spec_vrs_tbl IN GMD_SPEC_VRS_PUB.customer_spec_vrs_tbl

1384: ( p_api_version IN NUMBER
1385: , p_init_msg_list IN VARCHAR2
1386: , p_commit IN VARCHAR2
1387: , p_validation_level IN VARCHAR2
1388: , p_customer_spec_vrs_tbl IN GMD_SPEC_VRS_PUB.customer_spec_vrs_tbl
1389: , p_user_name IN VARCHAR2
1390: , x_deleted_rows OUT NOCOPY NUMBER
1391: , x_return_status OUT NOCOPY VARCHAR2
1392: , x_msg_count OUT NOCOPY NUMBER

Line 1602: , p_supplier_spec_vrs_tbl IN GMD_SPEC_VRS_PUB.supplier_spec_vrs_tbl

1598: ( p_api_version IN NUMBER
1599: , p_init_msg_list IN VARCHAR2
1600: , p_commit IN VARCHAR2
1601: , p_validation_level IN VARCHAR2
1602: , p_supplier_spec_vrs_tbl IN GMD_SPEC_VRS_PUB.supplier_spec_vrs_tbl
1603: , p_user_name IN VARCHAR2
1604: , x_deleted_rows OUT NOCOPY NUMBER
1605: , x_return_status OUT NOCOPY VARCHAR2
1606: , x_msg_count OUT NOCOPY NUMBER

Line 1818: , p_monitoring_spec_vrs_tbl IN GMD_SPEC_VRS_PUB.MONITORING_spec_vrs_tbl

1814: ( p_api_version IN NUMBER
1815: , p_init_msg_list IN VARCHAR2
1816: , p_commit IN VARCHAR2
1817: , p_validation_level IN VARCHAR2
1818: , p_monitoring_spec_vrs_tbl IN GMD_SPEC_VRS_PUB.MONITORING_spec_vrs_tbl
1819: , p_user_name IN VARCHAR2
1820: , x_deleted_rows OUT NOCOPY NUMBER
1821: , x_return_status OUT NOCOPY VARCHAR2
1822: , x_msg_count OUT NOCOPY NUMBER

Line 2006: END GMD_SPEC_VRS_PUB;

2002: , p_data => x_msg_data
2003: );
2004:
2005: END DELETE_MONITORING_SPEC_VRS;
2006: END GMD_SPEC_VRS_PUB;