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_EXCESS_PARTS_PVT dependencies on FND_FLEX_KEY_API

Line 1260: l_flexfield_rec FND_FLEX_KEY_API.flexfield_type;

1256: PROCEDURE Build_Item_Cat_Select(p_Cat_structure_id IN NUMBER
1257: ,x_item_select OUT NOCOPY VARCHAR2
1258: ,x_cat_Select OUT NOCOPY VARCHAR2
1259: ) IS
1260: l_flexfield_rec FND_FLEX_KEY_API.flexfield_type;
1261: l_structure_rec FND_FLEX_KEY_API.structure_type;
1262: l_segment_rec FND_FLEX_KEY_API.segment_type;
1263: l_segment_tbl FND_FLEX_KEY_API.segment_list;
1264: l_segment_number NUMBER;

Line 1261: l_structure_rec FND_FLEX_KEY_API.structure_type;

1257: ,x_item_select OUT NOCOPY VARCHAR2
1258: ,x_cat_Select OUT NOCOPY VARCHAR2
1259: ) IS
1260: l_flexfield_rec FND_FLEX_KEY_API.flexfield_type;
1261: l_structure_rec FND_FLEX_KEY_API.structure_type;
1262: l_segment_rec FND_FLEX_KEY_API.segment_type;
1263: l_segment_tbl FND_FLEX_KEY_API.segment_list;
1264: l_segment_number NUMBER;
1265: l_mstk_segs VARCHAR2(850);

Line 1262: l_segment_rec FND_FLEX_KEY_API.segment_type;

1258: ,x_cat_Select OUT NOCOPY VARCHAR2
1259: ) IS
1260: l_flexfield_rec FND_FLEX_KEY_API.flexfield_type;
1261: l_structure_rec FND_FLEX_KEY_API.structure_type;
1262: l_segment_rec FND_FLEX_KEY_API.segment_type;
1263: l_segment_tbl FND_FLEX_KEY_API.segment_list;
1264: l_segment_number NUMBER;
1265: l_mstk_segs VARCHAR2(850);
1266: l_mcat_segs VARCHAR2(850);

Line 1263: l_segment_tbl FND_FLEX_KEY_API.segment_list;

1259: ) IS
1260: l_flexfield_rec FND_FLEX_KEY_API.flexfield_type;
1261: l_structure_rec FND_FLEX_KEY_API.structure_type;
1262: l_segment_rec FND_FLEX_KEY_API.segment_type;
1263: l_segment_tbl FND_FLEX_KEY_API.segment_list;
1264: l_segment_number NUMBER;
1265: l_mstk_segs VARCHAR2(850);
1266: l_mcat_segs VARCHAR2(850);
1267: BEGIN

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

1264: l_segment_number NUMBER;
1265: l_mstk_segs VARCHAR2(850);
1266: l_mcat_segs VARCHAR2(850);
1267: BEGIN
1268: FND_FLEX_KEY_API.set_session_mode('customer_data');
1269:
1270: -- retrieve system item concatenated flexfield
1271: l_mstk_segs := '';
1272: l_flexfield_rec := FND_FLEX_KEY_API.find_flexfield('INV', 'MSTK');

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

1268: FND_FLEX_KEY_API.set_session_mode('customer_data');
1269:
1270: -- retrieve system item concatenated flexfield
1271: l_mstk_segs := '';
1272: l_flexfield_rec := FND_FLEX_KEY_API.find_flexfield('INV', 'MSTK');
1273: l_structure_rec := FND_FLEX_KEY_API.find_structure(l_flexfield_rec, 101);
1274: FND_FLEX_KEY_API.get_segments
1275: ( flexfield => l_flexfield_rec
1276: , structure => l_structure_rec

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

1269:
1270: -- retrieve system item concatenated flexfield
1271: l_mstk_segs := '';
1272: l_flexfield_rec := FND_FLEX_KEY_API.find_flexfield('INV', 'MSTK');
1273: l_structure_rec := FND_FLEX_KEY_API.find_structure(l_flexfield_rec, 101);
1274: FND_FLEX_KEY_API.get_segments
1275: ( flexfield => l_flexfield_rec
1276: , structure => l_structure_rec
1277: , nsegments => l_segment_number

Line 1274: FND_FLEX_KEY_API.get_segments

1270: -- retrieve system item concatenated flexfield
1271: l_mstk_segs := '';
1272: l_flexfield_rec := FND_FLEX_KEY_API.find_flexfield('INV', 'MSTK');
1273: l_structure_rec := FND_FLEX_KEY_API.find_structure(l_flexfield_rec, 101);
1274: FND_FLEX_KEY_API.get_segments
1275: ( flexfield => l_flexfield_rec
1276: , structure => l_structure_rec
1277: , nsegments => l_segment_number
1278: , segments => l_segment_tbl

Line 1281: l_segment_rec := FND_FLEX_KEY_API.find_segment

1277: , nsegments => l_segment_number
1278: , segments => l_segment_tbl
1279: );
1280: FOR l_idx IN 1..l_segment_number LOOP
1281: l_segment_rec := FND_FLEX_KEY_API.find_segment
1282: ( l_flexfield_rec
1283: , l_structure_rec
1284: , l_segment_tbl(l_idx)
1285: );

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

1290: END LOOP;
1291:
1292: -- retrieve item category concatenated flexfield
1293: l_mcat_segs := '';
1294: l_flexfield_rec := FND_FLEX_KEY_API.find_flexfield('INV', 'MCAT');
1295: l_structure_rec := FND_FLEX_KEY_API.find_structure
1296: ( l_flexfield_rec
1297: , p_cat_structure_id
1298: );

Line 1295: l_structure_rec := FND_FLEX_KEY_API.find_structure

1291:
1292: -- retrieve item category concatenated flexfield
1293: l_mcat_segs := '';
1294: l_flexfield_rec := FND_FLEX_KEY_API.find_flexfield('INV', 'MCAT');
1295: l_structure_rec := FND_FLEX_KEY_API.find_structure
1296: ( l_flexfield_rec
1297: , p_cat_structure_id
1298: );
1299: FND_FLEX_KEY_API.get_segments

Line 1299: FND_FLEX_KEY_API.get_segments

1295: l_structure_rec := FND_FLEX_KEY_API.find_structure
1296: ( l_flexfield_rec
1297: , p_cat_structure_id
1298: );
1299: FND_FLEX_KEY_API.get_segments
1300: ( flexfield => l_flexfield_rec
1301: , structure => l_structure_rec
1302: , nsegments => l_segment_number
1303: , segments => l_segment_tbl

Line 1306: l_segment_rec := FND_FLEX_KEY_API.find_segment

1302: , nsegments => l_segment_number
1303: , segments => l_segment_tbl
1304: );
1305: FOR l_idx IN 1..l_segment_number LOOP
1306: l_segment_rec := FND_FLEX_KEY_API.find_segment
1307: ( l_flexfield_rec
1308: , l_structure_rec
1309: , l_segment_tbl(l_idx)
1310: );

Line 1334: l_flexfield_rec FND_FLEX_KEY_API.flexfield_type;

1330: , p_lot_ctl IN NUMBER
1331: , x_range_sql OUT NOCOPY VARCHAR2
1332: )
1333: IS
1334: l_flexfield_rec FND_FLEX_KEY_API.flexfield_type;
1335: l_structure_rec FND_FLEX_KEY_API.structure_type;
1336: l_segment_rec FND_FLEX_KEY_API.segment_type;
1337: l_segment_tbl FND_FLEX_KEY_API.segment_list;
1338: l_segment_number NUMBER;

Line 1335: l_structure_rec FND_FLEX_KEY_API.structure_type;

1331: , x_range_sql OUT NOCOPY VARCHAR2
1332: )
1333: IS
1334: l_flexfield_rec FND_FLEX_KEY_API.flexfield_type;
1335: l_structure_rec FND_FLEX_KEY_API.structure_type;
1336: l_segment_rec FND_FLEX_KEY_API.segment_type;
1337: l_segment_tbl FND_FLEX_KEY_API.segment_list;
1338: l_segment_number NUMBER;
1339: l_mstk_segs VARCHAR2(850);

Line 1336: l_segment_rec FND_FLEX_KEY_API.segment_type;

1332: )
1333: IS
1334: l_flexfield_rec FND_FLEX_KEY_API.flexfield_type;
1335: l_structure_rec FND_FLEX_KEY_API.structure_type;
1336: l_segment_rec FND_FLEX_KEY_API.segment_type;
1337: l_segment_tbl FND_FLEX_KEY_API.segment_list;
1338: l_segment_number NUMBER;
1339: l_mstk_segs VARCHAR2(850);
1340: l_mcat_segs VARCHAR2(850);

Line 1337: l_segment_tbl FND_FLEX_KEY_API.segment_list;

1333: IS
1334: l_flexfield_rec FND_FLEX_KEY_API.flexfield_type;
1335: l_structure_rec FND_FLEX_KEY_API.structure_type;
1336: l_segment_rec FND_FLEX_KEY_API.segment_type;
1337: l_segment_tbl FND_FLEX_KEY_API.segment_list;
1338: l_segment_number NUMBER;
1339: l_mstk_segs VARCHAR2(850);
1340: l_mcat_segs VARCHAR2(850);
1341: --l_mcat_w VARCHAR2(2000);

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

1343: l_range_sql VARCHAr2(2000);
1344: lx_range_sql VARCHAR2(4000) := '1=1';
1345: BEGIN
1346:
1347: FND_FLEX_KEY_API.set_session_mode('customer_data');
1348:
1349: -- retrieve system item concatenated flexfield
1350: l_mstk_segs := '';
1351: l_flexfield_rec := FND_FLEX_KEY_API.find_flexfield('INV', 'MSTK');

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

1347: FND_FLEX_KEY_API.set_session_mode('customer_data');
1348:
1349: -- retrieve system item concatenated flexfield
1350: l_mstk_segs := '';
1351: l_flexfield_rec := FND_FLEX_KEY_API.find_flexfield('INV', 'MSTK');
1352: l_structure_rec := FND_FLEX_KEY_API.find_structure(l_flexfield_rec, 101);
1353: FND_FLEX_KEY_API.get_segments
1354: ( flexfield => l_flexfield_rec
1355: , structure => l_structure_rec

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

1348:
1349: -- retrieve system item concatenated flexfield
1350: l_mstk_segs := '';
1351: l_flexfield_rec := FND_FLEX_KEY_API.find_flexfield('INV', 'MSTK');
1352: l_structure_rec := FND_FLEX_KEY_API.find_structure(l_flexfield_rec, 101);
1353: FND_FLEX_KEY_API.get_segments
1354: ( flexfield => l_flexfield_rec
1355: , structure => l_structure_rec
1356: , nsegments => l_segment_number

Line 1353: FND_FLEX_KEY_API.get_segments

1349: -- retrieve system item concatenated flexfield
1350: l_mstk_segs := '';
1351: l_flexfield_rec := FND_FLEX_KEY_API.find_flexfield('INV', 'MSTK');
1352: l_structure_rec := FND_FLEX_KEY_API.find_structure(l_flexfield_rec, 101);
1353: FND_FLEX_KEY_API.get_segments
1354: ( flexfield => l_flexfield_rec
1355: , structure => l_structure_rec
1356: , nsegments => l_segment_number
1357: , segments => l_segment_tbl

Line 1360: l_segment_rec := FND_FLEX_KEY_API.find_segment

1356: , nsegments => l_segment_number
1357: , segments => l_segment_tbl
1358: );
1359: FOR l_idx IN 1..l_segment_number LOOP
1360: l_segment_rec := FND_FLEX_KEY_API.find_segment
1361: ( l_flexfield_rec
1362: , l_structure_rec
1363: , l_segment_tbl(l_idx)
1364: );

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

1369: END LOOP;
1370:
1371: -- retrieve item category concatenated flexfield
1372: l_mcat_segs := '';
1373: l_flexfield_rec := FND_FLEX_KEY_API.find_flexfield('INV', 'MCAT');
1374: l_structure_rec := FND_FLEX_KEY_API.find_structure
1375: ( l_flexfield_rec
1376: , p_cat_structure_id
1377: );

Line 1374: l_structure_rec := FND_FLEX_KEY_API.find_structure

1370:
1371: -- retrieve item category concatenated flexfield
1372: l_mcat_segs := '';
1373: l_flexfield_rec := FND_FLEX_KEY_API.find_flexfield('INV', 'MCAT');
1374: l_structure_rec := FND_FLEX_KEY_API.find_structure
1375: ( l_flexfield_rec
1376: , p_cat_structure_id
1377: );
1378: FND_FLEX_KEY_API.get_segments

Line 1378: FND_FLEX_KEY_API.get_segments

1374: l_structure_rec := FND_FLEX_KEY_API.find_structure
1375: ( l_flexfield_rec
1376: , p_cat_structure_id
1377: );
1378: FND_FLEX_KEY_API.get_segments
1379: ( flexfield => l_flexfield_rec
1380: , structure => l_structure_rec
1381: , nsegments => l_segment_number
1382: , segments => l_segment_tbl

Line 1385: l_segment_rec := FND_FLEX_KEY_API.find_segment

1381: , nsegments => l_segment_number
1382: , segments => l_segment_tbl
1383: );
1384: FOR l_idx IN 1..l_segment_number LOOP
1385: l_segment_rec := FND_FLEX_KEY_API.find_segment
1386: ( l_flexfield_rec
1387: , l_structure_rec
1388: , l_segment_tbl(l_idx)
1389: );