APPS.CSE_ASSET_CREATION_PKG dependencies on CSI_TRANSACTIONS

Line 218: csi_transactions_pvt.create_txn_error (

214:
215: EXCEPTION
216: WHEN no_data_found THEN
217:
218: csi_transactions_pvt.create_txn_error (
219: p_api_version => 1.0,
220: p_init_msg_list => fnd_api.g_true,
221: p_commit => fnd_api.g_false,
222: p_validation_level => fnd_api.g_valid_level_full,

Line 263: FROM csi_transactions

259: l_txn_rec.transaction_status_code := cse_datastructures_pub.g_complete ;
260:
261: SELECT object_version_number
262: INTO l_txn_rec.object_version_number
263: FROM csi_transactions
264: WHERE transaction_id = l_txn_rec.transaction_id;
265:
266: csi_transactions_pvt.update_transactions(
267: p_api_version => 1.0,

Line 266: csi_transactions_pvt.update_transactions(

262: INTO l_txn_rec.object_version_number
263: FROM csi_transactions
264: WHERE transaction_id = l_txn_rec.transaction_id;
265:
266: csi_transactions_pvt.update_transactions(
267: p_api_version => 1.0,
268: p_init_msg_list => fnd_api.g_true,
269: p_commit => fnd_api.g_false,
270: p_validation_level => fnd_api.g_valid_level_full,

Line 329: FROM csi_transactions ct,

325:
326:
327: CURSOR deploy_cur IS
328: SELECT 'Y'
329: FROM csi_transactions ct,
330: csi_item_instances_h ciih
331: WHERE ciih.instance_id = p_instance_id
332: AND ct.transaction_id = ciih.transaction_id
333: AND ct.transaction_date < p_transaction_date

Line 361: FROM csi_transactions ct,

357: RETURN boolean
358: IS
359: CURSOR txn_cur IS
360: SELECT ct.transaction_id
361: FROM csi_transactions ct,
362: csi_item_instances_h ciih
363: WHERE ciih.instance_id = p_instance_id
364: AND ct.transaction_id = ciih.transaction_id
365: AND ct.transaction_id < p_csi_txn_id

Line 2021: FROM csi_transactions ct

2017: ct.transaction_date,
2018: ct.inv_material_transaction_id,
2019: ct.source_dist_ref_id2,
2020: ct.source_dist_ref_id1
2021: FROM csi_transactions ct
2022: WHERE ct.transaction_type_id IN (117, 129, 128, 105, 112, 118, 119, 133, 132, 73) --Add WIP Assembly Completion for bug 7489949
2023: AND ct.transaction_status_code = l_pending_status
2024: AND ct.inv_material_transaction_id is not null
2025: AND exists (