DBA Data[Home] [Help]

PACKAGE: APPS.MTL_STATUS_ATTRIB_VAL_PKG

Source


1 PACKAGE MTL_STATUS_ATTRIB_VAL_PKG as
2 /* $Header: INVSDOSS.pls 120.0 2005/05/25 05:29:38 appldev noship $ */
3 
4 
5 
6   PROCEDURE Lock_Row(X_Rowid                            VARCHAR2,
7 
8                      X_Inventory_Item_Status_Code       VARCHAR2,
9                      X_Attribute_Name                   VARCHAR2,
10                      X_Attribute_Value                  VARCHAR2
11                     );
12 
13 
14 
15   PROCEDURE Update_Row(X_Rowid                          VARCHAR2,
16 
17                        X_Inventory_Item_Status_Code     VARCHAR2,
18                        X_Status_Code_Ndb                NUMBER,
19                        X_Attribute_Name                 VARCHAR2,
20                        X_Attribute_Value                VARCHAR2,
21                        X_Old_Attribute_Value            VARCHAR2,
22                        X_Last_Update_Date               DATE,
23                        X_Last_Updated_By                NUMBER,
24                        X_Last_Update_Login              NUMBER
25                       );
26   PROCEDURE Delete_Row(X_Rowid VARCHAR2);
27 
28   PROCEDURE  Populate_Tab (status_code IN VARCHAR2 );
29 
30 END MTL_STATUS_ATTRIB_VAL_PKG;