[Home] [Help]
PACKAGE: APPS.QA_PC_ELEMENT_REL_PKG
Source
1 PACKAGE QA_PC_ELEMENT_REL_PKG as
2 /* $Header: qapceles.pls 120.2 2005/12/19 04:02:43 srhariha noship $ */
3 PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
4 X_Element_Relationship_Id IN OUT NOCOPY NUMBER,
5 X_Plan_Relationship_Id NUMBER,
6 X_Parent_Char_id NUMBER,
7 X_Child_Char_id NUMBER,
8 X_Element_Relationship_Type NUMBER,
9 X_Link_Flag NUMBER,
10 X_Last_Update_Date DATE,
11 X_Last_Updated_By NUMBER,
12 X_Creation_Date DATE,
13 X_Created_By NUMBER,
14 X_Last_Update_Login NUMBER
15 );
16
17 PROCEDURE Lock_Row( X_Rowid VARCHAR2,
18 X_Element_Relationship_Id NUMBER,
19 X_Plan_Relationship_Id NUMBER,
20 X_Parent_Char_id NUMBER,
21 X_Child_Char_id NUMBER,
22 X_Element_Relationship_Type NUMBER,
23 X_Link_Flag NUMBER,
24 X_Last_Update_Date DATE,
25 X_Last_Updated_By NUMBER,
26 X_Creation_Date DATE,
27 X_Created_By NUMBER
28 );
29
30 PROCEDURE Update_Row (X_Rowid VARCHAR2,
31 X_Element_Relationship_Id NUMBER,
32 X_Plan_Relationship_Id NUMBER,
33 X_Parent_Char_id NUMBER,
34 X_Child_Char_id NUMBER,
35 X_Element_Relationship_Type NUMBER,
36 X_Link_Flag NUMBER,
37 X_Last_Update_Date DATE,
38 X_Last_Updated_By NUMBER,
39 X_Creation_Date DATE,
40 X_Created_By NUMBER,
41 X_Last_Update_Login NUMBER
42 );
43 PROCEDURE Delete_Row(X_Rowid VARCHAR2);
44
45
46 END QA_PC_ELEMENT_REL_PKG;