[Home] [Help]
PACKAGE: APPS.GMD_QC_ERES_UTILS
Source
1 PACKAGE GMD_QC_ERES_UTILS AUTHID CURRENT_USER AS
2 --$Header: GMDGERES.pls 120.4.12010000.2 2009/03/18 20:56:04 plowe ship $
3
4 -- Start of comments
5 --+==========================================================================+
6 --| Copyright (c) 1998 Oracle Corporation |
7 --| Redwood Shores, CA, USA |
8 --| All rights reserved. |
9 --+==========================================================================+
10 --| File Name : GMDVEREB.pls |
11 --| Package Name : GMD_QC_ERES_UTILS |
12 --| Type : Group |
13 --| |
14 --| Notes |
15 --| This package contains group layer APIs for Results Entity |
16 --| |
17 --| HISTORY |
18 --| Chetan Nagar 08-Aug-2002 Created. |
19 --| RLNAGARA 17-Nov-2005 Created 3 Procedures |
20 --| 1. GET_YES_NO |
21 --| 2. GET_ITEM_UOM_CALC |
22 --| 3. GET_DECIMAL_VALUE |
23 --+==========================================================================+
24 -- End of comments
25
26
27 PROCEDURE set_spec_status(p_spec_id IN NUMBER,
28 p_from_status IN VARCHAR2,
29 p_to_status IN VARCHAR2) ;
30
31 PROCEDURE set_spec_vr_status(p_spec_vr_id IN NUMBER,
32 p_entity_type IN VARCHAR2,
33 p_from_status IN VARCHAR2,
34 p_to_status IN VARCHAR2) ;
35
36 PROCEDURE update_vr_status(pentity_type IN VARCHAR2,
37 pspec_vr_id IN NUMBER,
38 p_to_status IN NUMBER) ;
39 FUNCTION chek_spec_validity_eres (p_spec_id IN NUMBER,
40 p_to_status IN VARCHAR2,
41 p_event IN VARCHAR2) RETURN BOOLEAN;
42
43 FUNCTION esig_required (p_event IN VARCHAR2,
44 p_event_key IN VARCHAR2,
45 p_to_status IN VARCHAR2) RETURN BOOLEAN;
46 PROCEDURE get_orgn_name(p_orgn_code VARCHAR2,
47 p_orgn_name OUT NOCOPY VARCHAR2);
48 PROCEDURE get_user_name(p_user_id VARCHAR2,
49 p_user_name OUT NOCOPY VARCHAR2);
50 PROCEDURE get_test_method_code(p_test_method_id VARCHAR2,
51 p_test_method_code OUT NOCOPY VARCHAR2);
52 PROCEDURE get_test_method_desc(p_test_method_id VARCHAR2,
53 p_test_method_desc OUT NOCOPY VARCHAR2);
54
55 PROCEDURE get_cust_name
56 (
57 p_cust_id IN NUMBER
58 , x_cust_name OUT NOCOPY VARCHAR2
59 );
60
61 PROCEDURE get_org_name
62 (
63 p_org_id IN NUMBER
64 , x_org_name OUT NOCOPY VARCHAR2
65 );
66
67
68 PROCEDURE get_ship_to_site_name
69 (
70 p_ship_to_site_id IN NUMBER
71 , x_ship_to_site_name OUT NOCOPY VARCHAR2
72 );
73
74 PROCEDURE get_order_number
75 (
76 p_order_id IN NUMBER
77 , x_order_number OUT NOCOPY NUMBER
78 );
79
80
81 PROCEDURE get_order_type
82 (
83 p_order_id IN NUMBER
84 , x_order_type OUT NOCOPY VARCHAR2
85 );
86
87 PROCEDURE get_order_line
88 (
89 p_order_line_id IN NUMBER
90 , x_order_line_number OUT NOCOPY NUMBER
91 );
92
93 PROCEDURE get_supp_code
94 (
95 p_supp_id IN NUMBER
96 , x_supp_code OUT NOCOPY VARCHAR2
97 );
98
99 PROCEDURE get_supp_name
100 (
101 p_supp_id IN NUMBER
102 , x_supp_name OUT NOCOPY VARCHAR2
103 );
104
105 PROCEDURE get_supp_site_name
106 (
107 p_supp_site_id IN NUMBER
108 , x_supp_site_name OUT NOCOPY VARCHAR2
109 );
110
111 PROCEDURE get_po_number
112 (
113 p_po_id IN NUMBER
114 , x_po_number OUT NOCOPY NUMBER
115 );
116
117 PROCEDURE get_po_line_number
118 (
119 p_po_line_id IN NUMBER
120 , x_po_line_number OUT NOCOPY NUMBER
121 );
122
123
124 PROCEDURE get_receipt_number
125 (
126 p_receipt_id IN NUMBER
127 , x_receipt_number OUT NOCOPY NUMBER
128 );
129
130 PROCEDURE get_receipt_line_number
131 (
132 p_receipt_line_id IN NUMBER
133 , x_receipt_line_number OUT NOCOPY NUMBER
134 );
135
136 PROCEDURE get_status_code_meaning
137 (
138 p_status_code IN NUMBER
139 , p_entity_type IN VARCHAR2
140 , x_status_meaning OUT NOCOPY VARCHAR2
141 );
142
143 -- added by mahesh to support stability study.
144
145 PROCEDURE set_stability_status( p_ss_id IN NUMBER,
146 p_from_status IN VARCHAR2,
147 p_to_status IN VARCHAR2) ;
148
149
150
151 PROCEDURE get_test_desc
152 (
153 p_test_id IN NUMBER
154 , x_test_desc OUT NOCOPY VARCHAR2
155 );
156
157 PROCEDURE get_ss_time_unit
158 (
159 p_time IN VARCHAR2
160 , x_time_unit OUT NOCOPY VARCHAR2
161 );
162
163 -- INVCONV, NSRIVAST, START
164 PROCEDURE get_orgn_code
165 (
166 p_orgn_id VARCHAR2
167 , p_orgn_code OUT NOCOPY VARCHAR2
168 );
169
170 PROCEDURE get_item_number
171 (
172 p_item_id VARCHAR2
173 , p_org_id VARCHAR2
174 , p_item_no OUT NOCOPY VARCHAR2
175 );
176
177 PROCEDURE get_item_number1
178 (
179 p_item_id VARCHAR2
180 , p_item_no OUT NOCOPY VARCHAR2
181 );
182
183 PROCEDURE get_item_desc
184 (
185 p_item_id VARCHAR2
186 , p_org_id VARCHAR2
187 , p_item_desc OUT NOCOPY VARCHAR2
188 );
189
190 PROCEDURE get_spec_name
191 (
192 p_spec_id VARCHAR2
193 , p_spec_name OUT NOCOPY VARCHAR2
194 );
195
196 PROCEDURE get_spec_vers
197 (
198 p_spec_id VARCHAR2
199 , p_spec_vers OUT NOCOPY VARCHAR2
200 );
201
202 PROCEDURE get_item_uom
203 (
204 p_item_id VARCHAR2
205 , p_org_id VARCHAR2
206 , p_item_uom OUT NOCOPY VARCHAR2
207 );
208
209 PROCEDURE get_spec_type
210 ( p_spec_type_ind VARCHAR2
211 , p_spec_type OUT NOCOPY VARCHAR2
212 ) ;
213
214 PROCEDURE get_loc_name
215 ( p_loc_id VARCHAR2
216 , p_loc_name OUT NOCOPY VARCHAR2
217 );
218
219 PROCEDURE GET_LOOKUP_VALUE
220 ( plookup_type IN VARCHAR2
221 , plookup_code IN VARCHAR2
222 , pmeaning OUT NOCOPY VARCHAR2
223 ) ;
224
225 -- INVCONV, NSRIVAST, END
226
227 --RLNAGARA
228 PROCEDURE GET_YES_NO
229 (
230 p_short IN VARCHAR2 ,
231 x_expanded OUT NOCOPY VARCHAR2
232 );
233 --RLNAGARA
234
235
236 --RLNAGARA
237 PROCEDURE GET_ITEM_UOM_CALC
238 (
239 p_item_id IN VARCHAR2
240 , p_organization_id IN VARCHAR2
241 , p_spec_id IN VARCHAR2
242 , p_test_id IN VARCHAR2
243 , x_item_uom OUT NOCOPY VARCHAR2
244 );
245 --RLNAGARA
246
247 --RLNAGARA
248 PROCEDURE GET_DECIMAL_VALUE
249 (
250 p_value IN VARCHAR2
251 , p_test_qty IN VARCHAR2
252 , p_test_id IN VARCHAR2
253 , x_decimal_value OUT NOCOPY VARCHAR2
254 );
255 --RLNAGARA
256
257 --RLNAGARA
258 PROCEDURE get_disp_meaning(p_sample_id IN NUMBER,
259 p_sampling_event_id IN NUMBER,
260 p_organization_id IN NUMBER,
261 p_disp_type IN VARCHAR2,
262 psample_disposition OUT NOCOPY VARCHAR2 );
263 --RLNAGARA
264
265 --RLNAGARA B3576516
266 PROCEDURE get_composited(p_event_spec_disp_id IN NUMBER,
267 x_composited OUT NOCOPY VARCHAR2);
268 --RLNAGARA B3576516
269
270 --RLNAGARA LPN ME 7027149
271 PROCEDURE get_lpn(p_lpn_id IN NUMBER,
272 x_lpn OUT NOCOPY VARCHAR2);
273
274 END GMD_QC_ERES_UTILS;
275