DBA Data[Home] [Help]

APPS.AR_ARXRJR_XMLP_PKG dependencies on XLA_MO_REPORTING_API

Line 60: xla_mo_reporting_api.initialize(p_reporting_level,p_reporting_entity_id,'AUTO');

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

Line 61: reporting_context_name:=substrb(xla_mo_reporting_api.get_reporting_entity_name,1,80);

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

Line 63: reporting_level_name:=substrb(xla_mo_reporting_api.get_reporting_level_name,1,30);

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

Line 64: p_cr_where:=xla_mo_reporting_api.get_predicate('cr',null);

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

Line 65: p_site_where:=xla_mo_reporting_api.get_predicate('site_uses',null);

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)

Line 66: p_cust_where:=xla_mo_reporting_api.get_predicate('cust_acct',null);

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;