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

Source


1 package FA_CATEGORIES_PKG as
2 /* $Header: faxicas.pls 120.4 2005/07/20 00:38:49 glchen ship $ */
3 procedure INSERT_ROW (
4   X_ROWID in out nocopy VARCHAR2,
5   X_CATEGORY_ID in NUMBER,
6   X_SUMMARY_FLAG in VARCHAR2,
7   X_ENABLED_FLAG in VARCHAR2,
8   X_OWNED_LEASED in VARCHAR2,
9   X_CATEGORY_TYPE in VARCHAR2,
10   X_CAPITALIZE_FLAG in VARCHAR2,
11   X_DESCRIPTION in VARCHAR2,
12   X_SEGMENT1 in VARCHAR2,
13   X_SEGMENT2 in VARCHAR2,
14   X_SEGMENT3 in VARCHAR2,
15   X_SEGMENT4 in VARCHAR2,
16   X_SEGMENT5 in VARCHAR2,
17   X_SEGMENT6 in VARCHAR2,
18   X_SEGMENT7 in VARCHAR2,
19   X_START_DATE_ACTIVE in DATE,
20   X_END_DATE_ACTIVE in DATE,
21   X_PROPERTY_TYPE_CODE in VARCHAR2,
22   X_PROPERTY_1245_1250_CODE in VARCHAR2,
23   X_DATE_INEFFECTIVE in DATE,
24   X_ATTRIBUTE1 in VARCHAR2 DEFAULT NULL,
25   X_ATTRIBUTE2 in VARCHAR2 DEFAULT NULL,
26   X_ATTRIBUTE3 in VARCHAR2 DEFAULT NULL,
27   X_ATTRIBUTE4 in VARCHAR2 DEFAULT NULL,
28   X_ATTRIBUTE5 in VARCHAR2 DEFAULT NULL,
29   X_ATTRIBUTE6 in VARCHAR2 DEFAULT NULL,
30   X_ATTRIBUTE7 in VARCHAR2 DEFAULT NULL,
31   X_ATTRIBUTE8 in VARCHAR2 DEFAULT NULL,
32   X_ATTRIBUTE9 in VARCHAR2 DEFAULT NULL,
33   X_ATTRIBUTE10 in VARCHAR2 DEFAULT NULL,
34   X_ATTRIBUTE11 in VARCHAR2 DEFAULT NULL,
35   X_ATTRIBUTE12 in VARCHAR2 DEFAULT NULL,
36   X_ATTRIBUTE13 in VARCHAR2 DEFAULT NULL,
37   X_ATTRIBUTE14 in VARCHAR2 DEFAULT NULL,
38   X_ATTRIBUTE15 in VARCHAR2 DEFAULT NULL,
39   X_ATTRIBUTE_CATEGORY_CODE in VARCHAR2 DEFAULT NULL,
40   X_PRODUCTION_CAPACITY in NUMBER DEFAULT NULL,
41   X_GLOBAL_ATTRIBUTE1 in VARCHAR2 DEFAULT NULL,
42   X_GLOBAL_ATTRIBUTE2 in VARCHAR2 DEFAULT NULL,
43   X_GLOBAL_ATTRIBUTE3 in VARCHAR2 DEFAULT NULL,
44   X_GLOBAL_ATTRIBUTE4 in VARCHAR2 DEFAULT NULL,
45   X_GLOBAL_ATTRIBUTE5 in VARCHAR2 DEFAULT NULL,
46   X_GLOBAL_ATTRIBUTE6 in VARCHAR2 DEFAULT NULL,
47   X_GLOBAL_ATTRIBUTE7 in VARCHAR2 DEFAULT NULL,
48   X_GLOBAL_ATTRIBUTE8 in VARCHAR2 DEFAULT NULL,
49   X_GLOBAL_ATTRIBUTE9 in VARCHAR2 DEFAULT NULL,
50   X_GLOBAL_ATTRIBUTE10 in VARCHAR2 DEFAULT NULL,
51   X_GLOBAL_ATTRIBUTE11 in VARCHAR2 DEFAULT NULL,
52   X_GLOBAL_ATTRIBUTE12 in VARCHAR2 DEFAULT NULL,
53   X_GLOBAL_ATTRIBUTE13 in VARCHAR2 DEFAULT NULL,
54   X_GLOBAL_ATTRIBUTE14 in VARCHAR2 DEFAULT NULL,
55   X_GLOBAL_ATTRIBUTE15 in VARCHAR2 DEFAULT NULL,
56   X_GLOBAL_ATTRIBUTE16 in VARCHAR2 DEFAULT NULL,
57   X_GLOBAL_ATTRIBUTE17 in VARCHAR2 DEFAULT NULL,
58   X_GLOBAL_ATTRIBUTE18 in VARCHAR2 DEFAULT NULL,
59   X_GLOBAL_ATTRIBUTE19 in VARCHAR2 DEFAULT NULL,
60   X_GLOBAL_ATTRIBUTE20 in VARCHAR2 DEFAULT NULL,
61   X_GLOBAL_ATTRIBUTE_CATEGORY in VARCHAR2 DEFAULT NULL,
62   X_INVENTORIAL in VARCHAR2,
63   X_CREATION_DATE in DATE,
64   X_CREATED_BY in NUMBER,
65   X_LAST_UPDATE_DATE in DATE,
66   X_LAST_UPDATED_BY in NUMBER,
67   X_LAST_UPDATE_LOGIN in NUMBER,
68   p_log_level_rec    in      fa_api_types.log_level_rec_type default null
69 );
70 
71 procedure LOCK_ROW (
72   X_CATEGORY_ID in NUMBER,
73   X_SUMMARY_FLAG in VARCHAR2,
74   X_ENABLED_FLAG in VARCHAR2,
75   X_OWNED_LEASED in VARCHAR2,
76   X_CATEGORY_TYPE in VARCHAR2,
77   X_CAPITALIZE_FLAG in VARCHAR2,
78   X_DESCRIPTION in VARCHAR2,
79   X_SEGMENT1 in VARCHAR2,
80   X_SEGMENT2 in VARCHAR2,
81   X_SEGMENT3 in VARCHAR2,
82   X_SEGMENT4 in VARCHAR2,
83   X_SEGMENT5 in VARCHAR2,
84   X_SEGMENT6 in VARCHAR2,
85   X_SEGMENT7 in VARCHAR2,
86   X_START_DATE_ACTIVE in DATE,
87   X_END_DATE_ACTIVE in DATE,
88   X_PROPERTY_TYPE_CODE in VARCHAR2,
89   X_PROPERTY_1245_1250_CODE in VARCHAR2,
90   X_DATE_INEFFECTIVE in DATE,
91   X_ATTRIBUTE1 in VARCHAR2 DEFAULT NULL,
92   X_ATTRIBUTE2 in VARCHAR2 DEFAULT NULL,
93   X_ATTRIBUTE3 in VARCHAR2 DEFAULT NULL,
94   X_ATTRIBUTE4 in VARCHAR2 DEFAULT NULL,
95   X_ATTRIBUTE5 in VARCHAR2 DEFAULT NULL,
96   X_ATTRIBUTE6 in VARCHAR2 DEFAULT NULL,
97   X_ATTRIBUTE7 in VARCHAR2 DEFAULT NULL,
98   X_ATTRIBUTE8 in VARCHAR2 DEFAULT NULL,
99   X_ATTRIBUTE9 in VARCHAR2 DEFAULT NULL,
100   X_ATTRIBUTE10 in VARCHAR2 DEFAULT NULL,
101   X_ATTRIBUTE11 in VARCHAR2 DEFAULT NULL,
102   X_ATTRIBUTE12 in VARCHAR2 DEFAULT NULL,
103   X_ATTRIBUTE13 in VARCHAR2 DEFAULT NULL,
104   X_ATTRIBUTE14 in VARCHAR2 DEFAULT NULL,
105   X_ATTRIBUTE15 in VARCHAR2 DEFAULT NULL,
106   X_ATTRIBUTE_CATEGORY_CODE in VARCHAR2 DEFAULT NULL,
107   X_PRODUCTION_CAPACITY in NUMBER DEFAULT NULL,
108   X_GLOBAL_ATTRIBUTE1 in VARCHAR2 DEFAULT NULL,
109   X_GLOBAL_ATTRIBUTE2 in VARCHAR2 DEFAULT NULL,
110   X_GLOBAL_ATTRIBUTE3 in VARCHAR2 DEFAULT NULL,
111   X_GLOBAL_ATTRIBUTE4 in VARCHAR2 DEFAULT NULL,
112   X_GLOBAL_ATTRIBUTE5 in VARCHAR2 DEFAULT NULL,
113   X_GLOBAL_ATTRIBUTE6 in VARCHAR2 DEFAULT NULL,
114   X_GLOBAL_ATTRIBUTE7 in VARCHAR2 DEFAULT NULL,
115   X_GLOBAL_ATTRIBUTE8 in VARCHAR2 DEFAULT NULL,
116   X_GLOBAL_ATTRIBUTE9 in VARCHAR2 DEFAULT NULL,
117   X_GLOBAL_ATTRIBUTE10 in VARCHAR2 DEFAULT NULL,
118   X_GLOBAL_ATTRIBUTE11 in VARCHAR2 DEFAULT NULL,
119   X_GLOBAL_ATTRIBUTE12 in VARCHAR2 DEFAULT NULL,
120   X_GLOBAL_ATTRIBUTE13 in VARCHAR2 DEFAULT NULL,
121   X_GLOBAL_ATTRIBUTE14 in VARCHAR2 DEFAULT NULL,
122   X_GLOBAL_ATTRIBUTE15 in VARCHAR2 DEFAULT NULL,
123   X_GLOBAL_ATTRIBUTE16 in VARCHAR2 DEFAULT NULL,
124   X_GLOBAL_ATTRIBUTE17 in VARCHAR2 DEFAULT NULL,
125   X_GLOBAL_ATTRIBUTE18 in VARCHAR2 DEFAULT NULL,
126   X_GLOBAL_ATTRIBUTE19 in VARCHAR2 DEFAULT NULL,
127   X_GLOBAL_ATTRIBUTE20 in VARCHAR2 DEFAULT NULL,
128   X_GLOBAL_ATTRIBUTE_CATEGORY in VARCHAR2 DEFAULT NULL,
129   X_INVENTORIAL in VARCHAR2,
130   p_log_level_rec    in      fa_api_types.log_level_rec_type default null
131 );
132 
133 procedure UPDATE_ROW (
134   X_CATEGORY_ID in NUMBER,
135   X_SUMMARY_FLAG in VARCHAR2,
136   X_ENABLED_FLAG in VARCHAR2,
137   X_OWNED_LEASED in VARCHAR2,
138   X_CATEGORY_TYPE in VARCHAR2,
139   X_CAPITALIZE_FLAG in VARCHAR2,
140   X_DESCRIPTION in VARCHAR2,
141   X_SEGMENT1 in VARCHAR2,
142   X_SEGMENT2 in VARCHAR2,
143   X_SEGMENT3 in VARCHAR2,
144   X_SEGMENT4 in VARCHAR2,
145   X_SEGMENT5 in VARCHAR2,
146   X_SEGMENT6 in VARCHAR2,
147   X_SEGMENT7 in VARCHAR2,
148   X_START_DATE_ACTIVE in DATE,
149   X_END_DATE_ACTIVE in DATE,
150   X_PROPERTY_TYPE_CODE in VARCHAR2,
151   X_PROPERTY_1245_1250_CODE in VARCHAR2,
152   X_DATE_INEFFECTIVE in DATE,
153   X_ATTRIBUTE1 in VARCHAR2 DEFAULT NULL,
154   X_ATTRIBUTE2 in VARCHAR2 DEFAULT NULL,
155   X_ATTRIBUTE3 in VARCHAR2 DEFAULT NULL,
156   X_ATTRIBUTE4 in VARCHAR2 DEFAULT NULL,
157   X_ATTRIBUTE5 in VARCHAR2 DEFAULT NULL,
158   X_ATTRIBUTE6 in VARCHAR2 DEFAULT NULL,
159   X_ATTRIBUTE7 in VARCHAR2 DEFAULT NULL,
160   X_ATTRIBUTE8 in VARCHAR2 DEFAULT NULL,
161   X_ATTRIBUTE9 in VARCHAR2 DEFAULT NULL,
162   X_ATTRIBUTE10 in VARCHAR2 DEFAULT NULL,
163   X_ATTRIBUTE11 in VARCHAR2 DEFAULT NULL,
164   X_ATTRIBUTE12 in VARCHAR2 DEFAULT NULL,
165   X_ATTRIBUTE13 in VARCHAR2 DEFAULT NULL,
166   X_ATTRIBUTE14 in VARCHAR2 DEFAULT NULL,
167   X_ATTRIBUTE15 in VARCHAR2 DEFAULT NULL,
168   X_ATTRIBUTE_CATEGORY_CODE in VARCHAR2 DEFAULT NULL,
169   X_PRODUCTION_CAPACITY in NUMBER DEFAULT NULL,
170   X_GLOBAL_ATTRIBUTE1 in VARCHAR2 DEFAULT NULL,
171   X_GLOBAL_ATTRIBUTE2 in VARCHAR2 DEFAULT NULL,
172   X_GLOBAL_ATTRIBUTE3 in VARCHAR2 DEFAULT NULL,
173   X_GLOBAL_ATTRIBUTE4 in VARCHAR2 DEFAULT NULL,
174   X_GLOBAL_ATTRIBUTE5 in VARCHAR2 DEFAULT NULL,
175   X_GLOBAL_ATTRIBUTE6 in VARCHAR2 DEFAULT NULL,
176   X_GLOBAL_ATTRIBUTE7 in VARCHAR2 DEFAULT NULL,
177   X_GLOBAL_ATTRIBUTE8 in VARCHAR2 DEFAULT NULL,
178   X_GLOBAL_ATTRIBUTE9 in VARCHAR2 DEFAULT NULL,
179   X_GLOBAL_ATTRIBUTE10 in VARCHAR2 DEFAULT NULL,
180   X_GLOBAL_ATTRIBUTE11 in VARCHAR2 DEFAULT NULL,
181   X_GLOBAL_ATTRIBUTE12 in VARCHAR2 DEFAULT NULL,
182   X_GLOBAL_ATTRIBUTE13 in VARCHAR2 DEFAULT NULL,
183   X_GLOBAL_ATTRIBUTE14 in VARCHAR2 DEFAULT NULL,
184   X_GLOBAL_ATTRIBUTE15 in VARCHAR2 DEFAULT NULL,
185   X_GLOBAL_ATTRIBUTE16 in VARCHAR2 DEFAULT NULL,
186   X_GLOBAL_ATTRIBUTE17 in VARCHAR2 DEFAULT NULL,
187   X_GLOBAL_ATTRIBUTE18 in VARCHAR2 DEFAULT NULL,
188   X_GLOBAL_ATTRIBUTE19 in VARCHAR2 DEFAULT NULL,
189   X_GLOBAL_ATTRIBUTE20 in VARCHAR2 DEFAULT NULL,
190   X_GLOBAL_ATTRIBUTE_CATEGORY in VARCHAR2 DEFAULT NULL,
191   X_INVENTORIAL in VARCHAR2,
192   X_LAST_UPDATE_DATE in DATE,
193   X_LAST_UPDATED_BY in NUMBER,
194   X_LAST_UPDATE_LOGIN in NUMBER,
195   p_log_level_rec    in      fa_api_types.log_level_rec_type default null
196 );
197 
198 procedure DELETE_ROW (
199   X_CATEGORY_ID in NUMBER
200  ,p_log_level_rec    in      fa_api_types.log_level_rec_type default null
201 );
202 
203 procedure ADD_LANGUAGE(p_log_level_rec    in      fa_api_types.log_level_rec_type default null);
204 
205 procedure LOAD_ROW (
206   X_CUSTOM_MODE in VARCHAR2,
207   X_CATEGORY_ID in NUMBER,
208   X_OWNER in VARCHAR2,
209   X_LAST_UPDATE_DATE in DATE,
210   X_SUMMARY_FLAG in VARCHAR2,
211   X_ENABLED_FLAG in VARCHAR2,
212   X_OWNED_LEASED in VARCHAR2,
213   X_PRODUCTION_CAPACITY in NUMBER DEFAULT NULL,
214   X_CATEGORY_TYPE in VARCHAR2,
215   X_CAPITALIZE_FLAG in VARCHAR2,
216   X_DESCRIPTION in VARCHAR2,
217   X_SEGMENT1 in VARCHAR2,
218   X_SEGMENT2 in VARCHAR2,
219   X_SEGMENT3 in VARCHAR2,
220   X_SEGMENT4 in VARCHAR2,
221   X_SEGMENT5 in VARCHAR2,
222   X_SEGMENT6 in VARCHAR2,
223   X_SEGMENT7 in VARCHAR2,
224   X_START_DATE_ACTIVE in DATE,
225   X_END_DATE_ACTIVE in DATE,
226   X_PROPERTY_TYPE_CODE in VARCHAR2,
227   X_PROPERTY_1245_1250_CODE in VARCHAR2,
228   X_DATE_INEFFECTIVE in DATE,
229   X_INVENTORIAL in VARCHAR2,
230   X_ATTRIBUTE1 in VARCHAR2 DEFAULT NULL,
231   X_ATTRIBUTE2 in VARCHAR2 DEFAULT NULL,
232   X_ATTRIBUTE3 in VARCHAR2 DEFAULT NULL,
233   X_ATTRIBUTE4 in VARCHAR2 DEFAULT NULL,
234   X_ATTRIBUTE5 in VARCHAR2 DEFAULT NULL,
235   X_ATTRIBUTE6 in VARCHAR2 DEFAULT NULL,
236   X_ATTRIBUTE7 in VARCHAR2 DEFAULT NULL,
237   X_ATTRIBUTE8 in VARCHAR2 DEFAULT NULL,
238   X_ATTRIBUTE9 in VARCHAR2 DEFAULT NULL,
239   X_ATTRIBUTE10 in VARCHAR2 DEFAULT NULL,
240   X_ATTRIBUTE11 in VARCHAR2 DEFAULT NULL,
241   X_ATTRIBUTE12 in VARCHAR2 DEFAULT NULL,
242   X_ATTRIBUTE13 in VARCHAR2 DEFAULT NULL,
243   X_ATTRIBUTE14 in VARCHAR2 DEFAULT NULL,
244   X_ATTRIBUTE15 in VARCHAR2 DEFAULT NULL,
245   X_ATTRIBUTE_CATEGORY_CODE in VARCHAR2 DEFAULT NULL,
246   X_GF_ATTRIBUTE1 in VARCHAR2 DEFAULT NULL,
247   X_GF_ATTRIBUTE2 in VARCHAR2 DEFAULT NULL,
248   X_GF_ATTRIBUTE3 in VARCHAR2 DEFAULT NULL,
249   X_GF_ATTRIBUTE4 in VARCHAR2 DEFAULT NULL,
250   X_GF_ATTRIBUTE5 in VARCHAR2 DEFAULT NULL,
251   X_GF_ATTRIBUTE6 in VARCHAR2 DEFAULT NULL,
252   X_GF_ATTRIBUTE7 in VARCHAR2 DEFAULT NULL,
253   X_GF_ATTRIBUTE8 in VARCHAR2 DEFAULT NULL,
254   X_GF_ATTRIBUTE9 in VARCHAR2 DEFAULT NULL,
255   X_GF_ATTRIBUTE10 in VARCHAR2 DEFAULT NULL,
256   X_GF_ATTRIBUTE11 in VARCHAR2 DEFAULT NULL,
257   X_GF_ATTRIBUTE12 in VARCHAR2 DEFAULT NULL,
258   X_GF_ATTRIBUTE13 in VARCHAR2 DEFAULT NULL,
259   X_GF_ATTRIBUTE14 in VARCHAR2 DEFAULT NULL,
260   X_GF_ATTRIBUTE15 in VARCHAR2 DEFAULT NULL,
261   X_GF_ATTRIBUTE16 in VARCHAR2 DEFAULT NULL,
262   X_GF_ATTRIBUTE17 in VARCHAR2 DEFAULT NULL,
263   X_GF_ATTRIBUTE18 in VARCHAR2 DEFAULT NULL,
264   X_GF_ATTRIBUTE19 in VARCHAR2 DEFAULT NULL,
265   X_GF_ATTRIBUTE20 in VARCHAR2 DEFAULT NULL,
266   X_GF_ATTRIBUTE_CATEGORY in VARCHAR2 DEFAULT NULL,
267   p_log_level_rec    in      fa_api_types.log_level_rec_type default null
268 );
269 
270 procedure TRANSLATE_ROW (
271   X_CUSTOM_MODE in VARCHAR2,
272   X_CATEGORY_ID in NUMBER,
273   X_OWNER in VARCHAR2,
274   X_LAST_UPDATE_DATE in DATE,
275   X_DESCRIPTION in VARCHAR2,
276   p_log_level_rec    in      fa_api_types.log_level_rec_type default null
277 );
278 
279 procedure LOAD_SEED_ROW (
280              x_upload_mode              IN VARCHAR2,
281              x_custom_mode              IN VARCHAR2,
282              x_category_id              IN NUMBER,
283              x_owner                    IN VARCHAR2,
284              x_last_update_date         IN DATE,
285              x_summary_flag             IN VARCHAR2,
286              x_enabled_flag             IN VARCHAR2,
287              x_owned_leased             IN VARCHAR2,
288              x_production_capacity      IN NUMBER,
289              x_category_type            IN VARCHAR2,
290              x_capitalize_flag          IN VARCHAR2,
291              x_description              IN VARCHAR2,
292              x_segment1                 IN VARCHAR2,
293              x_segment2                 IN VARCHAR2,
294              x_segment3                 IN VARCHAR2,
295              x_segment4                 IN VARCHAR2,
296              x_segment5                 IN VARCHAR2,
297              x_segment6                 IN VARCHAR2,
298              x_segment7                 IN VARCHAR2,
299              x_start_date_active        IN DATE,
300              x_end_date_active          IN DATE,
301              x_property_type_code       IN VARCHAR2,
302              x_property_1245_1250_code  IN VARCHAR2,
303              x_date_ineffective         IN DATE,
304              x_inventorial              IN VARCHAR2,
305              x_attribute1               IN VARCHAR2,
306              x_attribute2               IN VARCHAR2,
307              x_attribute3               IN VARCHAR2,
308              x_attribute4               IN VARCHAR2,
309              x_attribute5               IN VARCHAR2,
310              x_attribute6               IN VARCHAR2,
311              x_attribute7               IN VARCHAR2,
312              x_attribute8               IN VARCHAR2,
313              x_attribute9               IN VARCHAR2,
314              x_attribute10              IN VARCHAR2,
315              x_attribute11              IN VARCHAR2,
316              x_attribute12              IN VARCHAR2,
317              x_attribute13              IN VARCHAR2,
318              x_attribute14              IN VARCHAR2,
319              x_attribute15              IN VARCHAR2,
320              x_attribute_category_code  IN VARCHAR2,
321              x_gf_attribute1            IN VARCHAR2,
322              x_gf_attribute2            IN VARCHAR2,
323              x_gf_attribute3            IN VARCHAR2,
324              x_gf_attribute4            IN VARCHAR2,
325              x_gf_attribute5            IN VARCHAR2,
326              x_gf_attribute6            IN VARCHAR2,
327              x_gf_attribute7            IN VARCHAR2,
328              x_gf_attribute8            IN VARCHAR2,
329              x_gf_attribute9            IN VARCHAR2,
330              x_gf_attribute10           IN VARCHAR2,
331              x_gf_attribute11           IN VARCHAR2,
332              x_gf_attribute12           IN VARCHAR2,
333              x_gf_attribute13           IN VARCHAR2,
334              x_gf_attribute14           IN VARCHAR2,
335              x_gf_attribute15           IN VARCHAR2,
336              x_gf_attribute16           IN VARCHAR2,
337              x_gf_attribute17           IN VARCHAR2,
338              x_gf_attribute18           IN VARCHAR2,
339              x_gf_attribute19           IN VARCHAR2,
340              x_gf_attribute20           IN VARCHAR2,
341              x_gf_attribute_category    IN VARCHAR2);
342 
343 end FA_CATEGORIES_PKG;