DBA Data[Home] [Help]

APPS.ARRX_RC dependencies on XLA_MO_REPORTING_API

Line 633: XLA_MO_REPORTING_API.Initialize(var.p_reporting_level, var.p_reporting_entity_id, 'AUTO');

629: fa_rx_util_pkg.debug('Chart of Accounts ID : '||var.p_coa_id);
630: fa_rx_util_pkg.debug('Functional Currency : '||var.functional_currency_code);
631: fa_rx_util_pkg.debug('Organization Name : '||var.organization_name);
632:
633: XLA_MO_REPORTING_API.Initialize(var.p_reporting_level, var.p_reporting_entity_id, 'AUTO');
634:
635: L_CR_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CR','push_subq');
636: L_TAX_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('TAX','push_subq');
637: L_ABA_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('ABA','push_subq');

Line 635: L_CR_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CR','push_subq');

631: fa_rx_util_pkg.debug('Organization Name : '||var.organization_name);
632:
633: XLA_MO_REPORTING_API.Initialize(var.p_reporting_level, var.p_reporting_entity_id, 'AUTO');
634:
635: L_CR_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CR','push_subq');
636: L_TAX_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('TAX','push_subq');
637: L_ABA_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('ABA','push_subq');
638: L_CRH_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CRH','push_subq');
639: L_CUST_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CUST','push_subq');

Line 636: L_TAX_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('TAX','push_subq');

632:
633: XLA_MO_REPORTING_API.Initialize(var.p_reporting_level, var.p_reporting_entity_id, 'AUTO');
634:
635: L_CR_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CR','push_subq');
636: L_TAX_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('TAX','push_subq');
637: L_ABA_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('ABA','push_subq');
638: L_CRH_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CRH','push_subq');
639: L_CUST_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CUST','push_subq');
640: L_CRHFIRST_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CRHFIRST','push_subq');

Line 637: L_ABA_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('ABA','push_subq');

633: XLA_MO_REPORTING_API.Initialize(var.p_reporting_level, var.p_reporting_entity_id, 'AUTO');
634:
635: L_CR_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CR','push_subq');
636: L_TAX_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('TAX','push_subq');
637: L_ABA_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('ABA','push_subq');
638: L_CRH_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CRH','push_subq');
639: L_CUST_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CUST','push_subq');
640: L_CRHFIRST_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CRHFIRST','push_subq');
641: L_BATCHFIRST_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('BATCHFIRST','push_subq');

Line 638: L_CRH_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CRH','push_subq');

634:
635: L_CR_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CR','push_subq');
636: L_TAX_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('TAX','push_subq');
637: L_ABA_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('ABA','push_subq');
638: L_CRH_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CRH','push_subq');
639: L_CUST_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CUST','push_subq');
640: L_CRHFIRST_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CRHFIRST','push_subq');
641: L_BATCHFIRST_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('BATCHFIRST','push_subq');
642: L_BATCH_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('BATCH','push_subq');

Line 639: L_CUST_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CUST','push_subq');

635: L_CR_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CR','push_subq');
636: L_TAX_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('TAX','push_subq');
637: L_ABA_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('ABA','push_subq');
638: L_CRH_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CRH','push_subq');
639: L_CUST_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CUST','push_subq');
640: L_CRHFIRST_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CRHFIRST','push_subq');
641: L_BATCHFIRST_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('BATCHFIRST','push_subq');
642: L_BATCH_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('BATCH','push_subq');
643: L_RA_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('RA','push_subq');

Line 640: L_CRHFIRST_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CRHFIRST','push_subq');

636: L_TAX_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('TAX','push_subq');
637: L_ABA_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('ABA','push_subq');
638: L_CRH_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CRH','push_subq');
639: L_CUST_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CUST','push_subq');
640: L_CRHFIRST_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CRHFIRST','push_subq');
641: L_BATCHFIRST_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('BATCHFIRST','push_subq');
642: L_BATCH_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('BATCH','push_subq');
643: L_RA_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('RA','push_subq');
644: L_MISC_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('MISC','push_subq');

Line 641: L_BATCHFIRST_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('BATCHFIRST','push_subq');

637: L_ABA_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('ABA','push_subq');
638: L_CRH_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CRH','push_subq');
639: L_CUST_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CUST','push_subq');
640: L_CRHFIRST_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CRHFIRST','push_subq');
641: L_BATCHFIRST_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('BATCHFIRST','push_subq');
642: L_BATCH_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('BATCH','push_subq');
643: L_RA_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('RA','push_subq');
644: L_MISC_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('MISC','push_subq');
645: L_INCRH_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('INCRH','push_subq');

Line 642: L_BATCH_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('BATCH','push_subq');

638: L_CRH_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CRH','push_subq');
639: L_CUST_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CUST','push_subq');
640: L_CRHFIRST_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CRHFIRST','push_subq');
641: L_BATCHFIRST_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('BATCHFIRST','push_subq');
642: L_BATCH_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('BATCH','push_subq');
643: L_RA_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('RA','push_subq');
644: L_MISC_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('MISC','push_subq');
645: L_INCRH_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('INCRH','push_subq');
646: L_CRHNEW_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CRHNEW','push_subq');

Line 643: L_RA_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('RA','push_subq');

639: L_CUST_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CUST','push_subq');
640: L_CRHFIRST_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CRHFIRST','push_subq');
641: L_BATCHFIRST_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('BATCHFIRST','push_subq');
642: L_BATCH_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('BATCH','push_subq');
643: L_RA_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('RA','push_subq');
644: L_MISC_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('MISC','push_subq');
645: L_INCRH_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('INCRH','push_subq');
646: L_CRHNEW_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CRHNEW','push_subq');
647:

Line 644: L_MISC_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('MISC','push_subq');

640: L_CRHFIRST_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CRHFIRST','push_subq');
641: L_BATCHFIRST_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('BATCHFIRST','push_subq');
642: L_BATCH_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('BATCH','push_subq');
643: L_RA_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('RA','push_subq');
644: L_MISC_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('MISC','push_subq');
645: L_INCRH_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('INCRH','push_subq');
646: L_CRHNEW_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CRHNEW','push_subq');
647:
648: L_CI_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CI','push_subq');

Line 645: L_INCRH_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('INCRH','push_subq');

641: L_BATCHFIRST_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('BATCHFIRST','push_subq');
642: L_BATCH_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('BATCH','push_subq');
643: L_RA_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('RA','push_subq');
644: L_MISC_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('MISC','push_subq');
645: L_INCRH_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('INCRH','push_subq');
646: L_CRHNEW_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CRHNEW','push_subq');
647:
648: L_CI_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CI','push_subq');
649: L_RA_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('RA','push_subq');

Line 646: L_CRHNEW_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CRHNEW','push_subq');

642: L_BATCH_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('BATCH','push_subq');
643: L_RA_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('RA','push_subq');
644: L_MISC_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('MISC','push_subq');
645: L_INCRH_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('INCRH','push_subq');
646: L_CRHNEW_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CRHNEW','push_subq');
647:
648: L_CI_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CI','push_subq');
649: L_RA_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('RA','push_subq');
650: L_TRX_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('TRX','push_subq');

Line 648: L_CI_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CI','push_subq');

644: L_MISC_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('MISC','push_subq');
645: L_INCRH_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('INCRH','push_subq');
646: L_CRHNEW_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CRHNEW','push_subq');
647:
648: L_CI_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CI','push_subq');
649: L_RA_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('RA','push_subq');
650: L_TRX_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('TRX','push_subq');
651: L_REC_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('REC','push_subq');
652: L_RAC_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('RAC','push_subq');

Line 649: L_RA_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('RA','push_subq');

645: L_INCRH_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('INCRH','push_subq');
646: L_CRHNEW_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CRHNEW','push_subq');
647:
648: L_CI_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CI','push_subq');
649: L_RA_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('RA','push_subq');
650: L_TRX_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('TRX','push_subq');
651: L_REC_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('REC','push_subq');
652: L_RAC_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('RAC','push_subq');
653: L_PS_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('PS','push_subq');

Line 650: L_TRX_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('TRX','push_subq');

646: L_CRHNEW_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CRHNEW','push_subq');
647:
648: L_CI_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CI','push_subq');
649: L_RA_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('RA','push_subq');
650: L_TRX_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('TRX','push_subq');
651: L_REC_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('REC','push_subq');
652: L_RAC_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('RAC','push_subq');
653: L_PS_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('PS','push_subq');
654: L_MCD_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('MCD','push_subq');

Line 651: L_REC_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('REC','push_subq');

647:
648: L_CI_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CI','push_subq');
649: L_RA_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('RA','push_subq');
650: L_TRX_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('TRX','push_subq');
651: L_REC_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('REC','push_subq');
652: L_RAC_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('RAC','push_subq');
653: L_PS_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('PS','push_subq');
654: L_MCD_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('MCD','push_subq');
655: L_ARD_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('ARD','push_subq');

Line 652: L_RAC_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('RAC','push_subq');

648: L_CI_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CI','push_subq');
649: L_RA_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('RA','push_subq');
650: L_TRX_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('TRX','push_subq');
651: L_REC_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('REC','push_subq');
652: L_RAC_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('RAC','push_subq');
653: L_PS_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('PS','push_subq');
654: L_MCD_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('MCD','push_subq');
655: L_ARD_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('ARD','push_subq');
656: L_BS_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('BS','push_subq');

Line 653: L_PS_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('PS','push_subq');

649: L_RA_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('RA','push_subq');
650: L_TRX_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('TRX','push_subq');
651: L_REC_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('REC','push_subq');
652: L_RAC_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('RAC','push_subq');
653: L_PS_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('PS','push_subq');
654: L_MCD_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('MCD','push_subq');
655: L_ARD_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('ARD','push_subq');
656: L_BS_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('BS','push_subq');
657:

Line 654: L_MCD_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('MCD','push_subq');

650: L_TRX_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('TRX','push_subq');
651: L_REC_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('REC','push_subq');
652: L_RAC_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('RAC','push_subq');
653: L_PS_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('PS','push_subq');
654: L_MCD_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('MCD','push_subq');
655: L_ARD_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('ARD','push_subq');
656: L_BS_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('BS','push_subq');
657:
658: IF var.p_co_seg_low IS NULL AND var.p_co_seg_high IS NULL THEN

Line 655: L_ARD_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('ARD','push_subq');

651: L_REC_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('REC','push_subq');
652: L_RAC_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('RAC','push_subq');
653: L_PS_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('PS','push_subq');
654: L_MCD_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('MCD','push_subq');
655: L_ARD_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('ARD','push_subq');
656: L_BS_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('BS','push_subq');
657:
658: IF var.p_co_seg_low IS NULL AND var.p_co_seg_high IS NULL THEN
659: CO_SEG_WHERE := NULL;

Line 656: L_BS_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('BS','push_subq');

652: L_RAC_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('RAC','push_subq');
653: L_PS_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('PS','push_subq');
654: L_MCD_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('MCD','push_subq');
655: L_ARD_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('ARD','push_subq');
656: L_BS_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('BS','push_subq');
657:
658: IF var.p_co_seg_low IS NULL AND var.p_co_seg_high IS NULL THEN
659: CO_SEG_WHERE := NULL;
660: ELSIF var.p_co_seg_low IS NULL THEN