DBA Data[Home] [Help]

APPS.FA_ASSET_HISTORY_PKG dependencies on FND_API

Line 153: FND_API.G_MISS_NUM, null,

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,

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

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

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

Line 175: FND_API.G_MISS_NUM, null,

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,

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

Line 186: FND_API.G_MISS_NUM, null,

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,

Line 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:

Line 199: FND_API.G_MISS_NUM, null,

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,

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

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

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

Line 221: FND_API.G_MISS_NUM, null,

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,

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

Line 232: FND_API.G_MISS_NUM, null,

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,

Line 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;