DBA Data[Home] [Help]

APPS.ZX_AP_EXTRACT_PKG dependencies on FND_MO_REPORTING_API

Line 581: FND_MO_REPORTING_API.INITIALIZE(G_REPORTING_LEVEL,G_REPORTING_CONTEXT,'AUTO');

577: -- ==============================================================+
578:
579: L_REPORTING_CONTEXT_VAL := ' ' ||TO_CHAR(G_REPORTING_CONTEXT) || ' ' ;
580:
581: FND_MO_REPORTING_API.INITIALIZE(G_REPORTING_LEVEL,G_REPORTING_CONTEXT,'AUTO');
582:
583: l_fnd_mo_org_stg := FND_MO_REPORTING_API.GET_PREDICATE('ZX_DET',NULL,L_REPORTING_CONTEXT_VAL);
584: IF (g_level_procedure >= g_current_runtime_level ) THEN
585: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.BUILD_SQL',

Line 583: l_fnd_mo_org_stg := FND_MO_REPORTING_API.GET_PREDICATE('ZX_DET',NULL,L_REPORTING_CONTEXT_VAL);

579: L_REPORTING_CONTEXT_VAL := ' ' ||TO_CHAR(G_REPORTING_CONTEXT) || ' ' ;
580:
581: FND_MO_REPORTING_API.INITIALIZE(G_REPORTING_LEVEL,G_REPORTING_CONTEXT,'AUTO');
582:
583: l_fnd_mo_org_stg := FND_MO_REPORTING_API.GET_PREDICATE('ZX_DET',NULL,L_REPORTING_CONTEXT_VAL);
584: IF (g_level_procedure >= g_current_runtime_level ) THEN
585: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.BUILD_SQL',
586: 'l_fnd_mo_org_stg = '||l_fnd_mo_org_stg);
587: END IF;

Line 611: L_WHERE_ZXXTATAT_SPECIFIC := FND_MO_REPORTING_API.GET_PREDICATE('AP_DIST', NULL, L_REPORTING_CONTEXT_VAL);

607: END IF;
608:
609: IF G_REPORTING_LEVEL IN ('1000','3000') THEN
610: L_WHERE_REPORT_CONTEXT := l_internal_org_stg;
611: L_WHERE_ZXXTATAT_SPECIFIC := FND_MO_REPORTING_API.GET_PREDICATE('AP_DIST', NULL, L_REPORTING_CONTEXT_VAL);
612: ELSE
613: L_WHERE_REPORT_CONTEXT := 'AND NULL IS NULL';
614: L_WHERE_ZXXTATAT_SPECIFIC := ' AND NULL IS NULL ';
615: END IF;