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 1237: pa_interface_utils_pub.get_messages

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

Line 1281: pa_interface_utils_pub.get_messages

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

Line 1310: pa_interface_utils_pub.get_messages

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

Line 1386: pa_interface_utils_pub.get_messages

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

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

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

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

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

Line 1561: pa_interface_utils_pub.get_messages

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

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

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

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

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

Line 1742: pa_interface_utils_pub.get_messages

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

Line 2316: pa_interface_utils_pub.get_messages

2312:
2313: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2314: x_msg_count := FND_MSG_PUB.count_msg;
2315: IF x_msg_count = 1 then
2316: pa_interface_utils_pub.get_messages
2317: (p_encoded => FND_API.G_TRUE,
2318: p_msg_index => 1,
2319: p_msg_count => x_msg_count,
2320: p_msg_data => x_msg_data,

Line 2360: pa_interface_utils_pub.get_messages

2356:
2357: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2358: x_msg_count := FND_MSG_PUB.count_msg;
2359: IF x_msg_count = 1 then
2360: pa_interface_utils_pub.get_messages
2361: (p_encoded => FND_API.G_TRUE,
2362: p_msg_index => 1,
2363: p_msg_count => x_msg_count,
2364: p_msg_data => x_msg_data,

Line 2466: pa_interface_utils_pub.get_messages

2462:
2463: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2464: x_msg_count := FND_MSG_PUB.count_msg;
2465: IF x_msg_count = 1 then
2466: pa_interface_utils_pub.get_messages
2467: (p_encoded => FND_API.G_TRUE,
2468: p_msg_index => 1,
2469: p_msg_count => x_msg_count,
2470: p_msg_data => x_msg_data,

Line 2558: pa_interface_utils_pub.get_messages

2554: -- IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2555: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2556: x_msg_count := FND_MSG_PUB.count_msg;
2557: IF x_msg_count = 1 then
2558: pa_interface_utils_pub.get_messages
2559: (p_encoded => FND_API.G_TRUE,
2560: p_msg_index => 1,
2561: p_msg_count => x_msg_count,
2562: p_msg_data => x_msg_data,

Line 2769: pa_interface_utils_pub.get_messages

2765: );
2766: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2767: x_msg_count := FND_MSG_PUB.count_msg;
2768: IF x_msg_count = 1 then
2769: pa_interface_utils_pub.get_messages
2770: (p_encoded => FND_API.G_TRUE,
2771: p_msg_index => 1,
2772: p_msg_count => x_msg_count,
2773: p_msg_data => x_msg_data,

Line 2835: pa_interface_utils_pub.get_messages

2831:
2832: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2833: x_msg_count := FND_MSG_PUB.count_msg;
2834: /* IF x_msg_count = 1 then
2835: pa_interface_utils_pub.get_messages
2836: (p_encoded => FND_API.G_TRUE,
2837: p_msg_index => 1,
2838: p_msg_count => x_msg_count,
2839: p_msg_data => x_msg_data,

Line 2914: pa_interface_utils_pub.get_messages

2910:
2911: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2912: x_msg_count := FND_MSG_PUB.count_msg;
2913: /* IF x_msg_count = 1 then
2914: pa_interface_utils_pub.get_messages
2915: (p_encoded => FND_API.G_TRUE,
2916: p_msg_index => 1,
2917: p_msg_count => x_msg_count,
2918: p_msg_data => x_msg_data,

Line 2965: pa_interface_utils_pub.get_messages

2961:
2962: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2963: x_msg_count := FND_MSG_PUB.count_msg;
2964: IF x_msg_count = 1 Then
2965: pa_interface_utils_pub.get_messages
2966: (p_encoded => FND_API.G_TRUE,
2967: p_msg_index => 1,
2968: p_msg_count => x_msg_count,
2969: p_msg_data => x_msg_data,

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

2996: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
2997: ,p_validation_level IN VARCHAR2 := 100
2998: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
2999: ,p_debug_mode IN VARCHAR2 := 'N'
3000: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3001: ,p_src_proj_id IN NUMBER
3002: ,p_src_struc_wp_or_fin IN VARCHAR2
3003: ,p_src_struc_elem_id IN NUMBER
3004: ,p_src_struc_elem_ver_id IN NUMBER

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

3008: ,p_src_task_elem_id IN NUMBER
3009: ,p_src_task_elem_ver_id IN NUMBER
3010: ,p_lnk_task_name_number IN VARCHAR2 --SMukka
3011: ,p_relationship_type IN VARCHAR2
3012: ,p_comment IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR --Bug No 3668113
3013: ,x_lnk_task_elem_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
3014: ,x_lnk_task_elem_ver_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
3015: ,x_object_relationship_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
3016: ,x_pev_schedule_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 3096: pa_interface_utils_pub.get_messages

3092: ,x_msg_data => x_msg_data);
3093: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3094: x_msg_count := FND_MSG_PUB.count_msg;
3095: IF x_msg_count = 1 THEN
3096: pa_interface_utils_pub.get_messages
3097: (p_encoded => FND_API.G_TRUE,
3098: p_msg_index => 1,
3099: p_msg_count => x_msg_count,
3100: p_msg_data => x_msg_data,

Line 3140: pa_interface_utils_pub.get_messages

3136: ,x_msg_data => x_msg_data);
3137: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3138: x_msg_count := FND_MSG_PUB.count_msg;
3139: IF x_msg_count = 1 THEN
3140: pa_interface_utils_pub.get_messages
3141: (p_encoded => FND_API.G_TRUE,
3142: p_msg_index => 1,
3143: p_msg_count => x_msg_count,
3144: p_msg_data => x_msg_data,

Line 3233: pa_interface_utils_pub.get_messages

3229: --
3230: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3231: x_msg_count := FND_MSG_PUB.count_msg;
3232: IF x_msg_count = 1 THEN
3233: pa_interface_utils_pub.get_messages
3234: (p_encoded => FND_API.G_TRUE,
3235: p_msg_index => 1,
3236: p_msg_count => x_msg_count,
3237: p_msg_data => x_msg_data,

Line 3285: pa_interface_utils_pub.get_messages

3281: );
3282: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3283: x_msg_count := FND_MSG_PUB.count_msg;
3284: IF x_msg_count = 1 THEN
3285: pa_interface_utils_pub.get_messages
3286: (p_encoded => FND_API.G_TRUE,
3287: p_msg_index => 1,
3288: p_msg_count => x_msg_count,
3289: p_msg_data => x_msg_data,

Line 3322: pa_interface_utils_pub.get_messages

3318:
3319: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3320: x_msg_count := FND_MSG_PUB.count_msg;
3321: IF x_msg_count = 1 THEN
3322: pa_interface_utils_pub.get_messages
3323: (p_encoded => FND_API.G_TRUE,
3324: p_msg_index => 1,
3325: p_msg_count => x_msg_count,
3326: p_msg_data => x_msg_data,

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

3442: -- p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
3443: -- p_calling_module IN VARCHAR2 :='SELF_SERVICE'
3444: -- p_commit IN VARCHAR2 :=FND_API.G_FALSE
3445: -- p_debug_mode IN VARCHAR2 :='N'
3446: -- p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3447: -- p_src_proj_id IN pa_projects_all.project_id%type
3448: -- p_task_ver_id IN pa_proj_element_versions.element_version_id%type
3449: -- p_dest_proj_id IN pa_projects_all.project_id%type
3450: -- p_dest_proj_name IN pa_projects_all.name%type

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

3470: p_validation_level IN VARCHAR2 := 100,
3471: p_calling_module IN VARCHAR2 :='SELF_SERVICE',
3472: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
3473: p_debug_mode IN VARCHAR2 :='N',
3474: p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
3475: p_src_proj_id IN pa_projects_all.project_id%type,
3476: p_task_ver_id IN pa_proj_element_versions.element_version_id%type,
3477: p_dest_proj_id IN pa_projects_all.project_id%type,
3478: p_dest_proj_name IN pa_projects_all.name%type,

Line 3917: pa_interface_utils_pub.get_messages

3913: --
3914: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3915: x_msg_count := FND_MSG_PUB.count_msg;
3916: IF x_msg_count = 1 then
3917: pa_interface_utils_pub.get_messages
3918: (p_encoded => FND_API.G_TRUE,
3919: p_msg_index => 1,
3920: p_msg_count => x_msg_count,
3921: p_msg_data => x_msg_data,

Line 3985: pa_interface_utils_pub.get_messages

3981: --
3982: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3983: x_msg_count := FND_MSG_PUB.count_msg;
3984: IF x_msg_count = 1 then
3985: pa_interface_utils_pub.get_messages
3986: (p_encoded => FND_API.G_TRUE,
3987: p_msg_index => 1,
3988: p_msg_count => x_msg_count,
3989: p_msg_data => x_msg_data,

Line 4052: pa_interface_utils_pub.get_messages

4048: --
4049: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4050: x_msg_count := FND_MSG_PUB.count_msg;
4051: IF x_msg_count = 1 then
4052: pa_interface_utils_pub.get_messages
4053: (p_encoded => FND_API.G_TRUE,
4054: p_msg_index => 1,
4055: p_msg_count => x_msg_count,
4056: p_msg_data => x_msg_data,

Line 4120: pa_interface_utils_pub.get_messages

4116: );
4117: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4118: x_msg_count := FND_MSG_PUB.count_msg;
4119: IF x_msg_count = 1 then
4120: pa_interface_utils_pub.get_messages
4121: (p_encoded => FND_API.G_TRUE,
4122: p_msg_index => 1,
4123: p_msg_count => x_msg_count,
4124: p_msg_data => x_msg_data,

Line 4241: pa_interface_utils_pub.get_messages

4237:
4238: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
4239: x_msg_count := FND_MSG_PUB.count_msg;
4240: IF x_msg_count = 1 then
4241: pa_interface_utils_pub.get_messages
4242: (p_encoded => FND_API.G_TRUE,
4243: p_msg_index => 1,
4244: p_msg_count => x_msg_count,
4245: p_msg_data => x_msg_data,

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

4290: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
4291: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
4292: -- p_validation_level IN VARCHAR2 := 100
4293: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
4294: -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4295: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
4296: -- p_debug_mode IN VARCHAR2 := 'N'
4297: -- p_object_relationship_id IN NUMBER
4298: -- p_record_version_number IN NUMBER

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

4313: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
4314: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
4315: p_validation_level IN VARCHAR2 := 100,
4316: p_calling_module IN VARCHAR2 := 'SELF_SERVICE',
4317: p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
4318: p_commit IN VARCHAR2 := FND_API.G_FALSE,
4319: p_debug_mode IN VARCHAR2 := 'N',
4320: p_object_relationship_id IN NUMBER,
4321: p_record_version_number IN NUMBER,

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

4427: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
4428: -- p_validation_level IN VARCHAR2 := 100
4429: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
4430: -- p_debug_mode IN VARCHAR2 := 'N'
4431: -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4432: -- p_object_relationships_id IN NUMBER
4433: -- p_record_version_number IN NUMBER
4434: -- x_return_status OUT VARCHAR2
4435: -- x_msg_count OUT NUMBER

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

4447: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
4448: p_validation_level IN VARCHAR2 := 100,
4449: p_calling_module IN VARCHAR2 := 'SELF_SERVICE',
4450: p_debug_mode IN VARCHAR2 := 'N',
4451: p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
4452: p_object_relationships_id IN NUMBER,
4453: p_record_version_number IN NUMBER,
4454: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
4455: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 4682: pa_interface_utils_pub.get_messages

4678: --
4679: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4680: x_msg_count := FND_MSG_PUB.count_msg;
4681: IF x_msg_count = 1 then
4682: pa_interface_utils_pub.get_messages
4683: (p_encoded => FND_API.G_TRUE,
4684: p_msg_index => 1,
4685: p_msg_count => x_msg_count,
4686: p_msg_data => x_msg_data,

Line 4719: pa_interface_utils_pub.get_messages

4715: --
4716: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4717: x_msg_count := FND_MSG_PUB.count_msg;
4718: IF x_msg_count = 1 then
4719: pa_interface_utils_pub.get_messages
4720: (p_encoded => FND_API.G_TRUE,
4721: p_msg_index => 1,
4722: p_msg_count => x_msg_count,
4723: p_msg_data => x_msg_data,

Line 4770: pa_interface_utils_pub.get_messages

4766: x_msg_count := FND_MSG_PUB.count_msg;
4767:
4768: if x_msg_count = 1 then
4769:
4770: pa_interface_utils_pub.get_messages
4771: (p_encoded => FND_API.G_TRUE
4772: , p_msg_index => 1
4773: , p_msg_count => x_msg_count
4774: , p_msg_data => x_msg_data

Line 4820: pa_interface_utils_pub.get_messages

4816:
4817: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
4818: x_msg_count := FND_MSG_PUB.count_msg;
4819: IF x_msg_count = 1 then
4820: pa_interface_utils_pub.get_messages
4821: (p_encoded => FND_API.G_TRUE,
4822: p_msg_index => 1,
4823: p_msg_count => x_msg_count,
4824: p_msg_data => x_msg_data,

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

4880: Procedure Copy_OG_Lnk_For_Subproj_Ass(p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
4881: p_validation_level IN VARCHAR2 := 100,
4882: p_calling_module IN VARCHAR2 := 'SELF_SERVICE',
4883: p_debug_mode IN VARCHAR2 := 'N',
4884: p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
4885: p_commit IN VARCHAR2 := FND_API.G_FALSE,
4886: p_src_str_version_id IN NUMBER,
4887: p_dest_str_version_id IN NUMBER,
4888: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

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

5119: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
5120: p_validation_level IN VARCHAR2 := 100,
5121: p_calling_module IN VARCHAR2 := 'SELF_SERVICE',
5122: p_debug_mode IN VARCHAR2 := 'N',
5123: p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
5124: p_src_str_version_id IN NUMBER,
5125: p_dest_str_version_id IN NUMBER, /*publishing str*/
5126: p_publish_fl IN CHAR,
5127: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

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

5432: p_validation_level IN VARCHAR2 := 100,
5433: p_calling_module IN VARCHAR2 :='SELF_SERVICE',
5434: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
5435: p_debug_mode IN VARCHAR2 :='N',
5436: p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
5437: p_src_str_version_id IN NUMBER,
5438: p_pub_str_version_id IN NUMBER, --published str, which is destination
5439: p_last_pub_str_version_id IN NUMBER,
5440: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

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

5528: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
5529: -- p_validation_level IN VARCHAR2 := 100
5530: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
5531: -- p_debug_mode IN VARCHAR2 := 'N'
5532: -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5533: -- p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5534: -- p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5535: -- x_return_status OUT VARCHAR2
5536: -- x_msg_count OUT NUMBER

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

5529: -- p_validation_level IN VARCHAR2 := 100
5530: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
5531: -- p_debug_mode IN VARCHAR2 := 'N'
5532: -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5533: -- p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5534: -- p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5535: -- x_return_status OUT VARCHAR2
5536: -- x_msg_count OUT NUMBER
5537: -- x_msg_data OUT VARCHAR2

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

5530: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
5531: -- p_debug_mode IN VARCHAR2 := 'N'
5532: -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5533: -- p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5534: -- p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5535: -- x_return_status OUT VARCHAR2
5536: -- x_msg_count OUT NUMBER
5537: -- x_msg_data OUT VARCHAR2
5538: --

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

5554: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
5555: ,p_validation_level IN VARCHAR2 := 100
5556: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
5557: ,p_debug_mode IN VARCHAR2 := 'N'
5558: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5559: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5560: ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5561: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
5562: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

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

5555: ,p_validation_level IN VARCHAR2 := 100
5556: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
5557: ,p_debug_mode IN VARCHAR2 := 'N'
5558: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5559: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5560: ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5561: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
5562: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
5563: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

5556: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
5557: ,p_debug_mode IN VARCHAR2 := 'N'
5558: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5559: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5560: ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5561: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
5562: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
5563: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
5564: )