APPS.ZX_GL_EXTRACT_PKG dependencies on GL_MC_INFO

Line 470: l_bsv_list gl_mc_info.le_bsv_tbl_type;

466: L_WHERE_TAX_INVOICE_DATE varchar2(500);
467: --L_WHERE_GL_FLEX_LE VARCHAR2(2000);
468: l_bal_value boolean;
469: l_bsv_flag varchar2(1);
470: l_bsv_list gl_mc_info.le_bsv_tbl_type;
471: l_bsv_in varchar2(300);
472: l_bsv varchar2(100);
473: l_count number;
474: BEGIN

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

700: IF (g_level_procedure >= g_current_runtime_level ) THEN
701: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_GL_EXTRACT_PKG.BUILD_SQL',
702: 'L_WHERE_GL_FLEX = '||L_WHERE_GL_FLEX);
703: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_GL_EXTRACT_PKG.BUILD_SQL',
704: 'L_WHERE_GL_FLEX : Call to gl_mc_info.get_bal_seg_values');
705: END IF;
706:
707: -- For Legal Entity Level build predicate for blancing segments criteria
708:

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

706:
707: -- For Legal Entity Level build predicate for blancing segments criteria
708:
709: IF g_legal_entity_id IS NOT NULL THEN
710: l_bsv_list := gl_mc_info.le_bsv_tbl_type();
711: l_bal_value :=gl_mc_info.get_bal_seg_values(NULL,g_legal_entity_id,NULL,l_bsv_flag, l_bsv_list);
712: l_count := l_bsv_list.count;
713:
714: IF (g_level_procedure >= g_current_runtime_level ) THEN

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

707: -- For Legal Entity Level build predicate for blancing segments criteria
708:
709: IF g_legal_entity_id IS NOT NULL THEN
710: l_bsv_list := gl_mc_info.le_bsv_tbl_type();
711: l_bal_value :=gl_mc_info.get_bal_seg_values(NULL,g_legal_entity_id,NULL,l_bsv_flag, l_bsv_list);
712: l_count := l_bsv_list.count;
713:
714: IF (g_level_procedure >= g_current_runtime_level ) THEN
715: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_GL_EXTRACT_PKG.BUILD_SQL',

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

712: l_count := l_bsv_list.count;
713:
714: IF (g_level_procedure >= g_current_runtime_level ) THEN
715: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_GL_EXTRACT_PKG.BUILD_SQL',
716: 'L_WHERE_GL_FLEX : After Call to gl_mc_info.get_bal_seg_values'||to_char(l_count)||l_bsv_flag);
717: END IF;
718:
719: IF l_count > 0 THEN
720: L_WHERE_GL_FLEX_LE := substr(L_WHERE_GL_FLEX,1,18);

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

737:
738: L_WHERE_GL_FLEX := L_WHERE_GL_FLEX||' )';
739: IF (g_level_procedure >= g_current_runtime_level ) THEN
740: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_GL_EXTRACT_PKG.BUILD_SQL',
741: 'L_WHERE_GL_FLEX : After Call to gl_mc_info.get_bal_seg_values');
742: END IF;
743:
744: IF l_bal_value then
745: IF (g_level_procedure >= g_current_runtime_level ) THEN