DBA Data[Home] [Help]

APPS.AR_CALC_AGING dependencies on XLA_MO_REPORTING_API

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

54: l_trx_table := 'ra_customer_trx_all_mrc_v ';
55: l_cr_table := 'ar_cash_receipts_all_mrc_v ';
56: END IF;
57:
58: XLA_MO_REPORTING_API.Initialize(p_reporting_level, p_reporting_entity_id, 'AUTO');
59:
60: l_ps_org_where := XLA_MO_REPORTING_API.Get_Predicate('ps','push_subq');
61: l_gl_dist_org_where:= XLA_MO_REPORTING_API.Get_Predicate('gl_dist', 'push_subq');
62: l_trx_org_where := XLA_MO_REPORTING_API.Get_Predicate('trx', 'push_subq');

Line 60: l_ps_org_where := XLA_MO_REPORTING_API.Get_Predicate('ps','push_subq');

56: END IF;
57:
58: XLA_MO_REPORTING_API.Initialize(p_reporting_level, p_reporting_entity_id, 'AUTO');
59:
60: l_ps_org_where := XLA_MO_REPORTING_API.Get_Predicate('ps','push_subq');
61: l_gl_dist_org_where:= XLA_MO_REPORTING_API.Get_Predicate('gl_dist', 'push_subq');
62: l_trx_org_where := XLA_MO_REPORTING_API.Get_Predicate('trx', 'push_subq');
63: l_line_org_where := XLA_MO_REPORTING_API.Get_Predicate('lines','push_subq');
64: l_ra_org_where := XLA_MO_REPORTING_API.Get_Predicate('ra' , 'push_subq');

Line 61: l_gl_dist_org_where:= XLA_MO_REPORTING_API.Get_Predicate('gl_dist', 'push_subq');

57:
58: XLA_MO_REPORTING_API.Initialize(p_reporting_level, p_reporting_entity_id, 'AUTO');
59:
60: l_ps_org_where := XLA_MO_REPORTING_API.Get_Predicate('ps','push_subq');
61: l_gl_dist_org_where:= XLA_MO_REPORTING_API.Get_Predicate('gl_dist', 'push_subq');
62: l_trx_org_where := XLA_MO_REPORTING_API.Get_Predicate('trx', 'push_subq');
63: l_line_org_where := XLA_MO_REPORTING_API.Get_Predicate('lines','push_subq');
64: l_ra_org_where := XLA_MO_REPORTING_API.Get_Predicate('ra' , 'push_subq');
65: l_ard_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard','push_subq');

Line 62: l_trx_org_where := XLA_MO_REPORTING_API.Get_Predicate('trx', 'push_subq');

58: XLA_MO_REPORTING_API.Initialize(p_reporting_level, p_reporting_entity_id, 'AUTO');
59:
60: l_ps_org_where := XLA_MO_REPORTING_API.Get_Predicate('ps','push_subq');
61: l_gl_dist_org_where:= XLA_MO_REPORTING_API.Get_Predicate('gl_dist', 'push_subq');
62: l_trx_org_where := XLA_MO_REPORTING_API.Get_Predicate('trx', 'push_subq');
63: l_line_org_where := XLA_MO_REPORTING_API.Get_Predicate('lines','push_subq');
64: l_ra_org_where := XLA_MO_REPORTING_API.Get_Predicate('ra' , 'push_subq');
65: l_ard_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard','push_subq');
66: l_ard1_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard1','push_subq');

Line 63: l_line_org_where := XLA_MO_REPORTING_API.Get_Predicate('lines','push_subq');

59:
60: l_ps_org_where := XLA_MO_REPORTING_API.Get_Predicate('ps','push_subq');
61: l_gl_dist_org_where:= XLA_MO_REPORTING_API.Get_Predicate('gl_dist', 'push_subq');
62: l_trx_org_where := XLA_MO_REPORTING_API.Get_Predicate('trx', 'push_subq');
63: l_line_org_where := XLA_MO_REPORTING_API.Get_Predicate('lines','push_subq');
64: l_ra_org_where := XLA_MO_REPORTING_API.Get_Predicate('ra' , 'push_subq');
65: l_ard_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard','push_subq');
66: l_ard1_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard1','push_subq');
67: l_ath_org_where := XLA_MO_REPORTING_API.Get_Predicate('ath' ,'push_subq');

Line 64: l_ra_org_where := XLA_MO_REPORTING_API.Get_Predicate('ra' , 'push_subq');

60: l_ps_org_where := XLA_MO_REPORTING_API.Get_Predicate('ps','push_subq');
61: l_gl_dist_org_where:= XLA_MO_REPORTING_API.Get_Predicate('gl_dist', 'push_subq');
62: l_trx_org_where := XLA_MO_REPORTING_API.Get_Predicate('trx', 'push_subq');
63: l_line_org_where := XLA_MO_REPORTING_API.Get_Predicate('lines','push_subq');
64: l_ra_org_where := XLA_MO_REPORTING_API.Get_Predicate('ra' , 'push_subq');
65: l_ard_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard','push_subq');
66: l_ard1_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard1','push_subq');
67: l_ath_org_where := XLA_MO_REPORTING_API.Get_Predicate('ath' ,'push_subq');
68: l_adj_org_where := XLA_MO_REPORTING_API.Get_Predicate('adj' ,'push_subq');

Line 65: l_ard_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard','push_subq');

61: l_gl_dist_org_where:= XLA_MO_REPORTING_API.Get_Predicate('gl_dist', 'push_subq');
62: l_trx_org_where := XLA_MO_REPORTING_API.Get_Predicate('trx', 'push_subq');
63: l_line_org_where := XLA_MO_REPORTING_API.Get_Predicate('lines','push_subq');
64: l_ra_org_where := XLA_MO_REPORTING_API.Get_Predicate('ra' , 'push_subq');
65: l_ard_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard','push_subq');
66: l_ard1_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard1','push_subq');
67: l_ath_org_where := XLA_MO_REPORTING_API.Get_Predicate('ath' ,'push_subq');
68: l_adj_org_where := XLA_MO_REPORTING_API.Get_Predicate('adj' ,'push_subq');
69: l_cr_org_where := XLA_MO_REPORTING_API.Get_Predicate('cr' ,'push_subq');

Line 66: l_ard1_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard1','push_subq');

62: l_trx_org_where := XLA_MO_REPORTING_API.Get_Predicate('trx', 'push_subq');
63: l_line_org_where := XLA_MO_REPORTING_API.Get_Predicate('lines','push_subq');
64: l_ra_org_where := XLA_MO_REPORTING_API.Get_Predicate('ra' , 'push_subq');
65: l_ard_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard','push_subq');
66: l_ard1_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard1','push_subq');
67: l_ath_org_where := XLA_MO_REPORTING_API.Get_Predicate('ath' ,'push_subq');
68: l_adj_org_where := XLA_MO_REPORTING_API.Get_Predicate('adj' ,'push_subq');
69: l_cr_org_where := XLA_MO_REPORTING_API.Get_Predicate('cr' ,'push_subq');
70: /* Replace the variables to bind with the function calls so that we don't have to bind those */

Line 67: l_ath_org_where := XLA_MO_REPORTING_API.Get_Predicate('ath' ,'push_subq');

63: l_line_org_where := XLA_MO_REPORTING_API.Get_Predicate('lines','push_subq');
64: l_ra_org_where := XLA_MO_REPORTING_API.Get_Predicate('ra' , 'push_subq');
65: l_ard_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard','push_subq');
66: l_ard1_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard1','push_subq');
67: l_ath_org_where := XLA_MO_REPORTING_API.Get_Predicate('ath' ,'push_subq');
68: l_adj_org_where := XLA_MO_REPORTING_API.Get_Predicate('adj' ,'push_subq');
69: l_cr_org_where := XLA_MO_REPORTING_API.Get_Predicate('cr' ,'push_subq');
70: /* Replace the variables to bind with the function calls so that we don't have to bind those */
71: l_ps_org_where := replace(l_ps_org_where,

Line 68: l_adj_org_where := XLA_MO_REPORTING_API.Get_Predicate('adj' ,'push_subq');

64: l_ra_org_where := XLA_MO_REPORTING_API.Get_Predicate('ra' , 'push_subq');
65: l_ard_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard','push_subq');
66: l_ard1_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard1','push_subq');
67: l_ath_org_where := XLA_MO_REPORTING_API.Get_Predicate('ath' ,'push_subq');
68: l_adj_org_where := XLA_MO_REPORTING_API.Get_Predicate('adj' ,'push_subq');
69: l_cr_org_where := XLA_MO_REPORTING_API.Get_Predicate('cr' ,'push_subq');
70: /* Replace the variables to bind with the function calls so that we don't have to bind those */
71: l_ps_org_where := replace(l_ps_org_where,
72: ':p_reporting_entity_id','ar_calc_aging.get_reporting_entity_id()');

Line 69: l_cr_org_where := XLA_MO_REPORTING_API.Get_Predicate('cr' ,'push_subq');

65: l_ard_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard','push_subq');
66: l_ard1_org_where := XLA_MO_REPORTING_API.Get_Predicate('ard1','push_subq');
67: l_ath_org_where := XLA_MO_REPORTING_API.Get_Predicate('ath' ,'push_subq');
68: l_adj_org_where := XLA_MO_REPORTING_API.Get_Predicate('adj' ,'push_subq');
69: l_cr_org_where := XLA_MO_REPORTING_API.Get_Predicate('cr' ,'push_subq');
70: /* Replace the variables to bind with the function calls so that we don't have to bind those */
71: l_ps_org_where := replace(l_ps_org_where,
72: ':p_reporting_entity_id','ar_calc_aging.get_reporting_entity_id()');
73: l_gl_dist_org_where:= replace(l_gl_dist_org_where,

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

1872: ELSE
1873: l_sysparam_table := 'ar_system_parameters_all_mrc_v ';
1874: END IF;
1875:
1876: XLA_MO_REPORTING_API.Initialize(p_reporting_level, p_reporting_entity_id, 'AUTO');
1877:
1878: l_sysparam_where := XLA_MO_REPORTING_API.Get_Predicate('param',null);
1879:
1880: l_sysparam_where := replace(l_sysparam_where,

Line 1878: l_sysparam_where := XLA_MO_REPORTING_API.Get_Predicate('param',null);

1874: END IF;
1875:
1876: XLA_MO_REPORTING_API.Initialize(p_reporting_level, p_reporting_entity_id, 'AUTO');
1877:
1878: l_sysparam_where := XLA_MO_REPORTING_API.Get_Predicate('param',null);
1879:
1880: l_sysparam_where := replace(l_sysparam_where,
1881: ':p_reporting_entity_id','ar_calc_aging.get_reporting_entity_id()');
1882: