DBA Data[Home] [Help]

APPS.ARRX_ADJ dependencies on XLA_MO_REPORTING_API

Line 293: XLA_MO_REPORTING_API.Initialize(var.p_reporting_level, var.p_reporting_entity_id, 'AUTO');

289: --SELECT distinct ACCOUNTING_METHOD
290: --INTO ACCOUNTING_METHOD
291: --FROM ar_system_parameters;
292:
293: XLA_MO_REPORTING_API.Initialize(var.p_reporting_level, var.p_reporting_entity_id, 'AUTO');
294:
295: L_CUST_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CUST',NULL);
296: L_PAY_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('PAY',NULL);
297: L_ADJ_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('ADJ',NULL);

Line 295: L_CUST_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CUST',NULL);

291: --FROM ar_system_parameters;
292:
293: XLA_MO_REPORTING_API.Initialize(var.p_reporting_level, var.p_reporting_entity_id, 'AUTO');
294:
295: L_CUST_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CUST',NULL);
296: L_PAY_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('PAY',NULL);
297: L_ADJ_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('ADJ',NULL);
298: L_TRX_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('TRX',NULL);
299:

Line 296: L_PAY_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('PAY',NULL);

292:
293: XLA_MO_REPORTING_API.Initialize(var.p_reporting_level, var.p_reporting_entity_id, 'AUTO');
294:
295: L_CUST_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CUST',NULL);
296: L_PAY_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('PAY',NULL);
297: L_ADJ_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('ADJ',NULL);
298: L_TRX_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('TRX',NULL);
299:
300: --Bug fix 5595083 starts

Line 297: L_ADJ_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('ADJ',NULL);

293: XLA_MO_REPORTING_API.Initialize(var.p_reporting_level, var.p_reporting_entity_id, 'AUTO');
294:
295: L_CUST_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CUST',NULL);
296: L_PAY_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('PAY',NULL);
297: L_ADJ_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('ADJ',NULL);
298: L_TRX_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('TRX',NULL);
299:
300: --Bug fix 5595083 starts
301: L_SYSPARAM_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('SYSPARAM',NULL);

Line 298: L_TRX_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('TRX',NULL);

294:
295: L_CUST_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CUST',NULL);
296: L_PAY_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('PAY',NULL);
297: L_ADJ_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('ADJ',NULL);
298: L_TRX_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('TRX',NULL);
299:
300: --Bug fix 5595083 starts
301: L_SYSPARAM_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('SYSPARAM',NULL);
302: acct_stmt := 'select distinct ACCOUNTING_METHOD FROM ar_system_parameters_all SYSPARAM where ACCOUNTING_METHOD is not null ' || L_SYSPARAM_ORG_WHERE ;

Line 301: L_SYSPARAM_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('SYSPARAM',NULL);

297: L_ADJ_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('ADJ',NULL);
298: L_TRX_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('TRX',NULL);
299:
300: --Bug fix 5595083 starts
301: L_SYSPARAM_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('SYSPARAM',NULL);
302: acct_stmt := 'select distinct ACCOUNTING_METHOD FROM ar_system_parameters_all SYSPARAM where ACCOUNTING_METHOD is not null ' || L_SYSPARAM_ORG_WHERE ;
303: IF var.p_reporting_level = 3000 then
304: Select decode(nvl(sla_ledger_cash_basis_flag, 'N'),'N', 'ACCRUAL', 'CASH')
305: into ACCOUNTING_METHOD

Line 470: L_CI_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CI',NULL);

466: val => BILL_FLAG );
467: IF (BILL_FLAG = 'Y') THEN
468: SHOW_BILL_WHERE := 'AND pay.cons_inv_id = ci.cons_inv_id(+)';
469: SHOW_BILL_FROM := ', ar_cons_inv_all ci ';
470: L_CI_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CI',NULL);
471: ELSE
472: SHOW_BILL_WHERE := NULL;
473: SHOW_BILL_FROM := NULL;
474: L_CI_ORG_WHERE := NULL;