DBA Data[Home] [Help]

PACKAGE BODY: APPS.MTL_MOVEMENT_PARAMETERS_PKG

Source


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