[Home] [Help]
PACKAGE: APPS.CSC_PLAN_LINES_PUB
Source
1 PACKAGE CSC_PLAN_LINES_PUB AUTHID CURRENT_USER as
2 /* $Header: cscpplns.pls 120.0 2005/05/30 15:46:42 appldev noship $ */
3 -- Start of Comments
4 -- Package name : CSC_PLAN_LINES_PUB
5 -- Purpose : Package contain procedures to perform inserts, updates and
6 -- deletes on the plan details table CSC_PLAN_LINES.
7 -- History :
8 -- MM-DD-YYYY NAME MODIFICATIONS
9 -- 10-21-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 -- 11-25-2002 bhroy FND_API defaults removed, added WHENEVER OSERROR EXIT FAILURE ROLLBACK
17
18 -- NOTE :
19 -- End of Comments
20
21 -- Default number of records fetch per call
22 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
23
24 TYPE CSC_PLAN_LINES_Rec_Type IS RECORD
25 (
26 ROW_ID ROWID ,
27 LINE_ID NUMBER,
28 PLAN_ID NUMBER,
29 CONDITION_ID NUMBER,
30 CREATION_DATE DATE ,
31 LAST_UPDATE_DATE DATE,
32 CREATED_BY NUMBER,
33 LAST_UPDATED_BY NUMBER,
34 LAST_UPDATE_LOGIN NUMBER,
35 ATTRIBUTE1 VARCHAR2(450),
36 ATTRIBUTE2 VARCHAR2(450),
37 ATTRIBUTE3 VARCHAR2(450),
38 ATTRIBUTE4 VARCHAR2(450),
39 ATTRIBUTE5 VARCHAR2(450),
40 ATTRIBUTE6 VARCHAR2(450),
41 ATTRIBUTE7 VARCHAR2(450),
42 ATTRIBUTE8 VARCHAR2(450),
43 ATTRIBUTE9 VARCHAR2(450),
44 ATTRIBUTE10 VARCHAR2(450),
45 ATTRIBUTE11 VARCHAR2(450),
46 ATTRIBUTE12 VARCHAR2(450),
47 ATTRIBUTE13 VARCHAR2(450),
48 ATTRIBUTE14 VARCHAR2(450),
49 ATTRIBUTE15 VARCHAR2(450),
50 ATTRIBUTE_CATEGORY VARCHAR2(90),
51 OBJECT_VERSION_NUMBER NUMBER
52 );
53
54 G_MISS_CSC_PLAN_LINES_REC CSC_PLAN_LINES_Rec_Type;
55 TYPE CSC_PLAN_LINES_Tbl_Type IS TABLE OF CSC_PLAN_LINES_Rec_Type
56 INDEX BY BINARY_INTEGER;
57 G_MISS_CSC_PLAN_LINES_TBL CSC_PLAN_LINES_Tbl_Type;
58
59 -- *******************************************************
60 -- Start of Comments
61 -- *******************************************************
62 -- API Name: Create_plan_lines
63 -- Type : Public
64 -- Pre-Req : None.
65 -- Function: Inserts records into csc_plan_lines for a given plan_id.
66 -- Parameters:
67 -- IN
68 -- p_api_version_number IN NUMBER Required
69 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
70 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
71 -- P_CSC_PLAN_LINES_Rec IN CSC_PLAN_LINES_Rec_Type Required
72 --
73 -- OUT NOCOPY:
74 -- x_line_id OUT NOCOPY NUMBER
75 -- x_object_version_number OUT NOCOPY NUMBER
76 -- x_return_status OUT NOCOPY VARCHAR2
77 -- x_msg_count OUT NOCOPY NUMBER
78 -- x_msg_data OUT NOCOPY VARCHAR2
79 -- Version : Current version 1.0
80 -- End of Comments
81 --
82 PROCEDURE Create_plan_lines(
83 P_Api_Version_Number IN NUMBER,
84 P_Init_Msg_List IN VARCHAR2 := NULL,
85 P_Commit IN VARCHAR2 := NULL,
86 P_CSC_PLAN_LINES_Rec IN CSC_PLAN_LINES_Rec_Type := G_MISS_CSC_PLAN_LINES_REC,
87 X_LINE_ID OUT NOCOPY NUMBER,
88 X_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER,
89 X_Return_Status OUT NOCOPY VARCHAR2,
90 X_Msg_Count OUT NOCOPY NUMBER,
91 X_Msg_Data OUT NOCOPY VARCHAR2
92 );
93
94 -- *******************************************************
95 -- Start of Comments
96 -- *******************************************************
97 -- API Name: Create_plan_lines (procedure overloaded to accept a detailed parameter
98 -- list )
99 -- Type : Public
100 -- Pre-Req : None.
101 -- Function: Inserts records into csc_plan_lines for a given plan_id.
102 -- Parameters:
103 -- IN
104 -- p_api_version_number IN NUMBER Required
105 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
106 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
107 -- P_ROW_ID IN ROWID Optional Default = FND_API.G_MISS_CHAR
108 -- P_LINE_ID IN NUMBER Optional Default = FND_API.G_MISS_NUM
109 -- P_PLAN_ID IN NUMBER Required
110 -- P_CONDITION_ID IN NUMBER Required
111 -- P_CREATION_DATE IN DATE Required
112 -- P_LAST_UPDATE_DATE IN DATE Required
113 -- P_CREATED_BY IN NUMBER Required
114 -- P_LAST_UPDATED_BY IN NUMBER Required
115 -- P_LAST_UPDATE_LOGIN IN NUMBER Required
116 -- P_ATTRIBUTE1 IN VARCHAR2(450) Optional Default := FND_API.G_MISS_CHAR,
117 -- P_ATTRIBUTE2 IN VARCHAR2(450) Optional Default := FND_API.G_MISS_CHAR,
118 -- P_ATTRIBUTE3 IN VARCHAR2(450) Optional Default := FND_API.G_MISS_CHAR,
119 -- P_ATTRIBUTE4 IN VARCHAR2(450) Optional Default := FND_API.G_MISS_CHAR,
120 -- P_ATTRIBUTE5 IN VARCHAR2(450) Optional Default := FND_API.G_MISS_CHAR,
121 -- P_ATTRIBUTE6 IN VARCHAR2(450) Optional Default := FND_API.G_MISS_CHAR,
122 -- P_ATTRIBUTE7 IN VARCHAR2(450) Optional Default := FND_API.G_MISS_CHAR,
123 -- P_ATTRIBUTE8 IN VARCHAR2(450) Optional Default := FND_API.G_MISS_CHAR,
124 -- P_ATTRIBUTE9 IN VARCHAR2(450) Optional Default := FND_API.G_MISS_CHAR,
125 -- P_ATTRIBUTE10 IN VARCHAR2(450) Optional Default := FND_API.G_MISS_CHAR,
126 -- P_ATTRIBUTE11 IN VARCHAR2(450) Optional Default := FND_API.G_MISS_CHAR,
127 -- P_ATTRIBUTE12 IN VARCHAR2(450) Optional Default := FND_API.G_MISS_CHAR,
128 -- P_ATTRIBUTE13 IN VARCHAR2(450) Optional Default := FND_API.G_MISS_CHAR,
129 -- P_ATTRIBUTE14 IN VARCHAR2(450) Optional Default := FND_API.G_MISS_CHAR,
130 -- P_ATTRIBUTE15 IN VARCHAR2(450) Optional Default := FND_API.G_MISS_CHAR,
131 -- P_ATTRIBUTE_CATEGORY IN VARCHAR2(90) Optional Default := FND_API.G_MISS_CHAR,
132 -- P_OBJECT_VERSION_NUMBER IN NUMBER Required
133 --
134 -- OUT NOCOPY:
135 -- x_line_id OUT NOCOPY NUMBER
136 -- x_object_version_number OUT NOCOPY NUMBER
137 -- x_return_status OUT NOCOPY VARCHAR2
138 -- x_msg_count OUT NOCOPY NUMBER
139 -- x_msg_data OUT NOCOPY VARCHAR2
140 -- Version : Current version 1.0
141 -- End of Comments
142 --
143 PROCEDURE Create_plan_lines(
144 P_Api_Version_Number IN NUMBER,
145 P_Init_Msg_List IN VARCHAR2 := NULL,
146 P_Commit IN VARCHAR2 := NULL,
147 P_ROW_ID IN ROWID := NULL,
148 P_LINE_ID IN NUMBER,
149 P_PLAN_ID IN NUMBER,
150 P_CONDITION_ID IN NUMBER,
151 P_CREATION_DATE IN DATE,
152 P_LAST_UPDATE_DATE IN DATE,
153 P_CREATED_BY IN NUMBER,
154 P_LAST_UPDATED_BY IN NUMBER,
155 P_LAST_UPDATE_LOGIN IN NUMBER := NULL,
156 P_ATTRIBUTE1 IN VARCHAR2 := NULL,
157 P_ATTRIBUTE2 IN VARCHAR2 := NULL,
158 P_ATTRIBUTE3 IN VARCHAR2 := NULL,
159 P_ATTRIBUTE4 IN VARCHAR2 :=NULL,
160 P_ATTRIBUTE5 IN VARCHAR2 :=NULL,
161 P_ATTRIBUTE6 IN VARCHAR2 := NULL,
162 P_ATTRIBUTE7 IN VARCHAR2 := NULL,
163 P_ATTRIBUTE8 IN VARCHAR2 := NULL,
164 P_ATTRIBUTE9 IN VARCHAR2 := NULL,
165 P_ATTRIBUTE10 IN VARCHAR2 := NULL,
166 P_ATTRIBUTE11 IN VARCHAR2 := NULL,
167 P_ATTRIBUTE12 IN VARCHAR2 := NULL,
168 P_ATTRIBUTE13 IN VARCHAR2 := NULL,
169 P_ATTRIBUTE14 IN VARCHAR2 := NULL,
170 P_ATTRIBUTE15 IN VARCHAR2 := NULL,
171 P_ATTRIBUTE_CATEGORY IN VARCHAR2 := NULL,
172 P_OBJECT_VERSION_NUMBER IN NUMBER,
173 X_LINE_ID OUT NOCOPY NUMBER,
174 X_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER,
175 X_Return_Status OUT NOCOPY VARCHAR2,
176 X_Msg_Count OUT NOCOPY NUMBER,
177 X_Msg_Data OUT NOCOPY VARCHAR2
178 );
179
180 -- *******************************************************
181 -- Start of Comments
182 -- *******************************************************
183 -- API Name: Update_plan_lines
184 -- Type : Public
185 -- Pre-Req :
186 -- Parameters:
187 -- IN
188 -- p_api_version_number IN NUMBER Required
189 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
190 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
191 -- P_CSC_PLAN_LINES_Rec IN CSC_PLAN_LINES_Rec_Type Required
192 --
193 -- OUT NOCOPY:
194 -- x_object_version_number OUT NOCOPY NUMBER
195 -- x_return_status OUT NOCOPY VARCHAR2
196 -- x_msg_count OUT NOCOPY NUMBER
197 -- x_msg_data OUT NOCOPY VARCHAR2
198 -- Version : Current version 1.0
199 -- Note: This automatic generated procedure definition, it includes standard IN/OUT NOCOPY parameters
200 -- and basic operation, developer must manually add parameters and business logic as necessary.
201 --
202 -- End of Comments
203 --
204 PROCEDURE Update_plan_lines(
205 P_Api_Version_Number IN NUMBER,
206 P_Init_Msg_List IN VARCHAR2 := NULL,
207 P_Commit IN VARCHAR2 := NULL,
208 P_CSC_PLAN_LINES_Rec IN CSC_PLAN_LINES_Rec_Type,
209 X_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER,
210 X_Return_Status OUT NOCOPY VARCHAR2,
211 X_Msg_Count OUT NOCOPY NUMBER,
212 X_Msg_Data OUT NOCOPY VARCHAR2
213 );
214
215 -- *******************************************************
216 -- Start of Comments
217 -- *******************************************************
218 -- API Name: Update_plan_lines (procedure overloaded to accept a detailed parameter
219 -- list )
220 -- Type : Public
221 -- Pre-Req :
222 -- Parameters:
223 -- IN
224 -- p_api_version_number IN NUMBER Required
225 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
226 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
227 -- P_CSC_PLAN_LINES_Rec IN CSC_PLAN_LINES_Rec_Type Required
228 -- P_ROW_ID IN ROWID Optional Default = FND_API.G_MISS_CHAR
229 -- P_LINE_ID IN NUMBER Optional Default = FND_API.G_MISS_NUM
230 -- P_PLAN_ID IN NUMBER Required
231 -- P_CONDITION_ID IN NUMBER Required
232 -- P_CREATION_DATE IN DATE Required
233 -- P_LAST_UPDATE_DATE IN DATE Required
234 -- P_CREATED_BY IN NUMBER Required
235 -- P_LAST_UPDATED_BY IN NUMBER Required
236 -- P_LAST_UPDATE_LOGIN IN NUMBER Required
237 -- P_ATTRIBUTE1 IN VARCHAR2(450) Optional Default := FND_API.G_MISS_CHAR,
238 -- P_ATTRIBUTE2 IN VARCHAR2(450) Optional Default := FND_API.G_MISS_CHAR,
239 -- P_ATTRIBUTE3 IN VARCHAR2(450) Optional Default := FND_API.G_MISS_CHAR,
240 -- P_ATTRIBUTE4 IN VARCHAR2(450) Optional Default := FND_API.G_MISS_CHAR,
241 -- P_ATTRIBUTE5 IN VARCHAR2(450) Optional Default := FND_API.G_MISS_CHAR,
242 -- P_ATTRIBUTE6 IN VARCHAR2(450) Optional Default := FND_API.G_MISS_CHAR,
243 -- P_ATTRIBUTE7 IN VARCHAR2(450) Optional Default := FND_API.G_MISS_CHAR,
244 -- P_ATTRIBUTE8 IN VARCHAR2(450) Optional Default := FND_API.G_MISS_CHAR,
245 -- P_ATTRIBUTE9 IN VARCHAR2(450) Optional Default := FND_API.G_MISS_CHAR,
246 -- P_ATTRIBUTE10 IN VARCHAR2(450) Optional Default := FND_API.G_MISS_CHAR,
247 -- P_ATTRIBUTE11 IN VARCHAR2(450) Optional Default := FND_API.G_MISS_CHAR,
248 -- P_ATTRIBUTE12 IN VARCHAR2(450) Optional Default := FND_API.G_MISS_CHAR,
249 -- P_ATTRIBUTE13 IN VARCHAR2(450) Optional Default := FND_API.G_MISS_CHAR,
250 -- P_ATTRIBUTE14 IN VARCHAR2(450) Optional Default := FND_API.G_MISS_CHAR,
251 -- P_ATTRIBUTE15 IN VARCHAR2(450) Optional Default := FND_API.G_MISS_CHAR,
252 -- P_ATTRIBUTE_CATEGORY IN VARCHAR2(90) Optional Default := FND_API.G_MISS_CHAR,
253 -- P_OBJECT_VERSION_NUMBER IN NUMBER Optional Default := FND_API.G_MISS_NUM
254 --
255 -- OUT NOCOPY:
256 -- x_object_version_number OUT NOCOPY NUMBER
257 -- x_return_status OUT NOCOPY VARCHAR2
258 -- x_msg_count OUT NOCOPY NUMBER
259 -- x_msg_data OUT NOCOPY VARCHAR2
260 -- Version : Current version 1.0
261 --
262 -- End of Comments
263 --
264 PROCEDURE Update_plan_lines(
265 P_Api_Version_Number IN NUMBER,
266 P_Init_Msg_List IN VARCHAR2 := NULL,
267 P_Commit IN VARCHAR2 := NULL,
268 P_ROW_ID IN ROWID := NULL,
269 P_LINE_ID IN NUMBER,
270 P_PLAN_ID IN NUMBER,
271 P_CONDITION_ID IN NUMBER,
272 P_CREATION_DATE IN DATE,
273 P_LAST_UPDATE_DATE IN DATE,
274 P_CREATED_BY IN NUMBER,
275 P_LAST_UPDATED_BY IN NUMBER,
276 P_LAST_UPDATE_LOGIN IN NUMBER :=NULL,
277 P_ATTRIBUTE1 IN VARCHAR2 := NULL,
278 P_ATTRIBUTE2 IN VARCHAR2 := NULL,
279 P_ATTRIBUTE3 IN VARCHAR2 := NULL,
280 P_ATTRIBUTE4 IN VARCHAR2 := NULL,
281 P_ATTRIBUTE5 IN VARCHAR2 := NULL,
282 P_ATTRIBUTE6 IN VARCHAR2 := NULL,
283 P_ATTRIBUTE7 IN VARCHAR2 := NULL,
284 P_ATTRIBUTE8 IN VARCHAR2 := NULL,
285 P_ATTRIBUTE9 IN VARCHAR2 := NULL,
286 P_ATTRIBUTE10 IN VARCHAR2 := NULL,
287 P_ATTRIBUTE11 IN VARCHAR2 := NULL,
288 P_ATTRIBUTE12 IN VARCHAR2 := NULL,
289 P_ATTRIBUTE13 IN VARCHAR2 := NULL,
290 P_ATTRIBUTE14 IN VARCHAR2 := NULL,
291 P_ATTRIBUTE15 IN VARCHAR2 := NULL,
292 P_ATTRIBUTE_CATEGORY IN VARCHAR2 := NULL,
293 P_OBJECT_VERSION_NUMBER IN NUMBER,
294 X_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER,
295 X_Return_Status OUT NOCOPY VARCHAR2,
296 X_Msg_Count OUT NOCOPY NUMBER,
297 X_Msg_Data OUT NOCOPY VARCHAR2
298 );
299
303 -- API Name: Delete_plan_lines
300 -- *******************************************************
301 -- Start of Comments
302 -- *******************************************************
304 -- Type : Public
305 -- Pre-Req :
306 -- Parameters:
307 -- IN
308 -- p_api_version_number IN NUMBER Required
309 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
310 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
311 -- p_plan_id IN NUMBER Optional Default = FND_API.G_FALSE
312 -- p_line_id IN NUMBER Optional Default = FND_API.G_FALSE
313 --
314 -- OUT NOCOPY:
315 -- x_return_status OUT NOCOPY VARCHAR2
316 -- x_msg_count OUT NOCOPY NUMBER
317 -- x_msg_data OUT NOCOPY VARCHAR2
318 -- Version : Current version 1.0
319 --
323 P_Api_Version_Number IN NUMBER,
320 -- End of Comments
321 --
322 PROCEDURE Delete_plan_lines(
324 P_Init_Msg_List IN VARCHAR2 := NULL,
325 P_Commit IN VARCHAR2 := NULL,
326 P_Plan_Id IN NUMBER := NULL,
327 P_Line_Id IN NUMBER := NULL,
328 X_Return_Status OUT NOCOPY VARCHAR2,
329 X_Msg_Count OUT NOCOPY NUMBER,
330 X_Msg_Data OUT NOCOPY VARCHAR2
331 );
332
333 End CSC_PLAN_LINES_PUB;