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.AR_CUMULATIVE_BALANCE_REPORT dependencies on XLA_MO_REPORTING_API

Line 1715: xla_mo_reporting_api.initialize(

1711: -- initialize the reporting context
1712: init(p_sob_id);
1713:
1714: -- set the org conditions
1715: xla_mo_reporting_api.initialize(
1716: p_reporting_level => p_reporting_level,
1717: p_reporting_entity_id => p_reporting_entity_id,
1718: p_pred_type => 'AUTO');
1719:

Line 1726: g_dist_org_where := xla_mo_reporting_api.get_predicate('dist',NULL);

1722: CLOSE format;
1723:
1724: debug( 'getting where clause');
1725:
1726: g_dist_org_where := xla_mo_reporting_api.get_predicate('dist',NULL);
1727: g_trx_org_where := xla_mo_reporting_api.get_predicate('trx',NULL);
1728: g_type_org_where := xla_mo_reporting_api.get_predicate('ctt',NULL);
1729: g_ard_org_where := xla_mo_reporting_api.get_predicate('ard',NULL);
1730: g_crh_org_where := xla_mo_reporting_api.get_predicate('crh',NULL);

Line 1727: g_trx_org_where := xla_mo_reporting_api.get_predicate('trx',NULL);

1723:
1724: debug( 'getting where clause');
1725:
1726: g_dist_org_where := xla_mo_reporting_api.get_predicate('dist',NULL);
1727: g_trx_org_where := xla_mo_reporting_api.get_predicate('trx',NULL);
1728: g_type_org_where := xla_mo_reporting_api.get_predicate('ctt',NULL);
1729: g_ard_org_where := xla_mo_reporting_api.get_predicate('ard',NULL);
1730: g_crh_org_where := xla_mo_reporting_api.get_predicate('crh',NULL);
1731: g_cr_org_where := xla_mo_reporting_api.get_predicate('cr',NULL);

Line 1728: g_type_org_where := xla_mo_reporting_api.get_predicate('ctt',NULL);

1724: debug( 'getting where clause');
1725:
1726: g_dist_org_where := xla_mo_reporting_api.get_predicate('dist',NULL);
1727: g_trx_org_where := xla_mo_reporting_api.get_predicate('trx',NULL);
1728: g_type_org_where := xla_mo_reporting_api.get_predicate('ctt',NULL);
1729: g_ard_org_where := xla_mo_reporting_api.get_predicate('ard',NULL);
1730: g_crh_org_where := xla_mo_reporting_api.get_predicate('crh',NULL);
1731: g_cr_org_where := xla_mo_reporting_api.get_predicate('cr',NULL);
1732: g_rm_org_where := xla_mo_reporting_api.get_predicate('rm',NULL);

Line 1729: g_ard_org_where := xla_mo_reporting_api.get_predicate('ard',NULL);

1725:
1726: g_dist_org_where := xla_mo_reporting_api.get_predicate('dist',NULL);
1727: g_trx_org_where := xla_mo_reporting_api.get_predicate('trx',NULL);
1728: g_type_org_where := xla_mo_reporting_api.get_predicate('ctt',NULL);
1729: g_ard_org_where := xla_mo_reporting_api.get_predicate('ard',NULL);
1730: g_crh_org_where := xla_mo_reporting_api.get_predicate('crh',NULL);
1731: g_cr_org_where := xla_mo_reporting_api.get_predicate('cr',NULL);
1732: g_rm_org_where := xla_mo_reporting_api.get_predicate('rm',NULL);
1733: g_rec_org_where := xla_mo_reporting_api.get_predicate('ra',NULL);

Line 1730: g_crh_org_where := xla_mo_reporting_api.get_predicate('crh',NULL);

1726: g_dist_org_where := xla_mo_reporting_api.get_predicate('dist',NULL);
1727: g_trx_org_where := xla_mo_reporting_api.get_predicate('trx',NULL);
1728: g_type_org_where := xla_mo_reporting_api.get_predicate('ctt',NULL);
1729: g_ard_org_where := xla_mo_reporting_api.get_predicate('ard',NULL);
1730: g_crh_org_where := xla_mo_reporting_api.get_predicate('crh',NULL);
1731: g_cr_org_where := xla_mo_reporting_api.get_predicate('cr',NULL);
1732: g_rm_org_where := xla_mo_reporting_api.get_predicate('rm',NULL);
1733: g_rec_org_where := xla_mo_reporting_api.get_predicate('ra',NULL);
1734: g_mcd_org_where := xla_mo_reporting_api.get_predicate('mcd',NULL);

Line 1731: g_cr_org_where := xla_mo_reporting_api.get_predicate('cr',NULL);

1727: g_trx_org_where := xla_mo_reporting_api.get_predicate('trx',NULL);
1728: g_type_org_where := xla_mo_reporting_api.get_predicate('ctt',NULL);
1729: g_ard_org_where := xla_mo_reporting_api.get_predicate('ard',NULL);
1730: g_crh_org_where := xla_mo_reporting_api.get_predicate('crh',NULL);
1731: g_cr_org_where := xla_mo_reporting_api.get_predicate('cr',NULL);
1732: g_rm_org_where := xla_mo_reporting_api.get_predicate('rm',NULL);
1733: g_rec_org_where := xla_mo_reporting_api.get_predicate('ra',NULL);
1734: g_mcd_org_where := xla_mo_reporting_api.get_predicate('mcd',NULL);
1735: g_adj_org_where := xla_mo_reporting_api.get_predicate('adj',NULL);

Line 1732: g_rm_org_where := xla_mo_reporting_api.get_predicate('rm',NULL);

1728: g_type_org_where := xla_mo_reporting_api.get_predicate('ctt',NULL);
1729: g_ard_org_where := xla_mo_reporting_api.get_predicate('ard',NULL);
1730: g_crh_org_where := xla_mo_reporting_api.get_predicate('crh',NULL);
1731: g_cr_org_where := xla_mo_reporting_api.get_predicate('cr',NULL);
1732: g_rm_org_where := xla_mo_reporting_api.get_predicate('rm',NULL);
1733: g_rec_org_where := xla_mo_reporting_api.get_predicate('ra',NULL);
1734: g_mcd_org_where := xla_mo_reporting_api.get_predicate('mcd',NULL);
1735: g_adj_org_where := xla_mo_reporting_api.get_predicate('adj',NULL);
1736: g_br_org_where := xla_mo_reporting_api.get_predicate('br',NULL);

Line 1733: g_rec_org_where := xla_mo_reporting_api.get_predicate('ra',NULL);

1729: g_ard_org_where := xla_mo_reporting_api.get_predicate('ard',NULL);
1730: g_crh_org_where := xla_mo_reporting_api.get_predicate('crh',NULL);
1731: g_cr_org_where := xla_mo_reporting_api.get_predicate('cr',NULL);
1732: g_rm_org_where := xla_mo_reporting_api.get_predicate('rm',NULL);
1733: g_rec_org_where := xla_mo_reporting_api.get_predicate('ra',NULL);
1734: g_mcd_org_where := xla_mo_reporting_api.get_predicate('mcd',NULL);
1735: g_adj_org_where := xla_mo_reporting_api.get_predicate('adj',NULL);
1736: g_br_org_where := xla_mo_reporting_api.get_predicate('br',NULL);
1737: g_sys_org_where := xla_mo_reporting_api.get_Predicate('sys',NULL);

Line 1734: g_mcd_org_where := xla_mo_reporting_api.get_predicate('mcd',NULL);

1730: g_crh_org_where := xla_mo_reporting_api.get_predicate('crh',NULL);
1731: g_cr_org_where := xla_mo_reporting_api.get_predicate('cr',NULL);
1732: g_rm_org_where := xla_mo_reporting_api.get_predicate('rm',NULL);
1733: g_rec_org_where := xla_mo_reporting_api.get_predicate('ra',NULL);
1734: g_mcd_org_where := xla_mo_reporting_api.get_predicate('mcd',NULL);
1735: g_adj_org_where := xla_mo_reporting_api.get_predicate('adj',NULL);
1736: g_br_org_where := xla_mo_reporting_api.get_predicate('br',NULL);
1737: g_sys_org_where := xla_mo_reporting_api.get_Predicate('sys',NULL);
1738: g_balances_where := xla_mo_reporting_api.get_Predicate('bal',NULL);

Line 1735: g_adj_org_where := xla_mo_reporting_api.get_predicate('adj',NULL);

1731: g_cr_org_where := xla_mo_reporting_api.get_predicate('cr',NULL);
1732: g_rm_org_where := xla_mo_reporting_api.get_predicate('rm',NULL);
1733: g_rec_org_where := xla_mo_reporting_api.get_predicate('ra',NULL);
1734: g_mcd_org_where := xla_mo_reporting_api.get_predicate('mcd',NULL);
1735: g_adj_org_where := xla_mo_reporting_api.get_predicate('adj',NULL);
1736: g_br_org_where := xla_mo_reporting_api.get_predicate('br',NULL);
1737: g_sys_org_where := xla_mo_reporting_api.get_Predicate('sys',NULL);
1738: g_balances_where := xla_mo_reporting_api.get_Predicate('bal',NULL);
1739:

Line 1736: g_br_org_where := xla_mo_reporting_api.get_predicate('br',NULL);

1732: g_rm_org_where := xla_mo_reporting_api.get_predicate('rm',NULL);
1733: g_rec_org_where := xla_mo_reporting_api.get_predicate('ra',NULL);
1734: g_mcd_org_where := xla_mo_reporting_api.get_predicate('mcd',NULL);
1735: g_adj_org_where := xla_mo_reporting_api.get_predicate('adj',NULL);
1736: g_br_org_where := xla_mo_reporting_api.get_predicate('br',NULL);
1737: g_sys_org_where := xla_mo_reporting_api.get_Predicate('sys',NULL);
1738: g_balances_where := xla_mo_reporting_api.get_Predicate('bal',NULL);
1739:
1740: debug( 'before: g_sys_org_where : ' || g_sys_org_where);

Line 1737: g_sys_org_where := xla_mo_reporting_api.get_Predicate('sys',NULL);

1733: g_rec_org_where := xla_mo_reporting_api.get_predicate('ra',NULL);
1734: g_mcd_org_where := xla_mo_reporting_api.get_predicate('mcd',NULL);
1735: g_adj_org_where := xla_mo_reporting_api.get_predicate('adj',NULL);
1736: g_br_org_where := xla_mo_reporting_api.get_predicate('br',NULL);
1737: g_sys_org_where := xla_mo_reporting_api.get_Predicate('sys',NULL);
1738: g_balances_where := xla_mo_reporting_api.get_Predicate('bal',NULL);
1739:
1740: debug( 'before: g_sys_org_where : ' || g_sys_org_where);
1741:

Line 1738: g_balances_where := xla_mo_reporting_api.get_Predicate('bal',NULL);

1734: g_mcd_org_where := xla_mo_reporting_api.get_predicate('mcd',NULL);
1735: g_adj_org_where := xla_mo_reporting_api.get_predicate('adj',NULL);
1736: g_br_org_where := xla_mo_reporting_api.get_predicate('br',NULL);
1737: g_sys_org_where := xla_mo_reporting_api.get_Predicate('sys',NULL);
1738: g_balances_where := xla_mo_reporting_api.get_Predicate('bal',NULL);
1739:
1740: debug( 'before: g_sys_org_where : ' || g_sys_org_where);
1741:
1742: -- replacing with actual reporting entity id

Line 1786: substrb(xla_mo_reporting_api.get_reporting_entity_name,1,80);

1782: debug('g_sys_org_where: ' || g_sys_org_where);
1783: debug('g_balances_where: ' || g_balances_where);
1784:
1785: l_reporting_entity_name :=
1786: substrb(xla_mo_reporting_api.get_reporting_entity_name,1,80);
1787: l_reporting_level_name :=
1788: substrb(xla_mo_reporting_api.get_reporting_level_name,1,30);
1789:
1790: debug( 'l_reporting_entity_name : ' || l_reporting_entity_name);

Line 1788: substrb(xla_mo_reporting_api.get_reporting_level_name,1,30);

1784:
1785: l_reporting_entity_name :=
1786: substrb(xla_mo_reporting_api.get_reporting_entity_name,1,80);
1787: l_reporting_level_name :=
1788: substrb(xla_mo_reporting_api.get_reporting_level_name,1,30);
1789:
1790: debug( 'l_reporting_entity_name : ' || l_reporting_entity_name);
1791: debug( 'l_reporting_level_name : ' || l_reporting_level_name);
1792: