APPS.FA_ASSET_INVOICES_PKG dependencies on FA_MC_ASSET_INVOICES

Line 74: CURSOR C_ai_mc IS SELECT rowid FROM fa_mc_asset_invoices

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

Line 86: INSERT INTO fa_mc_asset_invoices(

82: BEGIN
83:
84: if (X_mrc_sob_type_code = 'R') then
85:
86: INSERT INTO fa_mc_asset_invoices(
87: set_of_books_id,
88: asset_id,
89: po_vendor_id,
90: asset_invoice_id,

Line 744: from fa_mc_asset_invoices

740:
741: if (X_Rowid is NULL) then
742: select rowid
743: into l_rowid
744: from fa_mc_asset_invoices
745: where source_line_id = X_Source_Line_Id
746: and set_of_books_id = X_set_of_books_id;
747: else
748: l_rowid := X_Rowid;

Line 751: UPDATE fa_mc_asset_invoices

747: else
748: l_rowid := X_Rowid;
749: end if;
750:
751: UPDATE fa_mc_asset_invoices
752: SET
753: asset_id = decode(X_Asset_Id,
754: FND_API.G_MISS_NUM, NULL,
755: NULL, asset_id,

Line 1264: DELETE FROM fa_mc_asset_invoices

1260: BEGIN
1261:
1262: if (X_mrc_sob_type_code = 'R') then
1263: if X_Rowid is not null then
1264: DELETE FROM fa_mc_asset_invoices
1265: WHERE rowid = X_Rowid;
1266: elsif X_Asset_Id is not null then
1267: DELETE FROM fa_mc_asset_invoices
1268: WHERE asset_id = X_Asset_Id

Line 1267: DELETE FROM fa_mc_asset_invoices

1263: if X_Rowid is not null then
1264: DELETE FROM fa_mc_asset_invoices
1265: WHERE rowid = X_Rowid;
1266: elsif X_Asset_Id is not null then
1267: DELETE FROM fa_mc_asset_invoices
1268: WHERE asset_id = X_Asset_Id
1269: AND set_of_books_id = X_set_of_books_id;
1270: else
1271: -- error message here