APPS.PA_FAXFACE dependencies on PA_PROJECT_ASSETS_ALL

Line 2173: extn_capital_hold_flag pa_project_assets_all.capital_hold_flag%TYPE;

2169: curr_capital_event_id pa_capital_events.capital_event_id%TYPE;
2170: prev_capital_event_id pa_capital_events.capital_event_id%TYPE;
2171: v_retirement_cost_type pa_project_asset_lines_all.retirement_cost_type%TYPE := NULL;
2172: extn_capital_event_id pa_capital_events.capital_event_id%TYPE;
2173: extn_capital_hold_flag pa_project_assets_all.capital_hold_flag%TYPE;
2174: extn_project_asset_type pa_project_assets_all.project_asset_type%TYPE;
2175:
2176: extn_project_id number(15);
2177: extn_date_in_service date;

Line 2174: extn_project_asset_type pa_project_assets_all.project_asset_type%TYPE;

2170: prev_capital_event_id pa_capital_events.capital_event_id%TYPE;
2171: v_retirement_cost_type pa_project_asset_lines_all.retirement_cost_type%TYPE := NULL;
2172: extn_capital_event_id pa_capital_events.capital_event_id%TYPE;
2173: extn_capital_hold_flag pa_project_assets_all.capital_hold_flag%TYPE;
2174: extn_project_asset_type pa_project_assets_all.project_asset_type%TYPE;
2175:
2176: extn_project_id number(15);
2177: extn_date_in_service date;
2178: extn_error_code varchar2(1);

Line 3033: v_fa_asset_id PA_PROJECT_ASSETS_ALL.fa_asset_id%TYPE;

3029: faassetrec selfaassets%ROWTYPE;
3030: -- Fix for bug : 4878878
3031: -- PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
3032:
3033: v_fa_asset_id PA_PROJECT_ASSETS_ALL.fa_asset_id%TYPE;
3034:
3035:
3036: BEGIN
3037:

Line 3050: FROM pa_project_assets_all

3046: --if the project asset has been Tied Back.
3047:
3048: SELECT fa_asset_id
3049: INTO v_fa_asset_id
3050: FROM pa_project_assets_all
3051: WHERE project_asset_id = x_project_asset_id;
3052:
3053: IF v_fa_asset_id IS NOT NULL THEN
3054:

Line 6030: UPDATE pa_project_assets_all

6026:
6027: IF is_no_event_proj = 'Y' then
6028:
6029: --Update all project assets that have a DPIS (AS-BUILT or RETIREMENT_ADJUSTMENT)
6030: UPDATE pa_project_assets_all
6031: SET capital_event_id = -1,
6032: last_update_date = SYSDATE,
6033: last_updated_by = x_last_updated_by,
6034: last_update_login = x_last_update_login,