[Home] [Help]
PACKAGE: APPS.GMIGAPI
Source
1 PACKAGE GMIGAPI AUTHID CURRENT_USER AS
2 /* $Header: GMIGAPIS.pls 115.13 2003/09/17 15:46:45 txyu ship $
3 +==========================================================================+
4 | Copyright (c) 1998 Oracle Corporation |
5 | Redwood Shores, CA, USA |
6 | All rights reserved. |
7 +==========================================================================+
8 | FILE NAME |
9 | GMIGAPIS.pls |
10 | |
11 | PACKAGE NAME |
12 | GMIGAPI |
13 | |
14 | DESCRIPTION |
15 | This package contains 'Group' specifications for the public APIs |
16 | |
17 | |
18 | HISTORY |
19 | 13/May/2000 P.J.Schofield Bug 1294915 Major performance changes |
20 | |
21 | 01/Nov/2001 K.RajaSekhar Bug 1962677 The field journal_comment is |
22 | added in qty_rec_typ record. |
23 | 21/Feb/2002 P Lowe Bug 2233859 - Field ont_pricing_qty_source |
24 | added in item_rec_typ record for the |
25 | Pricing by Quantity 2 project. |
26 | 07/04/2002 Jalaj Srivastava Bug 2483656
27 | Added 35 new columns to the qty_rec_typ
28 | 07/25/02 Jalaj Srivastava Bug 2485879
29 | FND_API.G_MISS_DATE should not be used now |
30 | 'coz of performance issues.
31 | Date fields should not be defaulted to |
32 | Sysdate since, then the forms do not accept|
33 | the record type as valid. Changes made in |
34 | lot_rec_typ. Also removed default |
35 | assignments of NULL. The fields of a record|
36 | are by default NULL.
37 | 11/11/2002 Joe DiIorio Bug 2643440 11.5.1J
38 | Added nocopy to packages.
39 | 06/19/2003 Sastry BUG 2861715
40 | Added a new column move_entire_qty to the |
41 | qty_rec_typ record. |
42 | 9/11/2003 Teresa Wong B2378017 |
43 | Added four new classes to item_rec_typ. |
44 +==========================================================================+
45 */
46
47
48
49 TYPE item_rec_typ IS RECORD
50 ( item_no ic_item_mst.item_no%TYPE
51 , item_desc1 ic_item_mst.item_desc1%TYPE
52 , item_desc2 ic_item_mst.item_desc2%TYPE DEFAULT NULL
53 , alt_itema ic_item_mst.alt_itema%TYPE DEFAULT NULL
54 , alt_itemb ic_item_mst.alt_itemb%TYPE DEFAULT NULL
55 , item_um ic_item_mst.item_um%TYPE
56 , dualum_ind ic_item_mst.dualum_ind%TYPE DEFAULT 0
57 , item_um2 ic_item_mst.item_um2%TYPE DEFAULT NULL
58 , deviation_lo ic_item_mst.deviation_lo%TYPE DEFAULT 0
59 , deviation_hi ic_item_mst.deviation_hi%TYPE DEFAULT 0
60 , level_code ic_item_mst.level_code%TYPE DEFAULT NULL
61 , lot_ctl ic_item_mst.lot_ctl%TYPE DEFAULT 0
62 , lot_indivisible ic_item_mst.lot_indivisible%TYPE DEFAULT 0
63 , sublot_ctl ic_item_mst.sublot_ctl%TYPE DEFAULT 0
64 , loct_ctl ic_item_mst.loct_ctl%TYPE DEFAULT 0
65 , noninv_ind ic_item_mst.noninv_ind%TYPE DEFAULT 0
66 , match_type ic_item_mst.match_type%TYPE DEFAULT 3
67 , inactive_ind ic_item_mst.inactive_ind%TYPE DEFAULT 0
68 , inv_type ic_item_mst.inv_type%TYPE DEFAULT NULL
69 , shelf_life ic_item_mst.shelf_life%TYPE DEFAULT 0
70 , retest_interval ic_item_mst.retest_interval%TYPE DEFAULT 0
71 , item_abccode ic_item_mst.item_abccode%TYPE DEFAULT NULL
72 , gl_class ic_item_mst.gl_class%TYPE DEFAULT NULL
73 , inv_class ic_item_mst.inv_class%TYPE DEFAULT NULL
74 , sales_class ic_item_mst.sales_class%TYPE DEFAULT NULL
75 , ship_class ic_item_mst.ship_class%TYPE DEFAULT NULL
76 , frt_class ic_item_mst.frt_class%TYPE DEFAULT NULL
77 , price_class ic_item_mst.price_class%TYPE DEFAULT NULL
78 , storage_class ic_item_mst.storage_class%TYPE DEFAULT NULL
79 , purch_class ic_item_mst.purch_class%TYPE DEFAULT NULL
80 , tax_class ic_item_mst.tax_class%TYPE DEFAULT NULL
81 , customs_class ic_item_mst.customs_class%TYPE DEFAULT NULL
82 , alloc_class ic_item_mst.alloc_class%TYPE DEFAULT NULL
83 , planning_class ic_item_mst.planning_class%TYPE DEFAULT NULL
84 , itemcost_class ic_item_mst.itemcost_class%TYPE DEFAULT NULL
85 , cost_mthd_code ic_item_mst.cost_mthd_code%TYPE DEFAULT NULL
86 , upc_code ic_item_mst.upc_code%TYPE DEFAULT NULL
87 , grade_ctl ic_item_mst.grade_ctl%TYPE DEFAULT 0
88 , status_ctl ic_item_mst.status_ctl%TYPE DEFAULT 0
89 , qc_grade ic_item_mst.qc_grade%TYPE DEFAULT NULL
90 , lot_status ic_item_mst.lot_status%TYPE DEFAULT NULL
91 , bulk_id ic_item_mst.bulk_id%TYPE DEFAULT NULL
92 , pkg_id ic_item_mst.pkg_id%TYPE DEFAULT NULL
93 , qcitem_no ic_item_mst.item_no%TYPE DEFAULT NULL
94 , qchold_res_code ic_item_mst.qchold_res_code%TYPE DEFAULT NULL
95 , expaction_code ic_item_mst.expaction_code%TYPE DEFAULT NULL
96 , fill_qty ic_item_mst.fill_qty%TYPE DEFAULT 0
97 , fill_um ic_item_mst.fill_um%TYPE DEFAULT NULL
98 , expaction_interval ic_item_mst.expaction_interval%TYPE DEFAULT 0
99 , phantom_type ic_item_mst.phantom_type%TYPE DEFAULT 0
100 , whse_item_no ic_item_mst.item_no%TYPE DEFAULT NULL
101 , experimental_ind ic_item_mst.experimental_ind%TYPE DEFAULT 0
102 , exported_date ic_item_mst.exported_date%TYPE DEFAULT TO_DATE('02011970','DDMMYYYY')
103 , seq_dpnd_class ic_item_mst.seq_dpnd_class%TYPE DEFAULT NULL
104 , commodity_code ic_item_mst.commodity_code%TYPE DEFAULT NULL
105 , ic_matr_days ic_item_cpg.ic_matr_days%TYPE DEFAULT 0
106 , ic_hold_days ic_item_cpg.ic_hold_days%TYPE DEFAULT 0
107 , attribute1 ic_item_mst.attribute1%TYPE DEFAULT NULL
108 , attribute2 ic_item_mst.attribute2%TYPE DEFAULT NULL
109 , attribute3 ic_item_mst.attribute3%TYPE DEFAULT NULL
110 , attribute4 ic_item_mst.attribute4%TYPE DEFAULT NULL
111 , attribute5 ic_item_mst.attribute5%TYPE DEFAULT NULL
112 , attribute6 ic_item_mst.attribute6%TYPE DEFAULT NULL
113 , attribute7 ic_item_mst.attribute7%TYPE DEFAULT NULL
114 , attribute8 ic_item_mst.attribute8%TYPE DEFAULT NULL
115 , attribute9 ic_item_mst.attribute9%TYPE DEFAULT NULL
116 , attribute10 ic_item_mst.attribute10%TYPE DEFAULT NULL
117 , attribute11 ic_item_mst.attribute11%TYPE DEFAULT NULL
118 , attribute12 ic_item_mst.attribute12%TYPE DEFAULT NULL
119 , attribute13 ic_item_mst.attribute13%TYPE DEFAULT NULL
120 , attribute14 ic_item_mst.attribute14%TYPE DEFAULT NULL
121 , attribute15 ic_item_mst.attribute15%TYPE DEFAULT NULL
122 , attribute16 ic_item_mst.attribute16%TYPE DEFAULT NULL
123 , attribute17 ic_item_mst.attribute17%TYPE DEFAULT NULL
124 , attribute18 ic_item_mst.attribute18%TYPE DEFAULT NULL
125 , attribute19 ic_item_mst.attribute19%TYPE DEFAULT NULL
126 , attribute20 ic_item_mst.attribute20%TYPE DEFAULT NULL
127 , attribute21 ic_item_mst.attribute21%TYPE DEFAULT NULL
128 , attribute22 ic_item_mst.attribute22%TYPE DEFAULT NULL
129 , attribute23 ic_item_mst.attribute23%TYPE DEFAULT NULL
130 , attribute24 ic_item_mst.attribute24%TYPE DEFAULT NULL
131 , attribute25 ic_item_mst.attribute25%TYPE DEFAULT NULL
132 , attribute26 ic_item_mst.attribute26%TYPE DEFAULT NULL
133 , attribute27 ic_item_mst.attribute27%TYPE DEFAULT NULL
134 , attribute28 ic_item_mst.attribute28%TYPE DEFAULT NULL
135 , attribute29 ic_item_mst.attribute29%TYPE DEFAULT NULL
136 , attribute30 ic_item_mst.attribute30%TYPE DEFAULT NULL
137 , attribute_category ic_item_mst.attribute_category%TYPE DEFAULT NULL
138 , user_name fnd_user.user_name%TYPE DEFAULT 'OPM'
139 , ont_pricing_qty_source ic_item_mst.ont_pricing_qty_source%TYPE DEFAULT 0
140 , gl_business_class mtl_categories_v.category_concat_segs%TYPE DEFAULT NULL
141 , gl_prod_line mtl_categories_v.category_concat_segs%TYPE DEFAULT NULL
142 , sub_standard_class mtl_categories_v.category_concat_segs%TYPE DEFAULT NULL
143 , tech_class mtl_categories_v.category_concat_segs%TYPE DEFAULT NULL
144 );
145
146 TYPE lot_rec_typ IS RECORD
147 ( item_no ic_item_mst.item_no%TYPE
148 , lot_no ic_lots_mst.lot_no%TYPE
149 , sublot_no ic_lots_mst.sublot_no%TYPE
150 , lot_desc ic_lots_mst.lot_desc%TYPE
151 , qc_grade ic_lots_mst.qc_grade%TYPE
152 , expaction_code ic_lots_mst.expaction_code%TYPE
153 , expaction_date ic_lots_mst.expaction_date%TYPE
154 , lot_created ic_lots_mst.lot_created%TYPE
155 , expire_date ic_lots_mst.expire_date%TYPE
156 , retest_date ic_lots_mst.retest_date%TYPE
157 , strength ic_lots_mst.strength%TYPE DEFAULT 100
158 , inactive_ind ic_lots_mst.inactive_ind%TYPE DEFAULT 0
159 , origination_type ic_lots_mst.origination_type%TYPE DEFAULT 0
160 , shipvendor_no po_vend_mst.vendor_no%TYPE
161 , vendor_lot_no ic_lots_mst.vendor_lot_no%TYPE
162 , ic_matr_date ic_lots_cpg.ic_matr_date%TYPE
163 , ic_hold_date ic_lots_cpg.ic_hold_date%TYPE
164 , attribute1 ic_lots_mst.attribute1%TYPE
165 , attribute2 ic_lots_mst.attribute2%TYPE
166 , attribute3 ic_lots_mst.attribute3%TYPE
167 , attribute4 ic_lots_mst.attribute4%TYPE
168 , attribute5 ic_lots_mst.attribute5%TYPE
169 , attribute6 ic_lots_mst.attribute6%TYPE
170 , attribute7 ic_lots_mst.attribute7%TYPE
171 , attribute8 ic_lots_mst.attribute8%TYPE
172 , attribute9 ic_lots_mst.attribute9%TYPE
173 , attribute10 ic_lots_mst.attribute10%TYPE
174 , attribute11 ic_lots_mst.attribute11%TYPE
175 , attribute12 ic_lots_mst.attribute12%TYPE
176 , attribute13 ic_lots_mst.attribute13%TYPE
177 , attribute14 ic_lots_mst.attribute14%TYPE
178 , attribute15 ic_lots_mst.attribute15%TYPE
179 , attribute16 ic_lots_mst.attribute16%TYPE
180 , attribute17 ic_lots_mst.attribute17%TYPE
181 , attribute18 ic_lots_mst.attribute18%TYPE
182 , attribute19 ic_lots_mst.attribute19%TYPE
183 , attribute20 ic_lots_mst.attribute20%TYPE
184 , attribute21 ic_lots_mst.attribute21%TYPE
185 , attribute22 ic_lots_mst.attribute22%TYPE
186 , attribute23 ic_lots_mst.attribute23%TYPE
187 , attribute24 ic_lots_mst.attribute24%TYPE
188 , attribute25 ic_lots_mst.attribute25%TYPE
192 , attribute29 ic_lots_mst.attribute29%TYPE
189 , attribute26 ic_lots_mst.attribute26%TYPE
190 , attribute27 ic_lots_mst.attribute27%TYPE
191 , attribute28 ic_lots_mst.attribute28%TYPE
193 , attribute30 ic_lots_mst.attribute30%TYPE
194 , attribute_category ic_lots_mst.attribute_category%TYPE
195 , user_name fnd_user.user_name%TYPE DEFAULT 'OPM'
196 );
197
198 TYPE conv_rec_typ IS RECORD
199 (
200 item_no IC_ITEM_MST.item_no%TYPE
201 , lot_no IC_LOTS_MST.lot_no%TYPE DEFAULT NULL
202 , sublot_no IC_LOTS_MST.sublot_no%TYPE DEFAULT NULL
203 , from_uom SY_UOMS_MST.um_code%TYPE
204 , to_uom SY_UOMS_MST.um_code%TYPE
205 , type_factor IC_ITEM_CNV.type_factor%TYPE
206 , user_name FND_USER.user_name%TYPE DEFAULT 'OPM'
207 );
208
209 TYPE qty_rec_typ IS RECORD
210 (
211 trans_type NUMBER(2)
212 , item_no ic_item_mst.item_no%TYPE
213 , journal_no ic_jrnl_mst.journal_no%TYPE
214 , from_whse_code ic_tran_cmp.whse_code%TYPE
215 , to_whse_code ic_tran_cmp.whse_code%TYPE DEFAULT NULL
216 , item_um ic_item_mst.item_um%TYPE DEFAULT NULL
217 , item_um2 ic_item_mst.item_um2%TYPE DEFAULT NULL
218 , lot_no ic_lots_mst.lot_no%TYPE DEFAULT NULL
219 , sublot_no ic_lots_mst.sublot_no%TYPE DEFAULT NULL
220 , from_location ic_tran_cmp.location%TYPE DEFAULT NULL
221 , to_location ic_tran_cmp.location%TYPE DEFAULT NULL
222 , trans_qty ic_tran_cmp.trans_qty%TYPE DEFAULT 0
223 , trans_qty2 ic_tran_cmp.trans_qty2%TYPE DEFAULT NULL
224 , qc_grade ic_tran_cmp.qc_grade%TYPE DEFAULT NULL
225 , lot_status ic_tran_cmp.lot_status%TYPE DEFAULT NULL
226 , co_code ic_tran_cmp.co_code%TYPE
227 , orgn_code ic_tran_cmp.orgn_code%TYPE
228 , trans_date ic_tran_cmp.trans_date%TYPE DEFAULT SYSDATE
229 , reason_code ic_tran_cmp.reason_code%TYPE
230 , user_name fnd_user.user_name%TYPE DEFAULT 'OPM'
231 , journal_comment ic_jrnl_mst.journal_comment%TYPE
232 , attribute1 ic_jrnl_mst.attribute1%TYPE DEFAULT NULL
233 , attribute2 ic_jrnl_mst.attribute2%TYPE DEFAULT NULL
234 , attribute3 ic_jrnl_mst.attribute3%TYPE DEFAULT NULL
235 , attribute4 ic_jrnl_mst.attribute4%TYPE DEFAULT NULL
236 , attribute5 ic_jrnl_mst.attribute5%TYPE DEFAULT NULL
237 , attribute6 ic_jrnl_mst.attribute6%TYPE DEFAULT NULL
238 , attribute7 ic_jrnl_mst.attribute7%TYPE DEFAULT NULL
239 , attribute8 ic_jrnl_mst.attribute8%TYPE DEFAULT NULL
240 , attribute9 ic_jrnl_mst.attribute9%TYPE DEFAULT NULL
241 , attribute10 ic_jrnl_mst.attribute10%TYPE DEFAULT NULL
242 , attribute11 ic_jrnl_mst.attribute11%TYPE DEFAULT NULL
243 , attribute12 ic_jrnl_mst.attribute12%TYPE DEFAULT NULL
244 , attribute13 ic_jrnl_mst.attribute13%TYPE DEFAULT NULL
245 , attribute14 ic_jrnl_mst.attribute14%TYPE DEFAULT NULL
246 , attribute15 ic_jrnl_mst.attribute15%TYPE DEFAULT NULL
247 , attribute16 ic_jrnl_mst.attribute16%TYPE DEFAULT NULL
248 , attribute17 ic_jrnl_mst.attribute17%TYPE DEFAULT NULL
249 , attribute18 ic_jrnl_mst.attribute18%TYPE DEFAULT NULL
250 , attribute19 ic_jrnl_mst.attribute19%TYPE DEFAULT NULL
251 , attribute20 ic_jrnl_mst.attribute20%TYPE DEFAULT NULL
252 , attribute21 ic_jrnl_mst.attribute21%TYPE DEFAULT NULL
253 , attribute22 ic_jrnl_mst.attribute22%TYPE DEFAULT NULL
254 , attribute23 ic_jrnl_mst.attribute23%TYPE DEFAULT NULL
255 , attribute24 ic_jrnl_mst.attribute24%TYPE DEFAULT NULL
256 , attribute25 ic_jrnl_mst.attribute25%TYPE DEFAULT NULL
257 , attribute26 ic_jrnl_mst.attribute26%TYPE DEFAULT NULL
258 , attribute27 ic_jrnl_mst.attribute27%TYPE DEFAULT NULL
259 , attribute28 ic_jrnl_mst.attribute28%TYPE DEFAULT NULL
260 , attribute29 ic_jrnl_mst.attribute29%TYPE DEFAULT NULL
261 , attribute30 ic_jrnl_mst.attribute30%TYPE DEFAULT NULL
262 , attribute_category ic_jrnl_mst.attribute_category%TYPE DEFAULT NULL
263 , acctg_unit_no VARCHAR2(240) DEFAULT NULL
264 , acct_no VARCHAR2(240) DEFAULT NULL
265 , txn_type VARCHAR2(3) DEFAULT NULL
266 , journal_ind VARCHAR2(1) DEFAULT NULL
267 , move_entire_qty VARCHAR2(2) DEFAULT 'Y' --BUG#2861715 Sastry
268 );
269
270 TYPE xfer_rec_typ IS RECORD
271 (
272 action_code NUMBER(2)
273 , transfer_no ic_xfer_mst.transfer_no%TYPE
274 , orgn_code ic_xfer_mst.orgn_code%TYPE
275 , item_no ic_item_mst.item_no%TYPE
276 , lot_no ic_lots_mst.lot_no%TYPE DEFAULT NULL
277 , sublot_no ic_lots_mst.sublot_no%TYPE DEFAULT NULL
278 , release_reason_code ic_xfer_mst.release_reason_code%TYPE DEFAULT NULL
279 , receive_reason_code ic_xfer_mst.receive_reason_code%TYPE DEFAULT NULL
280 , cancel_reason_code ic_xfer_mst.cancel_reason_code%TYPE DEFAULT NULL
281 , from_warehouse ic_xfer_mst.from_warehouse%TYPE DEFAULT NULL
282 , from_location ic_xfer_mst.from_location%TYPE DEFAULT NULL
283 , to_warehouse ic_xfer_mst.to_warehouse%TYPE DEFAULT NULL
287 , release_uom1 ic_xfer_mst.release_uom1%TYPE
284 , to_location ic_xfer_mst.to_location%TYPE DEFAULT NULL
285 , release_quantity1 ic_xfer_mst.release_quantity1%TYPE DEFAULT 0
286 , release_quantity2 ic_xfer_mst.release_quantity2%TYPE DEFAULT 0
288 , release_uom2 ic_xfer_mst.release_uom2%TYPE
289 , receive_quantity1 ic_xfer_mst.receive_quantity1%TYPE DEFAULT 0
290 , receive_quantity2 ic_xfer_mst.receive_quantity2%TYPE DEFAULT 0
291 , scheduled_release_date ic_xfer_mst.scheduled_release_date%TYPE
292 , actual_release_date ic_xfer_mst.actual_release_date%TYPE
293 , scheduled_receive_date ic_xfer_mst.scheduled_receive_date%TYPE
294 , actual_receive_date ic_xfer_mst.actual_receive_date%TYPE
295 , cancel_date ic_xfer_mst.cancel_date%TYPE
296 , comments ic_xfer_mst.comments%TYPE DEFAULT NULL
297 , attribute1 ic_lots_mst.attribute1%TYPE DEFAULT NULL
298 , attribute2 ic_lots_mst.attribute2%TYPE DEFAULT NULL
299 , attribute3 ic_lots_mst.attribute3%TYPE DEFAULT NULL
300 , attribute4 ic_lots_mst.attribute4%TYPE DEFAULT NULL
301 , attribute5 ic_lots_mst.attribute5%TYPE DEFAULT NULL
302 , attribute6 ic_lots_mst.attribute6%TYPE DEFAULT NULL
303 , attribute7 ic_lots_mst.attribute7%TYPE DEFAULT NULL
304 , attribute8 ic_lots_mst.attribute8%TYPE DEFAULT NULL
305 , attribute9 ic_lots_mst.attribute9%TYPE DEFAULT NULL
306 , attribute10 ic_lots_mst.attribute10%TYPE DEFAULT NULL
307 , attribute11 ic_lots_mst.attribute11%TYPE DEFAULT NULL
308 , attribute12 ic_lots_mst.attribute12%TYPE DEFAULT NULL
309 , attribute13 ic_lots_mst.attribute13%TYPE DEFAULT NULL
310 , attribute14 ic_lots_mst.attribute14%TYPE DEFAULT NULL
311 , attribute15 ic_lots_mst.attribute15%TYPE DEFAULT NULL
312 , attribute16 ic_lots_mst.attribute16%TYPE DEFAULT NULL
313 , attribute17 ic_lots_mst.attribute17%TYPE DEFAULT NULL
314 , attribute18 ic_lots_mst.attribute18%TYPE DEFAULT NULL
315 , attribute19 ic_lots_mst.attribute19%TYPE DEFAULT NULL
316 , attribute20 ic_lots_mst.attribute20%TYPE DEFAULT NULL
317 , attribute21 ic_lots_mst.attribute21%TYPE DEFAULT NULL
318 , attribute22 ic_lots_mst.attribute22%TYPE DEFAULT NULL
319 , attribute23 ic_lots_mst.attribute23%TYPE DEFAULT NULL
320 , attribute24 ic_lots_mst.attribute24%TYPE DEFAULT NULL
321 , attribute25 ic_lots_mst.attribute25%TYPE DEFAULT NULL
322 , attribute26 ic_lots_mst.attribute26%TYPE DEFAULT NULL
323 , attribute27 ic_lots_mst.attribute27%TYPE DEFAULT NULL
324 , attribute28 ic_lots_mst.attribute28%TYPE DEFAULT NULL
325 , attribute29 ic_lots_mst.attribute29%TYPE DEFAULT NULL
326 , attribute30 ic_lots_mst.attribute30%TYPE DEFAULT NULL
327 , attribute_category ic_lots_mst.attribute_category%TYPE DEFAULT NULL
328 , user_name fnd_user.user_name%TYPE DEFAULT 'OPM'
329 );
330
331
332 PROCEDURE Create_Item
333 ( p_api_version IN NUMBER
334 , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
335 , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
336 , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
337 , p_item_rec IN GMIGAPI.item_rec_typ
338 , x_ic_item_mst_row OUT NOCOPY ic_item_mst%ROWTYPE
339 , x_ic_item_cpg_row OUT NOCOPY ic_item_cpg%ROWTYPE
340 , x_return_status OUT NOCOPY VARCHAR2
341 , x_msg_count OUT NOCOPY NUMBER
342 , x_msg_data OUT NOCOPY VARCHAR2
343 );
344
345 PROCEDURE Create_Lot
346 ( p_api_version IN NUMBER
347 , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
348 , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
349 , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
350 , p_lot_rec IN lot_rec_typ
351 , p_ic_item_mst_row IN ic_item_mst%ROWTYPE
352 , p_ic_item_cpg_row IN ic_item_cpg%ROWTYPE
353 , x_ic_lots_mst_row OUT NOCOPY ic_lots_mst%ROWTYPE
354 , x_ic_lots_cpg_row OUT NOCOPY ic_lots_cpg%ROWTYPE
355 , x_return_status OUT NOCOPY VARCHAR2
356 , x_msg_count OUT NOCOPY NUMBER
357 , x_msg_data OUT NOCOPY VARCHAR2
358 );
359
360 PROCEDURE Create_Item_Lot_Conv
361 ( p_api_version IN NUMBER
362 , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
363 , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
364 , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
365 , p_conv_rec IN GMIGAPI.conv_rec_typ
366 , p_ic_item_mst_row IN ic_item_mst%ROWTYPE
367 , p_ic_lots_mst_row IN ic_lots_mst%ROWTYPE
368 , x_ic_item_cnv_row OUT NOCOPY ic_item_cnv%ROWTYPE
369 , x_return_status OUT NOCOPY VARCHAR2
370 , x_msg_count OUT NOCOPY NUMBER
371 , x_msg_data OUT NOCOPY VARCHAR2
372 );
373
374 PROCEDURE Inventory_Posting
375 ( p_api_version IN NUMBER
376 , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
377 , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
378 , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
379 , p_qty_rec IN GMIGAPI.qty_rec_typ
380 , p_ic_item_mst_row IN ic_item_mst%ROWTYPE
381 , p_ic_item_cpg_row IN ic_item_cpg%ROWTYPE
382 , p_ic_lots_mst_row IN ic_lots_mst%ROWTYPE
386 , x_ic_adjs_jnl_row2 OUT NOCOPY ic_adjs_jnl%ROWTYPE
383 , p_ic_lots_cpg_row IN ic_lots_cpg%ROWTYPE
384 , x_ic_jrnl_mst_row OUT NOCOPY ic_jrnl_mst%ROWTYPE
385 , x_ic_adjs_jnl_row1 OUT NOCOPY ic_adjs_jnl%ROWTYPE
387 , x_return_status OUT NOCOPY VARCHAR2
388 , x_msg_count OUT NOCOPY NUMBER
389 , x_msg_data OUT NOCOPY VARCHAR2
390 );
391
392 PROCEDURE Inventory_Transfer
393 ( p_api_version IN NUMBER
394 , p_init_msg_list IN VARCHAR2
395 , p_commit IN VARCHAR2
396 , p_validation_level IN NUMBER
397 , p_xfer_rec IN GMIGAPI.xfer_rec_typ
398 , p_ic_item_mst_row IN ic_item_mst%ROWTYPE
399 , p_ic_item_cpg_row IN ic_item_cpg%ROWTYPE
400 , p_ic_lots_mst_row IN ic_lots_mst%ROWTYPE
401 , p_ic_lots_cpg_row IN ic_lots_cpg%ROWTYPE
402 , p_ic_xfer_mst_row OUT NOCOPY ic_xfer_mst%ROWTYPE
403 , x_ic_xfer_mst_row OUT NOCOPY ic_xfer_mst%ROWTYPE
404 , x_return_status OUT NOCOPY VARCHAR2
405 , x_msg_count OUT NOCOPY NUMBER
406 , x_msg_data OUT NOCOPY VARCHAR2
407 );
408 prev_orgn_code ic_jrnl_mst.orgn_code%TYPE DEFAULT NULL;
409 prev_journal_no ic_jrnl_mst.journal_no%TYPE DEFAULT NULL;
410
411 END GMIGAPI;