18:
19:
20: BEGIN
21:
22: XLA_MO_REPORTING_API.Initialize(p_reporting_level, p_reporting_entity_id, 'AUTO');
23: p_reporting_entity_name := substrb(XLA_MO_REPORTING_API.get_reporting_entity_name,1,200) ;
24: p_reporting_level_name := substrb(XLA_MO_REPORTING_API.get_reporting_level_name,1,30);
25: P_ORG_WHERE_CUST := XLA_MO_REPORTING_API.Get_Predicate('CUST', null);
26: P_ORG_WHERE_DIST := XLA_MO_REPORTING_API.Get_Predicate('DIST', null);
19:
20: BEGIN
21:
22: XLA_MO_REPORTING_API.Initialize(p_reporting_level, p_reporting_entity_id, 'AUTO');
23: p_reporting_entity_name := substrb(XLA_MO_REPORTING_API.get_reporting_entity_name,1,200) ;
24: p_reporting_level_name := substrb(XLA_MO_REPORTING_API.get_reporting_level_name,1,30);
25: P_ORG_WHERE_CUST := XLA_MO_REPORTING_API.Get_Predicate('CUST', null);
26: P_ORG_WHERE_DIST := XLA_MO_REPORTING_API.Get_Predicate('DIST', null);
27: P_ORG_WHERE_TRX := XLA_MO_REPORTING_API.Get_Predicate('TRX', null);
20: BEGIN
21:
22: XLA_MO_REPORTING_API.Initialize(p_reporting_level, p_reporting_entity_id, 'AUTO');
23: p_reporting_entity_name := substrb(XLA_MO_REPORTING_API.get_reporting_entity_name,1,200) ;
24: p_reporting_level_name := substrb(XLA_MO_REPORTING_API.get_reporting_level_name,1,30);
25: P_ORG_WHERE_CUST := XLA_MO_REPORTING_API.Get_Predicate('CUST', null);
26: P_ORG_WHERE_DIST := XLA_MO_REPORTING_API.Get_Predicate('DIST', null);
27: P_ORG_WHERE_TRX := XLA_MO_REPORTING_API.Get_Predicate('TRX', null);
28: P_ORG_WHERE_TYPE := XLA_MO_REPORTING_API.Get_Predicate('TYPE',null);
21:
22: XLA_MO_REPORTING_API.Initialize(p_reporting_level, p_reporting_entity_id, 'AUTO');
23: p_reporting_entity_name := substrb(XLA_MO_REPORTING_API.get_reporting_entity_name,1,200) ;
24: p_reporting_level_name := substrb(XLA_MO_REPORTING_API.get_reporting_level_name,1,30);
25: P_ORG_WHERE_CUST := XLA_MO_REPORTING_API.Get_Predicate('CUST', null);
26: P_ORG_WHERE_DIST := XLA_MO_REPORTING_API.Get_Predicate('DIST', null);
27: P_ORG_WHERE_TRX := XLA_MO_REPORTING_API.Get_Predicate('TRX', null);
28: P_ORG_WHERE_TYPE := XLA_MO_REPORTING_API.Get_Predicate('TYPE',null);
29:
22: XLA_MO_REPORTING_API.Initialize(p_reporting_level, p_reporting_entity_id, 'AUTO');
23: p_reporting_entity_name := substrb(XLA_MO_REPORTING_API.get_reporting_entity_name,1,200) ;
24: p_reporting_level_name := substrb(XLA_MO_REPORTING_API.get_reporting_level_name,1,30);
25: P_ORG_WHERE_CUST := XLA_MO_REPORTING_API.Get_Predicate('CUST', null);
26: P_ORG_WHERE_DIST := XLA_MO_REPORTING_API.Get_Predicate('DIST', null);
27: P_ORG_WHERE_TRX := XLA_MO_REPORTING_API.Get_Predicate('TRX', null);
28: P_ORG_WHERE_TYPE := XLA_MO_REPORTING_API.Get_Predicate('TYPE',null);
29:
30:
23: p_reporting_entity_name := substrb(XLA_MO_REPORTING_API.get_reporting_entity_name,1,200) ;
24: p_reporting_level_name := substrb(XLA_MO_REPORTING_API.get_reporting_level_name,1,30);
25: P_ORG_WHERE_CUST := XLA_MO_REPORTING_API.Get_Predicate('CUST', null);
26: P_ORG_WHERE_DIST := XLA_MO_REPORTING_API.Get_Predicate('DIST', null);
27: P_ORG_WHERE_TRX := XLA_MO_REPORTING_API.Get_Predicate('TRX', null);
28: P_ORG_WHERE_TYPE := XLA_MO_REPORTING_API.Get_Predicate('TYPE',null);
29:
30:
31: if p_start_gl_date is NOT NULL then
24: p_reporting_level_name := substrb(XLA_MO_REPORTING_API.get_reporting_level_name,1,30);
25: P_ORG_WHERE_CUST := XLA_MO_REPORTING_API.Get_Predicate('CUST', null);
26: P_ORG_WHERE_DIST := XLA_MO_REPORTING_API.Get_Predicate('DIST', null);
27: P_ORG_WHERE_TRX := XLA_MO_REPORTING_API.Get_Predicate('TRX', null);
28: P_ORG_WHERE_TYPE := XLA_MO_REPORTING_API.Get_Predicate('TYPE',null);
29:
30:
31: if p_start_gl_date is NOT NULL then
32: lp_start_gl_date := ' AND dist.gl_date >= :p_start_gl_date ';