APPS.MC_FA_UTILITIES_PKG dependencies on FA_MC_BOOKS_RATES

Line 23: INTO fa_mc_books_rates(set_of_books_id,

19: p_currency_code in varchar2,
20: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) is
21: BEGIN
22: INSERT
23: INTO fa_mc_books_rates(set_of_books_id,
24: asset_id,
25: book_type_code,
26: transaction_header_id,
27: invoice_transaction_id,

Line 67: UPDATE fa_mc_books_rates a

63: -- This scenario is possible when posting MP and MC lines
64: -- where MC line can also have 0 fixed assets cost and
65: -- MP has 0 cost.Total cost of 0 will result in ora-1476
66:
67: UPDATE fa_mc_books_rates a
68: SET a.exchange_rate = decode(a.cost + p_cost,
69: 0, 1,
70: (a.cost * a.exchange_rate +
71: p_cost * p_exchange_rate) /

Line 93: fnd_message.set_token('TABLE', 'fa_mc_books_rates');

89: nvl(p_invoice_transaction_id,0);
90: EXCEPTION
91: WHEN OTHERS THEN
92: fnd_message.set_name('OFA','FA_MRC_UPD_MC_RECS');
93: fnd_message.set_token('TABLE', 'fa_mc_books_rates');
94: fnd_message.set_token('TRIGGER',
95: 'fa_mc_asset_invoices_aid');
96: fnd_message.set_token('ERROR',sqlerrm);
97: raise_application_error(-20000,fnd_message.get);

Line 101: fnd_message.set_token('TABLE', 'fa_mc_books_rates');

97: raise_application_error(-20000,fnd_message.get);
98: END;
99: WHEN OTHERS THEN
100: fnd_message.set_name('OFA', 'FA_MRC_INS_MC_RECS');
101: fnd_message.set_token('TABLE', 'fa_mc_books_rates');
102: fnd_message.set_token('TRIGGER', p_trigger);
103: fnd_message.set_token('ERROR',sqlerrm);
104: raise_application_error(-20000,fnd_message.get);
105: END;

Line 122: FROM fa_mc_books_rates

118: p_complete := 'N';
119: p_result_code := 'FOUND';
120: SELECT exchange_rate, avg_exchange_rate, complete
121: INTO p_exchange_rate, p_avg_exchange_rate, p_complete
122: FROM fa_mc_books_rates
123: WHERE set_of_books_id = p_set_of_books_id
124: AND transaction_header_id = p_transaction_header_id;
125: EXCEPTION
126: WHEN NO_DATA_FOUND THEN