[Home] [Help]
278: OPEN cur_rebuild_30seg_acct(l_to_segments_ccid, l_segment_delimiter);
279: FETCH cur_rebuild_30seg_acct INTO x_to_segments_new;
280: CLOSE cur_rebuild_30seg_acct;
281:
282: gmf_util.trace( ' From/To after rebld: ('||to_char(l_start_segments_ccid)||' / '||to_char(l_to_segments_ccid)
283: ||') '||x_start_segments_new||' / '||x_to_segments_new
284: ,3 ,C_LOG_FILE);
285:
286: /***************************** Bug#12600219(END) ****************************/
299: AND gp.period_num = in_period_num
300: and gp.PERIOD_SET_NAME= gl.PERIOD_SET_NAME
301: and gl.ledger_id = in_set_of_books ;
302:
303: gmf_util.trace( ' Periord name = '||l_period_name ,3 ,C_LOG_FILE);
304: OPEN cur_gl_get_balances (
305: in_set_of_books
306: -- , in_chart_of_accounts -- We don't need anymore as we are spliting the query
307: , in_period_year
424: OPEN cur_rebuild_30seg_acct(l_to_segments_ccid, l_segment_delimiter);
425: FETCH cur_rebuild_30seg_acct INTO x_to_segments_new;
426: CLOSE cur_rebuild_30seg_acct;
427:
428: gmf_util.trace( ' From/To after rebld: ('||to_char(l_start_segments_ccid)||' / '||to_char(l_to_segments_ccid)
429: ||') '||x_start_segments_new||' / '||x_to_segments_new ,3 ,C_LOG_FILE);
430: /***************************** Bug#12600219(END) ****************************/
431:
432: /*Bug#12600219 - Replaced this call with following
443: AND gp.period_num = in_period_num
444: AND gp.PERIOD_SET_NAME= gl.PERIOD_SET_NAME
445: AND gl.ledger_id = in_set_of_books ;
446:
447: gmf_util.trace( ' Periord name = '||l_period_name ,3 ,C_LOG_FILE);
448:
449: /* Create Dynamic Sql for Getting Balances bug 14178149 */
450: l_sql_stmt := 'SELECT '||
451: in_set_of_books ||','||
541: IF( cur_gl_get_balances%NOTFOUND )
542: THEN
543: error_status := 100;
544: /*B12600219 - Added Debug message */
545: gmf_util.trace( ' proc_gl_get_balances(): error_status = '||error_status||' [From/To acct:'||start_segments||' / '||to_segments || ']'
546: ,3 ,C_LOG_FILE);
547: /*B12600219 - Added Debug message */
548: END IF;
549: