eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.GMIGAPI

Source


4  |                   Copyright (c) 1998 Oracle Corporation                  |
1 PACKAGE GMIGAPI AUTHID CURRENT_USER AS
2 /* $Header: GMIGAPIS.pls 115.13 2003/09/17 15:46:45 txyu ship $
3  +==========================================================================+
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                                                                  |
22  |                               added in qty_rec_typ record.               |
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   |
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
112 , attribute6          ic_item_mst.attribute6%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
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
189 , attribute26         ic_lots_mst.attribute26%TYPE
190 , attribute27         ic_lots_mst.attribute27%TYPE
191 , attribute28         ic_lots_mst.attribute28%TYPE
192 , attribute29         ic_lots_mst.attribute29%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 (
214 , from_whse_code  ic_tran_cmp.whse_code%TYPE
211   trans_type      NUMBER(2)
212 , item_no         ic_item_mst.item_no%TYPE
213 , journal_no      ic_jrnl_mst.journal_no%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
225 , lot_status      ic_tran_cmp.lot_status%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
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
274 , orgn_code                ic_xfer_mst.orgn_code%TYPE
271 (
272   action_code              NUMBER(2)
273 , transfer_no              ic_xfer_mst.transfer_no%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
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
287 , release_uom1             ic_xfer_mst.release_uom1%TYPE
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
373 
370 , x_msg_count        OUT NOCOPY NUMBER
371 , x_msg_data         OUT NOCOPY VARCHAR2
372 );
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
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
386 , x_ic_adjs_jnl_row2 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;