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_EXTRACT_PKG dependencies on FND_MO_REPORTING_API

Line 788: FND_MO_REPORTING_API.INITIALIZE (

784: -- Hardcode the Low and High Transaction dates if they are null.
785: IF G_REPORTING_LEVEL IS NOT NULL THEN
786: L_REPORTING_CONTEXT_VAL := ' '||TO_CHAR(G_REPORTING_CONTEXT)||' ';
787:
788: FND_MO_REPORTING_API.INITIALIZE (
789: p_reporting_level =>G_REPORTING_LEVEL,
790: p_reporting_entity_id => G_REPORTING_CONTEXT,
791: p_pred_type =>'AUTO');
792:

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

792:
793:
794: IF (g_level_procedure >= g_current_runtime_level ) THEN
795: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
796: 'After FND_MO_REPORTING_API.INITIALIZE Call : ');
797: END IF;
798:
799: -- Check with Kripa --skorrapa
800:

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

798:
799: -- Check with Kripa --skorrapa
800:
801:
802: l_fnd_mo_org_stg := FND_MO_REPORTING_API.GET_PREDICATE('ZX_DET',NULL,L_REPORTING_CONTEXT_VAL);
803: IF (g_level_procedure >= g_current_runtime_level ) THEN
804: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
805: 'After FND_MO_REPORTING_API.GET_PREDICATE Call = '||l_fnd_mo_org_stg);
806: END IF;

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

801:
802: l_fnd_mo_org_stg := FND_MO_REPORTING_API.GET_PREDICATE('ZX_DET',NULL,L_REPORTING_CONTEXT_VAL);
803: IF (g_level_procedure >= g_current_runtime_level ) THEN
804: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
805: 'After FND_MO_REPORTING_API.GET_PREDICATE Call = '||l_fnd_mo_org_stg);
806: END IF;
807:
808: l_internal_org_stg:= REPLACE(l_fnd_mo_org_stg,'ORG_ID','INTERNAL_ORGANIZATION_ID');
809:

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

815:
816: IF G_REPORTING_LEVEL IN ('1000','3000') THEN
817: L_WHERE_REPORTING_CONTEXT_TRXH := l_internal_org_stg;
818: L_WHERE_REPORTING_CONTEXT_VAT :=
819: FND_MO_REPORTING_API.GET_PREDICATE('VAT',NULL,L_REPORTING_CONTEXT_VAL);
820: L_WHERE_REPORTING_CONTEXT_EX :=
821: FND_MO_REPORTING_API.GET_PREDICATE('EX',NULL,L_REPORTING_CONTEXT_VAL);
822: L_WHERE_REPORTING_CONTEXT_TYP :=
823: FND_MO_REPORTING_API.GET_PREDICATE('TYPES',NULL,L_REPORTING_CONTEXT_VAL);

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

817: L_WHERE_REPORTING_CONTEXT_TRXH := l_internal_org_stg;
818: L_WHERE_REPORTING_CONTEXT_VAT :=
819: FND_MO_REPORTING_API.GET_PREDICATE('VAT',NULL,L_REPORTING_CONTEXT_VAL);
820: L_WHERE_REPORTING_CONTEXT_EX :=
821: FND_MO_REPORTING_API.GET_PREDICATE('EX',NULL,L_REPORTING_CONTEXT_VAL);
822: L_WHERE_REPORTING_CONTEXT_TYP :=
823: FND_MO_REPORTING_API.GET_PREDICATE('TYPES',NULL,L_REPORTING_CONTEXT_VAL);
824: L_WHERE_REPORTING_CONTEXT_BS :=
825: FND_MO_REPORTING_API.GET_PREDICATE('BS',NULL,L_REPORTING_CONTEXT_VAL);

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

819: FND_MO_REPORTING_API.GET_PREDICATE('VAT',NULL,L_REPORTING_CONTEXT_VAL);
820: L_WHERE_REPORTING_CONTEXT_EX :=
821: FND_MO_REPORTING_API.GET_PREDICATE('EX',NULL,L_REPORTING_CONTEXT_VAL);
822: L_WHERE_REPORTING_CONTEXT_TYP :=
823: FND_MO_REPORTING_API.GET_PREDICATE('TYPES',NULL,L_REPORTING_CONTEXT_VAL);
824: L_WHERE_REPORTING_CONTEXT_BS :=
825: FND_MO_REPORTING_API.GET_PREDICATE('BS',NULL,L_REPORTING_CONTEXT_VAL);
826: L_WHERE_REPORTING_CONTEXT_ADJ :=
827: FND_MO_REPORTING_API.GET_PREDICATE('ADJ',NULL,L_REPORTING_CONTEXT_VAL);

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

821: FND_MO_REPORTING_API.GET_PREDICATE('EX',NULL,L_REPORTING_CONTEXT_VAL);
822: L_WHERE_REPORTING_CONTEXT_TYP :=
823: FND_MO_REPORTING_API.GET_PREDICATE('TYPES',NULL,L_REPORTING_CONTEXT_VAL);
824: L_WHERE_REPORTING_CONTEXT_BS :=
825: FND_MO_REPORTING_API.GET_PREDICATE('BS',NULL,L_REPORTING_CONTEXT_VAL);
826: L_WHERE_REPORTING_CONTEXT_ADJ :=
827: FND_MO_REPORTING_API.GET_PREDICATE('ADJ',NULL,L_REPORTING_CONTEXT_VAL);
828: L_WHERE_REPORTING_CONTEXT_CS :=
829: FND_MO_REPORTING_API.GET_PREDICATE('ARCS',NULL,L_REPORTING_CONTEXT_VAL);

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

823: FND_MO_REPORTING_API.GET_PREDICATE('TYPES',NULL,L_REPORTING_CONTEXT_VAL);
824: L_WHERE_REPORTING_CONTEXT_BS :=
825: FND_MO_REPORTING_API.GET_PREDICATE('BS',NULL,L_REPORTING_CONTEXT_VAL);
826: L_WHERE_REPORTING_CONTEXT_ADJ :=
827: FND_MO_REPORTING_API.GET_PREDICATE('ADJ',NULL,L_REPORTING_CONTEXT_VAL);
828: L_WHERE_REPORTING_CONTEXT_CS :=
829: FND_MO_REPORTING_API.GET_PREDICATE('ARCS',NULL,L_REPORTING_CONTEXT_VAL);
830: L_WHERE_REPORTING_CONTEXT_TH :=
831: FND_MO_REPORTING_API.GET_PREDICATE('TH',NULL,L_REPORTING_CONTEXT_VAL);

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

825: FND_MO_REPORTING_API.GET_PREDICATE('BS',NULL,L_REPORTING_CONTEXT_VAL);
826: L_WHERE_REPORTING_CONTEXT_ADJ :=
827: FND_MO_REPORTING_API.GET_PREDICATE('ADJ',NULL,L_REPORTING_CONTEXT_VAL);
828: L_WHERE_REPORTING_CONTEXT_CS :=
829: FND_MO_REPORTING_API.GET_PREDICATE('ARCS',NULL,L_REPORTING_CONTEXT_VAL);
830: L_WHERE_REPORTING_CONTEXT_TH :=
831: FND_MO_REPORTING_API.GET_PREDICATE('TH',NULL,L_REPORTING_CONTEXT_VAL);
832: ELSE
833: L_WHERE_REPORTING_CONTEXT_TRXH := ' AND NULL IS NULL';

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

827: FND_MO_REPORTING_API.GET_PREDICATE('ADJ',NULL,L_REPORTING_CONTEXT_VAL);
828: L_WHERE_REPORTING_CONTEXT_CS :=
829: FND_MO_REPORTING_API.GET_PREDICATE('ARCS',NULL,L_REPORTING_CONTEXT_VAL);
830: L_WHERE_REPORTING_CONTEXT_TH :=
831: FND_MO_REPORTING_API.GET_PREDICATE('TH',NULL,L_REPORTING_CONTEXT_VAL);
832: ELSE
833: L_WHERE_REPORTING_CONTEXT_TRXH := ' AND NULL IS NULL';
834: L_WHERE_REPORTING_CONTEXT_VAT :=' AND NULL IS NULL';
835: L_WHERE_REPORTING_CONTEXT_EX :=' AND NULL IS NULL';