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

Source


1 package RRS_LOCATIONS_EXT_PKG as
2 /* $Header: RRSLEXTS.pls 120.0 2005/09/30 00:02 pfarkade noship $ */
3 procedure INSERT_ROW (
4   X_ROWID in out nocopy VARCHAR2,
5   X_EXTENSION_ID in NUMBER,
6   X_C_EXT_ATTR13 in VARCHAR2,
7   X_C_EXT_ATTR14 in VARCHAR2,
8   X_C_EXT_ATTR15 in VARCHAR2,
9   X_C_EXT_ATTR16 in VARCHAR2,
10   X_C_EXT_ATTR17 in VARCHAR2,
11   X_C_EXT_ATTR18 in VARCHAR2,
12   X_C_EXT_ATTR19 in VARCHAR2,
13   X_C_EXT_ATTR20 in VARCHAR2,
14   X_N_EXT_ATTR1 in NUMBER,
15   X_N_EXT_ATTR2 in NUMBER,
16   X_N_EXT_ATTR3 in NUMBER,
17   X_N_EXT_ATTR4 in NUMBER,
18   X_N_EXT_ATTR5 in NUMBER,
19   X_N_EXT_ATTR6 in NUMBER,
20   X_N_EXT_ATTR7 in NUMBER,
21   X_N_EXT_ATTR8 in NUMBER,
22   X_N_EXT_ATTR9 in NUMBER,
23   X_N_EXT_ATTR10 in NUMBER,
24   X_D_EXT_ATTR1 in DATE,
25   X_D_EXT_ATTR2 in DATE,
26   X_D_EXT_ATTR3 in DATE,
27   X_D_EXT_ATTR4 in DATE,
28   X_D_EXT_ATTR5 in DATE,
29   X_C_EXT_ATTR21 in VARCHAR2,
30   X_C_EXT_ATTR22 in VARCHAR2,
31   X_C_EXT_ATTR23 in VARCHAR2,
32   X_C_EXT_ATTR24 in VARCHAR2,
33   X_C_EXT_ATTR25 in VARCHAR2,
34   X_C_EXT_ATTR26 in VARCHAR2,
35   X_C_EXT_ATTR27 in VARCHAR2,
36   X_C_EXT_ATTR28 in VARCHAR2,
37   X_C_EXT_ATTR29 in VARCHAR2,
38   X_C_EXT_ATTR30 in VARCHAR2,
39   X_C_EXT_ATTR31 in VARCHAR2,
40   X_C_EXT_ATTR32 in VARCHAR2,
41   X_C_EXT_ATTR33 in VARCHAR2,
42   X_C_EXT_ATTR34 in VARCHAR2,
43   X_C_EXT_ATTR35 in VARCHAR2,
44   X_C_EXT_ATTR36 in VARCHAR2,
45   X_C_EXT_ATTR37 in VARCHAR2,
46   X_C_EXT_ATTR38 in VARCHAR2,
47   X_C_EXT_ATTR39 in VARCHAR2,
48   X_C_EXT_ATTR40 in VARCHAR2,
49   X_N_EXT_ATTR11 in NUMBER,
50   X_N_EXT_ATTR12 in NUMBER,
51   X_N_EXT_ATTR13 in NUMBER,
52   X_N_EXT_ATTR14 in NUMBER,
53   X_N_EXT_ATTR15 in NUMBER,
54   X_N_EXT_ATTR16 in NUMBER,
55   X_N_EXT_ATTR17 in NUMBER,
56   X_N_EXT_ATTR18 in NUMBER,
57   X_N_EXT_ATTR19 in NUMBER,
58   X_N_EXT_ATTR20 in NUMBER,
59   X_UOM_EXT_ATTR1 in VARCHAR2,
60   X_UOM_EXT_ATTR2 in VARCHAR2,
61   X_UOM_EXT_ATTR3 in VARCHAR2,
62   X_UOM_EXT_ATTR4 in VARCHAR2,
63   X_UOM_EXT_ATTR5 in VARCHAR2,
64   X_UOM_EXT_ATTR6 in VARCHAR2,
65   X_UOM_EXT_ATTR7 in VARCHAR2,
66   X_UOM_EXT_ATTR8 in VARCHAR2,
67   X_UOM_EXT_ATTR9 in VARCHAR2,
68   X_UOM_EXT_ATTR10 in VARCHAR2,
69   X_UOM_EXT_ATTR11 in VARCHAR2,
70   X_UOM_EXT_ATTR12 in VARCHAR2,
71   X_UOM_EXT_ATTR13 in VARCHAR2,
72   X_UOM_EXT_ATTR14 in VARCHAR2,
73   X_UOM_EXT_ATTR15 in VARCHAR2,
74   X_UOM_EXT_ATTR16 in VARCHAR2,
75   X_UOM_EXT_ATTR17 in VARCHAR2,
76   X_UOM_EXT_ATTR18 in VARCHAR2,
77   X_UOM_EXT_ATTR19 in VARCHAR2,
78   X_UOM_EXT_ATTR20 in VARCHAR2,
79   X_D_EXT_ATTR6 in DATE,
80   X_D_EXT_ATTR7 in DATE,
81   X_D_EXT_ATTR8 in DATE,
82   X_D_EXT_ATTR9 in DATE,
83   X_D_EXT_ATTR10 in DATE,
84   X_REQUEST_ID in NUMBER,
85   X_LOCATION_ID in NUMBER,
86   X_COUNTRY in VARCHAR2,
87   X_ATTR_GROUP_ID in NUMBER,
88   X_C_EXT_ATTR1 in VARCHAR2,
89   X_C_EXT_ATTR2 in VARCHAR2,
90   X_C_EXT_ATTR3 in VARCHAR2,
91   X_C_EXT_ATTR4 in VARCHAR2,
92   X_C_EXT_ATTR5 in VARCHAR2,
93   X_C_EXT_ATTR6 in VARCHAR2,
94   X_C_EXT_ATTR7 in VARCHAR2,
95   X_C_EXT_ATTR8 in VARCHAR2,
96   X_C_EXT_ATTR9 in VARCHAR2,
97   X_C_EXT_ATTR10 in VARCHAR2,
98   X_C_EXT_ATTR11 in VARCHAR2,
99   X_C_EXT_ATTR12 in VARCHAR2,
100   X_TL_EXT_ATTR1 in VARCHAR2,
101   X_TL_EXT_ATTR2 in VARCHAR2,
102   X_TL_EXT_ATTR3 in VARCHAR2,
103   X_TL_EXT_ATTR4 in VARCHAR2,
104   X_TL_EXT_ATTR5 in VARCHAR2,
105   X_TL_EXT_ATTR6 in VARCHAR2,
106   X_TL_EXT_ATTR7 in VARCHAR2,
107   X_TL_EXT_ATTR8 in VARCHAR2,
108   X_TL_EXT_ATTR9 in VARCHAR2,
109   X_TL_EXT_ATTR10 in VARCHAR2,
110   X_TL_EXT_ATTR11 in VARCHAR2,
111   X_TL_EXT_ATTR12 in VARCHAR2,
112   X_TL_EXT_ATTR13 in VARCHAR2,
113   X_TL_EXT_ATTR14 in VARCHAR2,
114   X_TL_EXT_ATTR15 in VARCHAR2,
115   X_TL_EXT_ATTR16 in VARCHAR2,
116   X_TL_EXT_ATTR17 in VARCHAR2,
117   X_TL_EXT_ATTR18 in VARCHAR2,
118   X_TL_EXT_ATTR19 in VARCHAR2,
119   X_TL_EXT_ATTR20 in VARCHAR2,
120   X_TL_EXT_ATTR21 in VARCHAR2,
121   X_TL_EXT_ATTR22 in VARCHAR2,
122   X_TL_EXT_ATTR23 in VARCHAR2,
123   X_TL_EXT_ATTR24 in VARCHAR2,
124   X_TL_EXT_ATTR25 in VARCHAR2,
125   X_TL_EXT_ATTR26 in VARCHAR2,
126   X_TL_EXT_ATTR27 in VARCHAR2,
127   X_TL_EXT_ATTR28 in VARCHAR2,
128   X_TL_EXT_ATTR29 in VARCHAR2,
129   X_TL_EXT_ATTR30 in VARCHAR2,
130   X_TL_EXT_ATTR31 in VARCHAR2,
131   X_TL_EXT_ATTR32 in VARCHAR2,
132   X_TL_EXT_ATTR33 in VARCHAR2,
133   X_TL_EXT_ATTR34 in VARCHAR2,
134   X_TL_EXT_ATTR35 in VARCHAR2,
135   X_TL_EXT_ATTR36 in VARCHAR2,
136   X_TL_EXT_ATTR37 in VARCHAR2,
137   X_TL_EXT_ATTR38 in VARCHAR2,
138   X_TL_EXT_ATTR39 in VARCHAR2,
139   X_TL_EXT_ATTR40 in VARCHAR2,
140   X_CREATION_DATE in DATE,
141   X_CREATED_BY in NUMBER,
142   X_LAST_UPDATE_DATE in DATE,
143   X_LAST_UPDATED_BY in NUMBER,
144   X_LAST_UPDATE_LOGIN in NUMBER);
145 procedure LOCK_ROW (
146   X_EXTENSION_ID in NUMBER,
147   X_C_EXT_ATTR13 in VARCHAR2,
148   X_C_EXT_ATTR14 in VARCHAR2,
149   X_C_EXT_ATTR15 in VARCHAR2,
150   X_C_EXT_ATTR16 in VARCHAR2,
151   X_C_EXT_ATTR17 in VARCHAR2,
152   X_C_EXT_ATTR18 in VARCHAR2,
153   X_C_EXT_ATTR19 in VARCHAR2,
154   X_C_EXT_ATTR20 in VARCHAR2,
155   X_N_EXT_ATTR1 in NUMBER,
156   X_N_EXT_ATTR2 in NUMBER,
157   X_N_EXT_ATTR3 in NUMBER,
158   X_N_EXT_ATTR4 in NUMBER,
159   X_N_EXT_ATTR5 in NUMBER,
160   X_N_EXT_ATTR6 in NUMBER,
161   X_N_EXT_ATTR7 in NUMBER,
162   X_N_EXT_ATTR8 in NUMBER,
163   X_N_EXT_ATTR9 in NUMBER,
164   X_N_EXT_ATTR10 in NUMBER,
165   X_D_EXT_ATTR1 in DATE,
166   X_D_EXT_ATTR2 in DATE,
167   X_D_EXT_ATTR3 in DATE,
168   X_D_EXT_ATTR4 in DATE,
169   X_D_EXT_ATTR5 in DATE,
170   X_C_EXT_ATTR21 in VARCHAR2,
171   X_C_EXT_ATTR22 in VARCHAR2,
172   X_C_EXT_ATTR23 in VARCHAR2,
173   X_C_EXT_ATTR24 in VARCHAR2,
174   X_C_EXT_ATTR25 in VARCHAR2,
175   X_C_EXT_ATTR26 in VARCHAR2,
176   X_C_EXT_ATTR27 in VARCHAR2,
177   X_C_EXT_ATTR28 in VARCHAR2,
178   X_C_EXT_ATTR29 in VARCHAR2,
179   X_C_EXT_ATTR30 in VARCHAR2,
180   X_C_EXT_ATTR31 in VARCHAR2,
181   X_C_EXT_ATTR32 in VARCHAR2,
182   X_C_EXT_ATTR33 in VARCHAR2,
183   X_C_EXT_ATTR34 in VARCHAR2,
184   X_C_EXT_ATTR35 in VARCHAR2,
185   X_C_EXT_ATTR36 in VARCHAR2,
186   X_C_EXT_ATTR37 in VARCHAR2,
187   X_C_EXT_ATTR38 in VARCHAR2,
188   X_C_EXT_ATTR39 in VARCHAR2,
189   X_C_EXT_ATTR40 in VARCHAR2,
190   X_N_EXT_ATTR11 in NUMBER,
191   X_N_EXT_ATTR12 in NUMBER,
192   X_N_EXT_ATTR13 in NUMBER,
193   X_N_EXT_ATTR14 in NUMBER,
194   X_N_EXT_ATTR15 in NUMBER,
195   X_N_EXT_ATTR16 in NUMBER,
196   X_N_EXT_ATTR17 in NUMBER,
197   X_N_EXT_ATTR18 in NUMBER,
198   X_N_EXT_ATTR19 in NUMBER,
199   X_N_EXT_ATTR20 in NUMBER,
200   X_UOM_EXT_ATTR1 in VARCHAR2,
201   X_UOM_EXT_ATTR2 in VARCHAR2,
202   X_UOM_EXT_ATTR3 in VARCHAR2,
203   X_UOM_EXT_ATTR4 in VARCHAR2,
204   X_UOM_EXT_ATTR5 in VARCHAR2,
205   X_UOM_EXT_ATTR6 in VARCHAR2,
206   X_UOM_EXT_ATTR7 in VARCHAR2,
207   X_UOM_EXT_ATTR8 in VARCHAR2,
208   X_UOM_EXT_ATTR9 in VARCHAR2,
209   X_UOM_EXT_ATTR10 in VARCHAR2,
210   X_UOM_EXT_ATTR11 in VARCHAR2,
211   X_UOM_EXT_ATTR12 in VARCHAR2,
212   X_UOM_EXT_ATTR13 in VARCHAR2,
213   X_UOM_EXT_ATTR14 in VARCHAR2,
214   X_UOM_EXT_ATTR15 in VARCHAR2,
215   X_UOM_EXT_ATTR16 in VARCHAR2,
216   X_UOM_EXT_ATTR17 in VARCHAR2,
217   X_UOM_EXT_ATTR18 in VARCHAR2,
218   X_UOM_EXT_ATTR19 in VARCHAR2,
219   X_UOM_EXT_ATTR20 in VARCHAR2,
220   X_D_EXT_ATTR6 in DATE,
221   X_D_EXT_ATTR7 in DATE,
222   X_D_EXT_ATTR8 in DATE,
223   X_D_EXT_ATTR9 in DATE,
224   X_D_EXT_ATTR10 in DATE,
225   X_REQUEST_ID in NUMBER,
226   X_LOCATION_ID in NUMBER,
227   X_COUNTRY in VARCHAR2,
228   X_ATTR_GROUP_ID in NUMBER,
229   X_C_EXT_ATTR1 in VARCHAR2,
230   X_C_EXT_ATTR2 in VARCHAR2,
231   X_C_EXT_ATTR3 in VARCHAR2,
232   X_C_EXT_ATTR4 in VARCHAR2,
233   X_C_EXT_ATTR5 in VARCHAR2,
234   X_C_EXT_ATTR6 in VARCHAR2,
235   X_C_EXT_ATTR7 in VARCHAR2,
236   X_C_EXT_ATTR8 in VARCHAR2,
237   X_C_EXT_ATTR9 in VARCHAR2,
238   X_C_EXT_ATTR10 in VARCHAR2,
239   X_C_EXT_ATTR11 in VARCHAR2,
240   X_C_EXT_ATTR12 in VARCHAR2,
241   X_TL_EXT_ATTR1 in VARCHAR2,
242   X_TL_EXT_ATTR2 in VARCHAR2,
243   X_TL_EXT_ATTR3 in VARCHAR2,
244   X_TL_EXT_ATTR4 in VARCHAR2,
245   X_TL_EXT_ATTR5 in VARCHAR2,
246   X_TL_EXT_ATTR6 in VARCHAR2,
247   X_TL_EXT_ATTR7 in VARCHAR2,
248   X_TL_EXT_ATTR8 in VARCHAR2,
249   X_TL_EXT_ATTR9 in VARCHAR2,
250   X_TL_EXT_ATTR10 in VARCHAR2,
251   X_TL_EXT_ATTR11 in VARCHAR2,
252   X_TL_EXT_ATTR12 in VARCHAR2,
253   X_TL_EXT_ATTR13 in VARCHAR2,
254   X_TL_EXT_ATTR14 in VARCHAR2,
255   X_TL_EXT_ATTR15 in VARCHAR2,
256   X_TL_EXT_ATTR16 in VARCHAR2,
257   X_TL_EXT_ATTR17 in VARCHAR2,
258   X_TL_EXT_ATTR18 in VARCHAR2,
259   X_TL_EXT_ATTR19 in VARCHAR2,
260   X_TL_EXT_ATTR20 in VARCHAR2,
261   X_TL_EXT_ATTR21 in VARCHAR2,
262   X_TL_EXT_ATTR22 in VARCHAR2,
263   X_TL_EXT_ATTR23 in VARCHAR2,
264   X_TL_EXT_ATTR24 in VARCHAR2,
265   X_TL_EXT_ATTR25 in VARCHAR2,
266   X_TL_EXT_ATTR26 in VARCHAR2,
267   X_TL_EXT_ATTR27 in VARCHAR2,
268   X_TL_EXT_ATTR28 in VARCHAR2,
269   X_TL_EXT_ATTR29 in VARCHAR2,
270   X_TL_EXT_ATTR30 in VARCHAR2,
271   X_TL_EXT_ATTR31 in VARCHAR2,
272   X_TL_EXT_ATTR32 in VARCHAR2,
273   X_TL_EXT_ATTR33 in VARCHAR2,
274   X_TL_EXT_ATTR34 in VARCHAR2,
275   X_TL_EXT_ATTR35 in VARCHAR2,
276   X_TL_EXT_ATTR36 in VARCHAR2,
277   X_TL_EXT_ATTR37 in VARCHAR2,
278   X_TL_EXT_ATTR38 in VARCHAR2,
279   X_TL_EXT_ATTR39 in VARCHAR2,
280   X_TL_EXT_ATTR40 in VARCHAR2
281 );
282 procedure UPDATE_ROW (
283   X_EXTENSION_ID in NUMBER,
284   X_C_EXT_ATTR13 in VARCHAR2,
285   X_C_EXT_ATTR14 in VARCHAR2,
286   X_C_EXT_ATTR15 in VARCHAR2,
287   X_C_EXT_ATTR16 in VARCHAR2,
288   X_C_EXT_ATTR17 in VARCHAR2,
289   X_C_EXT_ATTR18 in VARCHAR2,
290   X_C_EXT_ATTR19 in VARCHAR2,
291   X_C_EXT_ATTR20 in VARCHAR2,
292   X_N_EXT_ATTR1 in NUMBER,
293   X_N_EXT_ATTR2 in NUMBER,
294   X_N_EXT_ATTR3 in NUMBER,
295   X_N_EXT_ATTR4 in NUMBER,
296   X_N_EXT_ATTR5 in NUMBER,
297   X_N_EXT_ATTR6 in NUMBER,
298   X_N_EXT_ATTR7 in NUMBER,
299   X_N_EXT_ATTR8 in NUMBER,
300   X_N_EXT_ATTR9 in NUMBER,
301   X_N_EXT_ATTR10 in NUMBER,
302   X_D_EXT_ATTR1 in DATE,
303   X_D_EXT_ATTR2 in DATE,
304   X_D_EXT_ATTR3 in DATE,
305   X_D_EXT_ATTR4 in DATE,
306   X_D_EXT_ATTR5 in DATE,
307   X_C_EXT_ATTR21 in VARCHAR2,
308   X_C_EXT_ATTR22 in VARCHAR2,
309   X_C_EXT_ATTR23 in VARCHAR2,
310   X_C_EXT_ATTR24 in VARCHAR2,
311   X_C_EXT_ATTR25 in VARCHAR2,
312   X_C_EXT_ATTR26 in VARCHAR2,
313   X_C_EXT_ATTR27 in VARCHAR2,
314   X_C_EXT_ATTR28 in VARCHAR2,
315   X_C_EXT_ATTR29 in VARCHAR2,
316   X_C_EXT_ATTR30 in VARCHAR2,
317   X_C_EXT_ATTR31 in VARCHAR2,
318   X_C_EXT_ATTR32 in VARCHAR2,
319   X_C_EXT_ATTR33 in VARCHAR2,
320   X_C_EXT_ATTR34 in VARCHAR2,
321   X_C_EXT_ATTR35 in VARCHAR2,
322   X_C_EXT_ATTR36 in VARCHAR2,
323   X_C_EXT_ATTR37 in VARCHAR2,
324   X_C_EXT_ATTR38 in VARCHAR2,
325   X_C_EXT_ATTR39 in VARCHAR2,
326   X_C_EXT_ATTR40 in VARCHAR2,
327   X_N_EXT_ATTR11 in NUMBER,
328   X_N_EXT_ATTR12 in NUMBER,
329   X_N_EXT_ATTR13 in NUMBER,
330   X_N_EXT_ATTR14 in NUMBER,
331   X_N_EXT_ATTR15 in NUMBER,
332   X_N_EXT_ATTR16 in NUMBER,
333   X_N_EXT_ATTR17 in NUMBER,
334   X_N_EXT_ATTR18 in NUMBER,
335   X_N_EXT_ATTR19 in NUMBER,
336   X_N_EXT_ATTR20 in NUMBER,
337   X_UOM_EXT_ATTR1 in VARCHAR2,
338   X_UOM_EXT_ATTR2 in VARCHAR2,
339   X_UOM_EXT_ATTR3 in VARCHAR2,
340   X_UOM_EXT_ATTR4 in VARCHAR2,
341   X_UOM_EXT_ATTR5 in VARCHAR2,
342   X_UOM_EXT_ATTR6 in VARCHAR2,
343   X_UOM_EXT_ATTR7 in VARCHAR2,
344   X_UOM_EXT_ATTR8 in VARCHAR2,
345   X_UOM_EXT_ATTR9 in VARCHAR2,
346   X_UOM_EXT_ATTR10 in VARCHAR2,
347   X_UOM_EXT_ATTR11 in VARCHAR2,
348   X_UOM_EXT_ATTR12 in VARCHAR2,
349   X_UOM_EXT_ATTR13 in VARCHAR2,
350   X_UOM_EXT_ATTR14 in VARCHAR2,
351   X_UOM_EXT_ATTR15 in VARCHAR2,
352   X_UOM_EXT_ATTR16 in VARCHAR2,
353   X_UOM_EXT_ATTR17 in VARCHAR2,
354   X_UOM_EXT_ATTR18 in VARCHAR2,
355   X_UOM_EXT_ATTR19 in VARCHAR2,
356   X_UOM_EXT_ATTR20 in VARCHAR2,
357   X_D_EXT_ATTR6 in DATE,
358   X_D_EXT_ATTR7 in DATE,
359   X_D_EXT_ATTR8 in DATE,
360   X_D_EXT_ATTR9 in DATE,
361   X_D_EXT_ATTR10 in DATE,
362   X_REQUEST_ID in NUMBER,
363   X_LOCATION_ID in NUMBER,
364   X_COUNTRY in VARCHAR2,
365   X_ATTR_GROUP_ID in NUMBER,
366   X_C_EXT_ATTR1 in VARCHAR2,
367   X_C_EXT_ATTR2 in VARCHAR2,
368   X_C_EXT_ATTR3 in VARCHAR2,
369   X_C_EXT_ATTR4 in VARCHAR2,
370   X_C_EXT_ATTR5 in VARCHAR2,
371   X_C_EXT_ATTR6 in VARCHAR2,
372   X_C_EXT_ATTR7 in VARCHAR2,
373   X_C_EXT_ATTR8 in VARCHAR2,
374   X_C_EXT_ATTR9 in VARCHAR2,
375   X_C_EXT_ATTR10 in VARCHAR2,
376   X_C_EXT_ATTR11 in VARCHAR2,
377   X_C_EXT_ATTR12 in VARCHAR2,
378   X_TL_EXT_ATTR1 in VARCHAR2,
379   X_TL_EXT_ATTR2 in VARCHAR2,
380   X_TL_EXT_ATTR3 in VARCHAR2,
381   X_TL_EXT_ATTR4 in VARCHAR2,
382   X_TL_EXT_ATTR5 in VARCHAR2,
383   X_TL_EXT_ATTR6 in VARCHAR2,
384   X_TL_EXT_ATTR7 in VARCHAR2,
385   X_TL_EXT_ATTR8 in VARCHAR2,
386   X_TL_EXT_ATTR9 in VARCHAR2,
387   X_TL_EXT_ATTR10 in VARCHAR2,
388   X_TL_EXT_ATTR11 in VARCHAR2,
389   X_TL_EXT_ATTR12 in VARCHAR2,
390   X_TL_EXT_ATTR13 in VARCHAR2,
391   X_TL_EXT_ATTR14 in VARCHAR2,
392   X_TL_EXT_ATTR15 in VARCHAR2,
393   X_TL_EXT_ATTR16 in VARCHAR2,
394   X_TL_EXT_ATTR17 in VARCHAR2,
395   X_TL_EXT_ATTR18 in VARCHAR2,
396   X_TL_EXT_ATTR19 in VARCHAR2,
397   X_TL_EXT_ATTR20 in VARCHAR2,
398   X_TL_EXT_ATTR21 in VARCHAR2,
399   X_TL_EXT_ATTR22 in VARCHAR2,
400   X_TL_EXT_ATTR23 in VARCHAR2,
401   X_TL_EXT_ATTR24 in VARCHAR2,
402   X_TL_EXT_ATTR25 in VARCHAR2,
403   X_TL_EXT_ATTR26 in VARCHAR2,
404   X_TL_EXT_ATTR27 in VARCHAR2,
405   X_TL_EXT_ATTR28 in VARCHAR2,
406   X_TL_EXT_ATTR29 in VARCHAR2,
407   X_TL_EXT_ATTR30 in VARCHAR2,
408   X_TL_EXT_ATTR31 in VARCHAR2,
409   X_TL_EXT_ATTR32 in VARCHAR2,
410   X_TL_EXT_ATTR33 in VARCHAR2,
411   X_TL_EXT_ATTR34 in VARCHAR2,
412   X_TL_EXT_ATTR35 in VARCHAR2,
413   X_TL_EXT_ATTR36 in VARCHAR2,
414   X_TL_EXT_ATTR37 in VARCHAR2,
415   X_TL_EXT_ATTR38 in VARCHAR2,
416   X_TL_EXT_ATTR39 in VARCHAR2,
417   X_TL_EXT_ATTR40 in VARCHAR2,
418   X_LAST_UPDATE_DATE in DATE,
419   X_LAST_UPDATED_BY in NUMBER,
420   X_LAST_UPDATE_LOGIN in NUMBER
421 );
422 procedure DELETE_ROW (
423   X_EXTENSION_ID in NUMBER
424 );
425 procedure ADD_LANGUAGE;
426 end RRS_LOCATIONS_EXT_PKG;