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_SERIAL_NUMBERS_INTERF_PKG

Source


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