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_FAXFACE dependencies on PA_PROJECT_ASSETS

Line 238: pa_project_assets ppa

234: paa.project_asset_id,
235: ppa.asset_category_id
236: FROM
237: pa_project_asset_assignments paa,
238: pa_project_assets ppa
239: WHERE
240: paa.project_id = x_project_id
241: AND ppa.project_asset_type(+) = DECODE(x_line_type,'C','AS-BUILT','RETIREMENT_ADJUSTMENT')
242: AND ppa.capital_event_id(+) IS NOT NULL

Line 322: pa_project_assets

318: depreciation_expense_ccid
319: INTO
320: x_depreciation_expense_ccid
321: FROM
322: pa_project_assets
323: WHERE
324: project_asset_id = x_project_asset_id;
325:
326: EXCEPTION

Line 351: pa_project_assets ppa

347: x_err_stage := 'Finding the assets to be reversed';
348: x_asset_found := TRUE;
349:
350: UPDATE
351: pa_project_assets ppa
352: SET
353: ppa.reverse_flag = 'S'
354: WHERE
355: ppa.project_id = x_project_id

Line 411: pa_project_assets pas

407: AND pal.project_asset_id NOT IN
408: ( SELECT
409: project_asset_id
410: FROM
411: pa_project_assets pas
412: WHERE
413: pas.reverse_flag = 'S'
414: AND pas.project_id = pal.project_id
415: )

Line 429: pa_project_assets pas

425: AND pal.project_asset_id IN
426: ( SELECT
427: project_asset_id
428: FROM
429: pa_project_assets pas
430: WHERE
431: pas.reverse_flag = 'S'
432: AND pas.project_id = pal.project_id
433: )

Line 574: pa_project_assets ppa

570:
571: IF ( x_project_asset_id > 0 ) THEN
572:
573: UPDATE
574: pa_project_assets ppa
575: SET
576: ppa.grouped_cip_cost = NVL(ppa.grouped_cip_cost,0) +
577: x_grouped_cip_cost,
578: ppa.capitalized_cost = NVL(ppa.capitalized_cost,0) +

Line 765: pa_project_assets pas

761: AND pal.project_asset_id IN
762: ( SELECT
763: project_asset_id
764: FROM
765: pa_project_assets pas
766: WHERE
767: pas.reverse_flag = 'S'
768: AND pas.project_id = pal.project_id
769: )

Line 831: pa_project_assets pas

827: AND pal.project_asset_id IN
828: ( SELECT
829: project_asset_id
830: FROM
831: pa_project_assets pas
832: WHERE
833: pas.reverse_flag = 'S'
834: AND pas.project_id = pal.project_id
835: )

Line 1047: pa_project_assets

1043: -- At this time Project_asset_lines are reversed
1044: -- we need to interface the adjustment lines to FA now
1045:
1046: UPDATE
1047: pa_project_assets
1048: SET
1049: reverse_flag = 'N',
1050: /* Automatic asset capitalization changes JPULTORAK 04-FEB-03 */
1051: --Commenting out this line since it is counter to business flow and erases key data (DPIS)

Line 1790: FROM pa_project_assets ppa,

1786: )
1787: )
1788: /* end of change for bug 6037734*/
1789: AND EXISTS ( SELECT '1' -- Check for task_id to have asset assignment
1790: FROM pa_project_assets ppa,
1791: pa_project_asset_assignments paa
1792: WHERE paa.project_id = p_project_id
1793: AND paa.task_id = pt.task_id
1794: AND ppa.capital_event_id IS NOT NULL

Line 1802: FROM pa_project_assets ppa,

1798: AND ppa.project_asset_id = paa.project_asset_id
1799: AND TRUNC(ppa.date_placed_in_service) <= TRUNC(p_in_service_date_through)
1800: UNION ALL
1801: SELECT '1' -- Check for top_task_id to have asset assignment
1802: FROM pa_project_assets ppa,
1803: pa_project_asset_assignments paa
1804: WHERE paa.project_id = p_project_id
1805: AND paa.task_id = pt.top_task_id
1806: AND ppa.capital_event_id IS NOT NULL

Line 1814: FROM pa_project_assets ppa,

1810: AND ppa.project_asset_id = paa.project_asset_id
1811: AND TRUNC(ppa.date_placed_in_service) <= TRUNC(p_in_service_date_through)
1812: UNION ALL
1813: SELECT '1' -- Check for project level Asset Assignments
1814: FROM pa_project_assets ppa,
1815: pa_project_asset_assignments paa
1816: WHERE paa.project_id = p_project_id
1817: AND nvl(paa.task_id,0) = 0
1818: AND ppa.capital_event_id IS NOT NULL

Line 1865: from pa_project_assets

1861:
1862: cursor c_proj_asset(p_asset_id in number) is
1863: select project_id, date_placed_in_service, capital_event_id,
1864: capital_hold_flag, project_asset_type
1865: from pa_project_assets
1866: where project_asset_id = nvl(p_asset_id,0);
1867:
1868: l_amount_type varchar2(1) := Null;
1869: l_tbc_flag varchar2(1);

Line 1928: extn_capital_hold_flag pa_project_assets_all.capital_hold_flag%TYPE;

1924: curr_capital_event_id pa_capital_events.capital_event_id%TYPE;
1925: prev_capital_event_id pa_capital_events.capital_event_id%TYPE;
1926: v_retirement_cost_type pa_project_asset_lines_all.retirement_cost_type%TYPE := NULL;
1927: extn_capital_event_id pa_capital_events.capital_event_id%TYPE;
1928: extn_capital_hold_flag pa_project_assets_all.capital_hold_flag%TYPE;
1929: extn_project_asset_type pa_project_assets_all.project_asset_type%TYPE;
1930:
1931: extn_project_id number(15);
1932: extn_date_in_service date;

Line 1929: extn_project_asset_type pa_project_assets_all.project_asset_type%TYPE;

1925: prev_capital_event_id pa_capital_events.capital_event_id%TYPE;
1926: v_retirement_cost_type pa_project_asset_lines_all.retirement_cost_type%TYPE := NULL;
1927: extn_capital_event_id pa_capital_events.capital_event_id%TYPE;
1928: extn_capital_hold_flag pa_project_assets_all.capital_hold_flag%TYPE;
1929: extn_project_asset_type pa_project_assets_all.project_asset_type%TYPE;
1930:
1931: extn_project_id number(15);
1932: extn_date_in_service date;
1933: extn_error_code varchar2(1);

Line 2501: pa_project_assets ppa

2497: AND pal.line_type = x_line_type
2498: AND exists
2499: (SELECT null -- Update project asset lines belonging to new assets
2500: FROM
2501: pa_project_assets ppa
2502: WHERE
2503: ppa.project_id = pal.project_id
2504: AND ppa.project_asset_id = pal.project_asset_id
2505: AND

Line 2574: pa_project_assets ppa

2570: AND pal.project_asset_id IN
2571: (SELECT
2572: ppa.project_asset_id
2573: FROM
2574: pa_project_assets ppa
2575: WHERE
2576: ppa.project_id = pal.project_id
2577: AND ppa.capitalized_flag = 'Y'
2578: );

Line 2598: pa_project_assets

2594: x_err_code := 0;
2595: x_err_stage := 'Updating the asset status';
2596:
2597: UPDATE
2598: pa_project_assets
2599: SET
2600: capitalized_flag = x_capitalized_flag,
2601: capitalized_date = sysdate,
2602: last_update_date = sysdate,

Line 2633: pa_project_assets

2629:
2630: IF x_adjustment_type = 'R' THEN
2631: --this is a reversing adjustment so do NOT update capitalized_date
2632: UPDATE
2633: pa_project_assets
2634: SET
2635: cost_adjustment_flag = x_adjustment_flag,
2636: last_update_date = sysdate,
2637: last_updated_by = x_last_updated_by,

Line 2648: pa_project_assets

2644: project_asset_id = x_project_asset_id;
2645: ELSE
2646: --this is a non-reversing adjustment. Update capitalized_date
2647: UPDATE
2648: pa_project_assets
2649: SET
2650: cost_adjustment_flag = x_adjustment_flag,
2651: capitalized_date = sysdate,
2652: last_update_date = sysdate,

Line 2700: v_fa_asset_id PA_PROJECT_ASSETS_ALL.fa_asset_id%TYPE;

2696: faassetrec selfaassets%ROWTYPE;
2697: -- Fix for bug : 4878878
2698: -- PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
2699:
2700: v_fa_asset_id PA_PROJECT_ASSETS_ALL.fa_asset_id%TYPE;
2701:
2702:
2703: BEGIN
2704:

Line 2717: FROM pa_project_assets_all

2713: --if the project asset has been Tied Back.
2714:
2715: SELECT fa_asset_id
2716: INTO v_fa_asset_id
2717: FROM pa_project_assets_all
2718: WHERE project_asset_id = x_project_asset_id;
2719:
2720: IF v_fa_asset_id IS NOT NULL THEN
2721:

Line 2824: pa_project_assets ppa

2820: AND exists
2821: (SELECT
2822: 'Yes'
2823: FROM
2824: pa_project_assets ppa
2825: WHERE
2826: ppa.project_asset_id = pal.project_asset_id
2827: AND ppa.capitalized_flag = 'N'
2828: AND ppa.reverse_flag||'' = 'N'

Line 3335: pa_project_assets ppa,

3331: ppa.serial_number,
3332: ppa.tag_number
3333: FROM
3334: pa_project_asset_lines pal,
3335: pa_project_assets ppa,
3336: pa_projects pp,
3337: pa_project_types ppt
3338: WHERE
3339: pal.project_asset_id = ppa.project_asset_id

Line 4090: from pa_project_assets ppa

4086: where pal.project_id = ppr.project_id
4087: and pal.rev_proj_asset_line_id IS NULL -- This line is not an adjustment
4088: and pal.transfer_status_code <> 'T')
4089: or exists ( select 'x' -- project has assets to be reverse capitalized
4090: from pa_project_assets ppa
4091: where ppa.project_id+0 = ppr.project_id
4092: and ppa.reverse_flag = 'Y'));
4093: */
4094:

Line 4173: pa_project_assets table since the client code has not been fired at this point.

4169: --with a Capital Event Processing method of 'None'. This logic is not executed
4170: --when run for a specific Event.
4171: /*bug 5642019 - this piece of code moved inside projrec loop.In case when PA_CLIENT_EXTN_ASSET_CREATION
4172: is used to create project assets procedure no_event_projects will fail to update
4173: pa_project_assets table since the client code has not been fired at this point.
4174: IF x_capital_event_id IS NULL THEN
4175:
4176: PA_FAXFACE.NO_EVENT_PROJECTS
4177: ( x_project_num_from => x_project_num_from,

Line 4620: pa_project_assets ppa

4616: pal.transfer_status_code||'' IN ('P','R')
4617: and (exists
4618: (SELECT 'x'
4619: FROM
4620: pa_project_assets ppa
4621: WHERE ppa.project_id = ppr.project_id
4622: AND ppa.reverse_flag||'' = 'N'
4623: AND TRUNC(ppa.date_placed_in_service) <=
4624: TRUNC(NVL(x_in_service_date_through,ppa.date_placed_in_service))

Line 4631: pa_project_assets ppa

4627: )
4628: or exists
4629: (SELECT 'x'
4630: FROM
4631: pa_project_assets ppa
4632: WHERE ppa.project_id = ppr.project_id
4633: AND ppa.reverse_flag||'' = 'N'
4634: AND ppa.capitalized_flag ='Y'
4635: AND TRUNC(ppa.date_placed_in_service) <=

Line 4643: pa_project_assets ppa

4639: )
4640: or exists
4641: (SELECT 'x'
4642: FROM
4643: pa_project_assets ppa
4644: WHERE ppa.project_id = ppr.project_id
4645: AND ppa.capitalized_flag = 'Y'
4646: AND pal.rev_proj_asset_line_id is not null
4647: AND pal.project_asset_id = ppa.project_asset_id

Line 5017: FROM pa_project_assets ppa

5013: WHERE pal.project_id = p_project_id
5014: AND pal.rev_proj_asset_line_id IS NULL -- This line is not an adjustment
5015: AND pal.transfer_status_code <> 'T')
5016: OR EXISTS (SELECT 'x' -- project has assets to be reverse capitalized
5017: FROM pa_project_assets ppa
5018: WHERE ppa.project_id+0 = p_project_id
5019: AND ppa.reverse_flag = 'Y');
5020: RETURN TRUE;
5021:

Line 5035: FROM pa_project_assets ppa

5031:
5032: SELECT 1 INTO dummy
5033: FROM DUAL
5034: WHERE EXISTS (SELECT 'x' -- project has assets to be reverse capitalized
5035: FROM pa_project_assets ppa
5036: WHERE ppa.project_id+0 = p_project_id
5037: AND ppa.reverse_flag = 'Y'
5038: /* Automatic asset capitalization changes JPULTORAK 04-FEB-03 */
5039: AND capital_event_id = NVL(p_capital_event_id, capital_event_id)

Line 5273: UPDATE pa_project_assets

5269:
5270: --If CCID value has changed, update Project Asset row
5271: IF NVL(x_out_deprn_expense_ccid,-999) <> NVL(x_in_deprn_expense_ccid,-999) THEN
5272:
5273: UPDATE pa_project_assets
5274: SET depreciation_expense_ccid = x_out_deprn_expense_ccid,
5275: last_update_date = SYSDATE,
5276: last_updated_by = x_last_updated_by,
5277: last_update_login = x_last_update_login,

Line 5333: pa_project_assets ppa,

5329: pal.current_asset_cost,
5330: pal.gl_date
5331: FROM
5332: pa_project_asset_lines pal,
5333: pa_project_assets ppa,
5334: pa_projects pp,
5335: pa_project_types ppt
5336: WHERE
5337: pal.project_asset_id = ppa.project_asset_id

Line 5644: UPDATE pa_project_assets_all

5640:
5641: IF is_no_event_proj = 'Y' then
5642:
5643: --Update all project assets that have a DPIS (AS-BUILT or RETIREMENT_ADJUSTMENT)
5644: UPDATE pa_project_assets_all
5645: SET capital_event_id = -1,
5646: last_update_date = SYSDATE,
5647: last_updated_by = x_last_updated_by,
5648: last_update_login = x_last_update_login,