APPS.ZX_GL_EXTRACT_PKG dependencies on GL_MC_INFO

Line 461: l_bsv_list gl_mc_info.le_bsv_tbl_type;

457: L_WHERE_TAX_INVOICE_DATE varchar2(500);
458: L_WHERE_GL_FLEX_LE VARCHAR2(2000);
459: l_bal_value boolean;
460: l_bsv_flag varchar2(1);
461: l_bsv_list gl_mc_info.le_bsv_tbl_type;
462: l_bsv_in varchar2(300);
463: l_bsv varchar2(100);
464: l_count number;
465: BEGIN

Line 693: 'L_WHERE_GL_FLEX : Call to gl_mc_info.get_bal_seg_values');

689: IF (g_level_procedure >= g_current_runtime_level ) THEN
690: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_GL_EXTRACT_PKG.BUILD_SQL',
691: 'L_WHERE_GL_FLEX = '||L_WHERE_GL_FLEX);
692: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_GL_EXTRACT_PKG.BUILD_SQL',
693: 'L_WHERE_GL_FLEX : Call to gl_mc_info.get_bal_seg_values');
694: END IF;
695:
696: -- For Legal Entity Level build predicate for blancing segments criteria
697:

Line 699: l_bsv_list := gl_mc_info.le_bsv_tbl_type();

695:
696: -- For Legal Entity Level build predicate for blancing segments criteria
697:
698: IF g_legal_entity_id IS NOT NULL THEN
699: l_bsv_list := gl_mc_info.le_bsv_tbl_type();
700: l_bal_value :=gl_mc_info.get_bal_seg_values(NULL,g_legal_entity_id,NULL,l_bsv_flag, l_bsv_list);
701: l_count := l_bsv_list.count;
702:
703: IF (g_level_procedure >= g_current_runtime_level ) THEN

Line 700: l_bal_value :=gl_mc_info.get_bal_seg_values(NULL,g_legal_entity_id,NULL,l_bsv_flag, l_bsv_list);

696: -- For Legal Entity Level build predicate for blancing segments criteria
697:
698: IF g_legal_entity_id IS NOT NULL THEN
699: l_bsv_list := gl_mc_info.le_bsv_tbl_type();
700: l_bal_value :=gl_mc_info.get_bal_seg_values(NULL,g_legal_entity_id,NULL,l_bsv_flag, l_bsv_list);
701: l_count := l_bsv_list.count;
702:
703: IF (g_level_procedure >= g_current_runtime_level ) THEN
704: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_GL_EXTRACT_PKG.BUILD_SQL',

Line 705: 'L_WHERE_GL_FLEX : After Call to gl_mc_info.get_bal_seg_values'||to_char(l_count)||l_bsv_flag);

701: l_count := l_bsv_list.count;
702:
703: IF (g_level_procedure >= g_current_runtime_level ) THEN
704: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_GL_EXTRACT_PKG.BUILD_SQL',
705: 'L_WHERE_GL_FLEX : After Call to gl_mc_info.get_bal_seg_values'||to_char(l_count)||l_bsv_flag);
706: END IF;
707:
708: IF l_count > 0 THEN
709: L_WHERE_GL_FLEX_LE := substr(L_WHERE_GL_FLEX,1,18);

Line 730: 'L_WHERE_GL_FLEX : After Call to gl_mc_info.get_bal_seg_values');

726:
727: L_WHERE_GL_FLEX := L_WHERE_GL_FLEX||' )';
728: IF (g_level_procedure >= g_current_runtime_level ) THEN
729: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_GL_EXTRACT_PKG.BUILD_SQL',
730: 'L_WHERE_GL_FLEX : After Call to gl_mc_info.get_bal_seg_values');
731: END IF;
732:
733: IF l_bal_value then
734: IF (g_level_procedure >= g_current_runtime_level ) THEN