APPS.CSE_GL_INTERFACE_PKG dependencies on CSI_TRANSACTIONS

Line 58: ,csi_transactions ct

54: SELECT 'Y'
55: FROM mtl_unit_transactions mut
56: ,csi_item_instances cii
57: ,csi_i_assets cia
58: ,csi_transactions ct
59: WHERE mut.transaction_id = p_mtl_txn_id
60: AND cii.inventory_item_id = mut.inventory_item_id
61: AND cii.instance_id = cia.instance_id
62: AND ct.transaction_id = p_csi_txn_id

Line 239: FROM csi_transactions ct

235: SELECT ct.transaction_id,
236: ct.transaction_date,
237: ct.inv_material_transaction_id ,
238: ct.gl_interface_status_code
239: FROM csi_transactions ct
240: WHERE ct.gl_interface_status_code = 1 --'PENDING'
241: AND ct.transaction_status_code = 'COMPLETE' ; --only those txn, which are already interfaced to FA
242:
243: -- nvl on gl_interf_status_cd not reqd as t wld have a value when the below cur is opened

Line 249: FROM csi_transactions ct

245: IS
246: SELECT ct.inv_material_transaction_id,
247: ct.transaction_type_id,
248: ct.transaction_id
249: FROM csi_transactions ct
250: WHERE ct.gl_interface_status_code = 1 ---'PENDING'
251: AND ct.transaction_status_code = 'COMPLETE' ;
252:
253: -- Cursor will be used to get redeployment status of nonexpired assets

Line 434: UPDATE csi_transactions

430: || ' GL_INTERF_CD: ' || to_char(l_gl_interface_code)
431: ) ;
432: END IF;
433:
434: UPDATE csi_transactions
435: SET gl_interface_status_code = l_gl_interface_code
436: WHERE transaction_id = csi_gl_interface_code_rec.transaction_id;
437:
438: END LOOP; --csi_gl_interface_code_rec

Line 603: csi_transactions ct ,

599: /*
600: SELECT sum(cia.asset_quantity)
601: INTO l_no_of_fa_items
602: FROM csi_item_instances cii,
603: csi_transactions ct ,
604: csi_item_instances_h ciih ,
605: csi_i_assets cia
606: WHERE cii.instance_id = ciih.instance_id
607: AND ct.transaction_id = ciih.transaction_id

Line 943: UPDATE csi_transactions

939: -- THEN
940: debug('Before Upd Csi_Txn_Status To 2 for Csi_Mmt_Txn_Id: '
941: || to_char(csi_pending_txn_rec.inv_material_transaction_id) ) ;
942: -- END IF;
943: UPDATE csi_transactions
944: SET gl_interface_status_code = 2 ---'POSTED'
945: WHERE inv_material_transaction_id = csi_pending_txn_rec.inv_material_transaction_id;
946: END IF;
947: ELSE

Line 955: UPDATE csi_transactions

951: debug('Before Upd Csi_Txn_Status To 3 for Csi_Mmt_Txn_Id: '
952: || to_char(csi_pending_txn_rec.inv_material_transaction_id) ) ;
953: -- END IF;
954:
955: UPDATE csi_transactions
956: SET gl_interface_status_code = 3 ---'NONE'
957: WHERE inv_material_transaction_id = csi_pending_txn_rec.inv_material_transaction_id;
958: --
959: END IF ; -- reversal_required or regular item with CIA