eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_TASKS_MAINT_PUB dependencies on FND_API

Line 10: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

6: -- Pre-reqs : None
7: -- Return Value : N/A
8: -- Parameters
9: -- p_api_version IN NUMBER := 1.0
10: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
11: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
12: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
13: -- p_validation_level IN VARCHAR2 := 100
14: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'

Line 11: -- p_commit IN VARCHAR2 := FND_API.G_FALSE

7: -- Return Value : N/A
8: -- Parameters
9: -- p_api_version IN NUMBER := 1.0
10: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
11: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
12: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
13: -- p_validation_level IN VARCHAR2 := 100
14: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
15: -- p_debug_mode IN VARCHAR2 := 'N'

Line 12: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE

8: -- Parameters
9: -- p_api_version IN NUMBER := 1.0
10: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
11: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
12: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
13: -- p_validation_level IN VARCHAR2 := 100
14: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
15: -- p_debug_mode IN VARCHAR2 := 'N'
16: -- p_project_id IN NUMBER

Line 127: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

123: --
124: procedure CREATE_TASK
125: (
126: p_api_version IN NUMBER := 1.0
127: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
128: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
129: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
130: ,p_validation_level IN VARCHAR2 := 100
131: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'

Line 128: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

124: procedure CREATE_TASK
125: (
126: p_api_version IN NUMBER := 1.0
127: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
128: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
129: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
130: ,p_validation_level IN VARCHAR2 := 100
131: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
132: ,p_debug_mode IN VARCHAR2 := 'N'

Line 129: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

125: (
126: p_api_version IN NUMBER := 1.0
127: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
128: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
129: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
130: ,p_validation_level IN VARCHAR2 := 100
131: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
132: ,p_debug_mode IN VARCHAR2 := 'N'
133:

Line 254: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

250: -- Pre-reqs : None
251: -- Return Value : N/A
252: -- Parameters
253: -- p_api_version IN NUMBER := 1.0
254: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
255: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
256: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
257: -- p_validation_level IN VARCHAR2 := 100
258: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'

Line 255: -- p_commit IN VARCHAR2 := FND_API.G_FALSE

251: -- Return Value : N/A
252: -- Parameters
253: -- p_api_version IN NUMBER := 1.0
254: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
255: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
256: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
257: -- p_validation_level IN VARCHAR2 := 100
258: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
259: -- p_debug_mode IN VARCHAR2 := 'N'

Line 256: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE

252: -- Parameters
253: -- p_api_version IN NUMBER := 1.0
254: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
255: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
256: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
257: -- p_validation_level IN VARCHAR2 := 100
258: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
259: -- p_debug_mode IN VARCHAR2 := 'N'
260: -- p_project_id IN NUMBER

Line 373: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

369:
370: procedure UPDATE_TASK
371: (
372: p_api_version IN NUMBER := 1.0
373: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
374: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
375: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
376: ,p_validation_level IN VARCHAR2 := 100
377: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'

Line 374: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

370: procedure UPDATE_TASK
371: (
372: p_api_version IN NUMBER := 1.0
373: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
374: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
375: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
376: ,p_validation_level IN VARCHAR2 := 100
377: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
378: ,p_debug_mode IN VARCHAR2 := 'N'

Line 375: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

371: (
372: p_api_version IN NUMBER := 1.0
373: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
374: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
375: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
376: ,p_validation_level IN VARCHAR2 := 100
377: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
378: ,p_debug_mode IN VARCHAR2 := 'N'
379:

Line 501: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

497: -- Pre-reqs : None
498: -- Return Value : N/A
499: -- Parameters
500: -- p_api_version IN NUMBER := 1.0
501: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
502: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
503: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
504: -- p_validation_level IN VARCHAR2 := 100
505: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'

Line 502: -- p_commit IN VARCHAR2 := FND_API.G_FALSE

498: -- Return Value : N/A
499: -- Parameters
500: -- p_api_version IN NUMBER := 1.0
501: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
502: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
503: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
504: -- p_validation_level IN VARCHAR2 := 100
505: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
506: -- p_debug_mode IN VARCHAR2 := 'N'

Line 503: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE

499: -- Parameters
500: -- p_api_version IN NUMBER := 1.0
501: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
502: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
503: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
504: -- p_validation_level IN VARCHAR2 := 100
505: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
506: -- p_debug_mode IN VARCHAR2 := 'N'
507: -- p_project_id IN NUMBER

Line 524: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

520: --
521: procedure DELETE_TASK
522: (
523: p_api_version IN NUMBER := 1.0
524: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
525: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
526: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
527: ,p_validation_level IN VARCHAR2 := 100
528: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'

Line 525: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

521: procedure DELETE_TASK
522: (
523: p_api_version IN NUMBER := 1.0
524: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
525: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
526: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
527: ,p_validation_level IN VARCHAR2 := 100
528: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
529: ,p_debug_mode IN VARCHAR2 := 'N'

Line 526: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

522: (
523: p_api_version IN NUMBER := 1.0
524: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
525: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
526: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
527: ,p_validation_level IN VARCHAR2 := 100
528: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
529: ,p_debug_mode IN VARCHAR2 := 'N'
530: ,p_project_id IN NUMBER

Line 548: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

544: -- Pre-reqs : None
545: -- Return Value : N/A
546: -- Parameters
547: -- p_api_version IN NUMBER := 1.0
548: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
549: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
550: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
551: -- p_validation_level IN VARCHAR2 := 100
552: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'

Line 549: -- p_commit IN VARCHAR2 := FND_API.G_FALSE

545: -- Return Value : N/A
546: -- Parameters
547: -- p_api_version IN NUMBER := 1.0
548: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
549: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
550: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
551: -- p_validation_level IN VARCHAR2 := 100
552: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
553: -- p_debug_mode IN VARCHAR2 := 'N'

Line 550: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE

546: -- Parameters
547: -- p_api_version IN NUMBER := 1.0
548: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
549: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
550: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
551: -- p_validation_level IN VARCHAR2 := 100
552: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
553: -- p_debug_mode IN VARCHAR2 := 'N'
554: -- p_project_id IN NUMBER := FND_API.G_MISS_NUM

Line 554: -- p_project_id IN NUMBER := FND_API.G_MISS_NUM

550: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
551: -- p_validation_level IN VARCHAR2 := 100
552: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
553: -- p_debug_mode IN VARCHAR2 := 'N'
554: -- p_project_id IN NUMBER := FND_API.G_MISS_NUM
555: -- p_project_name IN VARCHAR2 := FND_API.G_MISS_CHAR
556: -- p_task_id IN NUMBER := FND_API.G_MISS_NUM
557: -- p_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
558: -- p_edit_mode IN VARCHAR2 REQUIRED

Line 555: -- p_project_name IN VARCHAR2 := FND_API.G_MISS_CHAR

551: -- p_validation_level IN VARCHAR2 := 100
552: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
553: -- p_debug_mode IN VARCHAR2 := 'N'
554: -- p_project_id IN NUMBER := FND_API.G_MISS_NUM
555: -- p_project_name IN VARCHAR2 := FND_API.G_MISS_CHAR
556: -- p_task_id IN NUMBER := FND_API.G_MISS_NUM
557: -- p_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
558: -- p_edit_mode IN VARCHAR2 REQUIRED
559: -- p_record_version_number IN NUMBER

Line 556: -- p_task_id IN NUMBER := FND_API.G_MISS_NUM

552: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
553: -- p_debug_mode IN VARCHAR2 := 'N'
554: -- p_project_id IN NUMBER := FND_API.G_MISS_NUM
555: -- p_project_name IN VARCHAR2 := FND_API.G_MISS_CHAR
556: -- p_task_id IN NUMBER := FND_API.G_MISS_NUM
557: -- p_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
558: -- p_edit_mode IN VARCHAR2 REQUIRED
559: -- p_record_version_number IN NUMBER
560: -- p_wbs_record_version_number IN NUMBER

Line 557: -- p_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR

553: -- p_debug_mode IN VARCHAR2 := 'N'
554: -- p_project_id IN NUMBER := FND_API.G_MISS_NUM
555: -- p_project_name IN VARCHAR2 := FND_API.G_MISS_CHAR
556: -- p_task_id IN NUMBER := FND_API.G_MISS_NUM
557: -- p_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
558: -- p_edit_mode IN VARCHAR2 REQUIRED
559: -- p_record_version_number IN NUMBER
560: -- p_wbs_record_version_number IN NUMBER
561: -- x_return_status OUT VARCHAR2

Line 573: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

569: --
570:
571: PROCEDURE Edit_Task_Structure(
572: p_api_version IN NUMBER := 1.0
573: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
574: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
575: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
576: ,p_validation_level IN VARCHAR2 := 100
577: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'

Line 574: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

570:
571: PROCEDURE Edit_Task_Structure(
572: p_api_version IN NUMBER := 1.0
573: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
574: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
575: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
576: ,p_validation_level IN VARCHAR2 := 100
577: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
578: ,p_debug_mode IN VARCHAR2 := 'N'

Line 575: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

571: PROCEDURE Edit_Task_Structure(
572: p_api_version IN NUMBER := 1.0
573: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
574: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
575: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
576: ,p_validation_level IN VARCHAR2 := 100
577: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
578: ,p_debug_mode IN VARCHAR2 := 'N'
579: ,p_project_id IN NUMBER := FND_API.G_MISS_NUM

Line 579: ,p_project_id IN NUMBER := FND_API.G_MISS_NUM

575: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
576: ,p_validation_level IN VARCHAR2 := 100
577: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
578: ,p_debug_mode IN VARCHAR2 := 'N'
579: ,p_project_id IN NUMBER := FND_API.G_MISS_NUM
580: ,p_project_name IN VARCHAR2 := FND_API.G_MISS_CHAR
581: ,p_task_id IN NUMBER := FND_API.G_MISS_NUM
582: ,p_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
583: ,p_edit_mode IN VARCHAR2

Line 580: ,p_project_name IN VARCHAR2 := FND_API.G_MISS_CHAR

576: ,p_validation_level IN VARCHAR2 := 100
577: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
578: ,p_debug_mode IN VARCHAR2 := 'N'
579: ,p_project_id IN NUMBER := FND_API.G_MISS_NUM
580: ,p_project_name IN VARCHAR2 := FND_API.G_MISS_CHAR
581: ,p_task_id IN NUMBER := FND_API.G_MISS_NUM
582: ,p_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
583: ,p_edit_mode IN VARCHAR2
584: ,p_record_version_number IN NUMBER

Line 581: ,p_task_id IN NUMBER := FND_API.G_MISS_NUM

577: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
578: ,p_debug_mode IN VARCHAR2 := 'N'
579: ,p_project_id IN NUMBER := FND_API.G_MISS_NUM
580: ,p_project_name IN VARCHAR2 := FND_API.G_MISS_CHAR
581: ,p_task_id IN NUMBER := FND_API.G_MISS_NUM
582: ,p_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
583: ,p_edit_mode IN VARCHAR2
584: ,p_record_version_number IN NUMBER
585: ,p_wbs_record_version_number IN NUMBER

Line 582: ,p_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR

578: ,p_debug_mode IN VARCHAR2 := 'N'
579: ,p_project_id IN NUMBER := FND_API.G_MISS_NUM
580: ,p_project_name IN VARCHAR2 := FND_API.G_MISS_CHAR
581: ,p_task_id IN NUMBER := FND_API.G_MISS_NUM
582: ,p_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
583: ,p_edit_mode IN VARCHAR2
584: ,p_record_version_number IN NUMBER
585: ,p_wbs_record_version_number IN NUMBER
586: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 597: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

593: -- Pre-reqs : None
594: -- Return Value : N/A
595: -- Prameters
596: -- p_api_version IN NUMBER := 1.0
597: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
598: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
599: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
600: -- p_validation_level IN VARCHAR2 := 100
601: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'

Line 598: -- p_commit IN VARCHAR2 := FND_API.G_FALSE

594: -- Return Value : N/A
595: -- Prameters
596: -- p_api_version IN NUMBER := 1.0
597: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
598: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
599: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
600: -- p_validation_level IN VARCHAR2 := 100
601: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
602: -- p_debug_mode IN VARCHAR2 := 'N'

Line 599: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE

595: -- Prameters
596: -- p_api_version IN NUMBER := 1.0
597: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
598: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
599: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
600: -- p_validation_level IN VARCHAR2 := 100
601: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
602: -- p_debug_mode IN VARCHAR2 := 'N'
603: -- p_reference_project_id IN NUMBER := FND_API.G_MISS_NUM

Line 603: -- p_reference_project_id IN NUMBER := FND_API.G_MISS_NUM

599: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
600: -- p_validation_level IN VARCHAR2 := 100
601: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
602: -- p_debug_mode IN VARCHAR2 := 'N'
603: -- p_reference_project_id IN NUMBER := FND_API.G_MISS_NUM
604: -- p_reference_project_name IN VARCHAR2 := FND_API.G_MISS_CHAR
605: -- p_reference_task_id IN NUMBER := FND_API.G_MISS_NUM
606: -- p_reference_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
607: -- p_project_id IN NUMBER := FND_API.G_MISS_NUM

Line 604: -- p_reference_project_name IN VARCHAR2 := FND_API.G_MISS_CHAR

600: -- p_validation_level IN VARCHAR2 := 100
601: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
602: -- p_debug_mode IN VARCHAR2 := 'N'
603: -- p_reference_project_id IN NUMBER := FND_API.G_MISS_NUM
604: -- p_reference_project_name IN VARCHAR2 := FND_API.G_MISS_CHAR
605: -- p_reference_task_id IN NUMBER := FND_API.G_MISS_NUM
606: -- p_reference_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
607: -- p_project_id IN NUMBER := FND_API.G_MISS_NUM
608: -- p_project_name IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 605: -- p_reference_task_id IN NUMBER := FND_API.G_MISS_NUM

601: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
602: -- p_debug_mode IN VARCHAR2 := 'N'
603: -- p_reference_project_id IN NUMBER := FND_API.G_MISS_NUM
604: -- p_reference_project_name IN VARCHAR2 := FND_API.G_MISS_CHAR
605: -- p_reference_task_id IN NUMBER := FND_API.G_MISS_NUM
606: -- p_reference_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
607: -- p_project_id IN NUMBER := FND_API.G_MISS_NUM
608: -- p_project_name IN VARCHAR2 := FND_API.G_MISS_CHAR
609: -- p_task_id IN NUMBER := FND_API.G_MISS_NUM

Line 606: -- p_reference_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR

602: -- p_debug_mode IN VARCHAR2 := 'N'
603: -- p_reference_project_id IN NUMBER := FND_API.G_MISS_NUM
604: -- p_reference_project_name IN VARCHAR2 := FND_API.G_MISS_CHAR
605: -- p_reference_task_id IN NUMBER := FND_API.G_MISS_NUM
606: -- p_reference_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
607: -- p_project_id IN NUMBER := FND_API.G_MISS_NUM
608: -- p_project_name IN VARCHAR2 := FND_API.G_MISS_CHAR
609: -- p_task_id IN NUMBER := FND_API.G_MISS_NUM
610: -- p_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 607: -- p_project_id IN NUMBER := FND_API.G_MISS_NUM

603: -- p_reference_project_id IN NUMBER := FND_API.G_MISS_NUM
604: -- p_reference_project_name IN VARCHAR2 := FND_API.G_MISS_CHAR
605: -- p_reference_task_id IN NUMBER := FND_API.G_MISS_NUM
606: -- p_reference_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
607: -- p_project_id IN NUMBER := FND_API.G_MISS_NUM
608: -- p_project_name IN VARCHAR2 := FND_API.G_MISS_CHAR
609: -- p_task_id IN NUMBER := FND_API.G_MISS_NUM
610: -- p_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
611: -- p_peer_or_sub IN VARCHAR2

Line 608: -- p_project_name IN VARCHAR2 := FND_API.G_MISS_CHAR

604: -- p_reference_project_name IN VARCHAR2 := FND_API.G_MISS_CHAR
605: -- p_reference_task_id IN NUMBER := FND_API.G_MISS_NUM
606: -- p_reference_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
607: -- p_project_id IN NUMBER := FND_API.G_MISS_NUM
608: -- p_project_name IN VARCHAR2 := FND_API.G_MISS_CHAR
609: -- p_task_id IN NUMBER := FND_API.G_MISS_NUM
610: -- p_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
611: -- p_peer_or_sub IN VARCHAR2
612: -- p_record_version_number IN NUMBER

Line 609: -- p_task_id IN NUMBER := FND_API.G_MISS_NUM

605: -- p_reference_task_id IN NUMBER := FND_API.G_MISS_NUM
606: -- p_reference_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
607: -- p_project_id IN NUMBER := FND_API.G_MISS_NUM
608: -- p_project_name IN VARCHAR2 := FND_API.G_MISS_CHAR
609: -- p_task_id IN NUMBER := FND_API.G_MISS_NUM
610: -- p_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
611: -- p_peer_or_sub IN VARCHAR2
612: -- p_record_version_number IN NUMBER
613: -- p_wbs_record_version_number IN NUMBER

Line 610: -- p_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR

606: -- p_reference_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
607: -- p_project_id IN NUMBER := FND_API.G_MISS_NUM
608: -- p_project_name IN VARCHAR2 := FND_API.G_MISS_CHAR
609: -- p_task_id IN NUMBER := FND_API.G_MISS_NUM
610: -- p_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
611: -- p_peer_or_sub IN VARCHAR2
612: -- p_record_version_number IN NUMBER
613: -- p_wbs_record_version_number IN NUMBER
614:

Line 627: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

623: --
624:
625: PROCEDURE Move_Task(
626: p_api_version IN NUMBER := 1.0
627: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
628: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
629: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
630: ,p_validation_level IN VARCHAR2 := 100
631: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'

Line 628: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

624:
625: PROCEDURE Move_Task(
626: p_api_version IN NUMBER := 1.0
627: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
628: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
629: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
630: ,p_validation_level IN VARCHAR2 := 100
631: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
632: ,p_debug_mode IN VARCHAR2 := 'N'

Line 629: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

625: PROCEDURE Move_Task(
626: p_api_version IN NUMBER := 1.0
627: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
628: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
629: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
630: ,p_validation_level IN VARCHAR2 := 100
631: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
632: ,p_debug_mode IN VARCHAR2 := 'N'
633: ,p_reference_project_id IN NUMBER := FND_API.G_MISS_NUM

Line 633: ,p_reference_project_id IN NUMBER := FND_API.G_MISS_NUM

629: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
630: ,p_validation_level IN VARCHAR2 := 100
631: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
632: ,p_debug_mode IN VARCHAR2 := 'N'
633: ,p_reference_project_id IN NUMBER := FND_API.G_MISS_NUM
634: ,p_reference_project_name IN VARCHAR2 := FND_API.G_MISS_CHAR
635: ,p_reference_task_id IN NUMBER := FND_API.G_MISS_NUM
636: ,p_reference_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
637: ,p_project_id IN NUMBER := FND_API.G_MISS_NUM

Line 634: ,p_reference_project_name IN VARCHAR2 := FND_API.G_MISS_CHAR

630: ,p_validation_level IN VARCHAR2 := 100
631: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
632: ,p_debug_mode IN VARCHAR2 := 'N'
633: ,p_reference_project_id IN NUMBER := FND_API.G_MISS_NUM
634: ,p_reference_project_name IN VARCHAR2 := FND_API.G_MISS_CHAR
635: ,p_reference_task_id IN NUMBER := FND_API.G_MISS_NUM
636: ,p_reference_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
637: ,p_project_id IN NUMBER := FND_API.G_MISS_NUM
638: ,p_project_name IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 635: ,p_reference_task_id IN NUMBER := FND_API.G_MISS_NUM

631: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
632: ,p_debug_mode IN VARCHAR2 := 'N'
633: ,p_reference_project_id IN NUMBER := FND_API.G_MISS_NUM
634: ,p_reference_project_name IN VARCHAR2 := FND_API.G_MISS_CHAR
635: ,p_reference_task_id IN NUMBER := FND_API.G_MISS_NUM
636: ,p_reference_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
637: ,p_project_id IN NUMBER := FND_API.G_MISS_NUM
638: ,p_project_name IN VARCHAR2 := FND_API.G_MISS_CHAR
639: ,p_task_id IN NUMBER := FND_API.G_MISS_NUM

Line 636: ,p_reference_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR

632: ,p_debug_mode IN VARCHAR2 := 'N'
633: ,p_reference_project_id IN NUMBER := FND_API.G_MISS_NUM
634: ,p_reference_project_name IN VARCHAR2 := FND_API.G_MISS_CHAR
635: ,p_reference_task_id IN NUMBER := FND_API.G_MISS_NUM
636: ,p_reference_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
637: ,p_project_id IN NUMBER := FND_API.G_MISS_NUM
638: ,p_project_name IN VARCHAR2 := FND_API.G_MISS_CHAR
639: ,p_task_id IN NUMBER := FND_API.G_MISS_NUM
640: ,p_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 637: ,p_project_id IN NUMBER := FND_API.G_MISS_NUM

633: ,p_reference_project_id IN NUMBER := FND_API.G_MISS_NUM
634: ,p_reference_project_name IN VARCHAR2 := FND_API.G_MISS_CHAR
635: ,p_reference_task_id IN NUMBER := FND_API.G_MISS_NUM
636: ,p_reference_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
637: ,p_project_id IN NUMBER := FND_API.G_MISS_NUM
638: ,p_project_name IN VARCHAR2 := FND_API.G_MISS_CHAR
639: ,p_task_id IN NUMBER := FND_API.G_MISS_NUM
640: ,p_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
641: ,p_peer_or_sub IN VARCHAR2

Line 638: ,p_project_name IN VARCHAR2 := FND_API.G_MISS_CHAR

634: ,p_reference_project_name IN VARCHAR2 := FND_API.G_MISS_CHAR
635: ,p_reference_task_id IN NUMBER := FND_API.G_MISS_NUM
636: ,p_reference_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
637: ,p_project_id IN NUMBER := FND_API.G_MISS_NUM
638: ,p_project_name IN VARCHAR2 := FND_API.G_MISS_CHAR
639: ,p_task_id IN NUMBER := FND_API.G_MISS_NUM
640: ,p_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
641: ,p_peer_or_sub IN VARCHAR2
642: ,p_record_version_number IN NUMBER

Line 639: ,p_task_id IN NUMBER := FND_API.G_MISS_NUM

635: ,p_reference_task_id IN NUMBER := FND_API.G_MISS_NUM
636: ,p_reference_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
637: ,p_project_id IN NUMBER := FND_API.G_MISS_NUM
638: ,p_project_name IN VARCHAR2 := FND_API.G_MISS_CHAR
639: ,p_task_id IN NUMBER := FND_API.G_MISS_NUM
640: ,p_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
641: ,p_peer_or_sub IN VARCHAR2
642: ,p_record_version_number IN NUMBER
643: ,p_wbs_record_version_number IN NUMBER

Line 640: ,p_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR

636: ,p_reference_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
637: ,p_project_id IN NUMBER := FND_API.G_MISS_NUM
638: ,p_project_name IN VARCHAR2 := FND_API.G_MISS_CHAR
639: ,p_task_id IN NUMBER := FND_API.G_MISS_NUM
640: ,p_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
641: ,p_peer_or_sub IN VARCHAR2
642: ,p_record_version_number IN NUMBER
643: ,p_wbs_record_version_number IN NUMBER
644: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 655: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

651: -- Pre-reqs : None
652: -- Return Value : N/A
653: -- Prameters
654: -- p_api_version IN NUMBER := 1.0
655: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
656: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
657: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
658: -- p_validation_level IN VARCHAR2 := 100
659: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'

Line 656: -- p_commit IN VARCHAR2 := FND_API.G_FALSE

652: -- Return Value : N/A
653: -- Prameters
654: -- p_api_version IN NUMBER := 1.0
655: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
656: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
657: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
658: -- p_validation_level IN VARCHAR2 := 100
659: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
660: -- p_debug_mode IN VARCHAR2 := 'N'

Line 657: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE

653: -- Prameters
654: -- p_api_version IN NUMBER := 1.0
655: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
656: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
657: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
658: -- p_validation_level IN VARCHAR2 := 100
659: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
660: -- p_debug_mode IN VARCHAR2 := 'N'
661: -- p_reference_project_id IN NUMBER := FND_API.G_MISS_NUM

Line 661: -- p_reference_project_id IN NUMBER := FND_API.G_MISS_NUM

657: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
658: -- p_validation_level IN VARCHAR2 := 100
659: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
660: -- p_debug_mode IN VARCHAR2 := 'N'
661: -- p_reference_project_id IN NUMBER := FND_API.G_MISS_NUM
662: -- p_reference_project_name IN VARCHAR2 := FND_API.G_MISS_CHAR
663: -- p_reference_task_id IN NUMBER := FND_API.G_MISS_NUM
664: -- p_reference_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
665: -- p_project_id IN NUMBER := FND_API.G_MISS_NUM

Line 662: -- p_reference_project_name IN VARCHAR2 := FND_API.G_MISS_CHAR

658: -- p_validation_level IN VARCHAR2 := 100
659: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
660: -- p_debug_mode IN VARCHAR2 := 'N'
661: -- p_reference_project_id IN NUMBER := FND_API.G_MISS_NUM
662: -- p_reference_project_name IN VARCHAR2 := FND_API.G_MISS_CHAR
663: -- p_reference_task_id IN NUMBER := FND_API.G_MISS_NUM
664: -- p_reference_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
665: -- p_project_id IN NUMBER := FND_API.G_MISS_NUM
666: -- p_project_name IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 663: -- p_reference_task_id IN NUMBER := FND_API.G_MISS_NUM

659: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
660: -- p_debug_mode IN VARCHAR2 := 'N'
661: -- p_reference_project_id IN NUMBER := FND_API.G_MISS_NUM
662: -- p_reference_project_name IN VARCHAR2 := FND_API.G_MISS_CHAR
663: -- p_reference_task_id IN NUMBER := FND_API.G_MISS_NUM
664: -- p_reference_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
665: -- p_project_id IN NUMBER := FND_API.G_MISS_NUM
666: -- p_project_name IN VARCHAR2 := FND_API.G_MISS_CHAR
667: -- p_task_id IN NUMBER := FND_API.G_MISS_NUM

Line 664: -- p_reference_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR

660: -- p_debug_mode IN VARCHAR2 := 'N'
661: -- p_reference_project_id IN NUMBER := FND_API.G_MISS_NUM
662: -- p_reference_project_name IN VARCHAR2 := FND_API.G_MISS_CHAR
663: -- p_reference_task_id IN NUMBER := FND_API.G_MISS_NUM
664: -- p_reference_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
665: -- p_project_id IN NUMBER := FND_API.G_MISS_NUM
666: -- p_project_name IN VARCHAR2 := FND_API.G_MISS_CHAR
667: -- p_task_id IN NUMBER := FND_API.G_MISS_NUM
668: -- p_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 665: -- p_project_id IN NUMBER := FND_API.G_MISS_NUM

661: -- p_reference_project_id IN NUMBER := FND_API.G_MISS_NUM
662: -- p_reference_project_name IN VARCHAR2 := FND_API.G_MISS_CHAR
663: -- p_reference_task_id IN NUMBER := FND_API.G_MISS_NUM
664: -- p_reference_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
665: -- p_project_id IN NUMBER := FND_API.G_MISS_NUM
666: -- p_project_name IN VARCHAR2 := FND_API.G_MISS_CHAR
667: -- p_task_id IN NUMBER := FND_API.G_MISS_NUM
668: -- p_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
669: -- p_peer_or_sub IN VARCHAR2 REQUIRED

Line 666: -- p_project_name IN VARCHAR2 := FND_API.G_MISS_CHAR

662: -- p_reference_project_name IN VARCHAR2 := FND_API.G_MISS_CHAR
663: -- p_reference_task_id IN NUMBER := FND_API.G_MISS_NUM
664: -- p_reference_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
665: -- p_project_id IN NUMBER := FND_API.G_MISS_NUM
666: -- p_project_name IN VARCHAR2 := FND_API.G_MISS_CHAR
667: -- p_task_id IN NUMBER := FND_API.G_MISS_NUM
668: -- p_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
669: -- p_peer_or_sub IN VARCHAR2 REQUIRED
670: -- p_copy_node_flag IN VARCHAR2 REQUIRED

Line 667: -- p_task_id IN NUMBER := FND_API.G_MISS_NUM

663: -- p_reference_task_id IN NUMBER := FND_API.G_MISS_NUM
664: -- p_reference_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
665: -- p_project_id IN NUMBER := FND_API.G_MISS_NUM
666: -- p_project_name IN VARCHAR2 := FND_API.G_MISS_CHAR
667: -- p_task_id IN NUMBER := FND_API.G_MISS_NUM
668: -- p_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
669: -- p_peer_or_sub IN VARCHAR2 REQUIRED
670: -- p_copy_node_flag IN VARCHAR2 REQUIRED
671: -- p_task_prefix IN VARCHAR2 REQUIRED

Line 668: -- p_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR

664: -- p_reference_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
665: -- p_project_id IN NUMBER := FND_API.G_MISS_NUM
666: -- p_project_name IN VARCHAR2 := FND_API.G_MISS_CHAR
667: -- p_task_id IN NUMBER := FND_API.G_MISS_NUM
668: -- p_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
669: -- p_peer_or_sub IN VARCHAR2 REQUIRED
670: -- p_copy_node_flag IN VARCHAR2 REQUIRED
671: -- p_task_prefix IN VARCHAR2 REQUIRED
672: -- p_wbs_record_version_number IN NUMBER

Line 686: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

682: --
683:
684: PROCEDURE Copy_Task(
685: p_api_version IN NUMBER := 1.0
686: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
687: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
688: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
689: ,p_validation_level IN VARCHAR2 := 100
690: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'

Line 687: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

683:
684: PROCEDURE Copy_Task(
685: p_api_version IN NUMBER := 1.0
686: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
687: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
688: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
689: ,p_validation_level IN VARCHAR2 := 100
690: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
691: ,p_debug_mode IN VARCHAR2 := 'N'

Line 688: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

684: PROCEDURE Copy_Task(
685: p_api_version IN NUMBER := 1.0
686: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
687: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
688: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
689: ,p_validation_level IN VARCHAR2 := 100
690: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
691: ,p_debug_mode IN VARCHAR2 := 'N'
692: ,p_reference_project_id IN NUMBER := FND_API.G_MISS_NUM

Line 692: ,p_reference_project_id IN NUMBER := FND_API.G_MISS_NUM

688: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
689: ,p_validation_level IN VARCHAR2 := 100
690: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
691: ,p_debug_mode IN VARCHAR2 := 'N'
692: ,p_reference_project_id IN NUMBER := FND_API.G_MISS_NUM
693: ,p_reference_project_name IN VARCHAR2 := FND_API.G_MISS_CHAR
694: ,p_reference_task_id IN NUMBER := FND_API.G_MISS_NUM
695: ,p_reference_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
696: ,p_project_id IN NUMBER := FND_API.G_MISS_NUM

Line 693: ,p_reference_project_name IN VARCHAR2 := FND_API.G_MISS_CHAR

689: ,p_validation_level IN VARCHAR2 := 100
690: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
691: ,p_debug_mode IN VARCHAR2 := 'N'
692: ,p_reference_project_id IN NUMBER := FND_API.G_MISS_NUM
693: ,p_reference_project_name IN VARCHAR2 := FND_API.G_MISS_CHAR
694: ,p_reference_task_id IN NUMBER := FND_API.G_MISS_NUM
695: ,p_reference_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
696: ,p_project_id IN NUMBER := FND_API.G_MISS_NUM
697: ,p_project_name IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 694: ,p_reference_task_id IN NUMBER := FND_API.G_MISS_NUM

690: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
691: ,p_debug_mode IN VARCHAR2 := 'N'
692: ,p_reference_project_id IN NUMBER := FND_API.G_MISS_NUM
693: ,p_reference_project_name IN VARCHAR2 := FND_API.G_MISS_CHAR
694: ,p_reference_task_id IN NUMBER := FND_API.G_MISS_NUM
695: ,p_reference_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
696: ,p_project_id IN NUMBER := FND_API.G_MISS_NUM
697: ,p_project_name IN VARCHAR2 := FND_API.G_MISS_CHAR
698: ,p_task_id IN NUMBER := FND_API.G_MISS_NUM

Line 695: ,p_reference_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR

691: ,p_debug_mode IN VARCHAR2 := 'N'
692: ,p_reference_project_id IN NUMBER := FND_API.G_MISS_NUM
693: ,p_reference_project_name IN VARCHAR2 := FND_API.G_MISS_CHAR
694: ,p_reference_task_id IN NUMBER := FND_API.G_MISS_NUM
695: ,p_reference_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
696: ,p_project_id IN NUMBER := FND_API.G_MISS_NUM
697: ,p_project_name IN VARCHAR2 := FND_API.G_MISS_CHAR
698: ,p_task_id IN NUMBER := FND_API.G_MISS_NUM
699: ,p_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 696: ,p_project_id IN NUMBER := FND_API.G_MISS_NUM

692: ,p_reference_project_id IN NUMBER := FND_API.G_MISS_NUM
693: ,p_reference_project_name IN VARCHAR2 := FND_API.G_MISS_CHAR
694: ,p_reference_task_id IN NUMBER := FND_API.G_MISS_NUM
695: ,p_reference_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
696: ,p_project_id IN NUMBER := FND_API.G_MISS_NUM
697: ,p_project_name IN VARCHAR2 := FND_API.G_MISS_CHAR
698: ,p_task_id IN NUMBER := FND_API.G_MISS_NUM
699: ,p_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
700: ,p_peer_or_sub IN VARCHAR2

Line 697: ,p_project_name IN VARCHAR2 := FND_API.G_MISS_CHAR

693: ,p_reference_project_name IN VARCHAR2 := FND_API.G_MISS_CHAR
694: ,p_reference_task_id IN NUMBER := FND_API.G_MISS_NUM
695: ,p_reference_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
696: ,p_project_id IN NUMBER := FND_API.G_MISS_NUM
697: ,p_project_name IN VARCHAR2 := FND_API.G_MISS_CHAR
698: ,p_task_id IN NUMBER := FND_API.G_MISS_NUM
699: ,p_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
700: ,p_peer_or_sub IN VARCHAR2
701: ,p_copy_node_flag IN VARCHAR2

Line 698: ,p_task_id IN NUMBER := FND_API.G_MISS_NUM

694: ,p_reference_task_id IN NUMBER := FND_API.G_MISS_NUM
695: ,p_reference_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
696: ,p_project_id IN NUMBER := FND_API.G_MISS_NUM
697: ,p_project_name IN VARCHAR2 := FND_API.G_MISS_CHAR
698: ,p_task_id IN NUMBER := FND_API.G_MISS_NUM
699: ,p_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
700: ,p_peer_or_sub IN VARCHAR2
701: ,p_copy_node_flag IN VARCHAR2
702: ,p_task_prefix IN VARCHAR2

Line 699: ,p_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR

695: ,p_reference_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
696: ,p_project_id IN NUMBER := FND_API.G_MISS_NUM
697: ,p_project_name IN VARCHAR2 := FND_API.G_MISS_CHAR
698: ,p_task_id IN NUMBER := FND_API.G_MISS_NUM
699: ,p_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
700: ,p_peer_or_sub IN VARCHAR2
701: ,p_copy_node_flag IN VARCHAR2
702: ,p_task_prefix IN VARCHAR2
703: ,p_wbs_record_version_number IN NUMBER

Line 714: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

710:
711: PROCEDURE SET_FINANCIAL_FLAG_WRAPPER
712: (
713: p_api_version IN NUMBER := 1.0
714: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
715: , p_commit IN VARCHAR2 := FND_API.G_FALSE
716: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE
717: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
718: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'

Line 715: , p_commit IN VARCHAR2 := FND_API.G_FALSE

711: PROCEDURE SET_FINANCIAL_FLAG_WRAPPER
712: (
713: p_api_version IN NUMBER := 1.0
714: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
715: , p_commit IN VARCHAR2 := FND_API.G_FALSE
716: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE
717: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
718: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
719: , p_debug_mode IN VARCHAR2 := 'N'

Line 716: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE

712: (
713: p_api_version IN NUMBER := 1.0
714: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
715: , p_commit IN VARCHAR2 := FND_API.G_FALSE
716: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE
717: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
718: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
719: , p_debug_mode IN VARCHAR2 := 'N'
720: , p_task_version_id IN NUMBER

Line 717: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

713: p_api_version IN NUMBER := 1.0
714: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
715: , p_commit IN VARCHAR2 := FND_API.G_FALSE
716: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE
717: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
718: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
719: , p_debug_mode IN VARCHAR2 := 'N'
720: , p_task_version_id IN NUMBER
721: , p_checked_flag IN VARCHAR2

Line 767: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

763:
764: PROCEDURE POPULATE_TEMP_TABLE
765: (
766: p_api_version IN NUMBER := 1.0
767: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
768: , p_commit IN VARCHAR2 := FND_API.G_FALSE
769: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE
770: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
771: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'

Line 768: , p_commit IN VARCHAR2 := FND_API.G_FALSE

764: PROCEDURE POPULATE_TEMP_TABLE
765: (
766: p_api_version IN NUMBER := 1.0
767: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
768: , p_commit IN VARCHAR2 := FND_API.G_FALSE
769: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE
770: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
771: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
772: , p_debug_mode IN VARCHAR2 := 'N'

Line 769: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE

765: (
766: p_api_version IN NUMBER := 1.0
767: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
768: , p_commit IN VARCHAR2 := FND_API.G_FALSE
769: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE
770: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
771: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
772: , p_debug_mode IN VARCHAR2 := 'N'
773: , p_task_version_id_array IN SYSTEM.PA_NUM_TBL_TYPE := NULL

Line 770: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

766: p_api_version IN NUMBER := 1.0
767: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
768: , p_commit IN VARCHAR2 := FND_API.G_FALSE
769: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE
770: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
771: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
772: , p_debug_mode IN VARCHAR2 := 'N'
773: , p_task_version_id_array IN SYSTEM.PA_NUM_TBL_TYPE := NULL
774: , p_structure_version_id IN NUMBER

Line 783: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

779: );
780: PROCEDURE SYNC_UP_WP_TASKS_WITH_FIN
781: (
782: p_api_version IN NUMBER := 1.0
783: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
784: , p_commit IN VARCHAR2 := FND_API.G_FALSE
785: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE
786: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
787: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'

Line 784: , p_commit IN VARCHAR2 := FND_API.G_FALSE

780: PROCEDURE SYNC_UP_WP_TASKS_WITH_FIN
781: (
782: p_api_version IN NUMBER := 1.0
783: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
784: , p_commit IN VARCHAR2 := FND_API.G_FALSE
785: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE
786: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
787: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
788: , p_debug_mode IN VARCHAR2 := 'N'

Line 785: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE

781: (
782: p_api_version IN NUMBER := 1.0
783: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
784: , p_commit IN VARCHAR2 := FND_API.G_FALSE
785: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE
786: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
787: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
788: , p_debug_mode IN VARCHAR2 := 'N'
789: , p_patask_record_version_number IN NUMBER := FND_API.G_MISS_NUM

Line 786: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

782: p_api_version IN NUMBER := 1.0
783: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
784: , p_commit IN VARCHAR2 := FND_API.G_FALSE
785: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE
786: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
787: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
788: , p_debug_mode IN VARCHAR2 := 'N'
789: , p_patask_record_version_number IN NUMBER := FND_API.G_MISS_NUM
790: , p_parent_task_version_id IN NUMBER := FND_API.G_MISS_NUM

Line 789: , p_patask_record_version_number IN NUMBER := FND_API.G_MISS_NUM

785: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE
786: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
787: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
788: , p_debug_mode IN VARCHAR2 := 'N'
789: , p_patask_record_version_number IN NUMBER := FND_API.G_MISS_NUM
790: , p_parent_task_version_id IN NUMBER := FND_API.G_MISS_NUM
791: , p_project_id IN NUMBER
792: , p_syncup_all_tasks IN VARCHAR2 := 'N'
793: , p_task_version_id IN NUMBER := FND_API.G_MISS_NUM

Line 790: , p_parent_task_version_id IN NUMBER := FND_API.G_MISS_NUM

786: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
787: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
788: , p_debug_mode IN VARCHAR2 := 'N'
789: , p_patask_record_version_number IN NUMBER := FND_API.G_MISS_NUM
790: , p_parent_task_version_id IN NUMBER := FND_API.G_MISS_NUM
791: , p_project_id IN NUMBER
792: , p_syncup_all_tasks IN VARCHAR2 := 'N'
793: , p_task_version_id IN NUMBER := FND_API.G_MISS_NUM
794: , p_structure_version_id IN NUMBER := FND_API.G_MISS_NUM

Line 793: , p_task_version_id IN NUMBER := FND_API.G_MISS_NUM

789: , p_patask_record_version_number IN NUMBER := FND_API.G_MISS_NUM
790: , p_parent_task_version_id IN NUMBER := FND_API.G_MISS_NUM
791: , p_project_id IN NUMBER
792: , p_syncup_all_tasks IN VARCHAR2 := 'N'
793: , p_task_version_id IN NUMBER := FND_API.G_MISS_NUM
794: , p_structure_version_id IN NUMBER := FND_API.G_MISS_NUM
795: , p_check_for_transactions IN VARCHAR2 := 'N'
796: , p_checked_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
797: , p_mode IN VARCHAR2 := 'SINGLE'

Line 794: , p_structure_version_id IN NUMBER := FND_API.G_MISS_NUM

790: , p_parent_task_version_id IN NUMBER := FND_API.G_MISS_NUM
791: , p_project_id IN NUMBER
792: , p_syncup_all_tasks IN VARCHAR2 := 'N'
793: , p_task_version_id IN NUMBER := FND_API.G_MISS_NUM
794: , p_structure_version_id IN NUMBER := FND_API.G_MISS_NUM
795: , p_check_for_transactions IN VARCHAR2 := 'N'
796: , p_checked_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
797: , p_mode IN VARCHAR2 := 'SINGLE'
798: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 796: , p_checked_flag IN VARCHAR2 := FND_API.G_MISS_CHAR

792: , p_syncup_all_tasks IN VARCHAR2 := 'N'
793: , p_task_version_id IN NUMBER := FND_API.G_MISS_NUM
794: , p_structure_version_id IN NUMBER := FND_API.G_MISS_NUM
795: , p_check_for_transactions IN VARCHAR2 := 'N'
796: , p_checked_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
797: , p_mode IN VARCHAR2 := 'SINGLE'
798: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
799: , x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
800: , x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895