DBA Data[Home] [Help]

PACKAGE: APPS.QA_PC_RESULTS_REL_PKG

Source


1 PACKAGE QA_PC_RESULTS_REL_PKG AUTHID CURRENT_USER as
2 /* $Header: qapcress.pls 115.5 2003/08/26 13:55:24 rponnusa ship $ */
3  PROCEDURE Insert_Row(X_Rowid                   IN OUT NOCOPY VARCHAR2,
4                        X_Parent_Plan_Id                 NUMBER,
5                        X_Parent_Collection_Id           NUMBER,
6                        X_Parent_Occurrence              NUMBER,
7                        X_Child_Plan_Id                  NUMBER,
8                        X_Child_Collection_Id            NUMBER,
9                        X_Child_Occurrence               NUMBER,
10                        X_Enabled_Flag                   NUMBER,
11                        X_Last_Update_Date               DATE,
12                        X_Last_Updated_By                NUMBER,
13                        X_Creation_Date                  DATE,
14                        X_Created_By                     NUMBER,
15                        X_Last_Update_Login              NUMBER,
16                        X_Child_Txn_Header_Id            NUMBER
17                       );
18 
19  PROCEDURE Lock_Row(X_Rowid                             VARCHAR2,
20                        X_Parent_Plan_Id                 NUMBER,
21                        X_Parent_Collection_Id           NUMBER,
22                        X_Parent_Occurrence              NUMBER,
23                        X_Child_Plan_Id                  NUMBER,
24                        X_Child_Collection_Id            NUMBER,
25                        X_Child_Occurrence               NUMBER,
26                        X_Enabled_Flag                   NUMBER,
27                        X_Last_Update_Date               DATE,
28                        X_Last_Updated_By                NUMBER,
29                        X_Creation_Date                  DATE,
30                        X_Created_By                     NUMBER,
31                        X_Child_Txn_Header_Id            NUMBER
32                       );
33 
34  PROCEDURE Update_Row(X_Rowid                           VARCHAR2,
35                        X_Parent_Plan_Id                 NUMBER,
36                        X_Parent_Collection_Id           NUMBER,
37                        X_Parent_Occurrence              NUMBER,
38                        X_Child_Plan_Id                  NUMBER,
39                        X_Child_Collection_Id            NUMBER,
40                        X_Child_Occurrence               NUMBER,
41                        X_Enabled_Flag                   NUMBER,
42                        X_Last_Update_Date               DATE,
43                        X_Last_Updated_By                NUMBER,
44                        X_Creation_Date                  DATE,
45                        X_Created_By                     NUMBER,
46                        X_Last_Update_Login              NUMBER,
47                        X_Child_Txn_Header_Id            NUMBER
48                       );
49  PROCEDURE Delete_Row(X_Rowid VARCHAR2);
50 
51 
52 END QA_PC_RESULTS_REL_PKG;