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

Source


1 package BNE_ATTRIBUTES_PKG as
2 /* $Header: bneattss.pls 120.2 2005/06/29 03:39:40 dvayro noship $ */
3 
4 procedure INSERT_ROW (
5   X_ROWID in out NOCOPY VARCHAR2,
6   X_APPLICATION_ID in NUMBER,
7   X_ATTRIBUTE_CODE in VARCHAR2,
8   X_OBJECT_VERSION_NUMBER in NUMBER,
9   X_ATTRIBUTE1 in VARCHAR2,
10   X_ATTRIBUTE2 in VARCHAR2,
11   X_ATTRIBUTE3 in VARCHAR2,
12   X_ATTRIBUTE4 in VARCHAR2,
13   X_ATTRIBUTE5 in VARCHAR2,
14   X_ATTRIBUTE6 in VARCHAR2,
15   X_ATTRIBUTE7 in VARCHAR2,
16   X_ATTRIBUTE8 in VARCHAR2,
17   X_ATTRIBUTE9 in VARCHAR2,
18   X_ATTRIBUTE10 in VARCHAR2,
19   X_ATTRIBUTE11 in VARCHAR2,
20   X_ATTRIBUTE12 in VARCHAR2,
21   X_ATTRIBUTE13 in VARCHAR2,
22   X_ATTRIBUTE14 in VARCHAR2,
23   X_ATTRIBUTE15 in VARCHAR2,
24   X_ATTRIBUTE16 in VARCHAR2,
25   X_ATTRIBUTE17 in VARCHAR2,
26   X_ATTRIBUTE18 in VARCHAR2,
27   X_ATTRIBUTE19 in VARCHAR2,
28   X_ATTRIBUTE20 in VARCHAR2,
29   X_ATTRIBUTE21 in VARCHAR2,
30   X_ATTRIBUTE22 in VARCHAR2,
31   X_ATTRIBUTE23 in VARCHAR2,
32   X_ATTRIBUTE24 in VARCHAR2,
33   X_ATTRIBUTE25 in VARCHAR2,
34   X_ATTRIBUTE26 in VARCHAR2,
35   X_ATTRIBUTE27 in VARCHAR2,
36   X_ATTRIBUTE28 in VARCHAR2,
37   X_ATTRIBUTE29 in VARCHAR2,
38   X_ATTRIBUTE30 in VARCHAR2,
39   X_CREATION_DATE in DATE,
40   X_CREATED_BY in NUMBER,
41   X_LAST_UPDATE_DATE in DATE,
42   X_LAST_UPDATED_BY in NUMBER,
43   X_LAST_UPDATE_LOGIN in NUMBER,
44   X_ATTRIBUTE_NAME1 in VARCHAR2 DEFAULT NULL,
45   X_ATTRIBUTE_NAME2 in VARCHAR2 DEFAULT NULL,
46   X_ATTRIBUTE_NAME3 in VARCHAR2 DEFAULT NULL,
47   X_ATTRIBUTE_NAME4 in VARCHAR2 DEFAULT NULL,
48   X_ATTRIBUTE_NAME5 in VARCHAR2 DEFAULT NULL,
49   X_ATTRIBUTE_NAME6 in VARCHAR2 DEFAULT NULL,
50   X_ATTRIBUTE_NAME7 in VARCHAR2 DEFAULT NULL,
51   X_ATTRIBUTE_NAME8 in VARCHAR2 DEFAULT NULL,
52   X_ATTRIBUTE_NAME9 in VARCHAR2 DEFAULT NULL,
53   X_ATTRIBUTE_NAME10 in VARCHAR2 DEFAULT NULL,
54   X_ATTRIBUTE_NAME11 in VARCHAR2 DEFAULT NULL,
55   X_ATTRIBUTE_NAME12 in VARCHAR2 DEFAULT NULL,
56   X_ATTRIBUTE_NAME13 in VARCHAR2 DEFAULT NULL,
57   X_ATTRIBUTE_NAME14 in VARCHAR2 DEFAULT NULL,
58   X_ATTRIBUTE_NAME15 in VARCHAR2 DEFAULT NULL,
59   X_ATTRIBUTE_NAME16 in VARCHAR2 DEFAULT NULL,
60   X_ATTRIBUTE_NAME17 in VARCHAR2 DEFAULT NULL,
61   X_ATTRIBUTE_NAME18 in VARCHAR2 DEFAULT NULL,
62   X_ATTRIBUTE_NAME19 in VARCHAR2 DEFAULT NULL,
63   X_ATTRIBUTE_NAME20 in VARCHAR2 DEFAULT NULL,
64   X_ATTRIBUTE_NAME21 in VARCHAR2 DEFAULT NULL,
65   X_ATTRIBUTE_NAME22 in VARCHAR2 DEFAULT NULL,
66   X_ATTRIBUTE_NAME23 in VARCHAR2 DEFAULT NULL,
67   X_ATTRIBUTE_NAME24 in VARCHAR2 DEFAULT NULL,
68   X_ATTRIBUTE_NAME25 in VARCHAR2 DEFAULT NULL,
69   X_ATTRIBUTE_NAME26 in VARCHAR2 DEFAULT NULL,
70   X_ATTRIBUTE_NAME27 in VARCHAR2 DEFAULT NULL,
71   X_ATTRIBUTE_NAME28 in VARCHAR2 DEFAULT NULL,
72   X_ATTRIBUTE_NAME29 in VARCHAR2 DEFAULT NULL,
73   X_ATTRIBUTE_NAME30 in VARCHAR2 DEFAULT NULL
74   );
75 procedure LOCK_ROW (
76   X_APPLICATION_ID in NUMBER,
77   X_ATTRIBUTE_CODE in VARCHAR2,
78   X_OBJECT_VERSION_NUMBER in NUMBER,
79   X_ATTRIBUTE1 in VARCHAR2,
80   X_ATTRIBUTE2 in VARCHAR2,
81   X_ATTRIBUTE3 in VARCHAR2,
82   X_ATTRIBUTE4 in VARCHAR2,
83   X_ATTRIBUTE5 in VARCHAR2,
84   X_ATTRIBUTE6 in VARCHAR2,
85   X_ATTRIBUTE7 in VARCHAR2,
86   X_ATTRIBUTE8 in VARCHAR2,
87   X_ATTRIBUTE9 in VARCHAR2,
88   X_ATTRIBUTE10 in VARCHAR2,
89   X_ATTRIBUTE11 in VARCHAR2,
90   X_ATTRIBUTE12 in VARCHAR2,
91   X_ATTRIBUTE13 in VARCHAR2,
92   X_ATTRIBUTE14 in VARCHAR2,
93   X_ATTRIBUTE15 in VARCHAR2,
94   X_ATTRIBUTE16 in VARCHAR2,
95   X_ATTRIBUTE17 in VARCHAR2,
96   X_ATTRIBUTE18 in VARCHAR2,
97   X_ATTRIBUTE19 in VARCHAR2,
98   X_ATTRIBUTE20 in VARCHAR2,
99   X_ATTRIBUTE21 in VARCHAR2,
100   X_ATTRIBUTE22 in VARCHAR2,
101   X_ATTRIBUTE23 in VARCHAR2,
102   X_ATTRIBUTE24 in VARCHAR2,
103   X_ATTRIBUTE25 in VARCHAR2,
104   X_ATTRIBUTE26 in VARCHAR2,
105   X_ATTRIBUTE27 in VARCHAR2,
106   X_ATTRIBUTE28 in VARCHAR2,
107   X_ATTRIBUTE29 in VARCHAR2,
108   X_ATTRIBUTE30 in VARCHAR2,
109   X_ATTRIBUTE_NAME1 in VARCHAR2 DEFAULT NULL,
110   X_ATTRIBUTE_NAME2 in VARCHAR2 DEFAULT NULL,
111   X_ATTRIBUTE_NAME3 in VARCHAR2 DEFAULT NULL,
112   X_ATTRIBUTE_NAME4 in VARCHAR2 DEFAULT NULL,
113   X_ATTRIBUTE_NAME5 in VARCHAR2 DEFAULT NULL,
114   X_ATTRIBUTE_NAME6 in VARCHAR2 DEFAULT NULL,
115   X_ATTRIBUTE_NAME7 in VARCHAR2 DEFAULT NULL,
116   X_ATTRIBUTE_NAME8 in VARCHAR2 DEFAULT NULL,
117   X_ATTRIBUTE_NAME9 in VARCHAR2 DEFAULT NULL,
118   X_ATTRIBUTE_NAME10 in VARCHAR2 DEFAULT NULL,
119   X_ATTRIBUTE_NAME11 in VARCHAR2 DEFAULT NULL,
120   X_ATTRIBUTE_NAME12 in VARCHAR2 DEFAULT NULL,
121   X_ATTRIBUTE_NAME13 in VARCHAR2 DEFAULT NULL,
122   X_ATTRIBUTE_NAME14 in VARCHAR2 DEFAULT NULL,
123   X_ATTRIBUTE_NAME15 in VARCHAR2 DEFAULT NULL,
124   X_ATTRIBUTE_NAME16 in VARCHAR2 DEFAULT NULL,
125   X_ATTRIBUTE_NAME17 in VARCHAR2 DEFAULT NULL,
126   X_ATTRIBUTE_NAME18 in VARCHAR2 DEFAULT NULL,
127   X_ATTRIBUTE_NAME19 in VARCHAR2 DEFAULT NULL,
128   X_ATTRIBUTE_NAME20 in VARCHAR2 DEFAULT NULL,
129   X_ATTRIBUTE_NAME21 in VARCHAR2 DEFAULT NULL,
130   X_ATTRIBUTE_NAME22 in VARCHAR2 DEFAULT NULL,
131   X_ATTRIBUTE_NAME23 in VARCHAR2 DEFAULT NULL,
132   X_ATTRIBUTE_NAME24 in VARCHAR2 DEFAULT NULL,
133   X_ATTRIBUTE_NAME25 in VARCHAR2 DEFAULT NULL,
134   X_ATTRIBUTE_NAME26 in VARCHAR2 DEFAULT NULL,
135   X_ATTRIBUTE_NAME27 in VARCHAR2 DEFAULT NULL,
136   X_ATTRIBUTE_NAME28 in VARCHAR2 DEFAULT NULL,
137   X_ATTRIBUTE_NAME29 in VARCHAR2 DEFAULT NULL,
138   X_ATTRIBUTE_NAME30 in VARCHAR2 DEFAULT NULL
139 );
140 procedure UPDATE_ROW (
141   X_APPLICATION_ID in NUMBER,
142   X_ATTRIBUTE_CODE in VARCHAR2,
143   X_OBJECT_VERSION_NUMBER in NUMBER,
144   X_ATTRIBUTE1 in VARCHAR2,
145   X_ATTRIBUTE2 in VARCHAR2,
146   X_ATTRIBUTE3 in VARCHAR2,
147   X_ATTRIBUTE4 in VARCHAR2,
148   X_ATTRIBUTE5 in VARCHAR2,
149   X_ATTRIBUTE6 in VARCHAR2,
150   X_ATTRIBUTE7 in VARCHAR2,
151   X_ATTRIBUTE8 in VARCHAR2,
152   X_ATTRIBUTE9 in VARCHAR2,
153   X_ATTRIBUTE10 in VARCHAR2,
154   X_ATTRIBUTE11 in VARCHAR2,
155   X_ATTRIBUTE12 in VARCHAR2,
156   X_ATTRIBUTE13 in VARCHAR2,
157   X_ATTRIBUTE14 in VARCHAR2,
158   X_ATTRIBUTE15 in VARCHAR2,
159   X_ATTRIBUTE16 in VARCHAR2,
160   X_ATTRIBUTE17 in VARCHAR2,
161   X_ATTRIBUTE18 in VARCHAR2,
162   X_ATTRIBUTE19 in VARCHAR2,
163   X_ATTRIBUTE20 in VARCHAR2,
164   X_ATTRIBUTE21 in VARCHAR2,
165   X_ATTRIBUTE22 in VARCHAR2,
166   X_ATTRIBUTE23 in VARCHAR2,
167   X_ATTRIBUTE24 in VARCHAR2,
168   X_ATTRIBUTE25 in VARCHAR2,
169   X_ATTRIBUTE26 in VARCHAR2,
170   X_ATTRIBUTE27 in VARCHAR2,
171   X_ATTRIBUTE28 in VARCHAR2,
172   X_ATTRIBUTE29 in VARCHAR2,
173   X_ATTRIBUTE30 in VARCHAR2,
174   X_LAST_UPDATE_DATE in DATE,
175   X_LAST_UPDATED_BY in NUMBER,
176   X_LAST_UPDATE_LOGIN in NUMBER,
177   X_ATTRIBUTE_NAME1 in VARCHAR2 DEFAULT NULL,
178   X_ATTRIBUTE_NAME2 in VARCHAR2 DEFAULT NULL,
179   X_ATTRIBUTE_NAME3 in VARCHAR2 DEFAULT NULL,
180   X_ATTRIBUTE_NAME4 in VARCHAR2 DEFAULT NULL,
181   X_ATTRIBUTE_NAME5 in VARCHAR2 DEFAULT NULL,
182   X_ATTRIBUTE_NAME6 in VARCHAR2 DEFAULT NULL,
183   X_ATTRIBUTE_NAME7 in VARCHAR2 DEFAULT NULL,
184   X_ATTRIBUTE_NAME8 in VARCHAR2 DEFAULT NULL,
185   X_ATTRIBUTE_NAME9 in VARCHAR2 DEFAULT NULL,
186   X_ATTRIBUTE_NAME10 in VARCHAR2 DEFAULT NULL,
187   X_ATTRIBUTE_NAME11 in VARCHAR2 DEFAULT NULL,
188   X_ATTRIBUTE_NAME12 in VARCHAR2 DEFAULT NULL,
189   X_ATTRIBUTE_NAME13 in VARCHAR2 DEFAULT NULL,
190   X_ATTRIBUTE_NAME14 in VARCHAR2 DEFAULT NULL,
191   X_ATTRIBUTE_NAME15 in VARCHAR2 DEFAULT NULL,
192   X_ATTRIBUTE_NAME16 in VARCHAR2 DEFAULT NULL,
193   X_ATTRIBUTE_NAME17 in VARCHAR2 DEFAULT NULL,
194   X_ATTRIBUTE_NAME18 in VARCHAR2 DEFAULT NULL,
195   X_ATTRIBUTE_NAME19 in VARCHAR2 DEFAULT NULL,
196   X_ATTRIBUTE_NAME20 in VARCHAR2 DEFAULT NULL,
197   X_ATTRIBUTE_NAME21 in VARCHAR2 DEFAULT NULL,
198   X_ATTRIBUTE_NAME22 in VARCHAR2 DEFAULT NULL,
199   X_ATTRIBUTE_NAME23 in VARCHAR2 DEFAULT NULL,
200   X_ATTRIBUTE_NAME24 in VARCHAR2 DEFAULT NULL,
201   X_ATTRIBUTE_NAME25 in VARCHAR2 DEFAULT NULL,
202   X_ATTRIBUTE_NAME26 in VARCHAR2 DEFAULT NULL,
203   X_ATTRIBUTE_NAME27 in VARCHAR2 DEFAULT NULL,
204   X_ATTRIBUTE_NAME28 in VARCHAR2 DEFAULT NULL,
205   X_ATTRIBUTE_NAME29 in VARCHAR2 DEFAULT NULL,
206   X_ATTRIBUTE_NAME30 in VARCHAR2 DEFAULT NULL
207 );
208 procedure DELETE_ROW (
209   X_APPLICATION_ID in NUMBER,
210   X_ATTRIBUTE_CODE in VARCHAR2
211 );
212 procedure ADD_LANGUAGE;
213 procedure LOAD_ROW(
214   x_attribute_asn         IN VARCHAR2,
215   x_attribute_code        IN VARCHAR2,
216   x_object_version_number IN VARCHAR2,
217   x_attribute1            IN VARCHAR2,
218   x_attribute2            IN VARCHAR2,
219   x_attribute3            IN VARCHAR2,
220   x_attribute4            IN VARCHAR2,
221   x_attribute5            IN VARCHAR2,
222   x_attribute6            IN VARCHAR2,
223   x_attribute7            IN VARCHAR2,
224   x_attribute8            IN VARCHAR2,
225   x_attribute9            IN VARCHAR2,
226   x_attribute10           IN VARCHAR2,
227   x_attribute11           IN VARCHAR2,
228   x_attribute12           IN VARCHAR2,
229   x_attribute13           IN VARCHAR2,
230   x_attribute14           IN VARCHAR2,
231   x_attribute15           IN VARCHAR2,
232   x_attribute16           IN VARCHAR2,
233   x_attribute17           IN VARCHAR2,
234   x_attribute18           IN VARCHAR2,
235   x_attribute19           IN VARCHAR2,
236   x_attribute20           IN VARCHAR2,
237   x_attribute21           IN VARCHAR2,
238   x_attribute22           IN VARCHAR2,
239   x_attribute23           IN VARCHAR2,
240   x_attribute24           IN VARCHAR2,
241   x_attribute25           IN VARCHAR2,
242   x_attribute26           IN VARCHAR2,
243   x_attribute27           IN VARCHAR2,
244   x_attribute28           IN VARCHAR2,
245   x_attribute29           IN VARCHAR2,
246   x_attribute30           IN VARCHAR2,
247   x_owner                 IN VARCHAR2,
248   x_last_update_date      IN VARCHAR2,
249   x_custom_mode           IN VARCHAR2,
250   X_ATTRIBUTE_NAME1 in VARCHAR2 DEFAULT NULL,
251   X_ATTRIBUTE_NAME2 in VARCHAR2 DEFAULT NULL,
252   X_ATTRIBUTE_NAME3 in VARCHAR2 DEFAULT NULL,
253   X_ATTRIBUTE_NAME4 in VARCHAR2 DEFAULT NULL,
254   X_ATTRIBUTE_NAME5 in VARCHAR2 DEFAULT NULL,
255   X_ATTRIBUTE_NAME6 in VARCHAR2 DEFAULT NULL,
256   X_ATTRIBUTE_NAME7 in VARCHAR2 DEFAULT NULL,
257   X_ATTRIBUTE_NAME8 in VARCHAR2 DEFAULT NULL,
258   X_ATTRIBUTE_NAME9 in VARCHAR2 DEFAULT NULL,
259   X_ATTRIBUTE_NAME10 in VARCHAR2 DEFAULT NULL,
260   X_ATTRIBUTE_NAME11 in VARCHAR2 DEFAULT NULL,
261   X_ATTRIBUTE_NAME12 in VARCHAR2 DEFAULT NULL,
262   X_ATTRIBUTE_NAME13 in VARCHAR2 DEFAULT NULL,
263   X_ATTRIBUTE_NAME14 in VARCHAR2 DEFAULT NULL,
264   X_ATTRIBUTE_NAME15 in VARCHAR2 DEFAULT NULL,
265   X_ATTRIBUTE_NAME16 in VARCHAR2 DEFAULT NULL,
266   X_ATTRIBUTE_NAME17 in VARCHAR2 DEFAULT NULL,
267   X_ATTRIBUTE_NAME18 in VARCHAR2 DEFAULT NULL,
268   X_ATTRIBUTE_NAME19 in VARCHAR2 DEFAULT NULL,
269   X_ATTRIBUTE_NAME20 in VARCHAR2 DEFAULT NULL,
270   X_ATTRIBUTE_NAME21 in VARCHAR2 DEFAULT NULL,
271   X_ATTRIBUTE_NAME22 in VARCHAR2 DEFAULT NULL,
272   X_ATTRIBUTE_NAME23 in VARCHAR2 DEFAULT NULL,
273   X_ATTRIBUTE_NAME24 in VARCHAR2 DEFAULT NULL,
274   X_ATTRIBUTE_NAME25 in VARCHAR2 DEFAULT NULL,
275   X_ATTRIBUTE_NAME26 in VARCHAR2 DEFAULT NULL,
276   X_ATTRIBUTE_NAME27 in VARCHAR2 DEFAULT NULL,
277   X_ATTRIBUTE_NAME28 in VARCHAR2 DEFAULT NULL,
278   X_ATTRIBUTE_NAME29 in VARCHAR2 DEFAULT NULL,
279   X_ATTRIBUTE_NAME30 in VARCHAR2 DEFAULT NULL
280 );
281 
282 end BNE_ATTRIBUTES_PKG;