17:
18: PROCEDURE DELETE_MAPPING
19: (
20: p_api_version IN NUMBER := 1.0
21: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
22: , p_commit IN VARCHAR2 := FND_API.G_FALSE
23: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE
24: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
25: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
18: PROCEDURE DELETE_MAPPING
19: (
20: p_api_version IN NUMBER := 1.0
21: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
22: , p_commit IN VARCHAR2 := FND_API.G_FALSE
23: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE
24: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
25: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
26: , p_debug_mode IN VARCHAR2 := 'N'
19: (
20: p_api_version IN NUMBER := 1.0
21: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
22: , p_commit IN VARCHAR2 := FND_API.G_FALSE
23: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE
24: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
25: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
26: , p_debug_mode IN VARCHAR2 := 'N'
27: , p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
20: p_api_version IN NUMBER := 1.0
21: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
22: , p_commit IN VARCHAR2 := FND_API.G_FALSE
23: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE
24: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
25: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
26: , p_debug_mode IN VARCHAR2 := 'N'
27: , p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
28: , p_wp_from_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
23: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE
24: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
25: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
26: , p_debug_mode IN VARCHAR2 := 'N'
27: , p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
28: , p_wp_from_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
29: , p_wp_task_version_id IN NUMBER := FND_API.G_MISS_NUM
30: , p_fp_task_version_id IN NUMBER := FND_API.G_MISS_NUM
31: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
24: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
25: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
26: , p_debug_mode IN VARCHAR2 := 'N'
27: , p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
28: , p_wp_from_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
29: , p_wp_task_version_id IN NUMBER := FND_API.G_MISS_NUM
30: , p_fp_task_version_id IN NUMBER := FND_API.G_MISS_NUM
31: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
32: , x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
25: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
26: , p_debug_mode IN VARCHAR2 := 'N'
27: , p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
28: , p_wp_from_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
29: , p_wp_task_version_id IN NUMBER := FND_API.G_MISS_NUM
30: , p_fp_task_version_id IN NUMBER := FND_API.G_MISS_NUM
31: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
32: , x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
33: , x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
26: , p_debug_mode IN VARCHAR2 := 'N'
27: , p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
28: , p_wp_from_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
29: , p_wp_task_version_id IN NUMBER := FND_API.G_MISS_NUM
30: , p_fp_task_version_id IN NUMBER := FND_API.G_MISS_NUM
31: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
32: , x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
33: , x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
34:
36:
37: PROCEDURE CREATE_MAPPING
38: (
39: p_api_version IN NUMBER := 1.0
40: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
41: , p_commit IN VARCHAR2 := FND_API.G_FALSE
42: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE
43: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
44: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
37: PROCEDURE CREATE_MAPPING
38: (
39: p_api_version IN NUMBER := 1.0
40: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
41: , p_commit IN VARCHAR2 := FND_API.G_FALSE
42: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE
43: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
44: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
45: , p_debug_mode IN VARCHAR2 := 'N'
38: (
39: p_api_version IN NUMBER := 1.0
40: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
41: , p_commit IN VARCHAR2 := FND_API.G_FALSE
42: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE
43: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
44: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
45: , p_debug_mode IN VARCHAR2 := 'N'
46: , p_wp_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
39: p_api_version IN NUMBER := 1.0
40: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
41: , p_commit IN VARCHAR2 := FND_API.G_FALSE
42: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE
43: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
44: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
45: , p_debug_mode IN VARCHAR2 := 'N'
46: , p_wp_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
47: , p_wp_task_version_id IN NUMBER := FND_API.G_MISS_NUM
42: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE
43: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
44: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
45: , p_debug_mode IN VARCHAR2 := 'N'
46: , p_wp_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
47: , p_wp_task_version_id IN NUMBER := FND_API.G_MISS_NUM
48: , p_parent_str_version_id IN NUMBER := FND_API.G_MISS_NUM
49: , p_fp_task_version_id IN NUMBER := FND_API.G_MISS_NUM
50: , p_fp_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
43: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
44: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
45: , p_debug_mode IN VARCHAR2 := 'N'
46: , p_wp_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
47: , p_wp_task_version_id IN NUMBER := FND_API.G_MISS_NUM
48: , p_parent_str_version_id IN NUMBER := FND_API.G_MISS_NUM
49: , p_fp_task_version_id IN NUMBER := FND_API.G_MISS_NUM
50: , p_fp_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
51: , p_project_id IN NUMBER
44: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
45: , p_debug_mode IN VARCHAR2 := 'N'
46: , p_wp_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
47: , p_wp_task_version_id IN NUMBER := FND_API.G_MISS_NUM
48: , p_parent_str_version_id IN NUMBER := FND_API.G_MISS_NUM
49: , p_fp_task_version_id IN NUMBER := FND_API.G_MISS_NUM
50: , p_fp_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
51: , p_project_id IN NUMBER
52: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
45: , p_debug_mode IN VARCHAR2 := 'N'
46: , p_wp_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
47: , p_wp_task_version_id IN NUMBER := FND_API.G_MISS_NUM
48: , p_parent_str_version_id IN NUMBER := FND_API.G_MISS_NUM
49: , p_fp_task_version_id IN NUMBER := FND_API.G_MISS_NUM
50: , p_fp_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
51: , p_project_id IN NUMBER
52: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
53: , x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
46: , p_wp_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
47: , p_wp_task_version_id IN NUMBER := FND_API.G_MISS_NUM
48: , p_parent_str_version_id IN NUMBER := FND_API.G_MISS_NUM
49: , p_fp_task_version_id IN NUMBER := FND_API.G_MISS_NUM
50: , p_fp_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
51: , p_project_id IN NUMBER
52: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
53: , x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
54: , x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
56:
57: PROCEDURE UPDATE_MAPPING
58: (
59: p_api_version IN NUMBER := 1.0
60: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
61: , p_commit IN VARCHAR2 := FND_API.G_FALSE
62: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE
63: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
64: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
57: PROCEDURE UPDATE_MAPPING
58: (
59: p_api_version IN NUMBER := 1.0
60: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
61: , p_commit IN VARCHAR2 := FND_API.G_FALSE
62: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE
63: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
64: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
65: , p_debug_mode IN VARCHAR2 := 'N'
58: (
59: p_api_version IN NUMBER := 1.0
60: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
61: , p_commit IN VARCHAR2 := FND_API.G_FALSE
62: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE
63: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
64: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
65: , p_debug_mode IN VARCHAR2 := 'N'
66: , p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
59: p_api_version IN NUMBER := 1.0
60: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
61: , p_commit IN VARCHAR2 := FND_API.G_FALSE
62: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE
63: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
64: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
65: , p_debug_mode IN VARCHAR2 := 'N'
66: , p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
67: , p_structure_type IN VARCHAR2 := 'WORKPLAN'
62: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE
63: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
64: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
65: , p_debug_mode IN VARCHAR2 := 'N'
66: , p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
67: , p_structure_type IN VARCHAR2 := 'WORKPLAN'
68: , p_project_id IN NUMBER
69: , p_wp_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
70: , p_wp_prnt_str_ver_id IN NUMBER := FND_API.G_MISS_NUM
65: , p_debug_mode IN VARCHAR2 := 'N'
66: , p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
67: , p_structure_type IN VARCHAR2 := 'WORKPLAN'
68: , p_project_id IN NUMBER
69: , p_wp_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
70: , p_wp_prnt_str_ver_id IN NUMBER := FND_API.G_MISS_NUM
71: , p_wp_task_version_id IN NUMBER := FND_API.G_MISS_NUM
72: , p_fp_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
73: , p_fp_task_version_id IN NUMBER := FND_API.G_MISS_NUM
66: , p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
67: , p_structure_type IN VARCHAR2 := 'WORKPLAN'
68: , p_project_id IN NUMBER
69: , p_wp_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
70: , p_wp_prnt_str_ver_id IN NUMBER := FND_API.G_MISS_NUM
71: , p_wp_task_version_id IN NUMBER := FND_API.G_MISS_NUM
72: , p_fp_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
73: , p_fp_task_version_id IN NUMBER := FND_API.G_MISS_NUM
74: , p_object_relationship_id IN NUMBER := FND_API.G_MISS_NUM
67: , p_structure_type IN VARCHAR2 := 'WORKPLAN'
68: , p_project_id IN NUMBER
69: , p_wp_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
70: , p_wp_prnt_str_ver_id IN NUMBER := FND_API.G_MISS_NUM
71: , p_wp_task_version_id IN NUMBER := FND_API.G_MISS_NUM
72: , p_fp_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
73: , p_fp_task_version_id IN NUMBER := FND_API.G_MISS_NUM
74: , p_object_relationship_id IN NUMBER := FND_API.G_MISS_NUM
75: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
68: , p_project_id IN NUMBER
69: , p_wp_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
70: , p_wp_prnt_str_ver_id IN NUMBER := FND_API.G_MISS_NUM
71: , p_wp_task_version_id IN NUMBER := FND_API.G_MISS_NUM
72: , p_fp_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
73: , p_fp_task_version_id IN NUMBER := FND_API.G_MISS_NUM
74: , p_object_relationship_id IN NUMBER := FND_API.G_MISS_NUM
75: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
76: , x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
69: , p_wp_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
70: , p_wp_prnt_str_ver_id IN NUMBER := FND_API.G_MISS_NUM
71: , p_wp_task_version_id IN NUMBER := FND_API.G_MISS_NUM
72: , p_fp_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
73: , p_fp_task_version_id IN NUMBER := FND_API.G_MISS_NUM
74: , p_object_relationship_id IN NUMBER := FND_API.G_MISS_NUM
75: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
76: , x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
77: , x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
70: , p_wp_prnt_str_ver_id IN NUMBER := FND_API.G_MISS_NUM
71: , p_wp_task_version_id IN NUMBER := FND_API.G_MISS_NUM
72: , p_fp_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
73: , p_fp_task_version_id IN NUMBER := FND_API.G_MISS_NUM
74: , p_object_relationship_id IN NUMBER := FND_API.G_MISS_NUM
75: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
76: , x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
77: , x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
78: );
79:
80: PROCEDURE COPY_MAPPING
81: (
82: p_api_version IN NUMBER := 1.0
83: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
84: , p_commit IN VARCHAR2 := FND_API.G_FALSE
85: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE
86: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
87: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
80: PROCEDURE COPY_MAPPING
81: (
82: p_api_version IN NUMBER := 1.0
83: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
84: , p_commit IN VARCHAR2 := FND_API.G_FALSE
85: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE
86: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
87: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
88: , p_debug_mode IN VARCHAR2 := 'N'
81: (
82: p_api_version IN NUMBER := 1.0
83: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
84: , p_commit IN VARCHAR2 := FND_API.G_FALSE
85: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE
86: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
87: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
88: , p_debug_mode IN VARCHAR2 := 'N'
89: , p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
82: p_api_version IN NUMBER := 1.0
83: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
84: , p_commit IN VARCHAR2 := FND_API.G_FALSE
85: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE
86: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
87: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
88: , p_debug_mode IN VARCHAR2 := 'N'
89: , p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
90: , p_context IN VARCHAR2
85: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE
86: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
87: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
88: , p_debug_mode IN VARCHAR2 := 'N'
89: , p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
90: , p_context IN VARCHAR2
91: , p_src_project_id IN NUMBER := FND_API.G_MISS_NUM
92: , p_dest_project_id IN NUMBER := FND_API.G_MISS_NUM
93: , p_src_str_version_id IN NUMBER := FND_API.G_MISS_NUM
87: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
88: , p_debug_mode IN VARCHAR2 := 'N'
89: , p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
90: , p_context IN VARCHAR2
91: , p_src_project_id IN NUMBER := FND_API.G_MISS_NUM
92: , p_dest_project_id IN NUMBER := FND_API.G_MISS_NUM
93: , p_src_str_version_id IN NUMBER := FND_API.G_MISS_NUM
94: , p_dest_str_version_id IN NUMBER := FND_API.G_MISS_NUM
95: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
88: , p_debug_mode IN VARCHAR2 := 'N'
89: , p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
90: , p_context IN VARCHAR2
91: , p_src_project_id IN NUMBER := FND_API.G_MISS_NUM
92: , p_dest_project_id IN NUMBER := FND_API.G_MISS_NUM
93: , p_src_str_version_id IN NUMBER := FND_API.G_MISS_NUM
94: , p_dest_str_version_id IN NUMBER := FND_API.G_MISS_NUM
95: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
96: , x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
89: , p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
90: , p_context IN VARCHAR2
91: , p_src_project_id IN NUMBER := FND_API.G_MISS_NUM
92: , p_dest_project_id IN NUMBER := FND_API.G_MISS_NUM
93: , p_src_str_version_id IN NUMBER := FND_API.G_MISS_NUM
94: , p_dest_str_version_id IN NUMBER := FND_API.G_MISS_NUM
95: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
96: , x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
97: , x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
90: , p_context IN VARCHAR2
91: , p_src_project_id IN NUMBER := FND_API.G_MISS_NUM
92: , p_dest_project_id IN NUMBER := FND_API.G_MISS_NUM
93: , p_src_str_version_id IN NUMBER := FND_API.G_MISS_NUM
94: , p_dest_str_version_id IN NUMBER := FND_API.G_MISS_NUM
95: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
96: , x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
97: , x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
98: );
98: );
99: PROCEDURE DELETE_ALL_MAPPING
100: (
101: p_api_version IN NUMBER := 1.0
102: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
103: , p_commit IN VARCHAR2 := FND_API.G_FALSE
104: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE
105: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
106: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
99: PROCEDURE DELETE_ALL_MAPPING
100: (
101: p_api_version IN NUMBER := 1.0
102: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
103: , p_commit IN VARCHAR2 := FND_API.G_FALSE
104: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE
105: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
106: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
107: , p_debug_mode IN VARCHAR2 := 'N'
100: (
101: p_api_version IN NUMBER := 1.0
102: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
103: , p_commit IN VARCHAR2 := FND_API.G_FALSE
104: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE
105: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
106: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
107: , p_debug_mode IN VARCHAR2 := 'N'
108: , p_project_id IN NUMBER
101: p_api_version IN NUMBER := 1.0
102: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
103: , p_commit IN VARCHAR2 := FND_API.G_FALSE
104: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE
105: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
106: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
107: , p_debug_mode IN VARCHAR2 := 'N'
108: , p_project_id IN NUMBER
109: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895