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