1682: -- initialize the reporting context
1683: init(p_sob_id);
1684:
1685: -- set the org conditions
1686: xla_mo_reporting_api.initialize(
1687: p_reporting_level => p_reporting_level,
1688: p_reporting_entity_id => p_reporting_entity_id,
1689: p_pred_type => 'AUTO');
1690:
1693: CLOSE format;
1694:
1695: debug( 'getting where clause');
1696:
1697: g_dist_org_where := xla_mo_reporting_api.get_predicate('dist',NULL);
1698: g_trx_org_where := xla_mo_reporting_api.get_predicate('trx',NULL);
1699: g_type_org_where := xla_mo_reporting_api.get_predicate('ctt',NULL);
1700: g_ard_org_where := xla_mo_reporting_api.get_predicate('ard',NULL);
1701: g_crh_org_where := xla_mo_reporting_api.get_predicate('crh',NULL);
1694:
1695: debug( 'getting where clause');
1696:
1697: g_dist_org_where := xla_mo_reporting_api.get_predicate('dist',NULL);
1698: g_trx_org_where := xla_mo_reporting_api.get_predicate('trx',NULL);
1699: g_type_org_where := xla_mo_reporting_api.get_predicate('ctt',NULL);
1700: g_ard_org_where := xla_mo_reporting_api.get_predicate('ard',NULL);
1701: g_crh_org_where := xla_mo_reporting_api.get_predicate('crh',NULL);
1702: g_cr_org_where := xla_mo_reporting_api.get_predicate('cr',NULL);
1695: debug( 'getting where clause');
1696:
1697: g_dist_org_where := xla_mo_reporting_api.get_predicate('dist',NULL);
1698: g_trx_org_where := xla_mo_reporting_api.get_predicate('trx',NULL);
1699: g_type_org_where := xla_mo_reporting_api.get_predicate('ctt',NULL);
1700: g_ard_org_where := xla_mo_reporting_api.get_predicate('ard',NULL);
1701: g_crh_org_where := xla_mo_reporting_api.get_predicate('crh',NULL);
1702: g_cr_org_where := xla_mo_reporting_api.get_predicate('cr',NULL);
1703: g_rm_org_where := xla_mo_reporting_api.get_predicate('rm',NULL);
1696:
1697: g_dist_org_where := xla_mo_reporting_api.get_predicate('dist',NULL);
1698: g_trx_org_where := xla_mo_reporting_api.get_predicate('trx',NULL);
1699: g_type_org_where := xla_mo_reporting_api.get_predicate('ctt',NULL);
1700: g_ard_org_where := xla_mo_reporting_api.get_predicate('ard',NULL);
1701: g_crh_org_where := xla_mo_reporting_api.get_predicate('crh',NULL);
1702: g_cr_org_where := xla_mo_reporting_api.get_predicate('cr',NULL);
1703: g_rm_org_where := xla_mo_reporting_api.get_predicate('rm',NULL);
1704: g_rec_org_where := xla_mo_reporting_api.get_predicate('ra',NULL);
1697: g_dist_org_where := xla_mo_reporting_api.get_predicate('dist',NULL);
1698: g_trx_org_where := xla_mo_reporting_api.get_predicate('trx',NULL);
1699: g_type_org_where := xla_mo_reporting_api.get_predicate('ctt',NULL);
1700: g_ard_org_where := xla_mo_reporting_api.get_predicate('ard',NULL);
1701: g_crh_org_where := xla_mo_reporting_api.get_predicate('crh',NULL);
1702: g_cr_org_where := xla_mo_reporting_api.get_predicate('cr',NULL);
1703: g_rm_org_where := xla_mo_reporting_api.get_predicate('rm',NULL);
1704: g_rec_org_where := xla_mo_reporting_api.get_predicate('ra',NULL);
1705: g_mcd_org_where := xla_mo_reporting_api.get_predicate('mcd',NULL);
1698: g_trx_org_where := xla_mo_reporting_api.get_predicate('trx',NULL);
1699: g_type_org_where := xla_mo_reporting_api.get_predicate('ctt',NULL);
1700: g_ard_org_where := xla_mo_reporting_api.get_predicate('ard',NULL);
1701: g_crh_org_where := xla_mo_reporting_api.get_predicate('crh',NULL);
1702: g_cr_org_where := xla_mo_reporting_api.get_predicate('cr',NULL);
1703: g_rm_org_where := xla_mo_reporting_api.get_predicate('rm',NULL);
1704: g_rec_org_where := xla_mo_reporting_api.get_predicate('ra',NULL);
1705: g_mcd_org_where := xla_mo_reporting_api.get_predicate('mcd',NULL);
1706: g_adj_org_where := xla_mo_reporting_api.get_predicate('adj',NULL);
1699: g_type_org_where := xla_mo_reporting_api.get_predicate('ctt',NULL);
1700: g_ard_org_where := xla_mo_reporting_api.get_predicate('ard',NULL);
1701: g_crh_org_where := xla_mo_reporting_api.get_predicate('crh',NULL);
1702: g_cr_org_where := xla_mo_reporting_api.get_predicate('cr',NULL);
1703: g_rm_org_where := xla_mo_reporting_api.get_predicate('rm',NULL);
1704: g_rec_org_where := xla_mo_reporting_api.get_predicate('ra',NULL);
1705: g_mcd_org_where := xla_mo_reporting_api.get_predicate('mcd',NULL);
1706: g_adj_org_where := xla_mo_reporting_api.get_predicate('adj',NULL);
1707: g_br_org_where := xla_mo_reporting_api.get_predicate('br',NULL);
1700: g_ard_org_where := xla_mo_reporting_api.get_predicate('ard',NULL);
1701: g_crh_org_where := xla_mo_reporting_api.get_predicate('crh',NULL);
1702: g_cr_org_where := xla_mo_reporting_api.get_predicate('cr',NULL);
1703: g_rm_org_where := xla_mo_reporting_api.get_predicate('rm',NULL);
1704: g_rec_org_where := xla_mo_reporting_api.get_predicate('ra',NULL);
1705: g_mcd_org_where := xla_mo_reporting_api.get_predicate('mcd',NULL);
1706: g_adj_org_where := xla_mo_reporting_api.get_predicate('adj',NULL);
1707: g_br_org_where := xla_mo_reporting_api.get_predicate('br',NULL);
1708: g_sys_org_where := xla_mo_reporting_api.get_Predicate('sys',NULL);
1701: g_crh_org_where := xla_mo_reporting_api.get_predicate('crh',NULL);
1702: g_cr_org_where := xla_mo_reporting_api.get_predicate('cr',NULL);
1703: g_rm_org_where := xla_mo_reporting_api.get_predicate('rm',NULL);
1704: g_rec_org_where := xla_mo_reporting_api.get_predicate('ra',NULL);
1705: g_mcd_org_where := xla_mo_reporting_api.get_predicate('mcd',NULL);
1706: g_adj_org_where := xla_mo_reporting_api.get_predicate('adj',NULL);
1707: g_br_org_where := xla_mo_reporting_api.get_predicate('br',NULL);
1708: g_sys_org_where := xla_mo_reporting_api.get_Predicate('sys',NULL);
1709: g_balances_where := xla_mo_reporting_api.get_Predicate('bal',NULL);
1702: g_cr_org_where := xla_mo_reporting_api.get_predicate('cr',NULL);
1703: g_rm_org_where := xla_mo_reporting_api.get_predicate('rm',NULL);
1704: g_rec_org_where := xla_mo_reporting_api.get_predicate('ra',NULL);
1705: g_mcd_org_where := xla_mo_reporting_api.get_predicate('mcd',NULL);
1706: g_adj_org_where := xla_mo_reporting_api.get_predicate('adj',NULL);
1707: g_br_org_where := xla_mo_reporting_api.get_predicate('br',NULL);
1708: g_sys_org_where := xla_mo_reporting_api.get_Predicate('sys',NULL);
1709: g_balances_where := xla_mo_reporting_api.get_Predicate('bal',NULL);
1710:
1703: g_rm_org_where := xla_mo_reporting_api.get_predicate('rm',NULL);
1704: g_rec_org_where := xla_mo_reporting_api.get_predicate('ra',NULL);
1705: g_mcd_org_where := xla_mo_reporting_api.get_predicate('mcd',NULL);
1706: g_adj_org_where := xla_mo_reporting_api.get_predicate('adj',NULL);
1707: g_br_org_where := xla_mo_reporting_api.get_predicate('br',NULL);
1708: g_sys_org_where := xla_mo_reporting_api.get_Predicate('sys',NULL);
1709: g_balances_where := xla_mo_reporting_api.get_Predicate('bal',NULL);
1710:
1711: debug( 'before: g_sys_org_where : ' || g_sys_org_where);
1704: g_rec_org_where := xla_mo_reporting_api.get_predicate('ra',NULL);
1705: g_mcd_org_where := xla_mo_reporting_api.get_predicate('mcd',NULL);
1706: g_adj_org_where := xla_mo_reporting_api.get_predicate('adj',NULL);
1707: g_br_org_where := xla_mo_reporting_api.get_predicate('br',NULL);
1708: g_sys_org_where := xla_mo_reporting_api.get_Predicate('sys',NULL);
1709: g_balances_where := xla_mo_reporting_api.get_Predicate('bal',NULL);
1710:
1711: debug( 'before: g_sys_org_where : ' || g_sys_org_where);
1712:
1705: g_mcd_org_where := xla_mo_reporting_api.get_predicate('mcd',NULL);
1706: g_adj_org_where := xla_mo_reporting_api.get_predicate('adj',NULL);
1707: g_br_org_where := xla_mo_reporting_api.get_predicate('br',NULL);
1708: g_sys_org_where := xla_mo_reporting_api.get_Predicate('sys',NULL);
1709: g_balances_where := xla_mo_reporting_api.get_Predicate('bal',NULL);
1710:
1711: debug( 'before: g_sys_org_where : ' || g_sys_org_where);
1712:
1713: -- replacing with actual reporting entity id
1753: debug('g_sys_org_where: ' || g_sys_org_where);
1754: debug('g_balances_where: ' || g_balances_where);
1755:
1756: l_reporting_entity_name :=
1757: substrb(xla_mo_reporting_api.get_reporting_entity_name,1,80);
1758: l_reporting_level_name :=
1759: substrb(xla_mo_reporting_api.get_reporting_level_name,1,30);
1760:
1761: debug( 'l_reporting_entity_name : ' || l_reporting_entity_name);
1755:
1756: l_reporting_entity_name :=
1757: substrb(xla_mo_reporting_api.get_reporting_entity_name,1,80);
1758: l_reporting_level_name :=
1759: substrb(xla_mo_reporting_api.get_reporting_level_name,1,30);
1760:
1761: debug( 'l_reporting_entity_name : ' || l_reporting_entity_name);
1762: debug( 'l_reporting_level_name : ' || l_reporting_level_name);
1763: