1 PACKAGE GMD_QC_TESTS_PUB AUTHID CURRENT_USER AS
2 /* $Header: GMDPTSTS.pls 115.4 2004/04/16 09:06:52 rboddu noship $ */
3 /*#
4 * This interface is used to create and delete Test details.
5 * This package defines and implements the procedures and datatypes
6 * required to create and delete Test Headers and Test Values.
7 * @rep:scope public
8 * @rep:product GMD
9 * @rep:lifecycle active
10 * @rep:displayname Quality Tests package
11 * @rep:compatibility S
12 * @rep:category BUSINESS_ENTITY GMD_QC_TESTS_PUB
13 */
14
15 /* +=========================================================================+
16 | Copyright (c) 2000 Oracle Corporation |
17 | TVP, Reading, England |
18 | All rights reserved |
19 +=========================================================================+
20 | FILENAME |
21 | GMDPTSTS.pls |
22 | |
23 | DESCRIPTION |
24 | This package contains public definitions For processing |
25 | QC TESTS |
26
27 | |
28 | |
29 | HISTORY |
30 | 23-JUL-2002 H.Verdding |
31 | |
32 +=========================================================================+
33 API Name : GMD_QC_TESTS_PUB
34 Type : Public
35 Function : This package contains public procedures for processing QC TESTS
36 Pre-reqs : N/A
37 Parameters: Per function
38
39
40 Current Vers : 1.0
41
42 Previous Vers : 1.0
43
44 Initial Vers : 1.0
45 Notes
46 */
47
48
49
50 /* A Table type Definition For QC TESTS PUB */
51
52 TYPE QC_TEST_VALUES_TBL IS TABLE OF GMD_QC_TEST_VALUES%ROWTYPE
53 INDEX BY BINARY_INTEGER;
54
55 TYPE QC_CUST_TESTS_TBL IS TABLE OF GMD_CUSTOMER_TESTS%ROWTYPE
56 INDEX BY BINARY_INTEGER;
57
58
59
60 /* Define Procedures And Functions : */
61
62 /*#
63 * Creates Test Header and Test Values
64 * This is a PL/SQL procedure to create Test Header and Test Values.
65 * @param p_api_version API version field
66 * @param p_init_msg_list Flag to check if message list initialized
67 * @param p_commit to check for commit
68 * @param p_validation_level For Future use
69 * @param p_qc_tests_rec Record structure of Test Headers
70 * @param p_qc_test_values_tbl Table structure of Test Values
71 * @param p_qc_cust_tests_tbl Table structure of Customer Tests
72 * @param p_user_name Login User Name
73 * @param x_qc_tests_rec record structure of Test Headers
74 * @param x_qc_test_values_tbl Table structure of Test Values
75 * @param x_qc_cust_tests_tbl Table structure of Customer 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 Tests procedure
82 * @rep:compatibility S
83 */
84 PROCEDURE CREATE_TESTS
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 NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
89 , p_qc_tests_rec IN GMD_QC_TESTS%ROWTYPE
90 , p_qc_test_values_tbl IN GMD_QC_TESTS_PUB.qc_test_values_tbl
91 , p_qc_cust_tests_tbl IN GMD_QC_TESTS_PUB.qc_cust_tests_tbl
92 , p_user_name IN VARCHAR2
93 , x_qc_tests_rec OUT NOCOPY GMD_QC_TESTS%ROWTYPE
94 , x_qc_test_values_tbl OUT NOCOPY GMD_QC_TESTS_PUB.qc_test_values_tbl
95 , x_qc_cust_tests_tbl OUT NOCOPY GMD_QC_TESTS_PUB.qc_cust_tests_tbl
96 , x_return_status OUT NOCOPY VARCHAR2
97 , x_msg_count OUT NOCOPY NUMBER
98 , x_msg_data OUT NOCOPY VARCHAR2
99 );
100
101 /*#
102 * Deletes Test Headers
103 * This is a PL/SQL procedure to Delete Test Headers.
104 * @param p_api_version API version field
105 * @param p_init_msg_list Flag to check if message list initialized
106 * @param p_commit to check for commit
107 * @param p_validation_level For Future Use
108 * @param p_qc_tests_rec record structure of Test Headers
109 * @param p_user_name Login User name
110 * @param x_return_status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
111 * @param x_msg_count Number of messages on message stack
112 * @param x_msg_data Actual message data on message stack
113 * @rep:scope public
114 * @rep:lifecycle active
115 * @rep:displayname Delete Test Headers procedure
116 * @rep:compatibility S
117 */
118 PROCEDURE DELETE_TEST_HEADERS
119 ( p_api_version IN NUMBER
120 , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
121 , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
122 , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
123 , p_qc_tests_rec IN GMD_QC_TESTS%ROWTYPE
124 , p_user_name IN VARCHAR2
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 Test Values
132 * This is a PL/SQL procedure to Delete Test Values.
133 * @param p_api_version API version field
134 * @param p_init_msg_list Flag to check if message list initialized
135 * @param p_commit to check for commit
136 * @param p_validation_level For Future Use
137 * @param p_qc_test_values_tbl Table structure of Test Values
138 * @param x_deleted_rows Number of Test Value 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 Test Values procedure
145 * @rep:compatibility S
146 */
147 PROCEDURE DELETE_TEST_VALUES
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 NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
152 , p_qc_test_values_tbl IN GMD_QC_TESTS_PUB.qc_test_values_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 /*#
160 * Deletes Test Customer Display Details
161 * This is a PL/SQL procedure to Delete Test Customer Display Details.
162 * @param p_api_version API version field
163 * @param p_init_msg_list Flag to check if message list initialized
164 * @param p_commit to check for commit
165 * @param p_validation_level For Future Use
166 * @param p_qc_cust_tests_tbl Table structure of Test Customer Display
167 * @param x_deleted_rows Number of Test Customer Display records Deleted
168 * @param x_return_status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
169 * @param x_msg_count Number of messages on message stack
170 * @param x_msg_data Actual message data on message stack
171 * @rep:scope public
172 * @rep:lifecycle active
173 * @rep:displayname Delete Test Customer Display Details procedure
174 * @rep:compatibility S
175 */
176 PROCEDURE DELETE_CUSTOMER_TESTS
177 ( p_api_version IN NUMBER
178 , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
179 , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
180 , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
181 , p_qc_cust_tests_tbl IN GMD_QC_TESTS_PUB.qc_cust_tests_tbl
182 , x_deleted_rows OUT NOCOPY NUMBER
183 , x_return_status OUT NOCOPY VARCHAR2
184 , x_msg_count OUT NOCOPY NUMBER
185 , x_msg_data OUT NOCOPY VARCHAR2
186 );
187
188
189 END GMD_QC_TESTS_PUB;