21: l_Item_Table IN OUT NOCOPY WSH_ITM_QUERY_CUSTOM.g_CondnValTableType
22: )
23:
24: IS
25: l_flexfield_rec FND_FLEX_KEY_API.flexfield_type;
26: l_structure_rec FND_FLEX_KEY_API.structure_type;
27: l_segment_rec FND_FLEX_KEY_API.segment_type;
28: l_segment_tbl FND_FLEX_KEY_API.segment_list;
29:
22: )
23:
24: IS
25: l_flexfield_rec FND_FLEX_KEY_API.flexfield_type;
26: l_structure_rec FND_FLEX_KEY_API.structure_type;
27: l_segment_rec FND_FLEX_KEY_API.segment_type;
28: l_segment_tbl FND_FLEX_KEY_API.segment_list;
29:
30: l_Item_Condn2Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
23:
24: IS
25: l_flexfield_rec FND_FLEX_KEY_API.flexfield_type;
26: l_structure_rec FND_FLEX_KEY_API.structure_type;
27: l_segment_rec FND_FLEX_KEY_API.segment_type;
28: l_segment_tbl FND_FLEX_KEY_API.segment_list;
29:
30: l_Item_Condn2Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
31: l_Item_Condn22Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
24: IS
25: l_flexfield_rec FND_FLEX_KEY_API.flexfield_type;
26: l_structure_rec FND_FLEX_KEY_API.structure_type;
27: l_segment_rec FND_FLEX_KEY_API.segment_type;
28: l_segment_tbl FND_FLEX_KEY_API.segment_list;
29:
30: l_Item_Condn2Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
31: l_Item_Condn22Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
32:
63:
64: END IF;
65: --
66:
67: FND_FLEX_KEY_API.set_session_mode('customer_data');
68: -- retrieve system item concatenated flexfield
69: l_mstk_segs := '';
70: l_flexfield_rec := FND_FLEX_KEY_API.find_flexfield('INV', 'MSTK');
71: l_structure_rec := FND_FLEX_KEY_API.find_structure(l_flexfield_rec, 101);
66:
67: FND_FLEX_KEY_API.set_session_mode('customer_data');
68: -- retrieve system item concatenated flexfield
69: l_mstk_segs := '';
70: l_flexfield_rec := FND_FLEX_KEY_API.find_flexfield('INV', 'MSTK');
71: l_structure_rec := FND_FLEX_KEY_API.find_structure(l_flexfield_rec, 101);
72:
73: FND_FLEX_KEY_API.get_segments
74: ( flexfield => l_flexfield_rec
67: FND_FLEX_KEY_API.set_session_mode('customer_data');
68: -- retrieve system item concatenated flexfield
69: l_mstk_segs := '';
70: l_flexfield_rec := FND_FLEX_KEY_API.find_flexfield('INV', 'MSTK');
71: l_structure_rec := FND_FLEX_KEY_API.find_structure(l_flexfield_rec, 101);
72:
73: FND_FLEX_KEY_API.get_segments
74: ( flexfield => l_flexfield_rec
75: , structure => l_structure_rec
69: l_mstk_segs := '';
70: l_flexfield_rec := FND_FLEX_KEY_API.find_flexfield('INV', 'MSTK');
71: l_structure_rec := FND_FLEX_KEY_API.find_structure(l_flexfield_rec, 101);
72:
73: FND_FLEX_KEY_API.get_segments
74: ( flexfield => l_flexfield_rec
75: , structure => l_structure_rec
76: , nsegments => l_segment_number
77: , segments => l_segment_tbl
77: , segments => l_segment_tbl
78: );
79:
80: FOR l_idx IN 1..l_segment_number LOOP
81: l_segment_rec := FND_FLEX_KEY_API.find_segment
82: ( l_flexfield_rec
83: , l_structure_rec
84: , l_segment_tbl(l_idx)
85: );