[Home] [Help]
PACKAGE: APPS.QA_PC_CRITERIA_PKG
Source
1 PACKAGE QA_PC_CRITERIA_PKG as
2 /* $Header: qapccris.pls 120.2 2005/12/19 04:08:30 srhariha noship $ */
3 PROCEDURE Insert_Row( X_Rowid IN OUT NOCOPY VARCHAR2,
4 X_Criteria_Id IN OUT NOCOPY NUMBER,
5 X_Plan_Relationship_Id NUMBER,
6 X_Char_Id NUMBER,
7 X_Operator NUMBER,
8 X_Low_Value VARCHAR2,
9 X_Low_Value_Id NUMBER,
10 X_High_Value VARCHAR2,
11 X_High_Value_Id NUMBER,
12 X_Last_Update_Date DATE,
13 X_Last_Updated_By NUMBER,
14 X_Creation_Date DATE,
15 X_Created_By NUMBER,
16 X_Last_Update_Login NUMBER
17 );
18
19 PROCEDURE Lock_Row( X_Rowid VARCHAR2,
20 X_Criteria_Id NUMBER,
21 X_Plan_Relationship_Id NUMBER,
22 X_Char_Id NUMBER,
23 X_Operator NUMBER,
24 X_Low_Value VARCHAR2,
25 X_Low_Value_Id NUMBER,
26 X_High_Value VARCHAR2,
27 X_High_Value_Id NUMBER,
28 X_Last_Update_Date DATE,
29 X_Last_Updated_By NUMBER,
30 X_Creation_Date DATE,
31 X_Created_By NUMBER
32 );
33
34 PROCEDURE Update_Row(X_Rowid VARCHAR2,
35 X_Criteria_Id NUMBER,
36 X_Plan_Relationship_Id NUMBER,
37 X_Char_Id NUMBER,
38 X_Operator NUMBER,
39 X_Low_Value VARCHAR2,
40 X_Low_Value_Id NUMBER,
41 X_High_Value VARCHAR2,
42 X_High_Value_Id NUMBER,
43 X_Last_Update_Date DATE,
44 X_Last_Updated_By NUMBER,
45 X_Creation_Date DATE,
46 X_Created_By NUMBER,
47 X_Last_Update_Login NUMBER
48 );
49
50 PROCEDURE Delete_Row(X_Rowid VARCHAR2);
51 END QA_PC_CRITERIA_PKG;