APPS.INV_ITEM_ATTRIBUTES_PKG dependencies on FND_FLEX_KEY_API

Line 390: l_flexfield_rec FND_FLEX_KEY_API.flexfield_type;

386: , p_copy_dff_to_null IN VARCHAR2
387: , x_item_cursor IN OUT NOCOPY VARCHAR2
388: )
389: IS
390: l_flexfield_rec FND_FLEX_KEY_API.flexfield_type;
391: l_structure_rec FND_FLEX_KEY_API.structure_type;
392: l_segment_rec FND_FLEX_KEY_API.segment_type;
393: l_segment_tbl FND_FLEX_KEY_API.segment_list;
394: l_segment_number NUMBER;

Line 391: l_structure_rec FND_FLEX_KEY_API.structure_type;

387: , x_item_cursor IN OUT NOCOPY VARCHAR2
388: )
389: IS
390: l_flexfield_rec FND_FLEX_KEY_API.flexfield_type;
391: l_structure_rec FND_FLEX_KEY_API.structure_type;
392: l_segment_rec FND_FLEX_KEY_API.segment_type;
393: l_segment_tbl FND_FLEX_KEY_API.segment_list;
394: l_segment_number NUMBER;
395: l_mstk_segs VARCHAR2(850);

Line 392: l_segment_rec FND_FLEX_KEY_API.segment_type;

388: )
389: IS
390: l_flexfield_rec FND_FLEX_KEY_API.flexfield_type;
391: l_structure_rec FND_FLEX_KEY_API.structure_type;
392: l_segment_rec FND_FLEX_KEY_API.segment_type;
393: l_segment_tbl FND_FLEX_KEY_API.segment_list;
394: l_segment_number NUMBER;
395: l_mstk_segs VARCHAR2(850);
396: l_mcat_f VARCHAR2(2000);

Line 393: l_segment_tbl FND_FLEX_KEY_API.segment_list;

389: IS
390: l_flexfield_rec FND_FLEX_KEY_API.flexfield_type;
391: l_structure_rec FND_FLEX_KEY_API.structure_type;
392: l_segment_rec FND_FLEX_KEY_API.segment_type;
393: l_segment_tbl FND_FLEX_KEY_API.segment_list;
394: l_segment_number NUMBER;
395: l_mstk_segs VARCHAR2(850);
396: l_mcat_f VARCHAR2(2000);
397: l_mcat_w1 VARCHAR2(2000);

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

415: , '> Build_Item_Cursor'
416: );
417: END IF;
418:
419: FND_FLEX_KEY_API.set_session_mode('customer_data');
420:
421: -- retrieve system item concatenated flexfield
422: l_mstk_segs := '';
423: l_flexfield_rec := FND_FLEX_KEY_API.find_flexfield('INV', 'MSTK');

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

419: FND_FLEX_KEY_API.set_session_mode('customer_data');
420:
421: -- retrieve system item concatenated flexfield
422: l_mstk_segs := '';
423: l_flexfield_rec := FND_FLEX_KEY_API.find_flexfield('INV', 'MSTK');
424: l_structure_rec := FND_FLEX_KEY_API.find_structure(l_flexfield_rec, 101);
425: FND_FLEX_KEY_API.get_segments
426: ( flexfield => l_flexfield_rec
427: , structure => l_structure_rec

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

420:
421: -- retrieve system item concatenated flexfield
422: l_mstk_segs := '';
423: l_flexfield_rec := FND_FLEX_KEY_API.find_flexfield('INV', 'MSTK');
424: l_structure_rec := FND_FLEX_KEY_API.find_structure(l_flexfield_rec, 101);
425: FND_FLEX_KEY_API.get_segments
426: ( flexfield => l_flexfield_rec
427: , structure => l_structure_rec
428: , nsegments => l_segment_number

Line 425: FND_FLEX_KEY_API.get_segments

421: -- retrieve system item concatenated flexfield
422: l_mstk_segs := '';
423: l_flexfield_rec := FND_FLEX_KEY_API.find_flexfield('INV', 'MSTK');
424: l_structure_rec := FND_FLEX_KEY_API.find_structure(l_flexfield_rec, 101);
425: FND_FLEX_KEY_API.get_segments
426: ( flexfield => l_flexfield_rec
427: , structure => l_structure_rec
428: , nsegments => l_segment_number
429: , segments => l_segment_tbl

Line 432: l_segment_rec := FND_FLEX_KEY_API.find_segment

428: , nsegments => l_segment_number
429: , segments => l_segment_tbl
430: );
431: FOR l_idx IN 1..l_segment_number LOOP
432: l_segment_rec := FND_FLEX_KEY_API.find_segment
433: ( l_flexfield_rec
434: , l_structure_rec
435: , l_segment_tbl(l_idx)
436: );

Line 553: , FND_FLEX_KEY_API.message

549: WHEN OTHERS THEN
550: IF G_DEBUG = 'Y' THEN
551: INV_ORGHIERARCHY_PVT.Log
552: ( INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION
553: , FND_FLEX_KEY_API.message
554: );
555: END IF;
556: RAISE;
557: