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.IC_ITEM_MST_PKG

Source


1 package IC_ITEM_MST_PKG AUTHID CURRENT_USER as
2 /* $Header: gmiitems.pls 115.3 2003/03/07 15:11:00 jdiiorio noship $ */
3 procedure INSERT_ROW (
4   X_ROWID in out NOCOPY VARCHAR2,
5   X_ITEM_ID in NUMBER,
6   X_ITEM_NO in VARCHAR2,
7   X_ALT_ITEMA in VARCHAR2,
8   X_ALT_ITEMB in VARCHAR2,
9   X_ITEM_UM in VARCHAR2,
10   X_DUALUM_IND in NUMBER,
11   X_ITEM_UM2 in VARCHAR2,
12   X_DEVIATION_LO in NUMBER,
13   X_DEVIATION_HI in NUMBER,
14   X_LEVEL_CODE in NUMBER,
15   X_LOT_CTL in NUMBER,
16   X_LOT_INDIVISIBLE in NUMBER,
17   X_SUBLOT_CTL in NUMBER,
18   X_LOCT_CTL in NUMBER,
19   X_NONINV_IND in NUMBER,
20   X_MATCH_TYPE in NUMBER,
21   X_INACTIVE_IND in NUMBER,
22   X_INV_TYPE in VARCHAR2,
23   X_SHELF_LIFE in NUMBER,
24   X_RETEST_INTERVAL in NUMBER,
25   X_GL_CLASS in VARCHAR2,
26   X_INV_CLASS in VARCHAR2,
27   X_SALES_CLASS in VARCHAR2,
28   X_SHIP_CLASS in VARCHAR2,
29   X_FRT_CLASS in VARCHAR2,
30   X_PRICE_CLASS in VARCHAR2,
31   X_STORAGE_CLASS in VARCHAR2,
32   X_PURCH_CLASS in VARCHAR2,
33   X_TAX_CLASS in VARCHAR2,
34   X_CUSTOMS_CLASS in VARCHAR2,
35   X_ALLOC_CLASS in VARCHAR2,
36   X_PLANNING_CLASS in VARCHAR2,
37   X_ITEMCOST_CLASS in VARCHAR2,
38   X_COST_MTHD_CODE in VARCHAR2,
39   X_UPC_CODE in VARCHAR2,
40   X_GRADE_CTL in NUMBER,
41   X_STATUS_CTL in NUMBER,
42   X_QC_GRADE in VARCHAR2,
43   X_LOT_STATUS in VARCHAR2,
44   X_BULK_ID in NUMBER,
45   X_PKG_ID in NUMBER,
46   X_QCITEM_ID in NUMBER,
47   X_QCHOLD_RES_CODE in VARCHAR2,
48   X_EXPACTION_CODE in VARCHAR2,
49   X_FILL_QTY in NUMBER,
50   X_FILL_UM in VARCHAR2,
51   X_PLANNING_CATEGORY_ID in NUMBER,
52   X_PRICE_CATEGORY_ID in NUMBER,
53   X_EXPACTION_INTERVAL in NUMBER,
54   X_PHANTOM_TYPE in NUMBER,
55   X_WHSE_ITEM_ID in NUMBER,
56   X_EXPERIMENTAL_IND in NUMBER,
57   X_EXPORTED_DATE in DATE,
58   X_TRANS_CNT in NUMBER,
59   X_DELETE_MARK in NUMBER,
60   X_TEXT_CODE in NUMBER,
61   X_SEQ_DPND_CLASS in VARCHAR2,
62   X_COMMODITY_CODE in VARCHAR2,
63   X_REQUEST_ID in NUMBER,
64   X_ATTRIBUTE1 in VARCHAR2,
65   X_ATTRIBUTE2 in VARCHAR2,
66   X_ATTRIBUTE3 in VARCHAR2,
67   X_ATTRIBUTE4 in VARCHAR2,
68   X_ATTRIBUTE5 in VARCHAR2,
69   X_ATTRIBUTE6 in VARCHAR2,
70   X_ATTRIBUTE7 in VARCHAR2,
71   X_ATTRIBUTE8 in VARCHAR2,
72   X_ATTRIBUTE9 in VARCHAR2,
73   X_ATTRIBUTE10 in VARCHAR2,
74   X_ATTRIBUTE11 in VARCHAR2,
75   X_ATTRIBUTE12 in VARCHAR2,
76   X_ATTRIBUTE13 in VARCHAR2,
77   X_ATTRIBUTE14 in VARCHAR2,
78   X_ATTRIBUTE15 in VARCHAR2,
79   X_ATTRIBUTE16 in VARCHAR2,
80   X_ATTRIBUTE17 in VARCHAR2,
81   X_ATTRIBUTE18 in VARCHAR2,
82   X_ATTRIBUTE19 in VARCHAR2,
83   X_ATTRIBUTE20 in VARCHAR2,
84   X_ATTRIBUTE21 in VARCHAR2,
85   X_ATTRIBUTE22 in VARCHAR2,
86   X_ATTRIBUTE23 in VARCHAR2,
87   X_ATTRIBUTE24 in VARCHAR2,
88   X_ATTRIBUTE25 in VARCHAR2,
89   X_ATTRIBUTE26 in VARCHAR2,
90   X_ATTRIBUTE27 in VARCHAR2,
91   X_ATTRIBUTE28 in VARCHAR2,
92   X_ATTRIBUTE29 in VARCHAR2,
93   X_ATTRIBUTE30 in VARCHAR2,
94   X_ATTRIBUTE_CATEGORY in VARCHAR2,
95   X_ITEM_ABCCODE in VARCHAR2,
96   X_ALLOC_CATEGORY_ID in NUMBER,
97   X_CUSTOMS_CATEGORY_ID in NUMBER,
98   X_FRT_CATEGORY_ID in NUMBER,
99   X_GL_CATEGORY_ID in NUMBER,
100   X_INV_CATEGORY_ID in NUMBER,
101   X_COST_CATEGORY_ID in NUMBER,
102   X_PURCH_CATEGORY_ID in NUMBER,
103   X_SALES_CATEGORY_ID in NUMBER,
104   X_SEQ_CATEGORY_ID in NUMBER,
105   X_SHIP_CATEGORY_ID in NUMBER,
106   X_STORAGE_CATEGORY_ID in NUMBER,
107   X_TAX_CATEGORY_ID in NUMBER,
108   X_ITEM_DESC1 in VARCHAR2,
109   X_ITEM_DESC2 in VARCHAR2,
110   X_ONT_PRICING_QTY_SOURCE in NUMBER,  -- added for pricing by qty2 project
111   X_AUTOLOT_ACTIVE_INDICATOR in NUMBER DEFAULT 0,
112   X_LOT_PREFIX in VARCHAR2 DEFAULT NULL,
113   X_LOT_SUFFIX in NUMBER DEFAULT 0,
114   X_SUBLOT_PREFIX in VARCHAR2 DEFAULT NULL,
115   X_SUBLOT_SUFFIX in NUMBER DEFAULT 0,
116   X_CREATION_DATE in DATE,
117   X_CREATED_BY in NUMBER,
118   X_LAST_UPDATE_DATE in DATE,
119   X_LAST_UPDATED_BY in NUMBER,
120   X_LAST_UPDATE_LOGIN in NUMBER);
121 procedure LOCK_ROW (
122   X_ITEM_ID in NUMBER,
123   X_ITEM_NO in VARCHAR2,
124   X_ALT_ITEMA in VARCHAR2,
125   X_ALT_ITEMB in VARCHAR2,
126   X_ITEM_UM in VARCHAR2,
127   X_DUALUM_IND in NUMBER,
128   X_ITEM_UM2 in VARCHAR2,
129   X_DEVIATION_LO in NUMBER,
130   X_DEVIATION_HI in NUMBER,
131   X_LEVEL_CODE in NUMBER,
132   X_LOT_CTL in NUMBER,
133   X_LOT_INDIVISIBLE in NUMBER,
134   X_SUBLOT_CTL in NUMBER,
135   X_LOCT_CTL in NUMBER,
136   X_NONINV_IND in NUMBER,
137   X_MATCH_TYPE in NUMBER,
138   X_INACTIVE_IND in NUMBER,
139   X_INV_TYPE in VARCHAR2,
140   X_SHELF_LIFE in NUMBER,
141   X_RETEST_INTERVAL in NUMBER,
142   X_GL_CLASS in VARCHAR2,
143   X_INV_CLASS in VARCHAR2,
144   X_SALES_CLASS in VARCHAR2,
145   X_SHIP_CLASS in VARCHAR2,
146   X_FRT_CLASS in VARCHAR2,
147   X_PRICE_CLASS in VARCHAR2,
148   X_STORAGE_CLASS in VARCHAR2,
149   X_PURCH_CLASS in VARCHAR2,
150   X_TAX_CLASS in VARCHAR2,
151   X_CUSTOMS_CLASS in VARCHAR2,
152   X_ALLOC_CLASS in VARCHAR2,
153   X_PLANNING_CLASS in VARCHAR2,
154   X_ITEMCOST_CLASS in VARCHAR2,
155   X_COST_MTHD_CODE in VARCHAR2,
156   X_UPC_CODE in VARCHAR2,
157   X_GRADE_CTL in NUMBER,
158   X_STATUS_CTL in NUMBER,
159   X_QC_GRADE in VARCHAR2,
160   X_LOT_STATUS in VARCHAR2,
161   X_BULK_ID in NUMBER,
162   X_PKG_ID in NUMBER,
163   X_QCITEM_ID in NUMBER,
164   X_QCHOLD_RES_CODE in VARCHAR2,
165   X_EXPACTION_CODE in VARCHAR2,
166   X_FILL_QTY in NUMBER,
167   X_FILL_UM in VARCHAR2,
168   X_PLANNING_CATEGORY_ID in NUMBER,
169   X_PRICE_CATEGORY_ID in NUMBER,
170   X_EXPACTION_INTERVAL in NUMBER,
171   X_PHANTOM_TYPE in NUMBER,
172   X_WHSE_ITEM_ID in NUMBER,
173   X_EXPERIMENTAL_IND in NUMBER,
174   X_EXPORTED_DATE in DATE,
175   X_TRANS_CNT in NUMBER,
176   X_DELETE_MARK in NUMBER,
177   X_TEXT_CODE in NUMBER,
178   X_SEQ_DPND_CLASS in VARCHAR2,
179   X_COMMODITY_CODE in VARCHAR2,
180   X_REQUEST_ID in NUMBER,
181   X_ATTRIBUTE1 in VARCHAR2,
182   X_ATTRIBUTE2 in VARCHAR2,
183   X_ATTRIBUTE3 in VARCHAR2,
184   X_ATTRIBUTE4 in VARCHAR2,
185   X_ATTRIBUTE5 in VARCHAR2,
186   X_ATTRIBUTE6 in VARCHAR2,
187   X_ATTRIBUTE7 in VARCHAR2,
188   X_ATTRIBUTE8 in VARCHAR2,
189   X_ATTRIBUTE9 in VARCHAR2,
190   X_ATTRIBUTE10 in VARCHAR2,
191   X_ATTRIBUTE11 in VARCHAR2,
192   X_ATTRIBUTE12 in VARCHAR2,
193   X_ATTRIBUTE13 in VARCHAR2,
194   X_ATTRIBUTE14 in VARCHAR2,
195   X_ATTRIBUTE15 in VARCHAR2,
196   X_ATTRIBUTE16 in VARCHAR2,
197   X_ATTRIBUTE17 in VARCHAR2,
198   X_ATTRIBUTE18 in VARCHAR2,
199   X_ATTRIBUTE19 in VARCHAR2,
200   X_ATTRIBUTE20 in VARCHAR2,
201   X_ATTRIBUTE21 in VARCHAR2,
202   X_ATTRIBUTE22 in VARCHAR2,
203   X_ATTRIBUTE23 in VARCHAR2,
204   X_ATTRIBUTE24 in VARCHAR2,
205   X_ATTRIBUTE25 in VARCHAR2,
206   X_ATTRIBUTE26 in VARCHAR2,
207   X_ATTRIBUTE27 in VARCHAR2,
208   X_ATTRIBUTE28 in VARCHAR2,
209   X_ATTRIBUTE29 in VARCHAR2,
210   X_ATTRIBUTE30 in VARCHAR2,
211   X_ATTRIBUTE_CATEGORY in VARCHAR2,
212   X_ITEM_ABCCODE in VARCHAR2,
213   X_ALLOC_CATEGORY_ID in NUMBER,
214   X_CUSTOMS_CATEGORY_ID in NUMBER,
215   X_FRT_CATEGORY_ID in NUMBER,
216   X_GL_CATEGORY_ID in NUMBER,
217   X_INV_CATEGORY_ID in NUMBER,
218   X_COST_CATEGORY_ID in NUMBER,
219   X_PURCH_CATEGORY_ID in NUMBER,
220   X_SALES_CATEGORY_ID in NUMBER,
221   X_SEQ_CATEGORY_ID in NUMBER,
222   X_SHIP_CATEGORY_ID in NUMBER,
223   X_STORAGE_CATEGORY_ID in NUMBER,
224   X_TAX_CATEGORY_ID in NUMBER,
225   X_ITEM_DESC1 in VARCHAR2,
226   X_ITEM_DESC2 in VARCHAR2,
227   X_ONT_PRICING_QTY_SOURCE in NUMBER,   -- added for pricing by qty2 project
228   X_AUTOLOT_ACTIVE_INDICATOR in NUMBER DEFAULT 0,
229   X_LOT_PREFIX in VARCHAR2 DEFAULT NULL,
230   X_LOT_SUFFIX in NUMBER DEFAULT 0,
231   X_SUBLOT_PREFIX in VARCHAR2 DEFAULT NULL,
232   X_SUBLOT_SUFFIX in NUMBER DEFAULT 0
233 );
234 procedure UPDATE_ROW (
235   X_ITEM_ID in NUMBER,
236   X_ITEM_NO in VARCHAR2,
237   X_ALT_ITEMA in VARCHAR2,
238   X_ALT_ITEMB in VARCHAR2,
239   X_ITEM_UM in VARCHAR2,
240   X_DUALUM_IND in NUMBER,
241   X_ITEM_UM2 in VARCHAR2,
242   X_DEVIATION_LO in NUMBER,
243   X_DEVIATION_HI in NUMBER,
244   X_LEVEL_CODE in NUMBER,
245   X_LOT_CTL in NUMBER,
246   X_LOT_INDIVISIBLE in NUMBER,
247   X_SUBLOT_CTL in NUMBER,
248   X_LOCT_CTL in NUMBER,
249   X_NONINV_IND in NUMBER,
250   X_MATCH_TYPE in NUMBER,
251   X_INACTIVE_IND in NUMBER,
252   X_INV_TYPE in VARCHAR2,
253   X_SHELF_LIFE in NUMBER,
254   X_RETEST_INTERVAL in NUMBER,
255   X_GL_CLASS in VARCHAR2,
256   X_INV_CLASS in VARCHAR2,
257   X_SALES_CLASS in VARCHAR2,
258   X_SHIP_CLASS in VARCHAR2,
259   X_FRT_CLASS in VARCHAR2,
260   X_PRICE_CLASS in VARCHAR2,
261   X_STORAGE_CLASS in VARCHAR2,
262   X_PURCH_CLASS in VARCHAR2,
263   X_TAX_CLASS in VARCHAR2,
264   X_CUSTOMS_CLASS in VARCHAR2,
265   X_ALLOC_CLASS in VARCHAR2,
266   X_PLANNING_CLASS in VARCHAR2,
267   X_ITEMCOST_CLASS in VARCHAR2,
268   X_COST_MTHD_CODE in VARCHAR2,
269   X_UPC_CODE in VARCHAR2,
270   X_GRADE_CTL in NUMBER,
271   X_STATUS_CTL in NUMBER,
272   X_QC_GRADE in VARCHAR2,
273   X_LOT_STATUS in VARCHAR2,
274   X_BULK_ID in NUMBER,
275   X_PKG_ID in NUMBER,
276   X_QCITEM_ID in NUMBER,
277   X_QCHOLD_RES_CODE in VARCHAR2,
278   X_EXPACTION_CODE in VARCHAR2,
279   X_FILL_QTY in NUMBER,
280   X_FILL_UM in VARCHAR2,
281   X_PLANNING_CATEGORY_ID in NUMBER,
282   X_PRICE_CATEGORY_ID in NUMBER,
283   X_EXPACTION_INTERVAL in NUMBER,
284   X_PHANTOM_TYPE in NUMBER,
285   X_WHSE_ITEM_ID in NUMBER,
286   X_EXPERIMENTAL_IND in NUMBER,
287   X_EXPORTED_DATE in DATE,
288   X_TRANS_CNT in NUMBER,
289   X_DELETE_MARK in NUMBER,
290   X_TEXT_CODE in NUMBER,
291   X_SEQ_DPND_CLASS in VARCHAR2,
292   X_COMMODITY_CODE in VARCHAR2,
293   X_REQUEST_ID in NUMBER,
294   X_ATTRIBUTE1 in VARCHAR2,
295   X_ATTRIBUTE2 in VARCHAR2,
296   X_ATTRIBUTE3 in VARCHAR2,
297   X_ATTRIBUTE4 in VARCHAR2,
298   X_ATTRIBUTE5 in VARCHAR2,
299   X_ATTRIBUTE6 in VARCHAR2,
300   X_ATTRIBUTE7 in VARCHAR2,
301   X_ATTRIBUTE8 in VARCHAR2,
302   X_ATTRIBUTE9 in VARCHAR2,
303   X_ATTRIBUTE10 in VARCHAR2,
304   X_ATTRIBUTE11 in VARCHAR2,
305   X_ATTRIBUTE12 in VARCHAR2,
306   X_ATTRIBUTE13 in VARCHAR2,
307   X_ATTRIBUTE14 in VARCHAR2,
308   X_ATTRIBUTE15 in VARCHAR2,
309   X_ATTRIBUTE16 in VARCHAR2,
310   X_ATTRIBUTE17 in VARCHAR2,
311   X_ATTRIBUTE18 in VARCHAR2,
312   X_ATTRIBUTE19 in VARCHAR2,
313   X_ATTRIBUTE20 in VARCHAR2,
314   X_ATTRIBUTE21 in VARCHAR2,
315   X_ATTRIBUTE22 in VARCHAR2,
316   X_ATTRIBUTE23 in VARCHAR2,
317   X_ATTRIBUTE24 in VARCHAR2,
318   X_ATTRIBUTE25 in VARCHAR2,
319   X_ATTRIBUTE26 in VARCHAR2,
320   X_ATTRIBUTE27 in VARCHAR2,
321   X_ATTRIBUTE28 in VARCHAR2,
322   X_ATTRIBUTE29 in VARCHAR2,
323   X_ATTRIBUTE30 in VARCHAR2,
324   X_ATTRIBUTE_CATEGORY in VARCHAR2,
325   X_ITEM_ABCCODE in VARCHAR2,
326   X_ALLOC_CATEGORY_ID in NUMBER,
327   X_CUSTOMS_CATEGORY_ID in NUMBER,
328   X_FRT_CATEGORY_ID in NUMBER,
329   X_GL_CATEGORY_ID in NUMBER,
330   X_INV_CATEGORY_ID in NUMBER,
331   X_COST_CATEGORY_ID in NUMBER,
332   X_PURCH_CATEGORY_ID in NUMBER,
333   X_SALES_CATEGORY_ID in NUMBER,
334   X_SEQ_CATEGORY_ID in NUMBER,
335   X_SHIP_CATEGORY_ID in NUMBER,
336   X_STORAGE_CATEGORY_ID in NUMBER,
337   X_TAX_CATEGORY_ID in NUMBER,
338   X_ITEM_DESC1 in VARCHAR2,
339   X_ITEM_DESC2 in VARCHAR2,
340   X_ONT_PRICING_QTY_SOURCE in NUMBER,  -- added for pricing by qty2 project
341   X_AUTOLOT_ACTIVE_INDICATOR in NUMBER DEFAULT 0,
342   X_LOT_PREFIX in VARCHAR2 DEFAULT NULL,
343   X_LOT_SUFFIX in NUMBER DEFAULT 0,
344   X_SUBLOT_PREFIX in VARCHAR2 DEFAULT NULL,
345   X_SUBLOT_SUFFIX in NUMBER DEFAULT 0,
346   X_LAST_UPDATE_DATE in DATE,
347   X_LAST_UPDATED_BY in NUMBER,
348   X_LAST_UPDATE_LOGIN in NUMBER
349 );
350 procedure DELETE_ROW (
351   X_ITEM_ID in NUMBER
352 );
353 procedure ADD_LANGUAGE;
354 end IC_ITEM_MST_PKG;