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

Source


1 package EGO_ITEM_GTN_ATTRS_PKG AUTHID CURRENT_USER as
2 /* $Header: EGOVGTIS.pls 120.1 2005/10/14 04:51 jcgeorge noship $ */
3 procedure INSERT_ROW (
4   X_ROWID in out nocopy VARCHAR2,
5   X_EXTENSION_ID in NUMBER,
6   X_REQUEST_ID in NUMBER,
7   X_DELIVERY_TO_MRKT_TEMP_MIN in NUMBER,
8   X_UOM_DELIVERY_TO_MRKT_TEMP_MI in VARCHAR2,
9   X_SUB_BRAND in VARCHAR2,
10   X_UOM_DEL_TO_DIST_CNTR_TEMP_MI in VARCHAR2,
11   X_DELIVERY_TO_MRKT_TEMP_MAX in NUMBER,
12   X_UOM_DELIVERY_TO_MRKT_TEMP_MA in VARCHAR2,
13   X_INVENTORY_ITEM_ID in NUMBER,
14   X_ORGANIZATION_ID in NUMBER,
15   X_ITEM_CATALOG_GROUP_ID in NUMBER,
16   X_REVISION_ID in NUMBER,
17   X_IS_TRADE_ITEM_A_CONSUMER_UNI in VARCHAR2,
18   X_IS_TRADE_ITEM_INFO_PRIVATE in VARCHAR2,
19   X_GROSS_WEIGHT in NUMBER,
20   X_UOM_GROSS_WEIGHT in VARCHAR2,
21   X_EFFECTIVE_DATE in DATE,
22   X_CANCELED_DATE in DATE,
23   X_DISCONTINUED_DATE in DATE,
24   X_END_AVAILABILITY_DATE_TIME in DATE,
25   X_START_AVAILABILITY_DATE_TIME in DATE,
26   X_BRAND_NAME in VARCHAR2,
27   X_IS_TRADE_ITEM_A_BASE_UNIT in VARCHAR2,
28   X_IS_TRADE_ITEM_A_VARIABLE_UNI in VARCHAR2,
29   X_IS_PACK_MARKED_WITH_EXP_DATE in VARCHAR2,
30   X_IS_PACK_MARKED_WITH_GREEN_DO in VARCHAR2,
31   X_IS_PACK_MARKED_WITH_INGRED in VARCHAR2,
32   X_IS_PACKAGE_MARKED_AS_REC in VARCHAR2,
33   X_IS_PACKAGE_MARKED_RET in VARCHAR2,
34   X_STACKING_FACTOR in NUMBER,
35   X_STACKING_WEIGHT_MAXIMUM in NUMBER,
36   X_UOM_STACKING_WEIGHT_MAXIMUM in VARCHAR2,
37   X_ORDERING_LEAD_TIME in NUMBER,
38   X_UOM_ORDERING_LEAD_TIME in VARCHAR2,
39   X_ORDER_QUANTITY_MAX in NUMBER,
40   X_ORDER_QUANTITY_MIN in NUMBER,
41   X_ORDER_QUANTITY_MULTIPLE in NUMBER,
42   X_ORDER_SIZING_FACTOR in NUMBER,
43   X_EFFECTIVE_START_DATE in DATE,
44   X_CATALOG_PRICE in NUMBER,
45   X_EFFECTIVE_END_DATE in DATE,
46   X_SUGGESTED_RETAIL_PRICE in NUMBER,
47   X_MATERIAL_SAFETY_DATA_SHEET_N in VARCHAR2,
48   X_HAS_BATCH_NUMBER in VARCHAR2,
49   X_IS_NON_SOLD_TRADE_RET_FLAG in VARCHAR2,
50   X_IS_TRADE_ITEM_MAR_REC_FLAG in VARCHAR2,
51   X_DIAMETER in NUMBER,
52   X_UOM_DIAMETER in VARCHAR2,
53   X_DRAINED_WEIGHT in NUMBER,
54   X_UOM_DRAINED_WEIGHT in VARCHAR2,
55   X_GENERIC_INGREDIENT in VARCHAR2,
56   X_GENERIC_INGREDIENT_STRGTH in NUMBER,
57   X_UOM_GENERIC_INGREDIENT_STRGT in VARCHAR2,
58   X_INGREDIENT_STRENGTH in VARCHAR2,
59   X_IS_NET_CONTENT_DEC_FLAG in VARCHAR2,
60   X_NET_CONTENT in NUMBER,
61   X_UOM_NET_CONTENT in VARCHAR2,
62   X_PEG_HORIZONTAL in NUMBER,
63   X_UOM_PEG_HORIZONTAL in VARCHAR2,
64   X_PEG_VERTICAL in NUMBER,
65   X_UOM_PEG_VERTICAL in VARCHAR2,
66   X_CONSUMER_AVAIL_DATE_TIME in DATE,
67   X_DEL_TO_DIST_CNTR_TEMP_MAX in NUMBER,
68   X_UOM_DEL_TO_DIST_CNTR_TEMP_MA in VARCHAR2,
69   X_DEL_TO_DIST_CNTR_TEMP_MIN in NUMBER,
70   X_TRADE_ITEM_DESCRIPTOR in VARCHAR2,
71   X_EANUCC_CODE in VARCHAR2,
72   X_EANUCC_TYPE in VARCHAR2,
73   X_RETAIL_PRICE_ON_TRADE_ITEM in NUMBER,
74   X_QUANTITY_OF_COMP_LAY_ITEM in NUMBER,
75   X_QUANITY_OF_ITEM_IN_LAYER in NUMBER,
76   X_QUANTITY_OF_ITEM_INNER_PACK in NUMBER,
77   X_TARGET_MARKET_DESC in VARCHAR2,
78   X_QUANTITY_OF_INNER_PACK in NUMBER,
79   X_BRAND_OWNER_GLN in VARCHAR2,
80   X_BRAND_OWNER_NAME in VARCHAR2,
81   X_STORAGE_HANDLING_TEMP_MAX in NUMBER,
82   X_UOM_STORAGE_HANDLING_TEMP_MA in VARCHAR2,
83   X_STORAGE_HANDLING_TEMP_MIN in NUMBER,
84   X_UOM_STORAGE_HANDLING_TEMP_MI in VARCHAR2,
85   X_TRADE_ITEM_COUPON in NUMBER,
86   X_DEGREE_OF_ORIGINAL_WORT in VARCHAR2,
87   X_FAT_PERCENT_IN_DRY_MATTER in NUMBER,
88   X_PERCENT_OF_ALCOHOL_BY_VOL in NUMBER,
89   X_ISBN_NUMBER in VARCHAR2,
90   X_ISSN_NUMBER in VARCHAR2,
91   X_IS_INGREDIENT_IRRADIATED in VARCHAR2,
92   X_IS_RAW_MATERIAL_IRRADIATED in VARCHAR2,
93   X_IS_TRADE_ITEM_GENETICALLY_MO in VARCHAR2,
94   X_IS_TRADE_ITEM_IRRADIATED in VARCHAR2,
95   X_PUBLICATION_STATUS in NUMBER,
96   X_TOP_GTIN in VARCHAR2,
97   X_SECURITY_TAG_LOCATION in VARCHAR2,
98   X_URL_FOR_WARRANTY in VARCHAR2,
99   X_NESTING_INCREMENT in NUMBER,
100   X_UOM_NESTING_INCREMENT in VARCHAR2,
101   X_IS_TRADE_ITEM_RECALLED in VARCHAR2,
102   X_MODEL_NUMBER in VARCHAR2,
103   X_PIECES_PER_TRADE_ITEM in NUMBER,
104   X_UOM_PIECES_PER_TRADE_ITEM in VARCHAR2,
105   X_DEPT_OF_TRNSPRT_DANG_GOODS_N in VARCHAR2,
106   X_RETURN_GOODS_POLICY in VARCHAR2,
107   X_IS_OUT_OF_BOX_PROVIDED in VARCHAR2,
108   X_REGISTRATION_UPDATE_DATE in DATE,
109   X_TP_NEUTRAL_UPDATE_DATE in DATE,
110   X_IS_BARCODE_SYMBOLOGY_DERIVAB in VARCHAR2,
111   X_INVOICE_NAME in VARCHAR2,
112   X_DESCRIPTIVE_SIZE in VARCHAR2,
113   X_FUNCTIONAL_NAME in VARCHAR2,
114   X_TRADE_ITEM_FORM_DESCRIPTION in VARCHAR2,
115   X_WARRANTY_DESCRIPTION in VARCHAR2,
116   X_TRADE_ITEM_FINISH_DESCRIPTIO in VARCHAR2,
117   X_DESCRIPTION_SHORT in VARCHAR2,
118   X_CREATION_DATE in DATE,
119   X_CREATED_BY in NUMBER,
120   X_LAST_UPDATE_DATE in DATE,
121   X_LAST_UPDATED_BY in NUMBER,
122   X_LAST_UPDATE_LOGIN in NUMBER);
123 procedure LOCK_ROW (
124   X_EXTENSION_ID in NUMBER,
125   X_REQUEST_ID in NUMBER,
126   X_DELIVERY_TO_MRKT_TEMP_MIN in NUMBER,
127   X_UOM_DELIVERY_TO_MRKT_TEMP_MI in VARCHAR2,
128   X_SUB_BRAND in VARCHAR2,
129   X_UOM_DEL_TO_DIST_CNTR_TEMP_MI in VARCHAR2,
130   X_DELIVERY_TO_MRKT_TEMP_MAX in NUMBER,
131   X_UOM_DELIVERY_TO_MRKT_TEMP_MA in VARCHAR2,
132   X_INVENTORY_ITEM_ID in NUMBER,
133   X_ORGANIZATION_ID in NUMBER,
134   X_ITEM_CATALOG_GROUP_ID in NUMBER,
135   X_REVISION_ID in NUMBER,
136   X_IS_TRADE_ITEM_A_CONSUMER_UNI in VARCHAR2,
137   X_IS_TRADE_ITEM_INFO_PRIVATE in VARCHAR2,
138   X_GROSS_WEIGHT in NUMBER,
139   X_UOM_GROSS_WEIGHT in VARCHAR2,
140   X_EFFECTIVE_DATE in DATE,
141   X_CANCELED_DATE in DATE,
142   X_DISCONTINUED_DATE in DATE,
143   X_END_AVAILABILITY_DATE_TIME in DATE,
144   X_START_AVAILABILITY_DATE_TIME in DATE,
145   X_BRAND_NAME in VARCHAR2,
146   X_IS_TRADE_ITEM_A_BASE_UNIT in VARCHAR2,
147   X_IS_TRADE_ITEM_A_VARIABLE_UNI in VARCHAR2,
148   X_IS_PACK_MARKED_WITH_EXP_DATE in VARCHAR2,
149   X_IS_PACK_MARKED_WITH_GREEN_DO in VARCHAR2,
150   X_IS_PACK_MARKED_WITH_INGRED in VARCHAR2,
151   X_IS_PACKAGE_MARKED_AS_REC in VARCHAR2,
152   X_IS_PACKAGE_MARKED_RET in VARCHAR2,
153   X_STACKING_FACTOR in NUMBER,
154   X_STACKING_WEIGHT_MAXIMUM in NUMBER,
155   X_UOM_STACKING_WEIGHT_MAXIMUM in VARCHAR2,
156   X_ORDERING_LEAD_TIME in NUMBER,
157   X_UOM_ORDERING_LEAD_TIME in VARCHAR2,
158   X_ORDER_QUANTITY_MAX in NUMBER,
159   X_ORDER_QUANTITY_MIN in NUMBER,
160   X_ORDER_QUANTITY_MULTIPLE in NUMBER,
161   X_ORDER_SIZING_FACTOR in NUMBER,
162   X_EFFECTIVE_START_DATE in DATE,
163   X_CATALOG_PRICE in NUMBER,
164   X_EFFECTIVE_END_DATE in DATE,
165   X_SUGGESTED_RETAIL_PRICE in NUMBER,
166   X_MATERIAL_SAFETY_DATA_SHEET_N in VARCHAR2,
167   X_HAS_BATCH_NUMBER in VARCHAR2,
168   X_IS_NON_SOLD_TRADE_RET_FLAG in VARCHAR2,
169   X_IS_TRADE_ITEM_MAR_REC_FLAG in VARCHAR2,
170   X_DIAMETER in NUMBER,
171   X_UOM_DIAMETER in VARCHAR2,
172   X_DRAINED_WEIGHT in NUMBER,
173   X_UOM_DRAINED_WEIGHT in VARCHAR2,
174   X_GENERIC_INGREDIENT in VARCHAR2,
175   X_GENERIC_INGREDIENT_STRGTH in NUMBER,
176   X_UOM_GENERIC_INGREDIENT_STRGT in VARCHAR2,
177   X_INGREDIENT_STRENGTH in VARCHAR2,
178   X_IS_NET_CONTENT_DEC_FLAG in VARCHAR2,
179   X_NET_CONTENT in NUMBER,
180   X_UOM_NET_CONTENT in VARCHAR2,
181   X_PEG_HORIZONTAL in NUMBER,
182   X_UOM_PEG_HORIZONTAL in VARCHAR2,
183   X_PEG_VERTICAL in NUMBER,
184   X_UOM_PEG_VERTICAL in VARCHAR2,
185   X_CONSUMER_AVAIL_DATE_TIME in DATE,
186   X_DEL_TO_DIST_CNTR_TEMP_MAX in NUMBER,
187   X_UOM_DEL_TO_DIST_CNTR_TEMP_MA in VARCHAR2,
188   X_DEL_TO_DIST_CNTR_TEMP_MIN in NUMBER,
189   X_TRADE_ITEM_DESCRIPTOR in VARCHAR2,
190   X_EANUCC_CODE in VARCHAR2,
191   X_EANUCC_TYPE in VARCHAR2,
192   X_RETAIL_PRICE_ON_TRADE_ITEM in NUMBER,
193   X_QUANTITY_OF_COMP_LAY_ITEM in NUMBER,
194   X_QUANITY_OF_ITEM_IN_LAYER in NUMBER,
195   X_QUANTITY_OF_ITEM_INNER_PACK in NUMBER,
196   X_TARGET_MARKET_DESC in VARCHAR2,
197   X_QUANTITY_OF_INNER_PACK in NUMBER,
198   X_BRAND_OWNER_GLN in VARCHAR2,
199   X_BRAND_OWNER_NAME in VARCHAR2,
200   X_STORAGE_HANDLING_TEMP_MAX in NUMBER,
201   X_UOM_STORAGE_HANDLING_TEMP_MA in VARCHAR2,
202   X_STORAGE_HANDLING_TEMP_MIN in NUMBER,
203   X_UOM_STORAGE_HANDLING_TEMP_MI in VARCHAR2,
204   X_TRADE_ITEM_COUPON in NUMBER,
205   X_DEGREE_OF_ORIGINAL_WORT in VARCHAR2,
206   X_FAT_PERCENT_IN_DRY_MATTER in NUMBER,
207   X_PERCENT_OF_ALCOHOL_BY_VOL in NUMBER,
208   X_ISBN_NUMBER in VARCHAR2,
209   X_ISSN_NUMBER in VARCHAR2,
210   X_IS_INGREDIENT_IRRADIATED in VARCHAR2,
211   X_IS_RAW_MATERIAL_IRRADIATED in VARCHAR2,
212   X_IS_TRADE_ITEM_GENETICALLY_MO in VARCHAR2,
213   X_IS_TRADE_ITEM_IRRADIATED in VARCHAR2,
214   X_PUBLICATION_STATUS in NUMBER,
215   X_TOP_GTIN in VARCHAR2,
216   X_SECURITY_TAG_LOCATION in VARCHAR2,
217   X_URL_FOR_WARRANTY in VARCHAR2,
218   X_NESTING_INCREMENT in NUMBER,
219   X_UOM_NESTING_INCREMENT in VARCHAR2,
220   X_IS_TRADE_ITEM_RECALLED in VARCHAR2,
221   X_MODEL_NUMBER in VARCHAR2,
222   X_PIECES_PER_TRADE_ITEM in NUMBER,
223   X_UOM_PIECES_PER_TRADE_ITEM in VARCHAR2,
224   X_DEPT_OF_TRNSPRT_DANG_GOODS_N in VARCHAR2,
225   X_RETURN_GOODS_POLICY in VARCHAR2,
226   X_IS_OUT_OF_BOX_PROVIDED in VARCHAR2,
227   X_REGISTRATION_UPDATE_DATE in DATE,
228   X_TP_NEUTRAL_UPDATE_DATE in DATE,
229   X_IS_BARCODE_SYMBOLOGY_DERIVAB in VARCHAR2,
230   X_INVOICE_NAME in VARCHAR2,
231   X_DESCRIPTIVE_SIZE in VARCHAR2,
232   X_FUNCTIONAL_NAME in VARCHAR2,
233   X_TRADE_ITEM_FORM_DESCRIPTION in VARCHAR2,
234   X_WARRANTY_DESCRIPTION in VARCHAR2,
235   X_TRADE_ITEM_FINISH_DESCRIPTIO in VARCHAR2,
236   X_DESCRIPTION_SHORT in VARCHAR2
237 );
238 procedure UPDATE_ROW (
239   X_EXTENSION_ID in NUMBER,
240   X_REQUEST_ID in NUMBER,
241   X_DELIVERY_TO_MRKT_TEMP_MIN in NUMBER,
242   X_UOM_DELIVERY_TO_MRKT_TEMP_MI in VARCHAR2,
243   X_SUB_BRAND in VARCHAR2,
244   X_UOM_DEL_TO_DIST_CNTR_TEMP_MI in VARCHAR2,
245   X_DELIVERY_TO_MRKT_TEMP_MAX in NUMBER,
246   X_UOM_DELIVERY_TO_MRKT_TEMP_MA in VARCHAR2,
247   X_INVENTORY_ITEM_ID in NUMBER,
248   X_ORGANIZATION_ID in NUMBER,
249   X_ITEM_CATALOG_GROUP_ID in NUMBER,
250   X_REVISION_ID in NUMBER,
251   X_IS_TRADE_ITEM_A_CONSUMER_UNI in VARCHAR2,
252   X_IS_TRADE_ITEM_INFO_PRIVATE in VARCHAR2,
253   X_GROSS_WEIGHT in NUMBER,
254   X_UOM_GROSS_WEIGHT in VARCHAR2,
255   X_EFFECTIVE_DATE in DATE,
256   X_CANCELED_DATE in DATE,
257   X_DISCONTINUED_DATE in DATE,
258   X_END_AVAILABILITY_DATE_TIME in DATE,
259   X_START_AVAILABILITY_DATE_TIME in DATE,
260   X_BRAND_NAME in VARCHAR2,
261   X_IS_TRADE_ITEM_A_BASE_UNIT in VARCHAR2,
262   X_IS_TRADE_ITEM_A_VARIABLE_UNI in VARCHAR2,
263   X_IS_PACK_MARKED_WITH_EXP_DATE in VARCHAR2,
264   X_IS_PACK_MARKED_WITH_GREEN_DO in VARCHAR2,
265   X_IS_PACK_MARKED_WITH_INGRED in VARCHAR2,
266   X_IS_PACKAGE_MARKED_AS_REC in VARCHAR2,
267   X_IS_PACKAGE_MARKED_RET in VARCHAR2,
268   X_STACKING_FACTOR in NUMBER,
269   X_STACKING_WEIGHT_MAXIMUM in NUMBER,
270   X_UOM_STACKING_WEIGHT_MAXIMUM in VARCHAR2,
271   X_ORDERING_LEAD_TIME in NUMBER,
272   X_UOM_ORDERING_LEAD_TIME in VARCHAR2,
273   X_ORDER_QUANTITY_MAX in NUMBER,
274   X_ORDER_QUANTITY_MIN in NUMBER,
275   X_ORDER_QUANTITY_MULTIPLE in NUMBER,
276   X_ORDER_SIZING_FACTOR in NUMBER,
277   X_EFFECTIVE_START_DATE in DATE,
278   X_CATALOG_PRICE in NUMBER,
279   X_EFFECTIVE_END_DATE in DATE,
280   X_SUGGESTED_RETAIL_PRICE in NUMBER,
281   X_MATERIAL_SAFETY_DATA_SHEET_N in VARCHAR2,
282   X_HAS_BATCH_NUMBER in VARCHAR2,
283   X_IS_NON_SOLD_TRADE_RET_FLAG in VARCHAR2,
284   X_IS_TRADE_ITEM_MAR_REC_FLAG in VARCHAR2,
285   X_DIAMETER in NUMBER,
286   X_UOM_DIAMETER in VARCHAR2,
287   X_DRAINED_WEIGHT in NUMBER,
288   X_UOM_DRAINED_WEIGHT in VARCHAR2,
289   X_GENERIC_INGREDIENT in VARCHAR2,
290   X_GENERIC_INGREDIENT_STRGTH in NUMBER,
291   X_UOM_GENERIC_INGREDIENT_STRGT in VARCHAR2,
292   X_INGREDIENT_STRENGTH in VARCHAR2,
293   X_IS_NET_CONTENT_DEC_FLAG in VARCHAR2,
294   X_NET_CONTENT in NUMBER,
295   X_UOM_NET_CONTENT in VARCHAR2,
296   X_PEG_HORIZONTAL in NUMBER,
297   X_UOM_PEG_HORIZONTAL in VARCHAR2,
298   X_PEG_VERTICAL in NUMBER,
299   X_UOM_PEG_VERTICAL in VARCHAR2,
300   X_CONSUMER_AVAIL_DATE_TIME in DATE,
301   X_DEL_TO_DIST_CNTR_TEMP_MAX in NUMBER,
302   X_UOM_DEL_TO_DIST_CNTR_TEMP_MA in VARCHAR2,
303   X_DEL_TO_DIST_CNTR_TEMP_MIN in NUMBER,
304   X_TRADE_ITEM_DESCRIPTOR in VARCHAR2,
305   X_EANUCC_CODE in VARCHAR2,
306   X_EANUCC_TYPE in VARCHAR2,
307   X_RETAIL_PRICE_ON_TRADE_ITEM in NUMBER,
308   X_QUANTITY_OF_COMP_LAY_ITEM in NUMBER,
309   X_QUANITY_OF_ITEM_IN_LAYER in NUMBER,
310   X_QUANTITY_OF_ITEM_INNER_PACK in NUMBER,
311   X_TARGET_MARKET_DESC in VARCHAR2,
312   X_QUANTITY_OF_INNER_PACK in NUMBER,
313   X_BRAND_OWNER_GLN in VARCHAR2,
314   X_BRAND_OWNER_NAME in VARCHAR2,
315   X_STORAGE_HANDLING_TEMP_MAX in NUMBER,
316   X_UOM_STORAGE_HANDLING_TEMP_MA in VARCHAR2,
317   X_STORAGE_HANDLING_TEMP_MIN in NUMBER,
318   X_UOM_STORAGE_HANDLING_TEMP_MI in VARCHAR2,
319   X_TRADE_ITEM_COUPON in NUMBER,
320   X_DEGREE_OF_ORIGINAL_WORT in VARCHAR2,
321   X_FAT_PERCENT_IN_DRY_MATTER in NUMBER,
322   X_PERCENT_OF_ALCOHOL_BY_VOL in NUMBER,
323   X_ISBN_NUMBER in VARCHAR2,
324   X_ISSN_NUMBER in VARCHAR2,
325   X_IS_INGREDIENT_IRRADIATED in VARCHAR2,
326   X_IS_RAW_MATERIAL_IRRADIATED in VARCHAR2,
327   X_IS_TRADE_ITEM_GENETICALLY_MO in VARCHAR2,
328   X_IS_TRADE_ITEM_IRRADIATED in VARCHAR2,
329   X_PUBLICATION_STATUS in NUMBER,
330   X_TOP_GTIN in VARCHAR2,
331   X_SECURITY_TAG_LOCATION in VARCHAR2,
332   X_URL_FOR_WARRANTY in VARCHAR2,
333   X_NESTING_INCREMENT in NUMBER,
334   X_UOM_NESTING_INCREMENT in VARCHAR2,
335   X_IS_TRADE_ITEM_RECALLED in VARCHAR2,
336   X_MODEL_NUMBER in VARCHAR2,
337   X_PIECES_PER_TRADE_ITEM in NUMBER,
338   X_UOM_PIECES_PER_TRADE_ITEM in VARCHAR2,
339   X_DEPT_OF_TRNSPRT_DANG_GOODS_N in VARCHAR2,
340   X_RETURN_GOODS_POLICY in VARCHAR2,
341   X_IS_OUT_OF_BOX_PROVIDED in VARCHAR2,
342   X_REGISTRATION_UPDATE_DATE in DATE,
343   X_TP_NEUTRAL_UPDATE_DATE in DATE,
344   X_IS_BARCODE_SYMBOLOGY_DERIVAB in VARCHAR2,
345   X_INVOICE_NAME in VARCHAR2,
346   X_DESCRIPTIVE_SIZE in VARCHAR2,
347   X_FUNCTIONAL_NAME in VARCHAR2,
348   X_TRADE_ITEM_FORM_DESCRIPTION in VARCHAR2,
352   X_LAST_UPDATE_DATE in DATE,
349   X_WARRANTY_DESCRIPTION in VARCHAR2,
350   X_TRADE_ITEM_FINISH_DESCRIPTIO in VARCHAR2,
351   X_DESCRIPTION_SHORT in VARCHAR2,
353   X_LAST_UPDATED_BY in NUMBER,
354   X_LAST_UPDATE_LOGIN in NUMBER
355 );
356 procedure DELETE_ROW (
357   X_EXTENSION_ID in NUMBER
358 );
359 procedure ADD_LANGUAGE;
360 end EGO_ITEM_GTN_ATTRS_PKG;