DBA Data[Home] [Help]

APPS.CSE_AP_PA_PKG dependencies on CSI_TRANSACTIONS

Line 446: SELECT '1' FROM csi_transactions ct

442: ap_invoice_distributions_all aida,
443: ap_invoice_lines_all aila,
444: ap_invoices_all aia
445: WHERE EXISTS (
446: SELECT '1' FROM csi_transactions ct
447: WHERE ct.transaction_type_id = 105
448: AND ct.transaction_status_code = 'COMPLETE'
449: AND ct.source_dist_ref_id1 = pda.po_distribution_id)
450: AND pda.project_id = nvl(p_project_id, pda.project_id)

Line 806: csi_transactions_pvt.create_txn_error(

802: l_txn_error_rec.source_type := 'CSEIPVP';
803: l_txn_error_rec.source_id := l_inv_dist_id;
804: l_txn_error_rec.processed_flag := 'N';
805:
806: csi_transactions_pvt.create_txn_error(
807: p_api_version => 1.0 ,
808: p_init_msg_list => fnd_api.g_true,
809: p_commit => fnd_api.g_true,
810: p_validation_level => fnd_api.g_valid_level_full,