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:
532: AND fs.enabled_flag = 'Y'
533: AND fs.display_flag = 'Y';
534:
535: l_delim := fnd_flex_ext.get_delimiter('INV','MSTK',l_flex_num);
536: fnd_flex_server.parse_flex_values(p_item_lo,
537: l_delim,
538: l_no_of_segs,
539: l_seg_low,
540: l_num);
538: l_no_of_segs,
539: l_seg_low,
540: l_num);
541:
542: fnd_flex_server.parse_flex_values(p_item_hi,
543: l_delim,
544: l_no_of_segs,
545: l_seg_high,
546: l_num);