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

Source


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