DBA Data[Home] [Help]

APPS.ARRX_RC dependencies on XLA_MO_REPORTING_API

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

571: fa_rx_util_pkg.debug('Chart of Accounts ID : '||var.p_coa_id);
572: fa_rx_util_pkg.debug('Functional Currency : '||var.functional_currency_code);
573: fa_rx_util_pkg.debug('Organization Name : '||var.organization_name);
574:
575: XLA_MO_REPORTING_API.Initialize(var.p_reporting_level, var.p_reporting_entity_id, 'AUTO');
576:
577: L_CR_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CR',NULL);
578: L_TAX_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('TAX',NULL);
579: L_ABA_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('ABA',NULL);

Line 577: L_CR_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CR',NULL);

573: fa_rx_util_pkg.debug('Organization Name : '||var.organization_name);
574:
575: XLA_MO_REPORTING_API.Initialize(var.p_reporting_level, var.p_reporting_entity_id, 'AUTO');
576:
577: L_CR_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CR',NULL);
578: L_TAX_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('TAX',NULL);
579: L_ABA_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('ABA',NULL);
580: L_CRH_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CRH',NULL);
581: L_CUST_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CUST',NULL);

Line 578: L_TAX_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('TAX',NULL);

574:
575: XLA_MO_REPORTING_API.Initialize(var.p_reporting_level, var.p_reporting_entity_id, 'AUTO');
576:
577: L_CR_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CR',NULL);
578: L_TAX_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('TAX',NULL);
579: L_ABA_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('ABA',NULL);
580: L_CRH_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CRH',NULL);
581: L_CUST_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CUST',NULL);
582: L_CRHFIRST_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CRHFIRST',NULL);

Line 579: L_ABA_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('ABA',NULL);

575: XLA_MO_REPORTING_API.Initialize(var.p_reporting_level, var.p_reporting_entity_id, 'AUTO');
576:
577: L_CR_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CR',NULL);
578: L_TAX_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('TAX',NULL);
579: L_ABA_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('ABA',NULL);
580: L_CRH_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CRH',NULL);
581: L_CUST_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CUST',NULL);
582: L_CRHFIRST_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CRHFIRST',NULL);
583: L_BATCHFIRST_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('BATCHFIRST',NULL);

Line 580: L_CRH_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CRH',NULL);

576:
577: L_CR_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CR',NULL);
578: L_TAX_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('TAX',NULL);
579: L_ABA_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('ABA',NULL);
580: L_CRH_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CRH',NULL);
581: L_CUST_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CUST',NULL);
582: L_CRHFIRST_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CRHFIRST',NULL);
583: L_BATCHFIRST_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('BATCHFIRST',NULL);
584: L_BATCH_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('BATCH',NULL);

Line 581: L_CUST_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CUST',NULL);

577: L_CR_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CR',NULL);
578: L_TAX_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('TAX',NULL);
579: L_ABA_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('ABA',NULL);
580: L_CRH_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CRH',NULL);
581: L_CUST_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CUST',NULL);
582: L_CRHFIRST_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CRHFIRST',NULL);
583: L_BATCHFIRST_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('BATCHFIRST',NULL);
584: L_BATCH_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('BATCH',NULL);
585: L_RA_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('RA',NULL);

Line 582: L_CRHFIRST_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CRHFIRST',NULL);

578: L_TAX_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('TAX',NULL);
579: L_ABA_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('ABA',NULL);
580: L_CRH_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CRH',NULL);
581: L_CUST_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CUST',NULL);
582: L_CRHFIRST_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CRHFIRST',NULL);
583: L_BATCHFIRST_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('BATCHFIRST',NULL);
584: L_BATCH_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('BATCH',NULL);
585: L_RA_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('RA',NULL);
586: L_MISC_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('MISC',NULL);

Line 583: L_BATCHFIRST_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('BATCHFIRST',NULL);

579: L_ABA_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('ABA',NULL);
580: L_CRH_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CRH',NULL);
581: L_CUST_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CUST',NULL);
582: L_CRHFIRST_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CRHFIRST',NULL);
583: L_BATCHFIRST_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('BATCHFIRST',NULL);
584: L_BATCH_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('BATCH',NULL);
585: L_RA_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('RA',NULL);
586: L_MISC_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('MISC',NULL);
587: L_INCRH_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('INCRH',NULL);

Line 584: L_BATCH_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('BATCH',NULL);

580: L_CRH_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CRH',NULL);
581: L_CUST_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CUST',NULL);
582: L_CRHFIRST_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CRHFIRST',NULL);
583: L_BATCHFIRST_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('BATCHFIRST',NULL);
584: L_BATCH_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('BATCH',NULL);
585: L_RA_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('RA',NULL);
586: L_MISC_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('MISC',NULL);
587: L_INCRH_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('INCRH',NULL);
588: L_CI_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CI',NULL);

Line 585: L_RA_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('RA',NULL);

581: L_CUST_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CUST',NULL);
582: L_CRHFIRST_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CRHFIRST',NULL);
583: L_BATCHFIRST_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('BATCHFIRST',NULL);
584: L_BATCH_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('BATCH',NULL);
585: L_RA_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('RA',NULL);
586: L_MISC_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('MISC',NULL);
587: L_INCRH_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('INCRH',NULL);
588: L_CI_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CI',NULL);
589: L_RA_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('RA',NULL);

Line 586: L_MISC_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('MISC',NULL);

582: L_CRHFIRST_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CRHFIRST',NULL);
583: L_BATCHFIRST_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('BATCHFIRST',NULL);
584: L_BATCH_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('BATCH',NULL);
585: L_RA_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('RA',NULL);
586: L_MISC_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('MISC',NULL);
587: L_INCRH_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('INCRH',NULL);
588: L_CI_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CI',NULL);
589: L_RA_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('RA',NULL);
590: L_TRX_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('TRX',NULL);

Line 587: L_INCRH_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('INCRH',NULL);

583: L_BATCHFIRST_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('BATCHFIRST',NULL);
584: L_BATCH_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('BATCH',NULL);
585: L_RA_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('RA',NULL);
586: L_MISC_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('MISC',NULL);
587: L_INCRH_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('INCRH',NULL);
588: L_CI_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CI',NULL);
589: L_RA_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('RA',NULL);
590: L_TRX_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('TRX',NULL);
591: L_REC_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('REC',NULL);

Line 588: L_CI_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CI',NULL);

584: L_BATCH_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('BATCH',NULL);
585: L_RA_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('RA',NULL);
586: L_MISC_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('MISC',NULL);
587: L_INCRH_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('INCRH',NULL);
588: L_CI_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CI',NULL);
589: L_RA_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('RA',NULL);
590: L_TRX_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('TRX',NULL);
591: L_REC_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('REC',NULL);
592: L_RAC_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('RAC',NULL);

Line 589: L_RA_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('RA',NULL);

585: L_RA_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('RA',NULL);
586: L_MISC_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('MISC',NULL);
587: L_INCRH_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('INCRH',NULL);
588: L_CI_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CI',NULL);
589: L_RA_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('RA',NULL);
590: L_TRX_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('TRX',NULL);
591: L_REC_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('REC',NULL);
592: L_RAC_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('RAC',NULL);
593: L_PS_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('PS',NULL);

Line 590: L_TRX_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('TRX',NULL);

586: L_MISC_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('MISC',NULL);
587: L_INCRH_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('INCRH',NULL);
588: L_CI_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CI',NULL);
589: L_RA_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('RA',NULL);
590: L_TRX_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('TRX',NULL);
591: L_REC_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('REC',NULL);
592: L_RAC_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('RAC',NULL);
593: L_PS_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('PS',NULL);
594: L_MCD_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('MCD',NULL);

Line 591: L_REC_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('REC',NULL);

587: L_INCRH_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('INCRH',NULL);
588: L_CI_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CI',NULL);
589: L_RA_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('RA',NULL);
590: L_TRX_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('TRX',NULL);
591: L_REC_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('REC',NULL);
592: L_RAC_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('RAC',NULL);
593: L_PS_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('PS',NULL);
594: L_MCD_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('MCD',NULL);
595: L_ARD_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('ARD',NULL);

Line 592: L_RAC_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('RAC',NULL);

588: L_CI_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CI',NULL);
589: L_RA_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('RA',NULL);
590: L_TRX_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('TRX',NULL);
591: L_REC_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('REC',NULL);
592: L_RAC_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('RAC',NULL);
593: L_PS_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('PS',NULL);
594: L_MCD_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('MCD',NULL);
595: L_ARD_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('ARD',NULL);
596: L_BS_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('BS',NULL);

Line 593: L_PS_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('PS',NULL);

589: L_RA_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('RA',NULL);
590: L_TRX_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('TRX',NULL);
591: L_REC_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('REC',NULL);
592: L_RAC_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('RAC',NULL);
593: L_PS_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('PS',NULL);
594: L_MCD_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('MCD',NULL);
595: L_ARD_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('ARD',NULL);
596: L_BS_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('BS',NULL);
597:

Line 594: L_MCD_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('MCD',NULL);

590: L_TRX_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('TRX',NULL);
591: L_REC_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('REC',NULL);
592: L_RAC_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('RAC',NULL);
593: L_PS_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('PS',NULL);
594: L_MCD_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('MCD',NULL);
595: L_ARD_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('ARD',NULL);
596: L_BS_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('BS',NULL);
597:
598: IF var.p_co_seg_low IS NULL AND var.p_co_seg_high IS NULL THEN

Line 595: L_ARD_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('ARD',NULL);

591: L_REC_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('REC',NULL);
592: L_RAC_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('RAC',NULL);
593: L_PS_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('PS',NULL);
594: L_MCD_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('MCD',NULL);
595: L_ARD_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('ARD',NULL);
596: L_BS_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('BS',NULL);
597:
598: IF var.p_co_seg_low IS NULL AND var.p_co_seg_high IS NULL THEN
599: CO_SEG_WHERE := NULL;

Line 596: L_BS_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('BS',NULL);

592: L_RAC_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('RAC',NULL);
593: L_PS_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('PS',NULL);
594: L_MCD_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('MCD',NULL);
595: L_ARD_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('ARD',NULL);
596: L_BS_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('BS',NULL);
597:
598: IF var.p_co_seg_low IS NULL AND var.p_co_seg_high IS NULL THEN
599: CO_SEG_WHERE := NULL;
600: ELSIF var.p_co_seg_low IS NULL THEN