APPS.FA_ASSET_INVOICES_PKG dependencies on FA_ASSET_INVOICES_MRC_V

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