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

Source


1 package MTL_TRANSACTION_LOTS_INTF_pkg as
2 /* $Header: INVMTLIS.pls 120.1 2005/10/18 18:38:48 cjandhya noship $ */
3 procedure INSERT_ROW (
4   X_ROWID in out nocopy ROWID,
5   X_TRANSACTION_INTERFACE_ID in NUMBER,
6   X_EXPIRATION_ACTION_CODE in VARCHAR2,
7   X_EXPIRATION_ACTION_DATE in DATE,
8   X_HOLD_DATE in DATE,
9   X_ORIGINATION_TYPE in NUMBER,
10   X_PARENT_LOT_NUMBER in VARCHAR2,
11   X_REASON_ID in NUMBER,
12   X_SOURCE_CODE in VARCHAR2,
13   X_SOURCE_LINE_ID in NUMBER,
14   X_REQUEST_ID in NUMBER,
15   X_LOT_EXPIRATION_DATE in DATE,
16   X_TRANSACTION_QUANTITY in NUMBER,
17   X_PRIMARY_QUANTITY in NUMBER,
18   X_SERIAL_TRANSACTION_TEMP_ID in NUMBER,
19   X_ERROR_CODE in VARCHAR2,
20   X_PROCESS_FLAG in VARCHAR2,
21   X_DESCRIPTION in VARCHAR2,
22   X_VENDOR_NAME in VARCHAR2,
23   X_SUPPLIER_LOT_NUMBER in VARCHAR2,
24   X_ORIGINATION_DATE in DATE,
25   X_DATE_CODE in VARCHAR2,
26   X_GRADE_CODE in VARCHAR2,
27   X_CHANGE_DATE in DATE,
28   X_MATURITY_DATE in DATE,
29   X_STATUS_ID in NUMBER,
30   X_RETEST_DATE in DATE,
31   X_AGE in NUMBER,
32   X_ITEM_SIZE in NUMBER,
33   X_COLOR in VARCHAR2,
34   X_VOLUME in NUMBER,
35   X_VOLUME_UOM in VARCHAR2,
36   X_PLACE_OF_ORIGIN in VARCHAR2,
37   X_BEST_BY_DATE in DATE,
38   X_LENGTH in NUMBER,
39   X_LENGTH_UOM in VARCHAR2,
40   X_RECYCLED_CONTENT in NUMBER,
41   X_THICKNESS in NUMBER,
42   X_THICKNESS_UOM in VARCHAR2,
43   X_WIDTH in NUMBER,
44   X_WIDTH_UOM in VARCHAR2,
45   X_CURL_WRINKLE_FOLD in VARCHAR2,
46   X_LOT_ATTRIBUTE_CATEGORY in VARCHAR2,
47   X_C_ATTRIBUTE1 in VARCHAR2,
48   X_C_ATTRIBUTE2 in VARCHAR2,
49   X_C_ATTRIBUTE3 in VARCHAR2,
50   X_C_ATTRIBUTE4 in VARCHAR2,
51   X_C_ATTRIBUTE5 in VARCHAR2,
52   X_C_ATTRIBUTE6 in VARCHAR2,
53   X_C_ATTRIBUTE7 in VARCHAR2,
54   X_C_ATTRIBUTE8 in VARCHAR2,
55   X_C_ATTRIBUTE9 in VARCHAR2,
56   X_C_ATTRIBUTE10 in VARCHAR2,
57   X_C_ATTRIBUTE11 in VARCHAR2,
58   X_C_ATTRIBUTE12 in VARCHAR2,
59   X_C_ATTRIBUTE13 in VARCHAR2,
60   X_C_ATTRIBUTE14 in VARCHAR2,
61   X_C_ATTRIBUTE15 in VARCHAR2,
62   X_C_ATTRIBUTE16 in VARCHAR2,
63   X_C_ATTRIBUTE17 in VARCHAR2,
64   X_C_ATTRIBUTE18 in VARCHAR2,
65   X_C_ATTRIBUTE19 in VARCHAR2,
66   X_C_ATTRIBUTE20 in VARCHAR2,
67   X_D_ATTRIBUTE1 in DATE,
68   X_D_ATTRIBUTE2 in DATE,
69   X_D_ATTRIBUTE3 in DATE,
70   X_D_ATTRIBUTE4 in DATE,
71   X_D_ATTRIBUTE5 in DATE,
72   X_D_ATTRIBUTE6 in DATE,
73   X_D_ATTRIBUTE7 in DATE,
77   X_N_ATTRIBUTE1 in NUMBER,
74   X_D_ATTRIBUTE8 in DATE,
75   X_D_ATTRIBUTE9 in DATE,
76   X_D_ATTRIBUTE10 in DATE,
78   X_N_ATTRIBUTE2 in NUMBER,
79   X_N_ATTRIBUTE3 in NUMBER,
80   X_N_ATTRIBUTE4 in NUMBER,
81   X_N_ATTRIBUTE5 in NUMBER,
82   X_N_ATTRIBUTE6 in NUMBER,
83   X_N_ATTRIBUTE7 in NUMBER,
84   X_N_ATTRIBUTE8 in NUMBER,
85   X_N_ATTRIBUTE9 in NUMBER,
86   X_N_ATTRIBUTE10 in NUMBER,
87   X_VENDOR_ID in NUMBER,
88   X_TERRITORY_CODE in VARCHAR2,
89   X_PRODUCT_CODE in VARCHAR2,
90   X_PRODUCT_TRANSACTION_ID in NUMBER,
91   X_SECONDARY_TRANSACTION_QUANTI in NUMBER,
92   X_SUBLOT_NUM in VARCHAR2,
93   X_REASON_CODE in VARCHAR2,
94   X_ATTRIBUTE_CATEGORY in VARCHAR2,
95   X_ATTRIBUTE1 in VARCHAR2,
96   X_ATTRIBUTE2 in VARCHAR2,
97   X_ATTRIBUTE3 in VARCHAR2,
98   X_ATTRIBUTE4 in VARCHAR2,
99   X_ATTRIBUTE5 in VARCHAR2,
100   X_ATTRIBUTE6 in VARCHAR2,
101   X_ATTRIBUTE7 in VARCHAR2,
102   X_ATTRIBUTE8 in VARCHAR2,
106   X_ATTRIBUTE12 in VARCHAR2,
103   X_ATTRIBUTE9 in VARCHAR2,
104   X_ATTRIBUTE10 in VARCHAR2,
105   X_ATTRIBUTE11 in VARCHAR2,
107   X_ATTRIBUTE13 in VARCHAR2,
108   X_ATTRIBUTE14 in VARCHAR2,
109   X_ATTRIBUTE15 in VARCHAR2,
110   X_LOT_NUMBER in VARCHAR2,
111   X_CREATION_DATE in DATE,
112   X_CREATED_BY in NUMBER,
113   X_LAST_UPDATE_DATE in DATE,
114   X_LAST_UPDATED_BY in NUMBER,
115   X_LAST_UPDATE_LOGIN in NUMBER,
116   X_PARENT_OBJECT_TYPE IN NUMBER,
117   X_PARENT_OBJECT_ID IN NUMBER,
118   X_PARENT_OBJECT_NUMBER IN VARCHAR2,
119   X_PARENT_OBJECT_TYPE2 IN NUMBER,
120   X_PARENT_OBJECT_ID2 IN NUMBER,
121   X_PARENT_OBJECT_NUMBER2 IN VARCHAR2,
122   X_PARENT_ITEM_ID IN NUMBER);
123 procedure LOCK_ROW (
124   X_ROWID IN ROWID,
125   X_TRANSACTION_INTERFACE_ID in NUMBER,
126   X_EXPIRATION_ACTION_CODE in VARCHAR2,
127   X_EXPIRATION_ACTION_DATE in DATE,
128   X_HOLD_DATE in DATE,
129   X_ORIGINATION_TYPE in NUMBER,
130   X_PARENT_LOT_NUMBER in VARCHAR2,
131   X_REASON_ID in NUMBER,
132   X_SOURCE_CODE in VARCHAR2,
133   X_SOURCE_LINE_ID in NUMBER,
134   X_REQUEST_ID in NUMBER,
135   X_LOT_EXPIRATION_DATE in DATE,
136   X_TRANSACTION_QUANTITY in NUMBER,
137   X_PRIMARY_QUANTITY in NUMBER,
138   X_SERIAL_TRANSACTION_TEMP_ID in NUMBER,
142   X_VENDOR_NAME in VARCHAR2,
139   X_ERROR_CODE in VARCHAR2,
140   X_PROCESS_FLAG in VARCHAR2,
141   X_DESCRIPTION in VARCHAR2,
143   X_SUPPLIER_LOT_NUMBER in VARCHAR2,
144   X_ORIGINATION_DATE in DATE,
145   X_DATE_CODE in VARCHAR2,
146   X_GRADE_CODE in VARCHAR2,
147   X_CHANGE_DATE in DATE,
148   X_MATURITY_DATE in DATE,
149   X_STATUS_ID in NUMBER,
150   X_RETEST_DATE in DATE,
151   X_AGE in NUMBER,
152   X_ITEM_SIZE in NUMBER,
153   X_COLOR in VARCHAR2,
154   X_VOLUME in NUMBER,
155   X_VOLUME_UOM in VARCHAR2,
156   X_PLACE_OF_ORIGIN in VARCHAR2,
157   X_BEST_BY_DATE in DATE,
158   X_LENGTH in NUMBER,
159   X_LENGTH_UOM in VARCHAR2,
160   X_RECYCLED_CONTENT in NUMBER,
161   X_THICKNESS in NUMBER,
162   X_THICKNESS_UOM in VARCHAR2,
163   X_WIDTH in NUMBER,
164   X_WIDTH_UOM in VARCHAR2,
165   X_CURL_WRINKLE_FOLD in VARCHAR2,
166   X_LOT_ATTRIBUTE_CATEGORY in VARCHAR2,
167   X_C_ATTRIBUTE1 in VARCHAR2,
168   X_C_ATTRIBUTE2 in VARCHAR2,
169   X_C_ATTRIBUTE3 in VARCHAR2,
170   X_C_ATTRIBUTE4 in VARCHAR2,
171   X_C_ATTRIBUTE5 in VARCHAR2,
172   X_C_ATTRIBUTE6 in VARCHAR2,
173   X_C_ATTRIBUTE7 in VARCHAR2,
174   X_C_ATTRIBUTE8 in VARCHAR2,
178   X_C_ATTRIBUTE12 in VARCHAR2,
175   X_C_ATTRIBUTE9 in VARCHAR2,
176   X_C_ATTRIBUTE10 in VARCHAR2,
177   X_C_ATTRIBUTE11 in VARCHAR2,
179   X_C_ATTRIBUTE13 in VARCHAR2,
180   X_C_ATTRIBUTE14 in VARCHAR2,
181   X_C_ATTRIBUTE15 in VARCHAR2,
182   X_C_ATTRIBUTE16 in VARCHAR2,
183   X_C_ATTRIBUTE17 in VARCHAR2,
184   X_C_ATTRIBUTE18 in VARCHAR2,
185   X_C_ATTRIBUTE19 in VARCHAR2,
186   X_C_ATTRIBUTE20 in VARCHAR2,
187   X_D_ATTRIBUTE1 in DATE,
188   X_D_ATTRIBUTE2 in DATE,
189   X_D_ATTRIBUTE3 in DATE,
190   X_D_ATTRIBUTE4 in DATE,
191   X_D_ATTRIBUTE5 in DATE,
192   X_D_ATTRIBUTE6 in DATE,
193   X_D_ATTRIBUTE7 in DATE,
194   X_D_ATTRIBUTE8 in DATE,
195   X_D_ATTRIBUTE9 in DATE,
196   X_D_ATTRIBUTE10 in DATE,
197   X_N_ATTRIBUTE1 in NUMBER,
198   X_N_ATTRIBUTE2 in NUMBER,
199   X_N_ATTRIBUTE3 in NUMBER,
203   X_N_ATTRIBUTE7 in NUMBER,
200   X_N_ATTRIBUTE4 in NUMBER,
201   X_N_ATTRIBUTE5 in NUMBER,
202   X_N_ATTRIBUTE6 in NUMBER,
204   X_N_ATTRIBUTE8 in NUMBER,
205   X_N_ATTRIBUTE9 in NUMBER,
206   X_N_ATTRIBUTE10 in NUMBER,
207   X_VENDOR_ID in NUMBER,
208   X_TERRITORY_CODE in VARCHAR2,
209   X_PRODUCT_CODE in VARCHAR2,
210   X_PRODUCT_TRANSACTION_ID in NUMBER,
211   X_SECONDARY_TRANSACTION_QUANTI in NUMBER,
212   X_SUBLOT_NUM in VARCHAR2,
213   X_REASON_CODE in VARCHAR2,
214   X_ATTRIBUTE_CATEGORY in VARCHAR2,
215   X_ATTRIBUTE1 in VARCHAR2,
216   X_ATTRIBUTE2 in VARCHAR2,
217   X_ATTRIBUTE3 in VARCHAR2,
218   X_ATTRIBUTE4 in VARCHAR2,
219   X_ATTRIBUTE5 in VARCHAR2,
220   X_ATTRIBUTE6 in VARCHAR2,
221   X_ATTRIBUTE7 in VARCHAR2,
222   X_ATTRIBUTE8 in VARCHAR2,
223   X_ATTRIBUTE9 in VARCHAR2,
224   X_ATTRIBUTE10 in VARCHAR2,
225   X_ATTRIBUTE11 in VARCHAR2,
226   X_ATTRIBUTE12 in VARCHAR2,
227   X_ATTRIBUTE13 in VARCHAR2,
228   X_ATTRIBUTE14 in VARCHAR2,
229   X_ATTRIBUTE15 in VARCHAR2,
230   X_LOT_NUMBER in VARCHAR2,
231   X_PARENT_OBJECT_TYPE IN NUMBER,
232   X_PARENT_OBJECT_ID IN NUMBER,
236   X_PARENT_OBJECT_NUMBER2 IN VARCHAR2,
233   X_PARENT_OBJECT_NUMBER IN VARCHAR2,
234   X_PARENT_OBJECT_TYPE2 IN NUMBER,
235   X_PARENT_OBJECT_ID2 IN NUMBER,
237   X_PARENT_ITEM_ID IN NUMBER
238 );
239 procedure UPDATE_ROW (
240   X_ROWID IN ROWID,
241   X_TRANSACTION_INTERFACE_ID in NUMBER,
242   X_EXPIRATION_ACTION_CODE in VARCHAR2,
243   X_EXPIRATION_ACTION_DATE in DATE,
244   X_HOLD_DATE in DATE,
245   X_ORIGINATION_TYPE in NUMBER,
246   X_PARENT_LOT_NUMBER in VARCHAR2,
247   X_REASON_ID in NUMBER,
248   X_SOURCE_CODE in VARCHAR2,
249   X_SOURCE_LINE_ID in NUMBER,
250   X_REQUEST_ID in NUMBER,
251   X_LOT_EXPIRATION_DATE in DATE,
252   X_TRANSACTION_QUANTITY in NUMBER,
253   X_PRIMARY_QUANTITY in NUMBER,
254   X_SERIAL_TRANSACTION_TEMP_ID in NUMBER,
255   X_ERROR_CODE in VARCHAR2,
256   X_PROCESS_FLAG in VARCHAR2,
257   X_DESCRIPTION in VARCHAR2,
258   X_VENDOR_NAME in VARCHAR2,
259   X_SUPPLIER_LOT_NUMBER in VARCHAR2,
260   X_ORIGINATION_DATE in DATE,
261   X_DATE_CODE in VARCHAR2,
262   X_GRADE_CODE in VARCHAR2,
263   X_CHANGE_DATE in DATE,
264   X_MATURITY_DATE in DATE,
265   X_STATUS_ID in NUMBER,
266   X_RETEST_DATE in DATE,
267   X_AGE in NUMBER,
268   X_ITEM_SIZE in NUMBER,
269   X_COLOR in VARCHAR2,
270   X_VOLUME in NUMBER,
271   X_VOLUME_UOM in VARCHAR2,
272   X_PLACE_OF_ORIGIN in VARCHAR2,
273   X_BEST_BY_DATE in DATE,
274   X_LENGTH in NUMBER,
275   X_LENGTH_UOM in VARCHAR2,
276   X_RECYCLED_CONTENT in NUMBER,
277   X_THICKNESS in NUMBER,
278   X_THICKNESS_UOM in VARCHAR2,
279   X_WIDTH in NUMBER,
280   X_WIDTH_UOM in VARCHAR2,
281   X_CURL_WRINKLE_FOLD in VARCHAR2,
282   X_LOT_ATTRIBUTE_CATEGORY in VARCHAR2,
283   X_C_ATTRIBUTE1 in VARCHAR2,
284   X_C_ATTRIBUTE2 in VARCHAR2,
285   X_C_ATTRIBUTE3 in VARCHAR2,
286   X_C_ATTRIBUTE4 in VARCHAR2,
287   X_C_ATTRIBUTE5 in VARCHAR2,
288   X_C_ATTRIBUTE6 in VARCHAR2,
289   X_C_ATTRIBUTE7 in VARCHAR2,
290   X_C_ATTRIBUTE8 in VARCHAR2,
291   X_C_ATTRIBUTE9 in VARCHAR2,
292   X_C_ATTRIBUTE10 in VARCHAR2,
293   X_C_ATTRIBUTE11 in VARCHAR2,
294   X_C_ATTRIBUTE12 in VARCHAR2,
295   X_C_ATTRIBUTE13 in VARCHAR2,
296   X_C_ATTRIBUTE14 in VARCHAR2,
297   X_C_ATTRIBUTE15 in VARCHAR2,
298   X_C_ATTRIBUTE16 in VARCHAR2,
299   X_C_ATTRIBUTE17 in VARCHAR2,
300   X_C_ATTRIBUTE18 in VARCHAR2,
301   X_C_ATTRIBUTE19 in VARCHAR2,
302   X_C_ATTRIBUTE20 in VARCHAR2,
303   X_D_ATTRIBUTE1 in DATE,
304   X_D_ATTRIBUTE2 in DATE,
305   X_D_ATTRIBUTE3 in DATE,
306   X_D_ATTRIBUTE4 in DATE,
307   X_D_ATTRIBUTE5 in DATE,
308   X_D_ATTRIBUTE6 in DATE,
309   X_D_ATTRIBUTE7 in DATE,
310   X_D_ATTRIBUTE8 in DATE,
311   X_D_ATTRIBUTE9 in DATE,
312   X_D_ATTRIBUTE10 in DATE,
313   X_N_ATTRIBUTE1 in NUMBER,
314   X_N_ATTRIBUTE2 in NUMBER,
315   X_N_ATTRIBUTE3 in NUMBER,
316   X_N_ATTRIBUTE4 in NUMBER,
317   X_N_ATTRIBUTE5 in NUMBER,
318   X_N_ATTRIBUTE6 in NUMBER,
319   X_N_ATTRIBUTE7 in NUMBER,
320   X_N_ATTRIBUTE8 in NUMBER,
321   X_N_ATTRIBUTE9 in NUMBER,
322   X_N_ATTRIBUTE10 in NUMBER,
323   X_VENDOR_ID in NUMBER,
324   X_TERRITORY_CODE in VARCHAR2,
325   X_PRODUCT_CODE in VARCHAR2,
326   X_PRODUCT_TRANSACTION_ID in NUMBER,
327   X_SECONDARY_TRANSACTION_QUANTI in NUMBER,
328   X_SUBLOT_NUM in VARCHAR2,
329   X_REASON_CODE in VARCHAR2,
330   X_ATTRIBUTE_CATEGORY in VARCHAR2,
331   X_ATTRIBUTE1 in VARCHAR2,
332   X_ATTRIBUTE2 in VARCHAR2,
333   X_ATTRIBUTE3 in VARCHAR2,
334   X_ATTRIBUTE4 in VARCHAR2,
335   X_ATTRIBUTE5 in VARCHAR2,
336   X_ATTRIBUTE6 in VARCHAR2,
337   X_ATTRIBUTE7 in VARCHAR2,
338   X_ATTRIBUTE8 in VARCHAR2,
339   X_ATTRIBUTE9 in VARCHAR2,
340   X_ATTRIBUTE10 in VARCHAR2,
341   X_ATTRIBUTE11 in VARCHAR2,
342   X_ATTRIBUTE12 in VARCHAR2,
343   X_ATTRIBUTE13 in VARCHAR2,
344   X_ATTRIBUTE14 in VARCHAR2,
345   X_ATTRIBUTE15 in VARCHAR2,
346   X_LOT_NUMBER in VARCHAR2,
347   X_LAST_UPDATE_DATE in DATE,
348   X_LAST_UPDATED_BY in NUMBER,
349   X_LAST_UPDATE_LOGIN in NUMBER,
350   X_PARENT_OBJECT_TYPE IN NUMBER,
351   X_PARENT_OBJECT_ID IN NUMBER,
352   X_PARENT_OBJECT_NUMBER IN VARCHAR2,
353   X_PARENT_OBJECT_TYPE2 IN NUMBER,
354   X_PARENT_OBJECT_ID2 IN NUMBER,
355   X_PARENT_OBJECT_NUMBER2 IN VARCHAR2,
356   X_PARENT_ITEM_ID IN NUMBER
357 );
358 procedure DELETE_ROW (
359   X_ROWID IN ROWID
360 );
361 
362 end MTL_TRANSACTION_LOTS_INTF_pkg;