APPS.PA_RELATIONSHIP_PUB 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 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
18: -- p_project_name_from IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19: -- p_structure_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
20: -- p_structure_name_from IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

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 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
18: -- p_project_name_from IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19: -- p_structure_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
20: -- p_structure_name_from IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
21: -- p_structure_version_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

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

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 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
18: -- p_project_name_from IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19: -- p_structure_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
20: -- p_structure_name_from IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
21: -- p_structure_version_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
22: -- p_structure_version_name_from IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 19: -- p_structure_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 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
18: -- p_project_name_from IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19: -- p_structure_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
20: -- p_structure_name_from IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
21: -- p_structure_version_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
22: -- p_structure_version_name_from IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
23: -- p_task_version_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

101: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
102: -- p_validation_level IN VARCHAR2 := 100
103: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
104: -- p_debug_mode IN VARCHAR2 := 'N'
105: -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
106: -- p_object_relationship_id IN NUMBER
107: -- p_record_version_number IN NUMBER
108: -- x_return_status OUT VARCHAR2
109: -- x_msg_count OUT NUMBER

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

124: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
125: ,p_validation_level IN VARCHAR2 := 100
126: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
127: ,p_debug_mode IN VARCHAR2 := 'N'
128: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
129: ,p_object_relationship_id IN NUMBER
130: ,p_record_version_number IN NUMBER
131: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
132: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

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

144: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
145: -- p_validation_level IN VARCHAR2 := 100
146: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
147: -- p_debug_mode IN VARCHAR2 := 'N'
148: -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
149: -- p_src_proj_id IN NUMBER := NULL
150: -- p_src_task_ver_id IN NUMBER := NULL
151: -- p_dest_proj_name IN VARCHAR2 := NULL
152: -- p_dest_proj_id IN NUMBER := NULL

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

175: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
176: ,p_validation_level IN VARCHAR2 := 100
177: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
178: ,p_debug_mode IN VARCHAR2 := 'N'
179: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
180: ,p_src_proj_id IN NUMBER := NULL
181: ,p_src_task_ver_id IN NUMBER := NULL
182: ,p_dest_proj_name IN VARCHAR2 := NULL
183: ,p_dest_proj_id IN NUMBER := NULL

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

203: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
204: -- p_validation_level IN VARCHAR2 := 100
205: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
206: -- p_debug_mode IN VARCHAR2 := 'N'
207: -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
208: -- p_task_version_id IN NUMBER := NULL
209: -- p_type IN VARCHAR2 := NULL
210: -- p_lag_days IN NUMBER := NULL
211: -- p_comments IN VARCHAR2 := NULL

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

229: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
230: ,p_validation_level IN VARCHAR2 := 100
231: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
232: ,p_debug_mode IN VARCHAR2 := 'N'
233: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
234: ,p_task_version_id IN NUMBER := NULL
235: ,p_src_task_version_id IN NUMBER := NULL
236: ,p_type IN VARCHAR2 := NULL
237: ,p_lag_days IN NUMBER := NULL

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

253: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
254: -- p_validation_level IN VARCHAR2 := 100
255: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
256: -- p_debug_mode IN VARCHAR2 := 'N'
257: -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
258: -- p_object_relationship_id IN NUMBER := NULL
259: -- x_return_status OUT VARCHAR2
260: -- x_msg_count OUT NUMBER
261: -- x_msg_data OUT VARCHAR2

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

275: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
276: ,p_validation_level IN VARCHAR2 := 100
277: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
278: ,p_debug_mode IN VARCHAR2 := 'N'
279: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
280: ,p_object_relationship_id IN NUMBER := NULL
281: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
282: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
283: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

294: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
295: -- p_validation_level IN VARCHAR2 := 100
296: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
297: -- p_debug_mode IN VARCHAR2 := 'N'
298: -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
299: -- p_src_proj_id IN NUMBER
300: -- p_task_ver_id IN NUMBER
301: -- p_dest_proj_id IN NUMBER
302: -- p_dest_proj_name IN VARCHAR2

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

318: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
319: ,p_validation_level IN VARCHAR2 := 100
320: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
321: ,p_debug_mode IN VARCHAR2 := 'N'
322: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
323: ,p_src_proj_id IN NUMBER
324: ,p_task_ver_id IN NUMBER
325: ,p_dest_proj_id IN NUMBER
326: ,p_dest_proj_name IN VARCHAR2 := NULL

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

339: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
340: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
341: -- p_validation_level IN VARCHAR2 := 100
342: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
343: -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
344: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
345: -- p_debug_mode IN VARCHAR2 := 'N'
346: -- p_object_relationship_id IN NUMBER
347: -- p_record_version_number IN NUMBER

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

360: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
361: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
362: p_validation_level IN VARCHAR2 := 100,
363: p_calling_module IN VARCHAR2 := 'SELF_SERVICE',
364: p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
365: p_commit IN VARCHAR2 := FND_API.G_FALSE,
366: p_debug_mode IN VARCHAR2 := 'N',
367: p_object_relationship_id IN NUMBER,
368: p_record_version_number IN NUMBER,

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

380: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
381: -- p_validation_level IN VARCHAR2 := 100
382: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
383: -- p_debug_mode IN VARCHAR2 := 'N'
384: -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
385: -- p_object_relationships_id IN NUMBER
386: -- p_record_version_number IN NUMBER
387: -- x_return_status OUT VARCHAR2
388: -- x_msg_count OUT NUMBER

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

400: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
401: p_validation_level IN VARCHAR2 := 100,
402: p_calling_module IN VARCHAR2 := 'SELF_SERVICE',
403: p_debug_mode IN VARCHAR2 := 'N',
404: p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
405: p_object_relationships_id IN NUMBER,
406: p_record_version_number IN NUMBER,
407: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
408: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895