255:
256: /***************************** Bug#12600219(START) ****************************
257: /* Rebuild 30 Segmented account using CCIds of From/To accounts */
258: /* (i)Identify the CCIds of From/To accounts *
259: l_start_segments_ccid := fnd_flex_ext.get_ccid(application_short_name => 'SQLGL',
260: key_flex_code => 'GL#',
261: structure_number => l_chart_of_accounts_id,
262: validation_date => to_char(SYSDATE,FND_FLEX_EXT.DATE_FORMAT),
263: concatenated_segments => start_segments
258: /* (i)Identify the CCIds of From/To accounts *
259: l_start_segments_ccid := fnd_flex_ext.get_ccid(application_short_name => 'SQLGL',
260: key_flex_code => 'GL#',
261: structure_number => l_chart_of_accounts_id,
262: validation_date => to_char(SYSDATE,FND_FLEX_EXT.DATE_FORMAT),
263: concatenated_segments => start_segments
264: );
265:
266: l_to_segments_ccid := fnd_flex_ext.get_ccid(application_short_name => 'SQLGL',
262: validation_date => to_char(SYSDATE,FND_FLEX_EXT.DATE_FORMAT),
263: concatenated_segments => start_segments
264: );
265:
266: l_to_segments_ccid := fnd_flex_ext.get_ccid(application_short_name => 'SQLGL',
267: key_flex_code => 'GL#',
268: structure_number => l_chart_of_accounts_id,
269: validation_date => to_char(SYSDATE,FND_FLEX_EXT.DATE_FORMAT),
270: concatenated_segments => to_segments
265:
266: l_to_segments_ccid := fnd_flex_ext.get_ccid(application_short_name => 'SQLGL',
267: key_flex_code => 'GL#',
268: structure_number => l_chart_of_accounts_id,
269: validation_date => to_char(SYSDATE,FND_FLEX_EXT.DATE_FORMAT),
270: concatenated_segments => to_segments
271: );
272:
273: /* (ii)Rebuild 30 segmented From/To accounts *
401:
402: /***************************** Bug#12600219(START) ****************************/
403: /* Rebuild 30 Segmented account using CCIds of From/To accounts */
404: /* (i)Identify the CCIds of From/To accounts */
405: l_start_segments_ccid := fnd_flex_ext.get_ccid(application_short_name => 'SQLGL',
406: key_flex_code => 'GL#',
407: structure_number => l_chart_of_accounts_id,
408: validation_date => to_char(SYSDATE,FND_FLEX_EXT.DATE_FORMAT),
409: concatenated_segments => start_segments
404: /* (i)Identify the CCIds of From/To accounts */
405: l_start_segments_ccid := fnd_flex_ext.get_ccid(application_short_name => 'SQLGL',
406: key_flex_code => 'GL#',
407: structure_number => l_chart_of_accounts_id,
408: validation_date => to_char(SYSDATE,FND_FLEX_EXT.DATE_FORMAT),
409: concatenated_segments => start_segments
410: );
411:
412: l_to_segments_ccid := fnd_flex_ext.get_ccid(application_short_name => 'SQLGL',
408: validation_date => to_char(SYSDATE,FND_FLEX_EXT.DATE_FORMAT),
409: concatenated_segments => start_segments
410: );
411:
412: l_to_segments_ccid := fnd_flex_ext.get_ccid(application_short_name => 'SQLGL',
413: key_flex_code => 'GL#',
414: structure_number => l_chart_of_accounts_id,
415: validation_date => to_char(SYSDATE,FND_FLEX_EXT.DATE_FORMAT),
416: concatenated_segments => to_segments
411:
412: l_to_segments_ccid := fnd_flex_ext.get_ccid(application_short_name => 'SQLGL',
413: key_flex_code => 'GL#',
414: structure_number => l_chart_of_accounts_id,
415: validation_date => to_char(SYSDATE,FND_FLEX_EXT.DATE_FORMAT),
416: concatenated_segments => to_segments
417: );
418:
419: /* (ii)Rebuild 30 segmented From/To accounts */