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 472: XLA_MO_REPORTING_API.Initialize(p_reporting_level,

468: /* Initialize the reporting context */
469: init(p_sob_id);
470:
471: /* Set the org conditions */
472: XLA_MO_REPORTING_API.Initialize(p_reporting_level,
473: p_reporting_entity_id,
474: 'AUTO',
475: 'N' /* use NVL */);
476:

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

473: p_reporting_entity_id,
474: 'AUTO',
475: 'N' /* use NVL */);
476:
477: l_adj_org_where := XLA_MO_REPORTING_API.Get_Predicate('adj',NULL);
478: l_ard_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard',NULL);
479: l_trx_org_where := XLA_MO_REPORTING_API.Get_Predicate('trx',NULL);
480: l_pay_org_where := XLA_MO_REPORTING_API.Get_Predicate('pay',NULL);
481: l_rec_org_where := XLA_MO_REPORTING_API.Get_Predicate('rec',NULL);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

995: init(p_sob_id);
996:
997: /* Set the org conditions */
998:
999: XLA_MO_REPORTING_API.Initialize(p_reporting_level, p_reporting_entity_id, 'AUTO');
1000:
1001: l_ra_org_where := XLA_MO_REPORTING_API.Get_Predicate('ra',NULL);
1002: l_ard_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard',NULL);
1003: l_ps_org_where := XLA_MO_REPORTING_API.Get_Predicate('ps',NULL);

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

997: /* Set the org conditions */
998:
999: XLA_MO_REPORTING_API.Initialize(p_reporting_level, p_reporting_entity_id, 'AUTO');
1000:
1001: l_ra_org_where := XLA_MO_REPORTING_API.Get_Predicate('ra',NULL);
1002: l_ard_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard',NULL);
1003: l_ps_org_where := XLA_MO_REPORTING_API.Get_Predicate('ps',NULL);
1004: l_cr_org_where := XLA_MO_REPORTING_API.Get_Predicate('cr',NULL);
1005: l_crh_org_where := XLA_MO_REPORTING_API.Get_Predicate('crh',NULL);

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

998:
999: XLA_MO_REPORTING_API.Initialize(p_reporting_level, p_reporting_entity_id, 'AUTO');
1000:
1001: l_ra_org_where := XLA_MO_REPORTING_API.Get_Predicate('ra',NULL);
1002: l_ard_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard',NULL);
1003: l_ps_org_where := XLA_MO_REPORTING_API.Get_Predicate('ps',NULL);
1004: l_cr_org_where := XLA_MO_REPORTING_API.Get_Predicate('cr',NULL);
1005: l_crh_org_where := XLA_MO_REPORTING_API.Get_Predicate('crh',NULL);
1006: l_bat_org_where := XLA_MO_REPORTING_API.Get_Predicate('bat',NULL);

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

999: XLA_MO_REPORTING_API.Initialize(p_reporting_level, p_reporting_entity_id, 'AUTO');
1000:
1001: l_ra_org_where := XLA_MO_REPORTING_API.Get_Predicate('ra',NULL);
1002: l_ard_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard',NULL);
1003: l_ps_org_where := XLA_MO_REPORTING_API.Get_Predicate('ps',NULL);
1004: l_cr_org_where := XLA_MO_REPORTING_API.Get_Predicate('cr',NULL);
1005: l_crh_org_where := XLA_MO_REPORTING_API.Get_Predicate('crh',NULL);
1006: l_bat_org_where := XLA_MO_REPORTING_API.Get_Predicate('bat',NULL);
1007: l_bs_org_where := XLA_MO_REPORTING_API.Get_Predicate('bs',NULL);

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

1000:
1001: l_ra_org_where := XLA_MO_REPORTING_API.Get_Predicate('ra',NULL);
1002: l_ard_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard',NULL);
1003: l_ps_org_where := XLA_MO_REPORTING_API.Get_Predicate('ps',NULL);
1004: l_cr_org_where := XLA_MO_REPORTING_API.Get_Predicate('cr',NULL);
1005: l_crh_org_where := XLA_MO_REPORTING_API.Get_Predicate('crh',NULL);
1006: l_bat_org_where := XLA_MO_REPORTING_API.Get_Predicate('bat',NULL);
1007: l_bs_org_where := XLA_MO_REPORTING_API.Get_Predicate('bs',NULL);
1008: l_sysparam_org_where := XLA_MO_REPORTING_API.Get_Predicate('sysparam',NULL);

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

1001: l_ra_org_where := XLA_MO_REPORTING_API.Get_Predicate('ra',NULL);
1002: l_ard_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard',NULL);
1003: l_ps_org_where := XLA_MO_REPORTING_API.Get_Predicate('ps',NULL);
1004: l_cr_org_where := XLA_MO_REPORTING_API.Get_Predicate('cr',NULL);
1005: l_crh_org_where := XLA_MO_REPORTING_API.Get_Predicate('crh',NULL);
1006: l_bat_org_where := XLA_MO_REPORTING_API.Get_Predicate('bat',NULL);
1007: l_bs_org_where := XLA_MO_REPORTING_API.Get_Predicate('bs',NULL);
1008: l_sysparam_org_where := XLA_MO_REPORTING_API.Get_Predicate('sysparam',NULL);
1009:

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

1002: l_ard_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard',NULL);
1003: l_ps_org_where := XLA_MO_REPORTING_API.Get_Predicate('ps',NULL);
1004: l_cr_org_where := XLA_MO_REPORTING_API.Get_Predicate('cr',NULL);
1005: l_crh_org_where := XLA_MO_REPORTING_API.Get_Predicate('crh',NULL);
1006: l_bat_org_where := XLA_MO_REPORTING_API.Get_Predicate('bat',NULL);
1007: l_bs_org_where := XLA_MO_REPORTING_API.Get_Predicate('bs',NULL);
1008: l_sysparam_org_where := XLA_MO_REPORTING_API.Get_Predicate('sysparam',NULL);
1009:
1010: /* Replace the bind variables with global functions */

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

1003: l_ps_org_where := XLA_MO_REPORTING_API.Get_Predicate('ps',NULL);
1004: l_cr_org_where := XLA_MO_REPORTING_API.Get_Predicate('cr',NULL);
1005: l_crh_org_where := XLA_MO_REPORTING_API.Get_Predicate('crh',NULL);
1006: l_bat_org_where := XLA_MO_REPORTING_API.Get_Predicate('bat',NULL);
1007: l_bs_org_where := XLA_MO_REPORTING_API.Get_Predicate('bs',NULL);
1008: l_sysparam_org_where := XLA_MO_REPORTING_API.Get_Predicate('sysparam',NULL);
1009:
1010: /* Replace the bind variables with global functions */
1011: l_ra_org_where := replace(l_ra_org_where,

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

1004: l_cr_org_where := XLA_MO_REPORTING_API.Get_Predicate('cr',NULL);
1005: l_crh_org_where := XLA_MO_REPORTING_API.Get_Predicate('crh',NULL);
1006: l_bat_org_where := XLA_MO_REPORTING_API.Get_Predicate('bat',NULL);
1007: l_bs_org_where := XLA_MO_REPORTING_API.Get_Predicate('bs',NULL);
1008: l_sysparam_org_where := XLA_MO_REPORTING_API.Get_Predicate('sysparam',NULL);
1009:
1010: /* Replace the bind variables with global functions */
1011: l_ra_org_where := replace(l_ra_org_where,
1012: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');

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

1022: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
1023: l_bs_org_where := replace(l_bs_org_where,
1024: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
1025:
1026: l_reporting_entity_name := substrb(XLA_MO_REPORTING_API.get_reporting_entity_name,1,80);
1027: l_reporting_level_name := substrb(XLA_MO_REPORTING_API.get_reporting_level_name,1,30);
1028:
1029: /* Multi Org Uptake: Show appropriate message to the user depending upon the security profile */
1030: IF p_reporting_level = '1000' THEN

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

1023: l_bs_org_where := replace(l_bs_org_where,
1024: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
1025:
1026: l_reporting_entity_name := substrb(XLA_MO_REPORTING_API.get_reporting_entity_name,1,80);
1027: l_reporting_level_name := substrb(XLA_MO_REPORTING_API.get_reporting_level_name,1,30);
1028:
1029: /* Multi Org Uptake: Show appropriate message to the user depending upon the security profile */
1030: IF p_reporting_level = '1000' THEN
1031: l_ld_sp:= mo_utils.check_ledger_in_sp(p_reporting_entity_id);

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

2206: init(p_sob_id);
2207:
2208: /* Set the org conditions */
2209:
2210: XLA_MO_REPORTING_API.Initialize(p_reporting_level, p_reporting_entity_id, 'AUTO');
2211:
2212: l_ra_org_where := XLA_MO_REPORTING_API.Get_Predicate('ra',NULL);
2213: l_ard_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard',NULL);
2214: l_ard1_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard1',NULL);

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

2208: /* Set the org conditions */
2209:
2210: XLA_MO_REPORTING_API.Initialize(p_reporting_level, p_reporting_entity_id, 'AUTO');
2211:
2212: l_ra_org_where := XLA_MO_REPORTING_API.Get_Predicate('ra',NULL);
2213: l_ard_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard',NULL);
2214: l_ard1_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard1',NULL);
2215: l_ps_org_where := XLA_MO_REPORTING_API.Get_Predicate('ps',NULL);
2216: l_cr_org_where := XLA_MO_REPORTING_API.Get_Predicate('cr',NULL);

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

2209:
2210: XLA_MO_REPORTING_API.Initialize(p_reporting_level, p_reporting_entity_id, 'AUTO');
2211:
2212: l_ra_org_where := XLA_MO_REPORTING_API.Get_Predicate('ra',NULL);
2213: l_ard_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard',NULL);
2214: l_ard1_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard1',NULL);
2215: l_ps_org_where := XLA_MO_REPORTING_API.Get_Predicate('ps',NULL);
2216: l_cr_org_where := XLA_MO_REPORTING_API.Get_Predicate('cr',NULL);
2217: l_crh_org_where := XLA_MO_REPORTING_API.Get_Predicate('crh',NULL);

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

2210: XLA_MO_REPORTING_API.Initialize(p_reporting_level, p_reporting_entity_id, 'AUTO');
2211:
2212: l_ra_org_where := XLA_MO_REPORTING_API.Get_Predicate('ra',NULL);
2213: l_ard_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard',NULL);
2214: l_ard1_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard1',NULL);
2215: l_ps_org_where := XLA_MO_REPORTING_API.Get_Predicate('ps',NULL);
2216: l_cr_org_where := XLA_MO_REPORTING_API.Get_Predicate('cr',NULL);
2217: l_crh_org_where := XLA_MO_REPORTING_API.Get_Predicate('crh',NULL);
2218: l_bat_org_where := XLA_MO_REPORTING_API.Get_Predicate('bat',NULL);

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

2211:
2212: l_ra_org_where := XLA_MO_REPORTING_API.Get_Predicate('ra',NULL);
2213: l_ard_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard',NULL);
2214: l_ard1_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard1',NULL);
2215: l_ps_org_where := XLA_MO_REPORTING_API.Get_Predicate('ps',NULL);
2216: l_cr_org_where := XLA_MO_REPORTING_API.Get_Predicate('cr',NULL);
2217: l_crh_org_where := XLA_MO_REPORTING_API.Get_Predicate('crh',NULL);
2218: l_bat_org_where := XLA_MO_REPORTING_API.Get_Predicate('bat',NULL);
2219: l_bs_org_where := XLA_MO_REPORTING_API.Get_Predicate('bs',NULL);

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

2212: l_ra_org_where := XLA_MO_REPORTING_API.Get_Predicate('ra',NULL);
2213: l_ard_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard',NULL);
2214: l_ard1_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard1',NULL);
2215: l_ps_org_where := XLA_MO_REPORTING_API.Get_Predicate('ps',NULL);
2216: l_cr_org_where := XLA_MO_REPORTING_API.Get_Predicate('cr',NULL);
2217: l_crh_org_where := XLA_MO_REPORTING_API.Get_Predicate('crh',NULL);
2218: l_bat_org_where := XLA_MO_REPORTING_API.Get_Predicate('bat',NULL);
2219: l_bs_org_where := XLA_MO_REPORTING_API.Get_Predicate('bs',NULL);
2220: l_sysparam_org_where := XLA_MO_REPORTING_API.Get_Predicate('sysparam',NULL);

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

2213: l_ard_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard',NULL);
2214: l_ard1_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard1',NULL);
2215: l_ps_org_where := XLA_MO_REPORTING_API.Get_Predicate('ps',NULL);
2216: l_cr_org_where := XLA_MO_REPORTING_API.Get_Predicate('cr',NULL);
2217: l_crh_org_where := XLA_MO_REPORTING_API.Get_Predicate('crh',NULL);
2218: l_bat_org_where := XLA_MO_REPORTING_API.Get_Predicate('bat',NULL);
2219: l_bs_org_where := XLA_MO_REPORTING_API.Get_Predicate('bs',NULL);
2220: l_sysparam_org_where := XLA_MO_REPORTING_API.Get_Predicate('sysparam',NULL);
2221:

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

2214: l_ard1_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard1',NULL);
2215: l_ps_org_where := XLA_MO_REPORTING_API.Get_Predicate('ps',NULL);
2216: l_cr_org_where := XLA_MO_REPORTING_API.Get_Predicate('cr',NULL);
2217: l_crh_org_where := XLA_MO_REPORTING_API.Get_Predicate('crh',NULL);
2218: l_bat_org_where := XLA_MO_REPORTING_API.Get_Predicate('bat',NULL);
2219: l_bs_org_where := XLA_MO_REPORTING_API.Get_Predicate('bs',NULL);
2220: l_sysparam_org_where := XLA_MO_REPORTING_API.Get_Predicate('sysparam',NULL);
2221:
2222: /* Replace the bind variables with global functions */

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

2215: l_ps_org_where := XLA_MO_REPORTING_API.Get_Predicate('ps',NULL);
2216: l_cr_org_where := XLA_MO_REPORTING_API.Get_Predicate('cr',NULL);
2217: l_crh_org_where := XLA_MO_REPORTING_API.Get_Predicate('crh',NULL);
2218: l_bat_org_where := XLA_MO_REPORTING_API.Get_Predicate('bat',NULL);
2219: l_bs_org_where := XLA_MO_REPORTING_API.Get_Predicate('bs',NULL);
2220: l_sysparam_org_where := XLA_MO_REPORTING_API.Get_Predicate('sysparam',NULL);
2221:
2222: /* Replace the bind variables with global functions */
2223: l_ra_org_where := replace(l_ra_org_where,

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

2216: l_cr_org_where := XLA_MO_REPORTING_API.Get_Predicate('cr',NULL);
2217: l_crh_org_where := XLA_MO_REPORTING_API.Get_Predicate('crh',NULL);
2218: l_bat_org_where := XLA_MO_REPORTING_API.Get_Predicate('bat',NULL);
2219: l_bs_org_where := XLA_MO_REPORTING_API.Get_Predicate('bs',NULL);
2220: l_sysparam_org_where := XLA_MO_REPORTING_API.Get_Predicate('sysparam',NULL);
2221:
2222: /* Replace the bind variables with global functions */
2223: l_ra_org_where := replace(l_ra_org_where,
2224: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');

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

2239: l_sysparam_org_where := replace(l_sysparam_org_where,
2240: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
2241:
2242:
2243: l_reporting_entity_name := substrb(XLA_MO_REPORTING_API.get_reporting_entity_name,1,80);
2244: l_reporting_level_name := substrb(XLA_MO_REPORTING_API.get_reporting_level_name,1,30);
2245:
2246: /* Multi Org Uptake: Show appropriate message to the user depending upon the security profile */
2247: IF p_reporting_level = '1000' THEN

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

2240: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
2241:
2242:
2243: l_reporting_entity_name := substrb(XLA_MO_REPORTING_API.get_reporting_entity_name,1,80);
2244: l_reporting_level_name := substrb(XLA_MO_REPORTING_API.get_reporting_level_name,1,30);
2245:
2246: /* Multi Org Uptake: Show appropriate message to the user depending upon the security profile */
2247: IF p_reporting_level = '1000' THEN
2248: l_ld_sp:= mo_utils.check_ledger_in_sp(p_reporting_entity_id);

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

3291: init(p_sob_id);
3292:
3293: /* Set the org conditions */
3294:
3295: XLA_MO_REPORTING_API.Initialize(p_reporting_level, p_reporting_entity_id, 'AUTO');
3296:
3297: l_ra_org_where := XLA_MO_REPORTING_API.Get_Predicate('ra',NULL);
3298: l_ard_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard',NULL);
3299: l_ps_org_where := XLA_MO_REPORTING_API.Get_Predicate('ps',NULL);

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

3293: /* Set the org conditions */
3294:
3295: XLA_MO_REPORTING_API.Initialize(p_reporting_level, p_reporting_entity_id, 'AUTO');
3296:
3297: l_ra_org_where := XLA_MO_REPORTING_API.Get_Predicate('ra',NULL);
3298: l_ard_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard',NULL);
3299: l_ps_org_where := XLA_MO_REPORTING_API.Get_Predicate('ps',NULL);
3300: l_ps1_org_where := XLA_MO_REPORTING_API.Get_Predicate('ps1',NULL);
3301: l_sysparam_org_where := XLA_MO_REPORTING_API.Get_Predicate('sysparam',NULL);

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

3294:
3295: XLA_MO_REPORTING_API.Initialize(p_reporting_level, p_reporting_entity_id, 'AUTO');
3296:
3297: l_ra_org_where := XLA_MO_REPORTING_API.Get_Predicate('ra',NULL);
3298: l_ard_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard',NULL);
3299: l_ps_org_where := XLA_MO_REPORTING_API.Get_Predicate('ps',NULL);
3300: l_ps1_org_where := XLA_MO_REPORTING_API.Get_Predicate('ps1',NULL);
3301: l_sysparam_org_where := XLA_MO_REPORTING_API.Get_Predicate('sysparam',NULL);
3302:

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

3295: XLA_MO_REPORTING_API.Initialize(p_reporting_level, p_reporting_entity_id, 'AUTO');
3296:
3297: l_ra_org_where := XLA_MO_REPORTING_API.Get_Predicate('ra',NULL);
3298: l_ard_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard',NULL);
3299: l_ps_org_where := XLA_MO_REPORTING_API.Get_Predicate('ps',NULL);
3300: l_ps1_org_where := XLA_MO_REPORTING_API.Get_Predicate('ps1',NULL);
3301: l_sysparam_org_where := XLA_MO_REPORTING_API.Get_Predicate('sysparam',NULL);
3302:
3303:

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

3296:
3297: l_ra_org_where := XLA_MO_REPORTING_API.Get_Predicate('ra',NULL);
3298: l_ard_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard',NULL);
3299: l_ps_org_where := XLA_MO_REPORTING_API.Get_Predicate('ps',NULL);
3300: l_ps1_org_where := XLA_MO_REPORTING_API.Get_Predicate('ps1',NULL);
3301: l_sysparam_org_where := XLA_MO_REPORTING_API.Get_Predicate('sysparam',NULL);
3302:
3303:
3304: /* Replace the bind variables with global functions */

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

3297: l_ra_org_where := XLA_MO_REPORTING_API.Get_Predicate('ra',NULL);
3298: l_ard_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard',NULL);
3299: l_ps_org_where := XLA_MO_REPORTING_API.Get_Predicate('ps',NULL);
3300: l_ps1_org_where := XLA_MO_REPORTING_API.Get_Predicate('ps1',NULL);
3301: l_sysparam_org_where := XLA_MO_REPORTING_API.Get_Predicate('sysparam',NULL);
3302:
3303:
3304: /* Replace the bind variables with global functions */
3305: l_ra_org_where := replace(l_ra_org_where,

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

3311: l_ps1_org_where := replace(l_ps1_org_where,
3312: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
3313: l_sysparam_org_where := replace(l_sysparam_org_where,
3314: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
3315: l_reporting_entity_name := substrb(XLA_MO_REPORTING_API.get_reporting_entity_name,1,80);
3316: l_reporting_level_name := substrb(XLA_MO_REPORTING_API.get_reporting_level_name,1,30);
3317:
3318: /* Multi Org Uptake: Show appropriate message to the user depending upon the security profile */
3319: IF p_reporting_level = '1000' THEN

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

3312: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
3313: l_sysparam_org_where := replace(l_sysparam_org_where,
3314: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
3315: l_reporting_entity_name := substrb(XLA_MO_REPORTING_API.get_reporting_entity_name,1,80);
3316: l_reporting_level_name := substrb(XLA_MO_REPORTING_API.get_reporting_level_name,1,30);
3317:
3318: /* Multi Org Uptake: Show appropriate message to the user depending upon the security profile */
3319: IF p_reporting_level = '1000' THEN
3320: l_ld_sp:= mo_utils.check_ledger_in_sp(p_reporting_entity_id);

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

3738: init(p_sob_id);
3739:
3740: /* Set the org conditions */
3741:
3742: XLA_MO_REPORTING_API.Initialize(1000,p_reporting_entity_id, 'AUTO');
3743:
3744: l_ra_org_where := XLA_MO_REPORTING_API.Get_Predicate('ra',NULL);
3745: l_adj_org_where := XLA_MO_REPORTING_API.Get_Predicate('adj',NULL);
3746: l_ard_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard',NULL);

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

3740: /* Set the org conditions */
3741:
3742: XLA_MO_REPORTING_API.Initialize(1000,p_reporting_entity_id, 'AUTO');
3743:
3744: l_ra_org_where := XLA_MO_REPORTING_API.Get_Predicate('ra',NULL);
3745: l_adj_org_where := XLA_MO_REPORTING_API.Get_Predicate('adj',NULL);
3746: l_ard_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard',NULL);
3747: l_gl_dist_org_where := XLA_MO_REPORTING_API.Get_Predicate('ctlgd',NULL);
3748: l_sysparam_org_where := XLA_MO_REPORTING_API.Get_Predicate('sysparam',NULL);

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

3741:
3742: XLA_MO_REPORTING_API.Initialize(1000,p_reporting_entity_id, 'AUTO');
3743:
3744: l_ra_org_where := XLA_MO_REPORTING_API.Get_Predicate('ra',NULL);
3745: l_adj_org_where := XLA_MO_REPORTING_API.Get_Predicate('adj',NULL);
3746: l_ard_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard',NULL);
3747: l_gl_dist_org_where := XLA_MO_REPORTING_API.Get_Predicate('ctlgd',NULL);
3748: l_sysparam_org_where := XLA_MO_REPORTING_API.Get_Predicate('sysparam',NULL);
3749: l_mcd_org_where := XLA_MO_REPORTING_API.Get_Predicate('mcd',NULL);

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

3742: XLA_MO_REPORTING_API.Initialize(1000,p_reporting_entity_id, 'AUTO');
3743:
3744: l_ra_org_where := XLA_MO_REPORTING_API.Get_Predicate('ra',NULL);
3745: l_adj_org_where := XLA_MO_REPORTING_API.Get_Predicate('adj',NULL);
3746: l_ard_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard',NULL);
3747: l_gl_dist_org_where := XLA_MO_REPORTING_API.Get_Predicate('ctlgd',NULL);
3748: l_sysparam_org_where := XLA_MO_REPORTING_API.Get_Predicate('sysparam',NULL);
3749: l_mcd_org_where := XLA_MO_REPORTING_API.Get_Predicate('mcd',NULL);
3750: l_crh_org_where := XLA_MO_REPORTING_API.Get_Predicate('crh',NULL);

Line 3747: l_gl_dist_org_where := XLA_MO_REPORTING_API.Get_Predicate('ctlgd',NULL);

3743:
3744: l_ra_org_where := XLA_MO_REPORTING_API.Get_Predicate('ra',NULL);
3745: l_adj_org_where := XLA_MO_REPORTING_API.Get_Predicate('adj',NULL);
3746: l_ard_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard',NULL);
3747: l_gl_dist_org_where := XLA_MO_REPORTING_API.Get_Predicate('ctlgd',NULL);
3748: l_sysparam_org_where := XLA_MO_REPORTING_API.Get_Predicate('sysparam',NULL);
3749: l_mcd_org_where := XLA_MO_REPORTING_API.Get_Predicate('mcd',NULL);
3750: l_crh_org_where := XLA_MO_REPORTING_API.Get_Predicate('crh',NULL);
3751: l_cr_org_where := XLA_MO_REPORTING_API.Get_Predicate('cr',NULL); /* Bug fix 6432847 */

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

3744: l_ra_org_where := XLA_MO_REPORTING_API.Get_Predicate('ra',NULL);
3745: l_adj_org_where := XLA_MO_REPORTING_API.Get_Predicate('adj',NULL);
3746: l_ard_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard',NULL);
3747: l_gl_dist_org_where := XLA_MO_REPORTING_API.Get_Predicate('ctlgd',NULL);
3748: l_sysparam_org_where := XLA_MO_REPORTING_API.Get_Predicate('sysparam',NULL);
3749: l_mcd_org_where := XLA_MO_REPORTING_API.Get_Predicate('mcd',NULL);
3750: l_crh_org_where := XLA_MO_REPORTING_API.Get_Predicate('crh',NULL);
3751: l_cr_org_where := XLA_MO_REPORTING_API.Get_Predicate('cr',NULL); /* Bug fix 6432847 */
3752: l_ath_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard',NULL);

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

3745: l_adj_org_where := XLA_MO_REPORTING_API.Get_Predicate('adj',NULL);
3746: l_ard_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard',NULL);
3747: l_gl_dist_org_where := XLA_MO_REPORTING_API.Get_Predicate('ctlgd',NULL);
3748: l_sysparam_org_where := XLA_MO_REPORTING_API.Get_Predicate('sysparam',NULL);
3749: l_mcd_org_where := XLA_MO_REPORTING_API.Get_Predicate('mcd',NULL);
3750: l_crh_org_where := XLA_MO_REPORTING_API.Get_Predicate('crh',NULL);
3751: l_cr_org_where := XLA_MO_REPORTING_API.Get_Predicate('cr',NULL); /* Bug fix 6432847 */
3752: l_ath_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard',NULL);
3753:

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

3746: l_ard_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard',NULL);
3747: l_gl_dist_org_where := XLA_MO_REPORTING_API.Get_Predicate('ctlgd',NULL);
3748: l_sysparam_org_where := XLA_MO_REPORTING_API.Get_Predicate('sysparam',NULL);
3749: l_mcd_org_where := XLA_MO_REPORTING_API.Get_Predicate('mcd',NULL);
3750: l_crh_org_where := XLA_MO_REPORTING_API.Get_Predicate('crh',NULL);
3751: l_cr_org_where := XLA_MO_REPORTING_API.Get_Predicate('cr',NULL); /* Bug fix 6432847 */
3752: l_ath_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard',NULL);
3753:
3754: /* Replace the bind variables with global functions */

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

3747: l_gl_dist_org_where := XLA_MO_REPORTING_API.Get_Predicate('ctlgd',NULL);
3748: l_sysparam_org_where := XLA_MO_REPORTING_API.Get_Predicate('sysparam',NULL);
3749: l_mcd_org_where := XLA_MO_REPORTING_API.Get_Predicate('mcd',NULL);
3750: l_crh_org_where := XLA_MO_REPORTING_API.Get_Predicate('crh',NULL);
3751: l_cr_org_where := XLA_MO_REPORTING_API.Get_Predicate('cr',NULL); /* Bug fix 6432847 */
3752: l_ath_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard',NULL);
3753:
3754: /* Replace the bind variables with global functions */
3755: l_ra_org_where := replace(l_ra_org_where,

Line 3752: l_ath_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard',NULL);

3748: l_sysparam_org_where := XLA_MO_REPORTING_API.Get_Predicate('sysparam',NULL);
3749: l_mcd_org_where := XLA_MO_REPORTING_API.Get_Predicate('mcd',NULL);
3750: l_crh_org_where := XLA_MO_REPORTING_API.Get_Predicate('crh',NULL);
3751: l_cr_org_where := XLA_MO_REPORTING_API.Get_Predicate('cr',NULL); /* Bug fix 6432847 */
3752: l_ath_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard',NULL);
3753:
3754: /* Replace the bind variables with global functions */
3755: l_ra_org_where := replace(l_ra_org_where,
3756: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');

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

3771: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
3772: l_ath_org_where := replace(l_ath_org_where,
3773: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
3774:
3775: l_reporting_entity_name := substrb(XLA_MO_REPORTING_API.get_reporting_entity_name,1,80);
3776: l_reporting_level_name := substrb(XLA_MO_REPORTING_API.get_reporting_level_name,1,30);
3777:
3778: /* Get the org name */
3779: select meaning

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

3772: l_ath_org_where := replace(l_ath_org_where,
3773: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
3774:
3775: l_reporting_entity_name := substrb(XLA_MO_REPORTING_API.get_reporting_entity_name,1,80);
3776: l_reporting_level_name := substrb(XLA_MO_REPORTING_API.get_reporting_level_name,1,30);
3777:
3778: /* Get the org name */
3779: select meaning
3780: into l_organization