APPS.CSE_IPV_FA_PKG dependencies on CSE_ASSET_UTIL_PKG

Line 232: AND fai.feeder_system_name = cse_asset_util_pkg.g_fa_feeder_name

228: AND cia.fa_asset_id is not null
229: AND EXISTS (
230: SELECT 1 FROM fa_asset_invoices fai
231: WHERE fai.asset_id = cia.fa_asset_id
232: AND fai.feeder_system_name = cse_asset_util_pkg.g_fa_feeder_name
233: AND fai.po_distribution_id = p_po_dist_id)
234: UNION
235: SELECT cia.fa_mass_addition_id fa_id,
236: cia.fa_book_type_code fa_book_type_code,

Line 246: AND fma.feeder_system_name = cse_asset_util_pkg.g_fa_feeder_name

242: AND cia.fa_asset_id is null
243: AND EXISTS (
244: SELECT 1 FROM fa_mass_additions fma
245: WHERE fma.mass_addition_id = cia.fa_mass_addition_id
246: AND fma.feeder_system_name = cse_asset_util_pkg.g_fa_feeder_name
247: AND fma.po_distribution_id = p_po_dist_id);
248:
249: CURSOR fma_cur(p_csi_txn_id IN number, p_book_type_code in VARCHAR2) IS
250: SELECT fma.mass_addition_id,

Line 261: AND fma.feeder_system_name = cse_asset_util_pkg.g_fa_feeder_name

257: fa_mass_additions fma,
258: fa_massadd_distributions fmd
259: WHERE ciih.transaction_id = p_csi_txn_id
260: AND fma.reviewer_comments = to_char(ciih.instance_id)
261: AND fma.feeder_system_name = cse_asset_util_pkg.g_fa_feeder_name
262: AND fma.posting_status <> 'POSTED'
263: AND fma.book_type_code = p_book_type_code
264: AND fma.add_to_asset_id IS null
265: AND fma.split_merged_code = 'MP'

Line 285: l_expense_ccid := cse_asset_util_pkg.deprn_expense_ccid(

281: l_asset_attrib_rec.transaction_id := csi_txn_rec.transaction_id;
282: l_asset_attrib_rec.inventory_item_id := p_invoice_rec.inventory_item_id;
283: l_asset_attrib_rec.organization_id := p_invoice_rec.organization_id;
284:
285: l_expense_ccid := cse_asset_util_pkg.deprn_expense_ccid(
286: p_asset_attrib_rec => l_asset_attrib_rec,
287: x_error_msg => l_error_message,
288: x_return_status => l_return_status);
289:

Line 441: l_mass_add_rec.feeder_system_name := cse_asset_util_pkg.g_fa_feeder_name;

437: l_mass_add_rec.payables_cost := l_allocated_ipv;
438: l_mass_add_rec.fixed_assets_cost := l_allocated_ipv;
439: l_mass_add_rec.fixed_assets_units := 1;
440: --
441: l_mass_add_rec.feeder_system_name := cse_asset_util_pkg.g_fa_feeder_name;
442: l_mass_add_rec.reviewer_comments := 'IPV' ;
443: l_mass_add_rec.asset_type := 'CAPITALIZED';
444: l_mass_add_rec.depreciate_flag := 'YES' ;
445: l_mass_add_rec.creation_date := sysdate;

Line 451: cse_asset_util_pkg.insert_mass_add(

447: l_mass_add_rec.created_by := fnd_global.user_id;
448: l_mass_add_rec.last_updated_by := fnd_global.user_id;
449: l_mass_add_rec.last_update_login := fnd_global.login_id;
450:
451: cse_asset_util_pkg.insert_mass_add(
452: p_api_version => 1.0,
453: p_commit => fnd_api.g_false,
454: p_init_msg_list => fnd_api.g_true,
455: p_mass_add_rec => l_mass_add_rec,

Line 693: l_payables_ccid := cse_asset_util_pkg.get_ap_sla_acct_id(

689: WHERE pod.po_distribution_id = invoice_rec.po_distribution_id
690: AND pol.po_line_id = pod.po_line_id
691: AND poh.po_header_id = pol.po_header_id;
692:
693: l_payables_ccid := cse_asset_util_pkg.get_ap_sla_acct_id(
694: p_invoice_id => invoice_rec.invoice_id,
695: p_invoice_dist_type => 'IPV');
696:
697: debug(' price_variance_ccid : '||l_payables_ccid);