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_CAPITAL_EVENTS_PVT dependencies on PA_EXPENDITURE_ITEMS_ALL

Line 108: FROM pa_expenditure_items_all

104:
105:
106: CURSOR costs_added_cur (x_project_id NUMBER, x_capital_event_id NUMBER, x_cost_type VARCHAR2) IS
107: SELECT SUM(DECODE(x_cost_type,'R',NVL(raw_cost,0),NVL(burden_cost,0))) total_cost
108: FROM pa_expenditure_items_all
109: WHERE project_id = x_project_id
110: AND capital_event_id = x_capital_event_id
111: AND request_id = v_request_id;
112:

Line 118: FROM pa_expenditure_items_all

114:
115:
116: CURSOR current_costs_cur (x_project_id NUMBER, x_capital_event_id NUMBER, x_cost_type VARCHAR2) IS
117: SELECT SUM(DECODE(x_cost_type,'R',NVL(raw_cost,0),NVL(burden_cost,0))) total_cost
118: FROM pa_expenditure_items_all
119: WHERE project_id = x_project_id
120: AND capital_event_id = x_capital_event_id;
121:
122: current_costs_rec current_costs_cur%ROWTYPE;

Line 694: FROM pa_expenditure_items_all peia,

690:
691: CURSOR remaining_costs_cur(x_project_id NUMBER,
692: x_event_type VARCHAR2) IS
693: SELECT peia.task_id
694: FROM pa_expenditure_items_all peia,
695: pa_tasks t
696: WHERE peia.project_id = x_project_id
697: AND peia.task_id = t.task_id
698: AND t.project_id = x_project_id

Line 777: FROM pa_expenditure_items_all

773: SELECT 'Additional Costs Added'
774: FROM SYS.DUAL
775: WHERE EXISTS
776: (SELECT 'X'
777: FROM pa_expenditure_items_all
778: WHERE project_id = x_project_id
779: AND capital_event_id = x_capital_event_id
780: AND request_id = x_request_id);
781:

Line 923: UPDATE pa_expenditure_items_all

919: --Assign all new costs to the existing event
920: FOR add_ei_tasks_rec IN add_ei_tasks_cur(p_project_id, p_event_type) LOOP
921:
922: --Assign all eligible EIs for that Task to the event
923: UPDATE pa_expenditure_items_all
924: SET capital_event_id = capital_event_rec.capital_event_id,
925: last_update_date = SYSDATE,
926: last_updated_by = v_user_id,
927: request_id = v_request_id,

Line 964: FROM pa_expenditure_items_all ei,

960:
961: /* Commented for the bug 3961059 :
962: SELECT COUNT(*)
963: INTO v_ei_count
964: FROM pa_expenditure_items_all ei,
965: pa_tasks t
966: WHERE ei.project_id = p_project_id
967: AND t.task_id = ei.task_id
968: AND NVL(t.retirement_cost_flag,'N') = DECODE(p_event_type,'R','Y','N')

Line 983: FROM pa_expenditure_items_all ei,

979: SELECT COUNT(*)
980: INTO v_ei_count
981: From Dual Where Exists
982: (Select 1
983: FROM pa_expenditure_items_all ei,
984: pa_tasks t
985: WHERE ei.project_id = p_project_id
986: AND t.task_id = ei.task_id
987: AND NVL(t.retirement_cost_flag,'N') = DECODE(p_event_type,'R','Y','N')

Line 1072: UPDATE pa_expenditure_items_all

1068: --Assign all new costs to the existing event
1069: FOR add_ei_tasks_rec IN add_ei_tasks_cur(p_project_id, p_event_type) LOOP
1070:
1071: --Assign all eligible EIs for that Task to the event
1072: UPDATE pa_expenditure_items_all
1073: SET capital_event_id = capital_event_rec.capital_event_id,
1074: last_update_date = SYSDATE,
1075: last_updated_by = v_user_id,
1076: request_id = v_request_id,

Line 1285: FROM pa_expenditure_items_all

1281: --Look for costs in the event at the PROJECT grouping level (i.e., ANY expenditure items)
1282: /* Commented for bug 3961059
1283: SELECT COUNT(*)
1284: INTO v_ei_count
1285: FROM pa_expenditure_items_all
1286: WHERE capital_event_id = capital_event_rec.capital_event_id
1287: AND project_id = p_project_id;
1288: */
1289:

Line 1296: FROM pa_expenditure_items_all

1292: SELECT COUNT(*)
1293: INTO v_ei_count
1294: From Dual Where Exists
1295: (Select 1
1296: FROM pa_expenditure_items_all
1297: WHERE capital_event_id = capital_event_rec.capital_event_id
1298: AND project_id = p_project_id
1299: );
1300:

Line 1309: FROM pa_expenditure_items_all peia,

1305: --Look for costs in the event at the TASK or TOP TASK grouping level
1306: /* Commented for bug 3961059
1307: SELECT COUNT(*)
1308: INTO v_ei_count
1309: FROM pa_expenditure_items_all peia,
1310: pa_tasks t
1311: WHERE peia.task_id = t.task_id
1312: AND peia.capital_event_id = capital_event_rec.capital_event_id
1313: AND peia.project_id = p_project_id

Line 1324: FROM pa_expenditure_items_all peia,

1320: SELECT COUNT(*)
1321: INTO v_ei_count
1322: From Dual Where Exists
1323: ( Select 1
1324: FROM pa_expenditure_items_all peia,
1325: pa_tasks t
1326: WHERE peia.task_id = t.task_id
1327: AND peia.capital_event_id = capital_event_rec.capital_event_id
1328: AND peia.project_id = p_project_id

Line 1361: FROM pa_expenditure_items_all peia,

1357:
1358: --Look for new costs at the PROJECT grouping level (i.e., ANY expenditure items)
1359: SELECT COUNT(*)
1360: INTO v_ei_count
1361: FROM pa_expenditure_items_all peia,
1362: pa_tasks t
1363: WHERE peia.project_id = p_project_id
1364: AND peia.task_id = t.task_id
1365: AND NVL(t.retirement_cost_flag,'N') = DECODE(p_event_type,'R','Y','N')

Line 1377: FROM pa_expenditure_items_all peia,

1373:
1374: --Look for new costs at the TASK or TOP TASK grouping level
1375: SELECT COUNT(*)
1376: INTO v_ei_count
1377: FROM pa_expenditure_items_all peia,
1378: pa_tasks t
1379: WHERE peia.task_id = t.task_id
1380: AND NVL(t.retirement_cost_flag,'N') = DECODE(p_event_type,'R','Y','N')
1381: AND peia.project_id = p_project_id

Line 1412: UPDATE pa_expenditure_items_all

1408: WHERE project_asset_id = new_assets_rec.project_asset_id
1409: AND capital_event_id IS NULL;
1410:
1411: --Add the new costs to the event
1412: UPDATE pa_expenditure_items_all
1413: SET capital_event_id = capital_event_rec.capital_event_id,
1414: last_update_date = SYSDATE,
1415: last_updated_by = v_user_id,
1416: request_id = v_request_id,

Line 1457: FROM pa_expenditure_items_all peia,

1453:
1454: --Look for new costs at the PROJECT grouping level (i.e., ANY expenditure items)
1455: SELECT COUNT(*)
1456: INTO v_ei_count
1457: FROM pa_expenditure_items_all peia,
1458: pa_tasks t
1459: WHERE peia.project_id = p_project_id
1460: AND peia.task_id = t.task_id
1461: AND NVL(t.retirement_cost_flag,'N') = DECODE(p_event_type,'R','Y','N')

Line 1473: FROM pa_expenditure_items_all peia,

1469:
1470: --Look for new costs at the TASK or TOP TASK grouping level
1471: SELECT COUNT(*)
1472: INTO v_ei_count
1473: FROM pa_expenditure_items_all peia,
1474: pa_tasks t
1475: WHERE peia.task_id = t.task_id
1476: AND NVL(t.retirement_cost_flag,'N') = DECODE(p_event_type,'R','Y','N')
1477: AND peia.project_id = p_project_id

Line 1559: UPDATE pa_expenditure_items_all

1555: AND capital_event_id IS NULL;
1556:
1557:
1558: --Add the new costs to the event
1559: UPDATE pa_expenditure_items_all
1560: SET capital_event_id = capital_event_rec.capital_event_id,
1561: last_update_date = SYSDATE,
1562: last_updated_by = v_user_id,
1563: request_id = v_request_id,

Line 1631: UPDATE pa_expenditure_items_all

1627: PA_DEBUG.DEBUG('Common Task assignment made at Top Task Level for Task ID '||common_tasks_rec.task_id);
1628: END IF;
1629:
1630: --Attach all common costs to the event associated with a Top Task Assignment
1631: UPDATE pa_expenditure_items_all
1632: SET capital_event_id = capital_event_rec.capital_event_id,
1633: last_update_date = SYSDATE,
1634: last_updated_by = v_user_id,
1635: request_id = v_request_id,

Line 1694: UPDATE pa_expenditure_items_all

1690:
1691: IF v_wbs_branch_assets_exist = 'Y' THEN
1692:
1693: --Attach all common costs to the event for the current task
1694: UPDATE pa_expenditure_items_all
1695: SET capital_event_id = capital_event_rec.capital_event_id,
1696: last_update_date = SYSDATE,
1697: last_updated_by = v_user_id,
1698: request_id = v_request_id,

Line 1758: UPDATE pa_expenditure_items_all

1754:
1755: IF v_asset_count > 0 THEN
1756:
1757: --Add new costs to the event for the current task
1758: UPDATE pa_expenditure_items_all
1759: SET capital_event_id = capital_event_rec.capital_event_id,
1760: last_update_date = SYSDATE,
1761: last_updated_by = v_user_id,
1762: request_id = v_request_id,

Line 2546: FROM pa_expenditure_items_all peia,

2542: SELECT peia.expenditure_item_id,
2543: peia.task_id,
2544: t.top_task_id,
2545: t.parent_task_id
2546: FROM pa_expenditure_items_all peia,
2547: pa_tasks t
2548: WHERE t.project_id = p_project_id
2549: AND peia.task_id = t.task_id
2550: AND t.task_number

Line 2733: UPDATE pa_expenditure_items_all

2729:
2730: IF v_attach_ei = 'Y' THEN
2731:
2732: --Update NULL capital_event_id with parameter value
2733: UPDATE pa_expenditure_items_all
2734: SET capital_event_id = p_capital_event_id,
2735: last_update_date = SYSDATE,
2736: last_updated_by = v_user_id,
2737: last_update_login = v_login_id