eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZX_AR_ACTG_EXTRACT_PKG dependencies on FND_MO_REPORTING_API

Line 807: FND_MO_REPORTING_API.INITIALIZE (

803: -- Hardcode the Low and High Transaction dates if they are null.
804: IF G_REPORTING_LEVEL IS NOT NULL THEN
805: L_REPORTING_CONTEXT_VAL := ' '||TO_CHAR(G_REPORTING_CONTEXT)||' ';
806:
807: FND_MO_REPORTING_API.INITIALIZE (
808: p_reporting_level =>G_REPORTING_LEVEL,
809: p_reporting_entity_id => G_REPORTING_CONTEXT,
810: p_pred_type =>'AUTO');
811:

Line 815: 'After FND_MO_REPORTING_API.INITIALIZE Call : ');

811:
812:
813: IF (g_level_procedure >= g_current_runtime_level ) THEN
814: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.BUILD_SQL',
815: 'After FND_MO_REPORTING_API.INITIALIZE Call : ');
816: END IF;
817:
818: -- Check with Kripa --skorrapa
819:

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

817:
818: -- Check with Kripa --skorrapa
819:
820:
821: l_fnd_mo_org_stg := FND_MO_REPORTING_API.GET_PREDICATE('ZX_DET',NULL,L_REPORTING_CONTEXT_VAL);
822: IF (g_level_procedure >= g_current_runtime_level ) THEN
823: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.BUILD_SQL',
824: 'After FND_MO_REPORTING_API.GET_PREDICATE Call = '||l_fnd_mo_org_stg);
825: END IF;

Line 824: 'After FND_MO_REPORTING_API.GET_PREDICATE Call = '||l_fnd_mo_org_stg);

820:
821: l_fnd_mo_org_stg := FND_MO_REPORTING_API.GET_PREDICATE('ZX_DET',NULL,L_REPORTING_CONTEXT_VAL);
822: IF (g_level_procedure >= g_current_runtime_level ) THEN
823: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.BUILD_SQL',
824: 'After FND_MO_REPORTING_API.GET_PREDICATE Call = '||l_fnd_mo_org_stg);
825: END IF;
826:
827: l_internal_org_stg:= REPLACE(l_fnd_mo_org_stg,'ORG_ID','INTERNAL_ORGANIZATION_ID');
828:

Line 837: -- FND_MO_REPORTING_API.GET_PREDICATE('ZX_DET',NULL,L_REPORTING_CONTEXT_VAL);

833:
834:
835: -- L_WHERE_REPORTING_CONTEXT_TRXH := 'AND ZX_DET.INTERNAL_ORGANIZATION_ID '||l_get_org_id;
836: L_WHERE_REPORTING_CONTEXT_TRXH := l_internal_org_stg;
837: -- FND_MO_REPORTING_API.GET_PREDICATE('ZX_DET',NULL,L_REPORTING_CONTEXT_VAL);
838: L_WHERE_REPORTING_CONTEXT_VAT :=
839: FND_MO_REPORTING_API.GET_PREDICATE('VAT',NULL,L_REPORTING_CONTEXT_VAL);
840: L_WHERE_REPORTING_CONTEXT_EX :=
841: FND_MO_REPORTING_API.GET_PREDICATE('EX',NULL,L_REPORTING_CONTEXT_VAL);

Line 839: FND_MO_REPORTING_API.GET_PREDICATE('VAT',NULL,L_REPORTING_CONTEXT_VAL);

835: -- L_WHERE_REPORTING_CONTEXT_TRXH := 'AND ZX_DET.INTERNAL_ORGANIZATION_ID '||l_get_org_id;
836: L_WHERE_REPORTING_CONTEXT_TRXH := l_internal_org_stg;
837: -- FND_MO_REPORTING_API.GET_PREDICATE('ZX_DET',NULL,L_REPORTING_CONTEXT_VAL);
838: L_WHERE_REPORTING_CONTEXT_VAT :=
839: FND_MO_REPORTING_API.GET_PREDICATE('VAT',NULL,L_REPORTING_CONTEXT_VAL);
840: L_WHERE_REPORTING_CONTEXT_EX :=
841: FND_MO_REPORTING_API.GET_PREDICATE('EX',NULL,L_REPORTING_CONTEXT_VAL);
842: L_WHERE_REPORTING_CONTEXT_TYP :=
843: FND_MO_REPORTING_API.GET_PREDICATE('TYPES',NULL,L_REPORTING_CONTEXT_VAL);

Line 841: FND_MO_REPORTING_API.GET_PREDICATE('EX',NULL,L_REPORTING_CONTEXT_VAL);

837: -- FND_MO_REPORTING_API.GET_PREDICATE('ZX_DET',NULL,L_REPORTING_CONTEXT_VAL);
838: L_WHERE_REPORTING_CONTEXT_VAT :=
839: FND_MO_REPORTING_API.GET_PREDICATE('VAT',NULL,L_REPORTING_CONTEXT_VAL);
840: L_WHERE_REPORTING_CONTEXT_EX :=
841: FND_MO_REPORTING_API.GET_PREDICATE('EX',NULL,L_REPORTING_CONTEXT_VAL);
842: L_WHERE_REPORTING_CONTEXT_TYP :=
843: FND_MO_REPORTING_API.GET_PREDICATE('TYPES',NULL,L_REPORTING_CONTEXT_VAL);
844: L_WHERE_REPORTING_CONTEXT_BS :=
845: FND_MO_REPORTING_API.GET_PREDICATE('BS',NULL,L_REPORTING_CONTEXT_VAL);

Line 843: FND_MO_REPORTING_API.GET_PREDICATE('TYPES',NULL,L_REPORTING_CONTEXT_VAL);

839: FND_MO_REPORTING_API.GET_PREDICATE('VAT',NULL,L_REPORTING_CONTEXT_VAL);
840: L_WHERE_REPORTING_CONTEXT_EX :=
841: FND_MO_REPORTING_API.GET_PREDICATE('EX',NULL,L_REPORTING_CONTEXT_VAL);
842: L_WHERE_REPORTING_CONTEXT_TYP :=
843: FND_MO_REPORTING_API.GET_PREDICATE('TYPES',NULL,L_REPORTING_CONTEXT_VAL);
844: L_WHERE_REPORTING_CONTEXT_BS :=
845: FND_MO_REPORTING_API.GET_PREDICATE('BS',NULL,L_REPORTING_CONTEXT_VAL);
846: L_WHERE_REPORTING_CONTEXT_ADJ :=
847: FND_MO_REPORTING_API.GET_PREDICATE('ADJ',NULL,L_REPORTING_CONTEXT_VAL);

Line 845: FND_MO_REPORTING_API.GET_PREDICATE('BS',NULL,L_REPORTING_CONTEXT_VAL);

841: FND_MO_REPORTING_API.GET_PREDICATE('EX',NULL,L_REPORTING_CONTEXT_VAL);
842: L_WHERE_REPORTING_CONTEXT_TYP :=
843: FND_MO_REPORTING_API.GET_PREDICATE('TYPES',NULL,L_REPORTING_CONTEXT_VAL);
844: L_WHERE_REPORTING_CONTEXT_BS :=
845: FND_MO_REPORTING_API.GET_PREDICATE('BS',NULL,L_REPORTING_CONTEXT_VAL);
846: L_WHERE_REPORTING_CONTEXT_ADJ :=
847: FND_MO_REPORTING_API.GET_PREDICATE('ADJ',NULL,L_REPORTING_CONTEXT_VAL);
848: L_WHERE_REPORTING_CONTEXT_CS :=
849: FND_MO_REPORTING_API.GET_PREDICATE('ARCS',NULL,L_REPORTING_CONTEXT_VAL);

Line 847: FND_MO_REPORTING_API.GET_PREDICATE('ADJ',NULL,L_REPORTING_CONTEXT_VAL);

843: FND_MO_REPORTING_API.GET_PREDICATE('TYPES',NULL,L_REPORTING_CONTEXT_VAL);
844: L_WHERE_REPORTING_CONTEXT_BS :=
845: FND_MO_REPORTING_API.GET_PREDICATE('BS',NULL,L_REPORTING_CONTEXT_VAL);
846: L_WHERE_REPORTING_CONTEXT_ADJ :=
847: FND_MO_REPORTING_API.GET_PREDICATE('ADJ',NULL,L_REPORTING_CONTEXT_VAL);
848: L_WHERE_REPORTING_CONTEXT_CS :=
849: FND_MO_REPORTING_API.GET_PREDICATE('ARCS',NULL,L_REPORTING_CONTEXT_VAL);
850: L_WHERE_REPORTING_CONTEXT_TH :=
851: FND_MO_REPORTING_API.GET_PREDICATE('TH',NULL,L_REPORTING_CONTEXT_VAL);

Line 849: FND_MO_REPORTING_API.GET_PREDICATE('ARCS',NULL,L_REPORTING_CONTEXT_VAL);

845: FND_MO_REPORTING_API.GET_PREDICATE('BS',NULL,L_REPORTING_CONTEXT_VAL);
846: L_WHERE_REPORTING_CONTEXT_ADJ :=
847: FND_MO_REPORTING_API.GET_PREDICATE('ADJ',NULL,L_REPORTING_CONTEXT_VAL);
848: L_WHERE_REPORTING_CONTEXT_CS :=
849: FND_MO_REPORTING_API.GET_PREDICATE('ARCS',NULL,L_REPORTING_CONTEXT_VAL);
850: L_WHERE_REPORTING_CONTEXT_TH :=
851: FND_MO_REPORTING_API.GET_PREDICATE('TH',NULL,L_REPORTING_CONTEXT_VAL);
852: END IF;
853:

Line 851: FND_MO_REPORTING_API.GET_PREDICATE('TH',NULL,L_REPORTING_CONTEXT_VAL);

847: FND_MO_REPORTING_API.GET_PREDICATE('ADJ',NULL,L_REPORTING_CONTEXT_VAL);
848: L_WHERE_REPORTING_CONTEXT_CS :=
849: FND_MO_REPORTING_API.GET_PREDICATE('ARCS',NULL,L_REPORTING_CONTEXT_VAL);
850: L_WHERE_REPORTING_CONTEXT_TH :=
851: FND_MO_REPORTING_API.GET_PREDICATE('TH',NULL,L_REPORTING_CONTEXT_VAL);
852: END IF;
853:
854: IF (g_level_procedure >= g_current_runtime_level ) THEN
855: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.BUILD_SQL',