APPS.CSE_IPV_FA_PKG dependencies on CSI_TRANSACTIONS

Line 213: FROM csi_transactions

209: SELECT transaction_id,
210: inv_material_transaction_id,
211: transaction_quantity,
212: transaction_uom_code
213: FROM csi_transactions
214: WHERE source_dist_ref_id1 = p_po_dist_id
215: AND transaction_type_id IN (105, 112) -- po rcpt in to proj/inv
216: AND transaction_status_code = 'COMPLETE';
217:

Line 484: csi_transactions_pvt.create_txn_error(

480: l_txn_error_rec.source_group_ref_id := l_conc_request_id;
481: l_txn_error_rec.source_type := 'AP_INVOICE_DISTRIBUTIONS_ALL';
482: l_txn_error_rec.source_id := p_invoice_rec.invoice_dist_id;
483: l_txn_error_rec.processed_flag := 'N';
484: csi_transactions_pvt.create_txn_error(
485: p_api_version => 1.0,
486: p_init_msg_list => fnd_api.g_true,
487: p_commit => fnd_api.g_false,
488: p_validation_level => fnd_api.g_valid_level_full,

Line 545: FROM csi_transactions ct

541: AND aila.inventory_item_id = nvl(p_inventory_item_id, aila.inventory_item_id)
542: AND aia.invoice_id = aida.invoice_id
543: AND EXISTS (
544: SELECT '1'
545: FROM csi_transactions ct
546: WHERE ct.transaction_type_id in (105, 112)
547: AND ct.transaction_status_code = 'COMPLETE'
548: AND ct.source_dist_ref_id1 = aida.po_distribution_id)
549: AND EXISTS (

Line 753: csi_transactions_pvt.create_txn_error(

749: l_txn_error_rec.source_group_ref_id := l_conc_request_id;
750: l_txn_error_rec.source_type := 'AP_INVOICE_DISTRIBUTIONS_ALL';
751: l_txn_error_rec.source_id := invoice_rec.invoice_distribution_id;
752: l_txn_error_rec.processed_flag := 'N';
753: csi_transactions_pvt.create_txn_error(
754: p_api_version => 1.0,
755: p_init_msg_list => fnd_api.g_true,
756: p_commit => fnd_api.g_false,
757: p_validation_level => fnd_api.g_valid_level_full,

Line 779: csi_transactions_pvt.create_txn_error(

775: l_txn_error_rec.source_group_ref_id := l_conc_request_id;
776: l_txn_error_rec.source_type := 'AP_INVOICE_DISTRIBUTIONS_ALL';
777: l_txn_error_rec.source_id := l_invoice_distribution_id;
778: l_txn_error_rec.processed_flag := 'N';
779: csi_transactions_pvt.create_txn_error(
780: p_api_version => 1.0,
781: p_init_msg_list => fnd_api.g_true,
782: p_commit => fnd_api.g_false,
783: p_validation_level => fnd_api.g_valid_level_full,