APPS.CSE_ASSET_CREATION_PKG dependencies on CSI_TRANSACTIONS

Line 220: csi_transactions_pvt.create_txn_error (

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

Line 265: FROM csi_transactions

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

Line 268: csi_transactions_pvt.update_transactions(

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

Line 331: FROM csi_transactions ct,

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

Line 363: FROM csi_transactions ct,

359: RETURN boolean
360: IS
361: CURSOR txn_cur IS
362: SELECT ct.transaction_id
363: FROM csi_transactions ct,
364: csi_item_instances_h ciih
365: WHERE ciih.instance_id = p_instance_id
366: AND ct.transaction_id = ciih.transaction_id
367: AND ct.transaction_date < (SELECT ct1.transaction_date

Line 368: FROM csi_transactions ct1

364: csi_item_instances_h ciih
365: WHERE ciih.instance_id = p_instance_id
366: AND ct.transaction_id = ciih.transaction_id
367: AND ct.transaction_date < (SELECT ct1.transaction_date
368: FROM csi_transactions ct1
369: WHERE ct1.transaction_id = p_csi_txn_id) -- Modified for Bug 13719864
370: AND ct.transaction_status_code = 'PENDING';
371: BEGIN
372: FOR txn_rec IN txn_cur

Line 2166: FROM csi_transactions ct

2162: ct.source_transaction_date, -- Bug 14516891
2163: ct.inv_material_transaction_id,
2164: ct.source_dist_ref_id2,
2165: ct.source_dist_ref_id1
2166: FROM csi_transactions ct
2167: WHERE ct.transaction_type_id IN (117, 129, 128, 105, 112, 118, 119, 133, 132, 73,51) --Add WIP Assembly Completion for bug 7489949 --Added for ER#16265912
2168: AND ct.transaction_status_code = l_pending_status
2169: AND ct.inv_material_transaction_id is not null
2170: AND exists (

Line 2313: FROM csi_transactions

2309: IF csi_txn_rec.transaction_type_id = 51 THEN
2310:
2311: SELECT source_line_ref_id
2312: INTO l_line_id
2313: FROM csi_transactions
2314: WHERE transaction_id = csi_txn_rec.transaction_id;
2315:
2316: BEGIN
2317: SELECT 'Y'