[Home] [Help]
PACKAGE: APPS.PA_WORKPLAN_ATTR_PUB
Source
1 PACKAGE PA_WORKPLAN_ATTR_PUB AUTHID CURRENT_USER AS
2 /* $Header: PAPRWPPS.pls 120.1.12010000.2 2009/07/22 12:27:16 gboomina ship $ */
3
4
5 -- API name : Create_Proj_Workplan_Attrs
6 -- Type : Public
7 -- Pre-reqs : None.
8 -- Parameters :
9 -- p_api_version IN NUMBER Required Default = 1.0
10 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
11 -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
12 -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
13 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
14 -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
15 -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
16 -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
17 -- p_project_id IN NUMBER Required
18 -- p_proj_element_id IN NUMBER Required
19 -- p_approval_reqd_flag IN VARCHAR2 Required
20 -- p_auto_publish_flag IN VARCHAR2 Required
21 -- p_approver_source_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
22 -- p_approver_source_type IN NUMBER Optional Default = FND_API.G_MISS_NUM
23 -- p_approver_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
24 -- p_default_display_lvl IN NUMBER Required
25 -- p_enable_wp_version_flag IN VARCHAR2 Required
26 -- p_lifecycle_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
27 -- p_lifecycle_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
28 -- p_current_lifecycle_phase_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
29 -- p_current_lifecycle_phase IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
30 -- p_auto_pub_upon_creation_flag IN VARCHAR2 Required
31 -- p_auto_sync_txn_date_flag IN VARCHAR2 Required
32 -- p_txn_date_sync_buf_days IN NUMBER Optional Default = FND_API.G_MISS_NUM
33 -- x_return_status OUT VARCHAR2 Required
34 -- x_msg_count OUT NUMBER Required
35 -- x_msg_data OUT VARCHAR2 Optional
36
37 PROCEDURE CREATE_PROJ_WORKPLAN_ATTRS
38 ( p_api_version IN NUMBER := 1.0
39 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
40 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
41 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
42 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
43 ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
44 ,p_debug_mode IN VARCHAR2 := 'N'
45 ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
46 ,p_project_id IN NUMBER
47 ,p_proj_element_id IN NUMBER
48 ,p_approval_reqd_flag IN VARCHAR2
49 ,p_auto_publish_flag IN VARCHAR2
50 ,p_approver_source_id IN NUMBER := FND_API.G_MISS_NUM
51 ,p_approver_source_type IN NUMBER := FND_API.G_MISS_NUM
52 ,p_approver_name IN VARCHAR2 := FND_API.G_MISS_CHAR
53 ,p_default_display_lvl IN NUMBER
54 ,p_enable_wp_version_flag IN VARCHAR2
55 ,p_lifecycle_id IN NUMBER := FND_API.G_MISS_NUM
56 ,p_lifecycle_name IN VARCHAR2 := FND_API.G_MISS_CHAR
57 ,p_current_lifecycle_phase_id IN NUMBER := FND_API.G_MISS_NUM
58 ,p_current_lifecycle_phase IN VARCHAR2 := FND_API.G_MISS_CHAR
59 ,p_auto_pub_upon_creation_flag IN VARCHAR2
60 ,p_auto_sync_txn_date_flag IN VARCHAR2
61 ,p_txn_date_sync_buf_days IN NUMBER := FND_API.G_MISS_NUM
62 --bug 3325803: FP M
63 ,p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
64 ,p_schedule_third_party_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
65 ,p_third_party_schedule_code IN VARCHAR2 := FND_API.G_MISS_CHAR
66 ,p_auto_rollup_subproj_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
67 --bug 3325803: FP M
68 --FP M: Workflow attributes
69 -- gboomina Bug 8586393 - start
70 ,p_use_task_schedule_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
71 -- gboomina Bug 8586393 - end
72 ,p_enable_wf_flag IN VARCHAR2 := 'N'
73 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
74 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
75 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
76 );
77
78
79 -- API name : Update_Proj_Workplan_Attrs
80 -- Type : Public
81 -- Pre-reqs : None.
82 -- Parameters :
83 -- p_api_version IN NUMBER Required Default = 1.0
84 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
85 -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
86 -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
87 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
88 -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
89 -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
90 -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
91 -- p_project_id IN NUMBER Required Default = FND_API.G_MISS_NUM
92 -- p_approval_reqd_flag IN VARCHAR2 Required Default = FND_API.G_MISS_NUM
93 -- p_auto_publish_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
94 -- p_approver_source_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
95 -- p_approver_source_type IN NUMBER Optional Default = FND_API.G_MISS_NUM
96 -- p_approver_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
97 -- p_default_display_lvl IN NUMBER Required Default = FND_API.G_MISS_NUM
98 -- p_enable_wp_version_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
99 -- p_lifecycle_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
100 -- p_lifecycle_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
101 -- p_current_lifecycle_phase_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
102 -- p_current_lifecycle_phase IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
103 -- p_auto_pub_upon_creation_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
104 -- p_auto_sync_txn_date_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
105 -- p_txn_date_sync_buf_days IN NUMBER Optional Default = FND_API.G_MISS_NUM
106 -- p_record_version_number IN NUMBER Optional Default = FND_API.G_MISS_NUM
107 --bug 3325803: FP M
108 -- p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
109 -- p_schedule_third_party_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
110 -- p_third_party_schedule_code IN VARCHAR2 := FND_API.G_MISS_CHAR
111 ---p_auto_rollup_subproj_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
112 --bug 3325803: FP M
113 -- x_return_status OUT VARCHAR2 Required
114 -- x_msg_count OUT NUMBER Required
115 -- x_msg_data OUT VARCHAR2 Optional
116
117 PROCEDURE UPDATE_PROJ_WORKPLAN_ATTRS
118 ( p_api_version IN NUMBER := 1.0
119 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
120 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
121 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
122 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
123 ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
124 ,p_debug_mode IN VARCHAR2 := 'N'
125 ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
126 ,p_project_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
127 ,p_proj_element_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
128 ,p_approval_reqd_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
129 ,p_auto_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
130 ,p_approver_source_id IN NUMBER := FND_API.G_MISS_NUM
131 ,p_approver_source_type IN NUMBER := FND_API.G_MISS_NUM
132 ,p_approver_name IN VARCHAR2 := FND_API.G_MISS_CHAR
133 ,p_default_display_lvl IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
134 ,p_enable_wp_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
135 ,p_lifecycle_id IN NUMBER := FND_API.G_MISS_NUM
136 ,p_lifecycle_name IN VARCHAR2 := FND_API.G_MISS_CHAR
137 ,p_current_lifecycle_phase_id IN NUMBER := FND_API.G_MISS_NUM
138 ,p_current_lifecycle_phase IN VARCHAR2 := FND_API.G_MISS_CHAR
139 ,p_auto_pub_upon_creation_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
140 ,p_auto_sync_txn_date_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
141 ,p_txn_date_sync_buf_days IN NUMBER := FND_API.G_MISS_NUM
142 ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
143 --bug 3325803: FP M
144 ,p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
145 ,p_schedule_third_party_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
146 ,p_third_party_schedule_code IN VARCHAR2 := FND_API.G_MISS_CHAR
147 ,p_auto_rollup_subproj_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
148 --bug 3325803: FP M
149 --FP M: Workflow attributes
150 -- gboomina Bug 8586393 - start
151 ,p_use_task_schedule_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
152 -- gboomina Bug 8586393 - end
153 ,p_enable_wf_flag IN VARCHAR2 := 'N'
154 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
155 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
156 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
157 );
158
159 -- API name : Update_Structure_Name
160 -- Type : Public
161 -- Pre-reqs : None.
162 -- Parameters :
163 -- p_api_version IN NUMBER Required Default = 1.0
164 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
165 -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
166 -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
167 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
168 -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
169 -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
170 -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
171 -- p_proj_element_id IN NUMBER Required
172 -- p_structure_name IN VARCHAR2 Required
173 -- p_record_version_number IN NUMBER Optional Default = FND_API.G_MISS_NUM
174 -- x_return_status OUT VARCHAR2 Required
175 -- x_msg_count OUT NUMBER Required
176 -- x_msg_data OUT VARCHAR2 Optional
177
178 PROCEDURE UPDATE_STRUCTURE_NAME
179 ( p_api_version IN NUMBER := 1.0
180 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
181 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
182 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
183 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
184 ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
185 ,p_debug_mode IN VARCHAR2 := 'N'
186 ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
187 ,p_proj_element_id IN NUMBER
188 ,p_structure_name IN VARCHAR2
189 ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
190 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
191 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
192 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
193 );
194
195 -- API name : Delete_Proj_Workplan_Attrs
196 -- Type : Public
197 -- Pre-reqs : None.
198 -- Parameters :
199 -- p_api_version IN NUMBER Required Default = 1.0
200 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
201 -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
202 -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
203 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
204 -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
205 -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
206 -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
207 -- p_project_id IN NUMBER Required
208 -- p_proj_element_id IN NUMBER Required
209 -- p_record_version_number IN NUMBER Required Default = FND_API.G_MISS_NUM
210 -- x_return_status OUT VARCHAR2 Required
211 -- x_msg_count OUT NUMBER Required
212 -- x_msg_data OUT VARCHAR2 Optional
213
214 PROCEDURE DELETE_PROJ_WORKPLAN_ATTRS
215 ( p_api_version IN NUMBER := 1.0
216 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
217 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
218 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
219 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
220 ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
221 ,p_debug_mode IN VARCHAR2 := 'N'
222 ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
223 ,p_project_id IN NUMBER
224 ,p_proj_element_id IN NUMBER
225 ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
226 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
227 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
228 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
229 );
230
231
232 END PA_WORKPLAN_ATTR_PUB;