DBA Data[Home] [Help]

APPS.CSI_WIP_TRXS_PKG dependencies on CSI_TRANSACTIONS

Line 3712: FROM csi_transactions

3708: IS
3709:
3710: CURSOR csi_txn_cur IS
3711: SELECT transaction_id
3712: FROM csi_transactions
3713: WHERE inv_material_transaction_id = p_transaction_id;
3714:
3715: BEGIN
3716: x_return_status := fnd_api.g_ret_sts_success;

Line 3837: SELECT 'X' FROM csi_transactions

3833: SELECT 'Y'
3834: INTO l_csi_txn_found
3835: FROM sys.dual
3836: WHERE exists (
3837: SELECT 'X' FROM csi_transactions
3838: WHERE inv_material_transaction_id = compl_rec.transaction_id);
3839: l_completion_found := TRUE;
3840: EXCEPTION
3841: WHEN no_data_found THEN

Line 3863: SELECT 'X' FROM csi_transactions

3859: SELECT 'Y'
3860: INTO l_csi_txn_found
3861: FROM sys.dual
3862: WHERE exists (
3863: SELECT 'X' FROM csi_transactions
3864: WHERE inv_material_transaction_id = issue_rec.transaction_id);
3865: l_issues_found := TRUE;
3866: EXCEPTION
3867: WHEN no_data_found THEN