DBA Data[Home] [Help]

APPS.ARRX_ADJ dependencies on XLA_MO_REPORTING_API

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

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

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

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

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

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

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

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

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

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

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

298: L_ADJ_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('ADJ',NULL);
299: L_TRX_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('TRX',NULL);
300:
301: --Bug fix 5595083 starts
302: L_SYSPARAM_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('SYSPARAM',NULL);
303: acct_stmt := 'select distinct ACCOUNTING_METHOD FROM ar_system_parameters_all SYSPARAM where ACCOUNTING_METHOD is not null ' || L_SYSPARAM_ORG_WHERE ;
304: IF var.p_reporting_level = 3000 then
305: IF var.p_reporting_entity_id IS NOT NULL THEN
306: execute immediate acct_stmt into ACCOUNTING_METHOD using var.p_reporting_entity_id, var.p_reporting_entity_id;

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

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