[Home] [Help]
PACKAGE: APPS.GMF_VALIDATIONS_PVT
Source
1 PACKAGE GMF_validations_PVT AS
2 /* $Header: GMFVVALS.pls 120.5.12000000.2 2007/05/02 12:04:07 pmarada ship $ */
3 FUNCTION Validate_Calendar_Code
4 (
5 p_Calendar_Code IN cm_cldr_hdr.Calendar_Code%TYPE
6 )
7 RETURN BOOLEAN;
8
9 PROCEDURE Validate_Calendar_Code
10 (
11 p_calendar_code IN cm_cldr_hdr.Calendar_Code%TYPE
12 , x_co_code OUT NOCOPY cm_cldr_hdr.co_code%TYPE
13 , x_cost_mthd_code OUT NOCOPY cm_cldr_hdr.cost_mthd_code%TYPE
14 ) ;
15
16 PROCEDURE Validate_Period_Code
17 (
18 p_Calendar_Code IN cm_cldr_hdr.Calendar_Code%TYPE
19 , p_Period_Code IN cm_cldr_dtl.Period_Code%TYPE
20 , x_Period_Status OUT NOCOPY cm_cldr_dtl.Period_Status%TYPE
21 ) ;
22
23 FUNCTION Validate_Cost_Mthd_Code
24 (
25 p_cost_mthd_code IN ic_item_mst.cost_mthd_code%TYPE
26 )
27 RETURN BOOLEAN;
28
29 PROCEDURE Validate_cost_mthd_code
30 (
31 p_cost_mthd_code IN cm_mthd_mst.cost_mthd_code%TYPE
32 , x_cost_type OUT NOCOPY cm_mthd_mst.cost_type%TYPE
33 , x_rmcalc_type OUT NOCOPY cm_mthd_mst.rmcalc_type%TYPE
34 , x_prodcalc_type OUT NOCOPY cm_mthd_mst.prodcalc_type%TYPE
35 ) ;
36
37 FUNCTION Validate_Cost_type_Code
38 (
39 p_cost_mthd_code IN cm_mthd_mst.cost_mthd_code%TYPE
40 )
41 RETURN NUMBER;
42
43 FUNCTION Validate_Cost_type_Code
44 (
45 p_cost_mthd_code IN cm_mthd_mst.cost_mthd_code%TYPE,
46 p_type IN VARCHAR2
47 )
48 RETURN NUMBER;
49
50 FUNCTION Validate_Analysis_Code
51 (
52 p_Cost_Analysis_Code IN cm_alys_mst.Cost_Analysis_Code%TYPE
53 )
54 RETURN BOOLEAN;
55
56 FUNCTION Validate_Company_Code
57 (
58 p_Company_Code IN sy_orgn_mst.Co_Code%TYPE
59 )
60 RETURN BOOLEAN;
61
62 FUNCTION Validate_Orgn_Code
63 (
64 p_Orgn_Code IN sy_orgn_mst.Orgn_Code%TYPE
65 )
66 RETURN BOOLEAN;
67
68 FUNCTION Validate_Whse_Code
69 (
70 p_whse_code IN ic_whse_mst.whse_code%TYPE
71 )
72 RETURN BOOLEAN;
73
74 FUNCTION Validate_Item_Id
75 (
76 p_Item_Id IN ic_item_mst.Item_Id%TYPE
77 )
78 RETURN BOOLEAN;
79
80 PROCEDURE Validate_Item_Id
81 (
82 p_Item_Id IN ic_item_mst.Item_Id%TYPE
83 , x_Item_UM OUT NOCOPY ic_item_mst.Item_UM%TYPE
84 );
85
86 FUNCTION Validate_Item_No
87 (
88 p_Item_No IN ic_item_mst.Item_No%TYPE
89 )
90 RETURN NUMBER;
91
92 PROCEDURE Validate_Item_No
93 (
94 p_Item_No IN ic_item_mst.Item_No%TYPE
95 , x_Item_Id OUT NOCOPY ic_item_mst.Item_Id%TYPE
96 , x_Item_UM OUT NOCOPY ic_item_mst.Item_UM%TYPE
97 );
98
99 FUNCTION Validate_Itemcost_Class
100 (
101 p_itemcost_class IN ic_item_mst.itemcost_class%TYPE
102 )
103 RETURN BOOLEAN;
104
105 FUNCTION Validate_Cost_Cmpntcls_Id
106 (
107 p_Cost_Cmpntcls_Id IN cm_cmpt_mst.Cost_Cmpntcls_Id%TYPE
108 )
109 RETURN BOOLEAN;
110
111 PROCEDURE Validate_Cost_Cmpntcls_Id
112 (
113 p_Cost_Cmpntcls_Id IN cm_cmpt_mst.Cost_Cmpntcls_Id%TYPE
114 , x_Cost_Cmpntcls_Id OUT NOCOPY cm_cmpt_mst.Cost_Cmpntcls_Code%TYPE
115 , x_usage_ind OUT NOCOPY cm_cmpt_mst.usage_ind%TYPE
116 );
117
118 FUNCTION Validate_Cost_Cmpntcls_Code
119 (
120 p_Cost_Cmpntcls_Code IN cm_cmpt_mst.Cost_Cmpntcls_Code%TYPE
121 )
122 RETURN NUMBER;
123
124 PROCEDURE Validate_Cost_Cmpntcls_Code
125 (
126 p_Cost_Cmpntcls_Code IN cm_cmpt_mst.Cost_Cmpntcls_Code%TYPE
127 , x_Cost_Cmpntcls_Id OUT NOCOPY cm_cmpt_mst.Cost_Cmpntcls_Id%TYPE
128 , x_Usage_Ind OUT NOCOPY cm_cmpt_mst.Usage_Ind%TYPE
129 );
130
131 FUNCTION Validate_Gl_Class
132 (
133 p_gl_class IN ic_gled_cls.icgl_class%TYPE
134 )
135 RETURN BOOLEAN;
136
137 FUNCTION Validate_Fmeff_Id
138 (
139 p_Fmeff_Id IN fm_form_eff.Fmeff_Id%TYPE
140 )
141 RETURN BOOLEAN;
142
143 FUNCTION Validate_Resources
144 (
145 p_Resources IN cr_rsrc_mst.Resources%TYPE
146 )
147 RETURN BOOLEAN;
148
149 PROCEDURE Validate_Resources
150 (
151 p_Resources IN cr_rsrc_mst.Resources%TYPE
152 , x_resource_um OUT NOCOPY cr_rsrc_mst.std_usage_um%TYPE
153 , x_resource_um_type OUT NOCOPY sy_uoms_mst.um_type%TYPE
154 );
155
156 FUNCTION Validate_Alloc_Id
157 (
158 p_Alloc_Id IN gl_aloc_mst.Alloc_Id%TYPE
159 )
160 RETURN BOOLEAN;
161
162 FUNCTION Fetch_Alloc_Id
163 (
164 p_Alloc_Code IN gl_aloc_mst.Alloc_Code%TYPE
165 , p_co_code IN sy_orgn_mst.co_code%TYPE
166 )
167 RETURN NUMBER;
168
169 PROCEDURE Validate_Basis_account_key
170 (
171 p_Basis_account_key IN gl_aloc_bas.Basis_account_key%TYPE
172 , p_co_code IN sy_orgn_mst.co_code%TYPE
173 , p_basis_description OUT NOCOPY VARCHAR2
174 , p_return_status OUT NOCOPY NUMBER
175 );
176
177 FUNCTION Validate_Usage_Um
178 (
179 p_Usage_Um IN sy_uoms_mst.Um_Code%TYPE
180 )
181 RETURN BOOLEAN;
182
183 PROCEDURE Validate_Usage_Um
184 (
185 p_Usage_Um IN sy_uoms_mst.Um_Code%TYPE
186 , x_Um_Type OUT NOCOPY sy_uoms_mst.Um_Type%TYPE
187 );
188
189 FUNCTION VALIDATE_LOT_ID
190 (
191 p_item_id IN ic_item_mst.item_id%TYPE
192 , p_lot_no IN ic_lots_mst.lot_no%TYPE
193 , p_sublot_no IN ic_lots_mst.sublot_no%TYPE
194 )
195 RETURN NUMBER;
196
197 FUNCTION VALIDATE_LOT_ID
198 (
199 p_item_id IN ic_item_mst.item_id%TYPE
200 , p_lot_id IN ic_lots_mst.lot_id%TYPE
201 )
202 RETURN BOOLEAN;
203
204 FUNCTION VALIDATE_LOT_NO
205 (
206 p_item_id IN ic_item_mst.item_id%TYPE
207 , p_lot_no IN ic_lots_mst.lot_no%TYPE
208 , p_sublot_no IN ic_lots_mst.sublot_no%TYPE
209 )
210 RETURN BOOLEAN;
211
212 /* ANTHIYAG Added for Release 12.0 Start */
213 FUNCTION validate_legal_entity_id
214 (
215 p_legal_entity_id IN xle_entity_profiles.legal_entity_id%TYPE
216 )
217 RETURN BOOLEAN;
218
219 FUNCTION Validate_Cost_type_id
220 (
221 p_cost_type_id IN cm_mthd_mst.cost_type_id%TYPE
222 )
223 RETURN BOOLEAN;
224
225 FUNCTION Validate_Cost_type_id
226 (
227 p_cost_type_id IN cm_mthd_mst.cost_type_id%TYPE,
228 p_type IN VARCHAR2
229 )
230 RETURN BOOLEAN;
231
232 /* sschinch commented. This is a duplicate function repeated again
233 FUNCTION Validate_cost_mthd_code
234 (
235 p_cost_mthd_code IN cm_mthd_mst.cost_mthd_code%TYPE
236 )
237 RETURN NUMBER;
238 */
239
240 FUNCTION Validate_period_id
241 (
242 p_period_id IN gmf_period_statuses.period_id%TYPE
243 )
244 RETURN BOOLEAN;
245
246 FUNCTION Validate_period_id
247 (
248 p_period_id IN gmf_period_statuses.period_id%TYPE,
249 p_cost_type_id OUT NOCOPY gmf_period_statuses.cost_type_id%TYPE
250 )
251 RETURN BOOLEAN;
252
253 FUNCTION Validate_period_code
254 (
255 p_organization_id IN mtl_organizations.organization_id%TYPE,
256 p_calendar_code IN cm_cldr_hdr_b.calendar_code%TYPE,
257 p_period_code IN cm_cldr_dtl.period_code%TYPE,
258 p_cost_type_id IN cm_mthd_mst.cost_type_id%TYPE
259 )
260 RETURN NUMBER;
261
262 FUNCTION Validate_organization_id
263 (
264 p_organization_id IN mtl_organizations.organization_id%TYPE
265 )
266 RETURN BOOLEAN;
267
268 FUNCTION Validate_Organization_code
269 (
270 p_organization_code IN mtl_parameters.organization_code%TYPE
271 )
272 RETURN NUMBER;
273
274 FUNCTION Validate_inventory_item_id
275 (
276 p_inventory_item_id IN mtl_system_items_b.inventory_item_id%TYPE,
277 p_organization_id IN mtl_organizations.organization_id%TYPE
278 )
279 RETURN BOOLEAN;
280
281 FUNCTION Validate_item_number
282 (
283 p_item_number IN mtl_item_flexfields.item_number%TYPE,
284 p_organization_id IN mtl_organizations.organization_id%TYPE
285 )
286 RETURN NUMBER;
287
288 FUNCTION Validate_Lot_Number
289 (
290 p_lot_number IN mtl_lot_numbers.lot_number%TYPE,
291 p_inventory_item_id IN mtl_system_items_b.inventory_item_id%TYPE,
292 p_organization_id IN mtl_organizations.organization_id%TYPE
293 )
294 RETURN BOOLEAN;
295
296 FUNCTION Validate_Lot_Cost_Mthd_Code
297 (
298 p_cost_mthd_code IN ic_item_mst.cost_mthd_code%TYPE
299 )
300 RETURN BOOLEAN;
301
302 FUNCTION Validate_Lot_Cost_Type
303 (
304 p_cost_mthd_code IN cm_mthd_mst.cost_mthd_code%TYPE
305 )
306 RETURN NUMBER;
307
308 FUNCTION Validate_Lot_Cost_type_id
309 (
310 p_cost_type_id IN cm_mthd_mst.cost_type_id%TYPE
311 )
312 RETURN BOOLEAN;
313
314 FUNCTION Fetch_Alloc_Id
315 (
316 p_Alloc_Code IN gl_aloc_mst.Alloc_Code%TYPE
317 , p_le_id IN xle_entity_profiles.legal_entity_id%TYPE
318 )
319 RETURN NUMBER;
320
321 FUNCTION Validate_Basis_account_key
322 (
323 p_Basis_account_key IN gl_aloc_bas.Basis_account_key%TYPE
324 , p_le_id IN xle_entity_profiles.legal_entity_id%TYPE
325 )
326 RETURN NUMBER;
327
328 FUNCTION Validate_ACCOUNT_ID
329 (
330 p_Basis_account_id IN gl_aloc_bas.Basis_account_id%TYPE
331 , p_le_id IN xle_entity_profiles.legal_entity_id%TYPE
332 )
333 RETURN BOOLEAN;
334
335 FUNCTION Validate_same_class_Uom
336 (
337 P_uom_code IN mtl_units_of_measure.uom_code%TYPE,
338 p_inventory_item_id IN mtl_system_items_b.inventory_item_id%TYPE,
339 p_organization_id IN mtl_system_items_b.organization_id%TYPE
340 ) RETURN BOOLEAN;
341
342 /* ANTHIYAG Added for Release 12.0 End */
343
344 FUNCTION Validate_Usage_Uom
345 (
346 P_usgae_uom IN mtl_units_of_measure.uom_code%TYPE
347 ) RETURN BOOLEAN;
348
349 PROCEDURE validate_usage_uom (
350 p_usage_uom IN mtl_units_of_measure.uom_code%TYPE,
351 p_usage_uom_class OUT NOCOPY mtl_units_of_measure.uom_class%TYPE
352 );
353
354 PROCEDURE Validate_Resource
355 (
356 p_Resources IN cr_rsrc_mst.Resources%TYPE
357 , x_resource_uom OUT NOCOPY cr_rsrc_mst.std_usage_uom%TYPE
358 , x_resource_uom_class OUT NOCOPY mtl_units_of_measure.uom_class%TYPE
359 );
360
361 END GMF_validations_PVT;