[Home] [Help]
PACKAGE: APPS.PA_PROJECTS_MAINT_UTILS
Source
1 PACKAGE PA_PROJECTS_MAINT_UTILS AUTHID CURRENT_USER AS
2 /* $Header: PARMPRUS.pls 120.2 2005/08/19 16:57:11 mwasowic noship $ */
3 -- API name : check_org_name_or_id
4 -- Type : Public
5 -- Pre-reqs : None.
6 -- Parameters :
7 -- p_organization_id IN hr_organization_units.organization_id%TYPE Required
8 -- p_name IN hr_organization_units.name%TYPE Required
9 -- p_check_id_flag IN VARCHAR2 Required
10 -- x_organization_id OUT hr_organization_units.organization_id%TYPE Required
11 -- x_return_status OUT VARCHAR2 Required
12 -- x_error_msg_code OUT VARCHAR2 Required
13 --
14 -- History
15 --
16 -- 18-AUG-2000 -- Sakthi/William - Created.
17 --
18 PROCEDURE CHECK_ORG_NAME_OR_ID
19 (p_organization_id IN hr_organization_units.organization_id%TYPE
20 ,p_name IN hr_organization_units.name%TYPE
21 ,p_check_id_flag IN VARCHAR2
22 ,x_organization_id OUT NOCOPY hr_organization_units.organization_id%TYPE --File.Sql.39 bug 4440895
23 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
24 ,x_error_msg_code OUT NOCOPY VARCHAR2) ; --File.Sql.39 bug 4440895
25
26 -- API name : check_check_project_status_or_id
27 -- Type : Public
28 -- Pre-reqs : None.
29 -- Parameters :
30 -- p_project_status_code IN pa_project_statuses.project_status_code%TYPE Required
31 -- p_project_status_name IN pa_project_statuses.project_status_name%TYPE Required
32 -- p_check_id_flag IN VARCHAR2 Required
33 -- x_project_status_code OUT pa_project_statuses.project_status_code%TYPE Required
34 -- x_return_status OUT VARCHAR2 Required
35 -- x_error_msg_code OUT VARCHAR2 Required
36 --
37 -- History
38 --
39 -- 18-AUG-2000 -- Sakthi/William - Created.
40 --
41 --
42 PROCEDURE CHECK_PROJECT_STATUS_OR_ID
43 (p_project_status_code IN pa_project_statuses.project_status_code%TYPE
44 ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE
45 ,p_check_id_flag IN VARCHAR2
46 ,x_project_status_code OUT NOCOPY pa_project_statuses.project_status_code%TYPE --File.Sql.39 bug 4440895
47 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
48 ,x_error_msg_code OUT NOCOPY VARCHAR2) ; --File.Sql.39 bug 4440895
49
50 -- API name : check_customer_name_or_id
51 -- Type : Public
52 -- Pre-reqs : None.
53 -- Parameters :
54 -- p_customer_id IN ra_customers.customer_id%TYPE Required
55 -- p_customer_name IN ra_customers.customer_name%TYPE Required
56 -- p_check_id_flag IN VARCHAR2 Required
57 -- x_return_status OUT VARCHAR2 Required
58 -- x_error_msg_code OUT VARCHAR2 Required
59 --
60 -- History
61 --
62 -- 18-AUG-2000 -- Sakthi/William - Created.
63 -- 02-JUN-2005 -- dthakker 4363092 : TCA changes, replaced RA views with HZ tables
64 --
65 --
66 PROCEDURE CHECK_CUSTOMER_NAME_OR_ID
67 (p_customer_id IN hz_cust_accounts.cust_account_id%TYPE -- ra_customers.customer_id%TYPE -- for 4363092 TCA changes
68 ,p_customer_name IN hz_parties.party_name%TYPE -- ra_customers.customer_name%TYPE -- for 4363092 TCA changes
69 ,p_check_id_flag IN VARCHAR2
70 ,x_customer_id OUT NOCOPY hz_cust_accounts.cust_account_id%TYPE -- ra_customers.customer_id%TYPE -- for 4363092 TCA changes --File.Sql.39 bug 4440895
71 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
75 -- Type : Public
72 ,x_error_msg_code OUT NOCOPY VARCHAR2) ; --File.Sql.39 bug 4440895
73
74 -- API name : check_probability_code_or_id
76 -- Pre-reqs : None.
77 -- Parameters :
78 -- p_probability_member_id IN pa_probability_members.probability_member_id%TYPE Required
79 -- p_probability_percentage IN pa_probability_members.probability_percentage%TYPE Required
80 -- p_project_type IN pa_projects_all.project_type%TYPE
81 -- p_probability_list_id IN pa_probability_lists.probability_list_id%TYPE
82 -- p_check_id_flag IN VARCHAR2 Required
83 -- x_probability_member_id OUT pa_probability_members.probability_member_id%TYPE Required
84 -- x_return_status OUT VARCHAR2 Required
85 -- x_error_msg_code OUT VARCHAR2 Required
86 --
87 -- History
88 --
89 -- 18-AUG-2000 -- Sakthi/William - Created.
90 -- 18-MAR-2002 -- xxlu Added IN parameter p_probability_list_id.
91 --
92 PROCEDURE CHECK_PROBABILITY_CODE_OR_ID
93 (p_probability_member_id IN pa_probability_members.probability_member_id%TYPE
94 ,p_probability_percentage IN pa_probability_members.probability_percentage%TYPE
95 , p_project_type IN pa_projects_all.project_type%TYPE
96 , p_probability_list_id IN pa_probability_lists.probability_list_id%TYPE := NULL
97 ,p_check_id_flag IN VARCHAR2
98 ,x_probability_member_id OUT NOCOPY pa_probability_members.probability_member_id%TYPE --File.Sql.39 bug 4440895
99 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
100 ,x_error_msg_code OUT NOCOPY VARCHAR2) ; --File.Sql.39 bug 4440895
101
102 -- API name : check_calendar_name__or_id
103 -- Type : Public
104 -- Pre-reqs : None.
105 -- Parameters :
106 -- p_calendar_id IN jtf_calendars_tl.calendar_id%TYPE Required
107 -- p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE Required
108 -- p_check_id_flag IN VARCHAR2 Required
109 -- x_calendar_id OUT jtf_calendars_tl.calendar_id%TYPE Required
110 -- x_return_status OUT VARCHAR2 Required
111 -- x_error_msg_code OUT VARCHAR2 Required
112 --
113 -- History
114 --
115 -- 18-AUG-2000 -- Sakthi/William - Created.
116 --
117 --
118 PROCEDURE CHECK_CALENDAR_NAME_OR_ID
119 (p_calendar_id IN jtf_calendars_vl.calendar_id%TYPE
120 ,p_calendar_name IN jtf_calendars_vl.calendar_name%TYPE
121 ,p_check_id_flag IN VARCHAR2
122 ,x_calendar_id OUT NOCOPY jtf_calendars_vl.calendar_id%TYPE --File.Sql.39 bug 4440895
123 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
124 ,x_error_msg_code OUT NOCOPY VARCHAR2) ; --File.Sql.39 bug 4440895
125
126 -- API name : get_project_manager
127 -- Type : Public
128 -- Pre-reqs : None.
129 -- Parameters :
130 -- p_project_id IN NUMBER
131 -- Return : NUMBER
132 --
133 -- History
134 --
138 FUNCTION GET_PROJECT_MANAGER ( p_project_id IN NUMBER)
135 -- 18-AUG-2000 -- Sakthi/William - Created.
136 --
137 --
139 RETURN NUMBER;
140
141 -- API name : get_project_manager_name
142 -- Type : Public
143 -- Pre-reqs : None.
144 -- Parameters :
145 -- p_project_id IN NUMBER
146 -- Return : VARCHAR2
147 --
148 -- History
149 --
150 -- 18-AUG-2000 -- Sakthi/William - Created.
151 --
152 --
153 FUNCTION GET_PROJECT_MANAGER_NAME ( p_person_id IN NUMBER)
154 RETURN VARCHAR2;
155
156 -- API name : get_primary_customer
157 -- Type : Public
158 -- Pre-reqs : None.
159 -- Parameters :
160 -- p_person_id IN NUMBER
161 -- Return : NUMBER
162 --
163 -- History
164 --
165 -- 18-AUG-2000 -- Sakthi/William - Created.
166 --
167 --
168 FUNCTION GET_PRIMARY_CUSTOMER ( p_project_id IN NUMBER)
169 RETURN NUMBER;
170
171 -- API name : get_primary_customer_name
172 -- Type : Public
173 -- Pre-reqs : None.
174 -- Parameters :
175 -- p_project_id IN NUMBER
176 -- Return : VARCHAR2
177 --
178 -- History
179 --
180 -- 18-AUG-2000 -- Sakthi/William - Created.
181 --
182 --
183 FUNCTION GET_PRIMARY_CUSTOMER_NAME ( p_project_id IN NUMBER)
184 RETURN VARCHAR2;
185
186 -- API name : class_check_trans
187 -- Type : Public
188 -- Pre-reqs : None.
189 -- Parameters :
190 -- p_project_id IN NUMBER
191 -- Return : VARCHAR2
192 --
193 -- History
194 --
195 -- 18-AUG-2000 -- Sakthi/William - Created.
196 --
197 --
198 FUNCTION CLASS_CHECK_TRANS ( p_project_id IN NUMBER)
199 RETURN VARCHAR2;
200
201 -- API name : check_class_catg_can_delete
202 -- Type : Public
203 -- Pre-reqs : None.
204 -- Parameters :
205 -- p_object_id IN NUMBER
206 -- p_object_type IN VARCHAR2
207 -- p_class_category IN VARCHAR2
208 -- x_return_status OUT VARCHAR2
209 -- x_error_msg_code OUT VARCHAR2
210 --
211 -- History
212 --
213 -- 18-AUG-2000 -- Sakthi/William - Created.
214 --
215 --
216 PROCEDURE CHECK_CLASS_CATG_CAN_DELETE (p_object_id NUMBER,
217 p_object_type VARCHAR2,
218 p_class_category VARCHAR2,
219 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
220 x_error_msg_code OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
221
222
223 -- API name : check_duplicate_class_catg
224 -- Type : Public
225 -- Pre-reqs : None.
226 -- Parameters :
227 -- p_object_id IN NUMBER
228 -- p_object_type IN VARCHAR2
229 -- p_class_category IN VARCHAR2
230 -- p_class_code IN VARCHAR2
231 -- x_return_status OUT VARCHAR2
232 -- x_error_msg_code OUT VARCHAR2
233 --
234 -- History
235 --
236 -- 18-AUG-2000 -- Sakthi/William - Created.
237 --
238 --
239 PROCEDURE CHECK_DUPLICATE_CLASS_CATG (p_object_id NUMBER,
240 p_object_type VARCHAR2,
241 p_class_category VARCHAR2,
242 p_class_code VARCHAR2,
243 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
244 x_error_msg_code OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
245
246
247 -- API name : check_class_catg_one_only_code
248 -- Type : Public
249 -- Pre-reqs : None.
250 -- Parameters :
251 -- p_object_id IN NUMBER
252 -- p_object_type IN VARCHAR2
253 -- p_class_category IN VARCHAR2
254 -- x_return_status OUT VARCHAR2
255 -- x_error_msg_code OUT VARCHAR2
256 --
257 -- History
258 --
259 -- 18-AUG-2000 -- Sakthi/William - Created.
260 --
261 --
262 PROCEDURE CHECK_CLASS_CATG_ONE_ONLY_CODE (
263 p_object_id NUMBER,
264 p_object_type VARCHAR2,
265 p_class_category VARCHAR2,
266 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
267 x_error_msg_code OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
268
269 -- API name : check_class_catg_can_override
270 -- Type : Public
271 -- Pre-reqs : None.
272 -- Parameters :
273 -- p_project_id IN NUMBER
274 -- p_class_category IN VARCHAR2
275 -- p_class_code IN VARCHAR2
276 -- x_return_status OUT VARCHAR2
277 -- x_error_msg_code OUT VARCHAR2
278 --
279 -- History
280 --
281 -- 18-AUG-2000 -- Sakthi/William - Created.
282 --
283 --
284 PROCEDURE CHECK_CLASS_CATG_CAN_OVERRIDE (
285 p_project_id NUMBER,
286 p_class_category VARCHAR2,
287 p_class_code VARCHAR2,
291 -- API name : check_probability_can_change
288 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
289 x_error_msg_code OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
290
292 -- Type : Public
293 -- Pre-reqs : None.
294 -- Parameters :
295 -- p_project_status_code IN VARCHAR2
296 -- x_return_status OUT VARCHAR2
297 -- x_error_msg_code OUT VARCHAR2
298 --
299 -- History
300 --
301 -- 18-AUG-2000 -- Sakthi/William - Created.
302 --
303 --
304 PROCEDURE CHECK_PROBABILITY_CAN_CHANGE (
305 p_project_status_code VARCHAR2,
306 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
307 x_error_msg_code OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
308
309 -- API name : check_bill_job_grp_req
310 -- Type : Public
311 -- Pre-reqs : None.
312 -- Parameters :
313 -- p_project_type IN VARCHAR2
314 -- p_bill_job_group IN NUMBER
315 -- x_return_status OUT VARCHAR2
316 -- x_error_msg_code OUT VARCHAR2
317 --
318 -- History
319 --
320 -- 18-AUG-2000 -- Sakthi/William - Created.
321 --
322 --
323 PROCEDURE CHECK_BILL_JOB_GRP_REQ (p_project_type IN VARCHAR2,
324 p_bill_job_group_id IN NUMBER,
325 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
326 x_error_msg_code OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
327
328 -- API name : get_cost_job_group_id
329 -- Type : Public
330 -- Pre-reqs : None.
331 -- Parameters : None.
332 -- Return : NUMBER
333 --
334 -- History
335 --
336 -- 18-AUG-2000 -- Sakthi/William - Created.
337 --
338 --
339 FUNCTION GET_COST_JOB_GROUP_ID RETURN NUMBER;
340
341 -- API name : check_bill_rate_rate_schl_exists
342 -- Type : Public
343 -- Pre-reqs : None.
344 -- Parameters :
345 -- p_project_id IN NUMBER
346 --
347 -- History
348 --
349 -- 08-SEP-2000 -- Sakthi/William - Created.
350 --
351 FUNCTION CHECK_BILL_RATE_SCHL_EXISTS (p_project_id IN NUMBER)
352 RETURN VARCHAR2;
353
354 -- API name : check_project_option_exists
355 -- Type : Public
356 -- Pre-reqs : None.
357 -- Parameters :
358 -- p_project_id IN NUMBER
359 -- p_option_code IN VARCHAR2
360 -- Return : VARCHAR2
361 --
362 -- History
363 --
364 -- 01-JUN-2001 -- Sakthi - Created.
365 --
366 --
367 FUNCTION CHECK_PROJECT_OPTION_EXISTS ( p_project_id IN NUMBER, p_option_code IN VARCHAR2)
368 RETURN VARCHAR2;
369
370
371 -- API name : check_category_total_valid
372 -- Type : Public
373 -- Pre-reqs : None.
374 -- Parameters :
375 -- p_object_id IN NUMBER
376 -- p_object_type IN VARCHAR2
377 -- p_class_category IN VARCHAR2
378 -- p_rowid IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
379 -- p_code_percentage IN NUMBER
380 -- x_return_status OUT VARCHAR2
381 -- x_error_msg_code OUT VARCHAR2
382 --
383 -- History
384 --
385 -- 11-OCT-2001 -- anlee created
386 --
387 --
388 PROCEDURE CHECK_CATEGORY_TOTAL_VALID (p_object_id NUMBER,
389 p_object_type VARCHAR2,
390 p_class_category VARCHAR2,
391 p_rowid VARCHAR2 := FND_API.G_MISS_CHAR,
392 p_code_percentage NUMBER,
393 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
394 x_error_msg_code OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
395
396
397 -- API name : check_category_valid
398 -- Type : Public
399 -- Pre-reqs : None.
400 -- Parameters :
401 -- p_object_type_id IN NUMBER
402 -- p_class_category IN VARCHAR2
403 -- x_return_status OUT VARCHAR2
404 -- x_error_msg_code OUT VARCHAR2
405 --
406 -- History
407 --
408 -- 11-OCT-2001 -- anlee created
409 --
410 --
411 PROCEDURE CHECK_CATEGORY_VALID (p_object_type_id NUMBER,
412 p_class_category VARCHAR2,
413 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
414 x_error_msg_code OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
415
416
417 -- API name : check_percentage_allowed
418 -- Type : Public
419 -- Pre-reqs : None.
420 -- Parameters :
421 -- p_class_category IN VARCHAR2
422 -- x_return_status OUT VARCHAR2
423 -- x_error_msg_code OUT VARCHAR2
424 --
425 -- History
426 --
427 -- 11-OCT-2001 -- anlee created
428 --
429 --
430 PROCEDURE CHECK_PERCENTAGE_ALLOWED (p_class_category VARCHAR2,
431 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
435 -- API name : check_mandatory_classes
432 x_error_msg_code OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
433
434
436 -- Type : Public
437 -- Pre-reqs : None.
438 -- Parameters :
439 -- p_class_category IN VARCHAR2
440 -- x_return_status OUT VARCHAR2
441 -- x_error_msg_code OUT VARCHAR2
442 --
443 -- History
444 --
445 -- 11-OCT-2001 -- anlee created
446 --
447 --
448 PROCEDURE CHECK_MANDATORY_CLASSES (p_object_id VARCHAR2,
449 p_object_type VARCHAR2,
450 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
451 x_error_msg_code OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
452
453
454 -- API name : check_agreement_currency_name_or_code
455 -- Type : Public
456 -- Pre-reqs : None.
457 -- Parameters :
458 -- p_agreement_currency IN FND_CURRENCIES_VL.currency_code%TYPE Required
459 -- p_agreement_currency_name IN FND_CURRENCIES_VL.name%TYPE Required
460 -- p_check_id_flag IN VARCHAR2 Required
461 -- x_agreement_currency OUT VARCHAR2 Required
462 -- x_return_status OUT VARCHAR2 Required
463 -- x_error_msg_code OUT VARCHAR2 Required
464 --
465 --
466 -- History
467 --
468 -- 12-OCT-2001 -- anlee created
469 --
470 --
471 procedure Check_currency_name_or_code
472 ( p_agreement_currency IN FND_CURRENCIES_VL.currency_code%TYPE
473 ,p_agreement_currency_name IN FND_CURRENCIES_VL.name%TYPE
474 ,p_check_id_flag IN VARCHAR2
475 ,x_agreement_currency OUT NOCOPY FND_CURRENCIES_VL.currency_code%TYPE --File.Sql.39 bug 4440895
476 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
477 ,x_error_msg_code OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
478
479
480 -- API name : check_agreement_org_name_or_id
481 -- Type : Public
482 -- Pre-reqs : None.
483 -- Parameters :
484 -- p_agreement_org_id IN pa_organizations_project_v.organization_id%TYPE Required
485 -- p_agreement_org_name IN pa_organizations_project_v.name%TYPE Required
486 -- p_check_id_flag IN VARCHAR2 Required
487 -- x_agreement_org_id OUT NUMBER Required
488 -- x_return_status OUT VARCHAR2 Required
489 -- x_error_msg_code OUT VARCHAR2 Required
490 --
491 --
492 -- History
493 --
494 -- 12-OCT-2001 -- anlee created
495 --
496 --
497 procedure Check_agreement_org_name_or_id
498 ( p_agreement_org_id IN pa_organizations_project_v.organization_id%TYPE
499 ,p_agreement_org_name IN pa_organizations_project_v.name%TYPE
500 ,p_check_id_flag IN VARCHAR2
501 ,x_agreement_org_id OUT NOCOPY pa_organizations_project_v.organization_id%TYPE --File.Sql.39 bug 4440895
502 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
503 ,x_error_msg_code OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
504
505
506 -- API name : get_class_codes
507 -- Type : Public
508 -- Pre-reqs : None.
509 -- Parameters :
510 -- p_object_id IN NUMBER
511 -- p_object_type IN VARCHAR2
512 -- p_class_category IN VARCHAR2
513 -- Return : VARCHAR2
514 --
515 -- History
516 --
517 -- 18-OCT-2001 -- anlee - Created
518 --
519 --
520 FUNCTION GET_CLASS_CODES(p_object_id IN NUMBER, p_object_type IN VARCHAR2, p_class_category IN VARCHAR2)
521 RETURN VARCHAR2;
522
523
524 -- API name : get_class_exceptions
525 -- Type : Public
526 -- Pre-reqs : None.
527 -- Parameters :
528 -- p_object_id IN NUMBER
529 -- p_object_type IN VARCHAR2
530 -- p_class_category IN VARCHAR2
531 -- p_mandatory IN VARCHAR2
532 -- Return : VARCHAR2
533 --
534 -- History
535 --
536 -- 18-OCT-2001 -- anlee - Created
537 --
538 --
539 FUNCTION GET_CLASS_EXCEPTIONS(p_object_id IN NUMBER, p_object_type IN VARCHAR2, p_class_category IN VARCHAR2, p_mandatory IN VARCHAR2)
540 RETURN VARCHAR2;
541
542
543 -- API name : get_object_type_id
544 -- Type : Public
545 -- Pre-reqs : None.
546 -- Parameters :
547 -- p_object_id IN NUMBER
548 -- p_object_type IN VARCHAR2
549 -- Return : NUMBER
550 --
551 -- History
552 --
553 -- 18-OCT-2001 -- anlee - Created
554 --
555 --
556 FUNCTION GET_OBJECT_TYPE_ID(p_object_id IN NUMBER, p_object_type IN VARCHAR2)
557 RETURN NUMBER;
558
559 -- API name : populate_class_exception
560 -- Type : Public
561 -- Pre-reqs : None.
562 -- Parameters :
563 -- p_project : IN NUMBER
564 -- Return : NUMBER
565 --
566 -- History
567 --
568 -- 16-NOV-2001 -- Sakthi/Ansari - Created
569 --
570 --
571
572 procedure POPULATE_CLASS_EXCEPTION (p_project_id NUMBER);
573
574
575 -- API name : check_proj_recalc
576 -- Type : Public
577 -- Pre-reqs : None.
581 -- p_organization_name IN VARCHAR2
578 -- Parameters :
579 -- p_project_id IN NUMBER
580 -- p_organization_id IN NUMBER
582 -- Return : VARCHAR2
583 --
584 -- History
585 --
586 -- 22-MAY-2002 -- anlee - Created
587 --
588 --
589 FUNCTION CHECK_PROJ_RECALC (p_project_id IN NUMBER,
590 p_organization_id IN NUMBER,
591 p_organization_name IN VARCHAR2)
592 RETURN VARCHAR2;
593
594
595 -- API name : validate_pipeline_info
596 -- Type : Public
597 -- Pre-reqs : None.
598 -- Parameters :
599 -- p_project_id IN NUMBER
600 -- Return : VARCHAR2
601 --
602 -- History
603 --
604 -- 26-JUN-2002 -- anlee - Created
605 --
606 --
607 FUNCTION VALIDATE_PIPELINE_INFO (p_project_id IN NUMBER)
608 RETURN VARCHAR2;
609
610
611 -- API name : check_classcategory_name_or_id
612 -- Type : Public
613 -- Pre-reqs : None.
614 -- Description : It validates and returns the class category id
615 -- from the class category name.
616 -- History
617 --
618 -- 20-Nov-2002 -- adabdull - Created
619
620 PROCEDURE Check_ClassCategory_Name_Or_Id(
621 p_class_category_id IN pa_class_categories.class_category_id%TYPE
622 ,p_class_category_name IN pa_class_categories.class_category%TYPE
623 ,p_check_id_flag IN VARCHAR2 DEFAULT 'A'
624 ,x_class_category_id OUT NOCOPY pa_class_categories.class_category_id%TYPE --File.Sql.39 bug 4440895
625 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
626 ,x_error_message_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
627 );
628
629
630 -- API name : check_classcode_name_or_id
631 -- Type : Public
632 -- Pre-reqs : None.
633 -- Description : It validates and returns the class code id
634 -- from the class code and class category combination
635 -- History
636 --
637 -- 20-Nov-2002 -- adabdull - Created
638
639 PROCEDURE Check_ClassCode_Name_Or_Id(
640 p_classcode_id IN pa_class_codes.class_code_id%TYPE
641 ,p_classcode_name IN pa_class_codes.class_code%TYPE
642 ,p_classcategory IN pa_class_codes.class_category%TYPE
643 ,p_check_id_flag IN VARCHAR2 DEFAULT 'A'
644 ,x_classcode_id OUT NOCOPY pa_class_codes.class_code_id%TYPE --File.Sql.39 bug 4440895
645 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
646 ,x_error_message_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
647 );
648
649 -- API name : class_check_mandatory
650 -- Type : Public
651 -- Pre-reqs : None.
652 -- Description : Checks whether the class category is mandatory and returns 'Y' or 'N'
653 -- History
654 --
655 -- 19-Jan-2003 -- vshastry - Created
656 --
657
658 FUNCTION CLASS_CHECK_MANDATORY (p_class_category VARCHAR2, p_project_id NUMBER)
659 RETURN VARCHAR2;
660
661 END PA_PROJECTS_MAINT_UTILS;