DBA Data[Home] [Help]

PACKAGE: APPS.MTL_UOM_CLASSES_TL_PKG

Source


1 package MTL_UOM_CLASSES_TL_PKG as
2 /* $Header: INVUOCSS.pls 120.1 2005/06/11 13:15:30 appldev  $ */
3 --
4 procedure INSERT_ROW (
5   X_ROWID IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
6   X_UOM_CLASS in VARCHAR2,
7   X_UOM_CLASS_TL in VARCHAR2,
8   X_DESCRIPTION in VARCHAR2,
9   X_DISABLE_DATE in DATE,
10   X_ATTRIBUTE_CATEGORY in VARCHAR2,
11   X_ATTRIBUTE1 in VARCHAR2,
12   X_ATTRIBUTE2 in VARCHAR2,
13   X_ATTRIBUTE3 in VARCHAR2,
14   X_ATTRIBUTE4 in VARCHAR2,
15   X_ATTRIBUTE5 in VARCHAR2,
16   X_ATTRIBUTE6 in VARCHAR2,
17   X_ATTRIBUTE7 in VARCHAR2,
18   X_ATTRIBUTE8 in VARCHAR2,
19   X_ATTRIBUTE9 in VARCHAR2,
20   X_ATTRIBUTE10 in VARCHAR2,
21   X_ATTRIBUTE11 in VARCHAR2,
22   X_ATTRIBUTE12 in VARCHAR2,
23   X_ATTRIBUTE13 in VARCHAR2,
24   X_ATTRIBUTE14 in VARCHAR2,
25   X_ATTRIBUTE15 in VARCHAR2,
26   X_REQUEST_ID in NUMBER,
27   X_PROGRAM_ID in NUMBER,
28   X_PROGRAM_APPLICATION_ID in NUMBER,
29   X_PROGRAM_UPDATE_DATE in DATE,
30   X_CREATION_DATE in DATE,
31   X_CREATED_BY in NUMBER,
32   X_LAST_UPDATE_DATE in DATE,
33   X_LAST_UPDATED_BY in NUMBER,
34   X_LAST_UPDATE_LOGIN in NUMBER);
35 --
36 procedure LOCK_ROW (
37   X_UOM_CLASS in VARCHAR2,
38   X_UOM_CLASS_TL in VARCHAR2,
39   X_DESCRIPTION in VARCHAR2,
40   X_DISABLE_DATE in DATE,
41   X_ATTRIBUTE_CATEGORY in VARCHAR2,
42   X_ATTRIBUTE1 in VARCHAR2,
43   X_ATTRIBUTE2 in VARCHAR2,
44   X_ATTRIBUTE3 in VARCHAR2,
45   X_ATTRIBUTE4 in VARCHAR2,
46   X_ATTRIBUTE5 in VARCHAR2,
47   X_ATTRIBUTE6 in VARCHAR2,
48   X_ATTRIBUTE7 in VARCHAR2,
49   X_ATTRIBUTE8 in VARCHAR2,
50   X_ATTRIBUTE9 in VARCHAR2,
51   X_ATTRIBUTE10 in VARCHAR2,
52   X_ATTRIBUTE11 in VARCHAR2,
53   X_ATTRIBUTE12 in VARCHAR2,
54   X_ATTRIBUTE13 in VARCHAR2,
55   X_ATTRIBUTE14 in VARCHAR2,
56   X_ATTRIBUTE15 in VARCHAR2,
57   X_REQUEST_ID in NUMBER
58 );
59 --
60 procedure UPDATE_ROW (
61   X_UOM_CLASS in VARCHAR2,
62   X_UOM_CLASS_TL in VARCHAR2,
63   X_DESCRIPTION in VARCHAR2,
64   X_DISABLE_DATE in DATE,
65   X_ATTRIBUTE_CATEGORY in VARCHAR2,
66   X_ATTRIBUTE1 in VARCHAR2,
67   X_ATTRIBUTE2 in VARCHAR2,
68   X_ATTRIBUTE3 in VARCHAR2,
69   X_ATTRIBUTE4 in VARCHAR2,
70   X_ATTRIBUTE5 in VARCHAR2,
71   X_ATTRIBUTE6 in VARCHAR2,
72   X_ATTRIBUTE7 in VARCHAR2,
73   X_ATTRIBUTE8 in VARCHAR2,
74   X_ATTRIBUTE9 in VARCHAR2,
75   X_ATTRIBUTE10 in VARCHAR2,
76   X_ATTRIBUTE11 in VARCHAR2,
77   X_ATTRIBUTE12 in VARCHAR2,
78   X_ATTRIBUTE13 in VARCHAR2,
79   X_ATTRIBUTE14 in VARCHAR2,
80   X_ATTRIBUTE15 in VARCHAR2,
81   X_REQUEST_ID in NUMBER,
82   X_LAST_UPDATE_DATE in DATE,
83   X_LAST_UPDATED_BY in NUMBER,
84   X_LAST_UPDATE_LOGIN in NUMBER
85 );
86 --
87 procedure DELETE_ROW (
88   X_UOM_CLASS in VARCHAR2
89 );
90 --
91 procedure LOAD_ROW (
92   X_UOM_CLASS in VARCHAR2,
93   X_UOM_CLASS_TL in VARCHAR2,
94   X_DESCRIPTION in VARCHAR2,
95   X_OWNER in VARCHAR2,
96   X_DISABLE_DATE in DATE,
97   X_ATTRIBUTE_CATEGORY in VARCHAR2,
98   X_ATTRIBUTE1 in VARCHAR2,
99   X_ATTRIBUTE2 in VARCHAR2,
100   X_ATTRIBUTE3 in VARCHAR2,
101   X_ATTRIBUTE4 in VARCHAR2,
102   X_ATTRIBUTE5 in VARCHAR2,
103   X_ATTRIBUTE6 in VARCHAR2,
104   X_ATTRIBUTE7 in VARCHAR2,
105   X_ATTRIBUTE8 in VARCHAR2,
106   X_ATTRIBUTE9 in VARCHAR2,
107   X_ATTRIBUTE10 in VARCHAR2,
108   X_ATTRIBUTE11 in VARCHAR2,
109   X_ATTRIBUTE12 in VARCHAR2,
110   X_ATTRIBUTE13 in VARCHAR2,
111   X_ATTRIBUTE14 in VARCHAR2,
112   X_ATTRIBUTE15 in VARCHAR2,
113   X_REQUEST_ID in NUMBER,
114   X_LAST_UPDATE_DATE in DATE,
115   X_LAST_UPDATED_BY in NUMBER,
116   X_LAST_UPDATE_LOGIN in NUMBER,
117   X_APPL_SHORT_NAME in VARCHAR2
118 );
119 --
120 procedure TRANSLATE_ROW(
121   X_UOM_CLASS in VARCHAR2,
122   X_UOM_CLASS_TL in VARCHAR2,
123   X_DESCRIPTION in VARCHAR2,
124   X_OWNER in VARCHAR2
125 );
126 --
127 procedure ADD_LANGUAGE;
128 
129 --
130 /* this version takes x_language as the language for the user session
131  * created by Oracle Exchange
132  */
133 procedure INSERT_ROW (
134   X_ROWID IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
135   X_UOM_CLASS in VARCHAR2,
136   X_UOM_CLASS_TL in VARCHAR2,
137   X_DESCRIPTION in VARCHAR2,
138   X_DISABLE_DATE in DATE,
139   X_ATTRIBUTE_CATEGORY in VARCHAR2,
140   X_ATTRIBUTE1 in VARCHAR2,
141   X_ATTRIBUTE2 in VARCHAR2,
142   X_ATTRIBUTE3 in VARCHAR2,
143   X_ATTRIBUTE4 in VARCHAR2,
144   X_ATTRIBUTE5 in VARCHAR2,
145   X_ATTRIBUTE6 in VARCHAR2,
146   X_ATTRIBUTE7 in VARCHAR2,
147   X_ATTRIBUTE8 in VARCHAR2,
148   X_ATTRIBUTE9 in VARCHAR2,
149   X_ATTRIBUTE10 in VARCHAR2,
150   X_ATTRIBUTE11 in VARCHAR2,
151   X_ATTRIBUTE12 in VARCHAR2,
152   X_ATTRIBUTE13 in VARCHAR2,
153   X_ATTRIBUTE14 in VARCHAR2,
154   X_ATTRIBUTE15 in VARCHAR2,
155   X_REQUEST_ID in NUMBER,
156   X_PROGRAM_ID in NUMBER,
157   X_PROGRAM_APPLICATION_ID in NUMBER,
158   X_PROGRAM_UPDATE_DATE in DATE,
159   X_CREATION_DATE in DATE,
160   X_CREATED_BY in NUMBER,
161   X_LAST_UPDATE_DATE in DATE,
162   X_LAST_UPDATED_BY in NUMBER,
163   X_LAST_UPDATE_LOGIN in NUMBER,
164   X_LANGUAGE IN VARCHAR2
165 );
166 --
167 /* this version takes x_language as the language for the user session
168  * created by Oracle Exchange
169  */
170 procedure LOCK_ROW (
171   X_UOM_CLASS in VARCHAR2,
172   X_UOM_CLASS_TL in VARCHAR2,
173   X_DESCRIPTION in VARCHAR2,
174   X_DISABLE_DATE in DATE,
175   X_ATTRIBUTE_CATEGORY in VARCHAR2,
176   X_ATTRIBUTE1 in VARCHAR2,
177   X_ATTRIBUTE2 in VARCHAR2,
178   X_ATTRIBUTE3 in VARCHAR2,
179   X_ATTRIBUTE4 in VARCHAR2,
180   X_ATTRIBUTE5 in VARCHAR2,
181   X_ATTRIBUTE6 in VARCHAR2,
182   X_ATTRIBUTE7 in VARCHAR2,
183   X_ATTRIBUTE8 in VARCHAR2,
184   X_ATTRIBUTE9 in VARCHAR2,
185   X_ATTRIBUTE10 in VARCHAR2,
186   X_ATTRIBUTE11 in VARCHAR2,
187   X_ATTRIBUTE12 in VARCHAR2,
188   X_ATTRIBUTE13 in VARCHAR2,
189   X_ATTRIBUTE14 in VARCHAR2,
190   X_ATTRIBUTE15 in VARCHAR2,
191   X_REQUEST_ID in NUMBER,
192   X_LANGUAGE IN VARCHAR2
193 );
194 --
195 /* this version takes x_language as the language for the user session
196  * created by Oracle Exchange
197  */
198 procedure UPDATE_ROW (
199   X_UOM_CLASS in VARCHAR2,
200   X_UOM_CLASS_TL in VARCHAR2,
201   X_DESCRIPTION in VARCHAR2,
202   X_DISABLE_DATE in DATE,
203   X_ATTRIBUTE_CATEGORY in VARCHAR2,
204   X_ATTRIBUTE1 in VARCHAR2,
205   X_ATTRIBUTE2 in VARCHAR2,
206   X_ATTRIBUTE3 in VARCHAR2,
207   X_ATTRIBUTE4 in VARCHAR2,
208   X_ATTRIBUTE5 in VARCHAR2,
209   X_ATTRIBUTE6 in VARCHAR2,
210   X_ATTRIBUTE7 in VARCHAR2,
211   X_ATTRIBUTE8 in VARCHAR2,
212   X_ATTRIBUTE9 in VARCHAR2,
213   X_ATTRIBUTE10 in VARCHAR2,
214   X_ATTRIBUTE11 in VARCHAR2,
215   X_ATTRIBUTE12 in VARCHAR2,
216   X_ATTRIBUTE13 in VARCHAR2,
217   X_ATTRIBUTE14 in VARCHAR2,
218   X_ATTRIBUTE15 in VARCHAR2,
219   X_REQUEST_ID in NUMBER,
220   X_LAST_UPDATE_DATE in DATE,
221   X_LAST_UPDATED_BY in NUMBER,
222   X_LAST_UPDATE_LOGIN in NUMBER,
223   X_LANGUAGE IN VARCHAR2
224 );
225 --
226 
227 end MTL_UOM_CLASSES_TL_PKG;