APPS.PA_DELIVERABLE_PROGRESS_PUB dependencies on PA_PERCENT_COMPLETES

Line 135: l_pm_product_code pa_percent_completes.pm_product_code%TYPE ; -- FPM Dev CR 1

131: l_prog_gl_period_name VARCHAR2(30) ;
132: l_deliverable_status VARCHAR2(30) ;
133: l_deliverable_existing_status VARCHAR2(30) ;
134: l_dlvr_type_id NUMBER ;
135: l_pm_product_code pa_percent_completes.pm_product_code%TYPE ; -- FPM Dev CR 1
136: l_PROGRESS_COMMENT pa_percent_completes.progress_comment%TYPE ; -- FPM Dev CR 1
137: l_brief_overview pa_percent_completes.description%TYPE ; -- FPM Dev CR 1
138: l_progress_status_code pa_progress_rollup.progress_status_code%TYPE ; -- FPM Dev CR 3
139: l_record_version_number NUMBER ; -- FPM Dev CR 3

Line 136: l_PROGRESS_COMMENT pa_percent_completes.progress_comment%TYPE ; -- FPM Dev CR 1

132: l_deliverable_status VARCHAR2(30) ;
133: l_deliverable_existing_status VARCHAR2(30) ;
134: l_dlvr_type_id NUMBER ;
135: l_pm_product_code pa_percent_completes.pm_product_code%TYPE ; -- FPM Dev CR 1
136: l_PROGRESS_COMMENT pa_percent_completes.progress_comment%TYPE ; -- FPM Dev CR 1
137: l_brief_overview pa_percent_completes.description%TYPE ; -- FPM Dev CR 1
138: l_progress_status_code pa_progress_rollup.progress_status_code%TYPE ; -- FPM Dev CR 3
139: l_record_version_number NUMBER ; -- FPM Dev CR 3
140: --3632883

Line 137: l_brief_overview pa_percent_completes.description%TYPE ; -- FPM Dev CR 1

133: l_deliverable_existing_status VARCHAR2(30) ;
134: l_dlvr_type_id NUMBER ;
135: l_pm_product_code pa_percent_completes.pm_product_code%TYPE ; -- FPM Dev CR 1
136: l_PROGRESS_COMMENT pa_percent_completes.progress_comment%TYPE ; -- FPM Dev CR 1
137: l_brief_overview pa_percent_completes.description%TYPE ; -- FPM Dev CR 1
138: l_progress_status_code pa_progress_rollup.progress_status_code%TYPE ; -- FPM Dev CR 3
139: l_record_version_number NUMBER ; -- FPM Dev CR 3
140: --3632883
141: l_dummy VARCHAR2(3);

Line 205: delete from pa_percent_completes

201: -- if action is SAVE then delete al the present and future working records.
202: --there shud be only one working record.
203: if p_action = 'SAVE'
204: THEN
205: delete from pa_percent_completes
206: where project_id= p_project_id
207: and object_id = p_object_id
208: and published_flag = 'N'
209: and task_id = p_task_id

Line 229: delete from pa_percent_completes

225: --bug 3879461
226: --This code is required is PUBLISH mode to delete working progress records on previous dates
227: if p_action = 'PUBLISH' and p_structure_type = 'WORKPLAN'
228: then
229: delete from pa_percent_completes
230: where project_id= p_project_id
231: and object_id = p_object_id
232: and published_flag = 'N'
233: and date_computed <= p_as_of_date --bug 4247839, modified so that two records are not created for same as of date

Line 899: UPDATE pa_percent_completes

895: l_rollup_completed_percentage := l_percent_complete;
896: l_rollup_current_flag := 'Y'; -- Bug 3879461
897:
898: l_current_flag := 'Y';
899: UPDATE pa_percent_completes
900: SET current_flag = 'N'
901: WHERE project_id = p_project_id
902: AND object_id = p_object_id
903: AND current_flag = 'Y'

Line 1004: PA_PERCENT_COMPLETES_PKG.INSERT_ROW(

1000: END IF;
1001:
1002: pa_debug.write(x_Module=>'PA_DELIVERABLE_PROGRESS_PUB.UPDATE_DELIVERABLE_PROGRESS', x_Msg => 'Going to Insert in percent complete tables l_percent_complete_id='||l_percent_complete_id, x_Log_Level=> 3);
1003:
1004: PA_PERCENT_COMPLETES_PKG.INSERT_ROW(
1005: p_TASK_ID => l_task_id
1006: ,p_DATE_COMPUTED => p_as_of_date
1007: ,p_LAST_UPDATE_DATE => SYSDATE
1008: ,p_LAST_UPDATED_BY => l_user_id

Line 1401: FROM pa_percent_completes

1397: );
1398: -- FPM Dev CR 3 Getting Record Version Number too
1399: BEGIN
1400: SELECT record_version_number into l_record_version_number
1401: FROM pa_percent_completes
1402: where percent_complete_id = l_percent_complete_id;
1403: END;
1404: ELSE
1405: l_percent_complete_id := p_percent_complete_id;

Line 1414: PA_PERCENT_COMPLETES_PKG.UPDATE_ROW(

1410: pa_debug.write(x_Module=>'PA_DELIVERABLE_PROGRESS_PUB.UPDATE_DELIVERABLE_PROGRESS', x_Msg => 'Updating Percent Complete l_percent_complete_id='||l_percent_complete_id, x_Log_Level=> 3);
1411: pa_debug.write(x_Module=>'PA_DELIVERABLE_PROGRESS_PUB.UPDATE_DELIVERABLE_PROGRESS', x_Msg => 'Updating Percent Completel_record_version_number='||l_record_version_number, x_Log_Level=> 3);
1412: END IF;
1413:
1414: PA_PERCENT_COMPLETES_PKG.UPDATE_ROW(
1415: p_TASK_ID => l_task_id
1416: ,p_DATE_COMPUTED => p_as_of_date
1417: ,p_LAST_UPDATE_DATE => SYSDATE
1418: ,p_LAST_UPDATED_BY => l_user_id