APPS.PA_ASSIGNMENT_PROGRESS_PUB dependencies on PA_PERCENT_COMPLETES

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

261: AND ppr2.proj_element_id = p_task_id --bug 3861360
262: AND ppr2.current_flag <> 'W' -- Bug 3879461
263: -- Bug 3879461 : Not exists is not required now
264: -- AND NOT EXISTS (
265: -- SELECT 'X' FROM pa_percent_completes ppc
266: -- WHERE ppc.date_computed = ppr2.as_of_date
267: -- AND ppc.project_id = c_project_id
268: -- AND ppc.object_id = c_object_id
269: -- AND ppc.object_type = 'PA_ASSIGNMENTS'

Line 973: delete from pa_percent_completes

969: -- if action is SAVE then delete al the present and future working records.
970: --there shud be only one working record.
971: if p_action = 'SAVE'
972: THEN
973: delete from pa_percent_completes
974: where project_id= p_project_id
975: and object_id = p_object_id
976: and published_flag = 'N'
977: and task_id = p_task_id

Line 997: delete from pa_percent_completes

993: --bug 3879461
994: --This code is required is PUBLISH mode to delete working progress records on previous dates.
995: if p_action = 'PUBLISH' and p_structure_type = 'WORKPLAN'
996: then
997: delete from pa_percent_completes
998: where project_id= p_project_id
999: and object_id = p_object_id
1000: and published_flag = 'N'
1001: and date_computed <= p_as_of_date --bug 4247839, modified so that two records are not created for same as of date

Line 1438: UPDATE pa_percent_completes

1434: l_published_flag := 'Y';
1435: l_current_flag := 'Y';
1436: l_rollup_current_flag := 'Y'; -- Bug 3879461
1437:
1438: UPDATE pa_percent_completes
1439: SET current_flag = 'N'
1440: WHERE project_id = p_project_id
1441: --AND object_id = l_assignment_id --bug# 3764224 Changes for RLM
1442: AND object_id = l_resource_list_member_id

Line 2687: PA_PERCENT_COMPLETES_PKG.INSERT_ROW(

2683: */
2684: l_percent_complete_id := null;
2685:
2686:
2687: PA_PERCENT_COMPLETES_PKG.INSERT_ROW(
2688: p_TASK_ID => l_task_id
2689: ,p_DATE_COMPUTED => p_as_of_date
2690: ,p_LAST_UPDATE_DATE => SYSDATE
2691: ,p_LAST_UPDATED_BY => l_user_id

Line 3082: FROM pa_percent_completes

3078: );
3079: -- FPM Dev CR 3 Getting Record Version Number too
3080: BEGIN
3081: SELECT record_version_number into l_record_version_number
3082: FROM pa_percent_completes
3083: where percent_complete_id = l_percent_complete_id;
3084: END;
3085:
3086: -- ELSE

Line 3096: PA_PERCENT_COMPLETES_PKG.UPDATE_ROW(

3092: 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);
3093: END IF;
3094:
3095:
3096: PA_PERCENT_COMPLETES_PKG.UPDATE_ROW(
3097: p_TASK_ID => l_task_id
3098: ,p_DATE_COMPUTED => p_as_of_date
3099: ,p_LAST_UPDATE_DATE => SYSDATE
3100: ,p_LAST_UPDATED_BY => l_user_id