APPS.PA_DELIVERABLE_PROGRESS_PUB dependencies on PA_PERCENT_COMPLETES

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

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

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

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

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

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

Line 204: delete from pa_percent_completes

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

Line 228: delete from pa_percent_completes

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

Line 868: UPDATE pa_percent_completes

864: l_rollup_completed_percentage := l_percent_complete;
865: l_rollup_current_flag := 'Y'; -- Bug 3879461
866:
867: l_current_flag := 'Y';
868: UPDATE pa_percent_completes
869: SET current_flag = 'N'
870: WHERE project_id = p_project_id
871: AND object_id = p_object_id
872: AND current_flag = 'Y'

Line 973: PA_PERCENT_COMPLETES_PKG.INSERT_ROW(

969: END IF;
970:
971: 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);
972:
973: PA_PERCENT_COMPLETES_PKG.INSERT_ROW(
974: p_TASK_ID => l_task_id
975: ,p_DATE_COMPUTED => p_as_of_date
976: ,p_LAST_UPDATE_DATE => SYSDATE
977: ,p_LAST_UPDATED_BY => l_user_id

Line 1370: FROM pa_percent_completes

1366: );
1367: -- FPM Dev CR 3 Getting Record Version Number too
1368: BEGIN
1369: SELECT record_version_number into l_record_version_number
1370: FROM pa_percent_completes
1371: where percent_complete_id = l_percent_complete_id;
1372: END;
1373: ELSE
1374: l_percent_complete_id := p_percent_complete_id;

Line 1383: PA_PERCENT_COMPLETES_PKG.UPDATE_ROW(

1379: 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);
1380: 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);
1381: END IF;
1382:
1383: PA_PERCENT_COMPLETES_PKG.UPDATE_ROW(
1384: p_TASK_ID => l_task_id
1385: ,p_DATE_COMPUTED => p_as_of_date
1386: ,p_LAST_UPDATE_DATE => SYSDATE
1387: ,p_LAST_UPDATED_BY => l_user_id