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 59: (SELECT transaction_id FROM csi_transactions WHERE inv_material_transaction_id = pc_transaction_id))

55:
56: CURSOR c_csi_inv_exist_txns_and_items (pc_transaction_id IN NUMBER) IS
57: SELECT instance_id FROM csi_item_instances WHERE instance_id IN
58: (SELECT instance_id FROM csi_item_instances_h WHERE transaction_id IN
59: (SELECT transaction_id FROM csi_transactions WHERE inv_material_transaction_id = pc_transaction_id))
60: AND inventory_item_id IN
61: (SELECT inventory_item_id FROM mtl_material_transactions WHERE transaction_id = pc_transaction_id)
62: AND ROWNUM = 1;
63:

Line 69: FROM csi_transactions

65:
66: --modified for bug 7623208
67: CURSOR c_csi_soful_exist_txns (pc_transaction_id IN NUMBER) IS
68: SELECT transaction_id
69: FROM csi_transactions
70: WHERE source_line_ref_id = pc_transaction_id
71: AND transaction_type_id in (51,54,401)
72: AND source_header_ref IN
73: (SELECT order_number FROM oe_order_headers_all WHERE header_id IN

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

106: debug('Install Parameter Datastructure Populated');
107: debug(' Ownership Override: '||csi_datastructures_pub.g_install_param_rec.ownership_override_at_txn);
108: debug(' SFM Flag: '||csi_datastructures_pub.g_install_param_rec.sfm_queue_bypass_flag);
109:
110: -- Check to see if any CSI Transactions Exist. If it does then just exit if there is not
111: -- then process as normal
112:
113: IF p_transaction_type in ('CSISOFUL','CSIRMAFL') THEN
114: