[Home] [Help]
PACKAGE: APPS.GMI_VALID_GRP
Source
1 PACKAGE GMI_VALID_GRP AUTHID CURRENT_USER AS
2 -- $Header: GMIGVALS.pls 115.2 99/07/16 04:47:39 porting ship $
3 --+=========================================================================+
4 --| Copyright (c) 1998 Oracle Corporation |
5 --| TVP, Reading, England |
6 --| All rights reserved |
7 --+=========================================================================+
8 --| FILENAME |
9 --| GMIGVALS.pls |
10 --| |
11 --| DESCRIPTION |
12 --| This package contains inventory validation functions and |
13 --| procedures. |
14 --| |
15 --| HISTORY |
16 --| 01-OCT-1998 M.Godfrey Created |
17 --| 17-FEB-1999 M.Godfrey Upgrade to R11 |
18 --+=========================================================================+
19 -- API Name : GMI_VALID_GRP
20 -- Type : Group
21 -- Function : This package contains inventory validation functions and
22 -- procedures
23 -- Pre-reqs : N/A
24 -- Parameters: Per function
25 --
26 -- Current Vers : 2.0
27 --
28 -- Previous Vers : 1.0
29 --
30 -- Initial Vers : 1.0
31 -- Notes
32 --
33 FUNCTION Validate_Item_Existance
34 ( p_item_no IN ic_item_mst.item_no%TYPE
35 )
36 RETURN NUMBER;
37 --
38 FUNCTION Validate_Dualum_Ind
39 ( p_dualum_ind IN ic_item_mst.dualum_ind%TYPE
40 )
41 RETURN BOOLEAN;
42 --
43 FUNCTION Validate_Item_Um2
44 ( p_dualum_ind IN ic_item_mst.dualum_ind%TYPE
45 , p_item_um2 IN ic_item_mst.item_um2%TYPE
46 )
47 RETURN BOOLEAN;
48 --
49 FUNCTION Validate_Deviation
50 ( p_dualum_ind IN ic_item_mst.dualum_ind%TYPE
51 , p_deviation IN ic_item_mst.deviation_hi%TYPE
52 )
53 RETURN BOOLEAN;
54 --
55 FUNCTION Validate_Lot_Ctl
56 ( p_lot_ctl IN ic_item_mst.lot_ctl%TYPE
57 )
58 RETURN BOOLEAN;
59 --
60 FUNCTION Validate_Lot_Indivisible
61 ( p_lot_ctl IN ic_item_mst.lot_ctl%TYPE
62 , p_lot_indivisible IN ic_item_mst.lot_indivisible%TYPE
63 )
64 RETURN BOOLEAN;
65 --
66 FUNCTION Validate_Sublot_Ctl
67 ( p_lot_ctl IN ic_item_mst.lot_ctl%TYPE
68 , p_sublot_ctl IN ic_item_mst.sublot_ctl%TYPE
69 )
70 RETURN BOOLEAN;
71 --
72 FUNCTION Validate_Loct_Ctl
73 ( p_loct_ctl IN ic_item_mst.loct_ctl%TYPE
74 )
75 RETURN BOOLEAN;
76 --
77 FUNCTION Validate_Noninv_Ind
78 ( p_noninv_ind IN ic_item_mst.noninv_ind%TYPE
79 , p_lot_ctl IN ic_item_mst.lot_ctl%TYPE
80 )
81 RETURN BOOLEAN;
82 --
83 FUNCTION Validate_Match_Type
84 ( p_match_type IN ic_item_mst.match_type%TYPE
85 )
86 RETURN BOOLEAN;
87 --
88 FUNCTION Validate_Inactive_Ind
89 ( p_inactive_ind IN ic_item_mst.inactive_ind%TYPE
90 )
91 RETURN BOOLEAN;
92 --
93 FUNCTION Validate_Inv_Type
94 ( p_inv_type IN ic_item_mst.inv_type%TYPE
95 )
96 RETURN BOOLEAN;
97 --
98 FUNCTION Validate_Shelf_Life
99 ( p_shelf_life IN ic_item_mst.shelf_life%TYPE
100 , p_grade_ctl IN ic_item_mst.grade_ctl%TYPE
101 )
102 RETURN BOOLEAN;
103 --
104 FUNCTION Validate_Retest_Interval
105 ( p_retest_interval IN ic_item_mst.retest_interval%TYPE
106 , p_grade_ctl IN ic_item_mst.grade_ctl%TYPE
107 )
108 RETURN BOOLEAN;
109 --
110 FUNCTION Validate_Item_Abccode
111 ( p_item_abccode IN ic_item_mst.item_abccode%TYPE
112 )
113 RETURN BOOLEAN;
114 --
115 FUNCTION Validate_Gl_Class
116 ( p_gl_class IN ic_item_mst.gl_class%TYPE
117 )
118 RETURN BOOLEAN;
119 --
120 FUNCTION Validate_Inv_Class
121 ( p_inv_class IN ic_item_mst.inv_class%TYPE
122 )
123 RETURN BOOLEAN;
124 --
125 FUNCTION Validate_Sales_Class
126 ( p_sales_class IN ic_item_mst.sales_class%TYPE
127 )
128 RETURN BOOLEAN;
129 --
130 FUNCTION Validate_Ship_Class
131 ( p_ship_class IN ic_item_mst.ship_class%TYPE
132 )
133 RETURN BOOLEAN;
134 --
135 FUNCTION Validate_Frt_Class
136 ( p_frt_class IN ic_item_mst.frt_class%TYPE
137 )
138 RETURN BOOLEAN;
139 --
140 FUNCTION Validate_Price_Class
141 ( p_price_class IN ic_item_mst.price_class%TYPE
142 )
143 RETURN BOOLEAN;
144 --
145 FUNCTION Validate_Storage_Class
146 ( p_storage_class IN ic_item_mst.storage_class%TYPE
147 )
148 RETURN BOOLEAN;
149 --
150 FUNCTION Validate_Purch_Class
151 ( p_purch_class IN ic_item_mst.purch_class%TYPE
152 )
153 RETURN BOOLEAN;
154 --
155 FUNCTION Validate_Tax_Class
156 ( p_tax_class IN ic_item_mst.tax_class%TYPE
157 )
158 RETURN BOOLEAN;
159 --
160 FUNCTION Validate_Customs_Class
161 ( p_customs_class IN ic_item_mst.customs_class%TYPE
162 )
163 RETURN BOOLEAN;
164 --
165 FUNCTION Validate_Alloc_Class
166 ( p_alloc_class IN ic_item_mst.alloc_class%TYPE
167 )
168 RETURN BOOLEAN;
169 --
170 FUNCTION Validate_Planning_Class
171 ( p_planning_class IN ic_item_mst.planning_class%TYPE
172 )
173 RETURN BOOLEAN;
174 --
175 FUNCTION Validate_Itemcost_Class
176 ( p_itemcost_class IN ic_item_mst.itemcost_class%TYPE
177 )
178 RETURN BOOLEAN;
179 --
180 FUNCTION Validate_Cost_Mthd_Code
181 ( p_cost_mthd_code IN ic_item_mst.cost_mthd_code%TYPE
182 )
183 RETURN BOOLEAN;
184 --
185 FUNCTION Validate_Grade_Ctl
186 ( p_grade_ctl IN ic_item_mst.grade_ctl%TYPE
187 , p_lot_ctl IN ic_item_mst.lot_ctl%TYPE
188 )
189 RETURN BOOLEAN;
190 --
191 FUNCTION Validate_Status_Ctl
192 ( p_status_ctl IN ic_item_mst.status_ctl%TYPE
193 , p_lot_ctl IN ic_item_mst.lot_ctl%TYPE
194 )
195 RETURN BOOLEAN;
196 --
197 FUNCTION Validate_Qc_Grade
198 ( p_qc_grade IN ic_item_mst.qc_grade%TYPE
199 , p_grade_ctl IN ic_item_mst.grade_ctl%TYPE
200 )
201 RETURN BOOLEAN;
202 --
203 FUNCTION Validate_Lot_Status
204 ( p_lot_status IN ic_item_mst.lot_status%TYPE
205 , p_status_ctl IN ic_item_mst.status_ctl%TYPE
206 )
207 RETURN BOOLEAN;
208 --
209 FUNCTION Validate_Qchold_Res_Code
210 ( p_qchold_res_code IN ic_item_mst.qchold_res_code%TYPE
211 , p_grade_ctl IN ic_item_mst.grade_ctl%TYPE
212 )
213 RETURN BOOLEAN;
214 --
215 FUNCTION Validate_Expaction_Code
216 ( p_expaction_code IN ic_item_mst.expaction_code%TYPE
217 , p_grade_ctl IN ic_item_mst.grade_ctl%TYPE
218 )
219 RETURN BOOLEAN;
220 --
221 FUNCTION Validate_Expaction_Interval
222 ( p_expaction_interval IN ic_item_mst.expaction_interval%TYPE
223 , p_grade_ctl IN ic_item_mst.grade_ctl%TYPE
224 )
225 RETURN BOOLEAN;
226 --
227 FUNCTION Validate_Experimental_Ind
228 ( p_experimental_ind IN ic_item_mst.experimental_ind%TYPE
229 )
230 RETURN BOOLEAN;
231 --
232 FUNCTION Validate_Seq_Dpnd_Class
233 ( p_seq_dpnd_class IN ic_item_mst.seq_dpnd_class%TYPE
234 )
235 RETURN BOOLEAN;
236 --
237 FUNCTION Validate_Commodity_Code
238 ( p_commodity_code IN ic_item_mst.commodity_code%TYPE
239 , p_sy$intrastat IN VARCHAR2
240 )
241 RETURN BOOLEAN;
242 --
243 FUNCTION Validate_Ic_Matr_Days
244 ( p_ic_matr_days IN ic_item_cpg.ic_matr_days%TYPE
245 )
246 RETURN BOOLEAN;
247 --
248 FUNCTION Validate_Ic_Hold_Days
249 ( p_ic_hold_days IN ic_item_cpg.ic_hold_days%TYPE
250 )
251 RETURN BOOLEAN;
252 --
253 FUNCTION Validate_Strength
254 ( p_strength IN ic_lots_mst.strength%TYPE
255 )
256 RETURN BOOLEAN;
257 --
258 FUNCTION Validate_Origination_Type
259 ( p_origination_type IN ic_lots_mst.origination_type%TYPE
260 )
261 RETURN BOOLEAN;
262 --
263 FUNCTION Validate_Shipvendor_No
264 ( p_shipvendor_no IN po_vend_mst.vendor_no%TYPE
265 )
266 RETURN NUMBER;
267 --
268 FUNCTION Validate_Lot_No
269 ( p_item_no IN ic_item_mst.item_no%TYPE
270 , p_lot_no IN ic_lots_mst.lot_no%TYPE
271 , p_sublot_no IN ic_lots_mst.sublot_no%TYPE
272 )
273 RETURN BOOLEAN;
274 --
275 FUNCTION Validate_Location
276 ( p_item_loct_ctl IN ic_item_mst.loct_ctl%TYPE
277 , p_whse_loct_ctl IN ic_whse_mst.loct_ctl%TYPE
278 , p_whse_code IN ic_whse_mst.whse_code%TYPE
279 , p_location IN ic_loct_mst.location%TYPE
280 )
281 RETURN BOOLEAN;
282 --
283 FUNCTION Validate_Item_Cnv
284 ( p_item_no IN ic_item_mst.item_no%TYPE
285 , p_lot_no IN ic_lots_mst.lot_no%TYPE
286 , p_sublot_no IN ic_lots_mst.sublot_no%TYPE
287 , p_um_type IN ic_item_cnv.um_type%TYPE
288 )
289 RETURN BOOLEAN;
290 --
291 END GMI_VALID_GRP;