APPS.PA_ASSIGNMENT_PROGRESS_PUB dependencies on PA_PERCENT_COMPLETES

Line 267: -- SELECT 'X' FROM pa_percent_completes ppc

263: AND ppr2.current_flag <> 'W' -- Bug 3879461
264: AND NVL(ppr2.cbs_element_id,-1) = NVL(c_cbs_element_id,-1) -- Added for 16200605
265: -- Bug 3879461 : Not exists is not required now
266: -- AND NOT EXISTS (
267: -- SELECT 'X' FROM pa_percent_completes ppc
268: -- WHERE ppc.date_computed = ppr2.as_of_date
269: -- AND ppc.project_id = c_project_id
270: -- AND ppc.object_id = c_object_id
271: -- AND ppc.object_type = 'PA_ASSIGNMENTS'

Line 1046: delete from pa_percent_completes

1042: -- if action is SAVE then delete al the present and future working records.
1043: --there shud be only one working record.
1044: if p_action = 'SAVE'
1045: THEN
1046: delete from pa_percent_completes
1047: where project_id= p_project_id
1048: and object_id = p_object_id
1049: and published_flag = 'N'
1050: and task_id = p_task_id

Line 1072: delete from pa_percent_completes

1068: --bug 3879461
1069: --This code is required is PUBLISH mode to delete working progress records on previous dates.
1070: if p_action = 'PUBLISH' and p_structure_type = 'WORKPLAN'
1071: then
1072: delete from pa_percent_completes
1073: where project_id= p_project_id
1074: and object_id = p_object_id
1075: and published_flag = 'N'
1076: and date_computed <= p_as_of_date --bug 4247839, modified so that two records are not created for same as of date

Line 1548: UPDATE pa_percent_completes

1544: l_published_flag := 'Y';
1545: l_current_flag := 'Y';
1546: l_rollup_current_flag := 'Y'; -- Bug 3879461
1547:
1548: UPDATE pa_percent_completes
1549: SET current_flag = 'N'
1550: WHERE project_id = p_project_id
1551: --AND object_id = l_assignment_id --bug# 3764224 Changes for RLM
1552: AND object_id = l_resource_list_member_id

Line 2809: PA_PERCENT_COMPLETES_PKG.INSERT_ROW(

2805: */
2806: l_percent_complete_id := null;
2807:
2808:
2809: PA_PERCENT_COMPLETES_PKG.INSERT_ROW(
2810: p_TASK_ID => l_task_id
2811: ,p_DATE_COMPUTED => p_as_of_date
2812: ,p_LAST_UPDATE_DATE => SYSDATE
2813: ,p_LAST_UPDATED_BY => l_user_id

Line 3212: FROM pa_percent_completes

3208: --DEBUG_DJ('Out of PA_PROGRESS_UTILS.get_ppc_id 3293 || ' || l_percent_complete_id);
3209: -- FPM Dev CR 3 Getting Record Version Number too
3210: BEGIN
3211: SELECT record_version_number into l_record_version_number
3212: FROM pa_percent_completes
3213: where percent_complete_id = l_percent_complete_id;
3214: END;
3215: --DEBUG_DJ('After SELECT INTO 3313');
3216: -- FPM Dev CR 3 Getting Record Version Number too

Line 3227: PA_PERCENT_COMPLETES_PKG.UPDATE_ROW(

3223: pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'l_percent_complete_id: '||l_percent_complete_id, x_Log_Level=> 3);
3224: END IF;
3225:
3226:
3227: PA_PERCENT_COMPLETES_PKG.UPDATE_ROW(
3228: p_TASK_ID => l_task_id
3229: ,p_DATE_COMPUTED => p_as_of_date
3230: ,p_LAST_UPDATE_DATE => SYSDATE
3231: ,p_LAST_UPDATED_BY => l_user_id