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 247: from pa_progress_rollup ppr2

243: AND ppr.current_flag <> 'W' -- Bug 3879461
244: AND NVL(ppr.cbs_element_id,-1) = NVL(c_cbs_element_id,-1) -- Added for 16200605
245: --bug# 3821106 Satish
246: /*AND ppr.as_of_date = ( SELECT max(as_of_date)
247: from pa_progress_rollup ppr2
248: WHERE ppr2.as_of_date < c_as_of_date
249: AND ppr2.project_id = c_project_id
250: AND ppr2.object_id = c_object_id
251: AND ppr2.object_type = 'PA_ASSIGNMENTS'

Line 255: from pa_progress_rollup ppr2

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

Line 287: FROM pa_progress_rollup ppr

283: 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,
284: 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,
285: 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,
286: 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
287: FROM pa_progress_rollup ppr
288: WHERE ppr.project_id = c_project_id
289: AND ppr.object_id = c_object_id
290: AND ppr.structure_type = c_structure_type
291: AND ppr.structure_version_id is null --bug# 3821106 Satish

Line 298: from pa_progress_rollup ppr2

294: AND ppr.current_flag <> 'W' -- Bug 3879461
295: AND NVL(ppr.cbs_element_id,-1) = NVL(c_cbs_element_id,-1) -- Added for 16200605
296: --bug# 3821106 Satish
297: AND ppr.as_of_date = ( SELECT max(as_of_date)
298: from pa_progress_rollup ppr2
299: WHERE ppr2.as_of_date <= c_as_of_date ---4290592
300: AND ppr2.project_id = c_project_id
301: AND ppr2.object_id = c_object_id
302: AND ppr2.object_type = 'PA_ASSIGNMENTS'

Line 319: FROM pa_progress_rollup ppr

315: 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,
316: 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,
317: 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,
318: 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
319: FROM pa_progress_rollup ppr
320: WHERE ppr.project_id = c_project_id
321: AND ppr.object_id = c_object_id
322: AND ppr.structure_type = c_structure_type
323: AND ppr.structure_version_id is null --bug# 3821106 Satish

Line 419: SELECT 'y' FROM PA_PROGRESS_ROLLUP

415: CURSOR c_if_progress_exists(l_object_id NUMBER, l_project_id NUMBER, l_structure_version_id NUMBER , c_cbs_element_id NUMBER) IS
416: SELECT 'x' FROM dual
417: WHERE EXISTS
418: (
419: SELECT 'y' FROM PA_PROGRESS_ROLLUP
420: WHERE OBJECT_ID = l_object_id
421: AND PROJECT_ID = l_project_id
422: AND OBJECT_TYPE = 'PA_ASSIGNMENTS'
423: AND STRUCTURE_TYPE = 'WORKPLAN'

Line 474: FROM pa_progress_rollup ppr

470: , ppr.estimated_finish_date
471: , ppr.actual_start_date
472: , ppr.actual_finish_date
473: , ppe.status_code
474: FROM pa_progress_rollup ppr
475: , pa_proj_elements ppe
476: WHERE ppr.project_id = c_project_id
477: AND ppr.object_id = c_object_id
478: AND ppr.object_type = c_object_type

Line 1055: delete from pa_progress_rollup

1051: and structure_type = p_structure_type
1052: and NVL(cbs_element_id,-1) = NVL(l_cbs_element_id,-1) --Added for 16200605
1053: ;
1054:
1055: delete from pa_progress_rollup
1056: where project_id= p_project_id
1057: and object_id = p_object_id
1058: and current_flag = 'W'
1059: and proj_element_id = p_task_id

Line 1083: delete from pa_progress_rollup

1079: and NVL(cbs_element_id,-1) = NVL(l_cbs_element_id,-1) --Added for 16200605
1080: -- DJ::: NEED TO ADD CBS_ELEMENT_ID
1081: ;
1082:
1083: delete from pa_progress_rollup
1084: where project_id= p_project_id
1085: and object_id = p_object_id
1086: and current_flag = 'W'
1087: and as_of_date < p_as_of_date

Line 1558: UPDATE pa_progress_rollup

1554: AND current_flag = 'Y'
1555: AND object_type = l_object_type
1556: AND CBS_ELEMENT_ID = L_CBS_ELEMENT_ID; --Added for 16200605
1557:
1558: UPDATE pa_progress_rollup
1559: SET current_flag = 'N'
1560: WHERE project_id = p_project_id
1561: --AND object_id = l_assignment_id --bug# 3764224 Changes for RLM
1562: AND object_id = l_resource_list_member_id

Line 1573: DELETE FROM pa_progress_rollup

1569: -- Bug 3879461 Begin
1570: ----- IF l_db_action = 'UPDATE' THEN
1571: /*
1572: -- Delete the published progress record on the same as of date
1573: DELETE FROM pa_progress_rollup
1574: where project_id = p_project_id
1575: and object_id = l_resource_list_member_id
1576: and proj_element_id = l_task_id
1577: and object_type = l_object_type

Line 1583: from pa_progress_rollup

1579: and structure_type = 'WORKPLAN'
1580: and current_flag = 'Y'
1581: and trunc(as_of_date) = trunc(p_as_of_date)
1582: and exists(select 1
1583: from pa_progress_rollup
1584: where project_id = p_project_id
1585: and object_id = l_resource_list_member_id
1586: and proj_element_id = l_task_id
1587: and object_type = l_object_type

Line 1597: Update pa_progress_rollup

1593: -- Update the working progress record on the same as of date as published progress
1594: -- so that while updating rollup record its values can be considered
1595: -- Basically this is done so get_prog_rollup_id can return this row for update mode
1596:
1597: Update pa_progress_rollup
1598: set current_flag = 'Y'
1599: where project_id = p_project_id
1600: and object_id = l_resource_list_member_id
1601: and proj_element_id = l_task_id

Line 1609: Delete from pa_progress_rollup

1605: and current_flag = 'W'
1606: and trunc(as_of_date) = trunc(p_as_of_date);
1607: */
1608: --- while PUBLISH we delete all working rec <= to as_of_date
1609: Delete from pa_progress_rollup
1610: where project_id = p_project_id
1611: and object_id = l_resource_list_member_id
1612: and proj_element_id = l_task_id
1613: and object_type = l_object_type

Line 2898: PA_PROGRESS_ROLLUP_PKG.INSERT_ROW(

2894: IF g1_debug_mode = 'Y' THEN
2895: pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'INSERTING IN PPR', x_Log_Level=> 3);
2896: END IF;
2897:
2898: PA_PROGRESS_ROLLUP_PKG.INSERT_ROW(
2899: X_PROGRESS_ROLLUP_ID => l_PROGRESS_ROLLUP_ID
2900: ,X_PROJECT_ID => p_project_id
2901: --,X_OBJECT_ID => l_assignment_id --bug# 3764224 Changes for RLM
2902: ,X_OBJECT_ID => l_resource_list_member_id

Line 3044: PA_PROGRESS_ROLLUP_PKG.UPDATE_ROW(

3040: IF g1_debug_mode = 'Y' THEN
3041: pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'UPDATING PPR', x_Log_Level=> 3);
3042: END IF;
3043:
3044: PA_PROGRESS_ROLLUP_PKG.UPDATE_ROW(
3045: X_PROGRESS_ROLLUP_ID => l_PROGRESS_ROLLUP_ID
3046: ,X_PROJECT_ID => p_project_id
3047: --,X_OBJECT_ID => l_assignment_id --bug# 3764224 Changes for RLM
3048: ,X_OBJECT_ID => l_resource_list_member_id

Line 3303: PA_PROGRESS_ROLLUP_PKG.UPDATE_ROW(

3299:
3300:
3301: IF l_PROGRESS_ROLLUP_ID IS NOT NULL
3302: THEN
3303: PA_PROGRESS_ROLLUP_PKG.UPDATE_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

Line 3438: PA_PROGRESS_ROLLUP_PKG.INSERT_ROW(

3434: RAISE FND_API.G_EXC_ERROR;
3435: END IF;
3436:
3437: ELSE
3438: PA_PROGRESS_ROLLUP_PKG.INSERT_ROW(
3439: X_PROGRESS_ROLLUP_ID => l_PROGRESS_ROLLUP_ID
3440: ,X_PROJECT_ID => p_project_id
3441: --,X_OBJECT_ID => l_assignment_id --bug# 3764224 Changes for RLM
3442: ,X_OBJECT_ID => l_resource_list_member_id