APPS.AR_RAXGLR_XMLP_PKG dependencies on XLA_MO_REPORTING_API

Line 132: P_ORG_WHERE_CI := XLA_MO_REPORTING_API.Get_Predicate('CI', null);

128: P_ORG_WHERE_PS := ' ';
129: Else
130:
131: lp_query_show_bill := 'ci.cons_billing_number';
132: P_ORG_WHERE_CI := XLA_MO_REPORTING_API.Get_Predicate('CI', null);
133: P_ORG_WHERE_PS := XLA_MO_REPORTING_API.Get_Predicate('PS', null);
134:
135: IF (upper(p_mrcsobtype) = 'R') THEN
136: lp_table_show_bill := 'ar_payment_schedules_all_mrc_v ps,ar_cons_inv_all ci,';

Line 133: P_ORG_WHERE_PS := XLA_MO_REPORTING_API.Get_Predicate('PS', null);

129: Else
130:
131: lp_query_show_bill := 'ci.cons_billing_number';
132: P_ORG_WHERE_CI := XLA_MO_REPORTING_API.Get_Predicate('CI', null);
133: P_ORG_WHERE_PS := XLA_MO_REPORTING_API.Get_Predicate('PS', null);
134:
135: IF (upper(p_mrcsobtype) = 'R') THEN
136: lp_table_show_bill := 'ar_payment_schedules_all_mrc_v ps,ar_cons_inv_all ci,';
137: lp_where_show_bill := 'and trx.customer_trx_id = ps.customer_trx_id(+)

Line 341: XLA_MO_REPORTING_API.INITIALIZE(P_REPORTING_LEVEL

337: LP_AR_RATE_ADJUSTMENTS := 'AR_RATE_ADJUSTMENTS';
338: LP_AR_RATE_ADJUSTMENTS_ALL := 'AR_RATE_ADJUSTMENTS_ALL';
339: LP_AR_RECEIVABLE_APPS := 'AR_RECEIVABLE_APPLICATIONS';
340: LP_AR_RECEIVABLE_APPS_ALL := 'AR_RECEIVABLE_APPLICATIONS_ALL';
341: XLA_MO_REPORTING_API.INITIALIZE(P_REPORTING_LEVEL
342: ,P_REPORTING_ENTITY_ID
343: ,'AUTO');
344: P_REPORTING_ENTITY_NAME := SUBSTRB(XLA_MO_REPORTING_API.GET_REPORTING_ENTITY_NAME
345: ,1

Line 344: P_REPORTING_ENTITY_NAME := SUBSTRB(XLA_MO_REPORTING_API.GET_REPORTING_ENTITY_NAME

340: LP_AR_RECEIVABLE_APPS_ALL := 'AR_RECEIVABLE_APPLICATIONS_ALL';
341: XLA_MO_REPORTING_API.INITIALIZE(P_REPORTING_LEVEL
342: ,P_REPORTING_ENTITY_ID
343: ,'AUTO');
344: P_REPORTING_ENTITY_NAME := SUBSTRB(XLA_MO_REPORTING_API.GET_REPORTING_ENTITY_NAME
345: ,1
346: ,200);
347: P_REPORTING_LEVEL_NAME := SUBSTRB(XLA_MO_REPORTING_API.GET_REPORTING_LEVEL_NAME
348: ,1

Line 347: P_REPORTING_LEVEL_NAME := SUBSTRB(XLA_MO_REPORTING_API.GET_REPORTING_LEVEL_NAME

343: ,'AUTO');
344: P_REPORTING_ENTITY_NAME := SUBSTRB(XLA_MO_REPORTING_API.GET_REPORTING_ENTITY_NAME
345: ,1
346: ,200);
347: P_REPORTING_LEVEL_NAME := SUBSTRB(XLA_MO_REPORTING_API.GET_REPORTING_LEVEL_NAME
348: ,1
349: ,30);
350: P_ORG_WHERE_CUST_ACCT := XLA_MO_REPORTING_API.GET_PREDICATE('CUST_ACCT'
351: ,NULL);

Line 350: P_ORG_WHERE_CUST_ACCT := XLA_MO_REPORTING_API.GET_PREDICATE('CUST_ACCT'

346: ,200);
347: P_REPORTING_LEVEL_NAME := SUBSTRB(XLA_MO_REPORTING_API.GET_REPORTING_LEVEL_NAME
348: ,1
349: ,30);
350: P_ORG_WHERE_CUST_ACCT := XLA_MO_REPORTING_API.GET_PREDICATE('CUST_ACCT'
351: ,NULL);
352: P_ORG_WHERE_TRX := XLA_MO_REPORTING_API.GET_PREDICATE('TRX'
353: ,NULL);
354: P_ORG_WHERE_GL_DIST := XLA_MO_REPORTING_API.GET_PREDICATE('GL_DIST'

Line 352: P_ORG_WHERE_TRX := XLA_MO_REPORTING_API.GET_PREDICATE('TRX'

348: ,1
349: ,30);
350: P_ORG_WHERE_CUST_ACCT := XLA_MO_REPORTING_API.GET_PREDICATE('CUST_ACCT'
351: ,NULL);
352: P_ORG_WHERE_TRX := XLA_MO_REPORTING_API.GET_PREDICATE('TRX'
353: ,NULL);
354: P_ORG_WHERE_GL_DIST := XLA_MO_REPORTING_API.GET_PREDICATE('GL_DIST'
355: ,NULL);
356: IF P_START_GL_DATE IS NOT NULL THEN

Line 354: P_ORG_WHERE_GL_DIST := XLA_MO_REPORTING_API.GET_PREDICATE('GL_DIST'

350: P_ORG_WHERE_CUST_ACCT := XLA_MO_REPORTING_API.GET_PREDICATE('CUST_ACCT'
351: ,NULL);
352: P_ORG_WHERE_TRX := XLA_MO_REPORTING_API.GET_PREDICATE('TRX'
353: ,NULL);
354: P_ORG_WHERE_GL_DIST := XLA_MO_REPORTING_API.GET_PREDICATE('GL_DIST'
355: ,NULL);
356: IF P_START_GL_DATE IS NOT NULL THEN
357: LP_START_GL_DATE := 'and gl_dist.gl_date >= :p_start_gl_date ';
358: END IF;