396: l_dummy varchar2(50);
397: l_seg_size number := 0;
398: l_uppercase_flag varchar2(1) ;
399: l_msg_name VARCHAR2(1000) := NULL;
400: l_start_auto_lot_num mtl_system_items_b.START_AUTO_LOT_NUMBER%TYPE;
401:
402: --2967569 : Required Segments check
403: l_segment_required NUMBER(10):=0;
404: l_required_flag varchar2(1) := 'Y';
1015: END IF;
1016:
1017: select count(*)
1018: into ext_flag
1019: from MTL_SYSTEM_ITEMS_B
1020: where inventory_item_id = l_item_id
1021: and organization_id = cr.organization_id
1022: and cr.transaction_type = 'CREATE';
1023: IF l_inv_debug_level IN(101, 102) THEN
2195: --
2196: begin
2197: select 'item_in_source_org'
2198: into l_dummy
2199: from mtl_system_items_b
2200: where inventory_item_id = l_item_id
2201: and organization_id = cr.source_organization_id;
2202:
2203: exception