701: FUNCTION Get_Item_Number(P_Inventory_Item_Id MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID%TYPE
702: ,P_Organization_Id MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID%TYPE)
703: RETURN VARCHAR2 IS
704: l_delimiter VARCHAR2(10);
705: l_segs FND_FLEX_EXT.SegmentArray;
706: l_n_segs NUMBER;
707: l_item_exist BOOLEAN;
708: l_concat_segs VARCHAR2(1000);
709:
709:
710:
711: BEGIN
712: -- Get delimiter
713: l_delimiter := fnd_flex_ext.get_delimiter(application_short_name => 'INV'
714: ,key_flex_code => 'MSTK'
715: ,structure_number => 101);
716: -- Get segments
717: l_item_exist := fnd_flex_ext.get_segments(application_short_name => 'INV'
713: l_delimiter := fnd_flex_ext.get_delimiter(application_short_name => 'INV'
714: ,key_flex_code => 'MSTK'
715: ,structure_number => 101);
716: -- Get segments
717: l_item_exist := fnd_flex_ext.get_segments(application_short_name => 'INV'
718: ,key_flex_code => 'MSTK'
719: ,structure_number => 101
720: ,combination_id => P_Inventory_Item_Id
721: ,n_segments => l_n_segs
722: ,segments => l_segs
723: ,data_set => P_Organization_Id);
724: -- Get concatenated segments
725: IF l_item_exist THEN
726: l_concat_segs := fnd_flex_ext.concatenate_segments(n_segments => l_n_segs
727: ,segments => l_segs
728: ,delimiter => l_delimiter);
729: END IF;
730: