1 PACKAGE PA_CONTROL_ITEMS_PVT AUTHID CURRENT_USER AS
2 --$Header: PACICIVS.pls 120.8.12020000.2 2012/07/19 09:30:17 admarath ship $
3
4
5 procedure ADD_CONTROL_ITEM (
6 p_api_version IN NUMBER := 1.0
7 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
8 ,p_commit IN VARCHAR2 := FND_API.g_false
9 ,p_validate_only IN VARCHAR2 := FND_API.g_true
10 ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
11 ,p_ci_type_id IN NUMBER
12 ,p_summary IN VARCHAR2
13 ,p_status_code IN VARCHAR2
14 ,p_owner_id IN NUMBER
15 ,p_highlighted_flag IN VARCHAR2 :='N'
16 ,p_progress_status_code IN VARCHAR2 := NULL
17 ,p_progress_as_of_date IN DATE := NULL
18 ,p_classification_code IN NUMBER
19 ,p_reason_code IN NUMBER
20 ,p_project_id IN NUMBER
21 ,p_last_modified_by_id IN NUMBER
22 := NVL(PA_CONTROL_ITEMS_UTILS.GetPartyId(fnd_global.user_id ), fnd_global.user_id) -- 26-Jun-2009 cklee Modified for the Bug# 8633676
23
24 ,p_object_type IN VARCHAR2 := NULL
25 ,p_object_id IN NUMBER := NULL
26 ,p_ci_number IN VARCHAR2 := NULL
27 ,p_date_required IN DATE := NULL
28 ,p_date_closed IN DATE := NULL
29 ,p_closed_by_id IN NUMBER := NULL
30 ,p_description IN VARCHAR2 := NULL
31 ,p_status_overview IN VARCHAR2 := NULL
32 ,p_resolution IN VARCHAR2 := NULL
33 ,p_resolution_code IN NUMBER := NULL
34 ,p_priority_code IN VARCHAR2 := NULL
35 ,p_effort_level_code IN VARCHAR2 := NULL
36 ,p_open_action_num IN NUMBER := NULL
37 ,p_price IN NUMBER := NULL
38 ,p_price_currency_code IN VARCHAR2 := NULL
39 ,p_source_type_code IN VARCHAR2 := NULL
40 ,p_source_comment IN VARCHAR2 := NULL
41 ,p_source_number IN VARCHAR2 := NULL
42 ,p_source_date_received IN DATE := NULL
43 ,p_source_organization IN VARCHAR2 := NULL
44 ,p_source_person IN VARCHAR2 := NULL
45 ,p_attribute_category IN VARCHAR2 := NULL
46 ,p_attribute1 IN VARCHAR2 := NULL
47 ,p_attribute2 IN VARCHAR2 := NULL
48 ,p_attribute3 IN VARCHAR2 := NULL
49 ,p_attribute4 IN VARCHAR2 := NULL
50 ,p_attribute5 IN VARCHAR2 := NULL
51 ,p_attribute6 IN VARCHAR2 := NULL
52 ,p_attribute7 IN VARCHAR2 := NULL
53 ,p_attribute8 IN VARCHAR2 := NULL
54 ,p_attribute9 IN VARCHAR2 := NULL
55 ,p_attribute10 IN VARCHAR2 := NULL
56 ,p_attribute11 IN VARCHAR2 := NULL
57 ,p_attribute12 IN VARCHAR2 := NULL
58 ,p_attribute13 IN VARCHAR2 := NULL
59 ,p_attribute14 IN VARCHAR2 := NULL
60 ,p_attribute15 IN VARCHAR2 := NULL
61
62 -- start: 26-Jun-2009 cklee Modified for the Bug# 8633676
63 ,p_PCO_STATUS_CODE IN VARCHAR2 := NULL
64 ,p_APPROVAL_TYPE_CODE IN VARCHAR2 := NULL
65 ,p_LOCKED_FLAG IN VARCHAR2 := 'N'
66 -- end: 26-Jun-2009 cklee Modified for the Bug# 8633676
67
68 ,p_Version_number IN number := null
69 ,p_Current_Version_flag IN varchar2 := 'Y'
70 ,p_Version_Comments IN varchar2 := NULL
71 ,p_Original_ci_id IN number := NULL
72 ,p_Source_ci_id IN number := NULL
73 ,px_ci_id IN OUT NOCOPY NUMBER
74 ,x_ci_number OUT NOCOPY VARCHAR2
75 ,x_return_status OUT NOCOPY VARCHAR2
76 ,x_msg_count OUT NOCOPY NUMBER
77 ,x_msg_data OUT NOCOPY VARCHAR2
78 );
79
80
81 procedure UPDATE_CONTROL_ITEM (
82 p_api_version IN NUMBER := 1.0
83 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
84 ,p_commit IN VARCHAR2 := FND_API.g_false
85 ,p_validate_only IN VARCHAR2 := FND_API.g_true
86 ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
87
88 ,p_ci_id IN NUMBER
89 ,p_ci_type_id IN NUMBER
90 ,p_summary IN VARCHAR2
91 ,p_status_code IN VARCHAR2 := NULL
92 ,p_owner_id IN NUMBER
93 ,p_highlighted_flag IN VARCHAR2 := 'N'
94 ,p_progress_status_code IN VARCHAR2
95 ,p_progress_as_of_date IN DATE := NULL
96 ,p_classification_code IN NUMBER
97 ,p_reason_code IN NUMBER
98 ,p_record_version_number IN NUMBER
99 ,p_project_id IN NUMBER
100 ,p_last_modified_by_id IN NUMBER
101 := NVL(PA_CONTROL_ITEMS_UTILS.GetPartyId(fnd_global.user_id ), fnd_global.user_id) -- 26-Jun-2009 cklee Modified for the Bug# 8633676
102 ,p_object_type IN VARCHAR2 := NULL
103 ,p_object_id IN NUMBER := NULL
104 ,p_ci_number IN VARCHAR2 := NULL
105 ,p_date_required IN DATE := NULL
106 ,p_date_closed IN DATE := NULL
107 ,p_closed_by_id IN NUMBER := NULL
108
109 ,p_description IN VARCHAR2 := NULL
110 ,p_status_overview IN VARCHAR2 := NULL
111 ,p_resolution IN VARCHAR2 := NULL
112 ,p_resolution_code IN NUMBER := NULL
113 ,p_priority_code IN VARCHAR2 := NULL
114 ,p_effort_level_code IN VARCHAR2 := NULL
115 ,p_open_action_num IN NUMBER := NULL
116 ,p_price IN NUMBER := NULL
117 ,p_price_currency_code IN VARCHAR2 := NULL
118 ,p_source_type_code IN VARCHAR2 := NULL
119 ,p_source_comment IN VARCHAR2 := NULL
120 ,p_source_number IN VARCHAR2 := NULL
121 ,p_source_date_received IN DATE := NULL
122 ,p_source_organization IN VARCHAR2 := NULL
123 ,p_source_person IN VARCHAR2 := NULL
124 ,p_attribute_category IN VARCHAR2 := NULL
125 ,p_attribute1 IN VARCHAR2 := NULL
126 ,p_attribute2 IN VARCHAR2 := NULL
127 ,p_attribute3 IN VARCHAR2 := NULL
128 ,p_attribute4 IN VARCHAR2 := NULL
129 ,p_attribute5 IN VARCHAR2 := NULL
130 ,p_attribute6 IN VARCHAR2 := NULL
131 ,p_attribute7 IN VARCHAR2 := NULL
132 ,p_attribute8 IN VARCHAR2 := NULL
133 ,p_attribute9 IN VARCHAR2 := NULL
134 ,p_attribute10 IN VARCHAR2 := NULL
135 ,p_attribute11 IN VARCHAR2 := NULL
136 ,p_attribute12 IN VARCHAR2 := NULL
137 ,p_attribute13 IN VARCHAR2 := NULL
138 ,p_attribute14 IN VARCHAR2 := NULL
139 ,p_attribute15 IN VARCHAR2 := NULL
140
141 -- start: 26-Jun-2009 cklee Modified for the Bug# 8633676
142 ,p_PCO_STATUS_CODE IN VARCHAR2 := NULL
143 ,p_APPROVAL_TYPE_CODE IN VARCHAR2 := NULL
144 ,p_LOCKED_FLAG IN VARCHAR2 := 'N'
145 -- end: 26-Jun-2009 cklee Modified for the Bug# 8633676
146
147 ,p_Version_number IN number := null
148 ,p_Current_Version_flag IN varchar2 := 'Y'
149 ,p_Version_Comments IN varchar2 := NULL
150 ,p_Original_ci_id IN number := NULL
151 ,p_Source_ci_id IN number := NULL
152 ,p_change_approver IN varchar2 := NULL
153 ,x_return_status OUT NOCOPY VARCHAR2
154 ,x_msg_count OUT NOCOPY NUMBER
155 ,x_msg_data OUT NOCOPY VARCHAR2
156
157 );
158
159 procedure DELETE_CONTROL_ITEM (
160 p_api_version IN NUMBER := 1.0
161 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
162 ,p_commit IN VARCHAR2 := FND_API.g_false
163 ,p_validate_only IN VARCHAR2 := FND_API.g_true
164 ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
165
166 ,p_ci_id IN NUMBER
167 ,p_record_version_number IN NUMBER
168 ,x_return_status OUT NOCOPY VARCHAR2
169 ,x_msg_count OUT NOCOPY NUMBER
170 ,x_msg_data OUT NOCOPY VARCHAR2
171 );
172
173 procedure DELETE_ALL_CONTROL_ITEMS(
174 p_api_version IN NUMBER := 1.0
175 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
176 ,p_commit IN VARCHAR2 := FND_API.g_false
177 ,p_validate_only IN VARCHAR2 := FND_API.g_true
178 ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
179
180 ,p_project_id IN NUMBER
181 ,x_return_status OUT NOCOPY VARCHAR2
182 ,x_msg_count OUT NOCOPY NUMBER
183 ,x_msg_data OUT NOCOPY VARCHAR2
184 );
185
186 procedure COPY_CONTROL_ITEM (
187 p_api_version IN NUMBER := 1.0
188 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
189 ,p_commit IN VARCHAR2 := FND_API.g_false
190 ,p_validate_only IN VARCHAR2 := FND_API.g_true
191 ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
192
193 ,p_project_id IN NUMBER
194 ,p_ci_id_from IN NUMBER -- copy from this
195 ,p_ci_type_id IN NUMBER -- copy to this
196 ,p_classification_code_id IN NUMBER
197 ,p_reason_code_id IN NUMBER
198
199 ,p_include IN VARCHAR2 := 'N'
200 ,p_record_version_number_from IN NUMBER
201 ,x_ci_id OUT NOCOPY NUMBER
202 ,p_ci_number IN OUT NOCOPY VARCHAR2
203 ,x_return_status OUT NOCOPY VARCHAR2
204 ,x_msg_count OUT NOCOPY NUMBER
205 ,x_msg_data OUT NOCOPY VARCHAR2
206 );
207
208 procedure INCLUDE_CONTROL_ITEM(
209 p_api_version IN NUMBER := 1.0
210 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
211 ,p_commit IN VARCHAR2 := FND_API.g_false
212 ,p_validate_only IN VARCHAR2 := FND_API.g_true
213 ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
214
215 ,p_from_ci_id IN NUMBER
216 ,p_to_ci_id IN NUMBER
217 ,p_record_version_number_to IN NUMBER
218 ,x_relationship_id OUT NOCOPY NUMBER
219 ,x_return_status OUT NOCOPY VARCHAR2
220 ,x_msg_count OUT NOCOPY NUMBER
221 ,x_msg_data OUT NOCOPY VARCHAR2
222 );
223
224 procedure UPDATE_NUMBER_OF_ACTIONS (
225 p_api_version IN NUMBER := 1.0
226 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
227 ,p_commit IN VARCHAR2 := FND_API.g_false
228 ,p_validate_only IN VARCHAR2 := FND_API.g_true
229 ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
230
231 ,p_ci_id IN NUMBER
232 ,p_num_of_actions IN NUMBER
233 ,p_record_version_number IN NUMBER
234
235 ,x_num_of_actions OUT NOCOPY NUMBER
236 ,x_return_status OUT NOCOPY VARCHAR2
237 ,x_msg_count OUT NOCOPY NUMBER
238 ,x_msg_data OUT NOCOPY VARCHAR2
239 ,p_last_updated_by in NUMBER default fnd_global.user_id
240 ,p_last_update_date in DATE default sysdate
241 ,p_last_update_login in NUMBER default fnd_global.user_id
242 );
243
244 procedure UPDATE_CONTROL_ITEM_STATUS (
245 p_api_version IN NUMBER := 1.0
246 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
247 ,p_commit IN VARCHAR2 := FND_API.g_false
248 ,p_validate_only IN VARCHAR2 := FND_API.g_true
249 ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
250
251 ,p_ci_id IN NUMBER
252 ,p_status_code IN VARCHAR2
253 ,p_record_version_number IN NUMBER
254
255 ,x_return_status OUT NOCOPY VARCHAR2
256 ,x_msg_count OUT NOCOPY NUMBER
257 ,x_msg_data OUT NOCOPY VARCHAR2
258
259 );
260
261
262 FUNCTION ASSIGN_CONTROL_ITEM_NUMBER(
263 p_project_id IN NUMBER
264 ,p_ci_type_id IN NUMBER
265 ) RETURN VARCHAR2;
266
267
268 FUNCTION has_null_data (
269 p_ci_type_id IN NUMBER
270 ,p_project_id IN NUMBER
271 ,p_status_code IN VARCHAR2
272 ,p_owner_id IN NUMBER
273 ,p_summary IN VARCHAR2
274
275 ) RETURN BOOLEAN;
276
277 FUNCTION ci_number_exists(p_project_id IN NUMBER
278 ,p_ci_number IN VARCHAR2
279 ,p_ci_type_id IN NUMBER)
280
281 RETURN BOOLEAN;
282
283
284 FUNCTION is_lookup_valid (
285 p_lookup_type IN VARCHAR2
286 ,p_lookup_code IN VARCHAR2
287 ) RETURN BOOLEAN;
288
289 PROCEDURE change_included_cr_status(p_ci_id IN NUMBER
290 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
291 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
292 ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
293
297 p_commit IN VARCHAR2 := FND_API.g_false,
294 PROCEDURE add_related_item (
295 p_api_version IN NUMBER := 1.0,
296 p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
298 p_validate_only IN VARCHAR2 := FND_API.g_true,
299 p_max_msg_count IN NUMBER := FND_API.g_miss_num,
300 p_ci_id IN NUMBER,
301 p_related_ci_id IN NUMBER,
302 x_return_status OUT NOCOPY VARCHAR2,
303 x_msg_count OUT NOCOPY NUMBER,
304 x_msg_data OUT NOCOPY VARCHAR2
305 );
306
307 PROCEDURE delete_related_item (
308 p_api_version IN NUMBER := 1.0,
309 p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
310 p_commit IN VARCHAR2 := FND_API.g_false,
311 p_validate_only IN VARCHAR2 := FND_API.g_true,
312 p_max_msg_count IN NUMBER := FND_API.g_miss_num,
313 p_ci_id IN NUMBER,
314 p_related_ci_id IN NUMBER,
315 x_return_status OUT NOCOPY VARCHAR2,
316 x_msg_count OUT NOCOPY NUMBER,
317 x_msg_data OUT NOCOPY VARCHAR2
318 );
319
320 PROCEDURE delete_all_related_items (
321 p_api_version IN NUMBER := 1.0,
322 p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
323 p_commit IN VARCHAR2 := FND_API.g_false,
324 p_validate_only IN VARCHAR2 := FND_API.g_true,
325 p_max_msg_count IN NUMBER := FND_API.g_miss_num,
326 p_ci_id IN NUMBER,
327 x_return_status OUT NOCOPY VARCHAR2,
328 x_msg_count OUT NOCOPY NUMBER,
329 x_msg_data OUT NOCOPY VARCHAR2
330 );
331
332 PROCEDURE copy_related_items (
333 p_api_version IN NUMBER := 1.0,
334 p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
335 p_commit IN VARCHAR2 := FND_API.g_false,
336 p_validate_only IN VARCHAR2 := FND_API.g_true,
337 p_max_msg_count IN NUMBER := FND_API.g_miss_num,
338 p_from_ci_id IN NUMBER,
339 p_to_ci_id IN NUMBER,
340 x_return_status OUT NOCOPY VARCHAR2,
341 x_msg_count OUT NOCOPY NUMBER,
342 x_msg_data OUT NOCOPY VARCHAR2
343 );
344
345 PROCEDURE delete_all_included_crs (
346 p_api_version IN NUMBER := 1.0,
347 p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
348 p_commit IN VARCHAR2 := FND_API.g_false,
349 p_validate_only IN VARCHAR2 := FND_API.g_true,
350 p_max_msg_count IN NUMBER := FND_API.g_miss_num,
351 p_ci_id IN NUMBER,
352 x_return_status OUT NOCOPY VARCHAR2,
353 x_msg_count OUT NOCOPY NUMBER,
354 x_msg_data OUT NOCOPY VARCHAR2);
355
356
357 -- start: 26-Jun-2009 cklee Modified for the Bug# 8633676
358 procedure LOCK_CONTROL_ITEM (
359 p_api_version IN NUMBER := 1.0
360 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
361 ,p_commit IN VARCHAR2 := FND_API.g_false
362 ,p_validate_only IN VARCHAR2 := FND_API.g_true
363 ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
364 ,p_ci_id IN NUMBER
365 ,x_return_status OUT NOCOPY VARCHAR2
366 ,x_msg_count OUT NOCOPY NUMBER
367 ,x_msg_data OUT NOCOPY VARCHAR2
368 );
369 -- end: 26-Jun-2009 cklee Modified for the Bug# 8633676
370
371 END PA_CONTROL_ITEMS_PVT;
[Home] [Help]