1 PACKAGE CSC_PLAN_HEADERS_B_PKG AUTHID CURRENT_USER as
2 /* $Header: csctrlps.pls 115.18 2002/11/25 07:54:55 bhroy ship $ */
3 -- Start of Comments
4 -- Package name : CSC_PLAN_HEADERS_B_PKG
5 -- Purpose : Table handler for CSC_PLAN_HEADER_B. Contains procedure to INSERT,
6 -- UPDATE, DISABLE, LOCK records in CSC_PLAN_HEADER_B table.
7 -- History :
8 -- MM-DD-YYYY NAME MODIFICATIONS
9 -- 10-14-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-05-2000 dejoseph Added ADD_LANGUAGE procedure. This proc. is used to
17 -- restore data integrity to a corrupted base/translation
18 -- pair and also called from $CSC_TOP/admin/sql/CSCNLADD.sql
19 -- and $CSC_TOP/sql/CSCNLINS.sql to do inserts into the TL
20 -- tables when a new languages is added in the database.
21 -- 11-08-2000 madhavan Added procedures TRANSLATE_ROW and LOAD_ROW. Fix to
22 -- bug # 1491195. (load_row is added now itself to follow
23 -- standards and to take care of future requirements to add
24 -- Relationship Plans' seed data)
25 -- 01-18-2001 dejoseph Added parameter "P_NAME" to procedure TRANSLATE_ROW.
26 -- 08-17-2001 dejoseph Made the following changes for 11.5.6 to cater to seeding
27 -- Relationship Plans: Reference bug # 1895567
28 -- - Added p_application_id in procedure insert_row
29 -- - Added p_application_id in procedure update_row
30 -- - Performed check (if l_user_id = 1, then seeded_flag = Y)
31 -- in procedure insert_row, update_row and load_row.
32 -- - In procedure translate_row, changed data type of start and
33 -- end_date_active to varchar2 from date. The conversion to
34 -- date is done here as it cannot be done in the .lct file.
35 -- 02-18-2002 dejoseph Added changes to uptake new functionality for 11.5.8.
36 -- Ct. / Agent facing application
37 -- - Added new IN parameter END_USER_TYPE
38 -- Added the dbdrv command.
39 -- 05-23-2002 dejoseph Added checkfile syntax.
40 -- 11-12-2002 bhroy NOCOPY changes made
41 -- 11-25-2002 bhroy FND_API default removed, added WHENEVER OSERROR EXIT FAILURE ROLLBACK
42 --
43 -- NOTE :
44 -- End of Comments
45
46 PROCEDURE Insert_Row(
47 px_PLAN_ID IN OUT NOCOPY NUMBER,
48 p_ORIGINAL_PLAN_ID IN NUMBER,
49 p_PLAN_GROUP_CODE IN VARCHAR2,
50 p_START_DATE_ACTIVE IN DATE,
51 p_END_DATE_ACTIVE IN DATE,
52 p_USE_FOR_CUST_ACCOUNT IN VARCHAR2,
53 p_END_USER_TYPE IN VARCHAR2 := NULL,
54 p_CUSTOMIZED_PLAN IN VARCHAR2,
55 p_PROFILE_CHECK_ID IN NUMBER,
56 p_RELATIONAL_OPERATOR IN VARCHAR2,
57 p_CRITERIA_VALUE_HIGH IN VARCHAR2,
58 p_CRITERIA_VALUE_LOW IN VARCHAR2,
59 p_CREATION_DATE IN DATE,
60 p_LAST_UPDATE_DATE IN DATE,
61 p_CREATED_BY IN NUMBER,
62 p_LAST_UPDATED_BY IN NUMBER,
63 p_LAST_UPDATE_LOGIN IN NUMBER,
64 p_ATTRIBUTE1 IN VARCHAR2,
65 p_ATTRIBUTE2 IN VARCHAR2,
66 p_ATTRIBUTE3 IN VARCHAR2,
67 p_ATTRIBUTE4 IN VARCHAR2,
68 p_ATTRIBUTE5 IN VARCHAR2,
69 p_ATTRIBUTE6 IN VARCHAR2,
70 p_ATTRIBUTE7 IN VARCHAR2,
71 p_ATTRIBUTE8 IN VARCHAR2,
72 p_ATTRIBUTE9 IN VARCHAR2,
73 p_ATTRIBUTE10 IN VARCHAR2,
74 p_ATTRIBUTE11 IN VARCHAR2,
75 p_ATTRIBUTE12 IN VARCHAR2,
76 p_ATTRIBUTE13 IN VARCHAR2,
77 p_ATTRIBUTE14 IN VARCHAR2,
78 p_ATTRIBUTE15 IN VARCHAR2,
79 p_ATTRIBUTE_CATEGORY IN VARCHAR2,
80 P_DESCRIPTION IN VARCHAR2,
81 P_NAME IN VARCHAR2,
82 P_APPLICATION_ID IN NUMBER := NULL,
83 X_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER );
84
85 PROCEDURE Update_Row(
86 p_PLAN_ID IN NUMBER,
87 p_ORIGINAL_PLAN_ID IN NUMBER,
88 p_PLAN_GROUP_CODE IN VARCHAR2,
89 p_START_DATE_ACTIVE IN DATE,
90 p_END_DATE_ACTIVE IN DATE,
91 p_USE_FOR_CUST_ACCOUNT IN VARCHAR2,
92 p_END_USER_TYPE IN VARCHAR2 := NULL,
93 p_CUSTOMIZED_PLAN IN VARCHAR2,
94 p_PROFILE_CHECK_ID IN NUMBER,
95 p_RELATIONAL_OPERATOR IN VARCHAR2,
96 p_CRITERIA_VALUE_HIGH IN VARCHAR2,
97 p_CRITERIA_VALUE_LOW IN VARCHAR2,
98 p_LAST_UPDATE_DATE IN DATE,
99 p_LAST_UPDATED_BY IN NUMBER,
100 p_LAST_UPDATE_LOGIN IN NUMBER,
101 p_ATTRIBUTE1 IN VARCHAR2,
102 p_ATTRIBUTE2 IN VARCHAR2,
103 p_ATTRIBUTE3 IN VARCHAR2,
104 p_ATTRIBUTE4 IN VARCHAR2,
105 p_ATTRIBUTE5 IN VARCHAR2,
106 p_ATTRIBUTE6 IN VARCHAR2,
107 p_ATTRIBUTE7 IN VARCHAR2,
108 p_ATTRIBUTE8 IN VARCHAR2,
109 p_ATTRIBUTE9 IN VARCHAR2,
110 p_ATTRIBUTE10 IN VARCHAR2,
111 p_ATTRIBUTE11 IN VARCHAR2,
112 p_ATTRIBUTE12 IN VARCHAR2,
113 p_ATTRIBUTE13 IN VARCHAR2,
114 p_ATTRIBUTE14 IN VARCHAR2,
115 p_ATTRIBUTE15 IN VARCHAR2,
116 p_ATTRIBUTE_CATEGORY IN VARCHAR2,
117 P_DESCRIPTION IN VARCHAR2,
118 P_NAME IN VARCHAR2,
119 P_APPLICATION_ID IN NUMBER := NULL,
120 X_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER );
121
122 PROCEDURE Lock_Row(
123 p_PLAN_ID IN NUMBER,
124 p_OBJECT_VERSION_NUMBER IN NUMBER );
125
126 PROCEDURE Disable_Row(
127 P_PLAN_ID IN NUMBER);
128
129 PROCEDURE ADD_LANGUAGE;
130
131 PROCEDURE TRANSLATE_ROW(
132 p_plan_id IN NUMBER,
133 p_name IN VARCHAR2,
134 p_description IN VARCHAR2,
135 p_owner IN VARCHAR2) ;
136
137 PROCEDURE LOAD_ROW (
138 p_PLAN_ID IN NUMBER,
139 p_ORIGINAL_PLAN_ID IN NUMBER,
140 p_PLAN_GROUP_CODE IN VARCHAR2,
141 p_START_DATE_ACTIVE IN VARCHAR2,
142 p_END_DATE_ACTIVE IN VARCHAR2,
143 p_USE_FOR_CUST_ACCOUNT IN VARCHAR2,
144 p_END_USER_TYPE IN VARCHAR2 := NULL,
145 p_CUSTOMIZED_PLAN IN VARCHAR2,
146 p_PROFILE_CHECK_ID IN NUMBER,
147 p_RELATIONAL_OPERATOR IN VARCHAR2,
148 p_CRITERIA_VALUE_HIGH IN VARCHAR2,
149 p_CRITERIA_VALUE_LOW IN VARCHAR2,
150 p_LAST_UPDATE_DATE IN DATE,
151 p_LAST_UPDATED_BY IN NUMBER,
152 p_LAST_UPDATE_LOGIN IN NUMBER,
153 p_ATTRIBUTE1 IN VARCHAR2 := NULL,
154 p_ATTRIBUTE2 IN VARCHAR2 := NULL,
155 p_ATTRIBUTE3 IN VARCHAR2 := NULL,
156 p_ATTRIBUTE4 IN VARCHAR2 := NULL,
157 p_ATTRIBUTE5 IN VARCHAR2 := NULL,
158 p_ATTRIBUTE6 IN VARCHAR2 := NULL,
159 p_ATTRIBUTE7 IN VARCHAR2 := NULL,
160 p_ATTRIBUTE8 IN VARCHAR2 := NULL,
161 p_ATTRIBUTE9 IN VARCHAR2 := NULL,
162 p_ATTRIBUTE10 IN VARCHAR2 := NULL,
163 p_ATTRIBUTE11 IN VARCHAR2 := NULL,
164 p_ATTRIBUTE12 IN VARCHAR2 := NULL,
165 p_ATTRIBUTE13 IN VARCHAR2 := NULL,
166 p_ATTRIBUTE14 IN VARCHAR2 := NULL,
167 p_ATTRIBUTE15 IN VARCHAR2 := NULL,
168 p_ATTRIBUTE_CATEGORY IN VARCHAR2 := NULL,
169 P_DESCRIPTION IN VARCHAR2,
170 P_NAME IN VARCHAR2,
171 X_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER,
172 P_APPLICATION_ID IN NUMBER := NULL,
173 P_OWNER IN VARCHAR2);
174
175 End CSC_PLAN_HEADERS_B_PKG;