313: l_from_uom VARCHAR2 (3);
314: l_to_uom VARCHAR2 (3);
315: l_item_no VARCHAR2 (2000);
316: l_msg_data VARCHAR2 (2000);
317: l_mtl_txns_enabled_flag mtl_system_items_kfv.mtl_transactions_enabled_flag%TYPE;
318: l_concatenated_segments mtl_system_items_kfv.concatenated_segments%TYPE;
319: l_primary_uom_code mtl_system_items_kfv.primary_uom_code%TYPE;
320:
321: l_mtl_dtl_tbl gme_common_pvt.material_details_tab;
314: l_to_uom VARCHAR2 (3);
315: l_item_no VARCHAR2 (2000);
316: l_msg_data VARCHAR2 (2000);
317: l_mtl_txns_enabled_flag mtl_system_items_kfv.mtl_transactions_enabled_flag%TYPE;
318: l_concatenated_segments mtl_system_items_kfv.concatenated_segments%TYPE;
319: l_primary_uom_code mtl_system_items_kfv.primary_uom_code%TYPE;
320:
321: l_mtl_dtl_tbl gme_common_pvt.material_details_tab;
322: l_mtl_dtl_tbl_out gme_common_pvt.material_details_tab;
315: l_item_no VARCHAR2 (2000);
316: l_msg_data VARCHAR2 (2000);
317: l_mtl_txns_enabled_flag mtl_system_items_kfv.mtl_transactions_enabled_flag%TYPE;
318: l_concatenated_segments mtl_system_items_kfv.concatenated_segments%TYPE;
319: l_primary_uom_code mtl_system_items_kfv.primary_uom_code%TYPE;
320:
321: l_mtl_dtl_tbl gme_common_pvt.material_details_tab;
322: l_mtl_dtl_tbl_out gme_common_pvt.material_details_tab;
323: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;
343: l_diff_qty NUMBER;
344: CURSOR cur_get_item_info (v_org_id NUMBER, v_inventory_item_id NUMBER)
345: IS
346: SELECT mtl_transactions_enabled_flag, concatenated_segments, primary_uom_code
347: FROM mtl_system_items_kfv
348: WHERE inventory_item_id = v_inventory_item_id
349: AND organization_id = v_org_id;
350:
351: create_mo_err EXCEPTION;
1021:
1022: CURSOR cur_item_uoms (v_org_id NUMBER, v_inventory_item_id NUMBER)
1023: IS
1024: SELECT primary_uom_code, secondary_uom_code, concatenated_segments
1025: FROM mtl_system_items_kfv
1026: WHERE organization_id = v_org_id
1027: AND inventory_item_id = v_inventory_item_id;
1028:
1029: get_mo_line_err EXCEPTION;