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.CSE_IPV_FA_PKG dependencies on CSE_ASSET_UTIL_PKG

Line 236: AND fai.feeder_system_name = cse_asset_util_pkg.g_fa_feeder_name

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

Line 250: AND fma.feeder_system_name = cse_asset_util_pkg.g_fa_feeder_name

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

Line 265: AND fma.feeder_system_name = cse_asset_util_pkg.g_fa_feeder_name

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

Line 289: l_expense_ccid := cse_asset_util_pkg.deprn_expense_ccid(

285: l_asset_attrib_rec.transaction_id := csi_txn_rec.transaction_id;
286: l_asset_attrib_rec.inventory_item_id := p_invoice_rec.inventory_item_id;
287: l_asset_attrib_rec.organization_id := p_invoice_rec.organization_id;
288:
289: l_expense_ccid := cse_asset_util_pkg.deprn_expense_ccid(
290: p_asset_attrib_rec => l_asset_attrib_rec,
291: x_error_msg => l_error_message,
292: x_return_status => l_return_status);
293:

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

483: l_mass_add_rec.payables_cost := l_allocated_ipv;
484: l_mass_add_rec.fixed_assets_cost := l_allocated_ipv;
485: l_mass_add_rec.fixed_assets_units := 1;
486: --
487: l_mass_add_rec.feeder_system_name := cse_asset_util_pkg.g_fa_feeder_name;
488: l_mass_add_rec.reviewer_comments := 'IPV' ;
489: l_mass_add_rec.asset_type := 'CAPITALIZED';
490: l_mass_add_rec.depreciate_flag := 'YES' ;
491: l_mass_add_rec.creation_date := sysdate;

Line 497: cse_asset_util_pkg.insert_mass_add(

493: l_mass_add_rec.created_by := fnd_global.user_id;
494: l_mass_add_rec.last_updated_by := fnd_global.user_id;
495: l_mass_add_rec.last_update_login := fnd_global.login_id;
496:
497: cse_asset_util_pkg.insert_mass_add(
498: p_api_version => 1.0,
499: p_commit => fnd_api.g_false,
500: p_init_msg_list => fnd_api.g_true,
501: p_mass_add_rec => l_mass_add_rec,

Line 921: l_payables_ccid := cse_asset_util_pkg.get_ap_sla_acct_for_dist_id(

917: AND poh.po_header_id = pol.po_header_id;
918:
919: --Modified for bug 12991094
920: IF invoice_rec.invoice_distribution_type = 'IPV' THEN
921: l_payables_ccid := cse_asset_util_pkg.get_ap_sla_acct_for_dist_id(
922: p_invoice_distribution_id => invoice_rec.invoice_distribution_id,
923: p_invoice_id => invoice_rec.invoice_id,
924: p_invoice_dist_type => 'IPV',
925: p_self_assesed_flag => invoice_rec.self_assessed_flag);

Line 927: l_payables_ccid := cse_asset_util_pkg.get_ap_sla_acct_for_dist_id(

923: p_invoice_id => invoice_rec.invoice_id,
924: p_invoice_dist_type => 'IPV',
925: p_self_assesed_flag => invoice_rec.self_assessed_flag);
926: ELSIF invoice_rec.invoice_distribution_type = 'FREIGHT' THEN
927: l_payables_ccid := cse_asset_util_pkg.get_ap_sla_acct_for_dist_id(
928: p_invoice_distribution_id => invoice_rec.invoice_distribution_id,
929: p_invoice_id => invoice_rec.invoice_id,
930: p_invoice_dist_type => 'FREIGHT',
931: p_self_assesed_flag => invoice_rec.self_assessed_flag);

Line 933: l_payables_ccid := cse_asset_util_pkg.get_ap_sla_acct_for_dist_id(

929: p_invoice_id => invoice_rec.invoice_id,
930: p_invoice_dist_type => 'FREIGHT',
931: p_self_assesed_flag => invoice_rec.self_assessed_flag);
932: ELSIF invoice_rec.invoice_distribution_type = 'REC_TAX' THEN
933: l_payables_ccid := cse_asset_util_pkg.get_ap_sla_acct_for_dist_id(
934: p_invoice_distribution_id => invoice_rec.invoice_distribution_id,
935: p_invoice_id => invoice_rec.invoice_id,
936: p_invoice_dist_type => 'RTAX',
937: p_self_assesed_flag => invoice_rec.self_assessed_flag);

Line 939: l_payables_ccid := cse_asset_util_pkg.get_ap_sla_acct_for_dist_id(

935: p_invoice_id => invoice_rec.invoice_id,
936: p_invoice_dist_type => 'RTAX',
937: p_self_assesed_flag => invoice_rec.self_assessed_flag);
938: ELSIF invoice_rec.invoice_distribution_type = 'NONREC_TAX' THEN
939: l_payables_ccid := cse_asset_util_pkg.get_ap_sla_acct_for_dist_id(
940: p_invoice_distribution_id => invoice_rec.invoice_distribution_id,
941: p_invoice_id => invoice_rec.invoice_id,
942: p_invoice_dist_type => 'NRTAX',
943: p_self_assesed_flag => invoice_rec.self_assessed_flag);

Line 945: l_payables_ccid := cse_asset_util_pkg.get_ap_sla_acct_for_dist_id(

941: p_invoice_id => invoice_rec.invoice_id,
942: p_invoice_dist_type => 'NRTAX',
943: p_self_assesed_flag => invoice_rec.self_assessed_flag);
944: ELSIF invoice_rec.invoice_distribution_type = 'TRV' THEN --Added for bug 13647752
945: l_payables_ccid := cse_asset_util_pkg.get_ap_sla_acct_for_dist_id(
946: p_invoice_distribution_id => invoice_rec.invoice_distribution_id,
947: p_invoice_id => invoice_rec.invoice_id,
948: p_invoice_dist_type => 'TRV',
949: p_self_assesed_flag => invoice_rec.self_assessed_flag);

Line 951: l_payables_ccid := cse_asset_util_pkg.get_ap_sla_acct_for_dist_id(

947: p_invoice_id => invoice_rec.invoice_id,
948: p_invoice_dist_type => 'TRV',
949: p_self_assesed_flag => invoice_rec.self_assessed_flag);
950: ELSIF invoice_rec.invoice_distribution_type = 'TIPV' THEN -- Added for bug 13770784
951: l_payables_ccid := cse_asset_util_pkg.get_ap_sla_acct_for_dist_id(
952: p_invoice_distribution_id => invoice_rec.invoice_distribution_id,
953: p_invoice_id => invoice_rec.invoice_id,
954: p_invoice_dist_type => 'TIPV',
955: p_self_assesed_flag => invoice_rec.self_assessed_flag);

Line 957: l_payables_ccid := cse_asset_util_pkg.get_ap_sla_acct_for_dist_id(

953: p_invoice_id => invoice_rec.invoice_id,
954: p_invoice_dist_type => 'TIPV',
955: p_self_assesed_flag => invoice_rec.self_assessed_flag);
956: ELSIF invoice_rec.invoice_distribution_type = 'ERV' THEN -- Added for bug 13770784
957: l_payables_ccid := cse_asset_util_pkg.get_ap_sla_acct_for_dist_id(
958: p_invoice_distribution_id => invoice_rec.invoice_distribution_id,
959: p_invoice_id => invoice_rec.invoice_id,
960: p_invoice_dist_type => 'EXCHANGE_RATE_VARIANCE',
961: p_self_assesed_flag => invoice_rec.self_assessed_flag);