1 PACKAGE CSC_CUST_PLANS_PKG AUTHID CURRENT_USER as
2 /* $Header: csctctps.pls 115.11 2002/12/04 16:12:40 bhroy ship $ */
3 -- Start of Comments
4 -- Package name : CSC_CUST_PLANS_PKG
5 -- Purpose : Table handler package to perform inserts, update, deletes and lock
6 -- row operations on CSC_CUST_PLANS table.
7 -- History :
8 -- MM-DD-YYYY NAME MODIFICATIONS
9 -- 10-28-1999 dejoseph Created.
10 -- 12-08-1999 dejoseph 'Arcs'ed in for first code freeze.
11 -- 12-21-1999 dejoseph 'Arcs'ed in for second code freeze.
12 -- 01-03-2000 dejoseph 'Arcs'ed in for third code freeze. (10-JAN-2000)
13 -- 01-31-2000 dejoseph 'Arcs'ed in for fourth code freeze. (07-FEB-2000)
14 -- 02-13-2000 dejoseph 'Arcs'ed on for fifth code freeze. (21-FEB-2000)
15 -- 02-28-2000 dejoseph 'Arcs'ed on for sixth code freeze. (06-MAR-2000)
16 -- 04-10-2000 dejoseph Removed reference to cust_account_org in lieu of TCA's
17 -- decision to drop column org_id from hz_cust_accounts.
18
19 -- NOTE :
20 -- End of Comments
21
22 PROCEDURE Insert_Row(
23 px_CUST_PLAN_ID IN OUT NOCOPY NUMBER,
24 p_PLAN_ID IN NUMBER,
25 p_PARTY_ID IN NUMBER,
26 p_CUST_ACCOUNT_ID IN NUMBER,
27 --p_CUST_ACCOUNT_ORG IN NUMBER,
28 p_START_DATE_ACTIVE IN DATE,
29 p_END_DATE_ACTIVE IN DATE,
30 p_MANUAL_FLAG IN VARCHAR2,
31 p_PLAN_STATUS_CODE IN VARCHAR2,
32 p_REQUEST_ID IN NUMBER,
33 p_PROGRAM_APPLICATION_ID IN NUMBER,
34 p_PROGRAM_ID IN NUMBER,
35 p_PROGRAM_UPDATE_DATE IN DATE,
36 p_CREATION_DATE IN DATE,
37 p_LAST_UPDATE_DATE IN DATE,
38 p_CREATED_BY IN NUMBER,
39 p_LAST_UPDATED_BY IN NUMBER,
40 p_LAST_UPDATE_LOGIN IN NUMBER,
41 p_ATTRIBUTE1 IN VARCHAR2,
42 p_ATTRIBUTE2 IN VARCHAR2,
43 p_ATTRIBUTE3 IN VARCHAR2,
44 p_ATTRIBUTE4 IN VARCHAR2,
45 p_ATTRIBUTE5 IN VARCHAR2,
46 p_ATTRIBUTE6 IN VARCHAR2,
47 p_ATTRIBUTE7 IN VARCHAR2,
48 p_ATTRIBUTE8 IN VARCHAR2,
49 p_ATTRIBUTE9 IN VARCHAR2,
50 p_ATTRIBUTE10 IN VARCHAR2,
51 p_ATTRIBUTE11 IN VARCHAR2,
52 p_ATTRIBUTE12 IN VARCHAR2,
53 p_ATTRIBUTE13 IN VARCHAR2,
54 p_ATTRIBUTE14 IN VARCHAR2,
55 p_ATTRIBUTE15 IN VARCHAR2,
56 p_ATTRIBUTE_CATEGORY IN VARCHAR2,
57 X_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER);
58
59 PROCEDURE Update_Row(
60 p_CUST_PLAN_ID IN NUMBER,
61 p_PLAN_ID IN NUMBER,
62 p_PARTY_ID IN NUMBER,
63 p_CUST_ACCOUNT_ID IN NUMBER,
64 --p_CUST_ACCOUNT_ORG IN NUMBER,
65 p_START_DATE_ACTIVE IN DATE,
66 p_END_DATE_ACTIVE IN DATE,
67 p_MANUAL_FLAG IN VARCHAR2,
68 p_PLAN_STATUS_CODE IN VARCHAR2,
69 p_REQUEST_ID IN NUMBER,
70 p_PROGRAM_APPLICATION_ID IN NUMBER,
71 p_PROGRAM_ID IN NUMBER,
72 p_PROGRAM_UPDATE_DATE IN DATE,
73 --p_CREATION_DATE IN DATE,
74 p_LAST_UPDATE_DATE IN DATE,
75 --p_CREATED_BY IN NUMBER,
76 p_LAST_UPDATED_BY IN NUMBER,
77 p_LAST_UPDATE_LOGIN IN NUMBER,
78 p_ATTRIBUTE1 IN VARCHAR2,
79 p_ATTRIBUTE2 IN VARCHAR2,
80 p_ATTRIBUTE3 IN VARCHAR2,
81 p_ATTRIBUTE4 IN VARCHAR2,
82 p_ATTRIBUTE5 IN VARCHAR2,
83 p_ATTRIBUTE6 IN VARCHAR2,
84 p_ATTRIBUTE7 IN VARCHAR2,
85 p_ATTRIBUTE8 IN VARCHAR2,
86 p_ATTRIBUTE9 IN VARCHAR2,
87 p_ATTRIBUTE10 IN VARCHAR2,
88 p_ATTRIBUTE11 IN VARCHAR2,
89 p_ATTRIBUTE12 IN VARCHAR2,
90 p_ATTRIBUTE13 IN VARCHAR2,
91 p_ATTRIBUTE14 IN VARCHAR2,
92 p_ATTRIBUTE15 IN VARCHAR2,
93 p_ATTRIBUTE_CATEGORY IN VARCHAR2,
94 X_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER);
95
96 PROCEDURE Lock_Row(
97 p_CUST_PLAN_ID IN NUMBER := NULL,
98 p_PLAN_ID IN NUMBER := NULL,
99 p_PARTY_ID IN NUMBER := NULL,
100 p_CUST_ACCOUNT_ID IN NUMBER := NULL,
101 --p_CUST_ACCOUNT_ORG IN NUMBER := NULL,
102 p_OBJECT_VERSION_NUMBER IN NUMBER);
103
104 PROCEDURE Delete_Row(
105 p_CUST_PLAN_ID IN NUMBER := NULL,
106 p_PLAN_ID IN NUMBER := NULL,
107 p_PARTY_ID IN NUMBER := NULL);
108
109 End CSC_CUST_PLANS_PKG;