2804: l_trx_error_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC;
2805:
2806: cursor C_QUANTITY is
2807: select transaction_quantity
2808: from mtl_material_transactions
2809: where transaction_id = p_transaction_id;
2810:
2811: BEGIN
2812:
2892: l_trx_error_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC;
2893:
2894: cursor C_QUANTITY is
2895: select transaction_quantity
2896: from mtl_material_transactions
2897: where transaction_id = p_transaction_id;
2898:
2899: BEGIN
2900: x_return_status := l_fnd_success;
3024: mtl_unit_transactions mut,
3025: mtl_secondary_inventories msi,
3026: hr_all_organization_units haou,
3027: rcv_transactions rt,
3028: mtl_material_transactions mmt
3029: WHERE
3030: mmt.transaction_id = p_transaction_id AND
3031: mmt.inventory_item_id = msib.inventory_item_id AND
3032: mmt.organization_id = msib.organization_id AND
3090: mtl_transaction_lot_numbers mtln,
3091: mtl_secondary_inventories msi,
3092: hr_all_organization_units haou,
3093: rcv_transactions rt,
3094: mtl_material_transactions mmt
3095: WHERE
3096: mmt.transaction_id = p_transaction_id AND
3097: mmt.inventory_item_id = msib.inventory_item_id AND
3098: mmt.organization_id = msib.organization_id AND
3738: l_inv_name VARCHAR2(30);
3739:
3740: CURSOR x is
3741: SELECT transaction_type_id
3742: FROM mtl_material_transactions
3743: WHERE transaction_id = p_transaction_id;
3744:
3745: BEGIN
3746:
4109: transaction_action_id,
4110: transaction_type_id,
4111: transaction_source_type_id,
4112: ship_to_location_id
4113: FROM mtl_material_transactions
4114: WHERE transaction_id = p_transaction_id;
4115:
4116: r_mtl_data c_mtl_data%rowtype;
4117: