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

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

469: init(p_sob_id);
470:
471: /* Set the org conditions */
472:
473: XLA_MO_REPORTING_API.Initialize(p_reporting_level, p_reporting_entity_id, 'AUTO');
474:
475: l_adj_org_where := XLA_MO_REPORTING_API.Get_Predicate('adj',NULL);
476: l_ard_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard',NULL);
477: l_trx_org_where := XLA_MO_REPORTING_API.Get_Predicate('trx',NULL);

Line 475: l_adj_org_where := XLA_MO_REPORTING_API.Get_Predicate('adj',NULL);

471: /* Set the org conditions */
472:
473: XLA_MO_REPORTING_API.Initialize(p_reporting_level, p_reporting_entity_id, 'AUTO');
474:
475: l_adj_org_where := XLA_MO_REPORTING_API.Get_Predicate('adj',NULL);
476: l_ard_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard',NULL);
477: l_trx_org_where := XLA_MO_REPORTING_API.Get_Predicate('trx',NULL);
478: l_pay_org_where := XLA_MO_REPORTING_API.Get_Predicate('pay',NULL);
479: l_rec_org_where := XLA_MO_REPORTING_API.Get_Predicate('rec',NULL);

Line 476: l_ard_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard',NULL);

472:
473: XLA_MO_REPORTING_API.Initialize(p_reporting_level, p_reporting_entity_id, 'AUTO');
474:
475: l_adj_org_where := XLA_MO_REPORTING_API.Get_Predicate('adj',NULL);
476: l_ard_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard',NULL);
477: l_trx_org_where := XLA_MO_REPORTING_API.Get_Predicate('trx',NULL);
478: l_pay_org_where := XLA_MO_REPORTING_API.Get_Predicate('pay',NULL);
479: l_rec_org_where := XLA_MO_REPORTING_API.Get_Predicate('rec',NULL);
480: l_type_org_where := XLA_MO_REPORTING_API.Get_Predicate('type',NULL);

Line 477: l_trx_org_where := XLA_MO_REPORTING_API.Get_Predicate('trx',NULL);

473: XLA_MO_REPORTING_API.Initialize(p_reporting_level, p_reporting_entity_id, 'AUTO');
474:
475: l_adj_org_where := XLA_MO_REPORTING_API.Get_Predicate('adj',NULL);
476: l_ard_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard',NULL);
477: l_trx_org_where := XLA_MO_REPORTING_API.Get_Predicate('trx',NULL);
478: l_pay_org_where := XLA_MO_REPORTING_API.Get_Predicate('pay',NULL);
479: l_rec_org_where := XLA_MO_REPORTING_API.Get_Predicate('rec',NULL);
480: l_type_org_where := XLA_MO_REPORTING_API.Get_Predicate('type',NULL);
481: l_sysparam_org_where := XLA_MO_REPORTING_API.Get_Predicate('sysparam',NULL);

Line 478: l_pay_org_where := XLA_MO_REPORTING_API.Get_Predicate('pay',NULL);

474:
475: l_adj_org_where := XLA_MO_REPORTING_API.Get_Predicate('adj',NULL);
476: l_ard_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard',NULL);
477: l_trx_org_where := XLA_MO_REPORTING_API.Get_Predicate('trx',NULL);
478: l_pay_org_where := XLA_MO_REPORTING_API.Get_Predicate('pay',NULL);
479: l_rec_org_where := XLA_MO_REPORTING_API.Get_Predicate('rec',NULL);
480: l_type_org_where := XLA_MO_REPORTING_API.Get_Predicate('type',NULL);
481: l_sysparam_org_where := XLA_MO_REPORTING_API.Get_Predicate('sysparam',NULL);
482:

Line 479: l_rec_org_where := XLA_MO_REPORTING_API.Get_Predicate('rec',NULL);

475: l_adj_org_where := XLA_MO_REPORTING_API.Get_Predicate('adj',NULL);
476: l_ard_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard',NULL);
477: l_trx_org_where := XLA_MO_REPORTING_API.Get_Predicate('trx',NULL);
478: l_pay_org_where := XLA_MO_REPORTING_API.Get_Predicate('pay',NULL);
479: l_rec_org_where := XLA_MO_REPORTING_API.Get_Predicate('rec',NULL);
480: l_type_org_where := XLA_MO_REPORTING_API.Get_Predicate('type',NULL);
481: l_sysparam_org_where := XLA_MO_REPORTING_API.Get_Predicate('sysparam',NULL);
482:
483:

Line 480: l_type_org_where := XLA_MO_REPORTING_API.Get_Predicate('type',NULL);

476: l_ard_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard',NULL);
477: l_trx_org_where := XLA_MO_REPORTING_API.Get_Predicate('trx',NULL);
478: l_pay_org_where := XLA_MO_REPORTING_API.Get_Predicate('pay',NULL);
479: l_rec_org_where := XLA_MO_REPORTING_API.Get_Predicate('rec',NULL);
480: l_type_org_where := XLA_MO_REPORTING_API.Get_Predicate('type',NULL);
481: l_sysparam_org_where := XLA_MO_REPORTING_API.Get_Predicate('sysparam',NULL);
482:
483:
484: /* Replace the bind variables with global functions */

Line 481: l_sysparam_org_where := XLA_MO_REPORTING_API.Get_Predicate('sysparam',NULL);

477: l_trx_org_where := XLA_MO_REPORTING_API.Get_Predicate('trx',NULL);
478: l_pay_org_where := XLA_MO_REPORTING_API.Get_Predicate('pay',NULL);
479: l_rec_org_where := XLA_MO_REPORTING_API.Get_Predicate('rec',NULL);
480: l_type_org_where := XLA_MO_REPORTING_API.Get_Predicate('type',NULL);
481: l_sysparam_org_where := XLA_MO_REPORTING_API.Get_Predicate('sysparam',NULL);
482:
483:
484: /* Replace the bind variables with global functions */
485: l_adj_org_where := replace(l_adj_org_where,

Line 501: l_reporting_entity_name := substrb(XLA_MO_REPORTING_API.get_reporting_entity_name,1,80);

497: l_sysparam_org_where := replace(l_sysparam_org_where,
498: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
499:
500:
501: l_reporting_entity_name := substrb(XLA_MO_REPORTING_API.get_reporting_entity_name,1,80);
502: l_reporting_level_name := substrb(XLA_MO_REPORTING_API.get_reporting_level_name,1,30);
503:
504: /* Multi Org Uptake: Show appropriate message to the user depending upon the security profile */
505: IF p_reporting_level = '1000' THEN

Line 502: l_reporting_level_name := substrb(XLA_MO_REPORTING_API.get_reporting_level_name,1,30);

498: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
499:
500:
501: l_reporting_entity_name := substrb(XLA_MO_REPORTING_API.get_reporting_entity_name,1,80);
502: l_reporting_level_name := substrb(XLA_MO_REPORTING_API.get_reporting_level_name,1,30);
503:
504: /* Multi Org Uptake: Show appropriate message to the user depending upon the security profile */
505: IF p_reporting_level = '1000' THEN
506: l_ld_sp:= mo_utils.check_ledger_in_sp(p_reporting_entity_id);

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

979: init(p_sob_id);
980:
981: /* Set the org conditions */
982:
983: XLA_MO_REPORTING_API.Initialize(p_reporting_level, p_reporting_entity_id, 'AUTO');
984:
985: l_ra_org_where := XLA_MO_REPORTING_API.Get_Predicate('ra',NULL);
986: l_ard_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard',NULL);
987: l_ps_org_where := XLA_MO_REPORTING_API.Get_Predicate('ps',NULL);

Line 985: l_ra_org_where := XLA_MO_REPORTING_API.Get_Predicate('ra',NULL);

981: /* Set the org conditions */
982:
983: XLA_MO_REPORTING_API.Initialize(p_reporting_level, p_reporting_entity_id, 'AUTO');
984:
985: l_ra_org_where := XLA_MO_REPORTING_API.Get_Predicate('ra',NULL);
986: l_ard_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard',NULL);
987: l_ps_org_where := XLA_MO_REPORTING_API.Get_Predicate('ps',NULL);
988: l_cr_org_where := XLA_MO_REPORTING_API.Get_Predicate('cr',NULL);
989: l_crh_org_where := XLA_MO_REPORTING_API.Get_Predicate('crh',NULL);

Line 986: l_ard_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard',NULL);

982:
983: XLA_MO_REPORTING_API.Initialize(p_reporting_level, p_reporting_entity_id, 'AUTO');
984:
985: l_ra_org_where := XLA_MO_REPORTING_API.Get_Predicate('ra',NULL);
986: l_ard_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard',NULL);
987: l_ps_org_where := XLA_MO_REPORTING_API.Get_Predicate('ps',NULL);
988: l_cr_org_where := XLA_MO_REPORTING_API.Get_Predicate('cr',NULL);
989: l_crh_org_where := XLA_MO_REPORTING_API.Get_Predicate('crh',NULL);
990: l_bat_org_where := XLA_MO_REPORTING_API.Get_Predicate('bat',NULL);

Line 987: l_ps_org_where := XLA_MO_REPORTING_API.Get_Predicate('ps',NULL);

983: XLA_MO_REPORTING_API.Initialize(p_reporting_level, p_reporting_entity_id, 'AUTO');
984:
985: l_ra_org_where := XLA_MO_REPORTING_API.Get_Predicate('ra',NULL);
986: l_ard_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard',NULL);
987: l_ps_org_where := XLA_MO_REPORTING_API.Get_Predicate('ps',NULL);
988: l_cr_org_where := XLA_MO_REPORTING_API.Get_Predicate('cr',NULL);
989: l_crh_org_where := XLA_MO_REPORTING_API.Get_Predicate('crh',NULL);
990: l_bat_org_where := XLA_MO_REPORTING_API.Get_Predicate('bat',NULL);
991: l_bs_org_where := XLA_MO_REPORTING_API.Get_Predicate('bs',NULL);

Line 988: l_cr_org_where := XLA_MO_REPORTING_API.Get_Predicate('cr',NULL);

984:
985: l_ra_org_where := XLA_MO_REPORTING_API.Get_Predicate('ra',NULL);
986: l_ard_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard',NULL);
987: l_ps_org_where := XLA_MO_REPORTING_API.Get_Predicate('ps',NULL);
988: l_cr_org_where := XLA_MO_REPORTING_API.Get_Predicate('cr',NULL);
989: l_crh_org_where := XLA_MO_REPORTING_API.Get_Predicate('crh',NULL);
990: l_bat_org_where := XLA_MO_REPORTING_API.Get_Predicate('bat',NULL);
991: l_bs_org_where := XLA_MO_REPORTING_API.Get_Predicate('bs',NULL);
992: l_sysparam_org_where := XLA_MO_REPORTING_API.Get_Predicate('sysparam',NULL);

Line 989: l_crh_org_where := XLA_MO_REPORTING_API.Get_Predicate('crh',NULL);

985: l_ra_org_where := XLA_MO_REPORTING_API.Get_Predicate('ra',NULL);
986: l_ard_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard',NULL);
987: l_ps_org_where := XLA_MO_REPORTING_API.Get_Predicate('ps',NULL);
988: l_cr_org_where := XLA_MO_REPORTING_API.Get_Predicate('cr',NULL);
989: l_crh_org_where := XLA_MO_REPORTING_API.Get_Predicate('crh',NULL);
990: l_bat_org_where := XLA_MO_REPORTING_API.Get_Predicate('bat',NULL);
991: l_bs_org_where := XLA_MO_REPORTING_API.Get_Predicate('bs',NULL);
992: l_sysparam_org_where := XLA_MO_REPORTING_API.Get_Predicate('sysparam',NULL);
993:

Line 990: l_bat_org_where := XLA_MO_REPORTING_API.Get_Predicate('bat',NULL);

986: l_ard_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard',NULL);
987: l_ps_org_where := XLA_MO_REPORTING_API.Get_Predicate('ps',NULL);
988: l_cr_org_where := XLA_MO_REPORTING_API.Get_Predicate('cr',NULL);
989: l_crh_org_where := XLA_MO_REPORTING_API.Get_Predicate('crh',NULL);
990: l_bat_org_where := XLA_MO_REPORTING_API.Get_Predicate('bat',NULL);
991: l_bs_org_where := XLA_MO_REPORTING_API.Get_Predicate('bs',NULL);
992: l_sysparam_org_where := XLA_MO_REPORTING_API.Get_Predicate('sysparam',NULL);
993:
994: /* Replace the bind variables with global functions */

Line 991: l_bs_org_where := XLA_MO_REPORTING_API.Get_Predicate('bs',NULL);

987: l_ps_org_where := XLA_MO_REPORTING_API.Get_Predicate('ps',NULL);
988: l_cr_org_where := XLA_MO_REPORTING_API.Get_Predicate('cr',NULL);
989: l_crh_org_where := XLA_MO_REPORTING_API.Get_Predicate('crh',NULL);
990: l_bat_org_where := XLA_MO_REPORTING_API.Get_Predicate('bat',NULL);
991: l_bs_org_where := XLA_MO_REPORTING_API.Get_Predicate('bs',NULL);
992: l_sysparam_org_where := XLA_MO_REPORTING_API.Get_Predicate('sysparam',NULL);
993:
994: /* Replace the bind variables with global functions */
995: l_ra_org_where := replace(l_ra_org_where,

Line 992: l_sysparam_org_where := XLA_MO_REPORTING_API.Get_Predicate('sysparam',NULL);

988: l_cr_org_where := XLA_MO_REPORTING_API.Get_Predicate('cr',NULL);
989: l_crh_org_where := XLA_MO_REPORTING_API.Get_Predicate('crh',NULL);
990: l_bat_org_where := XLA_MO_REPORTING_API.Get_Predicate('bat',NULL);
991: l_bs_org_where := XLA_MO_REPORTING_API.Get_Predicate('bs',NULL);
992: l_sysparam_org_where := XLA_MO_REPORTING_API.Get_Predicate('sysparam',NULL);
993:
994: /* Replace the bind variables with global functions */
995: l_ra_org_where := replace(l_ra_org_where,
996: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');

Line 1010: l_reporting_entity_name := substrb(XLA_MO_REPORTING_API.get_reporting_entity_name,1,80);

1006: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
1007: l_bs_org_where := replace(l_bs_org_where,
1008: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
1009:
1010: l_reporting_entity_name := substrb(XLA_MO_REPORTING_API.get_reporting_entity_name,1,80);
1011: l_reporting_level_name := substrb(XLA_MO_REPORTING_API.get_reporting_level_name,1,30);
1012:
1013: /* Multi Org Uptake: Show appropriate message to the user depending upon the security profile */
1014: IF p_reporting_level = '1000' THEN

Line 1011: l_reporting_level_name := substrb(XLA_MO_REPORTING_API.get_reporting_level_name,1,30);

1007: l_bs_org_where := replace(l_bs_org_where,
1008: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
1009:
1010: l_reporting_entity_name := substrb(XLA_MO_REPORTING_API.get_reporting_entity_name,1,80);
1011: l_reporting_level_name := substrb(XLA_MO_REPORTING_API.get_reporting_level_name,1,30);
1012:
1013: /* Multi Org Uptake: Show appropriate message to the user depending upon the security profile */
1014: IF p_reporting_level = '1000' THEN
1015: l_ld_sp:= mo_utils.check_ledger_in_sp(p_reporting_entity_id);

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

1566: init(p_sob_id);
1567:
1568: /* Set the org conditions */
1569:
1570: XLA_MO_REPORTING_API.Initialize(p_reporting_level, p_reporting_entity_id, 'AUTO');
1571:
1572: l_ra_org_where := XLA_MO_REPORTING_API.Get_Predicate('ra',NULL);
1573: l_ard_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard',NULL);
1574: l_ard1_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard1',NULL);

Line 1572: l_ra_org_where := XLA_MO_REPORTING_API.Get_Predicate('ra',NULL);

1568: /* Set the org conditions */
1569:
1570: XLA_MO_REPORTING_API.Initialize(p_reporting_level, p_reporting_entity_id, 'AUTO');
1571:
1572: l_ra_org_where := XLA_MO_REPORTING_API.Get_Predicate('ra',NULL);
1573: l_ard_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard',NULL);
1574: l_ard1_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard1',NULL);
1575: l_ps_org_where := XLA_MO_REPORTING_API.Get_Predicate('ps',NULL);
1576: l_cr_org_where := XLA_MO_REPORTING_API.Get_Predicate('cr',NULL);

Line 1573: l_ard_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard',NULL);

1569:
1570: XLA_MO_REPORTING_API.Initialize(p_reporting_level, p_reporting_entity_id, 'AUTO');
1571:
1572: l_ra_org_where := XLA_MO_REPORTING_API.Get_Predicate('ra',NULL);
1573: l_ard_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard',NULL);
1574: l_ard1_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard1',NULL);
1575: l_ps_org_where := XLA_MO_REPORTING_API.Get_Predicate('ps',NULL);
1576: l_cr_org_where := XLA_MO_REPORTING_API.Get_Predicate('cr',NULL);
1577: l_crh_org_where := XLA_MO_REPORTING_API.Get_Predicate('crh',NULL);

Line 1574: l_ard1_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard1',NULL);

1570: XLA_MO_REPORTING_API.Initialize(p_reporting_level, p_reporting_entity_id, 'AUTO');
1571:
1572: l_ra_org_where := XLA_MO_REPORTING_API.Get_Predicate('ra',NULL);
1573: l_ard_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard',NULL);
1574: l_ard1_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard1',NULL);
1575: l_ps_org_where := XLA_MO_REPORTING_API.Get_Predicate('ps',NULL);
1576: l_cr_org_where := XLA_MO_REPORTING_API.Get_Predicate('cr',NULL);
1577: l_crh_org_where := XLA_MO_REPORTING_API.Get_Predicate('crh',NULL);
1578: l_bat_org_where := XLA_MO_REPORTING_API.Get_Predicate('bat',NULL);

Line 1575: l_ps_org_where := XLA_MO_REPORTING_API.Get_Predicate('ps',NULL);

1571:
1572: l_ra_org_where := XLA_MO_REPORTING_API.Get_Predicate('ra',NULL);
1573: l_ard_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard',NULL);
1574: l_ard1_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard1',NULL);
1575: l_ps_org_where := XLA_MO_REPORTING_API.Get_Predicate('ps',NULL);
1576: l_cr_org_where := XLA_MO_REPORTING_API.Get_Predicate('cr',NULL);
1577: l_crh_org_where := XLA_MO_REPORTING_API.Get_Predicate('crh',NULL);
1578: l_bat_org_where := XLA_MO_REPORTING_API.Get_Predicate('bat',NULL);
1579: l_bs_org_where := XLA_MO_REPORTING_API.Get_Predicate('bs',NULL);

Line 1576: l_cr_org_where := XLA_MO_REPORTING_API.Get_Predicate('cr',NULL);

1572: l_ra_org_where := XLA_MO_REPORTING_API.Get_Predicate('ra',NULL);
1573: l_ard_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard',NULL);
1574: l_ard1_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard1',NULL);
1575: l_ps_org_where := XLA_MO_REPORTING_API.Get_Predicate('ps',NULL);
1576: l_cr_org_where := XLA_MO_REPORTING_API.Get_Predicate('cr',NULL);
1577: l_crh_org_where := XLA_MO_REPORTING_API.Get_Predicate('crh',NULL);
1578: l_bat_org_where := XLA_MO_REPORTING_API.Get_Predicate('bat',NULL);
1579: l_bs_org_where := XLA_MO_REPORTING_API.Get_Predicate('bs',NULL);
1580: l_sysparam_org_where := XLA_MO_REPORTING_API.Get_Predicate('sysparam',NULL);

Line 1577: l_crh_org_where := XLA_MO_REPORTING_API.Get_Predicate('crh',NULL);

1573: l_ard_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard',NULL);
1574: l_ard1_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard1',NULL);
1575: l_ps_org_where := XLA_MO_REPORTING_API.Get_Predicate('ps',NULL);
1576: l_cr_org_where := XLA_MO_REPORTING_API.Get_Predicate('cr',NULL);
1577: l_crh_org_where := XLA_MO_REPORTING_API.Get_Predicate('crh',NULL);
1578: l_bat_org_where := XLA_MO_REPORTING_API.Get_Predicate('bat',NULL);
1579: l_bs_org_where := XLA_MO_REPORTING_API.Get_Predicate('bs',NULL);
1580: l_sysparam_org_where := XLA_MO_REPORTING_API.Get_Predicate('sysparam',NULL);
1581:

Line 1578: l_bat_org_where := XLA_MO_REPORTING_API.Get_Predicate('bat',NULL);

1574: l_ard1_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard1',NULL);
1575: l_ps_org_where := XLA_MO_REPORTING_API.Get_Predicate('ps',NULL);
1576: l_cr_org_where := XLA_MO_REPORTING_API.Get_Predicate('cr',NULL);
1577: l_crh_org_where := XLA_MO_REPORTING_API.Get_Predicate('crh',NULL);
1578: l_bat_org_where := XLA_MO_REPORTING_API.Get_Predicate('bat',NULL);
1579: l_bs_org_where := XLA_MO_REPORTING_API.Get_Predicate('bs',NULL);
1580: l_sysparam_org_where := XLA_MO_REPORTING_API.Get_Predicate('sysparam',NULL);
1581:
1582: /* Replace the bind variables with global functions */

Line 1579: l_bs_org_where := XLA_MO_REPORTING_API.Get_Predicate('bs',NULL);

1575: l_ps_org_where := XLA_MO_REPORTING_API.Get_Predicate('ps',NULL);
1576: l_cr_org_where := XLA_MO_REPORTING_API.Get_Predicate('cr',NULL);
1577: l_crh_org_where := XLA_MO_REPORTING_API.Get_Predicate('crh',NULL);
1578: l_bat_org_where := XLA_MO_REPORTING_API.Get_Predicate('bat',NULL);
1579: l_bs_org_where := XLA_MO_REPORTING_API.Get_Predicate('bs',NULL);
1580: l_sysparam_org_where := XLA_MO_REPORTING_API.Get_Predicate('sysparam',NULL);
1581:
1582: /* Replace the bind variables with global functions */
1583: l_ra_org_where := replace(l_ra_org_where,

Line 1580: l_sysparam_org_where := XLA_MO_REPORTING_API.Get_Predicate('sysparam',NULL);

1576: l_cr_org_where := XLA_MO_REPORTING_API.Get_Predicate('cr',NULL);
1577: l_crh_org_where := XLA_MO_REPORTING_API.Get_Predicate('crh',NULL);
1578: l_bat_org_where := XLA_MO_REPORTING_API.Get_Predicate('bat',NULL);
1579: l_bs_org_where := XLA_MO_REPORTING_API.Get_Predicate('bs',NULL);
1580: l_sysparam_org_where := XLA_MO_REPORTING_API.Get_Predicate('sysparam',NULL);
1581:
1582: /* Replace the bind variables with global functions */
1583: l_ra_org_where := replace(l_ra_org_where,
1584: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');

Line 1603: l_reporting_entity_name := substrb(XLA_MO_REPORTING_API.get_reporting_entity_name,1,80);

1599: l_sysparam_org_where := replace(l_sysparam_org_where,
1600: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
1601:
1602:
1603: l_reporting_entity_name := substrb(XLA_MO_REPORTING_API.get_reporting_entity_name,1,80);
1604: l_reporting_level_name := substrb(XLA_MO_REPORTING_API.get_reporting_level_name,1,30);
1605:
1606: /* Multi Org Uptake: Show appropriate message to the user depending upon the security profile */
1607: IF p_reporting_level = '1000' THEN

Line 1604: l_reporting_level_name := substrb(XLA_MO_REPORTING_API.get_reporting_level_name,1,30);

1600: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
1601:
1602:
1603: l_reporting_entity_name := substrb(XLA_MO_REPORTING_API.get_reporting_entity_name,1,80);
1604: l_reporting_level_name := substrb(XLA_MO_REPORTING_API.get_reporting_level_name,1,30);
1605:
1606: /* Multi Org Uptake: Show appropriate message to the user depending upon the security profile */
1607: IF p_reporting_level = '1000' THEN
1608: l_ld_sp:= mo_utils.check_ledger_in_sp(p_reporting_entity_id);

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

2078: init(p_sob_id);
2079:
2080: /* Set the org conditions */
2081:
2082: XLA_MO_REPORTING_API.Initialize(p_reporting_level, p_reporting_entity_id, 'AUTO');
2083:
2084: l_ra_org_where := XLA_MO_REPORTING_API.Get_Predicate('ra',NULL);
2085: l_ard_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard',NULL);
2086: l_ps_org_where := XLA_MO_REPORTING_API.Get_Predicate('ps',NULL);

Line 2084: l_ra_org_where := XLA_MO_REPORTING_API.Get_Predicate('ra',NULL);

2080: /* Set the org conditions */
2081:
2082: XLA_MO_REPORTING_API.Initialize(p_reporting_level, p_reporting_entity_id, 'AUTO');
2083:
2084: l_ra_org_where := XLA_MO_REPORTING_API.Get_Predicate('ra',NULL);
2085: l_ard_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard',NULL);
2086: l_ps_org_where := XLA_MO_REPORTING_API.Get_Predicate('ps',NULL);
2087: l_ps1_org_where := XLA_MO_REPORTING_API.Get_Predicate('ps1',NULL);
2088: l_sysparam_org_where := XLA_MO_REPORTING_API.Get_Predicate('sysparam',NULL);

Line 2085: l_ard_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard',NULL);

2081:
2082: XLA_MO_REPORTING_API.Initialize(p_reporting_level, p_reporting_entity_id, 'AUTO');
2083:
2084: l_ra_org_where := XLA_MO_REPORTING_API.Get_Predicate('ra',NULL);
2085: l_ard_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard',NULL);
2086: l_ps_org_where := XLA_MO_REPORTING_API.Get_Predicate('ps',NULL);
2087: l_ps1_org_where := XLA_MO_REPORTING_API.Get_Predicate('ps1',NULL);
2088: l_sysparam_org_where := XLA_MO_REPORTING_API.Get_Predicate('sysparam',NULL);
2089:

Line 2086: l_ps_org_where := XLA_MO_REPORTING_API.Get_Predicate('ps',NULL);

2082: XLA_MO_REPORTING_API.Initialize(p_reporting_level, p_reporting_entity_id, 'AUTO');
2083:
2084: l_ra_org_where := XLA_MO_REPORTING_API.Get_Predicate('ra',NULL);
2085: l_ard_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard',NULL);
2086: l_ps_org_where := XLA_MO_REPORTING_API.Get_Predicate('ps',NULL);
2087: l_ps1_org_where := XLA_MO_REPORTING_API.Get_Predicate('ps1',NULL);
2088: l_sysparam_org_where := XLA_MO_REPORTING_API.Get_Predicate('sysparam',NULL);
2089:
2090:

Line 2087: l_ps1_org_where := XLA_MO_REPORTING_API.Get_Predicate('ps1',NULL);

2083:
2084: l_ra_org_where := XLA_MO_REPORTING_API.Get_Predicate('ra',NULL);
2085: l_ard_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard',NULL);
2086: l_ps_org_where := XLA_MO_REPORTING_API.Get_Predicate('ps',NULL);
2087: l_ps1_org_where := XLA_MO_REPORTING_API.Get_Predicate('ps1',NULL);
2088: l_sysparam_org_where := XLA_MO_REPORTING_API.Get_Predicate('sysparam',NULL);
2089:
2090:
2091: /* Replace the bind variables with global functions */

Line 2088: l_sysparam_org_where := XLA_MO_REPORTING_API.Get_Predicate('sysparam',NULL);

2084: l_ra_org_where := XLA_MO_REPORTING_API.Get_Predicate('ra',NULL);
2085: l_ard_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard',NULL);
2086: l_ps_org_where := XLA_MO_REPORTING_API.Get_Predicate('ps',NULL);
2087: l_ps1_org_where := XLA_MO_REPORTING_API.Get_Predicate('ps1',NULL);
2088: l_sysparam_org_where := XLA_MO_REPORTING_API.Get_Predicate('sysparam',NULL);
2089:
2090:
2091: /* Replace the bind variables with global functions */
2092: l_ra_org_where := replace(l_ra_org_where,

Line 2102: l_reporting_entity_name := substrb(XLA_MO_REPORTING_API.get_reporting_entity_name,1,80);

2098: l_ps1_org_where := replace(l_ps1_org_where,
2099: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
2100: l_sysparam_org_where := replace(l_sysparam_org_where,
2101: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
2102: l_reporting_entity_name := substrb(XLA_MO_REPORTING_API.get_reporting_entity_name,1,80);
2103: l_reporting_level_name := substrb(XLA_MO_REPORTING_API.get_reporting_level_name,1,30);
2104:
2105: /* Multi Org Uptake: Show appropriate message to the user depending upon the security profile */
2106: IF p_reporting_level = '1000' THEN

Line 2103: l_reporting_level_name := substrb(XLA_MO_REPORTING_API.get_reporting_level_name,1,30);

2099: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
2100: l_sysparam_org_where := replace(l_sysparam_org_where,
2101: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
2102: l_reporting_entity_name := substrb(XLA_MO_REPORTING_API.get_reporting_entity_name,1,80);
2103: l_reporting_level_name := substrb(XLA_MO_REPORTING_API.get_reporting_level_name,1,30);
2104:
2105: /* Multi Org Uptake: Show appropriate message to the user depending upon the security profile */
2106: IF p_reporting_level = '1000' THEN
2107: l_ld_sp:= mo_utils.check_ledger_in_sp(p_reporting_entity_id);

Line 2515: XLA_MO_REPORTING_API.Initialize(1000,p_reporting_entity_id, 'AUTO');

2511: init(p_sob_id);
2512:
2513: /* Set the org conditions */
2514:
2515: XLA_MO_REPORTING_API.Initialize(1000,p_reporting_entity_id, 'AUTO');
2516:
2517: l_ra_org_where := XLA_MO_REPORTING_API.Get_Predicate('ra',NULL);
2518: l_adj_org_where := XLA_MO_REPORTING_API.Get_Predicate('adj',NULL);
2519: l_ard_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard',NULL);

Line 2517: l_ra_org_where := XLA_MO_REPORTING_API.Get_Predicate('ra',NULL);

2513: /* Set the org conditions */
2514:
2515: XLA_MO_REPORTING_API.Initialize(1000,p_reporting_entity_id, 'AUTO');
2516:
2517: l_ra_org_where := XLA_MO_REPORTING_API.Get_Predicate('ra',NULL);
2518: l_adj_org_where := XLA_MO_REPORTING_API.Get_Predicate('adj',NULL);
2519: l_ard_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard',NULL);
2520: l_gl_dist_org_where := XLA_MO_REPORTING_API.Get_Predicate('gl_dist',NULL);
2521: l_sysparam_org_where := XLA_MO_REPORTING_API.Get_Predicate('sysparam',NULL);

Line 2518: l_adj_org_where := XLA_MO_REPORTING_API.Get_Predicate('adj',NULL);

2514:
2515: XLA_MO_REPORTING_API.Initialize(1000,p_reporting_entity_id, 'AUTO');
2516:
2517: l_ra_org_where := XLA_MO_REPORTING_API.Get_Predicate('ra',NULL);
2518: l_adj_org_where := XLA_MO_REPORTING_API.Get_Predicate('adj',NULL);
2519: l_ard_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard',NULL);
2520: l_gl_dist_org_where := XLA_MO_REPORTING_API.Get_Predicate('gl_dist',NULL);
2521: l_sysparam_org_where := XLA_MO_REPORTING_API.Get_Predicate('sysparam',NULL);
2522: l_mcd_org_where := XLA_MO_REPORTING_API.Get_Predicate('mcd',NULL);

Line 2519: l_ard_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard',NULL);

2515: XLA_MO_REPORTING_API.Initialize(1000,p_reporting_entity_id, 'AUTO');
2516:
2517: l_ra_org_where := XLA_MO_REPORTING_API.Get_Predicate('ra',NULL);
2518: l_adj_org_where := XLA_MO_REPORTING_API.Get_Predicate('adj',NULL);
2519: l_ard_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard',NULL);
2520: l_gl_dist_org_where := XLA_MO_REPORTING_API.Get_Predicate('gl_dist',NULL);
2521: l_sysparam_org_where := XLA_MO_REPORTING_API.Get_Predicate('sysparam',NULL);
2522: l_mcd_org_where := XLA_MO_REPORTING_API.Get_Predicate('mcd',NULL);
2523: l_crh_org_where := XLA_MO_REPORTING_API.Get_Predicate('crh',NULL);

Line 2520: l_gl_dist_org_where := XLA_MO_REPORTING_API.Get_Predicate('gl_dist',NULL);

2516:
2517: l_ra_org_where := XLA_MO_REPORTING_API.Get_Predicate('ra',NULL);
2518: l_adj_org_where := XLA_MO_REPORTING_API.Get_Predicate('adj',NULL);
2519: l_ard_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard',NULL);
2520: l_gl_dist_org_where := XLA_MO_REPORTING_API.Get_Predicate('gl_dist',NULL);
2521: l_sysparam_org_where := XLA_MO_REPORTING_API.Get_Predicate('sysparam',NULL);
2522: l_mcd_org_where := XLA_MO_REPORTING_API.Get_Predicate('mcd',NULL);
2523: l_crh_org_where := XLA_MO_REPORTING_API.Get_Predicate('crh',NULL);
2524: l_cr_org_where := XLA_MO_REPORTING_API.Get_Predicate('cr',NULL); /* Bug fix 6432847 */

Line 2521: l_sysparam_org_where := XLA_MO_REPORTING_API.Get_Predicate('sysparam',NULL);

2517: l_ra_org_where := XLA_MO_REPORTING_API.Get_Predicate('ra',NULL);
2518: l_adj_org_where := XLA_MO_REPORTING_API.Get_Predicate('adj',NULL);
2519: l_ard_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard',NULL);
2520: l_gl_dist_org_where := XLA_MO_REPORTING_API.Get_Predicate('gl_dist',NULL);
2521: l_sysparam_org_where := XLA_MO_REPORTING_API.Get_Predicate('sysparam',NULL);
2522: l_mcd_org_where := XLA_MO_REPORTING_API.Get_Predicate('mcd',NULL);
2523: l_crh_org_where := XLA_MO_REPORTING_API.Get_Predicate('crh',NULL);
2524: l_cr_org_where := XLA_MO_REPORTING_API.Get_Predicate('cr',NULL); /* Bug fix 6432847 */
2525: l_ath_org_where := XLA_MO_REPORTING_API.Get_Predicate('ath',NULL);

Line 2522: l_mcd_org_where := XLA_MO_REPORTING_API.Get_Predicate('mcd',NULL);

2518: l_adj_org_where := XLA_MO_REPORTING_API.Get_Predicate('adj',NULL);
2519: l_ard_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard',NULL);
2520: l_gl_dist_org_where := XLA_MO_REPORTING_API.Get_Predicate('gl_dist',NULL);
2521: l_sysparam_org_where := XLA_MO_REPORTING_API.Get_Predicate('sysparam',NULL);
2522: l_mcd_org_where := XLA_MO_REPORTING_API.Get_Predicate('mcd',NULL);
2523: l_crh_org_where := XLA_MO_REPORTING_API.Get_Predicate('crh',NULL);
2524: l_cr_org_where := XLA_MO_REPORTING_API.Get_Predicate('cr',NULL); /* Bug fix 6432847 */
2525: l_ath_org_where := XLA_MO_REPORTING_API.Get_Predicate('ath',NULL);
2526:

Line 2523: l_crh_org_where := XLA_MO_REPORTING_API.Get_Predicate('crh',NULL);

2519: l_ard_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard',NULL);
2520: l_gl_dist_org_where := XLA_MO_REPORTING_API.Get_Predicate('gl_dist',NULL);
2521: l_sysparam_org_where := XLA_MO_REPORTING_API.Get_Predicate('sysparam',NULL);
2522: l_mcd_org_where := XLA_MO_REPORTING_API.Get_Predicate('mcd',NULL);
2523: l_crh_org_where := XLA_MO_REPORTING_API.Get_Predicate('crh',NULL);
2524: l_cr_org_where := XLA_MO_REPORTING_API.Get_Predicate('cr',NULL); /* Bug fix 6432847 */
2525: l_ath_org_where := XLA_MO_REPORTING_API.Get_Predicate('ath',NULL);
2526:
2527: /* Replace the bind variables with global functions */

Line 2524: l_cr_org_where := XLA_MO_REPORTING_API.Get_Predicate('cr',NULL); /* Bug fix 6432847 */

2520: l_gl_dist_org_where := XLA_MO_REPORTING_API.Get_Predicate('gl_dist',NULL);
2521: l_sysparam_org_where := XLA_MO_REPORTING_API.Get_Predicate('sysparam',NULL);
2522: l_mcd_org_where := XLA_MO_REPORTING_API.Get_Predicate('mcd',NULL);
2523: l_crh_org_where := XLA_MO_REPORTING_API.Get_Predicate('crh',NULL);
2524: l_cr_org_where := XLA_MO_REPORTING_API.Get_Predicate('cr',NULL); /* Bug fix 6432847 */
2525: l_ath_org_where := XLA_MO_REPORTING_API.Get_Predicate('ath',NULL);
2526:
2527: /* Replace the bind variables with global functions */
2528: l_ra_org_where := replace(l_ra_org_where,

Line 2525: l_ath_org_where := XLA_MO_REPORTING_API.Get_Predicate('ath',NULL);

2521: l_sysparam_org_where := XLA_MO_REPORTING_API.Get_Predicate('sysparam',NULL);
2522: l_mcd_org_where := XLA_MO_REPORTING_API.Get_Predicate('mcd',NULL);
2523: l_crh_org_where := XLA_MO_REPORTING_API.Get_Predicate('crh',NULL);
2524: l_cr_org_where := XLA_MO_REPORTING_API.Get_Predicate('cr',NULL); /* Bug fix 6432847 */
2525: l_ath_org_where := XLA_MO_REPORTING_API.Get_Predicate('ath',NULL);
2526:
2527: /* Replace the bind variables with global functions */
2528: l_ra_org_where := replace(l_ra_org_where,
2529: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');

Line 2548: l_reporting_entity_name := substrb(XLA_MO_REPORTING_API.get_reporting_entity_name,1,80);

2544: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
2545: l_ath_org_where := replace(l_ath_org_where,
2546: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
2547:
2548: l_reporting_entity_name := substrb(XLA_MO_REPORTING_API.get_reporting_entity_name,1,80);
2549: l_reporting_level_name := substrb(XLA_MO_REPORTING_API.get_reporting_level_name,1,30);
2550:
2551: /* Get the org name */
2552: select meaning

Line 2549: l_reporting_level_name := substrb(XLA_MO_REPORTING_API.get_reporting_level_name,1,30);

2545: l_ath_org_where := replace(l_ath_org_where,
2546: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
2547:
2548: l_reporting_entity_name := substrb(XLA_MO_REPORTING_API.get_reporting_entity_name,1,80);
2549: l_reporting_level_name := substrb(XLA_MO_REPORTING_API.get_reporting_level_name,1,30);
2550:
2551: /* Get the org name */
2552: select meaning
2553: into l_organization