DBA Data[Home] [Help]

APPS.CSE_IPV_FA_PKG dependencies on CSI_TRANSACTIONS

Line 217: FROM csi_transactions

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

Line 530: csi_transactions_pvt.create_txn_error(

526: l_txn_error_rec.source_group_ref_id := l_conc_request_id;
527: l_txn_error_rec.source_type := 'AP_INVOICE_DISTRIBUTIONS_ALL';
528: l_txn_error_rec.source_id := p_invoice_rec.invoice_dist_id;
529: l_txn_error_rec.processed_flag := 'N';
530: csi_transactions_pvt.create_txn_error(
531: p_api_version => 1.0,
532: p_init_msg_list => fnd_api.g_true,
533: p_commit => fnd_api.g_false,
534: p_validation_level => fnd_api.g_valid_level_full,

Line 611: FROM csi_transactions ct

607: WHERE aila2.invoice_id = aila.invoice_id
608: AND aila2.inventory_item_id = nvl(p_inventory_item_id, aila2.inventory_item_id))
609: AND EXISTS (
610: SELECT '1'
611: FROM csi_transactions ct
612: WHERE ct.transaction_type_id in (105, 112)
613: AND ct.transaction_status_code = 'COMPLETE'
614: AND ct.source_dist_ref_id1 = aida.po_distribution_id)
615: AND EXISTS (

Line 661: FROM csi_transactions ct

657: FROM ap_invoice_distributions_all aida4
658: WHERE aida4.invoice_distribution_id = aida.charge_applicable_to_dist_id
659: AND EXISTS (
660: SELECT '1'
661: FROM csi_transactions ct
662: WHERE ct.transaction_type_id in (105, 112)
663: AND ct.transaction_status_code = 'COMPLETE'
664: AND ct.source_dist_ref_id1 = aida4.po_distribution_id)
665: AND EXISTS (

Line 707: FROM csi_transactions ct

703: AND aila2.inventory_item_id = nvl(p_inventory_item_id, aila2.inventory_item_id))
704: /*
705: AND EXISTS (
706: SELECT '1'
707: FROM csi_transactions ct
708: WHERE ct.transaction_type_id in (105, 112)
709: AND ct.transaction_status_code = 'COMPLETE'
710: AND ct.source_dist_ref_id1 = aida.po_distribution_id)
711: AND EXISTS (

Line 1045: csi_transactions_pvt.create_txn_error(

1041: l_txn_error_rec.source_group_ref_id := l_conc_request_id;
1042: l_txn_error_rec.source_type := 'AP_INVOICE_DISTRIBUTIONS_ALL';
1043: l_txn_error_rec.source_id := invoice_rec.invoice_distribution_id;
1044: l_txn_error_rec.processed_flag := 'N';
1045: csi_transactions_pvt.create_txn_error(
1046: p_api_version => 1.0,
1047: p_init_msg_list => fnd_api.g_true,
1048: p_commit => fnd_api.g_false,
1049: p_validation_level => fnd_api.g_valid_level_full,

Line 1071: csi_transactions_pvt.create_txn_error(

1067: l_txn_error_rec.source_group_ref_id := l_conc_request_id;
1068: l_txn_error_rec.source_type := 'AP_INVOICE_DISTRIBUTIONS_ALL';
1069: l_txn_error_rec.source_id := l_invoice_distribution_id;
1070: l_txn_error_rec.processed_flag := 'N';
1071: csi_transactions_pvt.create_txn_error(
1072: p_api_version => 1.0,
1073: p_init_msg_list => fnd_api.g_true,
1074: p_commit => fnd_api.g_false,
1075: p_validation_level => fnd_api.g_valid_level_full,