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_ASSIGNMENT_PROGRESS_PUB dependencies on PA_PROGRESS_ROLLUP

Line 236: FROM pa_progress_rollup ppr

232: decode(c_resource_class_code, 'PEOPLE', nvl(ppr.ppl_act_cost_to_date_tc,0), 'EQUIPMENT', nvl(ppr.eqpmt_act_cost_to_date_tc,0), nvl(ppr.oth_act_cost_to_date_tc,0)) tc_bur_cost,
233: decode(c_resource_class_code, 'PEOPLE', nvl(ppr.ppl_act_cost_to_date_pc,0), 'EQUIPMENT', nvl(ppr.eqpmt_act_cost_to_date_pc,0), nvl(ppr.oth_act_cost_to_date_pc,0)) pc_bur_cost,
234: decode(c_resource_class_code, 'PEOPLE', nvl(ppr.ppl_act_cost_to_date_fc,0), 'EQUIPMENT', nvl(ppr.eqpmt_act_cost_to_date_fc,0), nvl(ppr.oth_act_cost_to_date_fc,0)) fc_bur_cost,
235: decode(c_resource_class_code, 'PEOPLE', nvl(ppr.PPL_ACT_EFFORT_TO_DATE,0), 'EQUIPMENT', nvl(ppr.EQPMT_ACT_EFFORT_TO_DATE,0), nvl(ppr.OTH_QUANTITY_TO_DATE,0)) act_effort -- 3696572 OTH_QUANTITY_TO_DATE shd also be considered here
236: FROM pa_progress_rollup ppr
237: WHERE ppr.project_id = c_project_id
238: AND ppr.object_id = c_object_id
239: AND ppr.structure_type = c_structure_type
240: AND ppr.structure_version_id is null --bug# 3821106 Satish

Line 246: from pa_progress_rollup ppr2

242: AND ppr.proj_element_id = p_task_id --bug 3861360
243: AND ppr.current_flag <> 'W' -- Bug 3879461
244: --bug# 3821106 Satish
245: /*AND ppr.as_of_date = ( SELECT max(as_of_date)
246: from pa_progress_rollup ppr2
247: WHERE ppr2.as_of_date < c_as_of_date
248: AND ppr2.project_id = c_project_id
249: AND ppr2.object_id = c_object_id
250: AND ppr2.object_type = 'PA_ASSIGNMENTS'

Line 254: from pa_progress_rollup ppr2

250: AND ppr2.object_type = 'PA_ASSIGNMENTS'
251: AND ppr2.structure_type = c_structure_type
252: );*/
253: AND ppr.as_of_date = ( SELECT max(as_of_date)
254: from pa_progress_rollup ppr2
255: WHERE ppr2.as_of_date < c_as_of_date ---4290592
256: AND ppr2.project_id = c_project_id
257: AND ppr2.object_id = c_object_id
258: AND ppr2.object_type = 'PA_ASSIGNMENTS'

Line 285: FROM pa_progress_rollup ppr

281: decode(c_resource_class_code, 'PEOPLE', nvl(ppr.ppl_act_cost_to_date_tc,0), 'EQUIPMENT', nvl(ppr.eqpmt_act_cost_to_date_tc,0), nvl(ppr.oth_act_cost_to_date_tc,0)) tc_bur_cost,
282: decode(c_resource_class_code, 'PEOPLE', nvl(ppr.ppl_act_cost_to_date_pc,0), 'EQUIPMENT', nvl(ppr.eqpmt_act_cost_to_date_pc,0), nvl(ppr.oth_act_cost_to_date_pc,0)) pc_bur_cost,
283: decode(c_resource_class_code, 'PEOPLE', nvl(ppr.ppl_act_cost_to_date_fc,0), 'EQUIPMENT', nvl(ppr.eqpmt_act_cost_to_date_fc,0), nvl(ppr.oth_act_cost_to_date_fc,0)) fc_bur_cost,
284: decode(c_resource_class_code, 'PEOPLE', nvl(ppr.PPL_ACT_EFFORT_TO_DATE,0), 'EQUIPMENT', nvl(ppr.EQPMT_ACT_EFFORT_TO_DATE,0), nvl(ppr.OTH_QUANTITY_TO_DATE,0)) act_effort -- 3696572 OTH_QUANTITY_TO_DATE shd also be considered here
285: FROM pa_progress_rollup ppr
286: WHERE ppr.project_id = c_project_id
287: AND ppr.object_id = c_object_id
288: AND ppr.structure_type = c_structure_type
289: AND ppr.structure_version_id is null --bug# 3821106 Satish

Line 295: from pa_progress_rollup ppr2

291: AND ppr.proj_element_id = p_task_id --bug 3861360
292: AND ppr.current_flag <> 'W' -- Bug 3879461
293: --bug# 3821106 Satish
294: AND ppr.as_of_date = ( SELECT max(as_of_date)
295: from pa_progress_rollup ppr2
296: WHERE ppr2.as_of_date <= c_as_of_date ---4290592
297: AND ppr2.project_id = c_project_id
298: AND ppr2.object_id = c_object_id
299: AND ppr2.object_type = 'PA_ASSIGNMENTS'

Line 315: FROM pa_progress_rollup ppr

311: decode(c_resource_class_code, 'PEOPLE', nvl(ppr.ppl_act_cost_to_date_tc,0), 'EQUIPMENT', nvl(ppr.eqpmt_act_cost_to_date_tc,0), nvl(ppr.oth_act_cost_to_date_tc,0)) tc_bur_cost,
312: decode(c_resource_class_code, 'PEOPLE', nvl(ppr.ppl_act_cost_to_date_pc,0), 'EQUIPMENT', nvl(ppr.eqpmt_act_cost_to_date_pc,0), nvl(ppr.oth_act_cost_to_date_pc,0)) pc_bur_cost,
313: decode(c_resource_class_code, 'PEOPLE', nvl(ppr.ppl_act_cost_to_date_fc,0), 'EQUIPMENT', nvl(ppr.eqpmt_act_cost_to_date_fc,0), nvl(ppr.oth_act_cost_to_date_fc,0)) fc_bur_cost,
314: decode(c_resource_class_code, 'PEOPLE', nvl(ppr.PPL_ACT_EFFORT_TO_DATE,0), 'EQUIPMENT', nvl(ppr.EQPMT_ACT_EFFORT_TO_DATE,0), nvl(ppr.OTH_QUANTITY_TO_DATE,0)) act_effort
315: FROM pa_progress_rollup ppr
316: WHERE ppr.project_id = c_project_id
317: AND ppr.object_id = c_object_id
318: AND ppr.structure_type = c_structure_type
319: AND ppr.structure_version_id is null --bug# 3821106 Satish

Line 414: SELECT 'y' FROM PA_PROGRESS_ROLLUP

410: CURSOR c_if_progress_exists(l_object_id NUMBER, l_project_id NUMBER, l_structure_version_id NUMBER) IS
411: SELECT 'x' FROM dual
412: WHERE EXISTS
413: (
414: SELECT 'y' FROM PA_PROGRESS_ROLLUP
415: WHERE OBJECT_ID = l_object_id
416: AND PROJECT_ID = l_project_id
417: AND OBJECT_TYPE = 'PA_ASSIGNMENTS'
418: AND STRUCTURE_TYPE = 'WORKPLAN'

Line 468: FROM pa_progress_rollup ppr

464: , ppr.estimated_finish_date
465: , ppr.actual_start_date
466: , ppr.actual_finish_date
467: , ppe.status_code
468: FROM pa_progress_rollup ppr
469: , pa_proj_elements ppe
470: WHERE ppr.project_id = c_project_id
471: AND ppr.object_id = c_object_id
472: AND ppr.object_type = c_object_type

Line 981: delete from pa_progress_rollup

977: and task_id = p_task_id
978: and structure_type = p_structure_type
979: ;
980:
981: delete from pa_progress_rollup
982: where project_id= p_project_id
983: and object_id = p_object_id
984: and current_flag = 'W'
985: and proj_element_id = p_task_id

Line 1006: delete from pa_progress_rollup

1002: and task_id = p_task_id
1003: and structure_type = p_structure_type
1004: ;
1005:
1006: delete from pa_progress_rollup
1007: where project_id= p_project_id
1008: and object_id = p_object_id
1009: and current_flag = 'W'
1010: and as_of_date < p_as_of_date

Line 1447: UPDATE pa_progress_rollup

1443: AND task_id = l_task_id --maansari7/21 bug# 3764224 Changes for RLM
1444: AND current_flag = 'Y'
1445: AND object_type = l_object_type;
1446:
1447: UPDATE pa_progress_rollup
1448: SET current_flag = 'N'
1449: WHERE project_id = p_project_id
1450: --AND object_id = l_assignment_id --bug# 3764224 Changes for RLM
1451: AND object_id = l_resource_list_member_id

Line 1461: DELETE FROM pa_progress_rollup

1457: -- Bug 3879461 Begin
1458: ----- IF l_db_action = 'UPDATE' THEN
1459: /*
1460: -- Delete the published progress record on the same as of date
1461: DELETE FROM pa_progress_rollup
1462: where project_id = p_project_id
1463: and object_id = l_resource_list_member_id
1464: and proj_element_id = l_task_id
1465: and object_type = l_object_type

Line 1471: from pa_progress_rollup

1467: and structure_type = 'WORKPLAN'
1468: and current_flag = 'Y'
1469: and trunc(as_of_date) = trunc(p_as_of_date)
1470: and exists(select 1
1471: from pa_progress_rollup
1472: where project_id = p_project_id
1473: and object_id = l_resource_list_member_id
1474: and proj_element_id = l_task_id
1475: and object_type = l_object_type

Line 1485: Update pa_progress_rollup

1481: -- Update the working progress record on the same as of date as published progress
1482: -- so that while updating rollup record its values can be considered
1483: -- Basically this is done so get_prog_rollup_id can return this row for update mode
1484:
1485: Update pa_progress_rollup
1486: set current_flag = 'Y'
1487: where project_id = p_project_id
1488: and object_id = l_resource_list_member_id
1489: and proj_element_id = l_task_id

Line 1497: Delete from pa_progress_rollup

1493: and current_flag = 'W'
1494: and trunc(as_of_date) = trunc(p_as_of_date);
1495: */
1496: --- while PUBLISH we delete all working rec <= to as_of_date
1497: Delete from pa_progress_rollup
1498: where project_id = p_project_id
1499: and object_id = l_resource_list_member_id
1500: and proj_element_id = l_task_id
1501: and object_type = l_object_type

Line 2774: PA_PROGRESS_ROLLUP_PKG.INSERT_ROW(

2770: IF g1_debug_mode = 'Y' THEN
2771: pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'INSERTING IN PPR', x_Log_Level=> 3);
2772: END IF;
2773:
2774: PA_PROGRESS_ROLLUP_PKG.INSERT_ROW(
2775: X_PROGRESS_ROLLUP_ID => l_PROGRESS_ROLLUP_ID
2776: ,X_PROJECT_ID => p_project_id
2777: --,X_OBJECT_ID => l_assignment_id --bug# 3764224 Changes for RLM
2778: ,X_OBJECT_ID => l_resource_list_member_id

Line 2919: PA_PROGRESS_ROLLUP_PKG.UPDATE_ROW(

2915: IF g1_debug_mode = 'Y' THEN
2916: pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'UPDATING PPR', x_Log_Level=> 3);
2917: END IF;
2918:
2919: PA_PROGRESS_ROLLUP_PKG.UPDATE_ROW(
2920: X_PROGRESS_ROLLUP_ID => l_PROGRESS_ROLLUP_ID
2921: ,X_PROJECT_ID => p_project_id
2922: --,X_OBJECT_ID => l_assignment_id --bug# 3764224 Changes for RLM
2923: ,X_OBJECT_ID => l_resource_list_member_id

Line 3170: PA_PROGRESS_ROLLUP_PKG.UPDATE_ROW(

3166:
3167:
3168: IF l_PROGRESS_ROLLUP_ID IS NOT NULL
3169: THEN
3170: PA_PROGRESS_ROLLUP_PKG.UPDATE_ROW(
3171: X_PROGRESS_ROLLUP_ID => l_PROGRESS_ROLLUP_ID
3172: ,X_PROJECT_ID => p_project_id
3173: --,X_OBJECT_ID => l_assignment_id --bug# 3764224 Changes for RLM
3174: ,X_OBJECT_ID => l_resource_list_member_id

Line 3303: PA_PROGRESS_ROLLUP_PKG.INSERT_ROW(

3299: RAISE FND_API.G_EXC_ERROR;
3300: END IF;
3301:
3302: ELSE
3303: PA_PROGRESS_ROLLUP_PKG.INSERT_ROW(
3304: X_PROGRESS_ROLLUP_ID => l_PROGRESS_ROLLUP_ID
3305: ,X_PROJECT_ID => p_project_id
3306: --,X_OBJECT_ID => l_assignment_id --bug# 3764224 Changes for RLM
3307: ,X_OBJECT_ID => l_resource_list_member_id