[Home] [Help]
PACKAGE: APPS.GMD_SAMPLES_PUB
Source
1 PACKAGE GMD_SAMPLES_PUB AS
2 /* $Header: GMDPSMPS.pls 120.3.12010000.1 2008/07/24 09:57:24 appldev ship $*/
3 /*#
4 * This interface is used to create, delete, and validate samples.
5 * This package defines and implements the procedures required
6 * to create, delete, and validate samples.
7 * @rep:scope public
8 * @rep:product GMD
9 * @rep:lifecycle active
10 * @rep:displayname GMD Samples Package
11 * @rep:compatibility S
12 * @rep:category BUSINESS_ENTITY GMD_QC_SAMPLES
13 */
14
15
16
17 /* Define Procedures And Functions : */
18
19 /*#
20 * Creates samples
21 * @param p_api_version API version field
22 * @param p_init_msg_list Flag to check if message list intialized
23 * @param p_commit Flag to check for commit
24 * @param p_validation_level For future use
25 * @param p_qc_samples_rec Record structure for samples - input
26 * @param p_user_name Login User name
27 * @param p_find_matching_spec Flag to ensure that sampling event has spec associated
28 * @param p_grade Grade
29 * @param x_qc_samples_rec Record structure for samples - output
30 * @param x_sampling_events_rec Record structure for sampling events
31 * @param x_sample_spec_disp Record structure for Sample Spec Disposition
32 * @param x_event_spec_disp_rec Record structure for Event Spec Disposition
33 * @param x_results_tab Table structure for results
34 * @param x_spec_results_tab Table structure for Spec results
35 * @param x_return_status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
36 * @param x_msg_count Number of messages on message stack
37 * @param x_msg_data Actual message data on message stack
38 * @rep:scope public
39 * @rep:lifecycle active
40 * @rep:displayname Create Samples
41 * @rep:compatibility S
42 */
43
44 PROCEDURE CREATE_SAMPLES
45 ( p_api_version IN NUMBER
46 , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
47 , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
48 , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
49 , p_qc_samples_rec IN GMD_SAMPLES%ROWTYPE
50 , p_user_name IN VARCHAR2
51 , p_find_matching_spec IN VARCHAR2 DEFAULT 'N'
52 , p_grade IN VARCHAR2 DEFAULT NULL --3431884
53 , x_qc_samples_rec OUT NOCOPY GMD_SAMPLES%ROWTYPE
54 , x_sampling_events_rec OUT NOCOPY GMD_SAMPLING_EVENTS%ROWTYPE
55 , x_sample_spec_disp OUT NOCOPY GMD_SAMPLE_SPEC_DISP%ROWTYPE
56 , x_event_spec_disp_rec OUT NOCOPY GMD_EVENT_SPEC_DISP%ROWTYPE
57 , x_results_tab OUT NOCOPY GMD_API_PUB.gmd_results_tab
58 , x_spec_results_tab OUT NOCOPY GMD_API_PUB.gmd_spec_results_tab
59 , x_return_status OUT NOCOPY VARCHAR2
60 , x_msg_count OUT NOCOPY NUMBER
61 , x_msg_data OUT NOCOPY VARCHAR2
62 );
63
64
65 /*# finds if the specification is matching
66 * @param p_samples_rec Record structure for Samples
67 * @param p_grade Grade
68 * @param x_spec_id Specification ID
69 * @param x_spec_type Specification type
70 * @param x_spec_vr_id Specification Validity Rule ID
71 * @param x_return_status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
72 * @param x_msg_data Actual message data on message stack
73 * @return returns true if a matching specification is found
74 * @rep:scope public
75 * @rep:lifecycle active
76 * @rep:displayname Find Matching Specifications
77 * @rep:compatibility S
78 */
79
80 FUNCTION FIND_MATCHING_SPEC
81 ( p_samples_rec IN GMD_SAMPLES%ROWTYPE,
82 p_grade IN VARCHAR2 DEFAULT NULL, -- 3431884
83 x_spec_id OUT NOCOPY NUMBER,
84 x_spec_type OUT NOCOPY VARCHAR2,
85 x_spec_vr_id OUT NOCOPY NUMBER,
86 x_return_status OUT NOCOPY VARCHAR2,
87 x_msg_data OUT NOCOPY VARCHAR2
88
89 ) RETURN BOOLEAN;
90
91
92 /*#
93 * Deletes samples
94 * @param p_api_version API version field
95 * @param p_init_msg_list Flag to check if message list is intialized
96 * @param p_commit Flag to check for commit
97 * @param p_validation_level For future use
98 * @param p_qc_samples_rec Record structure for Samples
99 * @param p_user_name Login User name
100 * @param x_return_status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
101 * @param x_msg_count Number of messages on message stack
102 * @param x_msg_data Actual message data on message stack
103 * @rep:scope public
104 * @rep:lifecycle active
105 * @rep:displayname Delete Samples
106 * @rep:compatibility S
107 */
108
109 PROCEDURE DELETE_SAMPLES
110 ( p_api_version IN NUMBER
111 , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
112 , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
113 , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
114 , p_qc_samples_rec IN GMD_SAMPLES%ROWTYPE
115 , p_user_name IN VARCHAR2
116 , x_return_status OUT NOCOPY VARCHAR2
117 , x_msg_count OUT NOCOPY NUMBER
118 , x_msg_data OUT NOCOPY VARCHAR2
119 );
120
121 /*#
122 * Validates Item controls
123 * @param p_sample_rec Record structure for Input Samples
124 * @param x_sample_rec Record structure for Output Samples
125 * @param p_grade Grade
126 * @param x_return_status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
127 * @rep:scope public
128 * @rep:lifecycle active
129 * @rep:displayname Validate Item controls
130 * @rep:compatibility S
131 */
132
133
134 PROCEDURE VALIDATE_ITEM_CONTROLS
135 ( p_sample_rec IN GMD_SAMPLES%ROWTYPE,
136 p_grade IN VARCHAR2,
137 x_sample_rec OUT NOCOPY GMD_SAMPLES%ROWTYPE,
138 x_return_status OUT NOCOPY VARCHAR2
139 );
140
141 /*#
142 * Validates Inventory sample
143 * @param p_sample_rec Record structure for samples
144 * @param p_locator_control Locator is controlled or not
145 * @param x_return_status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
146 * @rep:scope public
147 * @rep:lifecycle active
148 * @rep:displayname Validate Inventory sample
149 * @rep:compatibility S
150 */
151
152 PROCEDURE VALIDATE_INV_SAMPLE
153 ( p_sample_rec IN GMD_SAMPLES%ROWTYPE,
154 p_locator_control IN NUMBER,
155 x_return_status OUT NOCOPY VARCHAR2
156 );
157
158 /*#
159 * Validates Customer sample
160 * @param p_sample_rec Record structure for samples
161 * @param x_return_status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
162 * @rep:scope public
163 * @rep:lifecycle active
164 * @rep:displayname Validate Customer sample
165 * @rep:compatibility S
166 */
167
168 PROCEDURE VALIDATE_CUST_SAMPLE
169 ( p_sample_rec IN GMD_SAMPLES%ROWTYPE,
170 x_return_status OUT NOCOPY VARCHAR2
171 );
172
173 /*#
174 * Validates Supplier sample
175 * @param p_sample_rec Record structure for samples
176 * @param x_return_status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
177 * @rep:scope public
178 * @rep:lifecycle active
179 * @rep:displayname Validate Supplier sample
180 * @rep:compatibility S
181 */
182
183 PROCEDURE VALIDATE_SUPP_SAMPLE
184 ( p_sample_rec IN GMD_SAMPLES%ROWTYPE,
185 x_return_status OUT NOCOPY VARCHAR2
186 );
187
188 /*#
189 * Validates WIP sample
190 * @param p_sample_rec Record structure for input samples
191 * @param x_sample_rec Record structure for output samples
192 * @param x_return_status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
193 * @rep:scope public
194 * @rep:lifecycle active
195 * @rep:displayname Validate WIP sample
196 * @rep:compatibility S
197 */
198
199 PROCEDURE VALIDATE_WIP_SAMPLE
200 ( p_sample_rec IN GMD_SAMPLES%ROWTYPE,
201 x_sample_rec OUT NOCOPY GMD_SAMPLES%ROWTYPE,
202 x_return_status OUT NOCOPY VARCHAR2
203 );
204
205 /*#
206 * Validates sample
207 * @param p_sample_rec Record structure for input samples
208 * @param p_grade Grade
209 * @param x_sample_rec Record structure for output samples
210 * @param x_return_status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
211 * @rep:scope public
212 * @rep:lifecycle active
213 * @rep:displayname Validate sample
214 * @rep:compatibility S
215 */
216
217 PROCEDURE VALIDATE_SAMPLE
218 (
219 p_sample_rec IN GMD_SAMPLES%ROWTYPE
220 , p_grade IN VARCHAR2 --3431884
221 , x_sample_rec OUT NOCOPY GMD_SAMPLES%ROWTYPE
222 , x_return_status OUT NOCOPY VARCHAR2
223 );
224
225 /*#
226 * Validates Location sample
227 * @param p_sample_rec Record structure for samples
228 * @param p_locator_control Locator controlled or not
229 * @param x_return_status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
230 * @rep:scope public
231 * @rep:lifecycle active
232 * @rep:displayname Validate Location sample
233 * @rep:compatibility S
234 */
235
236 PROCEDURE VALIDATE_LOCATION_SAMPLE
237 ( p_sample_rec IN GMD_SAMPLES%ROWTYPE,
238 p_locator_control IN NUMBER,
239 x_return_status OUT NOCOPY VARCHAR2
240 );
241
242 /*#
243 * Validates Resource sample
244 * @param p_sample_rec Record structure for samples
245 * @param x_return_status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
246 * @rep:scope public
247 * @rep:lifecycle active
248 * @rep:displayname Validate Resource sample
249 * @rep:compatibility S
250 */
251
252 PROCEDURE VALIDATE_RESOURCE_SAMPLE
253 ( p_sample_rec IN GMD_SAMPLES%ROWTYPE,
254 x_return_status OUT NOCOPY VARCHAR2
255 );
256
257 /*#
258 * Validates Stability sample
259 * @param p_sample_rec Record structure for samples
260 * @param x_return_status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
261 * @rep:scope public
262 * @rep:lifecycle active
263 * @rep:displayname Validate Stability sample
264 * @rep:compatibility S
265 */
266
267 PROCEDURE VALIDATE_STABILITY_SAMPLE
268 ( p_sample_rec IN GMD_SAMPLES%ROWTYPE,
269 x_return_status OUT NOCOPY VARCHAR2
270 );
271
272
273 END GMD_SAMPLES_PUB;
274