1 PACKAGE PA_PROJ_STRUC_MAPPING_PUB AS
2 /* $Header: PAPSMPPS.pls 120.1 2005/08/19 16:46:20 mwasowic noship $ */
3
4 -- This table type can be used for version id of any kind of project element version.
5 TYPE OBJECT_VERSION_ID_TABLE_TYPE IS TABLE OF pa_proj_element_versions.element_version_id%TYPE
6 INDEX BY BINARY_INTEGER;
7
8 -- This table type can be used for id of any kind of project element.
9 TYPE OBJECT_ID_TABLE_TYPE IS TABLE OF pa_proj_element_versions.proj_element_id%TYPE
10 INDEX BY BINARY_INTEGER;
11
12 -- This table type can be used for name of any kind of project element.
13 TYPE OBJECT_NAME_TABLE_TYPE IS TABLE OF PA_PROJ_ELEMENTS.NAME%TYPE INDEX BY BINARY_INTEGER;
14
15 -- This table type can be used for stroring object_relationship_id
16 TYPE OBJ_REL_ID_TABLE_TYPE IS TABLE OF PA_OBJECT_RELATIONSHIPS.OBJECT_RELATIONSHIP_ID%TYPE INDEX BY BINARY_INTEGER;
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'
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
35 );
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'
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
54 , x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
55 );
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'
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
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'
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
97 , x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
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'
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
110 , x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
111 , x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
112 );
113 END PA_PROJ_STRUC_MAPPING_PUB;