[Home] [Help]
PACKAGE: APPS.QA_SEQ_AUDIT_PKG
Source
1 PACKAGE QA_SEQ_AUDIT_PKG AUTHID CURRENT_USER as
2 /* $Header: qaseqads.pls 115.0 2003/08/26 13:49:57 rponnusa noship $ */
3 PROCEDURE Insert_Row(P_Rowid IN OUT NOCOPY VARCHAR2,
4 P_Plan_Id NUMBER,
5 P_Collection_Id NUMBER,
6 P_Occurrence NUMBER,
7 P_Char_Id NUMBER,
8 P_Txn_Header_Id NUMBER,
9 P_Sequence_Value VARCHAR2,
10 P_User_Id NUMBER,
11 P_Source_Code VARCHAR2,
12 P_Source_Id NUMBER,
13 P_Audit_Type VARCHAR2,
14 P_Audit_Date DATE,
15 P_Last_Update_Date DATE,
16 P_Last_Updated_By NUMBER,
17 P_Creation_Date DATE,
18 P_Created_By NUMBER,
19 P_Last_Update_Login NUMBER
20 );
21
22 PROCEDURE Lock_Row (P_Rowid VARCHAR2,
23 P_Plan_Id NUMBER,
24 P_Collection_Id NUMBER,
25 P_Occurrence NUMBER,
26 P_Char_Id NUMBER,
27 P_Txn_Header_Id NUMBER,
28 P_Sequence_Value VARCHAR2,
29 P_User_Id NUMBER,
30 P_Source_Code VARCHAR2,
31 P_Source_Id NUMBER,
32 P_Audit_Type VARCHAR2,
33 P_Audit_Date DATE,
34 P_Last_Update_Date DATE,
35 P_Last_Updated_By NUMBER,
36 P_Creation_Date DATE,
37 P_Created_By NUMBER,
38 P_Last_Update_Login NUMBER
39 );
40
41 PROCEDURE Update_Row(P_Rowid VARCHAR2,
42 P_Plan_Id NUMBER,
43 P_Collection_Id NUMBER,
44 P_Occurrence NUMBER,
45 P_Char_Id NUMBER,
46 P_Txn_Header_Id NUMBER,
47 P_Sequence_Value VARCHAR2,
48 P_User_Id NUMBER,
49 P_Source_Code VARCHAR2,
50 P_Source_Id NUMBER,
51 P_Audit_Type VARCHAR2,
52 P_Audit_Date DATE,
53 P_Last_Update_Date DATE,
54 P_Last_Updated_By NUMBER,
55 P_Creation_Date DATE,
56 P_Created_By NUMBER,
57 P_Last_Update_Login NUMBER
58 );
59
60 PROCEDURE Delete_Row(P_Rowid VARCHAR2);
61
62
63 END QA_SEQ_AUDIT_PKG;