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 1179: csi_transactions ct,

1175: ct.object_version_number,
1176: cii.operational_status_code
1177: FROM csi_item_instances cii,
1178: csi_item_instances_h ciih,
1179: csi_transactions ct,
1180: mtl_material_transactions mmt,
1181: csi_txn_types ctt
1182: WHERE ct.transaction_id = p_transaction_id
1183: AND ct.inv_material_transaction_id = mmt.transaction_id(+)

Line 1373: csi_transactions_pvt.create_txn_error(

1369: FETCH csi_txn_error_cur INTO l_txn_error_id ;
1370: CLOSE csi_txn_error_cur ;
1371:
1372: IF l_txn_error_id IS NULL THEN
1373: csi_transactions_pvt.create_txn_error(
1374: l_api_version,
1375: l_init_msg_list,
1376: l_commit,
1377: l_validation_level,

Line 1413: csi_transactions_pvt.create_txn_error

1409: FETCH csi_txn_error_cur INTO l_txn_error_id ;
1410: CLOSE csi_txn_error_cur ;
1411:
1412: IF l_txn_error_id IS NULL THEN
1413: csi_transactions_pvt.create_txn_error
1414: (l_api_version, l_init_msg_list, l_commit, l_validation_level,
1415: l_trx_error_rec, l_return_status, l_msg_count,l_msg_data,
1416: l_txn_error_id);
1417: ELSE

Line 1486: csi_transactions ct

1482: SELECT transaction_id
1483: INTO l_transaction_id
1484: FROM (SELECT ciih.transaction_id
1485: FROM csi_item_instances_h ciih,
1486: csi_transactions ct
1487: WHERE ciih.transaction_id = ct.transaction_id
1488: AND ciih.instance_id = p_instance_id
1489: AND ct.transaction_date < (SELECT transaction_date
1490: FROM csi_transactions

Line 1490: FROM csi_transactions

1486: csi_transactions ct
1487: WHERE ciih.transaction_id = ct.transaction_id
1488: AND ciih.instance_id = p_instance_id
1489: AND ct.transaction_date < (SELECT transaction_date
1490: FROM csi_transactions
1491: WHERE transaction_id = l_transaction_id)
1492: ORDER BY ct.transaction_date DESC)
1493: WHERE ROWNUM = 1;
1494:

Line 1577: FROM csi_transactions ct,

1573: ct.source_transaction_date,
1574: ct.inv_material_transaction_id,
1575: ct.object_version_number,
1576: ctt.source_transaction_type
1577: FROM csi_transactions ct,
1578: csi_txn_types ctt
1579: WHERE ct.transaction_id = p_transaction_id
1580: AND ctt.transaction_type_id = ct.transaction_type_id;
1581:

Line 1628: csi_transactions cit,

1624: cit.transaction_id,
1625: cit.transaction_type_id
1626: FROM csi_item_instances_h ciih,
1627: csi_item_instances cii,
1628: csi_transactions cit,
1629: csi_i_assets cia
1630: WHERE cit.transaction_id <= p_transaction_id
1631: AND cii.inventory_item_id = p_item_id
1632: AND cii.instance_id = ciih.instance_id

Line 2503: FROM csi_transactions

2499: l_txn_rec.transaction_status_code := cse_datastructures_pub.g_complete ;
2500:
2501: SELECT object_version_number
2502: INTO l_txn_rec.object_version_number
2503: FROM csi_transactions
2504: WHERE transaction_id = l_txn_rec.transaction_id;
2505:
2506: csi_transactions_pvt.update_transactions(
2507: p_api_version => 1.0,

Line 2506: csi_transactions_pvt.update_transactions(

2502: INTO l_txn_rec.object_version_number
2503: FROM csi_transactions
2504: WHERE transaction_id = l_txn_rec.transaction_id;
2505:
2506: csi_transactions_pvt.update_transactions(
2507: p_api_version => 1.0,
2508: p_init_msg_list => fnd_api.g_true,
2509: p_commit => fnd_api.g_false,
2510: p_validation_level => fnd_api.g_valid_level_full,

Line 2547: FROM csi_transactions

2543: l_txn_rec csi_datastructures_pub.transaction_rec ;
2544:
2545: CURSOR csi_txn_cur (c_transaction_id IN NUMBER) IS
2546: SELECT object_version_number
2547: FROM csi_transactions
2548: WHERE transaction_id = c_transaction_id ;
2549:
2550: BEGIN
2551:

Line 3034: csi_transactions_pvt.update_transactions(

3030: l_txn_rec.transaction_status_code := cse_datastructures_pub.G_COMPLETE ;
3031:
3032: l_txn_rec.object_version_number := l_src_txn_object_ver_num ;
3033:
3034: csi_transactions_pvt.update_transactions(
3035: p_api_version => l_api_version
3036: ,p_init_msg_list => l_init_msg_list
3037: ,p_commit => l_commit
3038: ,p_validation_level => l_validation_level

Line 3066: csi_transactions_pvt.update_transactions(

3062: l_txn_rec.transaction_status_code := cse_datastructures_pub.G_COMPLETE ;
3063:
3064: l_txn_rec.object_version_number:= dest_misc_move_trans_rec.object_version_number ;
3065:
3066: csi_transactions_pvt.update_transactions(
3067: p_api_version => l_api_version
3068: ,p_init_msg_list => l_init_msg_list
3069: ,p_commit => l_commit
3070: ,p_validation_level => l_validation_level

Line 3110: csi_transactions_pvt.create_txn_error

3106: CLOSE csi_txn_error_cur ;
3107:
3108: IF l_txn_error_id IS NULL
3109: THEN
3110: csi_transactions_pvt.create_txn_error
3111: (l_api_version, l_init_msg_list, l_commit, l_validation_level,
3112: l_trx_error_rec, l_return_status, l_msg_count,l_msg_data,
3113: l_txn_error_id);
3114: ELSE

Line 3151: csi_transactions_pvt.create_txn_error

3147: CLOSE csi_txn_error_cur ;
3148:
3149: IF l_txn_error_id IS NULL
3150: THEN
3151: csi_transactions_pvt.create_txn_error
3152: (l_api_version, l_init_msg_list, l_commit, l_validation_level,
3153: l_trx_error_rec, l_return_status, l_msg_count,l_msg_data,
3154: l_txn_error_id);
3155: ELSE

Line 3182: csi_transactions_pvt.update_transactions(

3178: l_txn_rec.transaction_status_code := cse_datastructures_pub.G_COMPLETE ;
3179:
3180: l_txn_rec.object_version_number := serial_move_trans_rec.object_version_number ;
3181:
3182: csi_transactions_pvt.update_transactions(
3183: p_api_version => l_api_version
3184: ,p_init_msg_list => l_init_msg_list
3185: ,p_commit => l_commit
3186: ,p_validation_level => l_validation_level

Line 3312: FROM csi_transactions ct,

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

Line 3322: FROM csi_transactions ct1,

3318: AND NVL(ciih.old_quantity,0) > NVL(ciih.new_quantity,0)
3319: AND cii.serial_number is NULL
3320: AND EXISTS (
3321: SELECT 'x'
3322: FROM csi_transactions ct1,
3323: mtl_material_transactions mmt
3324: WHERE ct1.transaction_type_id in (131, 142, 143, 144)
3325: AND ct1.transaction_status_code = 'PENDING'
3326: AND mmt.transaction_id = ct1.inv_material_transaction_id

Line 3390: FROM csi_transactions ct,

3386: 'INVENTORY' location_type_code,
3387: ct.transaction_date,
3388: cii.instance_usage_code,
3389: ct.transaction_quantity
3390: FROM csi_transactions ct,
3391: csi_item_instances_h ciih ,
3392: csi_item_instances cii
3393: WHERE ct.transaction_id = p_transaction_id
3394: AND ciih.transaction_id = ct.transaction_id

Line 3399: FROM csi_transactions ct1,

3395: AND cii.instance_id = ciih.instance_id
3396: AND cii.serial_number is NOT NULL
3397: AND EXISTS (
3398: SELECT 'x'
3399: FROM csi_transactions ct1,
3400: mtl_material_transactions mmt
3401: WHERE ct1.transaction_type_id in (131, 142, 143, 144)
3402: AND ct1.transaction_status_code = 'PENDING'
3403: AND mmt.transaction_id = ct1.inv_material_transaction_id

Line 3674: csi_transactions_pvt.create_txn_error

3670: CLOSE csi_txn_error_cur ;
3671:
3672: IF l_txn_error_id IS NULL
3673: THEN
3674: csi_transactions_pvt.create_txn_error
3675: (1.0, fnd_api.g_true, fnd_api.g_false, fnd_api.g_valid_level_full,
3676: l_trx_error_rec, l_return_status, l_msg_count,l_msg_data,
3677: l_txn_error_id);
3678: ELSE

Line 3712: csi_transactions_pvt.create_txn_error

3708: CLOSE csi_txn_error_cur ;
3709:
3710: IF l_txn_error_id IS NULL
3711: THEN
3712: csi_transactions_pvt.create_txn_error
3713: (1.0, fnd_api.g_true, fnd_api.g_false, fnd_api.g_valid_level_full,
3714: l_trx_error_rec, l_return_status, l_msg_count,l_msg_data,
3715: l_txn_error_id);
3716: ELSE

Line 3732: p_csi_txn_rec IN csi_transactions%rowtype,

3728: --------------------------------------------------------------------------------------
3729:
3730: PROCEDURE identify_txn_action(
3731: p_inventory_item_id IN number,
3732: p_csi_txn_rec IN csi_transactions%rowtype,
3733: x_txn_context OUT nocopy txn_context,
3734: x_action OUT nocopy varchar2)
3735: IS
3736:

Line 4024: FROM csi_transactions

4020:
4021: --Added for ER#16265912
4022: SELECT source_line_ref_id
4023: INTO l_line_id
4024: FROM csi_transactions
4025: WHERE transaction_id = p_csi_txn_rec.transaction_id;
4026:
4027: BEGIN
4028: SELECT 'Y'

Line 4223: p_csi_txn_rec IN csi_transactions%rowtype,

4219:
4220: END identify_txn_action;
4221:
4222: PROCEDURE get_instance_info(
4223: p_csi_txn_rec IN csi_transactions%rowtype,
4224: p_txn_context IN txn_context,
4225: px_action IN OUT nocopy varchar2,
4226: x_instance_tbl OUT nocopy instance_tbl,
4227: x_return_status OUT nocopy varchar2)

Line 4267: FROM csi_transactions ct,

4263:
4264:
4265: CURSOR pend_txn_cur(p_instance_id IN number, p_csi_txn_id IN number, p_inv_item_id in NUMBER) IS
4266: SELECT ct.transaction_id
4267: FROM csi_transactions ct,
4268: csi_item_instances cii,
4269: csi_item_instances_h ciih
4270: WHERE ciih.instance_id = p_instance_id
4271: AND ciih.transaction_id < p_csi_txn_id

Line 4424: csi_transactions_pvt.create_txn_error (

4420:
4421: EXCEPTION
4422: WHEN no_data_found THEN
4423:
4424: csi_transactions_pvt.create_txn_error (
4425: p_api_version => 1.0,
4426: p_init_msg_list => fnd_api.g_true,
4427: p_commit => fnd_api.g_false,
4428: p_validation_level => fnd_api.g_valid_level_full,

Line 4460: FROM csi_transactions ct

4456:
4457: -- transactions that can possibly change IB location or affect quantity on an item instance
4458: CURSOR csi_pending_txn_cur (c_inventory_item_id IN NUMBER) IS
4459: SELECT ct.*
4460: FROM csi_transactions ct
4461: WHERE ct.transaction_type_id IN (
4462: 1, -- IB_UI
4463: 3, -- MASS_EDIT
4464: 5, -- EXPIRE_STATUS