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_RELATIONSHIP_PVT dependencies on PA_INTERFACE_UTILS_PUB

Line 16: -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

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_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
17: -- p_project_id_from IN NUMBER
18: -- p_structure_id_from IN NUMBER
19: -- p_structure_version_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
20: -- p_task_version_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 19: -- p_structure_version_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

15: -- p_debug_mode IN VARCHAR2 := 'N'
16: -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
17: -- p_project_id_from IN NUMBER
18: -- p_structure_id_from IN NUMBER
19: -- p_structure_version_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
20: -- p_task_version_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
21: -- p_project_id_to IN NUMBER
22: -- p_structure_id_to IN NUMBER
23: -- p_structure_version_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 20: -- p_task_version_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

16: -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
17: -- p_project_id_from IN NUMBER
18: -- p_structure_id_from IN NUMBER
19: -- p_structure_version_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
20: -- p_task_version_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
21: -- p_project_id_to IN NUMBER
22: -- p_structure_id_to IN NUMBER
23: -- p_structure_version_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
24: -- p_task_version_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 23: -- p_structure_version_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

19: -- p_structure_version_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
20: -- p_task_version_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
21: -- p_project_id_to IN NUMBER
22: -- p_structure_id_to IN NUMBER
23: -- p_structure_version_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
24: -- p_task_version_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
25: -- p_structure_type IN VARCHAR2
26: -- p_initiating_element IN VARCHAR2
27: -- p_link_to_latest_structure_ver IN VARCHAR2 := 'N'

Line 24: -- p_task_version_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

20: -- p_task_version_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
21: -- p_project_id_to IN NUMBER
22: -- p_structure_id_to IN NUMBER
23: -- p_structure_version_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
24: -- p_task_version_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
25: -- p_structure_type IN VARCHAR2
26: -- p_initiating_element IN VARCHAR2
27: -- p_link_to_latest_structure_ver IN VARCHAR2 := 'N'
28: -- p_relationship_type IN VARCHAR2

Line 29: -- p_relationship_subtype IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

25: -- p_structure_type IN VARCHAR2
26: -- p_initiating_element IN VARCHAR2
27: -- p_link_to_latest_structure_ver IN VARCHAR2 := 'N'
28: -- p_relationship_type IN VARCHAR2
29: -- p_relationship_subtype IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
30: -- p_lag_day IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
31: -- p_priority IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
32: -- x_object_relationship_id OUT NUMBER
33: -- x_return_status OUT VARCHAR2

Line 30: -- p_lag_day IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

26: -- p_initiating_element IN VARCHAR2
27: -- p_link_to_latest_structure_ver IN VARCHAR2 := 'N'
28: -- p_relationship_type IN VARCHAR2
29: -- p_relationship_subtype IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
30: -- p_lag_day IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
31: -- p_priority IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
32: -- x_object_relationship_id OUT NUMBER
33: -- x_return_status OUT VARCHAR2
34: -- x_msg_count OUT NUMBER

Line 31: -- p_priority IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

27: -- p_link_to_latest_structure_ver IN VARCHAR2 := 'N'
28: -- p_relationship_type IN VARCHAR2
29: -- p_relationship_subtype IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
30: -- p_lag_day IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
31: -- p_priority IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
32: -- x_object_relationship_id OUT NUMBER
33: -- x_return_status OUT VARCHAR2
34: -- x_msg_count OUT NUMBER
35: -- x_msg_data OUT VARCHAR2

Line 53: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

49: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
50: ,p_validation_level IN VARCHAR2 := 100
51: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
52: ,p_debug_mode IN VARCHAR2 := 'N'
53: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
54: ,p_project_id_from IN NUMBER
55: ,p_structure_id_from IN NUMBER
56: ,p_structure_version_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
57: ,p_task_version_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 56: ,p_structure_version_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

52: ,p_debug_mode IN VARCHAR2 := 'N'
53: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
54: ,p_project_id_from IN NUMBER
55: ,p_structure_id_from IN NUMBER
56: ,p_structure_version_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
57: ,p_task_version_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
58: ,p_project_id_to IN NUMBER
59: ,p_structure_id_to IN NUMBER
60: ,p_structure_version_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 57: ,p_task_version_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

53: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
54: ,p_project_id_from IN NUMBER
55: ,p_structure_id_from IN NUMBER
56: ,p_structure_version_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
57: ,p_task_version_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
58: ,p_project_id_to IN NUMBER
59: ,p_structure_id_to IN NUMBER
60: ,p_structure_version_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
61: ,p_task_version_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 60: ,p_structure_version_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

56: ,p_structure_version_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
57: ,p_task_version_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
58: ,p_project_id_to IN NUMBER
59: ,p_structure_id_to IN NUMBER
60: ,p_structure_version_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
61: ,p_task_version_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
62: ,p_structure_type IN VARCHAR2
63: ,p_initiating_element IN VARCHAR2
64: ,p_link_to_latest_structure_ver IN VARCHAR2 := 'N'

Line 61: ,p_task_version_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

57: ,p_task_version_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
58: ,p_project_id_to IN NUMBER
59: ,p_structure_id_to IN NUMBER
60: ,p_structure_version_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
61: ,p_task_version_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
62: ,p_structure_type IN VARCHAR2
63: ,p_initiating_element IN VARCHAR2
64: ,p_link_to_latest_structure_ver IN VARCHAR2 := 'N'
65: ,p_relationship_type IN VARCHAR2

Line 66: ,p_relationship_subtype IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

62: ,p_structure_type IN VARCHAR2
63: ,p_initiating_element IN VARCHAR2
64: ,p_link_to_latest_structure_ver IN VARCHAR2 := 'N'
65: ,p_relationship_type IN VARCHAR2
66: ,p_relationship_subtype IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
67: ,p_lag_day IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
68: ,p_priority IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
69: ,p_weighting_percentage IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
70: ,x_object_relationship_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 67: ,p_lag_day IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

63: ,p_initiating_element IN VARCHAR2
64: ,p_link_to_latest_structure_ver IN VARCHAR2 := 'N'
65: ,p_relationship_type IN VARCHAR2
66: ,p_relationship_subtype IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
67: ,p_lag_day IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
68: ,p_priority IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
69: ,p_weighting_percentage IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
70: ,x_object_relationship_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
71: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 68: ,p_priority IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

64: ,p_link_to_latest_structure_ver IN VARCHAR2 := 'N'
65: ,p_relationship_type IN VARCHAR2
66: ,p_relationship_subtype IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
67: ,p_lag_day IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
68: ,p_priority IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
69: ,p_weighting_percentage IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
70: ,x_object_relationship_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
71: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
72: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 69: ,p_weighting_percentage IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

65: ,p_relationship_type IN VARCHAR2
66: ,p_relationship_subtype IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
67: ,p_lag_day IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
68: ,p_priority IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
69: ,p_weighting_percentage IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
70: ,x_object_relationship_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
71: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
72: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
73: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 175: IF p_priority = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

171: pa_debug.debug('Performing validations');
172: END IF;
173:
174: --Bug 2955589. Handle miss char for priority.
175: IF p_priority = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
176: l_priority := NULL;
177: ELSE
178: l_priority := p_priority;
179: END IF;

Line 182: IF p_lag_day = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

178: l_priority := p_priority;
179: END IF;
180:
181: --Bug 2955589. Handle miss num for lag_day.
182: IF p_lag_day = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
183: l_lag_day := NULL;
184: ELSE
185: l_lag_day := p_lag_day;
186: END IF;

Line 393: pa_interface_utils_pub.get_messages

389: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
390:
391: x_msg_count := FND_MSG_PUB.count_msg;
392: if x_msg_count = 1 then
393: pa_interface_utils_pub.get_messages
394: (p_encoded => FND_API.G_TRUE,
395: p_msg_index => 1,
396: p_msg_count => l_msg_count,
397: p_msg_data => l_msg_data,

Line 431: pa_interface_utils_pub.get_messages

427: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
428:
429: x_msg_count := FND_MSG_PUB.count_msg;
430: if x_msg_count = 1 then
431: pa_interface_utils_pub.get_messages
432: (p_encoded => FND_API.G_TRUE,
433: p_msg_index => 1,
434: p_msg_count => l_msg_count,
435: p_msg_data => l_msg_data,

Line 461: pa_interface_utils_pub.get_messages

457:
458: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
459: x_msg_count := FND_MSG_PUB.count_msg;
460: if x_msg_count = 1 then
461: pa_interface_utils_pub.get_messages
462: (p_encoded => FND_API.G_TRUE,
463: p_msg_index => 1,
464: p_msg_count => l_msg_count,
465: p_msg_data => l_msg_data,

Line 543: IF (p_weighting_percentage = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM or p_weighting_percentage IS NULL) THEN

539: l_id_to := p_task_version_id_to;
540: l_type_to := 'PA_TASKS';
541: END IF;
542:
543: IF (p_weighting_percentage = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM or p_weighting_percentage IS NULL) THEN
544: l_weighting_percentage := NULL;
545: ELSE
546: l_weighting_percentage := p_weighting_percentage;
547: END IF;

Line 678: -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

674: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
675: -- p_validation_level IN VARCHAR2 := 100
676: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
677: -- p_debug_mode IN VARCHAR2 := 'N'
678: -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
679: -- p_object_relationship_id IN NUMBER
680: -- p_project_id_from IN NUMBER
681: -- p_structure_id_from IN NUMBER
682: -- p_structure_version_id_from IN NUMBER

Line 683: -- p_task_version_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

679: -- p_object_relationship_id IN NUMBER
680: -- p_project_id_from IN NUMBER
681: -- p_structure_id_from IN NUMBER
682: -- p_structure_version_id_from IN NUMBER
683: -- p_task_version_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
684: -- p_project_id_to IN NUMBER
685: -- p_structure_id_to IN NUMBER
686: -- p_structure_version_id_to IN NUMBER
687: -- p_task_version_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 687: -- p_task_version_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

683: -- p_task_version_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
684: -- p_project_id_to IN NUMBER
685: -- p_structure_id_to IN NUMBER
686: -- p_structure_version_id_to IN NUMBER
687: -- p_task_version_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
688: -- p_relationship_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
689: -- p_relationship_subtype IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
690: -- p_lag_day IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
691: -- p_priority IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 688: -- p_relationship_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

684: -- p_project_id_to IN NUMBER
685: -- p_structure_id_to IN NUMBER
686: -- p_structure_version_id_to IN NUMBER
687: -- p_task_version_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
688: -- p_relationship_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
689: -- p_relationship_subtype IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
690: -- p_lag_day IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
691: -- p_priority IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
692: -- p_record_version_number IN NUMBER

Line 689: -- p_relationship_subtype IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

685: -- p_structure_id_to IN NUMBER
686: -- p_structure_version_id_to IN NUMBER
687: -- p_task_version_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
688: -- p_relationship_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
689: -- p_relationship_subtype IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
690: -- p_lag_day IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
691: -- p_priority IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
692: -- p_record_version_number IN NUMBER
693: -- x_return_status OUT VARCHAR2

Line 690: -- p_lag_day IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

686: -- p_structure_version_id_to IN NUMBER
687: -- p_task_version_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
688: -- p_relationship_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
689: -- p_relationship_subtype IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
690: -- p_lag_day IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
691: -- p_priority IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
692: -- p_record_version_number IN NUMBER
693: -- x_return_status OUT VARCHAR2
694: -- x_msg_count OUT NUMBER

Line 691: -- p_priority IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

687: -- p_task_version_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
688: -- p_relationship_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
689: -- p_relationship_subtype IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
690: -- p_lag_day IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
691: -- p_priority IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
692: -- p_record_version_number IN NUMBER
693: -- x_return_status OUT VARCHAR2
694: -- x_msg_count OUT NUMBER
695: -- x_msg_data OUT VARCHAR2

Line 713: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

709: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
710: ,p_validation_level IN VARCHAR2 := 100
711: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
712: ,p_debug_mode IN VARCHAR2 := 'N'
713: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
714: ,p_object_relationship_id IN NUMBER
715: ,p_project_id_from IN NUMBER
716: ,p_structure_id_from IN NUMBER
717: ,p_structure_version_id_from IN NUMBER

Line 718: ,p_task_version_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

714: ,p_object_relationship_id IN NUMBER
715: ,p_project_id_from IN NUMBER
716: ,p_structure_id_from IN NUMBER
717: ,p_structure_version_id_from IN NUMBER
718: ,p_task_version_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
719: ,p_project_id_to IN NUMBER
720: ,p_structure_id_to IN NUMBER
721: ,p_structure_version_id_to IN NUMBER
722: ,p_task_version_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 722: ,p_task_version_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

718: ,p_task_version_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
719: ,p_project_id_to IN NUMBER
720: ,p_structure_id_to IN NUMBER
721: ,p_structure_version_id_to IN NUMBER
722: ,p_task_version_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
723: ,p_relationship_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
724: ,p_relationship_subtype IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
725: ,p_lag_day IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
726: ,p_priority IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 723: ,p_relationship_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

719: ,p_project_id_to IN NUMBER
720: ,p_structure_id_to IN NUMBER
721: ,p_structure_version_id_to IN NUMBER
722: ,p_task_version_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
723: ,p_relationship_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
724: ,p_relationship_subtype IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
725: ,p_lag_day IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
726: ,p_priority IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
727: ,p_weighting_percentage IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 724: ,p_relationship_subtype IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

720: ,p_structure_id_to IN NUMBER
721: ,p_structure_version_id_to IN NUMBER
722: ,p_task_version_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
723: ,p_relationship_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
724: ,p_relationship_subtype IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
725: ,p_lag_day IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
726: ,p_priority IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
727: ,p_weighting_percentage IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
728: ,p_record_version_number IN NUMBER

Line 725: ,p_lag_day IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

721: ,p_structure_version_id_to IN NUMBER
722: ,p_task_version_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
723: ,p_relationship_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
724: ,p_relationship_subtype IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
725: ,p_lag_day IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
726: ,p_priority IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
727: ,p_weighting_percentage IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
728: ,p_record_version_number IN NUMBER
729: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 726: ,p_priority IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

722: ,p_task_version_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
723: ,p_relationship_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
724: ,p_relationship_subtype IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
725: ,p_lag_day IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
726: ,p_priority IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
727: ,p_weighting_percentage IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
728: ,p_record_version_number IN NUMBER
729: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
730: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 727: ,p_weighting_percentage IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

723: ,p_relationship_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
724: ,p_relationship_subtype IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
725: ,p_lag_day IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
726: ,p_priority IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
727: ,p_weighting_percentage IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
728: ,p_record_version_number IN NUMBER
729: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
730: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
731: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 770: IF (p_weighting_percentage = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM or p_weighting_percentage IS NULL) THEN

766: l_id_to := p_task_version_id_to;
767: l_type_to := 'PA_TASKS';
768: END IF;
769:
770: IF (p_weighting_percentage = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM or p_weighting_percentage IS NULL) THEN
771: l_weighting_percentage := NULL;
772: ELSE
773: l_weighting_percentage := p_weighting_percentage;
774: END IF;

Line 874: -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

870: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
871: -- p_validation_level IN VARCHAR2 := 100
872: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
873: -- p_debug_mode IN VARCHAR2 := 'N'
874: -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
875: -- p_object_relationship_id IN NUMBER
876: -- p_record_version_number IN NUMBER
877: -- x_return_status OUT VARCHAR2
878: -- x_msg_count OUT NUMBER

Line 897: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

893: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
894: ,p_validation_level IN VARCHAR2 := 100
895: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
896: ,p_debug_mode IN VARCHAR2 := 'N'
897: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
898: ,p_object_relationship_id IN NUMBER
899: ,p_record_version_number IN NUMBER
900: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
901: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 981: pa_interface_utils_pub.get_messages

977:
978: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
979: x_msg_count := FND_MSG_PUB.count_msg;
980: IF x_msg_count = 1 then
981: pa_interface_utils_pub.get_messages
982: (p_encoded => FND_API.G_TRUE,
983: p_msg_index => 1,
984: p_msg_count => l_msg_count,
985: p_msg_data => l_msg_data,

Line 1028: -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

1024: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1025: -- p_validation_level IN VARCHAR2 := 100
1026: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
1027: -- p_debug_mode IN VARCHAR2 := 'N'
1028: -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1029: -- p_src_proj_id IN NUMBER := NULL
1030: -- p_src_task_ver_id IN NUMBER := NULL
1031: -- p_dest_proj_id IN NUMBER := NULL
1032: -- P_dest_task_id IN NUMBER := NULL

Line 1056: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

1052: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1053: ,p_validation_level IN VARCHAR2 := 100
1054: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
1055: ,p_debug_mode IN VARCHAR2 := 'N'
1056: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1057: ,p_src_proj_id IN NUMBER := NULL
1058: ,p_src_task_ver_id IN NUMBER := NULL
1059: ,p_dest_proj_id IN NUMBER := NULL
1060: ,p_dest_task_ver_id IN NUMBER := NULL

Line 1236: pa_interface_utils_pub.get_messages

1232:
1233: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1234: x_msg_count := FND_MSG_PUB.count_msg;
1235: IF x_msg_count = 1 then
1236: pa_interface_utils_pub.get_messages
1237: (p_encoded => FND_API.G_TRUE,
1238: p_msg_index => 1,
1239: p_msg_count => l_msg_count,
1240: p_msg_data => l_msg_data,

Line 1280: pa_interface_utils_pub.get_messages

1276:
1277: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1278: x_msg_count := FND_MSG_PUB.count_msg;
1279: IF x_msg_count = 1 then
1280: pa_interface_utils_pub.get_messages
1281: (p_encoded => FND_API.G_TRUE,
1282: p_msg_index => 1,
1283: p_msg_count => l_msg_count,
1284: p_msg_data => l_msg_data,

Line 1309: pa_interface_utils_pub.get_messages

1305:
1306: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1307: x_msg_count := FND_MSG_PUB.count_msg;
1308: IF x_msg_count = 1 then
1309: pa_interface_utils_pub.get_messages
1310: (p_encoded => FND_API.G_TRUE,
1311: p_msg_index => 1,
1312: p_msg_count => l_msg_count,
1313: p_msg_data => l_msg_data,

Line 1385: pa_interface_utils_pub.get_messages

1381:
1382: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1383: x_msg_count := FND_MSG_PUB.count_msg;
1384: IF x_msg_count = 1 then
1385: pa_interface_utils_pub.get_messages
1386: (p_encoded => FND_API.G_TRUE,
1387: p_msg_index => 1,
1388: p_msg_count => l_msg_count,
1389: p_msg_data => l_msg_data,

Line 1448: -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

1444: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1445: -- p_validation_level IN VARCHAR2 := 100
1446: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
1447: -- p_debug_mode IN VARCHAR2 := 'N'
1448: -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1449: -- p_task_version_id IN NUMBER := NULL
1450: -- p_type IN VARCHAR2 := NULL
1451: -- p_lag_days IN NUMBER := NULL
1452: -- p_comments IN VARCHAR2 := NULL

Line 1474: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

1470: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1471: ,p_validation_level IN VARCHAR2 := 100
1472: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
1473: ,p_debug_mode IN VARCHAR2 := 'N'
1474: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1475: ,p_task_version_id IN NUMBER := NULL
1476: ,p_src_task_version_id IN NUMBER := NULL
1477: ,p_type IN VARCHAR2 := NULL
1478: ,p_lag_days IN NUMBER := NULL

Line 1559: pa_interface_utils_pub.get_messages

1555:
1556: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1557: x_msg_count := FND_MSG_PUB.count_msg;
1558: IF x_msg_count = 1 then
1559: pa_interface_utils_pub.get_messages
1560: (p_encoded => FND_API.G_TRUE,
1561: p_msg_index => 1,
1562: p_msg_count => l_msg_count,
1563: p_msg_data => l_msg_data,

Line 1620: -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

1616: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1617: -- p_validation_level IN VARCHAR2 := 100
1618: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
1619: -- p_debug_mode IN VARCHAR2 := 'N'
1620: -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1621: -- p_object_relationship_id IN NUMBER := NULL
1622: -- x_return_status OUT VARCHAR2
1623: -- x_msg_count OUT NUMBER
1624: -- x_msg_data OUT VARCHAR2

Line 1642: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

1638: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1639: ,p_validation_level IN VARCHAR2 := 100
1640: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
1641: ,p_debug_mode IN VARCHAR2 := 'N'
1642: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1643: ,p_object_relationship_id IN NUMBER := NULL
1644: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1645: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1646: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 1740: pa_interface_utils_pub.get_messages

1736:
1737: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1738: x_msg_count := FND_MSG_PUB.count_msg;
1739: IF x_msg_count = 1 then
1740: pa_interface_utils_pub.get_messages
1741: (p_encoded => FND_API.G_TRUE,
1742: p_msg_index => 1,
1743: p_msg_count => l_msg_count,
1744: p_msg_data => l_msg_data,

Line 2308: pa_interface_utils_pub.get_messages

2304:
2305: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2306: x_msg_count := FND_MSG_PUB.count_msg;
2307: IF x_msg_count = 1 then
2308: pa_interface_utils_pub.get_messages
2309: (p_encoded => FND_API.G_TRUE,
2310: p_msg_index => 1,
2311: p_msg_count => x_msg_count,
2312: p_msg_data => x_msg_data,

Line 2352: pa_interface_utils_pub.get_messages

2348:
2349: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2350: x_msg_count := FND_MSG_PUB.count_msg;
2351: IF x_msg_count = 1 then
2352: pa_interface_utils_pub.get_messages
2353: (p_encoded => FND_API.G_TRUE,
2354: p_msg_index => 1,
2355: p_msg_count => x_msg_count,
2356: p_msg_data => x_msg_data,

Line 2458: pa_interface_utils_pub.get_messages

2454:
2455: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2456: x_msg_count := FND_MSG_PUB.count_msg;
2457: IF x_msg_count = 1 then
2458: pa_interface_utils_pub.get_messages
2459: (p_encoded => FND_API.G_TRUE,
2460: p_msg_index => 1,
2461: p_msg_count => x_msg_count,
2462: p_msg_data => x_msg_data,

Line 2550: pa_interface_utils_pub.get_messages

2546: -- IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2547: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2548: x_msg_count := FND_MSG_PUB.count_msg;
2549: IF x_msg_count = 1 then
2550: pa_interface_utils_pub.get_messages
2551: (p_encoded => FND_API.G_TRUE,
2552: p_msg_index => 1,
2553: p_msg_count => x_msg_count,
2554: p_msg_data => x_msg_data,

Line 2757: pa_interface_utils_pub.get_messages

2753: );
2754: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2755: x_msg_count := FND_MSG_PUB.count_msg;
2756: IF x_msg_count = 1 then
2757: pa_interface_utils_pub.get_messages
2758: (p_encoded => FND_API.G_TRUE,
2759: p_msg_index => 1,
2760: p_msg_count => x_msg_count,
2761: p_msg_data => x_msg_data,

Line 2823: pa_interface_utils_pub.get_messages

2819:
2820: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2821: x_msg_count := FND_MSG_PUB.count_msg;
2822: /* IF x_msg_count = 1 then
2823: pa_interface_utils_pub.get_messages
2824: (p_encoded => FND_API.G_TRUE,
2825: p_msg_index => 1,
2826: p_msg_count => x_msg_count,
2827: p_msg_data => x_msg_data,

Line 2902: pa_interface_utils_pub.get_messages

2898:
2899: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2900: x_msg_count := FND_MSG_PUB.count_msg;
2901: /* IF x_msg_count = 1 then
2902: pa_interface_utils_pub.get_messages
2903: (p_encoded => FND_API.G_TRUE,
2904: p_msg_index => 1,
2905: p_msg_count => x_msg_count,
2906: p_msg_data => x_msg_data,

Line 2953: pa_interface_utils_pub.get_messages

2949:
2950: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2951: x_msg_count := FND_MSG_PUB.count_msg;
2952: IF x_msg_count = 1 Then
2953: pa_interface_utils_pub.get_messages
2954: (p_encoded => FND_API.G_TRUE,
2955: p_msg_index => 1,
2956: p_msg_count => x_msg_count,
2957: p_msg_data => x_msg_data,

Line 2988: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

2984: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
2985: ,p_validation_level IN VARCHAR2 := 100
2986: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
2987: ,p_debug_mode IN VARCHAR2 := 'N'
2988: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2989: ,p_src_proj_id IN NUMBER
2990: ,p_src_struc_wp_or_fin IN VARCHAR2
2991: ,p_src_struc_elem_id IN NUMBER
2992: ,p_src_struc_elem_ver_id IN NUMBER

Line 3000: ,p_comment IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR --Bug No 3668113

2996: ,p_src_task_elem_id IN NUMBER
2997: ,p_src_task_elem_ver_id IN NUMBER
2998: ,p_lnk_task_name_number IN VARCHAR2 --SMukka
2999: ,p_relationship_type IN VARCHAR2
3000: ,p_comment IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR --Bug No 3668113
3001: ,x_lnk_task_elem_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
3002: ,x_lnk_task_elem_ver_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
3003: ,x_object_relationship_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
3004: ,x_pev_schedule_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 3083: pa_interface_utils_pub.get_messages

3079: ,x_msg_data => x_msg_data);
3080: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3081: x_msg_count := FND_MSG_PUB.count_msg;
3082: IF x_msg_count = 1 THEN
3083: pa_interface_utils_pub.get_messages
3084: (p_encoded => FND_API.G_TRUE,
3085: p_msg_index => 1,
3086: p_msg_count => x_msg_count,
3087: p_msg_data => x_msg_data,

Line 3127: pa_interface_utils_pub.get_messages

3123: ,x_msg_data => x_msg_data);
3124: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3125: x_msg_count := FND_MSG_PUB.count_msg;
3126: IF x_msg_count = 1 THEN
3127: pa_interface_utils_pub.get_messages
3128: (p_encoded => FND_API.G_TRUE,
3129: p_msg_index => 1,
3130: p_msg_count => x_msg_count,
3131: p_msg_data => x_msg_data,

Line 3220: pa_interface_utils_pub.get_messages

3216: --
3217: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3218: x_msg_count := FND_MSG_PUB.count_msg;
3219: IF x_msg_count = 1 THEN
3220: pa_interface_utils_pub.get_messages
3221: (p_encoded => FND_API.G_TRUE,
3222: p_msg_index => 1,
3223: p_msg_count => x_msg_count,
3224: p_msg_data => x_msg_data,

Line 3272: pa_interface_utils_pub.get_messages

3268: );
3269: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3270: x_msg_count := FND_MSG_PUB.count_msg;
3271: IF x_msg_count = 1 THEN
3272: pa_interface_utils_pub.get_messages
3273: (p_encoded => FND_API.G_TRUE,
3274: p_msg_index => 1,
3275: p_msg_count => x_msg_count,
3276: p_msg_data => x_msg_data,

Line 3309: pa_interface_utils_pub.get_messages

3305:
3306: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3307: x_msg_count := FND_MSG_PUB.count_msg;
3308: IF x_msg_count = 1 THEN
3309: pa_interface_utils_pub.get_messages
3310: (p_encoded => FND_API.G_TRUE,
3311: p_msg_index => 1,
3312: p_msg_count => x_msg_count,
3313: p_msg_data => x_msg_data,

Line 3433: -- p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

3429: -- p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
3430: -- p_calling_module IN VARCHAR2 :='SELF_SERVICE'
3431: -- p_commit IN VARCHAR2 :=FND_API.G_FALSE
3432: -- p_debug_mode IN VARCHAR2 :='N'
3433: -- p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3434: -- p_src_proj_id IN pa_projects_all.project_id%type
3435: -- p_task_ver_id IN pa_proj_element_versions.element_version_id%type
3436: -- p_dest_proj_id IN pa_projects_all.project_id%type
3437: -- p_dest_proj_name IN pa_projects_all.name%type

Line 3461: p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

3457: p_validation_level IN VARCHAR2 := 100,
3458: p_calling_module IN VARCHAR2 :='SELF_SERVICE',
3459: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
3460: p_debug_mode IN VARCHAR2 :='N',
3461: p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
3462: p_src_proj_id IN pa_projects_all.project_id%type,
3463: p_task_ver_id IN pa_proj_element_versions.element_version_id%type,
3464: p_dest_proj_id IN pa_projects_all.project_id%type,
3465: p_dest_proj_name IN pa_projects_all.name%type,

Line 3904: pa_interface_utils_pub.get_messages

3900: --
3901: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3902: x_msg_count := FND_MSG_PUB.count_msg;
3903: IF x_msg_count = 1 then
3904: pa_interface_utils_pub.get_messages
3905: (p_encoded => FND_API.G_TRUE,
3906: p_msg_index => 1,
3907: p_msg_count => x_msg_count,
3908: p_msg_data => x_msg_data,

Line 3972: pa_interface_utils_pub.get_messages

3968: --
3969: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3970: x_msg_count := FND_MSG_PUB.count_msg;
3971: IF x_msg_count = 1 then
3972: pa_interface_utils_pub.get_messages
3973: (p_encoded => FND_API.G_TRUE,
3974: p_msg_index => 1,
3975: p_msg_count => x_msg_count,
3976: p_msg_data => x_msg_data,

Line 4039: pa_interface_utils_pub.get_messages

4035: --
4036: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4037: x_msg_count := FND_MSG_PUB.count_msg;
4038: IF x_msg_count = 1 then
4039: pa_interface_utils_pub.get_messages
4040: (p_encoded => FND_API.G_TRUE,
4041: p_msg_index => 1,
4042: p_msg_count => x_msg_count,
4043: p_msg_data => x_msg_data,

Line 4107: pa_interface_utils_pub.get_messages

4103: );
4104: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4105: x_msg_count := FND_MSG_PUB.count_msg;
4106: IF x_msg_count = 1 then
4107: pa_interface_utils_pub.get_messages
4108: (p_encoded => FND_API.G_TRUE,
4109: p_msg_index => 1,
4110: p_msg_count => x_msg_count,
4111: p_msg_data => x_msg_data,

Line 4223: pa_interface_utils_pub.get_messages

4219:
4220: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
4221: x_msg_count := FND_MSG_PUB.count_msg;
4222: IF x_msg_count = 1 then
4223: pa_interface_utils_pub.get_messages
4224: (p_encoded => FND_API.G_TRUE,
4225: p_msg_index => 1,
4226: p_msg_count => x_msg_count,
4227: p_msg_data => x_msg_data,

Line 4276: -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

4272: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
4273: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
4274: -- p_validation_level IN VARCHAR2 := 100
4275: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
4276: -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4277: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
4278: -- p_debug_mode IN VARCHAR2 := 'N'
4279: -- p_object_relationship_id IN NUMBER
4280: -- p_record_version_number IN NUMBER

Line 4299: p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

4295: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
4296: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
4297: p_validation_level IN VARCHAR2 := 100,
4298: p_calling_module IN VARCHAR2 := 'SELF_SERVICE',
4299: p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
4300: p_commit IN VARCHAR2 := FND_API.G_FALSE,
4301: p_debug_mode IN VARCHAR2 := 'N',
4302: p_object_relationship_id IN NUMBER,
4303: p_record_version_number IN NUMBER,

Line 4413: -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

4409: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
4410: -- p_validation_level IN VARCHAR2 := 100
4411: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
4412: -- p_debug_mode IN VARCHAR2 := 'N'
4413: -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4414: -- p_object_relationships_id IN NUMBER
4415: -- p_record_version_number IN NUMBER
4416: -- x_return_status OUT VARCHAR2
4417: -- x_msg_count OUT NUMBER

Line 4433: p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

4429: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
4430: p_validation_level IN VARCHAR2 := 100,
4431: p_calling_module IN VARCHAR2 := 'SELF_SERVICE',
4432: p_debug_mode IN VARCHAR2 := 'N',
4433: p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
4434: p_object_relationships_id IN NUMBER,
4435: p_record_version_number IN NUMBER,
4436: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
4437: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 4664: pa_interface_utils_pub.get_messages

4660: --
4661: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4662: x_msg_count := FND_MSG_PUB.count_msg;
4663: IF x_msg_count = 1 then
4664: pa_interface_utils_pub.get_messages
4665: (p_encoded => FND_API.G_TRUE,
4666: p_msg_index => 1,
4667: p_msg_count => x_msg_count,
4668: p_msg_data => x_msg_data,

Line 4701: pa_interface_utils_pub.get_messages

4697: --
4698: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4699: x_msg_count := FND_MSG_PUB.count_msg;
4700: IF x_msg_count = 1 then
4701: pa_interface_utils_pub.get_messages
4702: (p_encoded => FND_API.G_TRUE,
4703: p_msg_index => 1,
4704: p_msg_count => x_msg_count,
4705: p_msg_data => x_msg_data,

Line 4752: pa_interface_utils_pub.get_messages

4748: x_msg_count := FND_MSG_PUB.count_msg;
4749:
4750: if x_msg_count = 1 then
4751:
4752: pa_interface_utils_pub.get_messages
4753: (p_encoded => FND_API.G_TRUE
4754: , p_msg_index => 1
4755: , p_msg_count => x_msg_count
4756: , p_msg_data => x_msg_data

Line 4799: pa_interface_utils_pub.get_messages

4795:
4796: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
4797: x_msg_count := FND_MSG_PUB.count_msg;
4798: IF x_msg_count = 1 then
4799: pa_interface_utils_pub.get_messages
4800: (p_encoded => FND_API.G_TRUE,
4801: p_msg_index => 1,
4802: p_msg_count => x_msg_count,
4803: p_msg_data => x_msg_data,

Line 4862: p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

4858: Procedure Copy_OG_Lnk_For_Subproj_Ass(p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
4859: p_validation_level IN VARCHAR2 := 100,
4860: p_calling_module IN VARCHAR2 := 'SELF_SERVICE',
4861: p_debug_mode IN VARCHAR2 := 'N',
4862: p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
4863: p_commit IN VARCHAR2 := FND_API.G_FALSE,
4864: p_src_str_version_id IN NUMBER,
4865: p_dest_str_version_id IN NUMBER,
4866: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 5101: p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

5097: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
5098: p_validation_level IN VARCHAR2 := 100,
5099: p_calling_module IN VARCHAR2 := 'SELF_SERVICE',
5100: p_debug_mode IN VARCHAR2 := 'N',
5101: p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
5102: p_src_str_version_id IN NUMBER,
5103: p_dest_str_version_id IN NUMBER, /*publishing str*/
5104: p_publish_fl IN CHAR,
5105: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 5414: p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

5410: p_validation_level IN VARCHAR2 := 100,
5411: p_calling_module IN VARCHAR2 :='SELF_SERVICE',
5412: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
5413: p_debug_mode IN VARCHAR2 :='N',
5414: p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
5415: p_src_str_version_id IN NUMBER,
5416: p_pub_str_version_id IN NUMBER, --published str, which is destination
5417: p_last_pub_str_version_id IN NUMBER,
5418: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 5510: -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

5506: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
5507: -- p_validation_level IN VARCHAR2 := 100
5508: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
5509: -- p_debug_mode IN VARCHAR2 := 'N'
5510: -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5511: -- p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5512: -- p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5513: -- x_return_status OUT VARCHAR2
5514: -- x_msg_count OUT NUMBER

Line 5511: -- p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

5507: -- p_validation_level IN VARCHAR2 := 100
5508: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
5509: -- p_debug_mode IN VARCHAR2 := 'N'
5510: -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5511: -- p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5512: -- p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5513: -- x_return_status OUT VARCHAR2
5514: -- x_msg_count OUT NUMBER
5515: -- x_msg_data OUT VARCHAR2

Line 5512: -- p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

5508: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
5509: -- p_debug_mode IN VARCHAR2 := 'N'
5510: -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5511: -- p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5512: -- p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5513: -- x_return_status OUT VARCHAR2
5514: -- x_msg_count OUT NUMBER
5515: -- x_msg_data OUT VARCHAR2
5516: --

Line 5536: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

5532: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
5533: ,p_validation_level IN VARCHAR2 := 100
5534: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
5535: ,p_debug_mode IN VARCHAR2 := 'N'
5536: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5537: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5538: ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5539: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
5540: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 5537: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

5533: ,p_validation_level IN VARCHAR2 := 100
5534: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
5535: ,p_debug_mode IN VARCHAR2 := 'N'
5536: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5537: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5538: ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5539: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
5540: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
5541: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 5538: ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

5534: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
5535: ,p_debug_mode IN VARCHAR2 := 'N'
5536: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5537: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5538: ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5539: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
5540: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
5541: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
5542: )