1783: , p_item_to IN VARCHAR2
1784: , x_item_cursor IN OUT NOCOPY VARCHAR2
1785: )
1786: IS
1787: l_flexfield_rec FND_FLEX_KEY_API.flexfield_type;
1788: l_structure_rec FND_FLEX_KEY_API.structure_type;
1789: l_segment_rec FND_FLEX_KEY_API.segment_type;
1790: l_segment_tbl FND_FLEX_KEY_API.segment_list;
1791: l_segment_number NUMBER;
1784: , x_item_cursor IN OUT NOCOPY VARCHAR2
1785: )
1786: IS
1787: l_flexfield_rec FND_FLEX_KEY_API.flexfield_type;
1788: l_structure_rec FND_FLEX_KEY_API.structure_type;
1789: l_segment_rec FND_FLEX_KEY_API.segment_type;
1790: l_segment_tbl FND_FLEX_KEY_API.segment_list;
1791: l_segment_number NUMBER;
1792: l_mstk_segs VARCHAR2(850);
1785: )
1786: IS
1787: l_flexfield_rec FND_FLEX_KEY_API.flexfield_type;
1788: l_structure_rec FND_FLEX_KEY_API.structure_type;
1789: l_segment_rec FND_FLEX_KEY_API.segment_type;
1790: l_segment_tbl FND_FLEX_KEY_API.segment_list;
1791: l_segment_number NUMBER;
1792: l_mstk_segs VARCHAR2(850);
1793: l_mcat_segs VARCHAR2(850);
1786: IS
1787: l_flexfield_rec FND_FLEX_KEY_API.flexfield_type;
1788: l_structure_rec FND_FLEX_KEY_API.structure_type;
1789: l_segment_rec FND_FLEX_KEY_API.segment_type;
1790: l_segment_tbl FND_FLEX_KEY_API.segment_list;
1791: l_segment_number NUMBER;
1792: l_mstk_segs VARCHAR2(850);
1793: l_mcat_segs VARCHAR2(850);
1794: l_mcat_f VARCHAR2(2000);
1801: BEGIN
1802:
1803: l_module := g_log_head||l_api_name||'.'||'000'||'.';
1804:
1805: FND_FLEX_KEY_API.set_session_mode('customer_data');
1806:
1807: -- retrieve system item concatenated flexfield
1808: l_mstk_segs := '';
1809: l_flexfield_rec := FND_FLEX_KEY_API.find_flexfield('INV', 'MSTK');
1805: FND_FLEX_KEY_API.set_session_mode('customer_data');
1806:
1807: -- retrieve system item concatenated flexfield
1808: l_mstk_segs := '';
1809: l_flexfield_rec := FND_FLEX_KEY_API.find_flexfield('INV', 'MSTK');
1810: l_structure_rec := FND_FLEX_KEY_API.find_structure(l_flexfield_rec, 101);
1811: FND_FLEX_KEY_API.get_segments
1812: ( flexfield => l_flexfield_rec
1813: , structure => l_structure_rec
1806:
1807: -- retrieve system item concatenated flexfield
1808: l_mstk_segs := '';
1809: l_flexfield_rec := FND_FLEX_KEY_API.find_flexfield('INV', 'MSTK');
1810: l_structure_rec := FND_FLEX_KEY_API.find_structure(l_flexfield_rec, 101);
1811: FND_FLEX_KEY_API.get_segments
1812: ( flexfield => l_flexfield_rec
1813: , structure => l_structure_rec
1814: , nsegments => l_segment_number
1807: -- retrieve system item concatenated flexfield
1808: l_mstk_segs := '';
1809: l_flexfield_rec := FND_FLEX_KEY_API.find_flexfield('INV', 'MSTK');
1810: l_structure_rec := FND_FLEX_KEY_API.find_structure(l_flexfield_rec, 101);
1811: FND_FLEX_KEY_API.get_segments
1812: ( flexfield => l_flexfield_rec
1813: , structure => l_structure_rec
1814: , nsegments => l_segment_number
1815: , segments => l_segment_tbl
1814: , nsegments => l_segment_number
1815: , segments => l_segment_tbl
1816: );
1817: FOR l_idx IN 1..l_segment_number LOOP
1818: l_segment_rec := FND_FLEX_KEY_API.find_segment
1819: ( l_flexfield_rec
1820: , l_structure_rec
1821: , l_segment_tbl(l_idx)
1822: );
1833:
1834:
1835: -- retrieve item category concatenated flexfield
1836: l_mcat_segs := '';
1837: l_flexfield_rec := FND_FLEX_KEY_API.find_flexfield('INV', 'MCAT');
1838: l_structure_rec := FND_FLEX_KEY_API.find_structure
1839: ( l_flexfield_rec
1840: , p_cat_structure_id
1841: );
1834:
1835: -- retrieve item category concatenated flexfield
1836: l_mcat_segs := '';
1837: l_flexfield_rec := FND_FLEX_KEY_API.find_flexfield('INV', 'MCAT');
1838: l_structure_rec := FND_FLEX_KEY_API.find_structure
1839: ( l_flexfield_rec
1840: , p_cat_structure_id
1841: );
1842: FND_FLEX_KEY_API.get_segments
1838: l_structure_rec := FND_FLEX_KEY_API.find_structure
1839: ( l_flexfield_rec
1840: , p_cat_structure_id
1841: );
1842: FND_FLEX_KEY_API.get_segments
1843: ( flexfield => l_flexfield_rec
1844: , structure => l_structure_rec
1845: , nsegments => l_segment_number
1846: , segments => l_segment_tbl
1845: , nsegments => l_segment_number
1846: , segments => l_segment_tbl
1847: );
1848: FOR l_idx IN 1..l_segment_number LOOP
1849: l_segment_rec := FND_FLEX_KEY_API.find_segment
1850: ( l_flexfield_rec
1851: , l_structure_rec
1852: , l_segment_tbl(l_idx)
1853: );