494: l_flex_num Number := Null;
495: l_quote varchar2(1) := '''';
496:
497: -- we need two local instances
498: l_seg_low fnd_flex_server1.stringarray;
499: l_seg_high fnd_flex_server1.stringarray;
500:
501:
502: l_bind_name VARCHAR2(255);
495: l_quote varchar2(1) := '''';
496:
497: -- we need two local instances
498: l_seg_low fnd_flex_server1.stringarray;
499: l_seg_high fnd_flex_server1.stringarray;
500:
501:
502: l_bind_name VARCHAR2(255);
503:
534: AND fs.display_flag = 'Y';
535:
536: l_delim := fnd_flex_ext.get_delimiter('INV','MSTK',l_flex_num);
537:
538: fnd_flex_server.parse_flex_values(p_item_lo,
539: l_delim,
540: l_no_of_segs,
541: l_seg_low,
542: l_num);
540: l_no_of_segs,
541: l_seg_low,
542: l_num);
543:
544: fnd_flex_server.parse_flex_values(p_item_hi,
545: l_delim,
546: l_no_of_segs,
547: l_seg_high,
548: l_num);