1 package PA_PROGRESS_PUB AUTHID CURRENT_USER as
2 /* $Header: PAPCPUBS.pls 120.6.12020000.4 2013/03/28 12:10:03 bpottipa ship $ */
3
4 g_wbs_apply_prog number := null;
5
6 -- added below two global variables for bug 13923366 Huawei by skkoppul
7 G_IS_WP_VERSION_ENABLED VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
8 G_STRUCTURE_SHARING_CODE VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
9 G_PROJECT_ID NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
10 G_STRUC_ELEMENT_ID NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
11
12 -- Bug 3606627 : Changed Defaulting to g_miss_xxx instead of null
13 TYPE PA_TASK_PROGRESS_LIST_REC_TYPE IS RECORD
14 (
15 TASK_ID NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
16 TASK_NAME VARCHAR2(20) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
17 TASK_NUMBER VARCHAR2(25) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
18 PM_TASK_REFERENCE VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
19 PERCENT_COMPLETE NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
20 DESCRIPTION VARCHAR2(250) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
21 OBJECT_ID NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
22 OBJECT_VERSION_ID NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
23 OBJECT_TYPE VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
24 PROGRESS_STATUS_CODE VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
25 PROGRESS_COMMENT VARCHAR2(4000) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
26 ACTUAL_START_DATE Date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
27 ACTUAL_FINISH_DATE Date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
28 ESTIMATED_START_DATE Date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
29 ESTIMATED_FINISH_DATE Date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
30 SCHEDULED_START_DATE Date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
31 SCHEDULED_FINISH_DATE Date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
32 TASK_STATUS VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
33 EST_REMAINING_EFFORT NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
34 ACTUAL_WORK_QUANTITY NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
35 LOWEST_LEVEL_TASK VARCHAR2(1) := 'N',
36 LATEST_AS_OF_DATE Date := NULL,
37 PROGRESS_MODE VARCHAR2(30) := 'N',
38 ETC_COST NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, /* FP M task progress bug 3420093 */
39 PM_DELIVERABLE_REFERENCE VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR, -- Bug 3606627
40 PM_TASK_ASSGN_REFERENCE VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR, -- Bug 3606627
41 ACTUAL_COST_TO_DATE NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, -- Bug 3606627
42 ACTUAL_EFFORT_TO_DATE NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3606627
43 );
44
45 TYPE PA_TASK_PROGRESS_LIST_TBL_TYPE IS TABLE OF PA_TASK_PROGRESS_LIST_REC_TYPE
46 INDEX BY BINARY_INTEGER;
47
48 -- Progress Management Change for bug # 3420093.
49
50 TYPE PA_NUM_1000_NUM IS VARRAY(1000) OF NUMBER;
51
52 PROCEDURE UPDATE_TASK_PROGRESS(
53 p_api_version IN NUMBER :=1.0 ,
54 p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE ,
55 p_commit IN VARCHAR2 :=FND_API.G_FALSE ,
56 p_validate_only IN VARCHAR2 :=FND_API.G_TRUE ,
57 p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL ,
58 p_calling_module IN VARCHAR2 :='SELF_SERVICE' ,
59 p_calling_mode IN VARCHAR2 := null ,
60 p_debug_mode IN VARCHAR2 :='N' ,
61 p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
62 p_action IN VARCHAR2 default 'SAVE' ,
63 p_bulk_load_flag IN VARCHAR2 default 'N' ,
64 p_progress_mode IN VARCHAR2 default 'FUTURE' ,
65 p_percent_complete_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
66 p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
67 p_object_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
68 p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
69 p_object_type IN Varchar2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
70 p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
71 p_percent_complete IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
72 p_progress_status_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
73 p_progress_comment IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
74 p_brief_overview IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
75 p_actual_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
76 p_actual_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
77 p_estimated_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
78 p_estimated_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
79 p_scheduled_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
80 p_scheduled_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
81 p_record_version_number IN NUMBER ,
82 p_task_status IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
83 p_est_remaining_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
84 p_actual_work_quantity IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
85 p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
86 p_structure_type IN VARCHAR2 := 'WORKPLAN' ,
87 p_actual_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
88 p_actual_effort_this_period IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
89 p_prog_fom_wp_flag IN VARCHAR2 := 'N' ,
90 p_planned_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
91 p_planned_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
92 p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
93 p_eff_rollup_percent_complete IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , -- 3910193
94 x_resource_list_member_id OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
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
100 -- Start of comments
101 -- API name : ROLLUP_PROGRESS_PVT
102 -- Type : Public
103 -- Pre-reqs : For Program Rollup, the sub project buckets should be populated.
104 -- Purpose : Rolls up the structure
105 -- Parameters Desc :
106 -- P_OBJECT_TYPE Possible values PA_ASSIGNMENTS, PA_DELIVERABLES, PA_TASKS
107 -- P_OBJECT_ID For assignments, pass resource_assignment_id, otherwise
108 -- proj_element_id of the deliverable and task
109 -- p_object_version_id For Assignments, pass task_version_id, otherwise
110 -- element_version_id of the deliverable and task
111 -- p_task_version_id For tasks, assignments, deliverables pass the task version id
112 -- , for struture pass null
113 -- p_lowest_level_task Does not seem to be required
114 -- p_process_whole_tree To indicate if whole tree rollup is not required. It will
115 -- do just 2 level rollup if N
116 -- p_structure_version_id Structure version id of the publsihed or working structure version
117 -- p_structure_type Possible values WORKPLAN, FINANCIAL
118 -- p_fin_rollup_method Possible values are COST, EFFORT
119 -- p_wp_rollup_method Possible values are COST, EFFORT, MANUAL, DURATION
120 -- p_rollup_entire_wbs To indicate if it requires the whole structure rollup, in this
121 -- case it will ignore the passed object and starts with the lowest
122 -- task
123 -- History : 17-MAR-04 amksingh Rewritten For FPM Development Tracking Bug 3420093
124 -- End of comments
125
126 PROCEDURE ROLLUP_PROGRESS_PVT(
127 p_api_version IN NUMBER :=1.0
128 ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
129 ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
130 ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
131 ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
132 ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
133 ,p_debug_mode IN VARCHAR2 :='N'
134 ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
135 ,p_progress_mode IN VARCHAR2 := 'FUTURE'
136 ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
137 ,p_object_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
138 ,p_object_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
139 ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
140 ,p_task_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
141 ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
142 ,p_lowest_level_task IN VARCHAR2 := 'N'
143 ,p_process_whole_tree IN VARCHAR2 := 'Y'
144 ,p_structure_version_id IN NUMBER
145 ,p_structure_type IN VARCHAR2 := 'WORKPLAN'
146 ,p_fin_rollup_method IN VARCHAR2 := 'COST'
147 ,p_wp_rollup_method IN VARCHAR2 := 'COST'
148 ,p_rollup_entire_wbs IN VARCHAR2 := 'N'
149 ,p_working_wp_prog_flag IN VARCHAR2 := 'N' --maansari7/18 to be passed form apply lp progress to select regular planned amounts to send to schduling api for percent comnplete and earned value calculations.
150 ,p_upd_new_elem_ver_id_flag IN VARCHAR2 := 'Y' -- rtarway, for BUG 3951024
151 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
152 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
153 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
154 );
155
156 -- Start of comments
157 -- API name : UPDATE_ROLLUP_PROGRESS_PVT
158 -- Type : Private
159 -- Pre-reqs : ROLLUP_PROGRESS_PVT shd have been called.
160 -- Purpose : Updates the Rolled up data
161 -- Parameters Desc :
162 -- P_OBJECT_TYPE Possible values PA_ASSIGNMENTS, PA_DELIVERABLES, PA_TASKS
163 -- P_OBJECT_ID For assignments, pass resource_assignment_id, otherwise
164 -- proj_element_id of the deliverable and task
165 -- p_object_version_id For Assignments, pass task_version_id, otherwise
166 -- element_version_id of the deliverable and task
167 -- p_task_version_id For tasks, assignments, deliverables pass the task version id
168 -- , for struture pass null
169 -- p_lowest_level_task Does not seem to be required
170 -- p_structure_version_id Structure version id of the publsihed or working structure version
171 -- p_structure_type Possible values WORKPLAN, FINANCIAL
172 -- p_fin_rollup_method Possible values are COST, EFFORT
173 -- p_wp_rollup_method Possible values are COST, EFFORT, MANUAL, DURATION
174 -- p_published_structure To indicate if the passed structure version is published
175 -- History : 17-MAR-04 amksingh Rewritten For FPM Development Tracking Bug 3420093
176 -- End of comments
177
178 PROCEDURE UPDATE_ROLLUP_PROGRESS_PVT(
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 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
187 ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
188 ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
189 ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
190 ,p_rollup_table IN PA_SCHEDULE_OBJECTS_PVT.PA_SCHEDULE_OBJECTS_TBL_TYPE
191 ,p_lowest_level_task IN VARCHAR2 := 'N'
192 ,p_task_version_id IN NUMBER
193 ,p_structure_version_id IN NUMBER
194 ,p_structure_type IN VARCHAR2 := 'WORKPLAN'
195 ,p_fin_rollup_method IN VARCHAR2 := 'COST'
196 ,p_wp_rollup_method IN VARCHAR2 := 'COST'
197 ,p_published_structure IN VARCHAR2
198 ,p_rollup_entire_wbs IN VARCHAR2 := 'N' -- FPM Dev CR 7
199 ,p_working_wp_prog_flag IN VARCHAR2 := 'N' --bug 3829341
200 ,p_upd_new_elem_ver_id_flag IN VARCHAR2 := 'Y' -- rtarway, for BUG 3951024
201 ,p_progress_mode IN VARCHAR2 := 'FUTURE' -- 4091457
202 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
203 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
204 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
205 );
206
207 PROCEDURE CREATE_PROJ_PROG_ATTR(
208 p_api_version IN NUMBER :=1.0
209 ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
210 ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
211 ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
212 ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
213 ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
214 ,p_debug_mode IN VARCHAR2 :='N'
215 ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
216 ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
217 ,P_OBJECT_TYPE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
218 ,P_OBJECT_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
219 ,P_PROGRESS_CYCLE_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
220 ,P_WQ_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
221 ,P_REMAIN_EFFORT_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
222 ,P_PERCENT_COMP_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
223 ,P_NEXT_PROGRESS_UPDATE_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
224 ,p_action_set_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
225 ,p_TASK_WEIGHT_BASIS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
226 ,X_PROJ_PROGRESS_ATTR_ID IN OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
227 ,P_ALLOW_COLLAB_PROG_ENTRY IN VARCHAR2 := 'N'
228 ,P_ALLW_PHY_PRCNT_CMP_OVERRIDES IN VARCHAR2 := 'N'
229 ,P_STRUCTURE_TYPE IN VARCHAR2 := 'WORKPLAN'
230 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
231 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
232 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
233
234 );
235
236 PROCEDURE UPDATE_PROJ_PROG_ATTR(
237 p_api_version IN NUMBER :=1.0
238 ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
239 ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
240 ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
241 ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
242 ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
243 ,p_debug_mode IN VARCHAR2 :='N'
244 ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
245 ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
246 ,P_OBJECT_TYPE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
247 ,P_OBJECT_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
248 ,P_PROGRESS_CYCLE_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
249 ,P_WQ_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
250 ,P_REMAIN_EFFORT_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
251 ,P_PERCENT_COMP_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
252 ,P_NEXT_PROGRESS_UPDATE_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
253 ,p_action_set_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
254 ,p_TASK_WEIGHT_BASIS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
255 ,P_PROJ_PROGRESS_ATTR_ID IN NUMBER
256 ,p_record_version_number IN NUMBER
257 ,p_allow_collab_prog_entry IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
258 ,p_allw_phy_prcnt_cmp_overrides IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
259 ,p_structure_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
260 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
261 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
262 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
263 );
264
265 PROCEDURE DELETE_PROJ_PROG_ATTR(
266 p_api_version IN NUMBER :=1.0
267 ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
268 ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
269 ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
270 ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
271 ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
272 ,p_debug_mode IN VARCHAR2 :='N'
273 ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
274 ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
275 ,P_OBJECT_TYPE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
276 ,P_OBJECT_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
277 ,p_structure_type IN VARCHAR2 := 'WORKPLAN' -- Amit
278 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
279 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
280 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
281 );
282
283 PROCEDURE delete_progress_record(
284 p_api_version IN NUMBER :=1.0
285 ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
286 ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
287 ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
288 ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
289 ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
290 ,p_debug_mode IN VARCHAR2 :='N'
291 ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
292 ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
293 ,p_task_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
294 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
295 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
296 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
297 );
298
299 PROCEDURE push_down_task_status(
300 p_api_version IN NUMBER :=1.0
301 ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
302 ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
303 ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
304 ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
305 ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
306 ,p_debug_mode IN VARCHAR2 :='N'
307 ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
308 ,p_task_status IN VARCHAR2
309 ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
310 ,p_object_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
311 ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
312 ,p_object_type IN Varchar2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
313 ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
314 ,p_actual_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
315 ,p_structure_type IN VARCHAR2 := 'WORKPLAN'
316 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
317 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
318 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
319 );
320
321 PROCEDURE ROLLUP_FUTURE_PROGRESS_PVT(
322 p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
323 ,P_OBJECT_TYPE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
324 ,P_OBJECT_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
325 ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
326 ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
327 ,p_lowest_level_task IN VARCHAR2 := 'N'
328 ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
329 ,p_structure_type IN VARCHAR2 := 'WORKPLAN'
330 ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
331 ,p_fin_rollup_method IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
332 ,p_wp_rollup_method IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
333 ,p_rollup_entire_wbs IN VARCHAR2 := 'N' -- Bug 3606627
334 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
335 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
336 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
337 );
338
339 -- Update_PC_PARTY_MAERGE (PUBLIC)
340 -- This is the procedure being called during the Party Merge.
341 -- The input/output arguments format matches the document PartyMergeDD.doc.
342 -- The goal is to fix the PUBLISHED_BY_PARTY_ID in pa_percent_completes table to point to the
343 -- same party when two similar parties are begin merged.
344 --
345 -- Usage example in pl/sql
346 -- This procedure should only be called from the PartyMerge utility.
347 --
348 procedure Update_PC_PARTY_MERGE(p_entity_name in varchar2,
349 p_from_id in number,
350 p_to_id in out nocopy number,
351 p_from_fk_id in number,
352 p_to_fk_id in number,
353 p_parent_entity_name in varchar2,
354 p_batch_id in number,
355 p_batch_party_id in number,
356 p_return_status in out nocopy varchar2);
357
358 -- Progress Management Changes. Bug # 3420093.
359
360 PROCEDURE apply_lp_prog_on_cwv(
361 p_api_version IN NUMBER :=1.0
362 ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
363 ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
364 ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
365 ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
366 ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
367 ,p_debug_mode IN VARCHAR2 :='N'
368 ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
369 ,p_project_id IN NUMBER
370 ,p_working_str_version_id IN NUMBER
371 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
372 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
373 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
374 );
375
376 -- Progress Management Changes. Bug # 3420093.
377
378 PROCEDURE delete_working_wp_progress(
379 p_api_version IN NUMBER :=1.0
380 ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
381 ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
382 ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
383 ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
384 ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
385 ,p_debug_mode IN VARCHAR2 :='N'
386 ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
387 ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
388 ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
389 ,p_task_version_id IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type()
390 ,p_calling_context IN VARCHAR2 := 'STRUCTURE_VERSION'
391 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
392 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
393 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
394 );
395
396 -- Progress Management Changes. Bug # 3420093.
397
398 Procedure PULL_SUMMARIZED_ACTUALS (
399 p_api_version IN NUMBER :=1.0
400 ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
401 ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
402 ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
403 ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
404 ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
405 ,p_debug_mode IN VARCHAR2 :='N'
406 ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
407 ,P_Project_ID IN NUMBER
408 ,P_Calling_Mode IN VARCHAR2
409 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
410 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
411 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
412 );
413
414 -- Progress Management Changes. Bug # 3420093.
415
416 PROCEDURE update_progress(
417 p_api_version IN NUMBER :=1.0
418 ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
419 ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
420 ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
421 ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
422 ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
423 ,p_debug_mode IN VARCHAR2 :='N'
424 ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
425 ,p_action IN VARCHAR2 :='SAVE'
426 ,P_rollup_entire_wbs_flag IN VARCHAR2 :='N'
427 ,p_progress_mode IN VARCHAR2 :='FUTURE'
428 ,p_percent_complete_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
429 ,p_project_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
430 ,p_object_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
431 ,p_object_version_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
432 ,p_object_type IN VARCHAR2 :='PA_TASKS'
433 ,p_as_of_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
434 ,p_percent_complete IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
435 ,p_progress_status_code IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
436 ,p_progress_comment IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
437 ,p_brief_overview IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
438 ,p_actual_start_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
439 ,p_actual_finish_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
440 ,p_estimated_start_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
441 ,p_estimated_finish_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
442 ,p_scheduled_start_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
443 ,p_scheduled_finish_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
444 ,p_record_version_number IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
445 ,p_task_status IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
446 ,p_est_remaining_effort IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
447 ,p_ETC_cost IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
448 ,p_actual_work_quantity IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
449 ,p_pm_product_code IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
450 ,p_structure_type IN VARCHAR2 :='WORKPLAN'
451 ,p_actual_effort IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
452 ,p_actual_cost IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
453 ,p_actual_effort_this_period IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
454 ,p_actual_cost_this_period IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
455 ,p_object_sub_type IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
456 ,p_task_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
457 ,p_structure_version_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
458 ,p_prog_fom_wp_flag IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
459 ,p_rollup_reporting_lines_flag IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
460 ,p_planned_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
461 ,p_planned_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
462 ,p_rate_based_flag IN VARCHAR := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
463 ,p_resource_class_code IN VARCHAR := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
464 ,p_transfer_wp_pc_flag IN VARCHAR := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
465 ,p_txn_currency_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
466 ,p_rbs_element_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
467 -- ,p_resource_list_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3764224
468 ,p_resource_assignment_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3764224
469 ,p_eff_rollup_percent_complete IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- 3910193
470 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
471 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
472 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
473 );
474
475 -- Progress Management Changes. Bug # 3420093.
476
477 PROCEDURE populate_pji_tab_for_plan(
478 p_api_version IN NUMBER :=1.0
479 ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
480 ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
481 ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
482 ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
483 ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
484 ,p_debug_mode IN VARCHAR2 :='N'
485 ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
486 ,p_project_id IN NUMBER
487 ,p_project_element_id IN NUMBER DEFAULT NULL --bug 4183307
488 ,p_structure_version_id IN NUMBER DEFAULT NULL
489 ,p_baselined_str_ver_id IN NUMBER DEFAULT NULL
490 ,p_structure_type IN VARCHAR2 := 'WORKPLAN' -- Bug 3627315
491 ,p_populate_tmp_tab_flag IN VARCHAR2 := 'Y' --bug 4290593
492 ,p_program_rollup_flag IN VARCHAR2 := 'Y' --bug 4392189
493 ,p_calling_context IN VARCHAR2 := 'ROLLUP' -- bug 4392189 , Possible values are ROLLUP and SUMMARIZE
494 ,p_as_of_date IN DATE := null -- bug 4392189
495 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
496 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
497 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
498 );
499
500 PROCEDURE push_workplan_actuals(
501 p_api_version IN NUMBER :=1.0
502 ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
503 ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
504 ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
505 ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
506 ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
507 ,p_debug_mode IN VARCHAR2 :='N'
508 ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
509 ,p_project_Id NUMBER
510 ,p_structure_version_id NUMBER
511 ,p_proj_element_id NUMBER
512 ,p_object_id NUMBER
513 ,p_object_type VARCHAR2
514 ,p_as_of_date DATE
515 ,p_resource_assignment_id NUMBER :=null -- Bug 4186007
516 ,p_resource_list_member_id NUMBER :=null-- Bug 4186007
517 ,p_rbs_element_id NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
518 ,p_rate_based_flag VARCHAR2 := 'Y' -- Default for Task
519 ,p_resource_class_code VARCHAR2 :='PEOPLE' -- Default for Task
520 -- ,p_TXN_CURRENCY_CODE VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Bug 3595585 Removed not needed
521 ,p_act_TXN_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
522 ,p_act_PRJ_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
523 ,p_act_POU_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
524 ,p_act_effort_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
525 ,p_etc_TXN_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM-- Bug 3595585
526 ,p_etc_PRJ_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM-- Bug 3595585
527 ,p_etc_POU_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM-- Bug 3595585
528 ,p_etc_effort_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM-- Bug 3595585
529 ,p_call_pji_apis_flag VARCHAR2 := 'Y'
530 ,p_act_TXN_raw_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3621404
531 ,p_act_PRJ_raw_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3621404
532 ,p_act_POU_raw_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3621404
533 ,p_etc_TXN_raw_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3621404
534 ,p_etc_PRJ_raw_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3621404
535 ,p_etc_POU_raw_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3621404
536 -- BUG # 3659659.
537 ,p_txn_currency_code VARCHAR2 := null
538 ,p_prj_currency_code VARCHAR2 := null
539 ,p_pfn_currency_code VARCHAR2 := null
540 -- BUG # 3659659.
541 --bug3675107
542 ,p_pa_period_name VARCHAR2 :=null
543 ,p_gl_period_name VARCHAR2 :=null
544 --bug3675107
545 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
546 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
547 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
548 ,p_cbs_element_id NUMBER := null -- Added for CBS phase 2 16200605
549 );
550
551 -- Progress Management Change for bug # 3420093.
552
553 PROCEDURE program_rollup_pvt(
554 p_api_version IN NUMBER :=1.0
555 ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
556 ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
557 ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
558 ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
559 ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
560 ,p_debug_mode IN VARCHAR2 :='N'
561 ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
562 ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
563 ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
564 ,p_structure_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
565 ,p_structure_ver_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
566 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
567 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
568 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
569 );
570
571 PROCEDURE transfer_wp_percent_to_fin(
572 p_api_version IN NUMBER :=1.0
573 ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
574 ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
575 ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
576 ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
577 ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
578 ,p_debug_mode IN VARCHAR2 :='N'
579 ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
580 ,p_project_id IN NUMBER
581 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
582 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
583 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
584 );
585
586 PROCEDURE publish_progress(
587 p_api_version IN NUMBER :=1.0
588 ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
589 ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
590 ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
591 ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
592 ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
593 ,p_debug_mode IN VARCHAR2 :='N'
594 ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
595 ,p_project_id IN NUMBER
596 ,p_working_str_ver_id IN NUMBER -- Bug 4190086
597 ,p_pub_structure_version_id IN NUMBER -- Bug 3839288
598 ,x_upd_new_elem_ver_id_flag OUT NOCOPY VARCHAR2 -- BUG 3951024, rtarway --File.Sql.39 bug 4440895
599 ,x_as_of_date OUT NOCOPY DATE -- Bug 3839288 --File.Sql.39 bug 4440895
600 ,x_task_weight_basis_code OUT NOCOPY VARCHAR2 -- Bug 3839288 --File.Sql.39 bug 4440895
601 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
602 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
603 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
604 );
605
606 PROCEDURE GET_SUMMARIZED_ACTUALS(p_project_id_list IN SYSTEM.pa_num_tbl_type,
607 p_extraction_type IN VARCHAR2,
608 p_plan_res_level IN VARCHAR2,
609 p_proj_pgm_level IN SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type(),
610 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
611 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
612 x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
613 -- Start of comments
614 -- API name : UPDATE_FINANCIAL_TASK_PROGRESS
615 -- Type : Public
616 -- Purpose : Updates Financial Percent Complete
617 -- Parameters Desc :
618 -- p_object_type PA_TASKS
619 -- p_as_of_date The as_of_date for which progress to be entered
620 -- p_object_version_id The task version id
621 -- p_structure_version_id Structure version id of the publsihed or working structure version
622 -- p_progress_comment Progress comment
623 -- p_brief_overview Brief Overview
624 -- p_structure_type FINANCIAL
625 -- p_rollup_entire_wbs To indicate if it requires the whole structure rollup, in this
626 -- case it will ignore the passed object and starts with the lowest
627 -- task
628 -- History : 29-MAR-04 sdnambia Written For FPM Development Tracking Bug 3420093
629 -- End of comments
630
631 -- FPM Dev CR 1 : Added Following Procedure
632 PROCEDURE UPDATE_FINANCIAL_TASK_PROGRESS(
633 p_api_version IN NUMBER :=1.0
634 ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
635 ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
636 ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
637 ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
638 ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
639 ,p_debug_mode IN VARCHAR2 :='N'
640 ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
641 ,p_action IN VARCHAR2 :='SAVE'
642 ,P_rollup_entire_wbs_flag IN VARCHAR2 :='N'
643 ,p_progress_mode IN VARCHAR2 :='FUTURE'
644 ,p_percent_complete_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
645 ,p_project_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
646 ,p_object_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
647 ,p_object_version_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
648 ,p_object_type IN VARCHAR2 :='PA_TASKS'
649 ,p_as_of_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
650 ,p_percent_complete IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
651 ,p_progress_status_code IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
652 ,p_progress_comment IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
653 ,p_brief_overview IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
654 ,p_record_version_number IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
655 ,p_pm_product_code IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
656 ,p_structure_type IN VARCHAR2 :='FINANCIAL'
657 ,p_task_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
658 ,p_structure_version_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
659 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
660 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
661 ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
662
663 -- Progress Management Changes. Bug # 3420093.
664
665 PROCEDURE re_rollup_progress(
666 p_api_version IN NUMBER :=1.0
667 ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
668 ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
669 ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
670 ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
671 ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
672 ,p_debug_mode IN VARCHAR2 :='N'
673 ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
674 ,p_project_id IN NUMBER
675 ,p_structure_version_id IN NUMBER
676 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
677 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
678 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
679 );
680
681 -- Bug 3633293 : Added populate_bulk_pji_tab_for_plan
682 PROCEDURE populate_bulk_pji_tab_for_plan(
683 p_api_version IN NUMBER :=1.0
684 ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
685 ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
686 ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
687 ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
688 ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
689 ,p_debug_mode IN VARCHAR2 :='N'
690 ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
691 ,p_person_id NUMBER
692 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
693 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
694 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
695 );
696
697 -- Start of comments
698 -- API name : ASGN_DLV_TO_TASK_ROLLUP_PVT
699 -- Type : Private
700 -- Pre-reqs : None.
701 -- Purpose : This API is intdended to be called for Assignment, Deliverables in Task Progress Details page when user clicks Recalculate button
702 -- : This does partial rollup of working progress records
703 -- History : 15-JUNE-04 amksingh Rewritten For FPM Development Bug 3614828
704 -- End of comments
705
706 PROCEDURE ASGN_DLV_TO_TASK_ROLLUP_PVT(
707 p_api_version IN NUMBER :=1.0
708 ,p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE -- Since it is a private API so false
709 ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
710 ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
711 ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
712 ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
713 ,p_debug_mode IN VARCHAR2 :='N'
714 ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
715 ,p_project_id IN NUMBER
716 ,p_task_id IN NUMBER
717 ,p_task_version_id IN NUMBER
718 ,p_as_of_date IN DATE
719 ,p_structure_version_id IN NUMBER
720 ,p_wp_rollup_method IN VARCHAR2 := 'COST'
721 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
722 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
723 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
724 );
725
726 -- Start of comments
727 -- API name : COPY_PROGRESS_ACT_ETC
728 -- Type : Private
729 -- Pre-reqs : None.
730 -- Purpose : This API is intdended to be used for copying actuals and etc from one structure
731 -- version to another. If there is no progress records exists then the api pass null
732 -- for act and etc.
733 -- History : 30-JUNE-04 Rakesh Raghavan Rewritten For FPM Development Bug
734 -- 28-JUL-2004 Rakesh Raghavan Added parameter: p_last_pub_str_version_id.
735 -- End of comments
736
737 PROCEDURE COPY_PROGRESS_ACT_ETC(
738 p_api_version IN NUMBER :=1.0
739 ,p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE -- FALSE for private API.
740 ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
741 ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
742 ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
743 ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
744 ,p_debug_mode IN VARCHAR2 :='N'
745 ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
746 ,p_project_id IN NUMBER
747 ,p_src_str_ver_id IN NUMBER
748 ,p_dst_str_ver_id IN NUMBER
749 ,p_pub_wp_with_prog_flag IN VARCHAR2 := 'Y'
750 ,p_calling_context IN VARCHAR2 := 'PUBLISH'
751 ,p_last_pub_str_version_id IN NUMBER := NULL
752 ,p_copy_actuals_flag IN VARCHAR2 := 'Y'
753 ,p_copy_ETC_flag IN VARCHAR2 := 'Y'
754 ,p_pji_conc_prog_context IN VARCHAR2 := 'N' -- Fix for Bug # 3996159.
755 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
756 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
757 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
758 );
759
760 -- Bug 3807299 : new API which will be called from update_progress and AMG pa_status_pub.update_progress
761 PROCEDURE update_link_proj_rollup_dates(
762 p_api_version IN NUMBER :=1.0
763 ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
764 ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
765 ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
766 ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
767 ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
768 ,p_project_id IN NUMBER
769 ,p_task_id IN NUMBER
770 ,p_task_version_id IN NUMBER
771 ,p_as_of_date IN DATE
772 ,p_structure_version_id IN NUMBER
773 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
774 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
775 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
776 );
777
778 PROCEDURE UPDATE_PROGRESS_BULK(
779 p_api_version IN NUMBER :=1.0
780 ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
781 ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
782 ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
783 ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
784 ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
785 ,p_calling_mode IN VARCHAR2 := null
786 ,p_debug_mode IN VARCHAR2 :='N'
787 ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
788 ,p_action IN VARCHAR2 :='SAVE'
789 ,p_rollup_entire_wbs_flag IN VARCHAR2 :='N'
790 ,p_progress_mode IN VARCHAR2 :='FUTURE'
791 ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
792 ,p_structure_type IN VARCHAR2 := 'WORKPLAN'
793 ,p_project_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
794 ,p_object_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
795 ,p_object_version_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
796 ,p_object_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type()
797 ,p_task_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
798 ,p_structure_version_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
799 ,p_as_of_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
800 ,p_rbs_element_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
801 ,p_resource_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
802 ,p_rate_based_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type()
803 ,p_resource_class_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type()
804 ,p_txn_currency_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type()
805 ,p_percent_complete_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
806 ,p_record_version_number_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
807 ,p_percent_complete_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
808 ,p_eff_rup_percent_complete_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
809 ,p_task_status_tbl IN SYSTEM.pa_varchar2_150_tbl_type := SYSTEM.pa_varchar2_150_tbl_type()
810 ,p_progress_status_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type()
811 ,p_progress_comment_tbl IN SYSTEM.pa_varchar2_4000_tbl_type2 := SYSTEM.pa_varchar2_4000_tbl_type2()
812 ,p_brief_overview_tbl IN SYSTEM.pa_varchar2_250_tbl_type := SYSTEM.pa_varchar2_250_tbl_type()
813 ,p_actual_start_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
814 ,p_actual_finish_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
815 ,p_estimated_start_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
816 ,p_estimated_finish_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
817 ,p_scheduled_start_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
818 ,p_scheduled_finish_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
819 ,p_est_remaining_effort_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
820 ,p_etc_cost_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
821 ,p_actual_work_quantity_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
822 ,p_actual_effort_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
823 ,p_actual_cost_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
824 ,p_act_eff_this_period_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
825 ,p_actual_cost_this_period_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
826 ,p_planned_cost_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
827 ,p_planned_effort_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
828 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
829 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
830 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
831 );
832
833 -- Begin fix for Bug # 4262985.
834
835 PROCEDURE apply_lp_prog_on_cwv_wrp(
836 p_api_version IN NUMBER :=1.0
837 ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
838 ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
839 ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
840 ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
841 ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
842 ,p_debug_mode IN VARCHAR2 :='N'
843 ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
844 ,p_project_id IN NUMBER
845 ,p_working_str_version_id IN NUMBER
846 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
847 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
848 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
849 );
850
851 -- End fix for Bug # 4262985.
852
853 end PA_PROGRESS_PUB;