eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSE_ASSET_MOVE_PKG dependencies on CSI_TRANSACTIONS

Line 149: FROM csi_transactions

145: INTO l_txn_type_id,
146: l_mtl_txn_id,
147: l_txn_date,
148: l_transacted_by
149: FROM csi_transactions
150: WHERE transaction_id = p_txn_id;
151:
152: SELECT source_txn_type_name
153: INTO l_txn_type

Line 258: FROM csi_transactions

254: l_src_transaction_id NUMBER ;
255:
256: CURSOR csi_txn_cur (c_transaction_id IN NUMBER) IS
257: SELECT object_version_number
258: FROM csi_transactions
259: WHERE transaction_id = c_transaction_id ;
260:
261: BEGIN
262:

Line 286: debug('Inside API csi_transactions_pvt.update_transactions');

282: OPEN csi_txn_cur (p_src_move_trans_tbl(1).transaction_id) ;
283: FETCH csi_txn_cur INTO l_txn_rec.object_version_number ;
284: CLOSE csi_txn_cur ;
285:
286: debug('Inside API csi_transactions_pvt.update_transactions');
287: debug(' transactio_id : '||l_txn_rec.transaction_id);
288: debug(' transaction_status : '||l_txn_rec.transaction_status_code);
289:
290: csi_transactions_pvt.update_transactions(

Line 290: csi_transactions_pvt.update_transactions(

286: debug('Inside API csi_transactions_pvt.update_transactions');
287: debug(' transactio_id : '||l_txn_rec.transaction_id);
288: debug(' transaction_status : '||l_txn_rec.transaction_status_code);
289:
290: csi_transactions_pvt.update_transactions(
291: p_api_version => 1.0,
292: p_init_msg_list => fnd_api.g_true,
293: p_commit => fnd_api.g_false,
294: p_validation_level => fnd_api.g_valid_level_full,

Line 345: debug('Inside API csi_transactions_pvt.update_transactions');

341: l_txn_rec.transaction_status_code := cse_datastructures_pub.G_COMPLETE ;
342:
343: l_txn_rec.object_version_number:= p_dest_move_trans_tbl(j).object_version_number ;
344:
345: debug('Inside API csi_transactions_pvt.update_transactions');
346: debug(' transaction_id : '||l_txn_rec.transaction_id);
347: debug(' transaction_status : '||l_txn_rec.transaction_status_code);
348:
349: csi_transactions_pvt.update_transactions(

Line 349: csi_transactions_pvt.update_transactions(

345: debug('Inside API csi_transactions_pvt.update_transactions');
346: debug(' transaction_id : '||l_txn_rec.transaction_id);
347: debug(' transaction_status : '||l_txn_rec.transaction_status_code);
348:
349: csi_transactions_pvt.update_transactions(
350: p_api_version => 1.0,
351: p_init_msg_list => fnd_api.g_true,
352: p_commit => fnd_api.g_false,
353: p_validation_level => fnd_api.g_valid_level_full,

Line 374: -- Creates a CSI Transactions record using CSI Private API.

370: x_error_msg := l_error_msg ;
371: END update_txn_status ;
372:
373: ------------------------------------------------------------------------------------------
374: -- Creates a CSI Transactions record using CSI Private API.
375: ------------------------------------------------------------------------------------------
376: PROCEDURE create_csi_txn(
377: px_txn_rec IN OUT NOCOPY CSI_DATASTRUCTURES_PUB.TRANSACTION_REC,
378: x_return_status OUT NOCOPY VARCHAR2,

Line 394: csi_transactions_pvt.create_transaction(

390:
391: px_txn_rec.object_version_number := 1;
392: px_txn_rec.transaction_date := sysdate;
393:
394: csi_transactions_pvt.create_transaction(
395: p_api_version => 1.0,
396: p_commit => fnd_api.g_false,
397: p_init_msg_list => fnd_api.g_true,
398: p_validation_level => fnd_api.g_valid_level_full,

Line 1164: csi_transactions ct,

1160: ct.object_version_number,
1161: cii.operational_status_code
1162: FROM csi_item_instances cii,
1163: csi_item_instances_h ciih,
1164: csi_transactions ct,
1165: mtl_material_transactions mmt,
1166: csi_txn_types ctt
1167: WHERE ct.transaction_id = p_transaction_id
1168: AND ct.inv_material_transaction_id = mmt.transaction_id(+)

Line 1358: csi_transactions_pvt.create_txn_error(

1354: FETCH csi_txn_error_cur INTO l_txn_error_id ;
1355: CLOSE csi_txn_error_cur ;
1356:
1357: IF l_txn_error_id IS NULL THEN
1358: csi_transactions_pvt.create_txn_error(
1359: l_api_version,
1360: l_init_msg_list,
1361: l_commit,
1362: l_validation_level,

Line 1398: csi_transactions_pvt.create_txn_error

1394: FETCH csi_txn_error_cur INTO l_txn_error_id ;
1395: CLOSE csi_txn_error_cur ;
1396:
1397: IF l_txn_error_id IS NULL THEN
1398: csi_transactions_pvt.create_txn_error
1399: (l_api_version, l_init_msg_list, l_commit, l_validation_level,
1400: l_trx_error_rec, l_return_status, l_msg_count,l_msg_data,
1401: l_txn_error_id);
1402: ELSE

Line 1538: FROM csi_transactions ct,

1534: ct.source_transaction_date,
1535: ct.inv_material_transaction_id,
1536: ct.object_version_number,
1537: ctt.source_transaction_type
1538: FROM csi_transactions ct,
1539: csi_txn_types ctt
1540: WHERE ct.transaction_id = p_transaction_id
1541: AND ctt.transaction_type_id = ct.transaction_type_id;
1542:

Line 1589: csi_transactions cit,

1585: cit.transaction_id,
1586: cit.transaction_type_id
1587: FROM csi_item_instances_h ciih,
1588: csi_item_instances cii,
1589: csi_transactions cit,
1590: csi_i_assets cia
1591: WHERE cit.transaction_id <= p_transaction_id
1592: AND cii.inventory_item_id = p_item_id
1593: AND cii.instance_id = ciih.instance_id

Line 2424: FROM csi_transactions

2420: l_txn_rec.transaction_status_code := cse_datastructures_pub.g_complete ;
2421:
2422: SELECT object_version_number
2423: INTO l_txn_rec.object_version_number
2424: FROM csi_transactions
2425: WHERE transaction_id = l_txn_rec.transaction_id;
2426:
2427: csi_transactions_pvt.update_transactions(
2428: p_api_version => 1.0,

Line 2427: csi_transactions_pvt.update_transactions(

2423: INTO l_txn_rec.object_version_number
2424: FROM csi_transactions
2425: WHERE transaction_id = l_txn_rec.transaction_id;
2426:
2427: csi_transactions_pvt.update_transactions(
2428: p_api_version => 1.0,
2429: p_init_msg_list => fnd_api.g_true,
2430: p_commit => fnd_api.g_false,
2431: p_validation_level => fnd_api.g_valid_level_full,

Line 2468: FROM csi_transactions

2464: l_txn_rec csi_datastructures_pub.transaction_rec ;
2465:
2466: CURSOR csi_txn_cur (c_transaction_id IN NUMBER) IS
2467: SELECT object_version_number
2468: FROM csi_transactions
2469: WHERE transaction_id = c_transaction_id ;
2470:
2471: BEGIN
2472:

Line 2955: csi_transactions_pvt.update_transactions(

2951: l_txn_rec.transaction_status_code := cse_datastructures_pub.G_COMPLETE ;
2952:
2953: l_txn_rec.object_version_number := l_src_txn_object_ver_num ;
2954:
2955: csi_transactions_pvt.update_transactions(
2956: p_api_version => l_api_version
2957: ,p_init_msg_list => l_init_msg_list
2958: ,p_commit => l_commit
2959: ,p_validation_level => l_validation_level

Line 2987: csi_transactions_pvt.update_transactions(

2983: l_txn_rec.transaction_status_code := cse_datastructures_pub.G_COMPLETE ;
2984:
2985: l_txn_rec.object_version_number:= dest_misc_move_trans_rec.object_version_number ;
2986:
2987: csi_transactions_pvt.update_transactions(
2988: p_api_version => l_api_version
2989: ,p_init_msg_list => l_init_msg_list
2990: ,p_commit => l_commit
2991: ,p_validation_level => l_validation_level

Line 3031: csi_transactions_pvt.create_txn_error

3027: CLOSE csi_txn_error_cur ;
3028:
3029: IF l_txn_error_id IS NULL
3030: THEN
3031: csi_transactions_pvt.create_txn_error
3032: (l_api_version, l_init_msg_list, l_commit, l_validation_level,
3033: l_trx_error_rec, l_return_status, l_msg_count,l_msg_data,
3034: l_txn_error_id);
3035: ELSE

Line 3072: csi_transactions_pvt.create_txn_error

3068: CLOSE csi_txn_error_cur ;
3069:
3070: IF l_txn_error_id IS NULL
3071: THEN
3072: csi_transactions_pvt.create_txn_error
3073: (l_api_version, l_init_msg_list, l_commit, l_validation_level,
3074: l_trx_error_rec, l_return_status, l_msg_count,l_msg_data,
3075: l_txn_error_id);
3076: ELSE

Line 3103: csi_transactions_pvt.update_transactions(

3099: l_txn_rec.transaction_status_code := cse_datastructures_pub.G_COMPLETE ;
3100:
3101: l_txn_rec.object_version_number := serial_move_trans_rec.object_version_number ;
3102:
3103: csi_transactions_pvt.update_transactions(
3104: p_api_version => l_api_version
3105: ,p_init_msg_list => l_init_msg_list
3106: ,p_commit => l_commit
3107: ,p_validation_level => l_validation_level

Line 3233: FROM csi_transactions ct,

3229: 'INVENTORY' location_type_code,
3230: ct.transaction_date,
3231: cii.inventory_revision,
3232: cii.instance_usage_code
3233: FROM csi_transactions ct,
3234: csi_item_instances_h ciih,
3235: csi_item_instances cii
3236: WHERE ct.transaction_id = p_transaction_id
3237: AND ciih.transaction_id = ct.transaction_id

Line 3243: FROM csi_transactions ct1,

3239: AND NVL(ciih.old_quantity,0) > NVL(ciih.new_quantity,0)
3240: AND cii.serial_number is NULL
3241: AND EXISTS (
3242: SELECT 'x'
3243: FROM csi_transactions ct1,
3244: mtl_material_transactions mmt
3245: WHERE ct1.transaction_type_id in (131, 142, 143, 144)
3246: AND ct1.transaction_status_code = 'PENDING'
3247: AND mmt.transaction_id = ct1.inv_material_transaction_id

Line 3311: FROM csi_transactions ct,

3307: 'INVENTORY' location_type_code,
3308: ct.transaction_date,
3309: cii.instance_usage_code,
3310: ct.transaction_quantity
3311: FROM csi_transactions ct,
3312: csi_item_instances_h ciih ,
3313: csi_item_instances cii
3314: WHERE ct.transaction_id = p_transaction_id
3315: AND ciih.transaction_id = ct.transaction_id

Line 3320: FROM csi_transactions ct1,

3316: AND cii.instance_id = ciih.instance_id
3317: AND cii.serial_number is NOT NULL
3318: AND EXISTS (
3319: SELECT 'x'
3320: FROM csi_transactions ct1,
3321: mtl_material_transactions mmt
3322: WHERE ct1.transaction_type_id in (131, 142, 143, 144)
3323: AND ct1.transaction_status_code = 'PENDING'
3324: AND mmt.transaction_id = ct1.inv_material_transaction_id

Line 3595: csi_transactions_pvt.create_txn_error

3591: CLOSE csi_txn_error_cur ;
3592:
3593: IF l_txn_error_id IS NULL
3594: THEN
3595: csi_transactions_pvt.create_txn_error
3596: (1.0, fnd_api.g_true, fnd_api.g_false, fnd_api.g_valid_level_full,
3597: l_trx_error_rec, l_return_status, l_msg_count,l_msg_data,
3598: l_txn_error_id);
3599: ELSE

Line 3633: csi_transactions_pvt.create_txn_error

3629: CLOSE csi_txn_error_cur ;
3630:
3631: IF l_txn_error_id IS NULL
3632: THEN
3633: csi_transactions_pvt.create_txn_error
3634: (1.0, fnd_api.g_true, fnd_api.g_false, fnd_api.g_valid_level_full,
3635: l_trx_error_rec, l_return_status, l_msg_count,l_msg_data,
3636: l_txn_error_id);
3637: ELSE

Line 3653: p_csi_txn_rec IN csi_transactions%rowtype,

3649: --------------------------------------------------------------------------------------
3650:
3651: PROCEDURE identify_txn_action(
3652: p_inventory_item_id IN number,
3653: p_csi_txn_rec IN csi_transactions%rowtype,
3654: x_txn_context OUT nocopy txn_context,
3655: x_action OUT nocopy varchar2)
3656: IS
3657:

Line 3999: p_csi_txn_rec IN csi_transactions%rowtype,

3995:
3996: END identify_txn_action;
3997:
3998: PROCEDURE get_instance_info(
3999: p_csi_txn_rec IN csi_transactions%rowtype,
4000: p_txn_context IN txn_context,
4001: px_action IN OUT nocopy varchar2,
4002: x_instance_tbl OUT nocopy instance_tbl,
4003: x_return_status OUT nocopy varchar2)

Line 4043: FROM csi_transactions ct,

4039:
4040:
4041: CURSOR pend_txn_cur(p_instance_id IN number, p_csi_txn_id IN number, p_inv_item_id in NUMBER) IS
4042: SELECT ct.transaction_id
4043: FROM csi_transactions ct,
4044: csi_item_instances cii,
4045: csi_item_instances_h ciih
4046: WHERE ciih.instance_id = p_instance_id
4047: AND ciih.transaction_id < p_csi_txn_id

Line 4200: csi_transactions_pvt.create_txn_error (

4196:
4197: EXCEPTION
4198: WHEN no_data_found THEN
4199:
4200: csi_transactions_pvt.create_txn_error (
4201: p_api_version => 1.0,
4202: p_init_msg_list => fnd_api.g_true,
4203: p_commit => fnd_api.g_false,
4204: p_validation_level => fnd_api.g_valid_level_full,

Line 4236: FROM csi_transactions ct

4232:
4233: -- transactions that can possibly change IB location or affect quantity on an item instance
4234: CURSOR csi_pending_txn_cur (c_inventory_item_id IN NUMBER) IS
4235: SELECT ct.*
4236: FROM csi_transactions ct
4237: WHERE ct.transaction_type_id IN (
4238: 1, -- IB_UI
4239: 3, -- MASS_EDIT
4240: 5, -- EXPIRE_STATUS