eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSP_PLANNER_NOTIFICATIONS dependencies on FND_FLEX_KEY_API

Line 1450: l_flexfield_rec FND_FLEX_KEY_API.flexfield_type;

1446: , p_lot_ctl IN NUMBER
1447: , x_range_sql OUT NOCOPY VARCHAR2
1448: )
1449: IS
1450: l_flexfield_rec FND_FLEX_KEY_API.flexfield_type;
1451: l_structure_rec FND_FLEX_KEY_API.structure_type;
1452: l_segment_rec FND_FLEX_KEY_API.segment_type;
1453: l_segment_tbl FND_FLEX_KEY_API.segment_list;
1454: l_segment_number NUMBER;

Line 1451: l_structure_rec FND_FLEX_KEY_API.structure_type;

1447: , x_range_sql OUT NOCOPY VARCHAR2
1448: )
1449: IS
1450: l_flexfield_rec FND_FLEX_KEY_API.flexfield_type;
1451: l_structure_rec FND_FLEX_KEY_API.structure_type;
1452: l_segment_rec FND_FLEX_KEY_API.segment_type;
1453: l_segment_tbl FND_FLEX_KEY_API.segment_list;
1454: l_segment_number NUMBER;
1455: l_mstk_segs VARCHAR2(850);

Line 1452: l_segment_rec FND_FLEX_KEY_API.segment_type;

1448: )
1449: IS
1450: l_flexfield_rec FND_FLEX_KEY_API.flexfield_type;
1451: l_structure_rec FND_FLEX_KEY_API.structure_type;
1452: l_segment_rec FND_FLEX_KEY_API.segment_type;
1453: l_segment_tbl FND_FLEX_KEY_API.segment_list;
1454: l_segment_number NUMBER;
1455: l_mstk_segs VARCHAR2(850);
1456: l_mcat_segs VARCHAR2(850);

Line 1453: l_segment_tbl FND_FLEX_KEY_API.segment_list;

1449: IS
1450: l_flexfield_rec FND_FLEX_KEY_API.flexfield_type;
1451: l_structure_rec FND_FLEX_KEY_API.structure_type;
1452: l_segment_rec FND_FLEX_KEY_API.segment_type;
1453: l_segment_tbl FND_FLEX_KEY_API.segment_list;
1454: l_segment_number NUMBER;
1455: l_mstk_segs VARCHAR2(850);
1456: l_mcat_segs VARCHAR2(850);
1457: --l_mcat_w VARCHAR2(2000);

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

1459: l_range_sql VARCHAr2(2000);
1460: lx_range_sql VARCHAR2(4000) := '1=1';
1461: BEGIN
1462:
1463: FND_FLEX_KEY_API.set_session_mode('customer_data');
1464:
1465: -- retrieve system item concatenated flexfield
1466: l_mstk_segs := '';
1467: l_flexfield_rec := FND_FLEX_KEY_API.find_flexfield('INV', 'MSTK');

Line 1467: l_flexfield_rec := FND_FLEX_KEY_API.find_flexfield('INV', 'MSTK');

1463: FND_FLEX_KEY_API.set_session_mode('customer_data');
1464:
1465: -- retrieve system item concatenated flexfield
1466: l_mstk_segs := '';
1467: l_flexfield_rec := FND_FLEX_KEY_API.find_flexfield('INV', 'MSTK');
1468: l_structure_rec := FND_FLEX_KEY_API.find_structure(l_flexfield_rec, 101);
1469: FND_FLEX_KEY_API.get_segments
1470: ( flexfield => l_flexfield_rec
1471: , structure => l_structure_rec

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

1464:
1465: -- retrieve system item concatenated flexfield
1466: l_mstk_segs := '';
1467: l_flexfield_rec := FND_FLEX_KEY_API.find_flexfield('INV', 'MSTK');
1468: l_structure_rec := FND_FLEX_KEY_API.find_structure(l_flexfield_rec, 101);
1469: FND_FLEX_KEY_API.get_segments
1470: ( flexfield => l_flexfield_rec
1471: , structure => l_structure_rec
1472: , nsegments => l_segment_number

Line 1469: FND_FLEX_KEY_API.get_segments

1465: -- retrieve system item concatenated flexfield
1466: l_mstk_segs := '';
1467: l_flexfield_rec := FND_FLEX_KEY_API.find_flexfield('INV', 'MSTK');
1468: l_structure_rec := FND_FLEX_KEY_API.find_structure(l_flexfield_rec, 101);
1469: FND_FLEX_KEY_API.get_segments
1470: ( flexfield => l_flexfield_rec
1471: , structure => l_structure_rec
1472: , nsegments => l_segment_number
1473: , segments => l_segment_tbl

Line 1476: l_segment_rec := FND_FLEX_KEY_API.find_segment

1472: , nsegments => l_segment_number
1473: , segments => l_segment_tbl
1474: );
1475: FOR l_idx IN 1..l_segment_number LOOP
1476: l_segment_rec := FND_FLEX_KEY_API.find_segment
1477: ( l_flexfield_rec
1478: , l_structure_rec
1479: , l_segment_tbl(l_idx)
1480: );

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

1486: END LOOP;
1487:
1488: -- retrieve item category concatenated flexfield
1489: l_mcat_segs := '';
1490: l_flexfield_rec := FND_FLEX_KEY_API.find_flexfield('INV', 'MCAT');
1491: l_structure_rec := FND_FLEX_KEY_API.find_structure
1492: ( l_flexfield_rec
1493: , p_cat_structure_id
1494: );

Line 1491: l_structure_rec := FND_FLEX_KEY_API.find_structure

1487:
1488: -- retrieve item category concatenated flexfield
1489: l_mcat_segs := '';
1490: l_flexfield_rec := FND_FLEX_KEY_API.find_flexfield('INV', 'MCAT');
1491: l_structure_rec := FND_FLEX_KEY_API.find_structure
1492: ( l_flexfield_rec
1493: , p_cat_structure_id
1494: );
1495: FND_FLEX_KEY_API.get_segments

Line 1495: FND_FLEX_KEY_API.get_segments

1491: l_structure_rec := FND_FLEX_KEY_API.find_structure
1492: ( l_flexfield_rec
1493: , p_cat_structure_id
1494: );
1495: FND_FLEX_KEY_API.get_segments
1496: ( flexfield => l_flexfield_rec
1497: , structure => l_structure_rec
1498: , nsegments => l_segment_number
1499: , segments => l_segment_tbl

Line 1502: l_segment_rec := FND_FLEX_KEY_API.find_segment

1498: , nsegments => l_segment_number
1499: , segments => l_segment_tbl
1500: );
1501: FOR l_idx IN 1..l_segment_number LOOP
1502: l_segment_rec := FND_FLEX_KEY_API.find_segment
1503: ( l_flexfield_rec
1504: , l_structure_rec
1505: , l_segment_tbl(l_idx)
1506: );

Line 1575: l_flexfield_rec FND_FLEX_KEY_API.flexfield_type;

1571: PROCEDURE Build_Item_Cat_Select(p_Cat_structure_id IN NUMBER
1572: ,x_item_select OUT NOCOPY VARCHAR2
1573: ,x_cat_Select OUT NOCOPY VARCHAR2
1574: ) IS
1575: l_flexfield_rec FND_FLEX_KEY_API.flexfield_type;
1576: l_structure_rec FND_FLEX_KEY_API.structure_type;
1577: l_segment_rec FND_FLEX_KEY_API.segment_type;
1578: l_segment_tbl FND_FLEX_KEY_API.segment_list;
1579: l_segment_number NUMBER;

Line 1576: l_structure_rec FND_FLEX_KEY_API.structure_type;

1572: ,x_item_select OUT NOCOPY VARCHAR2
1573: ,x_cat_Select OUT NOCOPY VARCHAR2
1574: ) IS
1575: l_flexfield_rec FND_FLEX_KEY_API.flexfield_type;
1576: l_structure_rec FND_FLEX_KEY_API.structure_type;
1577: l_segment_rec FND_FLEX_KEY_API.segment_type;
1578: l_segment_tbl FND_FLEX_KEY_API.segment_list;
1579: l_segment_number NUMBER;
1580: l_mstk_segs VARCHAR2(850);

Line 1577: l_segment_rec FND_FLEX_KEY_API.segment_type;

1573: ,x_cat_Select OUT NOCOPY VARCHAR2
1574: ) IS
1575: l_flexfield_rec FND_FLEX_KEY_API.flexfield_type;
1576: l_structure_rec FND_FLEX_KEY_API.structure_type;
1577: l_segment_rec FND_FLEX_KEY_API.segment_type;
1578: l_segment_tbl FND_FLEX_KEY_API.segment_list;
1579: l_segment_number NUMBER;
1580: l_mstk_segs VARCHAR2(850);
1581: l_mcat_segs VARCHAR2(850);

Line 1578: l_segment_tbl FND_FLEX_KEY_API.segment_list;

1574: ) IS
1575: l_flexfield_rec FND_FLEX_KEY_API.flexfield_type;
1576: l_structure_rec FND_FLEX_KEY_API.structure_type;
1577: l_segment_rec FND_FLEX_KEY_API.segment_type;
1578: l_segment_tbl FND_FLEX_KEY_API.segment_list;
1579: l_segment_number NUMBER;
1580: l_mstk_segs VARCHAR2(850);
1581: l_mcat_segs VARCHAR2(850);
1582: BEGIN

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

1579: l_segment_number NUMBER;
1580: l_mstk_segs VARCHAR2(850);
1581: l_mcat_segs VARCHAR2(850);
1582: BEGIN
1583: FND_FLEX_KEY_API.set_session_mode('customer_data');
1584:
1585: -- retrieve system item concatenated flexfield
1586: l_mstk_segs := '';
1587: l_flexfield_rec := FND_FLEX_KEY_API.find_flexfield('INV', 'MSTK');

Line 1587: l_flexfield_rec := FND_FLEX_KEY_API.find_flexfield('INV', 'MSTK');

1583: FND_FLEX_KEY_API.set_session_mode('customer_data');
1584:
1585: -- retrieve system item concatenated flexfield
1586: l_mstk_segs := '';
1587: l_flexfield_rec := FND_FLEX_KEY_API.find_flexfield('INV', 'MSTK');
1588: l_structure_rec := FND_FLEX_KEY_API.find_structure(l_flexfield_rec, 101);
1589: FND_FLEX_KEY_API.get_segments
1590: ( flexfield => l_flexfield_rec
1591: , structure => l_structure_rec

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

1584:
1585: -- retrieve system item concatenated flexfield
1586: l_mstk_segs := '';
1587: l_flexfield_rec := FND_FLEX_KEY_API.find_flexfield('INV', 'MSTK');
1588: l_structure_rec := FND_FLEX_KEY_API.find_structure(l_flexfield_rec, 101);
1589: FND_FLEX_KEY_API.get_segments
1590: ( flexfield => l_flexfield_rec
1591: , structure => l_structure_rec
1592: , nsegments => l_segment_number

Line 1589: FND_FLEX_KEY_API.get_segments

1585: -- retrieve system item concatenated flexfield
1586: l_mstk_segs := '';
1587: l_flexfield_rec := FND_FLEX_KEY_API.find_flexfield('INV', 'MSTK');
1588: l_structure_rec := FND_FLEX_KEY_API.find_structure(l_flexfield_rec, 101);
1589: FND_FLEX_KEY_API.get_segments
1590: ( flexfield => l_flexfield_rec
1591: , structure => l_structure_rec
1592: , nsegments => l_segment_number
1593: , segments => l_segment_tbl

Line 1596: l_segment_rec := FND_FLEX_KEY_API.find_segment

1592: , nsegments => l_segment_number
1593: , segments => l_segment_tbl
1594: );
1595: FOR l_idx IN 1..l_segment_number LOOP
1596: l_segment_rec := FND_FLEX_KEY_API.find_segment
1597: ( l_flexfield_rec
1598: , l_structure_rec
1599: , l_segment_tbl(l_idx)
1600: );

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

1607: END LOOP;
1608:
1609: -- retrieve item category concatenated flexfield
1610: l_mcat_segs := '';
1611: l_flexfield_rec := FND_FLEX_KEY_API.find_flexfield('INV', 'MCAT');
1612: l_structure_rec := FND_FLEX_KEY_API.find_structure
1613: ( l_flexfield_rec
1614: , p_cat_structure_id
1615: );

Line 1612: l_structure_rec := FND_FLEX_KEY_API.find_structure

1608:
1609: -- retrieve item category concatenated flexfield
1610: l_mcat_segs := '';
1611: l_flexfield_rec := FND_FLEX_KEY_API.find_flexfield('INV', 'MCAT');
1612: l_structure_rec := FND_FLEX_KEY_API.find_structure
1613: ( l_flexfield_rec
1614: , p_cat_structure_id
1615: );
1616: FND_FLEX_KEY_API.get_segments

Line 1616: FND_FLEX_KEY_API.get_segments

1612: l_structure_rec := FND_FLEX_KEY_API.find_structure
1613: ( l_flexfield_rec
1614: , p_cat_structure_id
1615: );
1616: FND_FLEX_KEY_API.get_segments
1617: ( flexfield => l_flexfield_rec
1618: , structure => l_structure_rec
1619: , nsegments => l_segment_number
1620: , segments => l_segment_tbl

Line 1623: l_segment_rec := FND_FLEX_KEY_API.find_segment

1619: , nsegments => l_segment_number
1620: , segments => l_segment_tbl
1621: );
1622: FOR l_idx IN 1..l_segment_number LOOP
1623: l_segment_rec := FND_FLEX_KEY_API.find_segment
1624: ( l_flexfield_rec
1625: , l_structure_rec
1626: , l_segment_tbl(l_idx)
1627: );