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

Source


1 package HZ_LOCATIONS_EXT_PKG as
2 /* $Header: ARHEXLOS.pls 120.2 2005/10/30 03:52:25 appldev noship $ */
3 
4 procedure INSERT_ROW (
5   X_ROWID in out nocopy VARCHAR2,
6   X_EXTENSION_ID IN NUMBER,
7   X_LOCATION_ID IN NUMBER,
8   X_ATTR_GROUP_ID IN NUMBER,
9   X_C_EXT_ATTR1 IN VARCHAR2,
10   X_C_EXT_ATTR2 IN VARCHAR2,
11   X_C_EXT_ATTR3 IN VARCHAR2,
12   X_C_EXT_ATTR4 IN VARCHAR2,
13   X_C_EXT_ATTR5 IN VARCHAR2,
14   X_C_EXT_ATTR6 IN VARCHAR2,
15   X_C_EXT_ATTR7 IN VARCHAR2,
16   X_C_EXT_ATTR8 IN VARCHAR2,
17   X_C_EXT_ATTR9 IN VARCHAR2,
18   X_C_EXT_ATTR10 IN VARCHAR2,
19   X_C_EXT_ATTR11 IN VARCHAR2,
20   X_C_EXT_ATTR12 IN VARCHAR2,
21   X_C_EXT_ATTR13 IN VARCHAR2,
22   X_C_EXT_ATTR14 IN VARCHAR2,
23   X_C_EXT_ATTR15 IN VARCHAR2,
24   X_C_EXT_ATTR16 IN VARCHAR2,
25   X_C_EXT_ATTR17 IN VARCHAR2,
26   X_C_EXT_ATTR18 IN VARCHAR2,
27   X_C_EXT_ATTR19 IN VARCHAR2,
28   X_C_EXT_ATTR20 IN VARCHAR2,
29   X_N_EXT_ATTR1 IN NUMBER,
30   X_N_EXT_ATTR2 IN NUMBER,
31   X_N_EXT_ATTR3 IN NUMBER,
32   X_N_EXT_ATTR4 IN NUMBER,
33   X_N_EXT_ATTR5 IN NUMBER,
34   X_N_EXT_ATTR6 IN NUMBER,
35   X_N_EXT_ATTR7 IN NUMBER,
36   X_N_EXT_ATTR8 IN NUMBER,
37   X_N_EXT_ATTR9 IN NUMBER,
38   X_N_EXT_ATTR10 IN NUMBER,
39   X_N_EXT_ATTR11 IN NUMBER,
40   X_N_EXT_ATTR12 IN NUMBER,
41   X_N_EXT_ATTR13 IN NUMBER,
42   X_N_EXT_ATTR14 IN NUMBER,
43   X_N_EXT_ATTR15 IN NUMBER,
44   X_N_EXT_ATTR16 IN NUMBER,
45   X_N_EXT_ATTR17 IN NUMBER,
46   X_N_EXT_ATTR18 IN NUMBER,
47   X_N_EXT_ATTR19 IN NUMBER,
48   X_N_EXT_ATTR20 IN NUMBER,
49   X_D_EXT_ATTR1 IN DATE,
50   X_D_EXT_ATTR2 IN DATE,
51   X_D_EXT_ATTR3 IN DATE,
52   X_D_EXT_ATTR4 IN DATE,
53   X_D_EXT_ATTR5 IN DATE,
54   X_D_EXT_ATTR6 IN DATE,
55   X_D_EXT_ATTR7 IN DATE,
56   X_D_EXT_ATTR8 IN DATE,
57   X_D_EXT_ATTR9 IN DATE,
58   X_D_EXT_ATTR10 IN DATE,
59   X_TL_EXT_ATTR1 IN VARCHAR2,
60   X_TL_EXT_ATTR2 IN VARCHAR2,
61   X_TL_EXT_ATTR3 IN VARCHAR2,
62   X_TL_EXT_ATTR4 IN VARCHAR2,
63   X_TL_EXT_ATTR5 IN VARCHAR2,
64   X_TL_EXT_ATTR6 IN VARCHAR2,
65   X_TL_EXT_ATTR7 IN VARCHAR2,
66   X_TL_EXT_ATTR8 IN VARCHAR2,
67   X_TL_EXT_ATTR9 IN VARCHAR2,
68   X_TL_EXT_ATTR10 IN VARCHAR2,
69   X_TL_EXT_ATTR11 IN VARCHAR2,
70   X_TL_EXT_ATTR12 IN VARCHAR2,
71   X_TL_EXT_ATTR13 IN VARCHAR2,
72   X_TL_EXT_ATTR14 IN VARCHAR2,
73   X_TL_EXT_ATTR15 IN VARCHAR2,
74   X_TL_EXT_ATTR16 IN VARCHAR2,
75   X_TL_EXT_ATTR17 IN VARCHAR2,
76   X_TL_EXT_ATTR18 IN VARCHAR2,
77   X_TL_EXT_ATTR19 IN VARCHAR2,
78   X_TL_EXT_ATTR20 IN VARCHAR2,
79   X_CREATION_DATE in DATE,
80   X_CREATED_BY in NUMBER,
81   X_LAST_UPDATE_DATE in DATE,
82   X_LAST_UPDATED_BY in NUMBER,
83   X_LAST_UPDATE_LOGIN in NUMBER);
84 
85 procedure LOCK_ROW (
86   X_EXTENSION_ID IN NUMBER,
87   X_LOCATION_ID IN NUMBER,
88   X_ATTR_GROUP_ID IN NUMBER,
89   X_C_EXT_ATTR1 IN VARCHAR2,
90   X_C_EXT_ATTR2 IN VARCHAR2,
91   X_C_EXT_ATTR3 IN VARCHAR2,
92   X_C_EXT_ATTR4 IN VARCHAR2,
93   X_C_EXT_ATTR5 IN VARCHAR2,
94   X_C_EXT_ATTR6 IN VARCHAR2,
95   X_C_EXT_ATTR7 IN VARCHAR2,
96   X_C_EXT_ATTR8 IN VARCHAR2,
97   X_C_EXT_ATTR9 IN VARCHAR2,
98   X_C_EXT_ATTR10 IN VARCHAR2,
99   X_C_EXT_ATTR11 IN VARCHAR2,
100   X_C_EXT_ATTR12 IN VARCHAR2,
101   X_C_EXT_ATTR13 IN VARCHAR2,
102   X_C_EXT_ATTR14 IN VARCHAR2,
103   X_C_EXT_ATTR15 IN VARCHAR2,
104   X_C_EXT_ATTR16 IN VARCHAR2,
105   X_C_EXT_ATTR17 IN VARCHAR2,
106   X_C_EXT_ATTR18 IN VARCHAR2,
107   X_C_EXT_ATTR19 IN VARCHAR2,
108   X_C_EXT_ATTR20 IN VARCHAR2,
109   X_N_EXT_ATTR1 IN NUMBER,
110   X_N_EXT_ATTR2 IN NUMBER,
111   X_N_EXT_ATTR3 IN NUMBER,
112   X_N_EXT_ATTR4 IN NUMBER,
113   X_N_EXT_ATTR5 IN NUMBER,
114   X_N_EXT_ATTR6 IN NUMBER,
115   X_N_EXT_ATTR7 IN NUMBER,
116   X_N_EXT_ATTR8 IN NUMBER,
117   X_N_EXT_ATTR9 IN NUMBER,
118   X_N_EXT_ATTR10 IN NUMBER,
119   X_N_EXT_ATTR11 IN NUMBER,
120   X_N_EXT_ATTR12 IN NUMBER,
121   X_N_EXT_ATTR13 IN NUMBER,
122   X_N_EXT_ATTR14 IN NUMBER,
123   X_N_EXT_ATTR15 IN NUMBER,
124   X_N_EXT_ATTR16 IN NUMBER,
125   X_N_EXT_ATTR17 IN NUMBER,
126   X_N_EXT_ATTR18 IN NUMBER,
127   X_N_EXT_ATTR19 IN NUMBER,
128   X_N_EXT_ATTR20 IN NUMBER,
129   X_D_EXT_ATTR1 IN DATE,
130   X_D_EXT_ATTR2 IN DATE,
131   X_D_EXT_ATTR3 IN DATE,
132   X_D_EXT_ATTR4 IN DATE,
133   X_D_EXT_ATTR5 IN DATE,
134   X_D_EXT_ATTR6 IN DATE,
135   X_D_EXT_ATTR7 IN DATE,
136   X_D_EXT_ATTR8 IN DATE,
137   X_D_EXT_ATTR9 IN DATE,
138   X_D_EXT_ATTR10 IN DATE,
139   X_TL_EXT_ATTR1 IN VARCHAR2,
140   X_TL_EXT_ATTR2 IN VARCHAR2,
141   X_TL_EXT_ATTR3 IN VARCHAR2,
142   X_TL_EXT_ATTR4 IN VARCHAR2,
143   X_TL_EXT_ATTR5 IN VARCHAR2,
144   X_TL_EXT_ATTR6 IN VARCHAR2,
145   X_TL_EXT_ATTR7 IN VARCHAR2,
146   X_TL_EXT_ATTR8 IN VARCHAR2,
147   X_TL_EXT_ATTR9 IN VARCHAR2,
148   X_TL_EXT_ATTR10 IN VARCHAR2,
149   X_TL_EXT_ATTR11 IN VARCHAR2,
150   X_TL_EXT_ATTR12 IN VARCHAR2,
151   X_TL_EXT_ATTR13 IN VARCHAR2,
152   X_TL_EXT_ATTR14 IN VARCHAR2,
153   X_TL_EXT_ATTR15 IN VARCHAR2,
154   X_TL_EXT_ATTR16 IN VARCHAR2,
155   X_TL_EXT_ATTR17 IN VARCHAR2,
156   X_TL_EXT_ATTR18 IN VARCHAR2,
157   X_TL_EXT_ATTR19 IN VARCHAR2,
158   X_TL_EXT_ATTR20 IN VARCHAR2
159 );
160 
161 procedure UPDATE_ROW (
162   X_EXTENSION_ID IN NUMBER,
163   X_LOCATION_ID IN NUMBER,
164   X_ATTR_GROUP_ID IN NUMBER,
165   X_C_EXT_ATTR1 IN VARCHAR2,
166   X_C_EXT_ATTR2 IN VARCHAR2,
167   X_C_EXT_ATTR3 IN VARCHAR2,
168   X_C_EXT_ATTR4 IN VARCHAR2,
169   X_C_EXT_ATTR5 IN VARCHAR2,
170   X_C_EXT_ATTR6 IN VARCHAR2,
171   X_C_EXT_ATTR7 IN VARCHAR2,
172   X_C_EXT_ATTR8 IN VARCHAR2,
173   X_C_EXT_ATTR9 IN VARCHAR2,
174   X_C_EXT_ATTR10 IN VARCHAR2,
175   X_C_EXT_ATTR11 IN VARCHAR2,
176   X_C_EXT_ATTR12 IN VARCHAR2,
177   X_C_EXT_ATTR13 IN VARCHAR2,
178   X_C_EXT_ATTR14 IN VARCHAR2,
179   X_C_EXT_ATTR15 IN VARCHAR2,
180   X_C_EXT_ATTR16 IN VARCHAR2,
181   X_C_EXT_ATTR17 IN VARCHAR2,
182   X_C_EXT_ATTR18 IN VARCHAR2,
183   X_C_EXT_ATTR19 IN VARCHAR2,
184   X_C_EXT_ATTR20 IN VARCHAR2,
185   X_N_EXT_ATTR1 IN NUMBER,
186   X_N_EXT_ATTR2 IN NUMBER,
187   X_N_EXT_ATTR3 IN NUMBER,
188   X_N_EXT_ATTR4 IN NUMBER,
189   X_N_EXT_ATTR5 IN NUMBER,
190   X_N_EXT_ATTR6 IN NUMBER,
191   X_N_EXT_ATTR7 IN NUMBER,
192   X_N_EXT_ATTR8 IN NUMBER,
193   X_N_EXT_ATTR9 IN NUMBER,
194   X_N_EXT_ATTR10 IN NUMBER,
195   X_N_EXT_ATTR11 IN NUMBER,
196   X_N_EXT_ATTR12 IN NUMBER,
197   X_N_EXT_ATTR13 IN NUMBER,
198   X_N_EXT_ATTR14 IN NUMBER,
199   X_N_EXT_ATTR15 IN NUMBER,
200   X_N_EXT_ATTR16 IN NUMBER,
201   X_N_EXT_ATTR17 IN NUMBER,
202   X_N_EXT_ATTR18 IN NUMBER,
203   X_N_EXT_ATTR19 IN NUMBER,
204   X_N_EXT_ATTR20 IN NUMBER,
205   X_D_EXT_ATTR1 IN DATE,
206   X_D_EXT_ATTR2 IN DATE,
207   X_D_EXT_ATTR3 IN DATE,
208   X_D_EXT_ATTR4 IN DATE,
209   X_D_EXT_ATTR5 IN DATE,
210   X_D_EXT_ATTR6 IN DATE,
211   X_D_EXT_ATTR7 IN DATE,
212   X_D_EXT_ATTR8 IN DATE,
213   X_D_EXT_ATTR9 IN DATE,
214   X_D_EXT_ATTR10 IN DATE,
215   X_TL_EXT_ATTR1 IN VARCHAR2,
216   X_TL_EXT_ATTR2 IN VARCHAR2,
217   X_TL_EXT_ATTR3 IN VARCHAR2,
218   X_TL_EXT_ATTR4 IN VARCHAR2,
219   X_TL_EXT_ATTR5 IN VARCHAR2,
220   X_TL_EXT_ATTR6 IN VARCHAR2,
221   X_TL_EXT_ATTR7 IN VARCHAR2,
222   X_TL_EXT_ATTR8 IN VARCHAR2,
223   X_TL_EXT_ATTR9 IN VARCHAR2,
224   X_TL_EXT_ATTR10 IN VARCHAR2,
225   X_TL_EXT_ATTR11 IN VARCHAR2,
226   X_TL_EXT_ATTR12 IN VARCHAR2,
227   X_TL_EXT_ATTR13 IN VARCHAR2,
228   X_TL_EXT_ATTR14 IN VARCHAR2,
229   X_TL_EXT_ATTR15 IN VARCHAR2,
230   X_TL_EXT_ATTR16 IN VARCHAR2,
231   X_TL_EXT_ATTR17 IN VARCHAR2,
232   X_TL_EXT_ATTR18 IN VARCHAR2,
233   X_TL_EXT_ATTR19 IN VARCHAR2,
234   X_TL_EXT_ATTR20 IN VARCHAR2,
235   X_LAST_UPDATE_DATE in DATE,
236   X_LAST_UPDATED_BY in NUMBER,
237   X_LAST_UPDATE_LOGIN in NUMBER
238 );
239 
240 procedure DELETE_ROW (
241   X_EXTENSION_ID IN NUMBER
242 );
243 
244 procedure ADD_LANGUAGE;
245 
246 procedure LOAD_ROW(
247   X_EXTENSION_ID IN NUMBER,
248   X_LOCATION_ID IN NUMBER,
249   X_ATTR_GROUP_ID IN NUMBER,
250   X_C_EXT_ATTR1 IN VARCHAR2,
251   X_C_EXT_ATTR2 IN VARCHAR2,
252   X_C_EXT_ATTR3 IN VARCHAR2,
253   X_C_EXT_ATTR4 IN VARCHAR2,
254   X_C_EXT_ATTR5 IN VARCHAR2,
255   X_C_EXT_ATTR6 IN VARCHAR2,
256   X_C_EXT_ATTR7 IN VARCHAR2,
257   X_C_EXT_ATTR8 IN VARCHAR2,
258   X_C_EXT_ATTR9 IN VARCHAR2,
259   X_C_EXT_ATTR10 IN VARCHAR2,
260   X_C_EXT_ATTR11 IN VARCHAR2,
261   X_C_EXT_ATTR12 IN VARCHAR2,
262   X_C_EXT_ATTR13 IN VARCHAR2,
263   X_C_EXT_ATTR14 IN VARCHAR2,
264   X_C_EXT_ATTR15 IN VARCHAR2,
265   X_C_EXT_ATTR16 IN VARCHAR2,
266   X_C_EXT_ATTR17 IN VARCHAR2,
267   X_C_EXT_ATTR18 IN VARCHAR2,
268   X_C_EXT_ATTR19 IN VARCHAR2,
269   X_C_EXT_ATTR20 IN VARCHAR2,
270   X_N_EXT_ATTR1 IN NUMBER,
271   X_N_EXT_ATTR2 IN NUMBER,
272   X_N_EXT_ATTR3 IN NUMBER,
273   X_N_EXT_ATTR4 IN NUMBER,
274   X_N_EXT_ATTR5 IN NUMBER,
275   X_N_EXT_ATTR6 IN NUMBER,
276   X_N_EXT_ATTR7 IN NUMBER,
277   X_N_EXT_ATTR8 IN NUMBER,
278   X_N_EXT_ATTR9 IN NUMBER,
279   X_N_EXT_ATTR10 IN NUMBER,
280   X_N_EXT_ATTR11 IN NUMBER,
281   X_N_EXT_ATTR12 IN NUMBER,
282   X_N_EXT_ATTR13 IN NUMBER,
283   X_N_EXT_ATTR14 IN NUMBER,
284   X_N_EXT_ATTR15 IN NUMBER,
285   X_N_EXT_ATTR16 IN NUMBER,
286   X_N_EXT_ATTR17 IN NUMBER,
287   X_N_EXT_ATTR18 IN NUMBER,
288   X_N_EXT_ATTR19 IN NUMBER,
289   X_N_EXT_ATTR20 IN NUMBER,
290   X_D_EXT_ATTR1 IN DATE,
291   X_D_EXT_ATTR2 IN DATE,
292   X_D_EXT_ATTR3 IN DATE,
293   X_D_EXT_ATTR4 IN DATE,
294   X_D_EXT_ATTR5 IN DATE,
295   X_D_EXT_ATTR6 IN DATE,
296   X_D_EXT_ATTR7 IN DATE,
297   X_D_EXT_ATTR8 IN DATE,
298   X_D_EXT_ATTR9 IN DATE,
299   X_D_EXT_ATTR10 IN DATE,
300   X_TL_EXT_ATTR1 IN VARCHAR2,
301   X_TL_EXT_ATTR2 IN VARCHAR2,
302   X_TL_EXT_ATTR3 IN VARCHAR2,
303   X_TL_EXT_ATTR4 IN VARCHAR2,
304   X_TL_EXT_ATTR5 IN VARCHAR2,
305   X_TL_EXT_ATTR6 IN VARCHAR2,
306   X_TL_EXT_ATTR7 IN VARCHAR2,
307   X_TL_EXT_ATTR8 IN VARCHAR2,
308   X_TL_EXT_ATTR9 IN VARCHAR2,
309   X_TL_EXT_ATTR10 IN VARCHAR2,
310   X_TL_EXT_ATTR11 IN VARCHAR2,
311   X_TL_EXT_ATTR12 IN VARCHAR2,
312   X_TL_EXT_ATTR13 IN VARCHAR2,
313   X_TL_EXT_ATTR14 IN VARCHAR2,
314   X_TL_EXT_ATTR15 IN VARCHAR2,
315   X_TL_EXT_ATTR16 IN VARCHAR2,
316   X_TL_EXT_ATTR17 IN VARCHAR2,
317   X_TL_EXT_ATTR18 IN VARCHAR2,
318   X_TL_EXT_ATTR19 IN VARCHAR2,
319   X_TL_EXT_ATTR20 IN VARCHAR2,
323 procedure TRANSLATE_ROW (
320   X_OWNER in VARCHAR2) ;
321 
322 
324   X_EXTENSION_ID IN NUMBER,
325   X_LOCATION_ID IN NUMBER,
326   X_ATTR_GROUP_ID IN NUMBER,
327   X_TL_EXT_ATTR1 IN VARCHAR2,
328   X_TL_EXT_ATTR2 IN VARCHAR2,
329   X_TL_EXT_ATTR3 IN VARCHAR2,
330   X_TL_EXT_ATTR4 IN VARCHAR2,
331   X_TL_EXT_ATTR5 IN VARCHAR2,
332   X_TL_EXT_ATTR6 IN VARCHAR2,
333   X_TL_EXT_ATTR7 IN VARCHAR2,
334   X_TL_EXT_ATTR8 IN VARCHAR2,
335   X_TL_EXT_ATTR9 IN VARCHAR2,
336   X_TL_EXT_ATTR10 IN VARCHAR2,
337   X_TL_EXT_ATTR11 IN VARCHAR2,
338   X_TL_EXT_ATTR12 IN VARCHAR2,
339   X_TL_EXT_ATTR13 IN VARCHAR2,
340   X_TL_EXT_ATTR14 IN VARCHAR2,
341   X_TL_EXT_ATTR15 IN VARCHAR2,
342   X_TL_EXT_ATTR16 IN VARCHAR2,
343   X_TL_EXT_ATTR17 IN VARCHAR2,
344   X_TL_EXT_ATTR18 IN VARCHAR2,
345   X_TL_EXT_ATTR19 IN VARCHAR2,
346   X_TL_EXT_ATTR20 IN VARCHAR2,
347   X_OWNER in VARCHAR2) ;
348 
349 
350 end HZ_LOCATIONS_EXT_PKG;