APPS.CSE_COST_COLLECTOR dependencies on CSI_TRANSACTIONS

Line 75: csi_transactions ct

71: ct.transaction_id transaction_id,
72: 'TO_PROJECT' issue_type
73: FROM csi_item_instances cii,
74: csi_item_instances_h ciih,
75: csi_transactions ct
76: WHERE cii.instance_id = ciih.instance_id
77: AND ciih.transaction_id = ct.transaction_id
78: AND ct.inv_material_transaction_id = c_txn_id
79: AND ct.transaction_type_id IN (

Line 90: csi_transactions ct

86: ct.transaction_id transaction_id,
87: 'FROM_PROJECT' issue_type
88: FROM csi_item_instances cii,
89: csi_item_instances_h ciih,
90: csi_transactions ct
91: WHERE cii.instance_id = ciih.instance_id
92: AND ciih.transaction_id = ct.transaction_id
93: AND ct.inv_material_transaction_id = c_txn_id
94: AND ct.transaction_type_id IN(

Line 389: FROM csi_transactions ct

385: ------------------------------------------------------------------------------------
386: PROCEDURE reverse_expenditures IS
387: CURSOR csi_txn_cur IS
388: SELECT ct.transaction_id
389: FROM csi_transactions ct
390: WHERE ct.transaction_status_code = 'PENDING' ;
391:
392: CURSOR csi_pending_txn_cur (c_transaction_id IN NUMBER) IS
393: SELECT cii.serial_number,

Line 402: csi_transactions ct

398: ct.object_version_number,
399: ct.transaction_date
400: FROM csi_item_instances cii,
401: csi_item_instances_h ciih,
402: csi_transactions ct
403: WHERE ct.transaction_id = c_transaction_id
404: AND ct.transaction_id = ciih.transaction_id
405: AND cii.instance_id = ciih.instance_id
406: AND cii.serial_number IS NOT NULL

Line 642: csi_transactions_pvt.update_transactions(

638: l_txn_rec.transaction_id := csi_txn_rec.transaction_id ;
639: l_txn_rec.transaction_status_code := CSE_DATASTRUCTURES_PUB.G_COMPLETE ;
640: l_txn_rec.object_version_number := l_txn_obj_ver ;
641:
642: csi_transactions_pvt.update_transactions(
643: p_api_version => l_api_version
644: ,p_init_msg_list => l_init_msg_list
645: ,p_commit => l_commit
646: ,p_validation_level => l_validation_level