APPS.FA_ASSET_INVOICES_PKG dependencies on FA_ASSET_INVOICES

Line 1: PACKAGE BODY FA_ASSET_INVOICES_PKG as

1: PACKAGE BODY FA_ASSET_INVOICES_PKG as
2: /* $Header: faxiaib.pls 120.9 2009/04/15 15:13:10 bridgway ship $ */
3:
4: PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
5: X_Asset_Id NUMBER,

Line 71: CURSOR C_ai IS SELECT rowid FROM fa_asset_invoices

67: X_mrc_sob_type_code VARCHAR2 DEFAULT 'P',
68: X_set_of_books_id NUMBER,
69: X_Calling_Fn VARCHAR2
70: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
71: CURSOR C_ai IS SELECT rowid FROM fa_asset_invoices
72: WHERE source_line_id = X_source_line_id;
73:
74: CURSOR C_ai_mc IS SELECT rowid FROM fa_mc_asset_invoices
75: WHERE source_line_id = X_source_line_id

Line 80: CURSOR C3 is select FA_ASSET_INVOICES_S.NEXTVAL from sys.dual;

76: AND set_of_books_id = X_set_of_books_id;
77:
78: CURSOR C2 IS SELECT fa_mass_additions_s.nextval FROM sys.dual;
79:
80: CURSOR C3 is select FA_ASSET_INVOICES_S.NEXTVAL from sys.dual;
81:
82: BEGIN
83:
84: if (X_mrc_sob_type_code = 'R') then

Line 240: INSERT INTO fa_asset_invoices(

236: CLOSE C3;
237: end if;
238:
239:
240: INSERT INTO fa_asset_invoices(
241: asset_id,
242: po_vendor_id,
243: asset_invoice_id,
244: fixed_assets_cost,

Line 379: 'fa_asset_invoices_pkg.insert_row', p_log_level_rec => p_log_level_rec);

375:
376: exception
377: when others then
378: FA_SRVR_MSG.Add_SQL_Error(Calling_fn =>
379: 'fa_asset_invoices_pkg.insert_row', p_log_level_rec => p_log_level_rec);
380: raise;
381: END Insert_Row;
382:
383:

Line 491: FROM fa_asset_invoices

487: split_parent_mass_additions_id,
488: project_asset_line_id,
489: project_id,
490: task_id
491: FROM fa_asset_invoices
492: WHERE rowid = X_Rowid
493: FOR UPDATE of Asset_Invoice_Id NOWAIT;
494: Recinfo C%ROWTYPE;
495:

Line 1000: from fa_asset_invoices

996:
997: if (X_Rowid is NULL) then
998: select rowid
999: into l_rowid
1000: from fa_asset_invoices
1001: where source_line_id = X_Source_Line_Id;
1002: else
1003: l_rowid := X_Rowid;
1004: end if;

Line 1006: UPDATE fa_asset_invoices

1002: else
1003: l_rowid := X_Rowid;
1004: end if;
1005:
1006: UPDATE fa_asset_invoices
1007: SET asset_id = decode(X_Asset_Id,
1008: FND_API.G_MISS_NUM, NULL,
1009: NULL, asset_id,
1010: X_asset_id),

Line 1250: 'fa_asset_invoices_pkg.update_row', p_log_level_rec => p_log_level_rec);

1246:
1247: exception
1248: when others then
1249: FA_SRVR_MSG.Add_SQL_Error(Calling_fn =>
1250: 'fa_asset_invoices_pkg.update_row', p_log_level_rec => p_log_level_rec);
1251: raise;
1252: END Update_Row;
1253:
1254: PROCEDURE Delete_Row(X_Rowid VARCHAR2 DEFAULT NULL,

Line 1276: DELETE FROM fa_asset_invoices

1272: null;
1273: end if;
1274: else
1275: if X_Rowid is not null then
1276: DELETE FROM fa_asset_invoices
1277: WHERE rowid = X_Rowid;
1278: elsif X_Asset_Id is not null then
1279: DELETE FROM fa_asset_invoices
1280: WHERE asset_id = X_Asset_Id;

Line 1279: DELETE FROM fa_asset_invoices

1275: if X_Rowid is not null then
1276: DELETE FROM fa_asset_invoices
1277: WHERE rowid = X_Rowid;
1278: elsif X_Asset_Id is not null then
1279: DELETE FROM fa_asset_invoices
1280: WHERE asset_id = X_Asset_Id;
1281: else
1282: -- error message here
1283: null;

Line 1296: CALLING_FN => 'fa_asset_invoices_pkg.delete_row', p_log_level_rec => p_log_level_rec);

1292: when no_data_found then
1293: null;
1294: when others then
1295: fa_srvr_msg.add_sql_error(
1296: CALLING_FN => 'fa_asset_invoices_pkg.delete_row', p_log_level_rec => p_log_level_rec);
1297: raise;
1298: END Delete_Row;
1299:
1300: END FA_ASSET_INVOICES_PKG;

Line 1300: END FA_ASSET_INVOICES_PKG;

1296: CALLING_FN => 'fa_asset_invoices_pkg.delete_row', p_log_level_rec => p_log_level_rec);
1297: raise;
1298: END Delete_Row;
1299:
1300: END FA_ASSET_INVOICES_PKG;