262: LP_AR_RATE_ADJUSTMENTS_ALL := 'AR_RATE_ADJUSTMENTS_ALL';
263: LP_AR_RECEIVABLE_APPS := 'AR_RECEIVABLE_APPLICATIONS';
264: LP_AR_RECEIVABLE_APPS_ALL := 'AR_RECEIVABLE_APPLICATIONS_ALL';
265: END IF;
266: XLA_MO_REPORTING_API.INITIALIZE(P_REPORTING_LEVEL
267: ,P_REPORTING_ENTITY_ID
268: ,'AUTO');
269: /*SRW.MESSAGE(103
270: ,'p_reporting_level = ' || P_REPORTING_LEVEL || ' p_reporting_entity_id = ' || TO_CHAR(P_REPORTING_ENTITY_ID))*/NULL;
267: ,P_REPORTING_ENTITY_ID
268: ,'AUTO');
269: /*SRW.MESSAGE(103
270: ,'p_reporting_level = ' || P_REPORTING_LEVEL || ' p_reporting_entity_id = ' || TO_CHAR(P_REPORTING_ENTITY_ID))*/NULL;
271: P_ORG_WHERE_GLDIST := XLA_MO_REPORTING_API.GET_PREDICATE('gldist'
272: ,NULL);
273: P_ORG_WHERE_CT := XLA_MO_REPORTING_API.GET_PREDICATE('ct'
274: ,NULL);
275: P_ORG_WHERE_CTT := XLA_MO_REPORTING_API.GET_PREDICATE('ctt'
269: /*SRW.MESSAGE(103
270: ,'p_reporting_level = ' || P_REPORTING_LEVEL || ' p_reporting_entity_id = ' || TO_CHAR(P_REPORTING_ENTITY_ID))*/NULL;
271: P_ORG_WHERE_GLDIST := XLA_MO_REPORTING_API.GET_PREDICATE('gldist'
272: ,NULL);
273: P_ORG_WHERE_CT := XLA_MO_REPORTING_API.GET_PREDICATE('ct'
274: ,NULL);
275: P_ORG_WHERE_CTT := XLA_MO_REPORTING_API.GET_PREDICATE('ctt'
276: ,NULL);
277: P_ORG_WHERE_ARD := XLA_MO_REPORTING_API.GET_PREDICATE('ard'
271: P_ORG_WHERE_GLDIST := XLA_MO_REPORTING_API.GET_PREDICATE('gldist'
272: ,NULL);
273: P_ORG_WHERE_CT := XLA_MO_REPORTING_API.GET_PREDICATE('ct'
274: ,NULL);
275: P_ORG_WHERE_CTT := XLA_MO_REPORTING_API.GET_PREDICATE('ctt'
276: ,NULL);
277: P_ORG_WHERE_ARD := XLA_MO_REPORTING_API.GET_PREDICATE('ard'
278: ,NULL);
279: P_ORG_WHERE_ACCT := XLA_MO_REPORTING_API.GET_PREDICATE('acct'
273: P_ORG_WHERE_CT := XLA_MO_REPORTING_API.GET_PREDICATE('ct'
274: ,NULL);
275: P_ORG_WHERE_CTT := XLA_MO_REPORTING_API.GET_PREDICATE('ctt'
276: ,NULL);
277: P_ORG_WHERE_ARD := XLA_MO_REPORTING_API.GET_PREDICATE('ard'
278: ,NULL);
279: P_ORG_WHERE_ACCT := XLA_MO_REPORTING_API.GET_PREDICATE('acct'
280: ,NULL);
281: P_ORG_WHERE_MCD := XLA_MO_REPORTING_API.GET_PREDICATE('mcd'
275: P_ORG_WHERE_CTT := XLA_MO_REPORTING_API.GET_PREDICATE('ctt'
276: ,NULL);
277: P_ORG_WHERE_ARD := XLA_MO_REPORTING_API.GET_PREDICATE('ard'
278: ,NULL);
279: P_ORG_WHERE_ACCT := XLA_MO_REPORTING_API.GET_PREDICATE('acct'
280: ,NULL);
281: P_ORG_WHERE_MCD := XLA_MO_REPORTING_API.GET_PREDICATE('mcd'
282: ,NULL);
283: P_ORG_WHERE_TH := XLA_MO_REPORTING_API.GET_PREDICATE('th'
277: P_ORG_WHERE_ARD := XLA_MO_REPORTING_API.GET_PREDICATE('ard'
278: ,NULL);
279: P_ORG_WHERE_ACCT := XLA_MO_REPORTING_API.GET_PREDICATE('acct'
280: ,NULL);
281: P_ORG_WHERE_MCD := XLA_MO_REPORTING_API.GET_PREDICATE('mcd'
282: ,NULL);
283: P_ORG_WHERE_TH := XLA_MO_REPORTING_API.GET_PREDICATE('th'
284: ,NULL);
285: P_ORG_WHERE_ADJ := XLA_MO_REPORTING_API.GET_PREDICATE('adj'
279: P_ORG_WHERE_ACCT := XLA_MO_REPORTING_API.GET_PREDICATE('acct'
280: ,NULL);
281: P_ORG_WHERE_MCD := XLA_MO_REPORTING_API.GET_PREDICATE('mcd'
282: ,NULL);
283: P_ORG_WHERE_TH := XLA_MO_REPORTING_API.GET_PREDICATE('th'
284: ,NULL);
285: P_ORG_WHERE_ADJ := XLA_MO_REPORTING_API.GET_PREDICATE('adj'
286: ,NULL);
287: P_ORG_WHERE_RA := XLA_MO_REPORTING_API.GET_PREDICATE('ra'
281: P_ORG_WHERE_MCD := XLA_MO_REPORTING_API.GET_PREDICATE('mcd'
282: ,NULL);
283: P_ORG_WHERE_TH := XLA_MO_REPORTING_API.GET_PREDICATE('th'
284: ,NULL);
285: P_ORG_WHERE_ADJ := XLA_MO_REPORTING_API.GET_PREDICATE('adj'
286: ,NULL);
287: P_ORG_WHERE_RA := XLA_MO_REPORTING_API.GET_PREDICATE('ra'
288: ,NULL);
289: P_ORG_WHERE_CRH := XLA_MO_REPORTING_API.GET_PREDICATE('crh'
283: P_ORG_WHERE_TH := XLA_MO_REPORTING_API.GET_PREDICATE('th'
284: ,NULL);
285: P_ORG_WHERE_ADJ := XLA_MO_REPORTING_API.GET_PREDICATE('adj'
286: ,NULL);
287: P_ORG_WHERE_RA := XLA_MO_REPORTING_API.GET_PREDICATE('ra'
288: ,NULL);
289: P_ORG_WHERE_CRH := XLA_MO_REPORTING_API.GET_PREDICATE('crh'
290: ,NULL);
291: P_ORG_WHERE_CR := XLA_MO_REPORTING_API.GET_PREDICATE('cr'
285: P_ORG_WHERE_ADJ := XLA_MO_REPORTING_API.GET_PREDICATE('adj'
286: ,NULL);
287: P_ORG_WHERE_RA := XLA_MO_REPORTING_API.GET_PREDICATE('ra'
288: ,NULL);
289: P_ORG_WHERE_CRH := XLA_MO_REPORTING_API.GET_PREDICATE('crh'
290: ,NULL);
291: P_ORG_WHERE_CR := XLA_MO_REPORTING_API.GET_PREDICATE('cr'
292: ,NULL);
293: P_ORG_WHERE_CTINV := XLA_MO_REPORTING_API.GET_PREDICATE('ctinv'
287: P_ORG_WHERE_RA := XLA_MO_REPORTING_API.GET_PREDICATE('ra'
288: ,NULL);
289: P_ORG_WHERE_CRH := XLA_MO_REPORTING_API.GET_PREDICATE('crh'
290: ,NULL);
291: P_ORG_WHERE_CR := XLA_MO_REPORTING_API.GET_PREDICATE('cr'
292: ,NULL);
293: P_ORG_WHERE_CTINV := XLA_MO_REPORTING_API.GET_PREDICATE('ctinv'
294: ,NULL);
295: /*SRW.MESSAGE(105
289: P_ORG_WHERE_CRH := XLA_MO_REPORTING_API.GET_PREDICATE('crh'
290: ,NULL);
291: P_ORG_WHERE_CR := XLA_MO_REPORTING_API.GET_PREDICATE('cr'
292: ,NULL);
293: P_ORG_WHERE_CTINV := XLA_MO_REPORTING_API.GET_PREDICATE('ctinv'
294: ,NULL);
295: /*SRW.MESSAGE(105
296: ,'Get_Predicate calls complete')*/NULL;
297: P_REPORTING_ENTITY_NAME := SUBSTRB(XLA_MO_REPORTING_API.GET_REPORTING_ENTITY_NAME
293: P_ORG_WHERE_CTINV := XLA_MO_REPORTING_API.GET_PREDICATE('ctinv'
294: ,NULL);
295: /*SRW.MESSAGE(105
296: ,'Get_Predicate calls complete')*/NULL;
297: P_REPORTING_ENTITY_NAME := SUBSTRB(XLA_MO_REPORTING_API.GET_REPORTING_ENTITY_NAME
298: ,1
299: ,80);
300: P_REPORTING_LEVEL_NAME := SUBSTRB(XLA_MO_REPORTING_API.GET_REPORTING_LEVEL_NAME
301: ,1
296: ,'Get_Predicate calls complete')*/NULL;
297: P_REPORTING_ENTITY_NAME := SUBSTRB(XLA_MO_REPORTING_API.GET_REPORTING_ENTITY_NAME
298: ,1
299: ,80);
300: P_REPORTING_LEVEL_NAME := SUBSTRB(XLA_MO_REPORTING_API.GET_REPORTING_LEVEL_NAME
301: ,1
302: ,30);
303: LP_ADJ_SELECT := 'Select ''ADJ_ADJ'' JOURNAL_CATEGORY ,''N'' ASSET_TYPE ,''Y'' LIABILITY_TYPE ,''Y'' EXPENSE_TYPE ,''Y'' REVENUE_TYPE from dual
304: union all