144:
145: FUNCTION AFTERPFORM RETURN BOOLEAN IS
146: BEGIN
147: BEGIN
148: XLA_MO_REPORTING_API.INITIALIZE(P_REPORTING_LEVEL
149: ,P_REPORTING_ENTITY_ID
150: ,'AUTO');
151: P_REPORTING_ENTITY_NAME := SUBSTRB(XLA_MO_REPORTING_API.GET_REPORTING_ENTITY_NAME
152: ,1
147: BEGIN
148: XLA_MO_REPORTING_API.INITIALIZE(P_REPORTING_LEVEL
149: ,P_REPORTING_ENTITY_ID
150: ,'AUTO');
151: P_REPORTING_ENTITY_NAME := SUBSTRB(XLA_MO_REPORTING_API.GET_REPORTING_ENTITY_NAME
152: ,1
153: ,200);
154: P_REPORTING_LEVEL_NAME := SUBSTRB(XLA_MO_REPORTING_API.GET_REPORTING_LEVEL_NAME
155: ,1
150: ,'AUTO');
151: P_REPORTING_ENTITY_NAME := SUBSTRB(XLA_MO_REPORTING_API.GET_REPORTING_ENTITY_NAME
152: ,1
153: ,200);
154: P_REPORTING_LEVEL_NAME := SUBSTRB(XLA_MO_REPORTING_API.GET_REPORTING_LEVEL_NAME
155: ,1
156: ,30);
157: P_ORG_WHERE_C := XLA_MO_REPORTING_API.GET_PREDICATE('C'
158: ,NULL);
153: ,200);
154: P_REPORTING_LEVEL_NAME := SUBSTRB(XLA_MO_REPORTING_API.GET_REPORTING_LEVEL_NAME
155: ,1
156: ,30);
157: P_ORG_WHERE_C := XLA_MO_REPORTING_API.GET_PREDICATE('C'
158: ,NULL);
159: P_ORG_WHERE_TRX := XLA_MO_REPORTING_API.GET_PREDICATE('TRX'
160: ,NULL);
161: P_ORG_WHERE_LINES := XLA_MO_REPORTING_API.GET_PREDICATE('LINES'
155: ,1
156: ,30);
157: P_ORG_WHERE_C := XLA_MO_REPORTING_API.GET_PREDICATE('C'
158: ,NULL);
159: P_ORG_WHERE_TRX := XLA_MO_REPORTING_API.GET_PREDICATE('TRX'
160: ,NULL);
161: P_ORG_WHERE_LINES := XLA_MO_REPORTING_API.GET_PREDICATE('LINES'
162: ,NULL);
163: P_ORG_WHERE_LINK_LINE := XLA_MO_REPORTING_API.GET_PREDICATE('LINK_LINE'
157: P_ORG_WHERE_C := XLA_MO_REPORTING_API.GET_PREDICATE('C'
158: ,NULL);
159: P_ORG_WHERE_TRX := XLA_MO_REPORTING_API.GET_PREDICATE('TRX'
160: ,NULL);
161: P_ORG_WHERE_LINES := XLA_MO_REPORTING_API.GET_PREDICATE('LINES'
162: ,NULL);
163: P_ORG_WHERE_LINK_LINE := XLA_MO_REPORTING_API.GET_PREDICATE('LINK_LINE'
164: ,NULL);
165: P_ORG_WHERE_GL_DIST := XLA_MO_REPORTING_API.GET_PREDICATE('GL_DIST'
159: P_ORG_WHERE_TRX := XLA_MO_REPORTING_API.GET_PREDICATE('TRX'
160: ,NULL);
161: P_ORG_WHERE_LINES := XLA_MO_REPORTING_API.GET_PREDICATE('LINES'
162: ,NULL);
163: P_ORG_WHERE_LINK_LINE := XLA_MO_REPORTING_API.GET_PREDICATE('LINK_LINE'
164: ,NULL);
165: P_ORG_WHERE_GL_DIST := XLA_MO_REPORTING_API.GET_PREDICATE('GL_DIST'
166: ,NULL);
167: P_ORG_WHERE_PARAM := XLA_MO_REPORTING_API.GET_PREDICATE('PARAM'
161: P_ORG_WHERE_LINES := XLA_MO_REPORTING_API.GET_PREDICATE('LINES'
162: ,NULL);
163: P_ORG_WHERE_LINK_LINE := XLA_MO_REPORTING_API.GET_PREDICATE('LINK_LINE'
164: ,NULL);
165: P_ORG_WHERE_GL_DIST := XLA_MO_REPORTING_API.GET_PREDICATE('GL_DIST'
166: ,NULL);
167: P_ORG_WHERE_PARAM := XLA_MO_REPORTING_API.GET_PREDICATE('PARAM'
168: ,NULL);
169: IF P_START_GL_DATE IS NOT NULL THEN
163: P_ORG_WHERE_LINK_LINE := XLA_MO_REPORTING_API.GET_PREDICATE('LINK_LINE'
164: ,NULL);
165: P_ORG_WHERE_GL_DIST := XLA_MO_REPORTING_API.GET_PREDICATE('GL_DIST'
166: ,NULL);
167: P_ORG_WHERE_PARAM := XLA_MO_REPORTING_API.GET_PREDICATE('PARAM'
168: ,NULL);
169: IF P_START_GL_DATE IS NOT NULL THEN
170: LP_START_GL_DATE := ' and gl_dist.gl_date >= :p_start_gl_date ';
171: END IF;