[Home] [Help]
PACKAGE: APPS.MTL_CYCLE_COUNT_CLASSES_PKG
Source
1 PACKAGE MTL_CYCLE_COUNT_CLASSES_PKG AUTHID CURRENT_USER as
2 /* $Header: INVADC3S.pls 120.1 2005/06/19 05:04:53 appldev $ */
3 --Added NOCOPY hint to X_Rowid IN OUT parameter to comply with
4 --GSCC standard File.Sql.39. BUg:4410902
5 PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
6 X_Abc_Class_Id NUMBER,
7 X_Cycle_Count_Header_Id NUMBER,
8 X_Organization_Id NUMBER,
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_Num_Counts_Per_Year NUMBER,
15 X_Approval_Tolerance_Positive NUMBER,
16 X_Approval_Tolerance_Negative NUMBER,
17 X_Cost_Tolerance_Positive NUMBER,
18 X_Cost_Tolerance_Negative NUMBER,
19 X_Hit_Miss_Tolerance_Positive NUMBER,
20 X_Hit_Miss_Tolerance_Negative NUMBER,
21 X_Abc_Assignment_Group_Id NUMBER
22 );
23
24 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
25 X_Abc_Class_Id NUMBER,
26 X_Cycle_Count_Header_Id NUMBER,
27 X_Organization_Id NUMBER,
28 X_Num_Counts_Per_Year NUMBER,
29 X_Approval_Tolerance_Positive NUMBER,
30 X_Approval_Tolerance_Negative NUMBER,
31 X_Cost_Tolerance_Positive NUMBER,
32 X_Cost_Tolerance_Negative NUMBER,
33 X_Hit_Miss_Tolerance_Positive NUMBER,
34 X_Hit_Miss_Tolerance_Negative NUMBER,
35 X_Abc_Assignment_Group_Id NUMBER
36 );
37
38
39 PROCEDURE Update_Row(X_Rowid VARCHAR2,
40 X_Abc_Class_Id NUMBER,
41 X_Cycle_Count_Header_Id NUMBER,
42 X_Organization_Id NUMBER,
43 X_Last_Update_Date DATE,
44 X_Last_Updated_By NUMBER,
45 X_Last_Update_Login NUMBER,
46 X_Num_Counts_Per_Year NUMBER,
47 X_Approval_Tolerance_Positive NUMBER,
48 X_Approval_Tolerance_Negative NUMBER,
49 X_Cost_Tolerance_Positive NUMBER,
50 X_Cost_Tolerance_Negative NUMBER,
51 X_Hit_Miss_Tolerance_Positive NUMBER,
52 X_Hit_Miss_Tolerance_Negative NUMBER,
53 X_Abc_Assignment_Group_Id NUMBER
54 );
55 PROCEDURE Delete_Row(X_Rowid VARCHAR2);
56
57 END MTL_CYCLE_COUNT_CLASSES_PKG;