1 PACKAGE CSC_CUST_PLANS_AUDIT_PKG AUTHID CURRENT_USER as
2 /* $Header: csctcpas.pls 120.0 2005/05/30 15:48:36 appldev noship $ */
3 -- Start of Comments
4 -- Package name : CSC_CUST_PLANS_AUDIT_PKG
5 -- Purpose : To insert records into CSC_CUST_PLANS_AUDIT table. Wheneven an operation is
6 -- is done on the CSC_CUST_PLANS table, a record is inserted into the
7 -- CSC_CUST_PLANS_AUDIT table. The PLAN_STATUS_CODE keeps track of what
8 -- operation is performed on the CSC_CUST_PLANS table.
9 -- ie. APPLIED, ENABLED, DISABLED
10 -- NOTE : There is an update, lock and a delete handler available for this table,
11 -- but only for future use.
12 -- History :
13 -- MM-DD-YYYY NAME MODIFICATIONS
14 -- 10-29-1999 dejoseph Created.
15 -- 12-08-1999 dejoseph 'Arcs'ed in for first code freeze.
16 -- 12-21-1999 dejoseph 'Arcs'ed in for second code freeze.
17 -- 01-03-2000 dejoseph 'Arcs'ed in for third code freeze. (10-JAN-2000)
18 -- 01-31-2000 dejoseph 'Arcs'ed in for fourth code freeze. (07-FEB-2000)
19 -- 02-13-2000 dejoseph 'Arcs'ed on for fifth code freeze. (21-FEB-2000)
20 -- 02-28-2000 dejoseph 'Arcs'ed on for sixth code freeze. (06-MAR-2000)
21 -- 04-10-2000 dejoseph Removed reference to cust_account_org in lieu of TCA's
22 -- decision to drop column org_id from hz_cust_accounts.
23 -- 10-23-2000 dejoseph Changed the IN OUT NOCOPY parameter px_plan_audit_id to an
24 -- OUT NOCOPY parameter x_plan_audit_id. Fix to bug # 1467071
25 -- 11-12-2002 bhroy NOCOPY changes made
26 -- 12-03-2002 bhroy Added check-in comments WHENEVER OSERROR EXIT FAILURE ROLLBACK
27 --
28
29 -- NOTE :
30 -- End of Comments
31
32 PROCEDURE Insert_Row (
33 --px_PLAN_AUDIT_ID IN OUT NOCOPY NUMBER,
34 p_PLAN_ID IN NUMBER,
35 p_PARTY_ID IN NUMBER,
36 p_CUST_ACCOUNT_ID IN NUMBER,
37 --p_CUST_ACCOUNT_ORG IN NUMBER,
38 p_PLAN_STATUS_CODE IN VARCHAR2,
39 p_REQUEST_ID IN NUMBER,
40 p_PROGRAM_APPLICATION_ID IN NUMBER,
41 p_PROGRAM_ID IN NUMBER,
42 p_PROGRAM_UPDATE_DATE IN DATE,
43 p_CREATION_DATE IN DATE,
44 p_LAST_UPDATE_DATE IN DATE,
45 p_CREATED_BY IN NUMBER,
46 p_LAST_UPDATED_BY IN NUMBER,
47 p_LAST_UPDATE_LOGIN IN NUMBER,
48 p_ATTRIBUTE1 IN VARCHAR2,
49 p_ATTRIBUTE2 IN VARCHAR2,
50 p_ATTRIBUTE3 IN VARCHAR2,
51 p_ATTRIBUTE4 IN VARCHAR2,
52 p_ATTRIBUTE5 IN VARCHAR2,
53 p_ATTRIBUTE6 IN VARCHAR2,
54 p_ATTRIBUTE7 IN VARCHAR2,
55 p_ATTRIBUTE8 IN VARCHAR2,
56 p_ATTRIBUTE9 IN VARCHAR2,
57 p_ATTRIBUTE10 IN VARCHAR2,
58 p_ATTRIBUTE11 IN VARCHAR2,
59 p_ATTRIBUTE12 IN VARCHAR2,
60 p_ATTRIBUTE13 IN VARCHAR2,
61 p_ATTRIBUTE14 IN VARCHAR2,
62 p_ATTRIBUTE15 IN VARCHAR2,
63 p_ATTRIBUTE_CATEGORY IN VARCHAR2,
64 x_PLAN_AUDIT_ID OUT NOCOPY NUMBER);
65
66 PROCEDURE Update_Row(
67 p_PLAN_AUDIT_ID IN NUMBER,
68 p_PLAN_ID IN NUMBER,
69 p_PARTY_ID IN NUMBER,
70 p_CUST_ACCOUNT_ID IN NUMBER,
71 --p_CUST_ACCOUNT_ORG IN NUMBER,
72 p_PLAN_STATUS_CODE IN VARCHAR2,
73 p_REQUEST_ID IN NUMBER,
74 p_PROGRAM_APPLICATION_ID IN NUMBER,
75 p_PROGRAM_ID IN NUMBER,
76 p_PROGRAM_UPDATE_DATE IN DATE,
77 p_LAST_UPDATE_DATE IN DATE,
78 p_LAST_UPDATED_BY IN NUMBER,
79 p_LAST_UPDATE_LOGIN IN NUMBER,
80 p_ATTRIBUTE1 IN VARCHAR2,
81 p_ATTRIBUTE2 IN VARCHAR2,
82 p_ATTRIBUTE3 IN VARCHAR2,
83 p_ATTRIBUTE4 IN VARCHAR2,
84 p_ATTRIBUTE5 IN VARCHAR2,
85 p_ATTRIBUTE6 IN VARCHAR2,
86 p_ATTRIBUTE7 IN VARCHAR2,
87 p_ATTRIBUTE8 IN VARCHAR2,
88 p_ATTRIBUTE9 IN VARCHAR2,
89 p_ATTRIBUTE10 IN VARCHAR2,
90 p_ATTRIBUTE11 IN VARCHAR2,
91 p_ATTRIBUTE12 IN VARCHAR2,
92 p_ATTRIBUTE13 IN VARCHAR2,
93 p_ATTRIBUTE14 IN VARCHAR2,
94 p_ATTRIBUTE15 IN VARCHAR2,
95 p_ATTRIBUTE_CATEGORY IN VARCHAR2 );
96
97 PROCEDURE Lock_Row(
98 p_PLAN_AUDIT_ID IN NUMBER,
99 p_PLAN_ID IN NUMBER,
100 p_PARTY_ID IN NUMBER,
101 p_CUST_ACCOUNT_ID IN NUMBER,
102 --p_CUST_ACCOUNT_ORG IN NUMBER,
103 p_PLAN_STATUS_CODE IN VARCHAR2,
104 p_REQUEST_ID IN NUMBER,
105 p_PROGRAM_APPLICATION_ID IN NUMBER,
106 p_PROGRAM_ID IN NUMBER,
107 p_PROGRAM_UPDATE_DATE IN DATE,
108 p_CREATION_DATE IN DATE,
109 p_LAST_UPDATE_DATE IN DATE,
110 p_CREATED_BY IN NUMBER,
111 p_LAST_UPDATED_BY IN NUMBER,
112 p_LAST_UPDATE_LOGIN IN NUMBER,
113 p_ATTRIBUTE1 IN VARCHAR2,
114 p_ATTRIBUTE2 IN VARCHAR2,
115 p_ATTRIBUTE3 IN VARCHAR2,
116 p_ATTRIBUTE4 IN VARCHAR2,
117 p_ATTRIBUTE5 IN VARCHAR2,
118 p_ATTRIBUTE6 IN VARCHAR2,
119 p_ATTRIBUTE7 IN VARCHAR2,
120 p_ATTRIBUTE8 IN VARCHAR2,
121 p_ATTRIBUTE9 IN VARCHAR2,
122 p_ATTRIBUTE10 IN VARCHAR2,
123 p_ATTRIBUTE11 IN VARCHAR2,
124 p_ATTRIBUTE12 IN VARCHAR2,
125 p_ATTRIBUTE13 IN VARCHAR2,
126 p_ATTRIBUTE14 IN VARCHAR2,
127 p_ATTRIBUTE15 IN VARCHAR2,
128 p_ATTRIBUTE_CATEGORY IN VARCHAR2,
129 p_OBJECT_VERSION_NUMBER IN NUMBER);
130
131 PROCEDURE Delete_Row(
132 p_PLAN_AUDIT_ID NUMBER);
133
134 End CSC_CUST_PLANS_AUDIT_PKG;