DBA Data[Home] [Help]

APPS.CSE_AP_PA_PKG dependencies on CSI_TRANSACTIONS

Line 433: SELECT '1' FROM csi_transactions ct

429: ap_invoice_distributions_all aida,
430: ap_invoice_lines_all aila,
431: ap_invoices_all aia
432: WHERE EXISTS (
433: SELECT '1' FROM csi_transactions ct
434: WHERE ct.transaction_type_id = 105
435: AND ct.transaction_status_code = 'COMPLETE'
436: AND ct.source_dist_ref_id1 = pda.po_distribution_id)
437: AND pda.project_id = nvl(p_project_id, pda.project_id)

Line 732: csi_transactions_pvt.create_txn_error(

728: l_txn_error_rec.source_type := 'CSEIPVP';
729: l_txn_error_rec.source_id := l_inv_dist_id;
730: l_txn_error_rec.processed_flag := 'N';
731:
732: csi_transactions_pvt.create_txn_error(
733: p_api_version => 1.0 ,
734: p_init_msg_list => fnd_api.g_true,
735: p_commit => fnd_api.g_true,
736: p_validation_level => fnd_api.g_valid_level_full,