DBA Data[Home] [Help]

APPS.PA_FA_TIEBACK_PVT dependencies on PA_PROJECT_ASSETS_ALL

Line 188: UPDATE pa_project_assets_all

184: PA_DEBUG.WRITE_FILE('LOG',TO_CHAR(SYSDATE,'HH:MI:SS')||': '||'Tieback project asset with asset number, fa_asset_id and fa period');
185: END IF;
186:
187: --Update project asset with asset number and FA period name
188: UPDATE pa_project_assets_all
189: SET asset_number = v_asset_number,
190: fa_asset_id = v_asset_id,
191: fa_period_name = v_fa_period_name,
192: last_update_date = SYSDATE,

Line 209: UPDATE pa_project_assets_all

205: PA_DEBUG.WRITE_FILE('LOG',TO_CHAR(SYSDATE,'HH:MI:SS')||': '||'Tieback project asset with fa_asset_id and fa period');
206: END IF;
207:
208: --Just update the FA Period Name and FA Asset ID
209: UPDATE pa_project_assets_all
210: SET fa_period_name = v_fa_period_name,
211: fa_asset_id = v_asset_id,
212: last_update_date = SYSDATE,
213: last_updated_by = v_user,