DBA Data[Home] [Help]

APPS.AR_CUMULATIVE_BALANCE_REPORT dependencies on XLA_MO_REPORTING_API

Line 1686: xla_mo_reporting_api.initialize(

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:

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

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

Line 1698: g_trx_org_where := xla_mo_reporting_api.get_predicate('trx',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);

Line 1699: g_type_org_where := xla_mo_reporting_api.get_predicate('ctt',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);

Line 1700: g_ard_org_where := xla_mo_reporting_api.get_predicate('ard',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);

Line 1701: g_crh_org_where := xla_mo_reporting_api.get_predicate('crh',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);

Line 1702: g_cr_org_where := xla_mo_reporting_api.get_predicate('cr',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);

Line 1703: g_rm_org_where := xla_mo_reporting_api.get_predicate('rm',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);

Line 1704: g_rec_org_where := xla_mo_reporting_api.get_predicate('ra',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);

Line 1705: g_mcd_org_where := xla_mo_reporting_api.get_predicate('mcd',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);

Line 1706: g_adj_org_where := xla_mo_reporting_api.get_predicate('adj',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:

Line 1707: g_br_org_where := xla_mo_reporting_api.get_predicate('br',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:
1711: debug( 'before: g_sys_org_where : ' || g_sys_org_where);

Line 1708: g_sys_org_where := xla_mo_reporting_api.get_Predicate('sys',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);
1712:

Line 1709: g_balances_where := xla_mo_reporting_api.get_Predicate('bal',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:
1713: -- replacing with actual reporting entity id

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

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

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

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: