44: vg_amount VARCHAR2(1000);
45:
46: -- PL/SQL Tables to hold the low and high values,
47: -- used in Get_Application_Col_Names proc
48: vt_seg_low Fnd_Flex_Ext.segmentarray;
49: vt_seg_high Fnd_Flex_Ext.segmentarray;
50: -- PL/SQL Table to hold the flexfield column names
51: TYPE seg_name IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;
52: vt_seg_name seg_name;
45:
46: -- PL/SQL Tables to hold the low and high values,
47: -- used in Get_Application_Col_Names proc
48: vt_seg_low Fnd_Flex_Ext.segmentarray;
49: vt_seg_high Fnd_Flex_Ext.segmentarray;
50: -- PL/SQL Table to hold the flexfield column names
51: TYPE seg_name IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;
52: vt_seg_name seg_name;
53: -- Variables needed for the Breakup_Segments API,
215: END IF;
216:
217: IF (vp_retcode = 0) THEN
218: -- Get the Delimiter
219: vg_delimiter := Fnd_Flex_Ext.get_delimiter
220: (
221: 'SQLGL',
222: vg_id_flex_code,
223: vp_coa_id
326: -- Get low segment values
327: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
328: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,' CALLING POPULATE LOW SEGMETNS ' ) ;
329: END IF;
330: vg_nsegs_low := Fnd_Flex_Ext.breakup_segments
331: (vp_flex_low,
332: vg_delimiter,
333: vt_seg_low );
334: -- Get high segment values
334: -- Get high segment values
335: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
336: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,' CALLING POPULATE HIGH SEGMETNS ' ) ;
337: END IF;
338: vg_nsegs_high := Fnd_Flex_Ext.breakup_segments
339: (vp_flex_high,
340: vg_delimiter,
341: vt_seg_high );
342: