188: fa_rx_util_pkg.debug('Chart of Accounts ID : '||var.chart_of_accounts_id);
189: fa_rx_util_pkg.debug('Functional Currency : '||var.functional_currency_code);
190: fa_rx_util_pkg.debug('Organization Name : '||var.organization_name);
191:
192: XLA_MO_REPORTING_API.Initialize(var.p_reporting_level, var.p_reporting_entity_id, 'AUTO');
193:
194: L_APP_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('APP',NULL);
195: L_CR_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CR',NULL);
196: L_CRH_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CRH',NULL);
190: fa_rx_util_pkg.debug('Organization Name : '||var.organization_name);
191:
192: XLA_MO_REPORTING_API.Initialize(var.p_reporting_level, var.p_reporting_entity_id, 'AUTO');
193:
194: L_APP_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('APP',NULL);
195: L_CR_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CR',NULL);
196: L_CRH_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CRH',NULL);
197: -- L_PS_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('PS',NULL);
198: L_CUST_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CUST',NULL);
191:
192: XLA_MO_REPORTING_API.Initialize(var.p_reporting_level, var.p_reporting_entity_id, 'AUTO');
193:
194: L_APP_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('APP',NULL);
195: L_CR_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CR',NULL);
196: L_CRH_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CRH',NULL);
197: -- L_PS_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('PS',NULL);
198: L_CUST_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CUST',NULL);
199: L_BS_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('BS',NULL);
192: XLA_MO_REPORTING_API.Initialize(var.p_reporting_level, var.p_reporting_entity_id, 'AUTO');
193:
194: L_APP_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('APP',NULL);
195: L_CR_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CR',NULL);
196: L_CRH_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CRH',NULL);
197: -- L_PS_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('PS',NULL);
198: L_CUST_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CUST',NULL);
199: L_BS_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('BS',NULL);
200: L_RB_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('RB',NULL);
193:
194: L_APP_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('APP',NULL);
195: L_CR_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CR',NULL);
196: L_CRH_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CRH',NULL);
197: -- L_PS_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('PS',NULL);
198: L_CUST_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CUST',NULL);
199: L_BS_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('BS',NULL);
200: L_RB_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('RB',NULL);
201: L_AB_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CBA',NULL);
194: L_APP_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('APP',NULL);
195: L_CR_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CR',NULL);
196: L_CRH_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CRH',NULL);
197: -- L_PS_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('PS',NULL);
198: L_CUST_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CUST',NULL);
199: L_BS_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('BS',NULL);
200: L_RB_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('RB',NULL);
201: L_AB_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CBA',NULL);
202: L_BSFIRST_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('BSFIRST',NULL);
195: L_CR_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CR',NULL);
196: L_CRH_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CRH',NULL);
197: -- L_PS_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('PS',NULL);
198: L_CUST_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CUST',NULL);
199: L_BS_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('BS',NULL);
200: L_RB_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('RB',NULL);
201: L_AB_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CBA',NULL);
202: L_BSFIRST_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('BSFIRST',NULL);
203: L_CRHFIRST_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CRHFIRST',NULL);
196: L_CRH_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CRH',NULL);
197: -- L_PS_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('PS',NULL);
198: L_CUST_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CUST',NULL);
199: L_BS_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('BS',NULL);
200: L_RB_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('RB',NULL);
201: L_AB_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CBA',NULL);
202: L_BSFIRST_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('BSFIRST',NULL);
203: L_CRHFIRST_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CRHFIRST',NULL);
204: L_RBFIRST_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('RBFIRST',NULL);
197: -- L_PS_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('PS',NULL);
198: L_CUST_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CUST',NULL);
199: L_BS_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('BS',NULL);
200: L_RB_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('RB',NULL);
201: L_AB_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CBA',NULL);
202: L_BSFIRST_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('BSFIRST',NULL);
203: L_CRHFIRST_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CRHFIRST',NULL);
204: L_RBFIRST_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('RBFIRST',NULL);
205: --
198: L_CUST_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CUST',NULL);
199: L_BS_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('BS',NULL);
200: L_RB_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('RB',NULL);
201: L_AB_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CBA',NULL);
202: L_BSFIRST_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('BSFIRST',NULL);
203: L_CRHFIRST_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CRHFIRST',NULL);
204: L_RBFIRST_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('RBFIRST',NULL);
205: --
206: -- Figure out NOCOPY the where clause for the parameters
199: L_BS_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('BS',NULL);
200: L_RB_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('RB',NULL);
201: L_AB_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CBA',NULL);
202: L_BSFIRST_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('BSFIRST',NULL);
203: L_CRHFIRST_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CRHFIRST',NULL);
204: L_RBFIRST_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('RBFIRST',NULL);
205: --
206: -- Figure out NOCOPY the where clause for the parameters
207: --
200: L_RB_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('RB',NULL);
201: L_AB_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CBA',NULL);
202: L_BSFIRST_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('BSFIRST',NULL);
203: L_CRHFIRST_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CRHFIRST',NULL);
204: L_RBFIRST_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('RBFIRST',NULL);
205: --
206: -- Figure out NOCOPY the where clause for the parameters
207: --
208: fa_rx_util_pkg.debug('AR_GET_PARAMETERS');