DBA Data[Home] [Help]

APPS.FA_ASSET_HISTORY_PKG dependencies on FND_API

Line 152: FND_API.G_MISS_NUM, null,

148: If x_rowid is null then
149: UPDATE fa_asset_history
150: SET asset_id = decode(X_Asset_Id,
151: NULL, asset_id,
152: FND_API.G_MISS_NUM, null,
153: X_Asset_Id),
154: category_id = decode(X_Category_Id,
155: NULL, category_id,
156: FND_API.G_MISS_NUM, null,

Line 156: FND_API.G_MISS_NUM, null,

152: FND_API.G_MISS_NUM, null,
153: X_Asset_Id),
154: category_id = decode(X_Category_Id,
155: NULL, category_id,
156: FND_API.G_MISS_NUM, null,
157: X_Category_Id),
158: asset_type = decode(X_Asset_Type,
159: NULL, asset_type,
160: FND_API.G_MISS_CHAR, null,

Line 160: FND_API.G_MISS_CHAR, null,

156: FND_API.G_MISS_NUM, null,
157: X_Category_Id),
158: asset_type = decode(X_Asset_Type,
159: NULL, asset_type,
160: FND_API.G_MISS_CHAR, null,
161: X_Asset_Type),
162: units = decode(X_Units,
163: NULL, units,
164: FND_API.G_MISS_NUM, null,

Line 164: FND_API.G_MISS_NUM, null,

160: FND_API.G_MISS_CHAR, null,
161: X_Asset_Type),
162: units = decode(X_Units,
163: NULL, units,
164: FND_API.G_MISS_NUM, null,
165: X_Units),
166: date_effective = decode(X_Date_Effective,
167: NULL, date_effective,
168: X_Date_Effective),

Line 174: FND_API.G_MISS_NUM, null,

170: NULL, date_ineffective,
171: X_Date_Ineffective),
172: transaction_header_id_in = decode(X_Transaction_Header_Id_In,
173: NULL, transaction_header_id_in,
174: FND_API.G_MISS_NUM, null,
175: X_Transaction_Header_Id_In),
176: transaction_header_id_out = decode(X_Transaction_Header_Id_Out,
177: NULL, transaction_header_id_out,
178: FND_API.G_MISS_NUM, null,

Line 178: FND_API.G_MISS_NUM, null,

174: FND_API.G_MISS_NUM, null,
175: X_Transaction_Header_Id_In),
176: transaction_header_id_out = decode(X_Transaction_Header_Id_Out,
177: NULL, transaction_header_id_out,
178: FND_API.G_MISS_NUM, null,
179: X_Transaction_Header_Id_Out),
180: last_update_date = decode(X_Last_Update_Date,
181: NULL, last_update_date,
182: X_Last_Update_Date),

Line 185: FND_API.G_MISS_NUM, null,

181: NULL, last_update_date,
182: X_Last_Update_Date),
183: last_updated_by = decode(X_Last_Updated_By,
184: NULL, last_updated_by,
185: FND_API.G_MISS_NUM, null,
186: X_Last_Updated_By),
187: last_update_login = decode(X_Last_Update_Login,
188: NULL, last_update_login,
189: FND_API.G_MISS_NUM, null,

Line 189: FND_API.G_MISS_NUM, null,

185: FND_API.G_MISS_NUM, null,
186: X_Last_Updated_By),
187: last_update_login = decode(X_Last_Update_Login,
188: NULL, last_update_login,
189: FND_API.G_MISS_NUM, null,
190: X_Last_Update_Login)
191: WHERE asset_id = X_asset_id and
192: date_ineffective is null;
193:

Line 198: FND_API.G_MISS_NUM, null,

194: else
195: UPDATE fa_asset_history
196: SET asset_id = decode(X_Asset_Id,
197: NULL, asset_id,
198: FND_API.G_MISS_NUM, null,
199: X_Asset_Id),
200: category_id = decode(X_Category_Id,
201: NULL, category_id,
202: FND_API.G_MISS_NUM, null,

Line 202: FND_API.G_MISS_NUM, null,

198: FND_API.G_MISS_NUM, null,
199: X_Asset_Id),
200: category_id = decode(X_Category_Id,
201: NULL, category_id,
202: FND_API.G_MISS_NUM, null,
203: X_Category_Id),
204: asset_type = decode(X_Asset_Type,
205: NULL, asset_type,
206: FND_API.G_MISS_CHAR, null,

Line 206: FND_API.G_MISS_CHAR, null,

202: FND_API.G_MISS_NUM, null,
203: X_Category_Id),
204: asset_type = decode(X_Asset_Type,
205: NULL, asset_type,
206: FND_API.G_MISS_CHAR, null,
207: X_Asset_Type),
208: units = decode(X_Units,
209: NULL, units,
210: FND_API.G_MISS_NUM, null,

Line 210: FND_API.G_MISS_NUM, null,

206: FND_API.G_MISS_CHAR, null,
207: X_Asset_Type),
208: units = decode(X_Units,
209: NULL, units,
210: FND_API.G_MISS_NUM, null,
211: X_Units),
212: date_effective = decode(X_Date_Effective,
213: NULL, date_effective,
214: X_Date_Effective),

Line 220: FND_API.G_MISS_NUM, null,

216: NULL, date_ineffective,
217: X_Date_Ineffective),
218: transaction_header_id_in = decode(X_Transaction_Header_Id_In,
219: NULL, transaction_header_id_in,
220: FND_API.G_MISS_NUM, null,
221: X_Transaction_Header_Id_In),
222: transaction_header_id_out = decode(X_Transaction_Header_Id_Out,
223: NULL, transaction_header_id_out,
224: FND_API.G_MISS_NUM, null,

Line 224: FND_API.G_MISS_NUM, null,

220: FND_API.G_MISS_NUM, null,
221: X_Transaction_Header_Id_In),
222: transaction_header_id_out = decode(X_Transaction_Header_Id_Out,
223: NULL, transaction_header_id_out,
224: FND_API.G_MISS_NUM, null,
225: X_Transaction_Header_Id_Out),
226: last_update_date = decode(X_Last_Update_Date,
227: NULL, last_update_date,
228: X_Last_Update_Date),

Line 231: FND_API.G_MISS_NUM, null,

227: NULL, last_update_date,
228: X_Last_Update_Date),
229: last_updated_by = decode(X_Last_Updated_By,
230: NULL, last_updated_by,
231: FND_API.G_MISS_NUM, null,
232: X_Last_Updated_By),
233: last_update_login = decode(X_Last_Update_Login,
234: NULL, last_update_login,
235: FND_API.G_MISS_NUM, null,

Line 235: FND_API.G_MISS_NUM, null,

231: FND_API.G_MISS_NUM, null,
232: X_Last_Updated_By),
233: last_update_login = decode(X_Last_Update_Login,
234: NULL, last_update_login,
235: FND_API.G_MISS_NUM, null,
236: X_Last_Update_Login)
237: WHERE rowid = X_Rowid;
238:
239: end if;