APPS.FLM_UTIL dependencies on FND_FLEX_EXT

Line 386: -- fnd_flex_ext.SegmentArray is a table of type varchar2(150)

382: l_quote varchar2(1) := '''';
383:
384: l_bind_name VARCHAR2(256);
385:
386: -- fnd_flex_ext.SegmentArray is a table of type varchar2(150)
387: -- we need two local instances
388: l_seg_low fnd_flex_ext.SegmentArray;
389: l_seg_high fnd_flex_ext.SegmentArray;
390:

Line 388: l_seg_low fnd_flex_ext.SegmentArray;

384: l_bind_name VARCHAR2(256);
385:
386: -- fnd_flex_ext.SegmentArray is a table of type varchar2(150)
387: -- we need two local instances
388: l_seg_low fnd_flex_ext.SegmentArray;
389: l_seg_high fnd_flex_ext.SegmentArray;
390:
391: -- cursor to get all the application column names for this flexfield
392: CURSOR cur_columns (l_struct_num Number) IS

Line 389: l_seg_high fnd_flex_ext.SegmentArray;

385:
386: -- fnd_flex_ext.SegmentArray is a table of type varchar2(150)
387: -- we need two local instances
388: l_seg_low fnd_flex_ext.SegmentArray;
389: l_seg_high fnd_flex_ext.SegmentArray;
390:
391: -- cursor to get all the application column names for this flexfield
392: CURSOR cur_columns (l_struct_num Number) IS
393: SELECT fs.application_column_name,

Line 413: l_delim := fnd_flex_ext.get_delimiter('INV','MCAT',l_flex_num);

409: INTO l_flex_num
410: FROM fnd_id_flex_structures fs
411: WHERE fs.id_flex_code = 'MCAT'
412: AND fs.id_flex_num = p_cat_struct_id;
413: l_delim := fnd_flex_ext.get_delimiter('INV','MCAT',l_flex_num);
414: l_num := fnd_flex_ext.breakup_segments( p_cat_lo, l_delim, l_seg_low);
415: l_num := fnd_flex_ext.breakup_segments( p_cat_hi, l_delim, l_seg_high);
416:
417: -- go ahead and build the where clause

Line 414: l_num := fnd_flex_ext.breakup_segments( p_cat_lo, l_delim, l_seg_low);

410: FROM fnd_id_flex_structures fs
411: WHERE fs.id_flex_code = 'MCAT'
412: AND fs.id_flex_num = p_cat_struct_id;
413: l_delim := fnd_flex_ext.get_delimiter('INV','MCAT',l_flex_num);
414: l_num := fnd_flex_ext.breakup_segments( p_cat_lo, l_delim, l_seg_low);
415: l_num := fnd_flex_ext.breakup_segments( p_cat_hi, l_delim, l_seg_high);
416:
417: -- go ahead and build the where clause
418:

Line 415: l_num := fnd_flex_ext.breakup_segments( p_cat_hi, l_delim, l_seg_high);

411: WHERE fs.id_flex_code = 'MCAT'
412: AND fs.id_flex_num = p_cat_struct_id;
413: l_delim := fnd_flex_ext.get_delimiter('INV','MCAT',l_flex_num);
414: l_num := fnd_flex_ext.breakup_segments( p_cat_lo, l_delim, l_seg_low);
415: l_num := fnd_flex_ext.breakup_segments( p_cat_hi, l_delim, l_seg_high);
416:
417: -- go ahead and build the where clause
418:
419: FOR curtemp IN cur_columns(l_flex_num) LOOP

Line 535: l_delim := fnd_flex_ext.get_delimiter('INV','MSTK',l_flex_num);

531: AND fs.id_flex_num = l_flex_num
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,