1 PACKAGE PA_PM_CONTROL_RULES_PKG as
2 /* $Header: PAPMPCRS.pls 120.1 2005/08/19 16:42:57 mwasowic noship $ */
3
4
5 PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
6 X_Control_Rule_id IN NUMBER,
7 X_Pm_product_code IN VARCHAR2,
8 X_Field_value_code IN VARCHAR2,
9 X_Start_Date IN DATE,
10 X_End_Date IN DATE,
11 X_Creation_Date IN DATE,
12 X_Created_By IN NUMBER,
13 X_Last_Update_Date IN DATE,
14 X_Last_Updated_By IN NUMBER,
15 X_Last_Update_Login IN NUMBER
16 );
17
18 PROCEDURE Lock_Row(X_Rowid IN VARCHAR2,
19 X_Control_Rule_id IN NUMBER,
20 X_Field_value_code IN VARCHAR2,
21 X_Start_Date IN DATE,
22 X_End_Date IN DATE
23 );
24
25 PROCEDURE Update_Row(X_Rowid IN VARCHAR2,
26 X_Start_Date IN DATE,
27 X_End_Date IN DATE,
28 X_Control_rule_id IN NUMBER,
29 X_Last_Update_Date IN DATE,
30 X_Last_Updated_By IN NUMBER,
31 X_Last_Update_Login IN NUMBER
32 );
33
34 PROCEDURE Delete_Row(X_Rowid VARCHAR2);
35
36
37 END PA_PM_CONTROL_RULES_PKG;