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

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

14: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
15: -- p_validation_level IN VARCHAR2 := 100
16: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
17: -- p_debug_mode IN VARCHAR2 := 'N'
18: -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19: -- p_project_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
20: -- p_project_name_from IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
21: -- p_structure_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
22: -- p_structure_name_from IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

15: -- p_validation_level IN VARCHAR2 := 100
16: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
17: -- p_debug_mode IN VARCHAR2 := 'N'
18: -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19: -- p_project_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
20: -- p_project_name_from IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
21: -- p_structure_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
22: -- p_structure_name_from IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
23: -- p_structure_version_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 20: -- p_project_name_from IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

16: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
17: -- p_debug_mode IN VARCHAR2 := 'N'
18: -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19: -- p_project_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
20: -- p_project_name_from IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
21: -- p_structure_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
22: -- p_structure_name_from IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
23: -- p_structure_version_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
24: -- p_structure_version_name_from IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 21: -- p_structure_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

17: -- p_debug_mode IN VARCHAR2 := 'N'
18: -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19: -- p_project_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
20: -- p_project_name_from IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
21: -- p_structure_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
22: -- p_structure_name_from IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
23: -- p_structure_version_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
24: -- p_structure_version_name_from IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
25: -- p_task_version_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 22: -- p_structure_name_from IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

18: -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19: -- p_project_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
20: -- p_project_name_from IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
21: -- p_structure_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
22: -- p_structure_name_from IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
23: -- p_structure_version_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
24: -- p_structure_version_name_from IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
25: -- p_task_version_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
26: -- p_task_name_from IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

19: -- p_project_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
20: -- p_project_name_from IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
21: -- p_structure_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
22: -- p_structure_name_from IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
23: -- p_structure_version_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
24: -- p_structure_version_name_from IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
25: -- p_task_version_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
26: -- p_task_name_from IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
27: -- p_project_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 24: -- p_structure_version_name_from IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

20: -- p_project_name_from IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
21: -- p_structure_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
22: -- p_structure_name_from IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
23: -- p_structure_version_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
24: -- p_structure_version_name_from IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
25: -- p_task_version_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
26: -- p_task_name_from IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
27: -- p_project_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
28: -- p_project_name_to IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

21: -- p_structure_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
22: -- p_structure_name_from IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
23: -- p_structure_version_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
24: -- p_structure_version_name_from IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
25: -- p_task_version_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
26: -- p_task_name_from IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
27: -- p_project_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
28: -- p_project_name_to IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
29: -- p_structure_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 26: -- p_task_name_from IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

22: -- p_structure_name_from IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
23: -- p_structure_version_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
24: -- p_structure_version_name_from IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
25: -- p_task_version_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
26: -- p_task_name_from IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
27: -- p_project_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
28: -- p_project_name_to IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
29: -- p_structure_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
30: -- p_structure_name_to IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 27: -- p_project_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

23: -- p_structure_version_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
24: -- p_structure_version_name_from IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
25: -- p_task_version_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
26: -- p_task_name_from IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
27: -- p_project_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
28: -- p_project_name_to IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
29: -- p_structure_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
30: -- p_structure_name_to IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
31: -- p_structure_version_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 28: -- p_project_name_to IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

24: -- p_structure_version_name_from IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
25: -- p_task_version_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
26: -- p_task_name_from IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
27: -- p_project_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
28: -- p_project_name_to IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
29: -- p_structure_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
30: -- p_structure_name_to IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
31: -- p_structure_version_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
32: -- p_structure_version_name_to IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 29: -- p_structure_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

25: -- p_task_version_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
26: -- p_task_name_from IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
27: -- p_project_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
28: -- p_project_name_to IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
29: -- p_structure_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
30: -- p_structure_name_to IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
31: -- p_structure_version_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
32: -- p_structure_version_name_to IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
33: -- p_task_version_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 30: -- p_structure_name_to IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

26: -- p_task_name_from IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
27: -- p_project_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
28: -- p_project_name_to IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
29: -- p_structure_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
30: -- p_structure_name_to IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
31: -- p_structure_version_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
32: -- p_structure_version_name_to IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
33: -- p_task_version_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
34: -- p_task_name_to IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

27: -- p_project_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
28: -- p_project_name_to IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
29: -- p_structure_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
30: -- p_structure_name_to IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
31: -- p_structure_version_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
32: -- p_structure_version_name_to IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
33: -- p_task_version_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
34: -- p_task_name_to IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
35: -- p_structure_type IN VARCHAR2

Line 32: -- p_structure_version_name_to IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

28: -- p_project_name_to IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
29: -- p_structure_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
30: -- p_structure_name_to IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
31: -- p_structure_version_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
32: -- p_structure_version_name_to IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
33: -- p_task_version_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
34: -- p_task_name_to IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
35: -- p_structure_type IN VARCHAR2
36: -- p_initiating_element IN VARCHAR2

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

29: -- p_structure_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
30: -- p_structure_name_to IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
31: -- p_structure_version_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
32: -- p_structure_version_name_to IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
33: -- p_task_version_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
34: -- p_task_name_to IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
35: -- p_structure_type IN VARCHAR2
36: -- p_initiating_element IN VARCHAR2
37: -- p_link_to_latest_structure_ver IN VARCHAR2 := 'N'

Line 34: -- p_task_name_to IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

30: -- p_structure_name_to IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
31: -- p_structure_version_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
32: -- p_structure_version_name_to IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
33: -- p_task_version_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
34: -- p_task_name_to IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
35: -- p_structure_type IN VARCHAR2
36: -- p_initiating_element IN VARCHAR2
37: -- p_link_to_latest_structure_ver IN VARCHAR2 := 'N'
38: -- p_relationship_type IN VARCHAR2

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

35: -- p_structure_type IN VARCHAR2
36: -- p_initiating_element IN VARCHAR2
37: -- p_link_to_latest_structure_ver IN VARCHAR2 := 'N'
38: -- p_relationship_type IN VARCHAR2
39: -- p_relationship_subtype IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
40: -- p_lag_day IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
41: -- p_priority IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
42: -- x_object_relationship_id OUT NUMBER
43: -- x_return_status OUT VARCHAR2

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

36: -- p_initiating_element IN VARCHAR2
37: -- p_link_to_latest_structure_ver IN VARCHAR2 := 'N'
38: -- p_relationship_type IN VARCHAR2
39: -- p_relationship_subtype IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
40: -- p_lag_day IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
41: -- p_priority IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
42: -- x_object_relationship_id OUT NUMBER
43: -- x_return_status OUT VARCHAR2
44: -- x_msg_count OUT NUMBER

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

37: -- p_link_to_latest_structure_ver IN VARCHAR2 := 'N'
38: -- p_relationship_type IN VARCHAR2
39: -- p_relationship_subtype IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
40: -- p_lag_day IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
41: -- p_priority IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
42: -- x_object_relationship_id OUT NUMBER
43: -- x_return_status OUT VARCHAR2
44: -- x_msg_count OUT NUMBER
45: -- x_msg_data OUT VARCHAR2

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

59: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
60: ,p_validation_level IN VARCHAR2 := 100
61: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
62: ,p_debug_mode IN VARCHAR2 := 'N'
63: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
64: ,p_project_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
65: ,p_project_name_from IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
66: ,p_structure_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
67: ,p_structure_name_from IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 64: ,p_project_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

60: ,p_validation_level IN VARCHAR2 := 100
61: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
62: ,p_debug_mode IN VARCHAR2 := 'N'
63: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
64: ,p_project_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
65: ,p_project_name_from IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
66: ,p_structure_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
67: ,p_structure_name_from IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
68: ,p_structure_version_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 65: ,p_project_name_from IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

61: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
62: ,p_debug_mode IN VARCHAR2 := 'N'
63: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
64: ,p_project_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
65: ,p_project_name_from IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
66: ,p_structure_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
67: ,p_structure_name_from IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
68: ,p_structure_version_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
69: ,p_structure_version_name_from IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 66: ,p_structure_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

62: ,p_debug_mode IN VARCHAR2 := 'N'
63: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
64: ,p_project_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
65: ,p_project_name_from IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
66: ,p_structure_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
67: ,p_structure_name_from IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
68: ,p_structure_version_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
69: ,p_structure_version_name_from IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
70: ,p_task_version_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 67: ,p_structure_name_from IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

63: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
64: ,p_project_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
65: ,p_project_name_from IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
66: ,p_structure_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
67: ,p_structure_name_from IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
68: ,p_structure_version_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
69: ,p_structure_version_name_from IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
70: ,p_task_version_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
71: ,p_task_name_from IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

64: ,p_project_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
65: ,p_project_name_from IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
66: ,p_structure_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
67: ,p_structure_name_from IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
68: ,p_structure_version_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
69: ,p_structure_version_name_from IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
70: ,p_task_version_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
71: ,p_task_name_from IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
72: ,p_project_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 69: ,p_structure_version_name_from IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

65: ,p_project_name_from IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
66: ,p_structure_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
67: ,p_structure_name_from IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
68: ,p_structure_version_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
69: ,p_structure_version_name_from IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
70: ,p_task_version_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
71: ,p_task_name_from IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
72: ,p_project_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
73: ,p_project_name_to IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

66: ,p_structure_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
67: ,p_structure_name_from IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
68: ,p_structure_version_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
69: ,p_structure_version_name_from IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
70: ,p_task_version_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
71: ,p_task_name_from IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
72: ,p_project_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
73: ,p_project_name_to IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
74: ,p_structure_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 71: ,p_task_name_from IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

67: ,p_structure_name_from IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
68: ,p_structure_version_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
69: ,p_structure_version_name_from IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
70: ,p_task_version_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
71: ,p_task_name_from IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
72: ,p_project_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
73: ,p_project_name_to IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
74: ,p_structure_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
75: ,p_structure_name_to IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 72: ,p_project_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

68: ,p_structure_version_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
69: ,p_structure_version_name_from IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
70: ,p_task_version_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
71: ,p_task_name_from IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
72: ,p_project_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
73: ,p_project_name_to IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
74: ,p_structure_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
75: ,p_structure_name_to IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
76: ,p_structure_version_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 73: ,p_project_name_to IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

69: ,p_structure_version_name_from IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
70: ,p_task_version_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
71: ,p_task_name_from IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
72: ,p_project_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
73: ,p_project_name_to IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
74: ,p_structure_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
75: ,p_structure_name_to IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
76: ,p_structure_version_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
77: ,p_structure_version_name_to IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 74: ,p_structure_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

70: ,p_task_version_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
71: ,p_task_name_from IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
72: ,p_project_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
73: ,p_project_name_to IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
74: ,p_structure_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
75: ,p_structure_name_to IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
76: ,p_structure_version_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
77: ,p_structure_version_name_to IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
78: ,p_task_version_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 75: ,p_structure_name_to IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

71: ,p_task_name_from IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
72: ,p_project_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
73: ,p_project_name_to IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
74: ,p_structure_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
75: ,p_structure_name_to IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
76: ,p_structure_version_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
77: ,p_structure_version_name_to IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
78: ,p_task_version_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
79: ,p_task_name_to IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

72: ,p_project_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
73: ,p_project_name_to IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
74: ,p_structure_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
75: ,p_structure_name_to IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
76: ,p_structure_version_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
77: ,p_structure_version_name_to IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
78: ,p_task_version_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
79: ,p_task_name_to IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
80: ,p_structure_type IN VARCHAR2

Line 77: ,p_structure_version_name_to IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

73: ,p_project_name_to IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
74: ,p_structure_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
75: ,p_structure_name_to IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
76: ,p_structure_version_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
77: ,p_structure_version_name_to IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
78: ,p_task_version_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
79: ,p_task_name_to IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
80: ,p_structure_type IN VARCHAR2
81: ,p_initiating_element IN VARCHAR2

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

74: ,p_structure_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
75: ,p_structure_name_to IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
76: ,p_structure_version_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
77: ,p_structure_version_name_to IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
78: ,p_task_version_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
79: ,p_task_name_to IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
80: ,p_structure_type IN VARCHAR2
81: ,p_initiating_element IN VARCHAR2
82: ,p_link_to_latest_structure_ver IN VARCHAR2 := 'N'

Line 79: ,p_task_name_to IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

75: ,p_structure_name_to IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
76: ,p_structure_version_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
77: ,p_structure_version_name_to IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
78: ,p_task_version_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
79: ,p_task_name_to IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
80: ,p_structure_type IN VARCHAR2
81: ,p_initiating_element IN VARCHAR2
82: ,p_link_to_latest_structure_ver IN VARCHAR2 := 'N'
83: ,p_relationship_type IN VARCHAR2

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

80: ,p_structure_type IN VARCHAR2
81: ,p_initiating_element IN VARCHAR2
82: ,p_link_to_latest_structure_ver IN VARCHAR2 := 'N'
83: ,p_relationship_type IN VARCHAR2
84: ,p_relationship_subtype IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
85: ,p_lag_day IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
86: ,p_priority IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
87: ,p_weighting_percentage IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
88: ,x_object_relationship_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

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

81: ,p_initiating_element IN VARCHAR2
82: ,p_link_to_latest_structure_ver IN VARCHAR2 := 'N'
83: ,p_relationship_type IN VARCHAR2
84: ,p_relationship_subtype IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
85: ,p_lag_day IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
86: ,p_priority IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
87: ,p_weighting_percentage IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
88: ,x_object_relationship_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
89: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

82: ,p_link_to_latest_structure_ver IN VARCHAR2 := 'N'
83: ,p_relationship_type IN VARCHAR2
84: ,p_relationship_subtype IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
85: ,p_lag_day IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
86: ,p_priority IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
87: ,p_weighting_percentage IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
88: ,x_object_relationship_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
89: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
90: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

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

83: ,p_relationship_type IN VARCHAR2
84: ,p_relationship_subtype IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
85: ,p_lag_day IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
86: ,p_priority IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
87: ,p_weighting_percentage IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
88: ,x_object_relationship_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
89: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
90: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
91: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 136: IF ((p_project_name_from <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND

132: END IF;
133:
134:
135: --name to id conversion
136: IF ((p_project_name_from <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND
137: (p_project_name_from IS NOT NULL)) OR
138: ((p_project_id_from <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) AND
139: (p_project_id_from IS NOT NULL)) THEN
140: PA_PROJ_ELEMENTS_UTILS.Project_Name_Or_Id(

Line 138: ((p_project_id_from <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) AND

134:
135: --name to id conversion
136: IF ((p_project_name_from <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND
137: (p_project_name_from IS NOT NULL)) OR
138: ((p_project_id_from <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) AND
139: (p_project_id_from IS NOT NULL)) THEN
140: PA_PROJ_ELEMENTS_UTILS.Project_Name_Or_Id(
141: p_project_name => p_project_name_from
142: ,p_project_id => p_project_id_from

Line 154: IF ((p_project_name_to <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND

150: END IF;
151: END IF;
152:
153:
154: IF ((p_project_name_to <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND
155: (p_project_name_to IS NOT NULL)) OR
156: ((p_project_id_to <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) AND
157: (p_project_id_to IS NOT NULL)) THEN
158: PA_PROJ_ELEMENTS_UTILS.Project_Name_Or_Id(

Line 156: ((p_project_id_to <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) AND

152:
153:
154: IF ((p_project_name_to <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND
155: (p_project_name_to IS NOT NULL)) OR
156: ((p_project_id_to <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) AND
157: (p_project_id_to IS NOT NULL)) THEN
158: PA_PROJ_ELEMENTS_UTILS.Project_Name_Or_Id(
159: p_project_name => p_project_name_to
160: ,p_project_id => p_project_id_to

Line 171: IF ((p_structure_name_from <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND

167: PA_UTILS.ADD_MESSAGE( 'PA', l_error_msg_code);
168: END IF;
169: END IF;
170:
171: IF ((p_structure_name_from <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND
172: (p_structure_name_from IS NOT NULL)) OR
173: ((p_structure_id_from <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) AND
174: (p_structure_id_from IS NOT NULL)) THEN
175: PA_PROJECT_STRUCTURE_UTILS.Structure_Name_Or_Id(

Line 173: ((p_structure_id_from <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) AND

169: END IF;
170:
171: IF ((p_structure_name_from <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND
172: (p_structure_name_from IS NOT NULL)) OR
173: ((p_structure_id_from <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) AND
174: (p_structure_id_from IS NOT NULL)) THEN
175: PA_PROJECT_STRUCTURE_UTILS.Structure_Name_Or_Id(
176: p_project_id => l_project_id_from
177: ,p_structure_id => p_structure_id_from

Line 189: IF ((p_structure_name_to <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND

185: PA_UTILS.ADD_MESSAGE( 'PA', l_error_msg_code);
186: END IF;
187: END IF;
188:
189: IF ((p_structure_name_to <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND
190: (p_structure_name_to IS NOT NULL)) OR
191: ((p_structure_id_to <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) AND
192: (p_structure_id_to IS NOT NULL)) THEN
193: PA_PROJECT_STRUCTURE_UTILS.Structure_Name_Or_Id(

Line 191: ((p_structure_id_to <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) AND

187: END IF;
188:
189: IF ((p_structure_name_to <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND
190: (p_structure_name_to IS NOT NULL)) OR
191: ((p_structure_id_to <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) AND
192: (p_structure_id_to IS NOT NULL)) THEN
193: PA_PROJECT_STRUCTURE_UTILS.Structure_Name_Or_Id(
194: p_project_id => l_project_id_to
195: ,p_structure_id => p_structure_id_to

Line 207: IF ((p_structure_version_name_from <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND

203: PA_UTILS.ADD_MESSAGE( 'PA', l_error_msg_code);
204: END IF;
205: END IF;
206:
207: IF ((p_structure_version_name_from <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND
208: (p_structure_version_name_from IS NOT NULL)) OR
209: ((p_structure_version_id_from <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) AND
210: (p_structure_version_id_from IS NOT NULL)) THEN
211: -- error_msg('name -> '||p_structure_version_name_from);

Line 209: ((p_structure_version_id_from <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) AND

205: END IF;
206:
207: IF ((p_structure_version_name_from <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND
208: (p_structure_version_name_from IS NOT NULL)) OR
209: ((p_structure_version_id_from <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) AND
210: (p_structure_version_id_from IS NOT NULL)) THEN
211: -- error_msg('name -> '||p_structure_version_name_from);
212: -- error_msg('id -> '||p_structure_version_id_from);
213: PA_PROJECT_STRUCTURE_UTILS.Structure_Version_Name_Or_Id

Line 229: IF ((p_structure_version_name_to <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND

225: PA_UTILS.ADD_MESSAGE( 'PA', l_error_msg_code);
226: END IF;
227: END IF;
228:
229: IF ((p_structure_version_name_to <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND
230: (p_structure_version_name_to IS NOT NULL)) OR
231: ((p_structure_version_id_to <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) AND
232: (p_structure_version_id_to IS NOT NULL)) THEN
233: PA_PROJECT_STRUCTURE_UTILS.Structure_Version_Name_Or_Id

Line 231: ((p_structure_version_id_to <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) AND

227: END IF;
228:
229: IF ((p_structure_version_name_to <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND
230: (p_structure_version_name_to IS NOT NULL)) OR
231: ((p_structure_version_id_to <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) AND
232: (p_structure_version_id_to IS NOT NULL)) THEN
233: PA_PROJECT_STRUCTURE_UTILS.Structure_Version_Name_Or_Id
234: (
235: p_structure_id => l_structure_id_to

Line 249: IF ((p_task_name_from <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND

245: PA_UTILS.ADD_MESSAGE( 'PA', l_error_msg_code);
246: END IF;
247: END IF;
248:
249: IF ((p_task_name_from <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND
250: (p_task_name_from IS NOT NULL)) OR
251: ((p_task_version_id_from <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) AND
252: (p_task_version_id_from IS NOT NULL)) THEN
253: PA_PROJ_ELEMENTS_UTILS.TASK_VER_NAME_OR_ID(

Line 251: ((p_task_version_id_from <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) AND

247: END IF;
248:
249: IF ((p_task_name_from <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND
250: (p_task_name_from IS NOT NULL)) OR
251: ((p_task_version_id_from <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) AND
252: (p_task_version_id_from IS NOT NULL)) THEN
253: PA_PROJ_ELEMENTS_UTILS.TASK_VER_NAME_OR_ID(
254: p_task_name => p_task_name_from
255: ,p_task_version_id => p_task_version_id_from

Line 268: IF ((p_task_name_to <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND

264: PA_UTILS.ADD_MESSAGE( 'PA', l_error_msg_code);
265: END IF;
266: END IF;
267:
268: IF ((p_task_name_to <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND
269: (p_task_name_to IS NOT NULL)) OR
270: ((p_task_version_id_to <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) AND
271: (p_task_version_id_to IS NOT NULL)) THEN
272: PA_PROJ_ELEMENTS_UTILS.TASK_VER_NAME_OR_ID(

Line 270: ((p_task_version_id_to <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) AND

266: END IF;
267:
268: IF ((p_task_name_to <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND
269: (p_task_name_to IS NOT NULL)) OR
270: ((p_task_version_id_to <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) AND
271: (p_task_version_id_to IS NOT NULL)) THEN
272: PA_PROJ_ELEMENTS_UTILS.TASK_VER_NAME_OR_ID(
273: p_task_name => p_task_name_to
274: ,p_task_version_id => p_task_version_id_to

Line 290: pa_interface_utils_pub.get_messages

286:
287: x_msg_count := FND_MSG_PUB.count_msg;
288: IF x_msg_count > 0 THEN
289: If x_msg_count > 1 then
290: pa_interface_utils_pub.get_messages
291: (p_encoded => FND_API.G_TRUE,
292: p_msg_index => 1,
293: p_msg_count => l_msg_count,
294: p_msg_data => l_msg_data,

Line 337: pa_interface_utils_pub.get_messages

333:
334: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
335: x_msg_count := FND_MSG_PUB.count_msg;
336: IF x_msg_count = 1 then
337: pa_interface_utils_pub.get_messages
338: (p_encoded => FND_API.G_TRUE,
339: p_msg_index => 1,
340: p_msg_count => l_msg_count,
341: p_msg_data => l_msg_data,

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

395: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
396: -- p_validation_level IN VARCHAR2 := 100
397: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
398: -- p_debug_mode IN VARCHAR2 := 'N'
399: -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
400: -- p_object_relationship_id IN NUMBER
401: -- p_record_version_number IN NUMBER
402: -- x_return_status OUT VARCHAR2
403: -- x_msg_count OUT NUMBER

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

418: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
419: ,p_validation_level IN VARCHAR2 := 100
420: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
421: ,p_debug_mode IN VARCHAR2 := 'N'
422: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
423: ,p_object_relationship_id IN NUMBER
424: ,p_record_version_number IN NUMBER
425: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
426: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 478: pa_interface_utils_pub.get_messages

474:
475: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
476: x_msg_count := FND_MSG_PUB.count_msg;
477: IF x_msg_count = 1 then
478: pa_interface_utils_pub.get_messages
479: (p_encoded => FND_API.G_TRUE,
480: p_msg_index => 1,
481: p_msg_count => l_msg_count,
482: p_msg_data => l_msg_data,

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

526: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
527: -- p_validation_level IN VARCHAR2 := 100
528: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
529: -- p_debug_mode IN VARCHAR2 := 'N'
530: -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
531: -- p_src_proj_id IN NUMBER := NULL
532: -- p_src_task_ver_id IN NUMBER := NULL
533: -- p_dest_proj_name IN VARCHAR2 := NULL
534: -- p_dest_proj_id IN NUMBER := NULL

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

556: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
557: ,p_validation_level IN VARCHAR2 := 100
558: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
559: ,p_debug_mode IN VARCHAR2 := 'N'
560: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
561: ,p_src_proj_id IN NUMBER := NULL
562: ,p_src_task_ver_id IN NUMBER := NULL
563: ,p_dest_proj_name IN VARCHAR2 := NULL
564: ,p_dest_proj_id IN NUMBER := NULL

Line 636: IF ((p_dest_proj_name <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND

632: RAISE FND_API.G_EXC_ERROR;
633: END IF;
634:
635: --project name to id conversion
636: IF ((p_dest_proj_name <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND
637: (p_dest_proj_name IS NOT NULL)) OR
638: ((p_dest_proj_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) AND
639: (p_dest_proj_id IS NOT NULL)) THEN
640: PA_PROJ_ELEMENTS_UTILS.Project_Name_Or_Id(

Line 638: ((p_dest_proj_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) AND

634:
635: --project name to id conversion
636: IF ((p_dest_proj_name <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND
637: (p_dest_proj_name IS NOT NULL)) OR
638: ((p_dest_proj_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) AND
639: (p_dest_proj_id IS NOT NULL)) THEN
640: PA_PROJ_ELEMENTS_UTILS.Project_Name_Or_Id(
641: p_project_name => p_dest_proj_name
642: ,p_project_id => p_dest_proj_id

Line 681: IF ((p_dest_task_name <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND

677: END IF;
678: END IF;
679:
680: --task name to id conversion
681: IF ((p_dest_task_name <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND
682: (p_dest_task_name IS NOT NULL)) OR
683: ((p_dest_task_ver_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) AND
684: (p_dest_task_ver_id IS NOT NULL)) THEN
685:

Line 683: ((p_dest_task_ver_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) AND

679:
680: --task name to id conversion
681: IF ((p_dest_task_name <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND
682: (p_dest_task_name IS NOT NULL)) OR
683: ((p_dest_task_ver_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) AND
684: (p_dest_task_ver_id IS NOT NULL)) THEN
685:
686: PA_PROJ_ELEMENTS_UTILS.task_Ver_Name_Or_Id
687: (

Line 709: pa_interface_utils_pub.get_messages

705:
706: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
707: x_msg_count := FND_MSG_PUB.count_msg;
708: IF x_msg_count = 1 then
709: pa_interface_utils_pub.get_messages
710: (p_encoded => FND_API.G_TRUE,
711: p_msg_index => 1,
712: p_msg_count => l_msg_count,
713: p_msg_data => l_msg_data,

Line 748: pa_interface_utils_pub.get_messages

744:
745: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
746: x_msg_count := FND_MSG_PUB.count_msg;
747: IF x_msg_count = 1 then
748: pa_interface_utils_pub.get_messages
749: (p_encoded => FND_API.G_TRUE,
750: p_msg_index => 1,
751: p_msg_count => l_msg_count,
752: p_msg_data => l_msg_data,

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

803: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
804: -- p_validation_level IN VARCHAR2 := 100
805: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
806: -- p_debug_mode IN VARCHAR2 := 'N'
807: -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
808: -- p_task_version_id IN NUMBER := NULL
809: -- p_type IN VARCHAR2 := NULL
810: -- p_lag_days IN NUMBER := NULL
811: -- p_comments IN VARCHAR2 := NULL

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

829: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
830: ,p_validation_level IN VARCHAR2 := 100
831: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
832: ,p_debug_mode IN VARCHAR2 := 'N'
833: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
834: ,p_task_version_id IN NUMBER := NULL
835: ,p_src_task_version_id IN NUMBER := NULL
836: ,p_type IN VARCHAR2 := NULL
837: ,p_lag_days IN NUMBER := NULL

Line 898: pa_interface_utils_pub.get_messages

894:
895: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
896: x_msg_count := FND_MSG_PUB.count_msg;
897: IF x_msg_count = 1 then
898: pa_interface_utils_pub.get_messages
899: (p_encoded => FND_API.G_TRUE,
900: p_msg_index => 1,
901: p_msg_count => l_msg_count,
902: p_msg_data => l_msg_data,

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

953: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
954: -- p_validation_level IN VARCHAR2 := 100
955: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
956: -- p_debug_mode IN VARCHAR2 := 'N'
957: -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
958: -- p_object_relationship_id IN NUMBER := NULL
959: -- x_return_status OUT VARCHAR2
960: -- x_msg_count OUT NUMBER
961: -- x_msg_data OUT VARCHAR2

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

975: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
976: ,p_validation_level IN VARCHAR2 := 100
977: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
978: ,p_debug_mode IN VARCHAR2 := 'N'
979: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
980: ,p_object_relationship_id IN NUMBER := NULL
981: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
982: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
983: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 1035: pa_interface_utils_pub.get_messages

1031:
1032: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1033: x_msg_count := FND_MSG_PUB.count_msg;
1034: IF x_msg_count = 1 then
1035: pa_interface_utils_pub.get_messages
1036: (p_encoded => FND_API.G_TRUE,
1037: p_msg_index => 1,
1038: p_msg_count => l_msg_count,
1039: p_msg_data => l_msg_data,

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

1090: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1091: -- p_validation_level IN VARCHAR2 := 100
1092: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
1093: -- p_debug_mode IN VARCHAR2 := 'N'
1094: -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1095: -- p_src_proj_id IN NUMBER
1096: -- p_task_ver_id IN NUMBER
1097: -- p_dest_proj_id IN NUMBER := NULL
1098: -- p_dest_proj_name IN VARCHAR2

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

1114: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1115: ,p_validation_level IN VARCHAR2 := 100
1116: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
1117: ,p_debug_mode IN VARCHAR2 := 'N'
1118: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1119: ,p_src_proj_id IN NUMBER
1120: ,p_task_ver_id IN NUMBER
1121: ,p_dest_proj_id IN NUMBER
1122: ,p_dest_proj_name IN VARCHAR2 := NULL

Line 1170: IF ((p_dest_proj_name <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND

1166: END IF;
1167: --
1168: --
1169: -- For destination Project
1170: IF ((p_dest_proj_name <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND
1171: (p_dest_proj_name IS NOT NULL)) OR
1172: ((p_dest_proj_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) AND
1173: (p_dest_proj_id IS NOT NULL)) THEN
1174: PA_PROJ_ELEMENTS_UTILS.Project_Name_Or_Id(

Line 1172: ((p_dest_proj_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) AND

1168: --
1169: -- For destination Project
1170: IF ((p_dest_proj_name <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND
1171: (p_dest_proj_name IS NOT NULL)) OR
1172: ((p_dest_proj_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) AND
1173: (p_dest_proj_id IS NOT NULL)) THEN
1174: PA_PROJ_ELEMENTS_UTILS.Project_Name_Or_Id(
1175: p_project_name => p_dest_proj_name
1176: ,p_project_id => p_dest_proj_id

Line 1212: pa_interface_utils_pub.get_messages

1208: x_msg_data => x_msg_data);
1209: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1210: x_msg_count := FND_MSG_PUB.count_msg;
1211: IF x_msg_count = 1 then
1212: pa_interface_utils_pub.get_messages
1213: (p_encoded => FND_API.G_TRUE,
1214: p_msg_index => 1,
1215: p_msg_count => l_msg_count,
1216: p_msg_data => l_msg_data,

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

1267: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1268: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1269: -- p_validation_level IN VARCHAR2 := 100
1270: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
1271: -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1272: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
1273: -- p_debug_mode IN VARCHAR2 := 'N'
1274: -- p_object_relationship_id IN NUMBER
1275: -- p_record_version_number IN NUMBER

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

1290: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1291: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
1292: p_validation_level IN VARCHAR2 := 100,
1293: p_calling_module IN VARCHAR2 := 'SELF_SERVICE',
1294: p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
1295: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1296: p_debug_mode IN VARCHAR2 := 'N',
1297: p_object_relationship_id IN NUMBER,
1298: p_record_version_number IN NUMBER,

Line 1356: pa_interface_utils_pub.get_messages

1352: x_msg_data => x_msg_data);
1353: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1354: x_msg_count := FND_MSG_PUB.count_msg;
1355: IF x_msg_count = 1 then
1356: pa_interface_utils_pub.get_messages
1357: (p_encoded => FND_API.G_TRUE,
1358: p_msg_index => 1,
1359: p_msg_count => l_msg_count,
1360: p_msg_data => l_msg_data,

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

1411: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1412: -- p_validation_level IN VARCHAR2 := 100
1413: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
1414: -- p_debug_mode IN VARCHAR2 := 'N'
1415: -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1416: -- p_object_relationships_id IN NUMBER
1417: -- p_record_version_number IN NUMBER
1418: -- x_return_status OUT VARCHAR2
1419: -- x_msg_count OUT NUMBER

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

1433: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
1434: p_validation_level IN VARCHAR2 := 100,
1435: p_calling_module IN VARCHAR2 := 'SELF_SERVICE',
1436: p_debug_mode IN VARCHAR2 := 'N',
1437: p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
1438: p_object_relationships_id IN NUMBER,
1439: p_record_version_number IN NUMBER,
1440: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1441: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 1493: pa_interface_utils_pub.get_messages

1489: x_msg_data => x_msg_data);
1490: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1491: x_msg_count := FND_MSG_PUB.count_msg;
1492: IF x_msg_count = 1 then
1493: pa_interface_utils_pub.get_messages
1494: (p_encoded => FND_API.G_TRUE,
1495: p_msg_index => 1,
1496: p_msg_count => l_msg_count,
1497: p_msg_data => l_msg_data,