1 PACKAGE GMD_SPEC_PUB AS
2 /* $Header: GMDPSPCS.pls 120.1 2006/10/04 11:50:30 srakrish noship $ */
3 /*#
4 * This interface is used to create and delete Specifications.
5 * This package defines and implements the procedures and datatypes
6 * required to create and delete Specifications and Specification Tests.
7 * @rep:scope public
8 * @rep:product GMD
9 * @rep:lifecycle active
10 * @rep:displayname Quality Specifications package
11 * @rep:compatibility S
12 * @rep:category BUSINESS_ENTITY GMD_QC_SPEC
13 */
14 /*
15 +=========================================================================+
16 | Copyright (c) 2000 Oracle Corporation |
17 | TVP, Reading, England |
18 | All rights reserved |
19 +=========================================================================+
20 | File Name : GMDPSPCS.pls |
21 | Package Name : GMD_Spec_PUB |
22 | Type : PUBLIC |
23 | |
24 | DESCRIPTION |
25 | This package contains public definitions for processing |
26 | QC Specifications |
27 | |
28 | |
29 | HISTORY |
30 | 03-AUG-2002 H.Verdding |
31 | |
32 +=========================================================================+
33 API Name : GMD_Spec_PUB
34 Type : Public
35 Function : This package contains public procedures used to process
36 specifications.
37 Pre-reqs : N/A
38 Parameters: Per function
39
40
41 Current Vers : 1.0
42
43 Previous Vers : 1.0
44
45 Initial Vers : 1.0
46 Notes
47 END of Notes */
48
49
50
51 /* A Table type Definition For GMD_Spec_PUB */
52
53 TYPE SPEC_TESTS_TBL IS TABLE OF GMD_SPEC_TESTS%ROWTYPE
54 INDEX BY BINARY_INTEGER;
55
56
57 TYPE INVENTORY_SPEC_VRS_TBL IS TABLE OF GMD_INVENTORY_SPEC_VRS%ROWTYPE
58 INDEX BY BINARY_INTEGER;
59
60
61 -- Define Procedures And Functions :
62 -- =================================
63
64 /*#
65 * Creates Specifications
66 * This is a PL/SQL procedure to Create Specifications.
67 * @param p_api_version API version field
68 * @param p_init_msg_list Flag to check if message list is initialized
69 * @param p_commit Flag to check for commit
70 * @param p_validation_level For Future Use
71 * @param p_spec Record Structure of Specifications
72 * @param p_spec_tests_tbl Table Structure of Specification tests
73 * @param p_user_name Login User name
74 * @param x_spec Record Structure of Specifications
75 * @param x_spec_tests_tbl Table Structure of Specification tests
76 * @param x_return_status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
77 * @param x_msg_count Number of messages on message stack
78 * @param x_msg_data Actual message data on message stack
79 * @rep:scope public
80 * @rep:lifecycle active
81 * @rep:displayname Create Specifications procedure
82 * @rep:compatibility S
83 */
84 PROCEDURE CREATE_SPEC
85 ( p_api_version IN NUMBER
86 , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
87 , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
88 , p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL
89 , p_spec IN GMD_SPECIFICATIONS%ROWTYPE
90 , p_spec_tests_tbl IN GMD_SPEC_PUB.spec_tests_tbl
91 , p_user_name IN VARCHAR2 DEFAULT NULL
92 , x_spec OUT NOCOPY GMD_SPECIFICATIONS%ROWTYPE
93 , x_spec_tests_tbl OUT NOCOPY GMD_SPEC_PUB.spec_tests_tbl
94 , x_return_status OUT NOCOPY VARCHAR2
95 , x_msg_count OUT NOCOPY NUMBER
96 , x_msg_data OUT NOCOPY VARCHAR2
97 );
98
99 /*#
100 * Deletes Specifications
101 * This is a PL/SQL procedure to Delete Specifications.
102 * @param p_api_version API version field
103 * @param p_init_msg_list Flag to check if message list is initialized
104 * @param p_commit Flag to check for commit
105 * @param p_validation_level For Future Use
106 * @param p_spec Record Structure of Specifications
107 * @param p_user_name Login User name
108 * @param x_deleted_rows Number of Specification records Deleted
109 * @param x_return_status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
110 * @param x_msg_count Number of messages on message stack
111 * @param x_msg_data Actual message data on message stack
112 * @rep:scope public
113 * @rep:lifecycle active
114 * @rep:displayname Delete Specifications procedure
115 * @rep:compatibility S
116 */
117 PROCEDURE DELETE_SPEC
118 ( p_api_version IN NUMBER
119 , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
120 , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
121 , p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL
122 , p_spec IN GMD_SPECIFICATIONS%ROWTYPE
123 , p_user_name IN VARCHAR2 DEFAULT NULL
124 , x_deleted_rows OUT NOCOPY NUMBER
125 , x_return_status OUT NOCOPY VARCHAR2
126 , x_msg_count OUT NOCOPY NUMBER
127 , x_msg_data OUT NOCOPY VARCHAR2
128 );
129
130 /*#
131 * Deletes Specification Tests
132 * This is a PL/SQL procedure to Delete Specification Tests.
133 * @param p_api_version API version field
134 * @param p_init_msg_list Flag to check if message list is initialized
135 * @param p_commit Flag to check for commit
136 * @param p_validation_level For Future Use
137 * @param p_spec_tests_tbl Table Structure of Specification Tests
138 * @param x_deleted_rows Number of Specification records Deleted
139 * @param x_return_status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
140 * @param x_msg_count Number of messages on message stack
141 * @param x_msg_data Actual message data on message stack
142 * @rep:scope public
143 * @rep:lifecycle active
144 * @rep:displayname Delete Specifications procedure
145 * @rep:compatibility S
146 */
147 PROCEDURE DELETE_SPEC_TESTS
148 ( p_api_version IN NUMBER
149 , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
150 , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
151 , p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL
152 , p_spec_tests_tbl IN GMD_SPEC_PUB.spec_tests_tbl
153 , x_deleted_rows OUT NOCOPY NUMBER
154 , x_return_status OUT NOCOPY VARCHAR2
155 , x_msg_count OUT NOCOPY NUMBER
156 , x_msg_data OUT NOCOPY VARCHAR2
157 );
158
159 END GMD_SPEC_PUB;