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 1139: l_flexfield_rec FND_FLEX_KEY_API.flexfield_type;

1135: PROCEDURE Build_Item_Cat_Select(p_Cat_structure_id IN NUMBER
1136: ,x_item_select OUT NOCOPY VARCHAR2
1137: ,x_cat_Select OUT NOCOPY VARCHAR2
1138: ) IS
1139: l_flexfield_rec FND_FLEX_KEY_API.flexfield_type;
1140: l_structure_rec FND_FLEX_KEY_API.structure_type;
1141: l_segment_rec FND_FLEX_KEY_API.segment_type;
1142: l_segment_tbl FND_FLEX_KEY_API.segment_list;
1143: l_segment_number NUMBER;

Line 1140: l_structure_rec FND_FLEX_KEY_API.structure_type;

1136: ,x_item_select OUT NOCOPY VARCHAR2
1137: ,x_cat_Select OUT NOCOPY VARCHAR2
1138: ) IS
1139: l_flexfield_rec FND_FLEX_KEY_API.flexfield_type;
1140: l_structure_rec FND_FLEX_KEY_API.structure_type;
1141: l_segment_rec FND_FLEX_KEY_API.segment_type;
1142: l_segment_tbl FND_FLEX_KEY_API.segment_list;
1143: l_segment_number NUMBER;
1144: l_mstk_segs VARCHAR2(850);

Line 1141: l_segment_rec FND_FLEX_KEY_API.segment_type;

1137: ,x_cat_Select OUT NOCOPY VARCHAR2
1138: ) IS
1139: l_flexfield_rec FND_FLEX_KEY_API.flexfield_type;
1140: l_structure_rec FND_FLEX_KEY_API.structure_type;
1141: l_segment_rec FND_FLEX_KEY_API.segment_type;
1142: l_segment_tbl FND_FLEX_KEY_API.segment_list;
1143: l_segment_number NUMBER;
1144: l_mstk_segs VARCHAR2(850);
1145: l_mcat_segs VARCHAR2(850);

Line 1142: l_segment_tbl FND_FLEX_KEY_API.segment_list;

1138: ) IS
1139: l_flexfield_rec FND_FLEX_KEY_API.flexfield_type;
1140: l_structure_rec FND_FLEX_KEY_API.structure_type;
1141: l_segment_rec FND_FLEX_KEY_API.segment_type;
1142: l_segment_tbl FND_FLEX_KEY_API.segment_list;
1143: l_segment_number NUMBER;
1144: l_mstk_segs VARCHAR2(850);
1145: l_mcat_segs VARCHAR2(850);
1146: BEGIN

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

1143: l_segment_number NUMBER;
1144: l_mstk_segs VARCHAR2(850);
1145: l_mcat_segs VARCHAR2(850);
1146: BEGIN
1147: FND_FLEX_KEY_API.set_session_mode('customer_data');
1148:
1149: -- retrieve system item concatenated flexfield
1150: l_mstk_segs := '';
1151: l_flexfield_rec := FND_FLEX_KEY_API.find_flexfield('INV', 'MSTK');

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

1147: FND_FLEX_KEY_API.set_session_mode('customer_data');
1148:
1149: -- retrieve system item concatenated flexfield
1150: l_mstk_segs := '';
1151: l_flexfield_rec := FND_FLEX_KEY_API.find_flexfield('INV', 'MSTK');
1152: l_structure_rec := FND_FLEX_KEY_API.find_structure(l_flexfield_rec, 101);
1153: FND_FLEX_KEY_API.get_segments
1154: ( flexfield => l_flexfield_rec
1155: , structure => l_structure_rec

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

1148:
1149: -- retrieve system item concatenated flexfield
1150: l_mstk_segs := '';
1151: l_flexfield_rec := FND_FLEX_KEY_API.find_flexfield('INV', 'MSTK');
1152: l_structure_rec := FND_FLEX_KEY_API.find_structure(l_flexfield_rec, 101);
1153: FND_FLEX_KEY_API.get_segments
1154: ( flexfield => l_flexfield_rec
1155: , structure => l_structure_rec
1156: , nsegments => l_segment_number

Line 1153: FND_FLEX_KEY_API.get_segments

1149: -- retrieve system item concatenated flexfield
1150: l_mstk_segs := '';
1151: l_flexfield_rec := FND_FLEX_KEY_API.find_flexfield('INV', 'MSTK');
1152: l_structure_rec := FND_FLEX_KEY_API.find_structure(l_flexfield_rec, 101);
1153: FND_FLEX_KEY_API.get_segments
1154: ( flexfield => l_flexfield_rec
1155: , structure => l_structure_rec
1156: , nsegments => l_segment_number
1157: , segments => l_segment_tbl

Line 1160: l_segment_rec := FND_FLEX_KEY_API.find_segment

1156: , nsegments => l_segment_number
1157: , segments => l_segment_tbl
1158: );
1159: FOR l_idx IN 1..l_segment_number LOOP
1160: l_segment_rec := FND_FLEX_KEY_API.find_segment
1161: ( l_flexfield_rec
1162: , l_structure_rec
1163: , l_segment_tbl(l_idx)
1164: );

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

1169: END LOOP;
1170:
1171: -- retrieve item category concatenated flexfield
1172: l_mcat_segs := '';
1173: l_flexfield_rec := FND_FLEX_KEY_API.find_flexfield('INV', 'MCAT');
1174: l_structure_rec := FND_FLEX_KEY_API.find_structure
1175: ( l_flexfield_rec
1176: , p_cat_structure_id
1177: );

Line 1174: l_structure_rec := FND_FLEX_KEY_API.find_structure

1170:
1171: -- retrieve item category concatenated flexfield
1172: l_mcat_segs := '';
1173: l_flexfield_rec := FND_FLEX_KEY_API.find_flexfield('INV', 'MCAT');
1174: l_structure_rec := FND_FLEX_KEY_API.find_structure
1175: ( l_flexfield_rec
1176: , p_cat_structure_id
1177: );
1178: FND_FLEX_KEY_API.get_segments

Line 1178: FND_FLEX_KEY_API.get_segments

1174: l_structure_rec := FND_FLEX_KEY_API.find_structure
1175: ( l_flexfield_rec
1176: , p_cat_structure_id
1177: );
1178: FND_FLEX_KEY_API.get_segments
1179: ( flexfield => l_flexfield_rec
1180: , structure => l_structure_rec
1181: , nsegments => l_segment_number
1182: , segments => l_segment_tbl

Line 1185: l_segment_rec := FND_FLEX_KEY_API.find_segment

1181: , nsegments => l_segment_number
1182: , segments => l_segment_tbl
1183: );
1184: FOR l_idx IN 1..l_segment_number LOOP
1185: l_segment_rec := FND_FLEX_KEY_API.find_segment
1186: ( l_flexfield_rec
1187: , l_structure_rec
1188: , l_segment_tbl(l_idx)
1189: );

Line 1213: l_flexfield_rec FND_FLEX_KEY_API.flexfield_type;

1209: , p_lot_ctl IN NUMBER
1210: , x_range_sql OUT NOCOPY VARCHAR2
1211: )
1212: IS
1213: l_flexfield_rec FND_FLEX_KEY_API.flexfield_type;
1214: l_structure_rec FND_FLEX_KEY_API.structure_type;
1215: l_segment_rec FND_FLEX_KEY_API.segment_type;
1216: l_segment_tbl FND_FLEX_KEY_API.segment_list;
1217: l_segment_number NUMBER;

Line 1214: l_structure_rec FND_FLEX_KEY_API.structure_type;

1210: , x_range_sql OUT NOCOPY VARCHAR2
1211: )
1212: IS
1213: l_flexfield_rec FND_FLEX_KEY_API.flexfield_type;
1214: l_structure_rec FND_FLEX_KEY_API.structure_type;
1215: l_segment_rec FND_FLEX_KEY_API.segment_type;
1216: l_segment_tbl FND_FLEX_KEY_API.segment_list;
1217: l_segment_number NUMBER;
1218: l_mstk_segs VARCHAR2(850);

Line 1215: l_segment_rec FND_FLEX_KEY_API.segment_type;

1211: )
1212: IS
1213: l_flexfield_rec FND_FLEX_KEY_API.flexfield_type;
1214: l_structure_rec FND_FLEX_KEY_API.structure_type;
1215: l_segment_rec FND_FLEX_KEY_API.segment_type;
1216: l_segment_tbl FND_FLEX_KEY_API.segment_list;
1217: l_segment_number NUMBER;
1218: l_mstk_segs VARCHAR2(850);
1219: l_mcat_segs VARCHAR2(850);

Line 1216: l_segment_tbl FND_FLEX_KEY_API.segment_list;

1212: IS
1213: l_flexfield_rec FND_FLEX_KEY_API.flexfield_type;
1214: l_structure_rec FND_FLEX_KEY_API.structure_type;
1215: l_segment_rec FND_FLEX_KEY_API.segment_type;
1216: l_segment_tbl FND_FLEX_KEY_API.segment_list;
1217: l_segment_number NUMBER;
1218: l_mstk_segs VARCHAR2(850);
1219: l_mcat_segs VARCHAR2(850);
1220: --l_mcat_w VARCHAR2(2000);

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

1222: l_range_sql VARCHAr2(2000);
1223: lx_range_sql VARCHAR2(4000) := '1=1';
1224: BEGIN
1225:
1226: FND_FLEX_KEY_API.set_session_mode('customer_data');
1227:
1228: -- retrieve system item concatenated flexfield
1229: l_mstk_segs := '';
1230: l_flexfield_rec := FND_FLEX_KEY_API.find_flexfield('INV', 'MSTK');

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

1226: FND_FLEX_KEY_API.set_session_mode('customer_data');
1227:
1228: -- retrieve system item concatenated flexfield
1229: l_mstk_segs := '';
1230: l_flexfield_rec := FND_FLEX_KEY_API.find_flexfield('INV', 'MSTK');
1231: l_structure_rec := FND_FLEX_KEY_API.find_structure(l_flexfield_rec, 101);
1232: FND_FLEX_KEY_API.get_segments
1233: ( flexfield => l_flexfield_rec
1234: , structure => l_structure_rec

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

1227:
1228: -- retrieve system item concatenated flexfield
1229: l_mstk_segs := '';
1230: l_flexfield_rec := FND_FLEX_KEY_API.find_flexfield('INV', 'MSTK');
1231: l_structure_rec := FND_FLEX_KEY_API.find_structure(l_flexfield_rec, 101);
1232: FND_FLEX_KEY_API.get_segments
1233: ( flexfield => l_flexfield_rec
1234: , structure => l_structure_rec
1235: , nsegments => l_segment_number

Line 1232: FND_FLEX_KEY_API.get_segments

1228: -- retrieve system item concatenated flexfield
1229: l_mstk_segs := '';
1230: l_flexfield_rec := FND_FLEX_KEY_API.find_flexfield('INV', 'MSTK');
1231: l_structure_rec := FND_FLEX_KEY_API.find_structure(l_flexfield_rec, 101);
1232: FND_FLEX_KEY_API.get_segments
1233: ( flexfield => l_flexfield_rec
1234: , structure => l_structure_rec
1235: , nsegments => l_segment_number
1236: , segments => l_segment_tbl

Line 1239: l_segment_rec := FND_FLEX_KEY_API.find_segment

1235: , nsegments => l_segment_number
1236: , segments => l_segment_tbl
1237: );
1238: FOR l_idx IN 1..l_segment_number LOOP
1239: l_segment_rec := FND_FLEX_KEY_API.find_segment
1240: ( l_flexfield_rec
1241: , l_structure_rec
1242: , l_segment_tbl(l_idx)
1243: );

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

1248: END LOOP;
1249:
1250: -- retrieve item category concatenated flexfield
1251: l_mcat_segs := '';
1252: l_flexfield_rec := FND_FLEX_KEY_API.find_flexfield('INV', 'MCAT');
1253: l_structure_rec := FND_FLEX_KEY_API.find_structure
1254: ( l_flexfield_rec
1255: , p_cat_structure_id
1256: );

Line 1253: l_structure_rec := FND_FLEX_KEY_API.find_structure

1249:
1250: -- retrieve item category concatenated flexfield
1251: l_mcat_segs := '';
1252: l_flexfield_rec := FND_FLEX_KEY_API.find_flexfield('INV', 'MCAT');
1253: l_structure_rec := FND_FLEX_KEY_API.find_structure
1254: ( l_flexfield_rec
1255: , p_cat_structure_id
1256: );
1257: FND_FLEX_KEY_API.get_segments

Line 1257: FND_FLEX_KEY_API.get_segments

1253: l_structure_rec := FND_FLEX_KEY_API.find_structure
1254: ( l_flexfield_rec
1255: , p_cat_structure_id
1256: );
1257: FND_FLEX_KEY_API.get_segments
1258: ( flexfield => l_flexfield_rec
1259: , structure => l_structure_rec
1260: , nsegments => l_segment_number
1261: , segments => l_segment_tbl

Line 1264: l_segment_rec := FND_FLEX_KEY_API.find_segment

1260: , nsegments => l_segment_number
1261: , segments => l_segment_tbl
1262: );
1263: FOR l_idx IN 1..l_segment_number LOOP
1264: l_segment_rec := FND_FLEX_KEY_API.find_segment
1265: ( l_flexfield_rec
1266: , l_structure_rec
1267: , l_segment_tbl(l_idx)
1268: );