DBA Data[Home] [Help]

APPS.PO_RETROACTIVE_PRICING_PVT dependencies on FND_FLEX_KEY_API

Line 1787: l_flexfield_rec FND_FLEX_KEY_API.flexfield_type;

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;

Line 1788: l_structure_rec FND_FLEX_KEY_API.structure_type;

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);

Line 1789: l_segment_rec FND_FLEX_KEY_API.segment_type;

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);

Line 1790: l_segment_tbl FND_FLEX_KEY_API.segment_list;

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);

Line 1805: FND_FLEX_KEY_API.set_session_mode('customer_data');

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');

Line 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

Line 1810: l_structure_rec := FND_FLEX_KEY_API.find_structure(l_flexfield_rec, 101);

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

Line 1811: FND_FLEX_KEY_API.get_segments

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

Line 1818: l_segment_rec := FND_FLEX_KEY_API.find_segment

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: );

Line 1837: l_flexfield_rec := FND_FLEX_KEY_API.find_flexfield('INV', 'MCAT');

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: );

Line 1838: l_structure_rec := FND_FLEX_KEY_API.find_structure

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

Line 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

Line 1849: l_segment_rec := FND_FLEX_KEY_API.find_segment

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: );