[Home] [Help]
PACKAGE: APPS.MTL_CYCLE_COUNT_ITEMS_PKG
Source
1 PACKAGE MTL_CYCLE_COUNT_ITEMS_PKG as
2 /* $Header: INVADC2S.pls 120.1 2005/06/19 00:53:23 appldev $ */
3 --Added NOCOPY hint to X_Rowid to comply with GSCC File.Sql.39
4 --standard Bug:4410902
5 PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
6 X_Cycle_Count_Header_Id NUMBER,
7 X_Inventory_Item_Id NUMBER,
8 X_Last_Update_Date DATE,
9 X_Last_Updated_By NUMBER,
10 X_Creation_Date DATE,
11 X_Created_By NUMBER,
12 X_Last_Update_Login NUMBER,
13 X_Abc_Class_Id NUMBER,
14 X_Item_Last_Schedule_Date DATE,
15 X_Schedule_Order NUMBER,
16 X_Approval_Tolerance_Positive NUMBER,
17 X_Approval_Tolerance_Negative NUMBER,
18 X_Control_Group_Flag NUMBER
19 );
20
21 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
22 X_Cycle_Count_Header_Id NUMBER,
23 X_Inventory_Item_Id NUMBER,
24 X_Abc_Class_Id NUMBER,
25 X_Item_Last_Schedule_Date DATE,
26 X_Schedule_Order NUMBER,
27 X_Approval_Tolerance_Positive NUMBER,
28 X_Approval_Tolerance_Negative NUMBER,
29 X_Control_Group_Flag NUMBER
30 );
31
32
33 PROCEDURE Update_Row(X_Rowid VARCHAR2,
34 X_Cycle_Count_Header_Id NUMBER,
35 X_Inventory_Item_Id NUMBER,
36 X_Last_Update_Date DATE,
37 X_Last_Updated_By NUMBER,
38 X_Last_Update_Login NUMBER,
39 X_Abc_Class_Id NUMBER,
40 X_Item_Last_Schedule_Date DATE,
41 X_Schedule_Order NUMBER,
42 X_Approval_Tolerance_Positive NUMBER,
43 X_Approval_Tolerance_Negative NUMBER,
44 X_Control_Group_Flag NUMBER
45 );
46 PROCEDURE Delete_Row(X_Rowid VARCHAR2);
47
48 END MTL_CYCLE_COUNT_ITEMS_PKG;