56: p_look:='ar_lookups';
57:
58: begin
59: p_reporting_entity_id:=p_reporting_context;
60: xla_mo_reporting_api.initialize(p_reporting_level,p_reporting_entity_id,'AUTO');
61: reporting_context_name:=substrb(xla_mo_reporting_api.get_reporting_entity_name,1,80);
62: reporting_entity_level_name:=reporting_context_name;
63: reporting_level_name:=substrb(xla_mo_reporting_api.get_reporting_level_name,1,30);
64: p_cr_where:=xla_mo_reporting_api.get_predicate('cr',null);
57:
58: begin
59: p_reporting_entity_id:=p_reporting_context;
60: xla_mo_reporting_api.initialize(p_reporting_level,p_reporting_entity_id,'AUTO');
61: reporting_context_name:=substrb(xla_mo_reporting_api.get_reporting_entity_name,1,80);
62: reporting_entity_level_name:=reporting_context_name;
63: reporting_level_name:=substrb(xla_mo_reporting_api.get_reporting_level_name,1,30);
64: p_cr_where:=xla_mo_reporting_api.get_predicate('cr',null);
65: p_site_where:=xla_mo_reporting_api.get_predicate('site_uses',null);
59: p_reporting_entity_id:=p_reporting_context;
60: xla_mo_reporting_api.initialize(p_reporting_level,p_reporting_entity_id,'AUTO');
61: reporting_context_name:=substrb(xla_mo_reporting_api.get_reporting_entity_name,1,80);
62: reporting_entity_level_name:=reporting_context_name;
63: reporting_level_name:=substrb(xla_mo_reporting_api.get_reporting_level_name,1,30);
64: p_cr_where:=xla_mo_reporting_api.get_predicate('cr',null);
65: p_site_where:=xla_mo_reporting_api.get_predicate('site_uses',null);
66: p_cust_where:=xla_mo_reporting_api.get_predicate('cust_acct',null);
67: select replace(p_cr_where,':p_reporting_entity_id',p_reporting_context),
60: xla_mo_reporting_api.initialize(p_reporting_level,p_reporting_entity_id,'AUTO');
61: reporting_context_name:=substrb(xla_mo_reporting_api.get_reporting_entity_name,1,80);
62: reporting_entity_level_name:=reporting_context_name;
63: reporting_level_name:=substrb(xla_mo_reporting_api.get_reporting_level_name,1,30);
64: p_cr_where:=xla_mo_reporting_api.get_predicate('cr',null);
65: p_site_where:=xla_mo_reporting_api.get_predicate('site_uses',null);
66: p_cust_where:=xla_mo_reporting_api.get_predicate('cust_acct',null);
67: select replace(p_cr_where,':p_reporting_entity_id',p_reporting_context),
68: replace(p_cust_where,':p_reporting_entity_id',p_reporting_context),
61: reporting_context_name:=substrb(xla_mo_reporting_api.get_reporting_entity_name,1,80);
62: reporting_entity_level_name:=reporting_context_name;
63: reporting_level_name:=substrb(xla_mo_reporting_api.get_reporting_level_name,1,30);
64: p_cr_where:=xla_mo_reporting_api.get_predicate('cr',null);
65: p_site_where:=xla_mo_reporting_api.get_predicate('site_uses',null);
66: p_cust_where:=xla_mo_reporting_api.get_predicate('cust_acct',null);
67: select replace(p_cr_where,':p_reporting_entity_id',p_reporting_context),
68: replace(p_cust_where,':p_reporting_entity_id',p_reporting_context),
69: replace(p_site_where,':p_reporting_entity_id',p_reporting_context)
62: reporting_entity_level_name:=reporting_context_name;
63: reporting_level_name:=substrb(xla_mo_reporting_api.get_reporting_level_name,1,30);
64: p_cr_where:=xla_mo_reporting_api.get_predicate('cr',null);
65: p_site_where:=xla_mo_reporting_api.get_predicate('site_uses',null);
66: p_cust_where:=xla_mo_reporting_api.get_predicate('cust_acct',null);
67: select replace(p_cr_where,':p_reporting_entity_id',p_reporting_context),
68: replace(p_cust_where,':p_reporting_entity_id',p_reporting_context),
69: replace(p_site_where,':p_reporting_entity_id',p_reporting_context)
70: into p_cr_where,p_cust_where,p_site_where from dual;