eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_DELIVERABLE_PROGRESS_PUB dependencies on PA_PROGRESS_ROLLUP

Line 137: l_progress_status_code pa_progress_rollup.progress_status_code%TYPE ; -- FPM Dev CR 3

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);
141: l_rollup_current_flag VARCHAR2(1); -- Bug 3879461

Line 212: delete from pa_progress_rollup

208: and task_id = p_task_id
209: and structure_type = p_structure_type
210: ;
211:
212: delete from pa_progress_rollup
213: where project_id= p_project_id
214: and object_id = p_object_id
215: and current_flag = 'W'
216: and proj_element_id = p_task_id

Line 236: delete from pa_progress_rollup

232: and date_computed <= p_as_of_date --bug 4247839, modified so that two records are not created for same as of date
233: and structure_type = p_structure_type
234: ;
235:
236: delete from pa_progress_rollup
237: where project_id= p_project_id
238: and object_id = p_object_id
239: and current_flag = 'W'
240: and as_of_date < p_as_of_date

Line 876: UPDATE pa_progress_rollup

872: AND current_flag = 'Y'
873: AND object_type = p_object_type
874: AND structure_type = p_structure_type;
875:
876: UPDATE pa_progress_rollup
877: SET current_flag = 'N'
878: WHERE project_id = p_project_id
879: AND object_id = p_object_id
880: AND current_flag = 'Y'

Line 890: DELETE FROM pa_progress_rollup

886: -- This case would not be possible for Deliverable, but still code is there to make it in sycn with Assignments Case
887: -- IF l_db_action = 'UPDATE' THEN -- Commented to fix Bug # 3958892.
888: /*
889: -- Delete the published progress record on the same as of date
890: DELETE FROM pa_progress_rollup
891: where project_id = p_project_id
892: and object_id = p_object_id
893: and object_type = p_object_type
894: and structure_version_id is null

Line 899: from pa_progress_rollup

895: and structure_type = 'WORKPLAN'
896: and current_flag = 'Y'
897: and trunc(as_of_date) = trunc(p_as_of_date)
898: and exists(select 1
899: from pa_progress_rollup
900: where project_id = p_project_id
901: and object_id = p_object_id
902: and object_type = p_object_type
903: and structure_version_id is null

Line 912: Update pa_progress_rollup

908: -- Update the working progress record on the same as of date as published progress
909: -- so that while updating rollup record its values can be considered
910: -- Basically this is done so get_prog_rollup_id can return this row for update mode
911:
912: Update pa_progress_rollup
913: set current_flag = 'Y'
914: where project_id = p_project_id
915: and object_id = p_object_id
916: and object_type = p_object_type

Line 922: Delete from pa_progress_rollup

918: and structure_type = 'WORKPLAN'
919: and current_flag = 'W'
920: and trunc(as_of_date) = trunc(p_as_of_date);
921: */
922: Delete from pa_progress_rollup
923: where project_id = p_project_id
924: and object_id = p_object_id
925: and object_type = p_object_type
926: and structure_version_id is null

Line 1065: PA_PROGRESS_ROLLUP_PKG.INSERT_ROW(

1061: pa_debug.write(x_Module=>'PA_DELIVERABLE_PROGRESS_PUB.UPDATE_DELIVERABLE_PROGRESS', x_Msg => 'INserting in progress rollup table', x_Log_Level=> 3);
1062: END IF;
1063:
1064:
1065: PA_PROGRESS_ROLLUP_PKG.INSERT_ROW(
1066: X_PROGRESS_ROLLUP_ID => l_PROGRESS_ROLLUP_ID
1067: ,X_PROJECT_ID => p_project_id
1068: ,X_OBJECT_ID => p_object_id
1069: ,X_OBJECT_TYPE => p_object_type

Line 1209: PA_PROGRESS_ROLLUP_PKG.UPDATE_ROW(

1205: pa_debug.write(x_Module=>'PA_DELIVERABLE_PROGRESS_PUB.UPDATE_DELIVERABLE_PROGRESS', x_Msg => 'Updating in progress rollup table', x_Log_Level=> 3);
1206: END IF;
1207:
1208:
1209: PA_PROGRESS_ROLLUP_PKG.UPDATE_ROW(
1210: X_PROGRESS_ROLLUP_ID => l_PROGRESS_ROLLUP_ID
1211: ,X_PROJECT_ID => p_project_id
1212: ,X_OBJECT_ID => p_object_id
1213: ,X_OBJECT_TYPE => p_object_type

Line 1455: PA_PROGRESS_ROLLUP_PKG.UPDATE_ROW(

1451: IF g1_debug_mode = 'Y' THEN
1452: pa_debug.write(x_Module=>'PA_DELIVERABLE_PROGRESS_PUB.UPDATE_DELIVERABLE_PROGRESS', x_Msg => 'Updating progress rollup table', x_Log_Level=> 3);
1453: END IF;
1454:
1455: PA_PROGRESS_ROLLUP_PKG.UPDATE_ROW(
1456: X_PROGRESS_ROLLUP_ID => l_PROGRESS_ROLLUP_ID
1457: ,X_PROJECT_ID => p_project_id
1458: ,X_OBJECT_ID => p_object_id
1459: ,X_OBJECT_TYPE => p_object_type

Line 1595: PA_PROGRESS_ROLLUP_PKG.INSERT_ROW(

1591: IF g1_debug_mode = 'Y' THEN
1592: pa_debug.write(x_Module=>'PA_DELIVERABLE_PROGRESS_PUB.UPDATE_DELIVERABLE_PROGRESS', x_Msg => 'Inserting progress rollup table', x_Log_Level=> 3);
1593: END IF;
1594:
1595: PA_PROGRESS_ROLLUP_PKG.INSERT_ROW(
1596: X_PROGRESS_ROLLUP_ID => l_PROGRESS_ROLLUP_ID
1597: ,X_PROJECT_ID => p_project_id
1598: ,X_OBJECT_ID => p_object_id
1599: ,X_OBJECT_TYPE => p_object_type