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_PROJECT_ASSETS

Line 98: FROM pa_project_assets_all

94:
95: CURSOR assets_added_cur (x_project_id NUMBER, x_capital_event_id NUMBER) IS
96: SELECT asset_name,
97: asset_description
98: FROM pa_project_assets_all
99: WHERE project_id = x_project_id
100: AND capital_event_id = x_capital_event_id
101: AND request_id = v_request_id;
102:

Line 519: FROM pa_project_assets

515:
516: --Determine if any Retirement Adjustment Assets assets exist for the current project
517: SELECT COUNT(*)
518: INTO v_ret_assets_count
519: FROM pa_project_assets
520: WHERE project_id = ac_projects_rec.project_id
521: AND project_asset_type = 'RETIREMENT_ADJUSTMENT';
522:
523:

Line 659: FROM pa_project_assets_all pa,

655: x_event_type VARCHAR2) IS
656: SELECT pa.project_asset_id,
657: paa.task_id, --Grouping Level: If = 0, asset is assigned to project
658: t.retirement_cost_flag task_retirement_cost_flag --Will be NULL if Task ID = 0
659: FROM pa_project_assets_all pa,
660: pa_project_asset_assignments paa,
661: pa_tasks t
662: WHERE pa.project_id = x_project_id
663: AND pa.project_asset_id = paa.project_asset_id

Line 715: FROM pa_project_assets_all pa,

711: x_event_type VARCHAR2) IS
712: SELECT pa.project_asset_id,
713: pa.asset_name,
714: paa.task_id --Grouping Level: If = 0, asset is assigned to project
715: FROM pa_project_assets_all pa,
716: pa_project_asset_assignments paa
717: WHERE pa.project_id = x_project_id
718: AND pa.project_asset_id = paa.project_asset_id (+)
719: AND pa.capital_event_id IS NULL

Line 792: FROM pa_project_assets_all

788: SELECT 'Additional Assets Added'
789: FROM SYS.DUAL
790: WHERE EXISTS
791: (SELECT 'X'
792: FROM pa_project_assets_all
793: WHERE project_id = x_project_id
794: AND capital_event_id = x_capital_event_id
795: AND request_id = x_request_id);
796:

Line 820: FROM pa_project_assets_all pa,

816: x_capital_event_id NUMBER,
817: x_task_id NUMBER,
818: x_event_type VARCHAR2) IS
819: SELECT paa.project_asset_id
820: FROM pa_project_assets_all pa,
821: pa_project_asset_assignments paa
822: WHERE pa.project_asset_id = paa.project_asset_id
823: AND pa.project_id = x_project_id
824: AND paa.project_id = x_project_id

Line 905: UPDATE pa_project_assets_all

901: END IF;
902:
903:
904: --Assign all new assets to the existing event
905: UPDATE pa_project_assets_all
906: SET capital_event_id = capital_event_rec.capital_event_id,
907: last_update_date = SYSDATE,
908: last_updated_by = v_user_id,
909: request_id = v_request_id,

Line 953: FROM pa_project_assets_all

949:
950: --Count the number of new assets
951: SELECT COUNT(*)
952: INTO v_asset_count
953: FROM pa_project_assets_all
954: WHERE project_id = p_project_id
955: AND capital_event_id IS NULL
956: AND project_asset_type = DECODE(p_event_type,'C','AS-BUILT','RETIREMENT_ADJUSTMENT')
957: AND date_placed_in_service <= p_asset_date_through;

Line 1055: UPDATE pa_project_assets_all

1051: END IF;
1052: CLOSE capital_event_cur;
1053:
1054: --Assign all new assets to the existing event
1055: UPDATE pa_project_assets_all
1056: SET capital_event_id = capital_event_rec.capital_event_id,
1057: last_update_date = SYSDATE,
1058: last_updated_by = v_user_id,
1059: request_id = v_request_id,

Line 1343: UPDATE pa_project_assets_all

1339: PA_DEBUG.WRITE_FILE('LOG',TO_CHAR(SYSDATE,'HH:MI:SS')||': '||'Costs already exists on the Event, add asset id: '||new_assets_rec.project_asset_id);
1340: END IF;
1341:
1342: --Add the asset to the event
1343: UPDATE pa_project_assets_all
1344: SET capital_event_id = capital_event_rec.capital_event_id,
1345: last_update_date = SYSDATE,
1346: last_updated_by = v_user_id,
1347: request_id = v_request_id,

Line 1400: UPDATE pa_project_assets_all

1396: END IF;
1397:
1398:
1399: --Add the asset to the event
1400: UPDATE pa_project_assets_all
1401: SET capital_event_id = capital_event_rec.capital_event_id,
1402: last_update_date = SYSDATE,
1403: last_updated_by = v_user_id,
1404: request_id = v_request_id,

Line 1546: UPDATE pa_project_assets_all

1542: CLOSE capital_event_cur;
1543:
1544:
1545: --Add the asset to the event
1546: UPDATE pa_project_assets_all
1547: SET capital_event_id = capital_event_rec.capital_event_id,
1548: last_update_date = SYSDATE,
1549: last_updated_by = v_user_id,
1550: request_id = v_request_id,

Line 1732: FROM pa_project_assets_all pa,

1728:
1729: /* Commented for bug 3961059 */
1730: SELECT COUNT(*)
1731: INTO v_asset_count
1732: FROM pa_project_assets_all pa,
1733: pa_project_asset_assignments paa
1734: WHERE pa.project_asset_id = paa.project_asset_id
1735: AND pa.capital_event_id = capital_event_rec.capital_event_id
1736: AND (paa.task_id = remaining_costs_rec.task_id

Line 1746: FROM pa_project_assets_all pa,

1742: SELECT COUNT(*)
1743: INTO v_asset_count
1744: From Dual Where Exists
1745: (Select 1
1746: FROM pa_project_assets_all pa,
1747: pa_project_asset_assignments paa
1748: WHERE pa.project_asset_id = paa.project_asset_id
1749: AND pa.capital_event_id = capital_event_rec.capital_event_id
1750: AND (paa.task_id = remaining_costs_rec.task_id

Line 2403: FROM pa_project_assets_all ppa

2399:
2400:
2401: CURSOR assets_cur (x_event_type VARCHAR2) IS
2402: SELECT ppa.project_asset_id
2403: FROM pa_project_assets_all ppa
2404: WHERE ppa.project_id = p_project_id
2405: AND ppa.capital_event_id IS NULL
2406: AND ppa.project_asset_type = DECODE(x_event_type,'C','AS-BUILT','R','RETIREMENT_ADJUSTMENT','X')
2407: AND ppa.date_placed_in_service IS NOT NULL

Line 2485: UPDATE pa_project_assets_all

2481: FETCH task_assignments_cur INTO task_assignments_rec;
2482: IF task_assignments_cur%FOUND THEN
2483:
2484: --Update NULL capital_event_id with parameter value
2485: UPDATE pa_project_assets_all
2486: SET capital_event_id = p_capital_event_id,
2487: last_update_date = SYSDATE,
2488: last_updated_by = v_user_id,
2489: last_update_login = v_login_id

Line 2501: UPDATE pa_project_assets_all

2497:
2498: ELSE
2499:
2500: --Update NULL capital_event_id with parameter value
2501: UPDATE pa_project_assets_all
2502: SET capital_event_id = p_capital_event_id,
2503: last_update_date = SYSDATE,
2504: last_updated_by = v_user_id,
2505: last_update_login = v_login_id

Line 2598: FROM pa_project_assets_all pa,

2594: x_capital_event_id NUMBER,
2595: x_task_id NUMBER,
2596: x_event_type VARCHAR2) IS
2597: SELECT paa.project_asset_id
2598: FROM pa_project_assets_all pa,
2599: pa_project_asset_assignments paa
2600: WHERE pa.project_asset_id = paa.project_asset_id
2601: AND pa.project_id = x_project_id
2602: AND paa.project_id = x_project_id

Line 2674: pa_project_assets_all ppa

2670: --for an asset in the current event
2671: SELECT DECODE(COUNT(*),0,'N','Y')
2672: INTO v_task_assignment
2673: FROM pa_project_asset_assignments paa,
2674: pa_project_assets_all ppa
2675: WHERE paa.project_id = p_project_id
2676: AND paa.project_asset_id = ppa.project_asset_id
2677: AND ppa.capital_event_id = p_capital_event_id
2678: AND paa.task_id IN (costs_rec.task_id,costs_rec.top_task_id);