APPS.PA_FAXFACE dependencies on PA_PROJECT_ASSETS_ALL

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 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 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,