[Home] [Help]
PACKAGE: APPS.QA_PC_PLAN_REL_PKG
Source
1 PACKAGE QA_PC_PLAN_REL_PKG AUTHID CURRENT_USER as
2 /* $Header: qapcplns.pls 115.5 2003/09/16 00:16:57 rkaza ship $ */
3 PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
4 X_Plan_Relationship_Id IN OUT NOCOPY NUMBER,
5 X_Parent_Plan_Id NUMBER,
6 X_Child_Plan_id NUMBER,
7 X_Plan_Relationship_Type NUMBER,
8 X_Data_Entry_Mode NUMBER,
9 X_Layout_mode NUMBER,
10 X_Auto_Row_Count NUMBER,
11 X_Default_Parent_Spec 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
20 PROCEDURE Lock_Row( X_Rowid VARCHAR2,
21 X_Plan_Relationship_Id NUMBER,
22 X_Parent_Plan_Id NUMBER,
23 X_Child_Plan_id NUMBER,
24 X_Plan_Relationship_Type NUMBER,
25 X_Data_Entry_Mode NUMBER,
26 X_Layout_mode NUMBER,
27 X_Auto_Row_Count NUMBER,
28 X_Default_Parent_Spec NUMBER,
29 X_Last_Update_Date DATE,
30 X_Last_Updated_By NUMBER,
31 X_Creation_Date DATE,
32 X_Created_By NUMBER
33 );
34
35 PROCEDURE Update_Row( X_Rowid VARCHAR2,
36 X_Plan_Relationship_Id NUMBER,
37 X_Parent_Plan_Id NUMBER,
38 X_Child_Plan_id NUMBER,
39 X_Plan_Relationship_Type NUMBER,
40 X_Data_Entry_Mode NUMBER,
41 X_Layout_mode NUMBER,
42 X_Auto_Row_Count NUMBER,
43 X_Default_Parent_Spec NUMBER,
44 X_Last_Update_Date DATE,
45 X_Last_Updated_By NUMBER,
46 X_Creation_Date DATE,
47 X_Created_By NUMBER,
48 X_Last_Update_Login NUMBER
49 );
50
51
52 PROCEDURE Delete_Row(X_Rowid VARCHAR2);
53
54 END QA_PC_PLAN_REL_PKG;