APPS.CSI_INV_TXNSTUB_PKG dependencies on CSI_TRANSACTIONS

Line 51: FROM csi_transactions

47: l_link_to_line_id NUMBER; --Code added for MACD enhancement
48:
49: CURSOR c_csi_inv_exist_txns (pc_transaction_id IN NUMBER) is
50: SELECT transaction_id
51: FROM csi_transactions
52: WHERE inv_material_transaction_id = pc_transaction_id;
53:
54: r_csi_inv_exist_txns c_csi_inv_exist_txns%rowtype;
55:

Line 58: FROM csi_transactions

54: r_csi_inv_exist_txns c_csi_inv_exist_txns%rowtype;
55:
56: CURSOR c_csi_soful_exist_txns (pc_transaction_id IN NUMBER) IS
57: SELECT transaction_id
58: FROM csi_transactions
59: WHERE source_line_ref_id = pc_transaction_id
60: AND transaction_type_id in (51,54,401);
61:
62: r_csi_soful_exist_txns c_csi_soful_exist_txns%rowtype;

Line 96: -- Check to see if any CSI Transactions Exist. If it does then just exit if there is not

92: debug('Install Parameter Datastructure Populated');
93: debug(' Ownership Override: '||csi_datastructures_pub.g_install_param_rec.ownership_override_at_txn);
94: debug(' SFM Flag: '||csi_datastructures_pub.g_install_param_rec.sfm_queue_bypass_flag);
95:
96: -- Check to see if any CSI Transactions Exist. If it does then just exit if there is not
97: -- then process as normal
98:
99: IF p_transaction_type in ('CSISOFUL','CSIRMAFL') THEN
100: