eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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.7 2005/07/25 09:59:12 yyoon ship $ */
3:
4: PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
5: X_Asset_Id NUMBER,

Line 70: CURSOR C_ai IS SELECT rowid FROM fa_asset_invoices

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

Line 73: CURSOR C_ai_mc IS SELECT rowid FROM fa_asset_invoices_mrc_v

69: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
70: CURSOR C_ai IS SELECT rowid FROM fa_asset_invoices
71: WHERE source_line_id = X_source_line_id;
72:
73: CURSOR C_ai_mc IS SELECT rowid FROM fa_asset_invoices_mrc_v
74: WHERE source_line_id = X_source_line_id;
75:
76: CURSOR C2 IS SELECT fa_mass_additions_s.nextval FROM sys.dual;
77:

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

74: WHERE source_line_id = X_source_line_id;
75:
76: CURSOR C2 IS SELECT fa_mass_additions_s.nextval FROM sys.dual;
77:
78: CURSOR C3 is select FA_ASSET_INVOICES_S.NEXTVAL from sys.dual;
79:
80: BEGIN
81:
82: if (X_mrc_sob_type_code = 'R') then

Line 84: INSERT INTO fa_asset_invoices_mrc_v(

80: BEGIN
81:
82: if (X_mrc_sob_type_code = 'R') then
83:
84: INSERT INTO fa_asset_invoices_mrc_v(
85: asset_id,
86: po_vendor_id,
87: asset_invoice_id,
88: fixed_assets_cost,

Line 236: INSERT INTO fa_asset_invoices(

232: CLOSE C3;
233: end if;
234:
235:
236: INSERT INTO fa_asset_invoices(
237: asset_id,
238: po_vendor_id,
239: asset_invoice_id,
240: fixed_assets_cost,

Line 375: 'fa_asset_invoices_pkg.insert_row'

371:
372: exception
373: when others then
374: FA_SRVR_MSG.Add_SQL_Error(Calling_fn =>
375: 'fa_asset_invoices_pkg.insert_row'
376: ,p_log_level_rec => p_log_level_rec);
377: raise;
378: END Insert_Row;
379:

Line 488: FROM fa_asset_invoices

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

Line 739: from fa_asset_invoices_mrc_v

735:
736: if (X_Rowid is NULL) then
737: select rowid
738: into l_rowid
739: from fa_asset_invoices_mrc_v
740: where source_line_id = X_Source_Line_Id;
741: else
742: l_rowid := X_Rowid;
743: end if;

Line 745: UPDATE fa_asset_invoices_mrc_v

741: else
742: l_rowid := X_Rowid;
743: end if;
744:
745: UPDATE fa_asset_invoices_mrc_v
746: SET
747: asset_id = decode(X_Asset_Id,
748: FND_API.G_MISS_NUM, NULL,
749: NULL, asset_id,

Line 994: from fa_asset_invoices

990:
991: if (X_Rowid is NULL) then
992: select rowid
993: into l_rowid
994: from fa_asset_invoices
995: where source_line_id = X_Source_Line_Id;
996: else
997: l_rowid := X_Rowid;
998: end if;

Line 1000: UPDATE fa_asset_invoices

996: else
997: l_rowid := X_Rowid;
998: end if;
999:
1000: UPDATE fa_asset_invoices
1001: SET asset_id = decode(X_Asset_Id,
1002: FND_API.G_MISS_NUM, NULL,
1003: NULL, asset_id,
1004: X_asset_id),

Line 1244: 'fa_asset_invoices_pkg.update_row'

1240:
1241: exception
1242: when others then
1243: FA_SRVR_MSG.Add_SQL_Error(Calling_fn =>
1244: 'fa_asset_invoices_pkg.update_row'
1245: ,p_log_level_rec => p_log_level_rec);
1246: raise;
1247: END Update_Row;
1248:

Line 1259: DELETE FROM fa_asset_invoices_mrc_v

1255: BEGIN
1256:
1257: if (X_mrc_sob_type_code = 'R') then
1258: if X_Rowid is not null then
1259: DELETE FROM fa_asset_invoices_mrc_v
1260: WHERE rowid = X_Rowid;
1261: elsif X_Asset_Id is not null then
1262: DELETE FROM fa_asset_invoices_mrc_v
1263: WHERE asset_id = X_Asset_Id;

Line 1262: DELETE FROM fa_asset_invoices_mrc_v

1258: if X_Rowid is not null then
1259: DELETE FROM fa_asset_invoices_mrc_v
1260: WHERE rowid = X_Rowid;
1261: elsif X_Asset_Id is not null then
1262: DELETE FROM fa_asset_invoices_mrc_v
1263: WHERE asset_id = X_Asset_Id;
1264: else
1265: -- error message here
1266: null;

Line 1270: DELETE FROM fa_asset_invoices

1266: null;
1267: end if;
1268: else
1269: if X_Rowid is not null then
1270: DELETE FROM fa_asset_invoices
1271: WHERE rowid = X_Rowid;
1272: elsif X_Asset_Id is not null then
1273: DELETE FROM fa_asset_invoices
1274: WHERE asset_id = X_Asset_Id;

Line 1273: DELETE FROM fa_asset_invoices

1269: if X_Rowid is not null then
1270: DELETE FROM fa_asset_invoices
1271: WHERE rowid = X_Rowid;
1272: elsif X_Asset_Id is not null then
1273: DELETE FROM fa_asset_invoices
1274: WHERE asset_id = X_Asset_Id;
1275: else
1276: -- error message here
1277: null;

Line 1290: CALLING_FN => 'fa_asset_invoices_pkg.delete_row'

1286: when no_data_found then
1287: null;
1288: when others then
1289: fa_srvr_msg.add_sql_error(
1290: CALLING_FN => 'fa_asset_invoices_pkg.delete_row'
1291: ,p_log_level_rec => p_log_level_rec);
1292: raise;
1293: END Delete_Row;
1294:

Line 1295: END FA_ASSET_INVOICES_PKG;

1291: ,p_log_level_rec => p_log_level_rec);
1292: raise;
1293: END Delete_Row;
1294:
1295: END FA_ASSET_INVOICES_PKG;