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 BODY: APPS.CST_COST_GROUPS_PKG

Source


1 PACKAGE BODY CST_COST_GROUPS_PKG as
2 /* $Header: CSTCOGRB.pls 115.4 2002/11/08 03:19:33 awwang ship $ */
3 
4   PROCEDURE Insert_Row(X_Rowid                   IN OUT NOCOPY VARCHAR2,
5                        X_Cost_Group_Id                  IN OUT NOCOPY NUMBER,
6                        X_Cost_Group                     VARCHAR2,
7                        X_Description                    VARCHAR2 DEFAULT NULL,
8                        X_Organization_Id                NUMBER DEFAULT NULL,
9                        X_Disable_Date                   DATE DEFAULT NULL,
10                        X_Attribute_Category             VARCHAR2 DEFAULT NULL,
11                        X_Attribute1                     VARCHAR2 DEFAULT NULL,
12                        X_Attribute2                     VARCHAR2 DEFAULT NULL,
13                        X_Attribute3                     VARCHAR2 DEFAULT NULL,
14                        X_Attribute4                     VARCHAR2 DEFAULT NULL,
15                        X_Attribute5                     VARCHAR2 DEFAULT NULL,
16                        X_Attribute6                     VARCHAR2 DEFAULT NULL,
17                        X_Attribute7                     VARCHAR2 DEFAULT NULL,
18                        X_Attribute8                     VARCHAR2 DEFAULT NULL,
19                        X_Attribute9                     VARCHAR2 DEFAULT NULL,
20                        X_Attribute10                    VARCHAR2 DEFAULT NULL,
21                        X_Attribute11                    VARCHAR2 DEFAULT NULL,
22                        X_Attribute12                    VARCHAR2 DEFAULT NULL,
23                        X_Attribute13                    VARCHAR2 DEFAULT NULL,
24                        X_Attribute14                    VARCHAR2 DEFAULT NULL,
25                        X_Attribute15                    VARCHAR2 DEFAULT NULL,
26                        X_Creation_Date                  DATE,
27                        X_Created_By                     NUMBER,
28                        X_Last_Update_Date               DATE,
29                        X_Last_Updated_By                NUMBER,
30                        X_Last_Update_Login              NUMBER DEFAULT NULL,
31 		       X_Cost_Group_Type		NUMBER DEFAULT 1
32   ) IS
33     CURSOR C IS SELECT rowid FROM cst_cost_groups
34                  WHERE cost_group_id = X_Cost_Group_Id;
35       CURSOR C2 IS SELECT cst_cost_groups_s.nextval FROM sys.dual;
36 --    X_Cost_Group_Type CONSTANT NUMBER := 1;
37 
38    BEGIN
39       if (X_Cost_Group_Id is NULL) then
40         OPEN C2;
41         FETCH C2 INTO X_Cost_Group_Id;
42         CLOSE C2;
43       end if;
44 
45        INSERT INTO cst_cost_groups(
46 
47               cost_group_id,
48               cost_group,
49               description,
50               organization_id,
51               disable_date,
52               attribute_category,
53               attribute1,
54               attribute2,
55               attribute3,
56               attribute4,
57               attribute5,
58               attribute6,
59               attribute7,
60               attribute8,
61               attribute9,
62               attribute10,
63               attribute11,
64               attribute12,
65               attribute13,
66               attribute14,
67               attribute15,
68               creation_date,
69               created_by,
70               last_update_date,
71               last_updated_by,
72               last_update_login,
73               cost_group_type
74              ) VALUES (
75 
76               X_Cost_Group_Id,
77               X_Cost_Group,
78               X_Description,
79               X_Organization_Id,
80               X_Disable_Date,
81               X_Attribute_Category,
82               X_Attribute1,
83               X_Attribute2,
84               X_Attribute3,
85               X_Attribute4,
86               X_Attribute5,
87               X_Attribute6,
88               X_Attribute7,
89               X_Attribute8,
90               X_Attribute9,
91               X_Attribute10,
92               X_Attribute11,
93               X_Attribute12,
94               X_Attribute13,
95               X_Attribute14,
96               X_Attribute15,
97               X_Creation_Date,
98               X_Created_By,
99               X_Last_Update_Date,
100               X_Last_Updated_By,
101               X_Last_Update_Login,
102               X_Cost_Group_Type
103              );
104 
105     OPEN C;
106     FETCH C INTO X_Rowid;
107     if (C%NOTFOUND) then
108       CLOSE C;
109       Raise NO_DATA_FOUND;
110     end if;
111     CLOSE C;
112   END Insert_Row;
113 
114 
115   PROCEDURE Lock_Row(X_Rowid                            VARCHAR2,
116                      X_Cost_Group_Id                    NUMBER,
117                      X_Cost_Group                       VARCHAR2,
118                      X_Description                      VARCHAR2 DEFAULT NULL,
119                      X_Organization_Id                  NUMBER DEFAULT NULL,
120                      X_Disable_Date                     DATE DEFAULT NULL,
121                      X_Attribute_Category               VARCHAR2 DEFAULT NULL,
122                      X_Attribute1                       VARCHAR2 DEFAULT NULL,
123                      X_Attribute2                       VARCHAR2 DEFAULT NULL,
124                      X_Attribute3                       VARCHAR2 DEFAULT NULL,
125                      X_Attribute4                       VARCHAR2 DEFAULT NULL,
126                      X_Attribute5                       VARCHAR2 DEFAULT NULL,
127                      X_Attribute6                       VARCHAR2 DEFAULT NULL,
128                      X_Attribute7                       VARCHAR2 DEFAULT NULL,
129                      X_Attribute8                       VARCHAR2 DEFAULT NULL,
130                      X_Attribute9                       VARCHAR2 DEFAULT NULL,
131                      X_Attribute10                      VARCHAR2 DEFAULT NULL,
132                      X_Attribute11                      VARCHAR2 DEFAULT NULL,
133                      X_Attribute12                      VARCHAR2 DEFAULT NULL,
134                      X_Attribute13                      VARCHAR2 DEFAULT NULL,
135                      X_Attribute14                      VARCHAR2 DEFAULT NULL,
136                      X_Attribute15                      VARCHAR2 DEFAULT NULL
137   ) IS
138     CURSOR C IS
139         SELECT *
140         FROM   cst_cost_groups
141         WHERE  rowid = X_Rowid
142         FOR UPDATE of Cost_Group_Id NOWAIT;
143     Recinfo C%ROWTYPE;
144 
145 
146   BEGIN
147     OPEN C;
148     FETCH C INTO Recinfo;
149     if (C%NOTFOUND) then
150       CLOSE C;
151       FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
152       APP_EXCEPTION.Raise_Exception;
153     end if;
154     CLOSE C;
155     if (
156 
157                (Recinfo.cost_group_id =  X_Cost_Group_Id)
158            AND (Recinfo.cost_group =  X_Cost_Group)
159            AND (   (Recinfo.description =  X_Description)
160                 OR (    (Recinfo.description IS NULL)
161                     AND (X_Description IS NULL)))
162            AND (   (Recinfo.organization_id =  X_Organization_Id)
163                 OR (    (Recinfo.organization_id IS NULL)
164                     AND (X_Organization_Id IS NULL)))
165            AND (   (Recinfo.disable_date =  X_Disable_Date)
166                 OR (    (Recinfo.disable_date IS NULL)
167                     AND (X_Disable_Date IS NULL)))
168            AND (   (Recinfo.attribute_category =  X_Attribute_Category)
169                 OR (    (Recinfo.attribute_category IS NULL)
170                     AND (X_Attribute_Category IS NULL)))
171            AND (   (Recinfo.attribute1 =  X_Attribute1)
172                 OR (    (Recinfo.attribute1 IS NULL)
173                     AND (X_Attribute1 IS NULL)))
174            AND (   (Recinfo.attribute2 =  X_Attribute2)
175                 OR (    (Recinfo.attribute2 IS NULL)
176                     AND (X_Attribute2 IS NULL)))
177            AND (   (Recinfo.attribute3 =  X_Attribute3)
178                 OR (    (Recinfo.attribute3 IS NULL)
179                     AND (X_Attribute3 IS NULL)))
180            AND (   (Recinfo.attribute4 =  X_Attribute4)
181                 OR (    (Recinfo.attribute4 IS NULL)
182                     AND (X_Attribute4 IS NULL)))
183            AND (   (Recinfo.attribute5 =  X_Attribute5)
184                 OR (    (Recinfo.attribute5 IS NULL)
185                     AND (X_Attribute5 IS NULL)))
186            AND (   (Recinfo.attribute6 =  X_Attribute6)
187                 OR (    (Recinfo.attribute6 IS NULL)
188                     AND (X_Attribute6 IS NULL)))
189            AND (   (Recinfo.attribute7 =  X_Attribute7)
190                 OR (    (Recinfo.attribute7 IS NULL)
191                     AND (X_Attribute7 IS NULL)))
192            AND (   (Recinfo.attribute8 =  X_Attribute8)
193                 OR (    (Recinfo.attribute8 IS NULL)
194                     AND (X_Attribute8 IS NULL)))
195            AND (   (Recinfo.attribute9 =  X_Attribute9)
196                 OR (    (Recinfo.attribute9 IS NULL)
197                     AND (X_Attribute9 IS NULL)))
198            AND (   (Recinfo.attribute10 =  X_Attribute10)
199                 OR (    (Recinfo.attribute10 IS NULL)
200                     AND (X_Attribute10 IS NULL)))
201            AND (   (Recinfo.attribute11 =  X_Attribute11)
202                 OR (    (Recinfo.attribute11 IS NULL)
203                     AND (X_Attribute11 IS NULL)))
204            AND (   (Recinfo.attribute12 =  X_Attribute12)
205                 OR (    (Recinfo.attribute12 IS NULL)
206                     AND (X_Attribute12 IS NULL)))
207            AND (   (Recinfo.attribute13 =  X_Attribute13)
208                 OR (    (Recinfo.attribute13 IS NULL)
209                     AND (X_Attribute13 IS NULL)))
210            AND (   (Recinfo.attribute14 =  X_Attribute14)
211                 OR (    (Recinfo.attribute14 IS NULL)
212                     AND (X_Attribute14 IS NULL)))
213            AND (   (Recinfo.attribute15 =  X_Attribute15)
214                 OR (    (Recinfo.attribute15 IS NULL)
215                     AND (X_Attribute15 IS NULL)))
216            AND (Recinfo.Cost_Group_Type IN( 1,3))
217       ) then
218       return;
219     else
220       FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
221       APP_EXCEPTION.Raise_Exception;
222     end if;
223   END Lock_Row;
224 
225   PROCEDURE Update_Row(X_Rowid                          VARCHAR2,
226                        X_Cost_Group_Id                  NUMBER,
227                        X_Cost_Group                     VARCHAR2,
228                        X_Description                    VARCHAR2 DEFAULT NULL,
229                        X_Organization_Id                NUMBER DEFAULT NULL,
230                        X_Disable_Date                   DATE DEFAULT NULL,
231                        X_Attribute_Category             VARCHAR2 DEFAULT NULL,
232                        X_Attribute1                     VARCHAR2 DEFAULT NULL,
233                        X_Attribute2                     VARCHAR2 DEFAULT NULL,
234                        X_Attribute3                     VARCHAR2 DEFAULT NULL,
235                        X_Attribute4                     VARCHAR2 DEFAULT NULL,
236                        X_Attribute5                     VARCHAR2 DEFAULT NULL,
237                        X_Attribute6                     VARCHAR2 DEFAULT NULL,
238                        X_Attribute7                     VARCHAR2 DEFAULT NULL,
239                        X_Attribute8                     VARCHAR2 DEFAULT NULL,
240                        X_Attribute9                     VARCHAR2 DEFAULT NULL,
241                        X_Attribute10                    VARCHAR2 DEFAULT NULL,
242                        X_Attribute11                    VARCHAR2 DEFAULT NULL,
243                        X_Attribute12                    VARCHAR2 DEFAULT NULL,
244                        X_Attribute13                    VARCHAR2 DEFAULT NULL,
245                        X_Attribute14                    VARCHAR2 DEFAULT NULL,
246                        X_Attribute15                    VARCHAR2 DEFAULT NULL,
247                        X_Last_Update_Date               DATE,
248                        X_Last_Updated_By                NUMBER,
249                        X_Last_Update_Login              NUMBER DEFAULT NULL,
250 		       X_Cost_Group_Type		NUMBER DEFAULT 1
251 
252   ) IS
253   BEGIN
254     UPDATE cst_cost_groups
255     SET
256        cost_group_id                   =     X_Cost_Group_Id,
257        cost_group                      =     X_Cost_Group,
258        description                     =     X_Description,
259        organization_id                 =     X_Organization_Id,
260        disable_date                    =     X_Disable_Date,
261        attribute_category              =     X_Attribute_Category,
262        attribute1                      =     X_Attribute1,
263        attribute2                      =     X_Attribute2,
264        attribute3                      =     X_Attribute3,
265        attribute4                      =     X_Attribute4,
266        attribute5                      =     X_Attribute5,
267        attribute6                      =     X_Attribute6,
268        attribute7                      =     X_Attribute7,
269        attribute8                      =     X_Attribute8,
270        attribute9                      =     X_Attribute9,
271        attribute10                     =     X_Attribute10,
272        attribute11                     =     X_Attribute11,
273        attribute12                     =     X_Attribute12,
274        attribute13                     =     X_Attribute13,
275        attribute14                     =     X_Attribute14,
276        attribute15                     =     X_Attribute15,
277        last_update_date                =     X_Last_Update_Date,
278        last_updated_by                 =     X_Last_Updated_By,
279        last_update_login               =     X_Last_Update_Login,
280        cost_group_type		       =     X_Cost_Group_Type
281     WHERE rowid = X_Rowid;
282 
283     if (SQL%NOTFOUND) then
284       Raise NO_DATA_FOUND;
285     end if;
286   END Update_Row;
287 
288   PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
289   BEGIN
290     DELETE FROM cst_cost_groups
291     WHERE rowid = X_Rowid;
292 
293     if (SQL%NOTFOUND) then
294       Raise NO_DATA_FOUND;
295     end if;
296   END Delete_Row;
297 
301                        X_Description                    VARCHAR2 DEFAULT NULL,
298  PROCEDURE Insert_Fiscal_Row(X_Rowid                   IN OUT NOCOPY VARCHAR2,
299                        X_Cost_Group_Id                  IN OUT NOCOPY NUMBER,
300                        X_Cost_Group                     VARCHAR2,
302                        X_Organization_Id                NUMBER DEFAULT NULL,
303                        X_Attribute_Category             VARCHAR2 DEFAULT NULL,
304                        X_Attribute1                     VARCHAR2 DEFAULT NULL,
305                        X_Attribute2                     VARCHAR2 DEFAULT NULL,
306                        X_Attribute3                     VARCHAR2 DEFAULT NULL,
307                        X_Attribute4                     VARCHAR2 DEFAULT NULL,
308                        X_Attribute5                     VARCHAR2 DEFAULT NULL,
309                        X_Attribute6                     VARCHAR2 DEFAULT NULL,
310                        X_Attribute7                     VARCHAR2 DEFAULT NULL,
311                        X_Attribute8                     VARCHAR2 DEFAULT NULL,
312                        X_Attribute9                     VARCHAR2 DEFAULT NULL,
313                        X_Attribute10                    VARCHAR2 DEFAULT NULL,
314                        X_Attribute11                    VARCHAR2 DEFAULT NULL,
315                        X_Attribute12                    VARCHAR2 DEFAULT NULL,
316                        X_Attribute13                    VARCHAR2 DEFAULT NULL,
317                        X_Attribute14                    VARCHAR2 DEFAULT NULL,
318                        X_Attribute15                    VARCHAR2 DEFAULT NULL,
319                        X_Creation_Date                  DATE,
320                        X_Created_By                     NUMBER,
321                        X_Last_Update_Date               DATE,
322                        X_Last_Updated_By                NUMBER,
323                        X_Last_Update_Login              NUMBER DEFAULT NULL,
324 		       X_Legal_Entity			NUMBER
325   ) IS
326 
327     CURSOR C IS SELECT rowid FROM cst_cost_groups
328                  WHERE cost_group_id = X_Cost_Group_Id;
329  CURSOR C2 IS SELECT cst_cost_groups_s.nextval FROM sys.dual;
330 
331     X_Cost_Group_Type CONSTANT NUMBER := 2;
332    BEGIN
333       if (X_Cost_Group_Id is NULL) then
334         OPEN C2;
335         FETCH C2 INTO X_Cost_Group_Id;
336         CLOSE C2;
337       end if;
338 
339        INSERT INTO cst_cost_groups(
340 
341               cost_group_id,
342               cost_group,
343               description,
344               organization_id,
345               attribute_category,
346               attribute1,
347               attribute2,
348               attribute3,
349               attribute4,
350               attribute5,
351               attribute6,
352               attribute7,
353               attribute8,
354               attribute9,
355               attribute10,
356               attribute11,
357               attribute12,
358               attribute13,
359               attribute14,
360               attribute15,
361               creation_date,
362               created_by,
363               last_update_date,
364               last_updated_by,
365               last_update_login,
366               cost_group_type,
367               legal_entity
368              ) VALUES (
369 
370               X_Cost_Group_Id,
371               X_Cost_Group,
372               X_Description,
373               X_Organization_Id,
374               X_Attribute_Category,
375               X_Attribute1,
376               X_Attribute2,
377               X_Attribute3,
378               X_Attribute4,
379               X_Attribute5,
380               X_Attribute6,
381               X_Attribute7,
382               X_Attribute8,
383               X_Attribute9,
384               X_Attribute10,
385               X_Attribute11,
386               X_Attribute12,
387               X_Attribute13,
388               X_Attribute14,
389               X_Attribute15,
390               X_Creation_Date,
391               X_Created_By,
392               X_Last_Update_Date,
393               X_Last_Updated_By,
394               X_Last_Update_Login,
395               X_Cost_Group_Type,
396               X_Legal_Entity
397              );
398 
399     OPEN C;
400     FETCH C INTO X_Rowid;
401     if (C%NOTFOUND) then
402       CLOSE C;
403       Raise NO_DATA_FOUND;
404     end if;
405     CLOSE C;
406   END Insert_Fiscal_Row;
407 
408  PROCEDURE Lock_Fiscal_Row(X_Rowid                            VARCHAR2,
409                      X_Cost_Group_Id                    NUMBER,
410                      X_Cost_Group                       VARCHAR2,
411                      X_Description                      VARCHAR2 DEFAULT NULL,
412                      X_Organization_Id                  NUMBER DEFAULT NULL,
413                      X_Attribute_Category               VARCHAR2 DEFAULT NULL,
414                      X_Attribute1                       VARCHAR2 DEFAULT NULL,
415                      X_Attribute2                       VARCHAR2 DEFAULT NULL,
416                      X_Attribute3                       VARCHAR2 DEFAULT NULL,
417                      X_Attribute4                       VARCHAR2 DEFAULT NULL,
418                      X_Attribute5                       VARCHAR2 DEFAULT NULL,
419                      X_Attribute6                       VARCHAR2 DEFAULT NULL,
420                      X_Attribute7                       VARCHAR2 DEFAULT NULL,
421                      X_Attribute8                       VARCHAR2 DEFAULT NULL,
422                      X_Attribute9                       VARCHAR2 DEFAULT NULL,
423                      X_Attribute10                      VARCHAR2 DEFAULT NULL,
427                      X_Attribute14                      VARCHAR2 DEFAULT NULL,
424                      X_Attribute11                      VARCHAR2 DEFAULT NULL,
425                      X_Attribute12                      VARCHAR2 DEFAULT NULL,
426                      X_Attribute13                      VARCHAR2 DEFAULT NULL,
428                      X_Attribute15                      VARCHAR2 DEFAULT NULL,
429 		     X_Legal_Entity			NUMBER
430   ) IS
431     CURSOR C IS
432         SELECT *
433         FROM   cst_cost_groups
434         WHERE  rowid = X_Rowid
435         FOR UPDATE of Cost_Group_Id NOWAIT;
436     Recinfo C%ROWTYPE;
437 
438 
439   BEGIN
440     OPEN C;
441     FETCH C INTO Recinfo;
442     if (C%NOTFOUND) then
443       CLOSE C;
444       FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
445       APP_EXCEPTION.Raise_Exception;
446     end if;
447     CLOSE C;
448 if (
449 
450                (Recinfo.cost_group_id =  X_Cost_Group_Id)
451            AND (Recinfo.cost_group =  X_Cost_Group)
452            AND (   (Recinfo.description =  X_Description)
453                 OR (    (Recinfo.description IS NULL)
454                     AND (X_Description IS NULL)))
455            AND (   (Recinfo.organization_id =  X_Organization_Id)
456                 OR (    (Recinfo.organization_id IS NULL)
457                     AND (X_Organization_Id IS NULL)))
458            AND (   (Recinfo.attribute_category =  X_Attribute_Category)
459                 OR (    (Recinfo.attribute_category IS NULL)
460                     AND (X_Attribute_Category IS NULL)))
461            AND (   (Recinfo.attribute1 =  X_Attribute1)
462                 OR (    (Recinfo.attribute1 IS NULL)
463                     AND (X_Attribute1 IS NULL)))
464            AND (   (Recinfo.attribute2 =  X_Attribute2)
465                 OR (    (Recinfo.attribute2 IS NULL)
466                     AND (X_Attribute2 IS NULL)))
467            AND (   (Recinfo.attribute3 =  X_Attribute3)
468                 OR (    (Recinfo.attribute3 IS NULL)
469                     AND (X_Attribute3 IS NULL)))
470            AND (   (Recinfo.attribute4 =  X_Attribute4)
471                 OR (    (Recinfo.attribute4 IS NULL)
472                     AND (X_Attribute4 IS NULL)))
473            AND (   (Recinfo.attribute5 =  X_Attribute5)
474                 OR (    (Recinfo.attribute5 IS NULL)
475                     AND (X_Attribute5 IS NULL)))
476            AND (   (Recinfo.attribute6 =  X_Attribute6)
477                 OR (    (Recinfo.attribute6 IS NULL)
478                     AND (X_Attribute6 IS NULL)))
479            AND (   (Recinfo.attribute7 =  X_Attribute7)
480                 OR (    (Recinfo.attribute7 IS NULL)
481                     AND (X_Attribute7 IS NULL)))
482            AND (   (Recinfo.attribute8 =  X_Attribute8)
483                 OR (    (Recinfo.attribute8 IS NULL)
484                     AND (X_Attribute8 IS NULL)))
485 	   AND (   (Recinfo.attribute9 =  X_Attribute9)
486                 OR (    (Recinfo.attribute9 IS NULL)
487                     AND (X_Attribute9 IS NULL)))
488            AND (   (Recinfo.attribute10 =  X_Attribute10)
489                 OR (    (Recinfo.attribute10 IS NULL)
490                     AND (X_Attribute10 IS NULL)))
491            AND (   (Recinfo.attribute11 =  X_Attribute11)
492                 OR (    (Recinfo.attribute11 IS NULL)
493                     AND (X_Attribute11 IS NULL)))
494            AND (   (Recinfo.attribute12 =  X_Attribute12)
495                 OR (    (Recinfo.attribute12 IS NULL)
496                     AND (X_Attribute12 IS NULL)))
497            AND (   (Recinfo.attribute13 =  X_Attribute13)
498                 OR (    (Recinfo.attribute13 IS NULL)
499                     AND (X_Attribute13 IS NULL)))
500            AND (   (Recinfo.attribute14 =  X_Attribute14)
501                 OR (    (Recinfo.attribute14 IS NULL)
502                     AND (X_Attribute14 IS NULL)))
503            AND (   (Recinfo.attribute15 =  X_Attribute15)
504                 OR (    (Recinfo.attribute15 IS NULL)
505                     AND (X_Attribute15 IS NULL)))
506            AND (Recinfo.Cost_Group_Type = 2)
507            AND (Recinfo.Legal_Entity = X_Legal_Entity)
508       ) then
509       return;
510     else
511       FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
512       APP_EXCEPTION.Raise_Exception;
513     end if;
514   END Lock_Fiscal_Row;
515 
516 PROCEDURE Update_Fiscal_Row(X_Rowid                          VARCHAR2,
517                        X_Cost_Group_Id                  NUMBER,
518                        X_Cost_Group                     VARCHAR2,
519                        X_Description                    VARCHAR2 DEFAULT NULL,
520                        X_Organization_Id                NUMBER DEFAULT NULL,
521                        X_Attribute_Category             VARCHAR2 DEFAULT NULL,
522                        X_Attribute1                     VARCHAR2 DEFAULT NULL,
523                        X_Attribute2                     VARCHAR2 DEFAULT NULL,
524                        X_Attribute3                     VARCHAR2 DEFAULT NULL,
525                        X_Attribute4                     VARCHAR2 DEFAULT NULL,
526                        X_Attribute5                     VARCHAR2 DEFAULT NULL,
527                        X_Attribute6                     VARCHAR2 DEFAULT NULL,
528                        X_Attribute7                     VARCHAR2 DEFAULT NULL,
529                        X_Attribute8                     VARCHAR2 DEFAULT NULL,
530                        X_Attribute9                     VARCHAR2 DEFAULT NULL,
531                        X_Attribute10                    VARCHAR2 DEFAULT NULL,
532                        X_Attribute11                    VARCHAR2 DEFAULT NULL,
533                        X_Attribute12                    VARCHAR2 DEFAULT NULL,
534                        X_Attribute13                    VARCHAR2 DEFAULT NULL,
538                        X_Last_Updated_By                NUMBER,
535                        X_Attribute14                    VARCHAR2 DEFAULT NULL,
536                        X_Attribute15                    VARCHAR2 DEFAULT NULL,
537                        X_Last_Update_Date               DATE,
539                        X_Last_Update_Login              NUMBER DEFAULT NULL,
540                        X_Legal_Entity			NUMBER
541   ) IS
542   BEGIN
543     UPDATE cst_cost_groups
544     SET
545        cost_group_id                   =     X_Cost_Group_Id,
546        cost_group                      =     X_Cost_Group,
547        description                     =     X_Description,
548        organization_id                 =     X_Organization_Id,
549        attribute_category              =     X_Attribute_Category,
550        attribute1                      =     X_Attribute1,
551        attribute2                      =     X_Attribute2,
552        attribute3                      =     X_Attribute3,
553        attribute4                      =     X_Attribute4,
554        attribute5                      =     X_Attribute5,
555        attribute6                      =     X_Attribute6,
556        attribute7                      =     X_Attribute7,
557        attribute8                      =     X_Attribute8,
558        attribute9                      =     X_Attribute9,
559        attribute10                     =     X_Attribute10,
560        attribute11                     =     X_Attribute11,
561        attribute12                     =     X_Attribute12,
562        attribute13                     =     X_Attribute13,
563        attribute14                     =     X_Attribute14,
564        attribute15                     =     X_Attribute15,
565        last_update_date                =     X_Last_Update_Date,
566        last_updated_by                 =     X_Last_Updated_By,
567        last_update_login               =     X_Last_Update_Login,
568        legal_entity		       =     X_Legal_Entity
569     WHERE rowid = X_Rowid;
570 
571     if (SQL%NOTFOUND) then
572       Raise NO_DATA_FOUND;
573     end if;
574   END Update_Fiscal_Row;
575 
576 
577 END CST_COST_GROUPS_PKG;