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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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:
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
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;
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