149: If x_rowid is null then
150: UPDATE fa_asset_history
151: SET asset_id = decode(X_Asset_Id,
152: NULL, asset_id,
153: FND_API.G_MISS_NUM, null,
154: X_Asset_Id),
155: category_id = decode(X_Category_Id,
156: NULL, category_id,
157: FND_API.G_MISS_NUM, null,
153: FND_API.G_MISS_NUM, null,
154: X_Asset_Id),
155: category_id = decode(X_Category_Id,
156: NULL, category_id,
157: FND_API.G_MISS_NUM, null,
158: X_Category_Id),
159: asset_type = decode(X_Asset_Type,
160: NULL, asset_type,
161: FND_API.G_MISS_CHAR, null,
157: FND_API.G_MISS_NUM, null,
158: X_Category_Id),
159: asset_type = decode(X_Asset_Type,
160: NULL, asset_type,
161: FND_API.G_MISS_CHAR, null,
162: X_Asset_Type),
163: units = decode(X_Units,
164: NULL, units,
165: FND_API.G_MISS_NUM, null,
161: FND_API.G_MISS_CHAR, null,
162: X_Asset_Type),
163: units = decode(X_Units,
164: NULL, units,
165: FND_API.G_MISS_NUM, null,
166: X_Units),
167: date_effective = decode(X_Date_Effective,
168: NULL, date_effective,
169: X_Date_Effective),
171: NULL, date_ineffective,
172: X_Date_Ineffective),
173: transaction_header_id_in = decode(X_Transaction_Header_Id_In,
174: NULL, transaction_header_id_in,
175: FND_API.G_MISS_NUM, null,
176: X_Transaction_Header_Id_In),
177: transaction_header_id_out = decode(X_Transaction_Header_Id_Out,
178: NULL, transaction_header_id_out,
179: FND_API.G_MISS_NUM, null,
175: FND_API.G_MISS_NUM, null,
176: X_Transaction_Header_Id_In),
177: transaction_header_id_out = decode(X_Transaction_Header_Id_Out,
178: NULL, transaction_header_id_out,
179: FND_API.G_MISS_NUM, null,
180: X_Transaction_Header_Id_Out),
181: last_update_date = decode(X_Last_Update_Date,
182: NULL, last_update_date,
183: X_Last_Update_Date),
182: NULL, last_update_date,
183: X_Last_Update_Date),
184: last_updated_by = decode(X_Last_Updated_By,
185: NULL, last_updated_by,
186: FND_API.G_MISS_NUM, null,
187: X_Last_Updated_By),
188: last_update_login = decode(X_Last_Update_Login,
189: NULL, last_update_login,
190: FND_API.G_MISS_NUM, null,
186: FND_API.G_MISS_NUM, null,
187: X_Last_Updated_By),
188: last_update_login = decode(X_Last_Update_Login,
189: NULL, last_update_login,
190: FND_API.G_MISS_NUM, null,
191: X_Last_Update_Login)
192: WHERE asset_id = X_asset_id and
193: date_ineffective is null;
194:
195: else
196: UPDATE fa_asset_history
197: SET asset_id = decode(X_Asset_Id,
198: NULL, asset_id,
199: FND_API.G_MISS_NUM, null,
200: X_Asset_Id),
201: category_id = decode(X_Category_Id,
202: NULL, category_id,
203: FND_API.G_MISS_NUM, null,
199: FND_API.G_MISS_NUM, null,
200: X_Asset_Id),
201: category_id = decode(X_Category_Id,
202: NULL, category_id,
203: FND_API.G_MISS_NUM, null,
204: X_Category_Id),
205: asset_type = decode(X_Asset_Type,
206: NULL, asset_type,
207: FND_API.G_MISS_CHAR, null,
203: FND_API.G_MISS_NUM, null,
204: X_Category_Id),
205: asset_type = decode(X_Asset_Type,
206: NULL, asset_type,
207: FND_API.G_MISS_CHAR, null,
208: X_Asset_Type),
209: units = decode(X_Units,
210: NULL, units,
211: FND_API.G_MISS_NUM, null,
207: FND_API.G_MISS_CHAR, null,
208: X_Asset_Type),
209: units = decode(X_Units,
210: NULL, units,
211: FND_API.G_MISS_NUM, null,
212: X_Units),
213: date_effective = decode(X_Date_Effective,
214: NULL, date_effective,
215: X_Date_Effective),
217: NULL, date_ineffective,
218: X_Date_Ineffective),
219: transaction_header_id_in = decode(X_Transaction_Header_Id_In,
220: NULL, transaction_header_id_in,
221: FND_API.G_MISS_NUM, null,
222: X_Transaction_Header_Id_In),
223: transaction_header_id_out = decode(X_Transaction_Header_Id_Out,
224: NULL, transaction_header_id_out,
225: FND_API.G_MISS_NUM, null,
221: FND_API.G_MISS_NUM, null,
222: X_Transaction_Header_Id_In),
223: transaction_header_id_out = decode(X_Transaction_Header_Id_Out,
224: NULL, transaction_header_id_out,
225: FND_API.G_MISS_NUM, null,
226: X_Transaction_Header_Id_Out),
227: last_update_date = decode(X_Last_Update_Date,
228: NULL, last_update_date,
229: X_Last_Update_Date),
228: NULL, last_update_date,
229: X_Last_Update_Date),
230: last_updated_by = decode(X_Last_Updated_By,
231: NULL, last_updated_by,
232: FND_API.G_MISS_NUM, null,
233: X_Last_Updated_By),
234: last_update_login = decode(X_Last_Update_Login,
235: NULL, last_update_login,
236: FND_API.G_MISS_NUM, null,
232: FND_API.G_MISS_NUM, null,
233: X_Last_Updated_By),
234: last_update_login = decode(X_Last_Update_Login,
235: NULL, last_update_login,
236: FND_API.G_MISS_NUM, null,
237: X_Last_Update_Login)
238: WHERE rowid = X_Rowid;
239:
240: end if;