eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ARP_RECON_REP dependencies on ARP_RECON_REP

Line 1: PACKAGE BODY ARP_RECON_REP as

1: PACKAGE BODY ARP_RECON_REP as
2: /* $Header: ARGLRECB.pls 120.24.12010000.5 2009/03/05 10:35:34 ankuagar ship $ */
3:
4: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
5: LOG_LEVEL varchar2(1) := NVL(FND_PROFILE.value('AFLOG_LEVEL'), '6');

Line 20: return arp_recon_rep.var_tname.g_reporting_level;

16: ========================================================================*/
17:
18: FUNCTION get_reporting_level return VARCHAR2 is
19: BEGIN
20: return arp_recon_rep.var_tname.g_reporting_level;
21: END get_reporting_level;
22:
23: /*========================================================================+
24: Function which returns the global variable g_reporting_entity_id

Line 29: return arp_recon_rep.var_tname.g_reporting_entity_id;

25: ========================================================================*/
26:
27: FUNCTION get_reporting_entity_id return NUMBER is
28: BEGIN
29: return arp_recon_rep.var_tname.g_reporting_entity_id;
30: END get_reporting_entity_id;
31:
32: /*========================================================================+
33: Function which returns the global variable g_set_of_books_id

Line 38: return arp_recon_rep.var_tname.g_set_of_books_id;

34: ========================================================================*/
35:
36: FUNCTION get_set_of_books_id return NUMBER is
37: BEGIN
38: return arp_recon_rep.var_tname.g_set_of_books_id;
39: END get_set_of_books_id;
40:
41: /*========================================================================+
42: Function which returns the global variable g_chart_of_accounts_id

Line 47: return arp_recon_rep.var_tname.g_chart_of_accounts_id;

43: ========================================================================*/
44:
45: FUNCTION get_chart_of_accounts_id return NUMBER is
46: BEGIN
47: return arp_recon_rep.var_tname.g_chart_of_accounts_id;
48: END get_chart_of_accounts_id;
49:
50: /*========================================================================+
51: Function which returns the global variable g_gl_date_from

Line 56: return arp_recon_rep.var_tname.g_gl_date_from;

52: ========================================================================*/
53:
54: FUNCTION get_gl_date_from return DATE is
55: BEGIN
56: return arp_recon_rep.var_tname.g_gl_date_from;
57: END get_gl_date_from;
58:
59: /*========================================================================+
60: Function which returns the global variable g_gl_date_to

Line 65: return arp_recon_rep.var_tname.g_gl_date_to;

61: ========================================================================*/
62:
63: FUNCTION get_gl_date_to return DATE is
64: BEGIN
65: return arp_recon_rep.var_tname.g_gl_date_to;
66: END get_gl_date_to;
67:
68: /*========================================================================+
69: Function which returns the global variable g_posting_status

Line 74: return arp_recon_rep.var_tname.g_posting_status;

70: ========================================================================*/
71:
72: FUNCTION get_posting_status return VARCHAR2 is
73: BEGIN
74: return arp_recon_rep.var_tname.g_posting_status;
75: END get_posting_status;
76:
77: /*========================================================================+
78: Function which returns the maximum gl_date possible

Line 83: return arp_recon_rep.var_tname.g_max_gl_date;

79: ========================================================================*/
80:
81: FUNCTION get_max_gl_date return DATE IS
82: BEGIN
83: return arp_recon_rep.var_tname.g_max_gl_date;
84: END get_max_gl_date;
85:
86: /*========================================================================+
87: Function which returns the period name

Line 92: return arp_recon_rep.var_tname.g_period_name;

88: ========================================================================*/
89:
90: FUNCTION get_period_name return VARCHAR2 IS
91: BEGIN
92: return arp_recon_rep.var_tname.g_period_name;
93: END get_period_name;
94:
95: /*========================================================================+
96: Function which returns the functional currency

Line 101: return arp_recon_rep.var_tname.g_functional_currency;

97: ========================================================================*/
98:
99: FUNCTION get_functional_currency return VARCHAR2 IS
100: BEGIN
101: return arp_recon_rep.var_tname.g_functional_currency;
102: END get_functional_currency;
103:
104: /*========================================================================+
105: Function which returns the value of g_out_of_balance_only

Line 110: return arp_recon_rep.var_tname.g_out_of_balance_only;

106: ========================================================================*/
107:
108: FUNCTION get_out_of_balance_only return VARCHAR2 IS
109: BEGIN
110: return arp_recon_rep.var_tname.g_out_of_balance_only;
111: END get_out_of_balance_only;
112:
113: /*========================================================================+
114: | PUBLIC PROCEDURE GET_DETAIL_ACCOUNTS |

Line 283: arp_recon_rep.var_tname.l_ar_system_parameters_all := 'ar_system_parameters_all';

279: * report from reporting responsibility it would still work and in this case even though
280: * report is run for reporting book we still need to point to regular AR views
281: */
282: /* Set the table names based on the sob type */
283: arp_recon_rep.var_tname.l_ar_system_parameters_all := 'ar_system_parameters_all';
284: arp_recon_rep.var_tname.l_ar_payment_schedules_all := 'ar_payment_schedules_all';
285: arp_recon_rep.var_tname.l_ar_adjustments_all := 'ar_adjustments_all';
286: arp_recon_rep.var_tname.l_ar_cash_receipt_history_all := 'ar_cash_receipt_history_all';
287: arp_recon_rep.var_tname.l_ar_batches_all := 'ar_batches_all';

Line 284: arp_recon_rep.var_tname.l_ar_payment_schedules_all := 'ar_payment_schedules_all';

280: * report is run for reporting book we still need to point to regular AR views
281: */
282: /* Set the table names based on the sob type */
283: arp_recon_rep.var_tname.l_ar_system_parameters_all := 'ar_system_parameters_all';
284: arp_recon_rep.var_tname.l_ar_payment_schedules_all := 'ar_payment_schedules_all';
285: arp_recon_rep.var_tname.l_ar_adjustments_all := 'ar_adjustments_all';
286: arp_recon_rep.var_tname.l_ar_cash_receipt_history_all := 'ar_cash_receipt_history_all';
287: arp_recon_rep.var_tname.l_ar_batches_all := 'ar_batches_all';
288: arp_recon_rep.var_tname.l_ar_cash_receipts_all := 'ar_cash_receipts_all';

Line 285: arp_recon_rep.var_tname.l_ar_adjustments_all := 'ar_adjustments_all';

281: */
282: /* Set the table names based on the sob type */
283: arp_recon_rep.var_tname.l_ar_system_parameters_all := 'ar_system_parameters_all';
284: arp_recon_rep.var_tname.l_ar_payment_schedules_all := 'ar_payment_schedules_all';
285: arp_recon_rep.var_tname.l_ar_adjustments_all := 'ar_adjustments_all';
286: arp_recon_rep.var_tname.l_ar_cash_receipt_history_all := 'ar_cash_receipt_history_all';
287: arp_recon_rep.var_tname.l_ar_batches_all := 'ar_batches_all';
288: arp_recon_rep.var_tname.l_ar_cash_receipts_all := 'ar_cash_receipts_all';
289:

Line 286: arp_recon_rep.var_tname.l_ar_cash_receipt_history_all := 'ar_cash_receipt_history_all';

282: /* Set the table names based on the sob type */
283: arp_recon_rep.var_tname.l_ar_system_parameters_all := 'ar_system_parameters_all';
284: arp_recon_rep.var_tname.l_ar_payment_schedules_all := 'ar_payment_schedules_all';
285: arp_recon_rep.var_tname.l_ar_adjustments_all := 'ar_adjustments_all';
286: arp_recon_rep.var_tname.l_ar_cash_receipt_history_all := 'ar_cash_receipt_history_all';
287: arp_recon_rep.var_tname.l_ar_batches_all := 'ar_batches_all';
288: arp_recon_rep.var_tname.l_ar_cash_receipts_all := 'ar_cash_receipts_all';
289:
290: -- BUG#4429368 Replace ar_distributions_all by ar_xla_ard_lines_v

Line 287: arp_recon_rep.var_tname.l_ar_batches_all := 'ar_batches_all';

283: arp_recon_rep.var_tname.l_ar_system_parameters_all := 'ar_system_parameters_all';
284: arp_recon_rep.var_tname.l_ar_payment_schedules_all := 'ar_payment_schedules_all';
285: arp_recon_rep.var_tname.l_ar_adjustments_all := 'ar_adjustments_all';
286: arp_recon_rep.var_tname.l_ar_cash_receipt_history_all := 'ar_cash_receipt_history_all';
287: arp_recon_rep.var_tname.l_ar_batches_all := 'ar_batches_all';
288: arp_recon_rep.var_tname.l_ar_cash_receipts_all := 'ar_cash_receipts_all';
289:
290: -- BUG#4429368 Replace ar_distributions_all by ar_xla_ard_lines_v
291: arp_recon_rep.var_tname.l_ar_distributions_all := 'ar_xla_ard_lines_v';

Line 288: arp_recon_rep.var_tname.l_ar_cash_receipts_all := 'ar_cash_receipts_all';

284: arp_recon_rep.var_tname.l_ar_payment_schedules_all := 'ar_payment_schedules_all';
285: arp_recon_rep.var_tname.l_ar_adjustments_all := 'ar_adjustments_all';
286: arp_recon_rep.var_tname.l_ar_cash_receipt_history_all := 'ar_cash_receipt_history_all';
287: arp_recon_rep.var_tname.l_ar_batches_all := 'ar_batches_all';
288: arp_recon_rep.var_tname.l_ar_cash_receipts_all := 'ar_cash_receipts_all';
289:
290: -- BUG#4429368 Replace ar_distributions_all by ar_xla_ard_lines_v
291: arp_recon_rep.var_tname.l_ar_distributions_all := 'ar_xla_ard_lines_v';
292:

Line 291: arp_recon_rep.var_tname.l_ar_distributions_all := 'ar_xla_ard_lines_v';

287: arp_recon_rep.var_tname.l_ar_batches_all := 'ar_batches_all';
288: arp_recon_rep.var_tname.l_ar_cash_receipts_all := 'ar_cash_receipts_all';
289:
290: -- BUG#4429368 Replace ar_distributions_all by ar_xla_ard_lines_v
291: arp_recon_rep.var_tname.l_ar_distributions_all := 'ar_xla_ard_lines_v';
292:
293: arp_recon_rep.var_tname.l_ra_customer_trx_all := 'ra_customer_trx_all';
294: arp_recon_rep.var_tname.l_ra_batches_all := 'ra_batches_all';
295:

Line 293: arp_recon_rep.var_tname.l_ra_customer_trx_all := 'ra_customer_trx_all';

289:
290: -- BUG#4429368 Replace ar_distributions_all by ar_xla_ard_lines_v
291: arp_recon_rep.var_tname.l_ar_distributions_all := 'ar_xla_ard_lines_v';
292:
293: arp_recon_rep.var_tname.l_ra_customer_trx_all := 'ra_customer_trx_all';
294: arp_recon_rep.var_tname.l_ra_batches_all := 'ra_batches_all';
295:
296: -- BUG#4429368 Replace ra_cust_trx_line_gl_dist_all by ar_xla_ctlgd_lines_v
297: arp_recon_rep.var_tname.l_ra_cust_trx_gl_dist_all := 'ar_xla_ctlgd_lines_v';

Line 294: arp_recon_rep.var_tname.l_ra_batches_all := 'ra_batches_all';

290: -- BUG#4429368 Replace ar_distributions_all by ar_xla_ard_lines_v
291: arp_recon_rep.var_tname.l_ar_distributions_all := 'ar_xla_ard_lines_v';
292:
293: arp_recon_rep.var_tname.l_ra_customer_trx_all := 'ra_customer_trx_all';
294: arp_recon_rep.var_tname.l_ra_batches_all := 'ra_batches_all';
295:
296: -- BUG#4429368 Replace ra_cust_trx_line_gl_dist_all by ar_xla_ctlgd_lines_v
297: arp_recon_rep.var_tname.l_ra_cust_trx_gl_dist_all := 'ar_xla_ctlgd_lines_v';
298:

Line 297: arp_recon_rep.var_tname.l_ra_cust_trx_gl_dist_all := 'ar_xla_ctlgd_lines_v';

293: arp_recon_rep.var_tname.l_ra_customer_trx_all := 'ra_customer_trx_all';
294: arp_recon_rep.var_tname.l_ra_batches_all := 'ra_batches_all';
295:
296: -- BUG#4429368 Replace ra_cust_trx_line_gl_dist_all by ar_xla_ctlgd_lines_v
297: arp_recon_rep.var_tname.l_ra_cust_trx_gl_dist_all := 'ar_xla_ctlgd_lines_v';
298:
299: arp_recon_rep.var_tname.l_ar_misc_cash_dists_all := 'ar_misc_cash_distributions_all';
300: arp_recon_rep.var_tname.l_ar_rate_adjustments_all := 'ar_rate_adjustments_all';
301: arp_recon_rep.var_tname.l_ar_receivable_apps_all := 'ar_receivable_applications_all';

Line 299: arp_recon_rep.var_tname.l_ar_misc_cash_dists_all := 'ar_misc_cash_distributions_all';

295:
296: -- BUG#4429368 Replace ra_cust_trx_line_gl_dist_all by ar_xla_ctlgd_lines_v
297: arp_recon_rep.var_tname.l_ra_cust_trx_gl_dist_all := 'ar_xla_ctlgd_lines_v';
298:
299: arp_recon_rep.var_tname.l_ar_misc_cash_dists_all := 'ar_misc_cash_distributions_all';
300: arp_recon_rep.var_tname.l_ar_rate_adjustments_all := 'ar_rate_adjustments_all';
301: arp_recon_rep.var_tname.l_ar_receivable_apps_all := 'ar_receivable_applications_all';
302:
303: log('INIT (-)');

Line 300: arp_recon_rep.var_tname.l_ar_rate_adjustments_all := 'ar_rate_adjustments_all';

296: -- BUG#4429368 Replace ra_cust_trx_line_gl_dist_all by ar_xla_ctlgd_lines_v
297: arp_recon_rep.var_tname.l_ra_cust_trx_gl_dist_all := 'ar_xla_ctlgd_lines_v';
298:
299: arp_recon_rep.var_tname.l_ar_misc_cash_dists_all := 'ar_misc_cash_distributions_all';
300: arp_recon_rep.var_tname.l_ar_rate_adjustments_all := 'ar_rate_adjustments_all';
301: arp_recon_rep.var_tname.l_ar_receivable_apps_all := 'ar_receivable_applications_all';
302:
303: log('INIT (-)');
304:

Line 301: arp_recon_rep.var_tname.l_ar_receivable_apps_all := 'ar_receivable_applications_all';

297: arp_recon_rep.var_tname.l_ra_cust_trx_gl_dist_all := 'ar_xla_ctlgd_lines_v';
298:
299: arp_recon_rep.var_tname.l_ar_misc_cash_dists_all := 'ar_misc_cash_distributions_all';
300: arp_recon_rep.var_tname.l_ar_rate_adjustments_all := 'ar_rate_adjustments_all';
301: arp_recon_rep.var_tname.l_ar_receivable_apps_all := 'ar_receivable_applications_all';
302:
303: log('INIT (-)');
304:
305: END INIT;

Line 425: arp_recon_rep.var_tname.g_reporting_level := p_reporting_level;

421:
422: log ('aradj_journal_load_xml (+)');
423:
424: /* Assign the input parameters to the global variables */
425: arp_recon_rep.var_tname.g_reporting_level := p_reporting_level;
426: arp_recon_rep.var_tname.g_reporting_entity_id := p_reporting_entity_id;
427: /* bug 5654975 p_coa_id,p_sob_id is passed incorrectly when the user
428: has access to multiple Ledgers */
429: -- arp_recon_rep.var_tname.g_set_of_books_id := p_sob_id;

Line 426: arp_recon_rep.var_tname.g_reporting_entity_id := p_reporting_entity_id;

422: log ('aradj_journal_load_xml (+)');
423:
424: /* Assign the input parameters to the global variables */
425: arp_recon_rep.var_tname.g_reporting_level := p_reporting_level;
426: arp_recon_rep.var_tname.g_reporting_entity_id := p_reporting_entity_id;
427: /* bug 5654975 p_coa_id,p_sob_id is passed incorrectly when the user
428: has access to multiple Ledgers */
429: -- arp_recon_rep.var_tname.g_set_of_books_id := p_sob_id;
430: -- arp_recon_rep.var_tname.g_chart_of_accounts_id := p_coa_id;

Line 429: -- arp_recon_rep.var_tname.g_set_of_books_id := p_sob_id;

425: arp_recon_rep.var_tname.g_reporting_level := p_reporting_level;
426: arp_recon_rep.var_tname.g_reporting_entity_id := p_reporting_entity_id;
427: /* bug 5654975 p_coa_id,p_sob_id is passed incorrectly when the user
428: has access to multiple Ledgers */
429: -- arp_recon_rep.var_tname.g_set_of_books_id := p_sob_id;
430: -- arp_recon_rep.var_tname.g_chart_of_accounts_id := p_coa_id;
431: arp_recon_rep.var_tname.g_gl_date_from := fnd_date.canonical_to_date(p_gl_date_from);
432: arp_recon_rep.var_tname.g_gl_date_to := fnd_date.canonical_to_date(p_gl_date_to);
433: arp_recon_rep.var_tname.g_posting_status := p_posting_status;

Line 430: -- arp_recon_rep.var_tname.g_chart_of_accounts_id := p_coa_id;

426: arp_recon_rep.var_tname.g_reporting_entity_id := p_reporting_entity_id;
427: /* bug 5654975 p_coa_id,p_sob_id is passed incorrectly when the user
428: has access to multiple Ledgers */
429: -- arp_recon_rep.var_tname.g_set_of_books_id := p_sob_id;
430: -- arp_recon_rep.var_tname.g_chart_of_accounts_id := p_coa_id;
431: arp_recon_rep.var_tname.g_gl_date_from := fnd_date.canonical_to_date(p_gl_date_from);
432: arp_recon_rep.var_tname.g_gl_date_to := fnd_date.canonical_to_date(p_gl_date_to);
433: arp_recon_rep.var_tname.g_posting_status := p_posting_status;
434:

Line 431: arp_recon_rep.var_tname.g_gl_date_from := fnd_date.canonical_to_date(p_gl_date_from);

427: /* bug 5654975 p_coa_id,p_sob_id is passed incorrectly when the user
428: has access to multiple Ledgers */
429: -- arp_recon_rep.var_tname.g_set_of_books_id := p_sob_id;
430: -- arp_recon_rep.var_tname.g_chart_of_accounts_id := p_coa_id;
431: arp_recon_rep.var_tname.g_gl_date_from := fnd_date.canonical_to_date(p_gl_date_from);
432: arp_recon_rep.var_tname.g_gl_date_to := fnd_date.canonical_to_date(p_gl_date_to);
433: arp_recon_rep.var_tname.g_posting_status := p_posting_status;
434:
435: /* Added Conditional Implication to address bug:5181586*/

Line 432: arp_recon_rep.var_tname.g_gl_date_to := fnd_date.canonical_to_date(p_gl_date_to);

428: has access to multiple Ledgers */
429: -- arp_recon_rep.var_tname.g_set_of_books_id := p_sob_id;
430: -- arp_recon_rep.var_tname.g_chart_of_accounts_id := p_coa_id;
431: arp_recon_rep.var_tname.g_gl_date_from := fnd_date.canonical_to_date(p_gl_date_from);
432: arp_recon_rep.var_tname.g_gl_date_to := fnd_date.canonical_to_date(p_gl_date_to);
433: arp_recon_rep.var_tname.g_posting_status := p_posting_status;
434:
435: /* Added Conditional Implication to address bug:5181586*/
436: IF p_reporting_level = 1000 THEN

Line 433: arp_recon_rep.var_tname.g_posting_status := p_posting_status;

429: -- arp_recon_rep.var_tname.g_set_of_books_id := p_sob_id;
430: -- arp_recon_rep.var_tname.g_chart_of_accounts_id := p_coa_id;
431: arp_recon_rep.var_tname.g_gl_date_from := fnd_date.canonical_to_date(p_gl_date_from);
432: arp_recon_rep.var_tname.g_gl_date_to := fnd_date.canonical_to_date(p_gl_date_to);
433: arp_recon_rep.var_tname.g_posting_status := p_posting_status;
434:
435: /* Added Conditional Implication to address bug:5181586*/
436: IF p_reporting_level = 1000 THEN
437: SELECT sob.name sob_name,

Line 446: WHERE sob.set_of_books_id = arp_recon_rep.var_tname.g_reporting_entity_id;

442: l_sob_id,
443: l_functional_currency,
444: l_coa_id
445: FROM gl_sets_of_books sob
446: WHERE sob.set_of_books_id = arp_recon_rep.var_tname.g_reporting_entity_id;
447:
448: ELSIF p_reporting_level = 3000 THEN
449: SELECT sob.name sob_name,
450: sob.set_of_books_id,

Line 460: AND sysparam.org_id = arp_recon_rep.var_tname.g_reporting_entity_id;

456: l_coa_id
457: FROM gl_sets_of_books sob,
458: ar_system_parameters_all sysparam
459: WHERE sob.set_of_books_id = sysparam.set_of_books_id
460: AND sysparam.org_id = arp_recon_rep.var_tname.g_reporting_entity_id;
461:
462: END IF;
463: /* Changes for bug:5181586 ends*/
464:

Line 465: arp_recon_rep.var_tname.g_chart_of_accounts_id := l_coa_id;

461:
462: END IF;
463: /* Changes for bug:5181586 ends*/
464:
465: arp_recon_rep.var_tname.g_chart_of_accounts_id := l_coa_id;
466: arp_recon_rep.var_tname.g_set_of_books_id := l_sob_id;
467:
468: /* Initialize the reporting context */
469: init(p_sob_id);

Line 466: arp_recon_rep.var_tname.g_set_of_books_id := l_sob_id;

462: END IF;
463: /* Changes for bug:5181586 ends*/
464:
465: arp_recon_rep.var_tname.g_chart_of_accounts_id := l_coa_id;
466: arp_recon_rep.var_tname.g_set_of_books_id := l_sob_id;
467:
468: /* Initialize the reporting context */
469: init(p_sob_id);
470:

Line 486: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');

482:
483:
484: /* Replace the bind variables with global functions */
485: l_adj_org_where := replace(l_adj_org_where,
486: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
487: l_ard_org_where := replace(l_ard_org_where,
488: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
489: l_trx_org_where := replace(l_trx_org_where,
490: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');

Line 488: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');

484: /* Replace the bind variables with global functions */
485: l_adj_org_where := replace(l_adj_org_where,
486: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
487: l_ard_org_where := replace(l_ard_org_where,
488: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
489: l_trx_org_where := replace(l_trx_org_where,
490: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
491: l_pay_org_where := replace(l_pay_org_where,
492: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');

Line 490: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');

486: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
487: l_ard_org_where := replace(l_ard_org_where,
488: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
489: l_trx_org_where := replace(l_trx_org_where,
490: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
491: l_pay_org_where := replace(l_pay_org_where,
492: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
493: l_rec_org_where := replace(l_rec_org_where,
494: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');

Line 492: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');

488: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
489: l_trx_org_where := replace(l_trx_org_where,
490: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
491: l_pay_org_where := replace(l_pay_org_where,
492: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
493: l_rec_org_where := replace(l_rec_org_where,
494: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
495: l_type_org_where := replace(l_type_org_where,
496: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');

Line 494: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');

490: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
491: l_pay_org_where := replace(l_pay_org_where,
492: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
493: l_rec_org_where := replace(l_rec_org_where,
494: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
495: l_type_org_where := replace(l_type_org_where,
496: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
497: l_sysparam_org_where := replace(l_sysparam_org_where,
498: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');

Line 496: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');

492: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
493: l_rec_org_where := replace(l_rec_org_where,
494: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
495: l_type_org_where := replace(l_type_org_where,
496: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
497: l_sysparam_org_where := replace(l_sysparam_org_where,
498: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
499:
500:

Line 498: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');

494: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
495: l_type_org_where := replace(l_type_org_where,
496: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
497: l_sysparam_org_where := replace(l_sysparam_org_where,
498: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
499:
500:
501: l_reporting_entity_name := substrb(XLA_MO_REPORTING_API.get_reporting_entity_name,1,80);
502: l_reporting_level_name := substrb(XLA_MO_REPORTING_API.get_reporting_level_name,1,30);

Line 517: arp_recon_rep.var_tname.g_gl_date_from,

513:
514: /* Bug fix 4942083*/
515: IF arp_util.Open_Period_Exists(p_reporting_level,
516: p_reporting_entity_id,
517: arp_recon_rep.var_tname.g_gl_date_from,
518: arp_recon_rep.var_tname.g_gl_date_to) THEN
519: FND_MESSAGE.SET_NAME('AR','AR_REPORT_ACC_NOT_GEN');--Changed as per Bug 5578884 the parameter to AR from FND as the message is in AR product
520: l_message_acct := FND_MESSAGE.Get;
521: END IF;

Line 518: arp_recon_rep.var_tname.g_gl_date_to) THEN

514: /* Bug fix 4942083*/
515: IF arp_util.Open_Period_Exists(p_reporting_level,
516: p_reporting_entity_id,
517: arp_recon_rep.var_tname.g_gl_date_from,
518: arp_recon_rep.var_tname.g_gl_date_to) THEN
519: FND_MESSAGE.SET_NAME('AR','AR_REPORT_ACC_NOT_GEN');--Changed as per Bug 5578884 the parameter to AR from FND as the message is in AR product
520: l_message_acct := FND_MESSAGE.Get;
521: END IF;
522:

Line 528: where hou.organization_id = arp_recon_rep.var_tname.g_reporting_entity_id;

524: IF p_reporting_level = '3000' THEN
525: select substrb(hou.name,1,60)
526: into l_organization
527: from hr_organization_units hou
528: where hou.organization_id = arp_recon_rep.var_tname.g_reporting_entity_id;
529: ELSE
530: select meaning
531: into l_organization
532: from ar_lookups

Line 577: l_gl_date_where :=' and adj.gl_date <= arp_recon_rep.get_gl_date_to()';

573:
574: IF p_gl_date_from IS NULL and p_gl_date_to IS NULL THEN
575: l_gl_date_where := NULL;
576: ELSIF p_gl_date_from IS NULL THEN
577: l_gl_date_where :=' and adj.gl_date <= arp_recon_rep.get_gl_date_to()';
578: ELSIF p_gl_date_to IS NULL THEN
579: l_gl_date_where :=' and adj.gl_date >= arp_recon_rep.get_gl_date_from() ' ;
580: ELSE
581: l_gl_date_where := ' and adj.gl_date between arp_recon_rep.get_gl_date_from() and arp_recon_rep.get_gl_date_to() ';

Line 579: l_gl_date_where :=' and adj.gl_date >= arp_recon_rep.get_gl_date_from() ' ;

575: l_gl_date_where := NULL;
576: ELSIF p_gl_date_from IS NULL THEN
577: l_gl_date_where :=' and adj.gl_date <= arp_recon_rep.get_gl_date_to()';
578: ELSIF p_gl_date_to IS NULL THEN
579: l_gl_date_where :=' and adj.gl_date >= arp_recon_rep.get_gl_date_from() ' ;
580: ELSE
581: l_gl_date_where := ' and adj.gl_date between arp_recon_rep.get_gl_date_from() and arp_recon_rep.get_gl_date_to() ';
582: END IF;
583:

Line 581: l_gl_date_where := ' and adj.gl_date between arp_recon_rep.get_gl_date_from() and arp_recon_rep.get_gl_date_to() ';

577: l_gl_date_where :=' and adj.gl_date <= arp_recon_rep.get_gl_date_to()';
578: ELSIF p_gl_date_to IS NULL THEN
579: l_gl_date_where :=' and adj.gl_date >= arp_recon_rep.get_gl_date_from() ' ;
580: ELSE
581: l_gl_date_where := ' and adj.gl_date between arp_recon_rep.get_gl_date_from() and arp_recon_rep.get_gl_date_to() ';
582: END IF;
583:
584: IF p_gl_account_low IS NOT NULL AND p_gl_account_high IS NOT NULL THEN
585: l_account_where := ' AND ' || AR_CALC_AGING.FLEX_SQL(

Line 606: AND fcav.id_flex_num = arp_recon_rep.var_tname.g_chart_of_accounts_id

602: FROM fnd_segment_attribute_values fcav,
603: fnd_id_flex_segments fifs
604: WHERE fcav.application_id = 101
605: AND fcav.id_flex_code = 'GL#'
606: AND fcav.id_flex_num = arp_recon_rep.var_tname.g_chart_of_accounts_id
607: AND fcav.attribute_value = 'Y'
608: AND fcav.segment_attribute_type = 'GL_ACCOUNT'
609: AND fifs.application_id = fcav.application_id
610: AND fifs.id_flex_code = fcav.id_flex_code

Line 642: and lookup_code = arp_recon_rep.var_tname.g_posting_status;

638: select meaning
639: into l_status_meaning
640: from ar_lookups
641: where lookup_type = 'POSTED_STATUS'
642: and lookup_code = arp_recon_rep.var_tname.g_posting_status;
643:
644: l_posting_status_where := 'and nvl(adj.gl_posted_date,TO_DATE(''01/01/0001'',''MM/DD/YYYY'')) =
645: decode(arp_recon_rep.get_posting_status(),
646: ''POSTED'',adj.gl_posted_date,

Line 645: decode(arp_recon_rep.get_posting_status(),

641: where lookup_type = 'POSTED_STATUS'
642: and lookup_code = arp_recon_rep.var_tname.g_posting_status;
643:
644: l_posting_status_where := 'and nvl(adj.gl_posted_date,TO_DATE(''01/01/0001'',''MM/DD/YYYY'')) =
645: decode(arp_recon_rep.get_posting_status(),
646: ''POSTED'',adj.gl_posted_date,
647: ''UNPOSTED'',TO_DATE(''01/01/0001'',''MM/DD/YYYY''),
648: nvl(adj.gl_posted_date,TO_DATE(''01/01/0001'',''MM/DD/YYYY'')))';
649: ELSE

Line 675: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''ALL'',gc.code_combination_id) account,

671: nvl(ard.acctd_amount_dr,0) acctd_debit,
672: nvl(ard.acctd_amount_cr,0) acctd_credit,
673: gc.code_combination_id account_code_combination_id,
674: l_cat.meaning category,
675: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''ALL'',gc.code_combination_id) account,
676: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_BALANCING'',gc.code_combination_id) company,
677: ar_calc_aging.get_description(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_ACCOUNT'',gc.code_combination_id) account_desc
678: from hz_cust_accounts cust,
679: hz_parties party,

Line 676: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_BALANCING'',gc.code_combination_id) company,

672: nvl(ard.acctd_amount_cr,0) acctd_credit,
673: gc.code_combination_id account_code_combination_id,
674: l_cat.meaning category,
675: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''ALL'',gc.code_combination_id) account,
676: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_BALANCING'',gc.code_combination_id) company,
677: ar_calc_aging.get_description(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_ACCOUNT'',gc.code_combination_id) account_desc
678: from hz_cust_accounts cust,
679: hz_parties party,
680: ra_cust_trx_types_all type,

Line 677: ar_calc_aging.get_description(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_ACCOUNT'',gc.code_combination_id) account_desc

673: gc.code_combination_id account_code_combination_id,
674: l_cat.meaning category,
675: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''ALL'',gc.code_combination_id) account,
676: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_BALANCING'',gc.code_combination_id) company,
677: ar_calc_aging.get_description(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_ACCOUNT'',gc.code_combination_id) account_desc
678: from hz_cust_accounts cust,
679: hz_parties party,
680: ra_cust_trx_types_all type,
681: gl_code_combinations gc,

Line 682: '||arp_recon_rep.var_tname.l_ar_payment_schedules_all||' pay,

678: from hz_cust_accounts cust,
679: hz_parties party,
680: ra_cust_trx_types_all type,
681: gl_code_combinations gc,
682: '||arp_recon_rep.var_tname.l_ar_payment_schedules_all||' pay,
683: ar_receivables_trx_all rec,
684: '||arp_recon_rep.var_tname.l_ra_customer_trx_all||' trx,
685: '||arp_recon_rep.var_tname.l_ar_adjustments_all||' adj,
686: '||arp_recon_rep.var_tname.l_ar_distributions_all||' ard,

Line 684: '||arp_recon_rep.var_tname.l_ra_customer_trx_all||' trx,

680: ra_cust_trx_types_all type,
681: gl_code_combinations gc,
682: '||arp_recon_rep.var_tname.l_ar_payment_schedules_all||' pay,
683: ar_receivables_trx_all rec,
684: '||arp_recon_rep.var_tname.l_ra_customer_trx_all||' trx,
685: '||arp_recon_rep.var_tname.l_ar_adjustments_all||' adj,
686: '||arp_recon_rep.var_tname.l_ar_distributions_all||' ard,
687: ar_lookups look,
688: ar_lookups l_cat

Line 685: '||arp_recon_rep.var_tname.l_ar_adjustments_all||' adj,

681: gl_code_combinations gc,
682: '||arp_recon_rep.var_tname.l_ar_payment_schedules_all||' pay,
683: ar_receivables_trx_all rec,
684: '||arp_recon_rep.var_tname.l_ra_customer_trx_all||' trx,
685: '||arp_recon_rep.var_tname.l_ar_adjustments_all||' adj,
686: '||arp_recon_rep.var_tname.l_ar_distributions_all||' ard,
687: ar_lookups look,
688: ar_lookups l_cat
689: where trx.complete_flag = ''Y''

Line 686: '||arp_recon_rep.var_tname.l_ar_distributions_all||' ard,

682: '||arp_recon_rep.var_tname.l_ar_payment_schedules_all||' pay,
683: ar_receivables_trx_all rec,
684: '||arp_recon_rep.var_tname.l_ra_customer_trx_all||' trx,
685: '||arp_recon_rep.var_tname.l_ar_adjustments_all||' adj,
686: '||arp_recon_rep.var_tname.l_ar_distributions_all||' ard,
687: ar_lookups look,
688: ar_lookups l_cat
689: where trx.complete_flag = ''Y''
690: and cust.cust_account_id = trx.bill_to_customer_id

Line 692: and trx.set_of_books_id = arp_recon_rep.get_set_of_books_id()

688: ar_lookups l_cat
689: where trx.complete_flag = ''Y''
690: and cust.cust_account_id = trx.bill_to_customer_id
691: and cust.party_id = party.party_id
692: and trx.set_of_books_id = arp_recon_rep.get_set_of_books_id()
693: and trx.cust_trx_type_id = type.cust_trx_type_id
694: and trx.customer_trx_id = pay.customer_trx_id
695: and pay.payment_schedule_id = adj.payment_schedule_id
696: and nvl(adj.status, ''A'') = ''A''

Line 709: and gc.chart_of_accounts_id = arp_recon_rep.get_chart_of_accounts_id()

705: and nvl(rec.org_id,-99) = nvl(trx.org_id,-99)
706: and ard.source_id = adj.adjustment_id
707: and ard.source_table = ''ADJ''
708: and gc.code_combination_id = ard.code_combination_id
709: and gc.chart_of_accounts_id = arp_recon_rep.get_chart_of_accounts_id()
710: and l_cat.lookup_type = ''ARRGTA_FUNCTION_MAPPING''
711: and l_cat.lookup_code = (''ADJ_''||ard.source_type)
712: '||l_adj_org_where||'
713: '||l_ard_org_where||'

Line 929: arp_recon_rep.var_tname.g_reporting_level := p_reporting_level;

925:
926:
927:
928: /* Assign the input parameters to the global variables */
929: arp_recon_rep.var_tname.g_reporting_level := p_reporting_level;
930: arp_recon_rep.var_tname.g_reporting_entity_id := p_reporting_entity_id;
931: /* bug 5654975 p_sob_id is passed incorrectly when the user
932: has access to multiple Ledgers */
933: -- arp_recon_rep.var_tname.g_set_of_books_id := p_sob_id;

Line 930: arp_recon_rep.var_tname.g_reporting_entity_id := p_reporting_entity_id;

926:
927:
928: /* Assign the input parameters to the global variables */
929: arp_recon_rep.var_tname.g_reporting_level := p_reporting_level;
930: arp_recon_rep.var_tname.g_reporting_entity_id := p_reporting_entity_id;
931: /* bug 5654975 p_sob_id is passed incorrectly when the user
932: has access to multiple Ledgers */
933: -- arp_recon_rep.var_tname.g_set_of_books_id := p_sob_id;
934: /* Bug fix 5678284

Line 933: -- arp_recon_rep.var_tname.g_set_of_books_id := p_sob_id;

929: arp_recon_rep.var_tname.g_reporting_level := p_reporting_level;
930: arp_recon_rep.var_tname.g_reporting_entity_id := p_reporting_entity_id;
931: /* bug 5654975 p_sob_id is passed incorrectly when the user
932: has access to multiple Ledgers */
933: -- arp_recon_rep.var_tname.g_set_of_books_id := p_sob_id;
934: /* Bug fix 5678284
935: p_coa_id is passed incorrectly when the user has access to multiple Ledgers */
936: --arp_recon_rep.var_tname.g_chart_of_accounts_id := p_coa_id;
937: arp_recon_rep.var_tname.g_gl_date_from := fnd_date.canonical_to_date(p_gl_date_from);

Line 936: --arp_recon_rep.var_tname.g_chart_of_accounts_id := p_coa_id;

932: has access to multiple Ledgers */
933: -- arp_recon_rep.var_tname.g_set_of_books_id := p_sob_id;
934: /* Bug fix 5678284
935: p_coa_id is passed incorrectly when the user has access to multiple Ledgers */
936: --arp_recon_rep.var_tname.g_chart_of_accounts_id := p_coa_id;
937: arp_recon_rep.var_tname.g_gl_date_from := fnd_date.canonical_to_date(p_gl_date_from);
938: arp_recon_rep.var_tname.g_gl_date_to := fnd_date.canonical_to_date(p_gl_date_to);
939: arp_recon_rep.var_tname.g_posting_status := p_posting_status;
940: arp_recon_rep.var_tname.g_max_gl_date := to_date('31-12-4712','DD-MM-YYYY');

Line 937: arp_recon_rep.var_tname.g_gl_date_from := fnd_date.canonical_to_date(p_gl_date_from);

933: -- arp_recon_rep.var_tname.g_set_of_books_id := p_sob_id;
934: /* Bug fix 5678284
935: p_coa_id is passed incorrectly when the user has access to multiple Ledgers */
936: --arp_recon_rep.var_tname.g_chart_of_accounts_id := p_coa_id;
937: arp_recon_rep.var_tname.g_gl_date_from := fnd_date.canonical_to_date(p_gl_date_from);
938: arp_recon_rep.var_tname.g_gl_date_to := fnd_date.canonical_to_date(p_gl_date_to);
939: arp_recon_rep.var_tname.g_posting_status := p_posting_status;
940: arp_recon_rep.var_tname.g_max_gl_date := to_date('31-12-4712','DD-MM-YYYY');
941:

Line 938: arp_recon_rep.var_tname.g_gl_date_to := fnd_date.canonical_to_date(p_gl_date_to);

934: /* Bug fix 5678284
935: p_coa_id is passed incorrectly when the user has access to multiple Ledgers */
936: --arp_recon_rep.var_tname.g_chart_of_accounts_id := p_coa_id;
937: arp_recon_rep.var_tname.g_gl_date_from := fnd_date.canonical_to_date(p_gl_date_from);
938: arp_recon_rep.var_tname.g_gl_date_to := fnd_date.canonical_to_date(p_gl_date_to);
939: arp_recon_rep.var_tname.g_posting_status := p_posting_status;
940: arp_recon_rep.var_tname.g_max_gl_date := to_date('31-12-4712','DD-MM-YYYY');
941:
942:

Line 939: arp_recon_rep.var_tname.g_posting_status := p_posting_status;

935: p_coa_id is passed incorrectly when the user has access to multiple Ledgers */
936: --arp_recon_rep.var_tname.g_chart_of_accounts_id := p_coa_id;
937: arp_recon_rep.var_tname.g_gl_date_from := fnd_date.canonical_to_date(p_gl_date_from);
938: arp_recon_rep.var_tname.g_gl_date_to := fnd_date.canonical_to_date(p_gl_date_to);
939: arp_recon_rep.var_tname.g_posting_status := p_posting_status;
940: arp_recon_rep.var_tname.g_max_gl_date := to_date('31-12-4712','DD-MM-YYYY');
941:
942:
943:

Line 940: arp_recon_rep.var_tname.g_max_gl_date := to_date('31-12-4712','DD-MM-YYYY');

936: --arp_recon_rep.var_tname.g_chart_of_accounts_id := p_coa_id;
937: arp_recon_rep.var_tname.g_gl_date_from := fnd_date.canonical_to_date(p_gl_date_from);
938: arp_recon_rep.var_tname.g_gl_date_to := fnd_date.canonical_to_date(p_gl_date_to);
939: arp_recon_rep.var_tname.g_posting_status := p_posting_status;
940: arp_recon_rep.var_tname.g_max_gl_date := to_date('31-12-4712','DD-MM-YYYY');
941:
942:
943:
944: /* Added Conditional Implication to address bug:5181586*/

Line 956: WHERE sob.set_of_books_id = arp_recon_rep.var_tname.g_reporting_entity_id;

952: l_sob_id,
953: l_functional_currency,
954: l_coa_id
955: FROM gl_sets_of_books sob
956: WHERE sob.set_of_books_id = arp_recon_rep.var_tname.g_reporting_entity_id;
957:
958: ELSIF p_reporting_level = 3000 THEN
959: SELECT sob.name sob_name,
960: sob.set_of_books_id,

Line 970: AND sysparam.org_id = arp_recon_rep.var_tname.g_reporting_entity_id;

966: l_coa_id
967: FROM gl_sets_of_books sob,
968: ar_system_parameters_all sysparam
969: WHERE sob.set_of_books_id = sysparam.set_of_books_id
970: AND sysparam.org_id = arp_recon_rep.var_tname.g_reporting_entity_id;
971:
972: END IF;
973: /* Changes for bug:5181586 ends*/
974:

Line 975: arp_recon_rep.var_tname.g_set_of_books_id := l_sob_id;

971:
972: END IF;
973: /* Changes for bug:5181586 ends*/
974:
975: arp_recon_rep.var_tname.g_set_of_books_id := l_sob_id;
976: arp_recon_rep.var_tname.g_chart_of_accounts_id := l_coa_id;
977:
978: /* Initialize the reporting context */
979: init(p_sob_id);

Line 976: arp_recon_rep.var_tname.g_chart_of_accounts_id := l_coa_id;

972: END IF;
973: /* Changes for bug:5181586 ends*/
974:
975: arp_recon_rep.var_tname.g_set_of_books_id := l_sob_id;
976: arp_recon_rep.var_tname.g_chart_of_accounts_id := l_coa_id;
977:
978: /* Initialize the reporting context */
979: init(p_sob_id);
980:

Line 996: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');

992: l_sysparam_org_where := XLA_MO_REPORTING_API.Get_Predicate('sysparam',NULL);
993:
994: /* Replace the bind variables with global functions */
995: l_ra_org_where := replace(l_ra_org_where,
996: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
997: l_ard_org_where := replace(l_ard_org_where,
998: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
999: l_ps_org_where := replace(l_ps_org_where,
1000: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');

Line 998: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');

994: /* Replace the bind variables with global functions */
995: l_ra_org_where := replace(l_ra_org_where,
996: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
997: l_ard_org_where := replace(l_ard_org_where,
998: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
999: l_ps_org_where := replace(l_ps_org_where,
1000: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
1001: l_cr_org_where := replace(l_cr_org_where,
1002: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');

Line 1000: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');

996: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
997: l_ard_org_where := replace(l_ard_org_where,
998: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
999: l_ps_org_where := replace(l_ps_org_where,
1000: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
1001: l_cr_org_where := replace(l_cr_org_where,
1002: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
1003: l_crh_org_where := replace(l_crh_org_where,
1004: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');

Line 1002: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');

998: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
999: l_ps_org_where := replace(l_ps_org_where,
1000: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
1001: l_cr_org_where := replace(l_cr_org_where,
1002: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
1003: l_crh_org_where := replace(l_crh_org_where,
1004: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
1005: l_bat_org_where := replace(l_bat_org_where,
1006: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');

Line 1004: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');

1000: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
1001: l_cr_org_where := replace(l_cr_org_where,
1002: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
1003: l_crh_org_where := replace(l_crh_org_where,
1004: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
1005: l_bat_org_where := replace(l_bat_org_where,
1006: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
1007: l_bs_org_where := replace(l_bs_org_where,
1008: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');

Line 1006: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');

1002: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
1003: l_crh_org_where := replace(l_crh_org_where,
1004: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
1005: l_bat_org_where := replace(l_bat_org_where,
1006: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
1007: l_bs_org_where := replace(l_bs_org_where,
1008: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
1009:
1010: l_reporting_entity_name := substrb(XLA_MO_REPORTING_API.get_reporting_entity_name,1,80);

Line 1008: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');

1004: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
1005: l_bat_org_where := replace(l_bat_org_where,
1006: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
1007: l_bs_org_where := replace(l_bs_org_where,
1008: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
1009:
1010: l_reporting_entity_name := substrb(XLA_MO_REPORTING_API.get_reporting_entity_name,1,80);
1011: l_reporting_level_name := substrb(XLA_MO_REPORTING_API.get_reporting_level_name,1,30);
1012:

Line 1026: arp_recon_rep.var_tname.g_gl_date_from,

1022:
1023: /* Bug fix 4942083*/
1024: IF arp_util.Open_Period_Exists(p_reporting_level,
1025: p_reporting_entity_id,
1026: arp_recon_rep.var_tname.g_gl_date_from,
1027: arp_recon_rep.var_tname.g_gl_date_to) THEN
1028: FND_MESSAGE.SET_NAME('AR','AR_REPORT_ACC_NOT_GEN');--Changed as per Bug 5578884 the parameter to AR from FND as the message is in AR product
1029: l_message_acct := FND_MESSAGE.Get;
1030: END IF;

Line 1027: arp_recon_rep.var_tname.g_gl_date_to) THEN

1023: /* Bug fix 4942083*/
1024: IF arp_util.Open_Period_Exists(p_reporting_level,
1025: p_reporting_entity_id,
1026: arp_recon_rep.var_tname.g_gl_date_from,
1027: arp_recon_rep.var_tname.g_gl_date_to) THEN
1028: FND_MESSAGE.SET_NAME('AR','AR_REPORT_ACC_NOT_GEN');--Changed as per Bug 5578884 the parameter to AR from FND as the message is in AR product
1029: l_message_acct := FND_MESSAGE.Get;
1030: END IF;
1031:

Line 1037: where hou.organization_id = arp_recon_rep.var_tname.g_reporting_entity_id;

1033: IF p_reporting_level = '3000' THEN
1034: select substrb(hou.name,1,60)
1035: into l_organization
1036: from hr_organization_units hou
1037: where hou.organization_id = arp_recon_rep.var_tname.g_reporting_entity_id;
1038: ELSE
1039: select meaning
1040: into l_organization
1041: from ar_lookups

Line 1088: l_gl_date_where :=' and ra.gl_date <= arp_recon_rep.get_gl_date_to()';

1084: IF p_gl_date_from IS NULL and p_gl_date_to IS NULL THEN
1085: l_gl_date_where := NULL;
1086: l_gl_date_ard_where := NULL;
1087: ELSIF p_gl_date_from IS NULL THEN
1088: l_gl_date_where :=' and ra.gl_date <= arp_recon_rep.get_gl_date_to()';
1089: l_gl_date_ard_where :=' and ard.gl_date <= arp_recon_rep.get_gl_date_to()';
1090: ELSIF p_gl_date_to IS NULL THEN
1091: l_gl_date_where :=' and ra.gl_date >= arp_recon_rep.get_gl_date_from() ' ;
1092: l_gl_date_ard_where :=' and ard.gl_date >= arp_recon_rep.get_gl_date_from() ' ;

Line 1089: l_gl_date_ard_where :=' and ard.gl_date <= arp_recon_rep.get_gl_date_to()';

1085: l_gl_date_where := NULL;
1086: l_gl_date_ard_where := NULL;
1087: ELSIF p_gl_date_from IS NULL THEN
1088: l_gl_date_where :=' and ra.gl_date <= arp_recon_rep.get_gl_date_to()';
1089: l_gl_date_ard_where :=' and ard.gl_date <= arp_recon_rep.get_gl_date_to()';
1090: ELSIF p_gl_date_to IS NULL THEN
1091: l_gl_date_where :=' and ra.gl_date >= arp_recon_rep.get_gl_date_from() ' ;
1092: l_gl_date_ard_where :=' and ard.gl_date >= arp_recon_rep.get_gl_date_from() ' ;
1093: ELSE

Line 1091: l_gl_date_where :=' and ra.gl_date >= arp_recon_rep.get_gl_date_from() ' ;

1087: ELSIF p_gl_date_from IS NULL THEN
1088: l_gl_date_where :=' and ra.gl_date <= arp_recon_rep.get_gl_date_to()';
1089: l_gl_date_ard_where :=' and ard.gl_date <= arp_recon_rep.get_gl_date_to()';
1090: ELSIF p_gl_date_to IS NULL THEN
1091: l_gl_date_where :=' and ra.gl_date >= arp_recon_rep.get_gl_date_from() ' ;
1092: l_gl_date_ard_where :=' and ard.gl_date >= arp_recon_rep.get_gl_date_from() ' ;
1093: ELSE
1094: l_gl_date_where := ' and ra.gl_date between arp_recon_rep.get_gl_date_from() and arp_recon_rep.get_gl_date_to() ';
1095: l_gl_date_ard_where := ' and ard.gl_date between arp_recon_rep.get_gl_date_from() and arp_recon_rep.get_gl_date_to() ';

Line 1092: l_gl_date_ard_where :=' and ard.gl_date >= arp_recon_rep.get_gl_date_from() ' ;

1088: l_gl_date_where :=' and ra.gl_date <= arp_recon_rep.get_gl_date_to()';
1089: l_gl_date_ard_where :=' and ard.gl_date <= arp_recon_rep.get_gl_date_to()';
1090: ELSIF p_gl_date_to IS NULL THEN
1091: l_gl_date_where :=' and ra.gl_date >= arp_recon_rep.get_gl_date_from() ' ;
1092: l_gl_date_ard_where :=' and ard.gl_date >= arp_recon_rep.get_gl_date_from() ' ;
1093: ELSE
1094: l_gl_date_where := ' and ra.gl_date between arp_recon_rep.get_gl_date_from() and arp_recon_rep.get_gl_date_to() ';
1095: l_gl_date_ard_where := ' and ard.gl_date between arp_recon_rep.get_gl_date_from() and arp_recon_rep.get_gl_date_to() ';
1096: END IF;

Line 1094: l_gl_date_where := ' and ra.gl_date between arp_recon_rep.get_gl_date_from() and arp_recon_rep.get_gl_date_to() ';

1090: ELSIF p_gl_date_to IS NULL THEN
1091: l_gl_date_where :=' and ra.gl_date >= arp_recon_rep.get_gl_date_from() ' ;
1092: l_gl_date_ard_where :=' and ard.gl_date >= arp_recon_rep.get_gl_date_from() ' ;
1093: ELSE
1094: l_gl_date_where := ' and ra.gl_date between arp_recon_rep.get_gl_date_from() and arp_recon_rep.get_gl_date_to() ';
1095: l_gl_date_ard_where := ' and ard.gl_date between arp_recon_rep.get_gl_date_from() and arp_recon_rep.get_gl_date_to() ';
1096: END IF;
1097:
1098: IF p_gl_date_from IS NULL and p_gl_date_to IS NULL THEN

Line 1095: l_gl_date_ard_where := ' and ard.gl_date between arp_recon_rep.get_gl_date_from() and arp_recon_rep.get_gl_date_to() ';

1091: l_gl_date_where :=' and ra.gl_date >= arp_recon_rep.get_gl_date_from() ' ;
1092: l_gl_date_ard_where :=' and ard.gl_date >= arp_recon_rep.get_gl_date_from() ' ;
1093: ELSE
1094: l_gl_date_where := ' and ra.gl_date between arp_recon_rep.get_gl_date_from() and arp_recon_rep.get_gl_date_to() ';
1095: l_gl_date_ard_where := ' and ard.gl_date between arp_recon_rep.get_gl_date_from() and arp_recon_rep.get_gl_date_to() ';
1096: END IF;
1097:
1098: IF p_gl_date_from IS NULL and p_gl_date_to IS NULL THEN
1099: l_gl_date_closed_where := 'and ps.gl_date_closed = arp_recon_rep.get_max_gl_date()';

Line 1099: l_gl_date_closed_where := 'and ps.gl_date_closed = arp_recon_rep.get_max_gl_date()';

1095: l_gl_date_ard_where := ' and ard.gl_date between arp_recon_rep.get_gl_date_from() and arp_recon_rep.get_gl_date_to() ';
1096: END IF;
1097:
1098: IF p_gl_date_from IS NULL and p_gl_date_to IS NULL THEN
1099: l_gl_date_closed_where := 'and ps.gl_date_closed = arp_recon_rep.get_max_gl_date()';
1100: ELSIF p_gl_date_from IS NOT NULL THEN
1101: l_gl_date_closed_where := 'and ps.gl_date_closed >= arp_recon_rep.get_gl_date_from() ';
1102: ELSIF p_gl_date_to IS NOT NULL THEN
1103: l_gl_date_closed_where := 'and ps.gl_date_closed >= arp_recon_rep.get_gl_date_to()';

Line 1101: l_gl_date_closed_where := 'and ps.gl_date_closed >= arp_recon_rep.get_gl_date_from() ';

1097:
1098: IF p_gl_date_from IS NULL and p_gl_date_to IS NULL THEN
1099: l_gl_date_closed_where := 'and ps.gl_date_closed = arp_recon_rep.get_max_gl_date()';
1100: ELSIF p_gl_date_from IS NOT NULL THEN
1101: l_gl_date_closed_where := 'and ps.gl_date_closed >= arp_recon_rep.get_gl_date_from() ';
1102: ELSIF p_gl_date_to IS NOT NULL THEN
1103: l_gl_date_closed_where := 'and ps.gl_date_closed >= arp_recon_rep.get_gl_date_to()';
1104: END IF;
1105:

Line 1103: l_gl_date_closed_where := 'and ps.gl_date_closed >= arp_recon_rep.get_gl_date_to()';

1099: l_gl_date_closed_where := 'and ps.gl_date_closed = arp_recon_rep.get_max_gl_date()';
1100: ELSIF p_gl_date_from IS NOT NULL THEN
1101: l_gl_date_closed_where := 'and ps.gl_date_closed >= arp_recon_rep.get_gl_date_from() ';
1102: ELSIF p_gl_date_to IS NOT NULL THEN
1103: l_gl_date_closed_where := 'and ps.gl_date_closed >= arp_recon_rep.get_gl_date_to()';
1104: END IF;
1105:
1106: IF p_gl_account_low IS NOT NULL AND p_gl_account_high IS NOT NULL THEN
1107: l_account_where := ' AND ' || AR_CALC_AGING.FLEX_SQL(

Line 1128: AND fcav.id_flex_num = arp_recon_rep.var_tname.g_chart_of_accounts_id

1124: FROM fnd_segment_attribute_values fcav,
1125: fnd_id_flex_segments fifs
1126: WHERE fcav.application_id = 101
1127: AND fcav.id_flex_code = 'GL#'
1128: AND fcav.id_flex_num = arp_recon_rep.var_tname.g_chart_of_accounts_id
1129: AND fcav.attribute_value = 'Y'
1130: AND fcav.segment_attribute_type = 'GL_ACCOUNT'
1131: AND fifs.application_id = fcav.application_id
1132: AND fifs.id_flex_code = fcav.id_flex_code

Line 1166: and lookup_code = arp_recon_rep.var_tname.g_posting_status;

1162: select meaning
1163: into l_status_meaning
1164: from ar_lookups
1165: where lookup_type = 'POSTED_STATUS'
1166: and lookup_code = arp_recon_rep.var_tname.g_posting_status;
1167:
1168: l_posting_status_where := 'and nvl(ra.gl_posted_date,TO_DATE(''01/01/0001'',''MM/DD/YYYY'')) =
1169: decode(arp_recon_rep.get_posting_status(),
1170: ''POSTED'',ra.gl_posted_date,

Line 1169: decode(arp_recon_rep.get_posting_status(),

1165: where lookup_type = 'POSTED_STATUS'
1166: and lookup_code = arp_recon_rep.var_tname.g_posting_status;
1167:
1168: l_posting_status_where := 'and nvl(ra.gl_posted_date,TO_DATE(''01/01/0001'',''MM/DD/YYYY'')) =
1169: decode(arp_recon_rep.get_posting_status(),
1170: ''POSTED'',ra.gl_posted_date,
1171: ''UNPOSTED'',TO_DATE(''01/01/0001'',''MM/DD/YYYY''),
1172: nvl(ra.gl_posted_date,TO_DATE(''01/01/0001'',''MM/DD/YYYY'')))';
1173: /* Bug fix 5678284 : Added l_posting_status_ard_where*/

Line 1175: decode(arp_recon_rep.get_posting_status(),

1171: ''UNPOSTED'',TO_DATE(''01/01/0001'',''MM/DD/YYYY''),
1172: nvl(ra.gl_posted_date,TO_DATE(''01/01/0001'',''MM/DD/YYYY'')))';
1173: /* Bug fix 5678284 : Added l_posting_status_ard_where*/
1174: l_posting_status_ard_where := 'and nvl(ard.gl_posted_date,TO_DATE(''01/01/0001'',''MM/DD/YYYY'')) =
1175: decode(arp_recon_rep.get_posting_status(),
1176: ''POSTED'',ard.gl_posted_date,
1177: ''UNPOSTED'',TO_DATE(''01/01/0001'',''MM/DD/YYYY''),
1178: nvl(ard.gl_posted_date,TO_DATE(''01/01/0001'',''MM/DD/YYYY'')))';
1179: ELSE

Line 1205: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''ALL'',gc.code_combination_id) account,

1201: bat.name batch_name,
1202: l_cat.meaning category,
1203: /* 7008877 */
1204: ard.line_id,
1205: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''ALL'',gc.code_combination_id) account,
1206: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_BALANCING'',gc.code_combination_id) company,
1207: ar_calc_aging.get_description(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_ACCOUNT'',gc.code_combination_id) account_desc
1208: from '||arp_recon_rep.var_tname.l_ar_cash_receipts_all||' cr,
1209: ar_receipt_methods arm,

Line 1206: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_BALANCING'',gc.code_combination_id) company,

1202: l_cat.meaning category,
1203: /* 7008877 */
1204: ard.line_id,
1205: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''ALL'',gc.code_combination_id) account,
1206: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_BALANCING'',gc.code_combination_id) company,
1207: ar_calc_aging.get_description(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_ACCOUNT'',gc.code_combination_id) account_desc
1208: from '||arp_recon_rep.var_tname.l_ar_cash_receipts_all||' cr,
1209: ar_receipt_methods arm,
1210: '||arp_recon_rep.var_tname.l_ar_cash_receipt_history_all||' crh,

Line 1207: ar_calc_aging.get_description(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_ACCOUNT'',gc.code_combination_id) account_desc

1203: /* 7008877 */
1204: ard.line_id,
1205: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''ALL'',gc.code_combination_id) account,
1206: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_BALANCING'',gc.code_combination_id) company,
1207: ar_calc_aging.get_description(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_ACCOUNT'',gc.code_combination_id) account_desc
1208: from '||arp_recon_rep.var_tname.l_ar_cash_receipts_all||' cr,
1209: ar_receipt_methods arm,
1210: '||arp_recon_rep.var_tname.l_ar_cash_receipt_history_all||' crh,
1211: gl_code_combinations gc,

Line 1208: from '||arp_recon_rep.var_tname.l_ar_cash_receipts_all||' cr,

1204: ard.line_id,
1205: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''ALL'',gc.code_combination_id) account,
1206: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_BALANCING'',gc.code_combination_id) company,
1207: ar_calc_aging.get_description(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_ACCOUNT'',gc.code_combination_id) account_desc
1208: from '||arp_recon_rep.var_tname.l_ar_cash_receipts_all||' cr,
1209: ar_receipt_methods arm,
1210: '||arp_recon_rep.var_tname.l_ar_cash_receipt_history_all||' crh,
1211: gl_code_combinations gc,
1212: hz_cust_accounts cust,

Line 1210: '||arp_recon_rep.var_tname.l_ar_cash_receipt_history_all||' crh,

1206: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_BALANCING'',gc.code_combination_id) company,
1207: ar_calc_aging.get_description(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_ACCOUNT'',gc.code_combination_id) account_desc
1208: from '||arp_recon_rep.var_tname.l_ar_cash_receipts_all||' cr,
1209: ar_receipt_methods arm,
1210: '||arp_recon_rep.var_tname.l_ar_cash_receipt_history_all||' crh,
1211: gl_code_combinations gc,
1212: hz_cust_accounts cust,
1213: hz_parties party,
1214: '||arp_recon_rep.var_tname.l_ar_batches_all||' bat,

Line 1214: '||arp_recon_rep.var_tname.l_ar_batches_all||' bat,

1210: '||arp_recon_rep.var_tname.l_ar_cash_receipt_history_all||' crh,
1211: gl_code_combinations gc,
1212: hz_cust_accounts cust,
1213: hz_parties party,
1214: '||arp_recon_rep.var_tname.l_ar_batches_all||' bat,
1215: ar_batch_sources_all bs,
1216: '||arp_recon_rep.var_tname.l_ar_receivable_apps_all||' ra,
1217: '||arp_recon_rep.var_tname.l_ar_payment_schedules_all||' ps,
1218: '||arp_recon_rep.var_tname.l_ar_distributions_all||' ard,

Line 1216: '||arp_recon_rep.var_tname.l_ar_receivable_apps_all||' ra,

1212: hz_cust_accounts cust,
1213: hz_parties party,
1214: '||arp_recon_rep.var_tname.l_ar_batches_all||' bat,
1215: ar_batch_sources_all bs,
1216: '||arp_recon_rep.var_tname.l_ar_receivable_apps_all||' ra,
1217: '||arp_recon_rep.var_tname.l_ar_payment_schedules_all||' ps,
1218: '||arp_recon_rep.var_tname.l_ar_distributions_all||' ard,
1219: ar_lookups l_cat
1220: where nvl(ra.confirmed_flag,''Y'') = ''Y''

Line 1217: '||arp_recon_rep.var_tname.l_ar_payment_schedules_all||' ps,

1213: hz_parties party,
1214: '||arp_recon_rep.var_tname.l_ar_batches_all||' bat,
1215: ar_batch_sources_all bs,
1216: '||arp_recon_rep.var_tname.l_ar_receivable_apps_all||' ra,
1217: '||arp_recon_rep.var_tname.l_ar_payment_schedules_all||' ps,
1218: '||arp_recon_rep.var_tname.l_ar_distributions_all||' ard,
1219: ar_lookups l_cat
1220: where nvl(ra.confirmed_flag,''Y'') = ''Y''
1221: and ra.status in (''UNAPP'',''ACC'',''UNID'',''OTHER ACC'')

Line 1218: '||arp_recon_rep.var_tname.l_ar_distributions_all||' ard,

1214: '||arp_recon_rep.var_tname.l_ar_batches_all||' bat,
1215: ar_batch_sources_all bs,
1216: '||arp_recon_rep.var_tname.l_ar_receivable_apps_all||' ra,
1217: '||arp_recon_rep.var_tname.l_ar_payment_schedules_all||' ps,
1218: '||arp_recon_rep.var_tname.l_ar_distributions_all||' ard,
1219: ar_lookups l_cat
1220: where nvl(ra.confirmed_flag,''Y'') = ''Y''
1221: and ra.status in (''UNAPP'',''ACC'',''UNID'',''OTHER ACC'')
1222: and ps.cash_receipt_id = ra.cash_receipt_id

Line 1234: and gc.chart_of_accounts_id = arp_recon_rep.get_chart_of_accounts_id()

1230: and crh.batch_id = bat.batch_id(+)
1231: and bat.batch_source_id = bs.batch_source_id(+)
1232: and bat.org_id = bs.org_id(+)
1233: and gc.code_combination_id = ard.code_combination_id
1234: and gc.chart_of_accounts_id = arp_recon_rep.get_chart_of_accounts_id()
1235: and ard.source_id = ra.receivable_application_id
1236: and ard.source_table = ''RA''
1237: and cr.pay_from_customer = cust.cust_account_id(+)
1238: and cust.party_id = party.party_id(+)

Line 1273: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''ALL'',gc.code_combination_id) account,

1269: bat.name batch_name,
1270: l_cat.meaning category,
1271: /* 7008877 */
1272: ard.line_id,
1273: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''ALL'',gc.code_combination_id) account,
1274: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_BALANCING'',gc.code_combination_id) company,
1275: ar_calc_aging.get_description(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_ACCOUNT'',gc.code_combination_id) account_desc
1276: from '||arp_recon_rep.var_tname.l_ar_cash_receipts_all||' cr,
1277: ar_receipt_methods arm,

Line 1274: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_BALANCING'',gc.code_combination_id) company,

1270: l_cat.meaning category,
1271: /* 7008877 */
1272: ard.line_id,
1273: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''ALL'',gc.code_combination_id) account,
1274: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_BALANCING'',gc.code_combination_id) company,
1275: ar_calc_aging.get_description(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_ACCOUNT'',gc.code_combination_id) account_desc
1276: from '||arp_recon_rep.var_tname.l_ar_cash_receipts_all||' cr,
1277: ar_receipt_methods arm,
1278: '||arp_recon_rep.var_tname.l_ar_cash_receipt_history_all||' crh,

Line 1275: ar_calc_aging.get_description(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_ACCOUNT'',gc.code_combination_id) account_desc

1271: /* 7008877 */
1272: ard.line_id,
1273: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''ALL'',gc.code_combination_id) account,
1274: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_BALANCING'',gc.code_combination_id) company,
1275: ar_calc_aging.get_description(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_ACCOUNT'',gc.code_combination_id) account_desc
1276: from '||arp_recon_rep.var_tname.l_ar_cash_receipts_all||' cr,
1277: ar_receipt_methods arm,
1278: '||arp_recon_rep.var_tname.l_ar_cash_receipt_history_all||' crh,
1279: gl_code_combinations gc,

Line 1276: from '||arp_recon_rep.var_tname.l_ar_cash_receipts_all||' cr,

1272: ard.line_id,
1273: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''ALL'',gc.code_combination_id) account,
1274: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_BALANCING'',gc.code_combination_id) company,
1275: ar_calc_aging.get_description(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_ACCOUNT'',gc.code_combination_id) account_desc
1276: from '||arp_recon_rep.var_tname.l_ar_cash_receipts_all||' cr,
1277: ar_receipt_methods arm,
1278: '||arp_recon_rep.var_tname.l_ar_cash_receipt_history_all||' crh,
1279: gl_code_combinations gc,
1280: hz_cust_accounts cust,

Line 1278: '||arp_recon_rep.var_tname.l_ar_cash_receipt_history_all||' crh,

1274: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_BALANCING'',gc.code_combination_id) company,
1275: ar_calc_aging.get_description(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_ACCOUNT'',gc.code_combination_id) account_desc
1276: from '||arp_recon_rep.var_tname.l_ar_cash_receipts_all||' cr,
1277: ar_receipt_methods arm,
1278: '||arp_recon_rep.var_tname.l_ar_cash_receipt_history_all||' crh,
1279: gl_code_combinations gc,
1280: hz_cust_accounts cust,
1281: hz_parties party,
1282: '||arp_recon_rep.var_tname.l_ar_batches_all||' bat,

Line 1282: '||arp_recon_rep.var_tname.l_ar_batches_all||' bat,

1278: '||arp_recon_rep.var_tname.l_ar_cash_receipt_history_all||' crh,
1279: gl_code_combinations gc,
1280: hz_cust_accounts cust,
1281: hz_parties party,
1282: '||arp_recon_rep.var_tname.l_ar_batches_all||' bat,
1283: ar_batch_sources_all bs,
1284: '||arp_recon_rep.var_tname.l_ar_payment_schedules_all||' ps,
1285: '||arp_recon_rep.var_tname.l_ar_distributions_all||' ard,
1286: ar_lookups l_cat

Line 1284: '||arp_recon_rep.var_tname.l_ar_payment_schedules_all||' ps,

1280: hz_cust_accounts cust,
1281: hz_parties party,
1282: '||arp_recon_rep.var_tname.l_ar_batches_all||' bat,
1283: ar_batch_sources_all bs,
1284: '||arp_recon_rep.var_tname.l_ar_payment_schedules_all||' ps,
1285: '||arp_recon_rep.var_tname.l_ar_distributions_all||' ard,
1286: ar_lookups l_cat
1287: where ard.source_type = ''UNAPP''
1288: and ps.cash_receipt_id = ard.cash_receipt_id

Line 1285: '||arp_recon_rep.var_tname.l_ar_distributions_all||' ard,

1281: hz_parties party,
1282: '||arp_recon_rep.var_tname.l_ar_batches_all||' bat,
1283: ar_batch_sources_all bs,
1284: '||arp_recon_rep.var_tname.l_ar_payment_schedules_all||' ps,
1285: '||arp_recon_rep.var_tname.l_ar_distributions_all||' ard,
1286: ar_lookups l_cat
1287: where ard.source_type = ''UNAPP''
1288: and ps.cash_receipt_id = ard.cash_receipt_id
1289: and ps.class = ''PMT''

Line 1300: and gc.chart_of_accounts_id = arp_recon_rep.get_chart_of_accounts_id()

1296: and crh.batch_id = bat.batch_id(+)
1297: and bat.batch_source_id = bs.batch_source_id(+)
1298: and bat.org_id = bs.org_id(+)
1299: and gc.code_combination_id = ard.code_combination_id
1300: and gc.chart_of_accounts_id = arp_recon_rep.get_chart_of_accounts_id()
1301: and ard.cash_receipt_id = ps.cash_receipt_id
1302: and ard.source_table in(''CRH'', ''RA'')
1303: and cr.pay_from_customer = cust.cust_account_id(+)
1304: and cust.party_id = party.party_id(+)

Line 1521: arp_recon_rep.var_tname.g_reporting_level := p_reporting_level;

1517:
1518: log('arapp_journal_load_xml (+)');
1519:
1520: /* Assign the input parameters to the global variables */
1521: arp_recon_rep.var_tname.g_reporting_level := p_reporting_level;
1522: arp_recon_rep.var_tname.g_reporting_entity_id := p_reporting_entity_id;
1523: /* bug 5654975 p_coa_id,p_sob_id is passed incorrectly when the user
1524: has access to multiple Ledgers */
1525: -- arp_recon_rep.var_tname.g_set_of_books_id := p_sob_id;

Line 1522: arp_recon_rep.var_tname.g_reporting_entity_id := p_reporting_entity_id;

1518: log('arapp_journal_load_xml (+)');
1519:
1520: /* Assign the input parameters to the global variables */
1521: arp_recon_rep.var_tname.g_reporting_level := p_reporting_level;
1522: arp_recon_rep.var_tname.g_reporting_entity_id := p_reporting_entity_id;
1523: /* bug 5654975 p_coa_id,p_sob_id is passed incorrectly when the user
1524: has access to multiple Ledgers */
1525: -- arp_recon_rep.var_tname.g_set_of_books_id := p_sob_id;
1526: -- arp_recon_rep.var_tname.g_chart_of_accounts_id := p_coa_id;

Line 1525: -- arp_recon_rep.var_tname.g_set_of_books_id := p_sob_id;

1521: arp_recon_rep.var_tname.g_reporting_level := p_reporting_level;
1522: arp_recon_rep.var_tname.g_reporting_entity_id := p_reporting_entity_id;
1523: /* bug 5654975 p_coa_id,p_sob_id is passed incorrectly when the user
1524: has access to multiple Ledgers */
1525: -- arp_recon_rep.var_tname.g_set_of_books_id := p_sob_id;
1526: -- arp_recon_rep.var_tname.g_chart_of_accounts_id := p_coa_id;
1527: arp_recon_rep.var_tname.g_gl_date_from := fnd_date.canonical_to_date(p_gl_date_from);
1528: arp_recon_rep.var_tname.g_gl_date_to := fnd_date.canonical_to_date(p_gl_date_to);
1529: arp_recon_rep.var_tname.g_posting_status := p_posting_status;

Line 1526: -- arp_recon_rep.var_tname.g_chart_of_accounts_id := p_coa_id;

1522: arp_recon_rep.var_tname.g_reporting_entity_id := p_reporting_entity_id;
1523: /* bug 5654975 p_coa_id,p_sob_id is passed incorrectly when the user
1524: has access to multiple Ledgers */
1525: -- arp_recon_rep.var_tname.g_set_of_books_id := p_sob_id;
1526: -- arp_recon_rep.var_tname.g_chart_of_accounts_id := p_coa_id;
1527: arp_recon_rep.var_tname.g_gl_date_from := fnd_date.canonical_to_date(p_gl_date_from);
1528: arp_recon_rep.var_tname.g_gl_date_to := fnd_date.canonical_to_date(p_gl_date_to);
1529: arp_recon_rep.var_tname.g_posting_status := p_posting_status;
1530:

Line 1527: arp_recon_rep.var_tname.g_gl_date_from := fnd_date.canonical_to_date(p_gl_date_from);

1523: /* bug 5654975 p_coa_id,p_sob_id is passed incorrectly when the user
1524: has access to multiple Ledgers */
1525: -- arp_recon_rep.var_tname.g_set_of_books_id := p_sob_id;
1526: -- arp_recon_rep.var_tname.g_chart_of_accounts_id := p_coa_id;
1527: arp_recon_rep.var_tname.g_gl_date_from := fnd_date.canonical_to_date(p_gl_date_from);
1528: arp_recon_rep.var_tname.g_gl_date_to := fnd_date.canonical_to_date(p_gl_date_to);
1529: arp_recon_rep.var_tname.g_posting_status := p_posting_status;
1530:
1531: /* Added Conditional Implication to address bug:5181586*/

Line 1528: arp_recon_rep.var_tname.g_gl_date_to := fnd_date.canonical_to_date(p_gl_date_to);

1524: has access to multiple Ledgers */
1525: -- arp_recon_rep.var_tname.g_set_of_books_id := p_sob_id;
1526: -- arp_recon_rep.var_tname.g_chart_of_accounts_id := p_coa_id;
1527: arp_recon_rep.var_tname.g_gl_date_from := fnd_date.canonical_to_date(p_gl_date_from);
1528: arp_recon_rep.var_tname.g_gl_date_to := fnd_date.canonical_to_date(p_gl_date_to);
1529: arp_recon_rep.var_tname.g_posting_status := p_posting_status;
1530:
1531: /* Added Conditional Implication to address bug:5181586*/
1532: /*Added set of books id and char of accounts id for bug fix 5654975 */

Line 1529: arp_recon_rep.var_tname.g_posting_status := p_posting_status;

1525: -- arp_recon_rep.var_tname.g_set_of_books_id := p_sob_id;
1526: -- arp_recon_rep.var_tname.g_chart_of_accounts_id := p_coa_id;
1527: arp_recon_rep.var_tname.g_gl_date_from := fnd_date.canonical_to_date(p_gl_date_from);
1528: arp_recon_rep.var_tname.g_gl_date_to := fnd_date.canonical_to_date(p_gl_date_to);
1529: arp_recon_rep.var_tname.g_posting_status := p_posting_status;
1530:
1531: /* Added Conditional Implication to address bug:5181586*/
1532: /*Added set of books id and char of accounts id for bug fix 5654975 */
1533: IF p_reporting_level = 1000 THEN

Line 1543: WHERE sob.set_of_books_id = arp_recon_rep.var_tname.g_reporting_entity_id;

1539: l_sob_id,
1540: l_functional_currency,
1541: l_coa_id
1542: FROM gl_sets_of_books sob
1543: WHERE sob.set_of_books_id = arp_recon_rep.var_tname.g_reporting_entity_id;
1544:
1545: ELSIF p_reporting_level = 3000 THEN
1546: SELECT sob.name sob_name,
1547: sob.set_of_books_id,

Line 1557: AND sysparam.org_id = arp_recon_rep.var_tname.g_reporting_entity_id;

1553: l_coa_id
1554: FROM gl_sets_of_books sob,
1555: ar_system_parameters_all sysparam
1556: WHERE sob.set_of_books_id = sysparam.set_of_books_id
1557: AND sysparam.org_id = arp_recon_rep.var_tname.g_reporting_entity_id;
1558:
1559: END IF;
1560: /* Changes for bug:5181586 ends*/
1561:

Line 1562: arp_recon_rep.var_tname.g_set_of_books_id := l_sob_id;

1558:
1559: END IF;
1560: /* Changes for bug:5181586 ends*/
1561:
1562: arp_recon_rep.var_tname.g_set_of_books_id := l_sob_id;
1563: arp_recon_rep.var_tname.g_chart_of_accounts_id := l_coa_id;
1564:
1565: /* Initialize the reporting context */
1566: init(p_sob_id);

Line 1563: arp_recon_rep.var_tname.g_chart_of_accounts_id := l_coa_id;

1559: END IF;
1560: /* Changes for bug:5181586 ends*/
1561:
1562: arp_recon_rep.var_tname.g_set_of_books_id := l_sob_id;
1563: arp_recon_rep.var_tname.g_chart_of_accounts_id := l_coa_id;
1564:
1565: /* Initialize the reporting context */
1566: init(p_sob_id);
1567:

Line 1584: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');

1580: l_sysparam_org_where := XLA_MO_REPORTING_API.Get_Predicate('sysparam',NULL);
1581:
1582: /* Replace the bind variables with global functions */
1583: l_ra_org_where := replace(l_ra_org_where,
1584: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
1585: l_ard_org_where := replace(l_ard_org_where,
1586: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
1587: l_ard1_org_where := replace(l_ard1_org_where,
1588: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');

Line 1586: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');

1582: /* Replace the bind variables with global functions */
1583: l_ra_org_where := replace(l_ra_org_where,
1584: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
1585: l_ard_org_where := replace(l_ard_org_where,
1586: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
1587: l_ard1_org_where := replace(l_ard1_org_where,
1588: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
1589: l_ps_org_where := replace(l_ps_org_where,
1590: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');

Line 1588: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');

1584: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
1585: l_ard_org_where := replace(l_ard_org_where,
1586: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
1587: l_ard1_org_where := replace(l_ard1_org_where,
1588: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
1589: l_ps_org_where := replace(l_ps_org_where,
1590: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
1591: l_cr_org_where := replace(l_cr_org_where,
1592: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');

Line 1590: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');

1586: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
1587: l_ard1_org_where := replace(l_ard1_org_where,
1588: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
1589: l_ps_org_where := replace(l_ps_org_where,
1590: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
1591: l_cr_org_where := replace(l_cr_org_where,
1592: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
1593: l_crh_org_where := replace(l_crh_org_where,
1594: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');

Line 1592: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');

1588: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
1589: l_ps_org_where := replace(l_ps_org_where,
1590: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
1591: l_cr_org_where := replace(l_cr_org_where,
1592: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
1593: l_crh_org_where := replace(l_crh_org_where,
1594: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
1595: l_bat_org_where := replace(l_bat_org_where,
1596: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');

Line 1594: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');

1590: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
1591: l_cr_org_where := replace(l_cr_org_where,
1592: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
1593: l_crh_org_where := replace(l_crh_org_where,
1594: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
1595: l_bat_org_where := replace(l_bat_org_where,
1596: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
1597: l_bs_org_where := replace(l_bs_org_where,
1598: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');

Line 1596: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');

1592: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
1593: l_crh_org_where := replace(l_crh_org_where,
1594: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
1595: l_bat_org_where := replace(l_bat_org_where,
1596: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
1597: l_bs_org_where := replace(l_bs_org_where,
1598: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
1599: l_sysparam_org_where := replace(l_sysparam_org_where,
1600: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');

Line 1598: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');

1594: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
1595: l_bat_org_where := replace(l_bat_org_where,
1596: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
1597: l_bs_org_where := replace(l_bs_org_where,
1598: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
1599: l_sysparam_org_where := replace(l_sysparam_org_where,
1600: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
1601:
1602:

Line 1600: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');

1596: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
1597: l_bs_org_where := replace(l_bs_org_where,
1598: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
1599: l_sysparam_org_where := replace(l_sysparam_org_where,
1600: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
1601:
1602:
1603: l_reporting_entity_name := substrb(XLA_MO_REPORTING_API.get_reporting_entity_name,1,80);
1604: l_reporting_level_name := substrb(XLA_MO_REPORTING_API.get_reporting_level_name,1,30);

Line 1619: arp_recon_rep.var_tname.g_gl_date_from,

1615:
1616: /* Bug fix 4942083*/
1617: IF arp_util.Open_Period_Exists(p_reporting_level,
1618: p_reporting_entity_id,
1619: arp_recon_rep.var_tname.g_gl_date_from,
1620: arp_recon_rep.var_tname.g_gl_date_to) THEN
1621: FND_MESSAGE.SET_NAME('AR','AR_REPORT_ACC_NOT_GEN');--Changed as per Bug 5578884 the parameter to AR from FND as the message is in AR product
1622: l_message_acct := FND_MESSAGE.Get;
1623: END IF;

Line 1620: arp_recon_rep.var_tname.g_gl_date_to) THEN

1616: /* Bug fix 4942083*/
1617: IF arp_util.Open_Period_Exists(p_reporting_level,
1618: p_reporting_entity_id,
1619: arp_recon_rep.var_tname.g_gl_date_from,
1620: arp_recon_rep.var_tname.g_gl_date_to) THEN
1621: FND_MESSAGE.SET_NAME('AR','AR_REPORT_ACC_NOT_GEN');--Changed as per Bug 5578884 the parameter to AR from FND as the message is in AR product
1622: l_message_acct := FND_MESSAGE.Get;
1623: END IF;
1624:

Line 1630: where hou.organization_id = arp_recon_rep.var_tname.g_reporting_entity_id;

1626: IF p_reporting_level = '3000' THEN
1627: select substrb(hou.name,1,60)
1628: into l_organization
1629: from hr_organization_units hou
1630: where hou.organization_id = arp_recon_rep.var_tname.g_reporting_entity_id;
1631: ELSE
1632: select meaning
1633: into l_organization
1634: from ar_lookups

Line 1681: l_gl_date_where :=' and ra.gl_date <= arp_recon_rep.get_gl_date_to()';

1677:
1678: IF p_gl_date_from IS NULL and p_gl_date_to IS NULL THEN
1679: l_gl_date_where := NULL;
1680: ELSIF p_gl_date_from IS NULL THEN
1681: l_gl_date_where :=' and ra.gl_date <= arp_recon_rep.get_gl_date_to()';
1682: ELSIF p_gl_date_to IS NULL THEN
1683: l_gl_date_where :=' and ra.gl_date >= arp_recon_rep.get_gl_date_from() ' ;
1684: ELSE
1685: l_gl_date_where := ' and ra.gl_date between arp_recon_rep.get_gl_date_from() and arp_recon_rep.get_gl_date_to() ';

Line 1683: l_gl_date_where :=' and ra.gl_date >= arp_recon_rep.get_gl_date_from() ' ;

1679: l_gl_date_where := NULL;
1680: ELSIF p_gl_date_from IS NULL THEN
1681: l_gl_date_where :=' and ra.gl_date <= arp_recon_rep.get_gl_date_to()';
1682: ELSIF p_gl_date_to IS NULL THEN
1683: l_gl_date_where :=' and ra.gl_date >= arp_recon_rep.get_gl_date_from() ' ;
1684: ELSE
1685: l_gl_date_where := ' and ra.gl_date between arp_recon_rep.get_gl_date_from() and arp_recon_rep.get_gl_date_to() ';
1686: END IF;
1687:

Line 1685: l_gl_date_where := ' and ra.gl_date between arp_recon_rep.get_gl_date_from() and arp_recon_rep.get_gl_date_to() ';

1681: l_gl_date_where :=' and ra.gl_date <= arp_recon_rep.get_gl_date_to()';
1682: ELSIF p_gl_date_to IS NULL THEN
1683: l_gl_date_where :=' and ra.gl_date >= arp_recon_rep.get_gl_date_from() ' ;
1684: ELSE
1685: l_gl_date_where := ' and ra.gl_date between arp_recon_rep.get_gl_date_from() and arp_recon_rep.get_gl_date_to() ';
1686: END IF;
1687:
1688: IF p_gl_account_low IS NOT NULL AND p_gl_account_high IS NOT NULL THEN
1689: l_account_where := ' AND ' || AR_CALC_AGING.FLEX_SQL(

Line 1710: AND fcav.id_flex_num = arp_recon_rep.var_tname.g_chart_of_accounts_id

1706: FROM fnd_segment_attribute_values fcav,
1707: fnd_id_flex_segments fifs
1708: WHERE fcav.application_id = 101
1709: AND fcav.id_flex_code = 'GL#'
1710: AND fcav.id_flex_num = arp_recon_rep.var_tname.g_chart_of_accounts_id
1711: AND fcav.attribute_value = 'Y'
1712: AND fcav.segment_attribute_type = 'GL_ACCOUNT'
1713: AND fifs.application_id = fcav.application_id
1714: AND fifs.id_flex_code = fcav.id_flex_code

Line 1730: from '||arp_recon_rep.var_tname.l_ar_distributions_all||' ard1

1726: IF nvl(p_receivable_mode,'N') = 'Y' THEN
1727: l_source_type_where := ' and ((ard.source_type = ''REC'')
1728: OR (ps.class =''BR''
1729: and not exists (select line_id
1730: from '||arp_recon_rep.var_tname.l_ar_distributions_all||' ard1
1731: where ard1.source_id = ra.receivable_application_id
1732: and ard1.source_type = ''REC''
1733: and ard1.source_table =''RA''
1734: '|| l_ard1_org_where || ')

Line 1756: and lookup_code = arp_recon_rep.var_tname.g_posting_status;

1752: select meaning
1753: into l_status_meaning
1754: from ar_lookups
1755: where lookup_type = 'POSTED_STATUS'
1756: and lookup_code = arp_recon_rep.var_tname.g_posting_status;
1757:
1758: l_posting_status_where := 'and nvl(ra.gl_posted_date,TO_DATE(''01/01/0001'',''MM/DD/YYYY'')) =
1759: decode(arp_recon_rep.get_posting_status(),
1760: ''POSTED'',ra.gl_posted_date,

Line 1759: decode(arp_recon_rep.get_posting_status(),

1755: where lookup_type = 'POSTED_STATUS'
1756: and lookup_code = arp_recon_rep.var_tname.g_posting_status;
1757:
1758: l_posting_status_where := 'and nvl(ra.gl_posted_date,TO_DATE(''01/01/0001'',''MM/DD/YYYY'')) =
1759: decode(arp_recon_rep.get_posting_status(),
1760: ''POSTED'',ra.gl_posted_date,
1761: ''UNPOSTED'',TO_DATE(''01/01/0001'',''MM/DD/YYYY''),
1762: nvl(ra.gl_posted_date,TO_DATE(''01/01/0001'',''MM/DD/YYYY'')))';
1763: ELSE

Line 1787: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''ALL'',gc.code_combination_id) account,

1783: bs.name receipt_source,
1784: bat.name batch_name,
1785: l_cat.meaning category,
1786: ard.currency_code currency_code,
1787: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''ALL'',gc.code_combination_id) account,
1788: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_BALANCING'',gc.code_combination_id) company,
1789: ar_calc_aging.get_description(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_ACCOUNT'',gc.code_combination_id) account_desc
1790: from '||arp_recon_rep.var_tname.l_ar_cash_receipts_all||' cr,
1791: ar_receipt_methods arm,

Line 1788: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_BALANCING'',gc.code_combination_id) company,

1784: bat.name batch_name,
1785: l_cat.meaning category,
1786: ard.currency_code currency_code,
1787: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''ALL'',gc.code_combination_id) account,
1788: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_BALANCING'',gc.code_combination_id) company,
1789: ar_calc_aging.get_description(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_ACCOUNT'',gc.code_combination_id) account_desc
1790: from '||arp_recon_rep.var_tname.l_ar_cash_receipts_all||' cr,
1791: ar_receipt_methods arm,
1792: '||arp_recon_rep.var_tname.l_ar_cash_receipt_history_all||' crh,

Line 1789: ar_calc_aging.get_description(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_ACCOUNT'',gc.code_combination_id) account_desc

1785: l_cat.meaning category,
1786: ard.currency_code currency_code,
1787: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''ALL'',gc.code_combination_id) account,
1788: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_BALANCING'',gc.code_combination_id) company,
1789: ar_calc_aging.get_description(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_ACCOUNT'',gc.code_combination_id) account_desc
1790: from '||arp_recon_rep.var_tname.l_ar_cash_receipts_all||' cr,
1791: ar_receipt_methods arm,
1792: '||arp_recon_rep.var_tname.l_ar_cash_receipt_history_all||' crh,
1793: gl_code_combinations gc,

Line 1790: from '||arp_recon_rep.var_tname.l_ar_cash_receipts_all||' cr,

1786: ard.currency_code currency_code,
1787: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''ALL'',gc.code_combination_id) account,
1788: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_BALANCING'',gc.code_combination_id) company,
1789: ar_calc_aging.get_description(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_ACCOUNT'',gc.code_combination_id) account_desc
1790: from '||arp_recon_rep.var_tname.l_ar_cash_receipts_all||' cr,
1791: ar_receipt_methods arm,
1792: '||arp_recon_rep.var_tname.l_ar_cash_receipt_history_all||' crh,
1793: gl_code_combinations gc,
1794: hz_cust_accounts cust,

Line 1792: '||arp_recon_rep.var_tname.l_ar_cash_receipt_history_all||' crh,

1788: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_BALANCING'',gc.code_combination_id) company,
1789: ar_calc_aging.get_description(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_ACCOUNT'',gc.code_combination_id) account_desc
1790: from '||arp_recon_rep.var_tname.l_ar_cash_receipts_all||' cr,
1791: ar_receipt_methods arm,
1792: '||arp_recon_rep.var_tname.l_ar_cash_receipt_history_all||' crh,
1793: gl_code_combinations gc,
1794: hz_cust_accounts cust,
1795: hz_parties party,
1796: '||arp_recon_rep.var_tname.l_ar_batches_all||' bat,

Line 1796: '||arp_recon_rep.var_tname.l_ar_batches_all||' bat,

1792: '||arp_recon_rep.var_tname.l_ar_cash_receipt_history_all||' crh,
1793: gl_code_combinations gc,
1794: hz_cust_accounts cust,
1795: hz_parties party,
1796: '||arp_recon_rep.var_tname.l_ar_batches_all||' bat,
1797: ar_batch_sources_all bs,
1798: '||arp_recon_rep.var_tname.l_ar_receivable_apps_all||' ra,
1799: '||arp_recon_rep.var_tname.l_ar_payment_schedules_all||' ps,
1800: '||arp_recon_rep.var_tname.l_ar_distributions_all||' ard,

Line 1798: '||arp_recon_rep.var_tname.l_ar_receivable_apps_all||' ra,

1794: hz_cust_accounts cust,
1795: hz_parties party,
1796: '||arp_recon_rep.var_tname.l_ar_batches_all||' bat,
1797: ar_batch_sources_all bs,
1798: '||arp_recon_rep.var_tname.l_ar_receivable_apps_all||' ra,
1799: '||arp_recon_rep.var_tname.l_ar_payment_schedules_all||' ps,
1800: '||arp_recon_rep.var_tname.l_ar_distributions_all||' ard,
1801: ar_lookups l_cat
1802: where nvl(ra.confirmed_flag,''Y'') = ''Y''

Line 1799: '||arp_recon_rep.var_tname.l_ar_payment_schedules_all||' ps,

1795: hz_parties party,
1796: '||arp_recon_rep.var_tname.l_ar_batches_all||' bat,
1797: ar_batch_sources_all bs,
1798: '||arp_recon_rep.var_tname.l_ar_receivable_apps_all||' ra,
1799: '||arp_recon_rep.var_tname.l_ar_payment_schedules_all||' ps,
1800: '||arp_recon_rep.var_tname.l_ar_distributions_all||' ard,
1801: ar_lookups l_cat
1802: where nvl(ra.confirmed_flag,''Y'') = ''Y''
1803: and ra.status = ''APP''

Line 1800: '||arp_recon_rep.var_tname.l_ar_distributions_all||' ard,

1796: '||arp_recon_rep.var_tname.l_ar_batches_all||' bat,
1797: ar_batch_sources_all bs,
1798: '||arp_recon_rep.var_tname.l_ar_receivable_apps_all||' ra,
1799: '||arp_recon_rep.var_tname.l_ar_payment_schedules_all||' ps,
1800: '||arp_recon_rep.var_tname.l_ar_distributions_all||' ard,
1801: ar_lookups l_cat
1802: where nvl(ra.confirmed_flag,''Y'') = ''Y''
1803: and ra.status = ''APP''
1804: and cr.cash_receipt_id = ra.cash_receipt_id

Line 1814: and gc.chart_of_accounts_id = arp_recon_rep.get_chart_of_accounts_id()

1810: and ps.payment_schedule_id = ra.applied_payment_schedule_id
1811: and bat.batch_source_id = bs.batch_source_id(+)
1812: and bat.org_id = bs.org_id(+)
1813: and gc.code_combination_id = ard.code_combination_id
1814: and gc.chart_of_accounts_id = arp_recon_rep.get_chart_of_accounts_id()
1815: and ard.source_id = ra.receivable_application_id
1816: and ard.source_table = ''RA''
1817: and cr.pay_from_customer = cust.cust_account_id(+)
1818: and cust.party_id = party.party_id(+)

Line 2033: arp_recon_rep.var_tname.g_reporting_level := p_reporting_level;

2029:
2030: log('arcm_journal_load_xml (+)');
2031:
2032: /* Assign the input parameters to the global variables */
2033: arp_recon_rep.var_tname.g_reporting_level := p_reporting_level;
2034: arp_recon_rep.var_tname.g_reporting_entity_id := p_reporting_entity_id;
2035: /* bug 5654975 p_coa_id,p_sob_id is passed incorrectly when the user
2036: has access to multiple Ledgers */
2037: -- arp_recon_rep.var_tname.g_set_of_books_id := p_sob_id;

Line 2034: arp_recon_rep.var_tname.g_reporting_entity_id := p_reporting_entity_id;

2030: log('arcm_journal_load_xml (+)');
2031:
2032: /* Assign the input parameters to the global variables */
2033: arp_recon_rep.var_tname.g_reporting_level := p_reporting_level;
2034: arp_recon_rep.var_tname.g_reporting_entity_id := p_reporting_entity_id;
2035: /* bug 5654975 p_coa_id,p_sob_id is passed incorrectly when the user
2036: has access to multiple Ledgers */
2037: -- arp_recon_rep.var_tname.g_set_of_books_id := p_sob_id;
2038: -- arp_recon_rep.var_tname.g_chart_of_accounts_id := p_coa_id;

Line 2037: -- arp_recon_rep.var_tname.g_set_of_books_id := p_sob_id;

2033: arp_recon_rep.var_tname.g_reporting_level := p_reporting_level;
2034: arp_recon_rep.var_tname.g_reporting_entity_id := p_reporting_entity_id;
2035: /* bug 5654975 p_coa_id,p_sob_id is passed incorrectly when the user
2036: has access to multiple Ledgers */
2037: -- arp_recon_rep.var_tname.g_set_of_books_id := p_sob_id;
2038: -- arp_recon_rep.var_tname.g_chart_of_accounts_id := p_coa_id;
2039: arp_recon_rep.var_tname.g_gl_date_from := fnd_date.canonical_to_date(p_gl_date_from);
2040: arp_recon_rep.var_tname.g_gl_date_to := fnd_date.canonical_to_date(p_gl_date_to);
2041: arp_recon_rep.var_tname.g_posting_status := p_posting_status;

Line 2038: -- arp_recon_rep.var_tname.g_chart_of_accounts_id := p_coa_id;

2034: arp_recon_rep.var_tname.g_reporting_entity_id := p_reporting_entity_id;
2035: /* bug 5654975 p_coa_id,p_sob_id is passed incorrectly when the user
2036: has access to multiple Ledgers */
2037: -- arp_recon_rep.var_tname.g_set_of_books_id := p_sob_id;
2038: -- arp_recon_rep.var_tname.g_chart_of_accounts_id := p_coa_id;
2039: arp_recon_rep.var_tname.g_gl_date_from := fnd_date.canonical_to_date(p_gl_date_from);
2040: arp_recon_rep.var_tname.g_gl_date_to := fnd_date.canonical_to_date(p_gl_date_to);
2041: arp_recon_rep.var_tname.g_posting_status := p_posting_status;
2042:

Line 2039: arp_recon_rep.var_tname.g_gl_date_from := fnd_date.canonical_to_date(p_gl_date_from);

2035: /* bug 5654975 p_coa_id,p_sob_id is passed incorrectly when the user
2036: has access to multiple Ledgers */
2037: -- arp_recon_rep.var_tname.g_set_of_books_id := p_sob_id;
2038: -- arp_recon_rep.var_tname.g_chart_of_accounts_id := p_coa_id;
2039: arp_recon_rep.var_tname.g_gl_date_from := fnd_date.canonical_to_date(p_gl_date_from);
2040: arp_recon_rep.var_tname.g_gl_date_to := fnd_date.canonical_to_date(p_gl_date_to);
2041: arp_recon_rep.var_tname.g_posting_status := p_posting_status;
2042:
2043: /* Added Conditional Implication to address bug:5181586*/

Line 2040: arp_recon_rep.var_tname.g_gl_date_to := fnd_date.canonical_to_date(p_gl_date_to);

2036: has access to multiple Ledgers */
2037: -- arp_recon_rep.var_tname.g_set_of_books_id := p_sob_id;
2038: -- arp_recon_rep.var_tname.g_chart_of_accounts_id := p_coa_id;
2039: arp_recon_rep.var_tname.g_gl_date_from := fnd_date.canonical_to_date(p_gl_date_from);
2040: arp_recon_rep.var_tname.g_gl_date_to := fnd_date.canonical_to_date(p_gl_date_to);
2041: arp_recon_rep.var_tname.g_posting_status := p_posting_status;
2042:
2043: /* Added Conditional Implication to address bug:5181586*/
2044: /* Added set of books id and chart of accounts id for bug fix 565497*/

Line 2041: arp_recon_rep.var_tname.g_posting_status := p_posting_status;

2037: -- arp_recon_rep.var_tname.g_set_of_books_id := p_sob_id;
2038: -- arp_recon_rep.var_tname.g_chart_of_accounts_id := p_coa_id;
2039: arp_recon_rep.var_tname.g_gl_date_from := fnd_date.canonical_to_date(p_gl_date_from);
2040: arp_recon_rep.var_tname.g_gl_date_to := fnd_date.canonical_to_date(p_gl_date_to);
2041: arp_recon_rep.var_tname.g_posting_status := p_posting_status;
2042:
2043: /* Added Conditional Implication to address bug:5181586*/
2044: /* Added set of books id and chart of accounts id for bug fix 565497*/
2045: IF p_reporting_level = 1000 THEN

Line 2055: WHERE sob.set_of_books_id = arp_recon_rep.var_tname.g_reporting_entity_id;

2051: l_sob_id,
2052: l_functional_currency,
2053: l_coa_id
2054: FROM gl_sets_of_books sob
2055: WHERE sob.set_of_books_id = arp_recon_rep.var_tname.g_reporting_entity_id;
2056:
2057: ELSIF p_reporting_level = 3000 THEN
2058: SELECT sob.name sob_name,
2059: sob.set_of_books_id,

Line 2069: AND sysparam.org_id = arp_recon_rep.var_tname.g_reporting_entity_id;

2065: l_coa_id
2066: FROM gl_sets_of_books sob,
2067: ar_system_parameters_all sysparam
2068: WHERE sob.set_of_books_id = sysparam.set_of_books_id
2069: AND sysparam.org_id = arp_recon_rep.var_tname.g_reporting_entity_id;
2070:
2071: END IF;
2072: /* Changes for bug:5181586 ends*/
2073: arp_recon_rep.var_tname.g_set_of_books_id := l_sob_id;

Line 2073: arp_recon_rep.var_tname.g_set_of_books_id := l_sob_id;

2069: AND sysparam.org_id = arp_recon_rep.var_tname.g_reporting_entity_id;
2070:
2071: END IF;
2072: /* Changes for bug:5181586 ends*/
2073: arp_recon_rep.var_tname.g_set_of_books_id := l_sob_id;
2074: arp_recon_rep.var_tname.g_chart_of_accounts_id := l_coa_id;
2075:
2076:
2077: /* Initialize the reporting context */

Line 2074: arp_recon_rep.var_tname.g_chart_of_accounts_id := l_coa_id;

2070:
2071: END IF;
2072: /* Changes for bug:5181586 ends*/
2073: arp_recon_rep.var_tname.g_set_of_books_id := l_sob_id;
2074: arp_recon_rep.var_tname.g_chart_of_accounts_id := l_coa_id;
2075:
2076:
2077: /* Initialize the reporting context */
2078: init(p_sob_id);

Line 2093: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');

2089:
2090:
2091: /* Replace the bind variables with global functions */
2092: l_ra_org_where := replace(l_ra_org_where,
2093: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
2094: l_ard_org_where := replace(l_ard_org_where,
2095: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
2096: l_ps_org_where := replace(l_ps_org_where,
2097: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');

Line 2095: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');

2091: /* Replace the bind variables with global functions */
2092: l_ra_org_where := replace(l_ra_org_where,
2093: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
2094: l_ard_org_where := replace(l_ard_org_where,
2095: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
2096: l_ps_org_where := replace(l_ps_org_where,
2097: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
2098: l_ps1_org_where := replace(l_ps1_org_where,
2099: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');

Line 2097: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');

2093: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
2094: l_ard_org_where := replace(l_ard_org_where,
2095: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
2096: l_ps_org_where := replace(l_ps_org_where,
2097: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
2098: l_ps1_org_where := replace(l_ps1_org_where,
2099: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
2100: l_sysparam_org_where := replace(l_sysparam_org_where,
2101: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');

Line 2099: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');

2095: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
2096: l_ps_org_where := replace(l_ps_org_where,
2097: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
2098: l_ps1_org_where := replace(l_ps1_org_where,
2099: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
2100: l_sysparam_org_where := replace(l_sysparam_org_where,
2101: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
2102: l_reporting_entity_name := substrb(XLA_MO_REPORTING_API.get_reporting_entity_name,1,80);
2103: l_reporting_level_name := substrb(XLA_MO_REPORTING_API.get_reporting_level_name,1,30);

Line 2101: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');

2097: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
2098: l_ps1_org_where := replace(l_ps1_org_where,
2099: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
2100: l_sysparam_org_where := replace(l_sysparam_org_where,
2101: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
2102: l_reporting_entity_name := substrb(XLA_MO_REPORTING_API.get_reporting_entity_name,1,80);
2103: l_reporting_level_name := substrb(XLA_MO_REPORTING_API.get_reporting_level_name,1,30);
2104:
2105: /* Multi Org Uptake: Show appropriate message to the user depending upon the security profile */

Line 2118: arp_recon_rep.var_tname.g_gl_date_from,

2114:
2115: /* Bug fix 4942083*/
2116: IF arp_util.Open_Period_Exists(p_reporting_level,
2117: p_reporting_entity_id,
2118: arp_recon_rep.var_tname.g_gl_date_from,
2119: arp_recon_rep.var_tname.g_gl_date_to) THEN
2120: FND_MESSAGE.SET_NAME('AR','AR_REPORT_ACC_NOT_GEN');--Changed as per Bug 5578884 the parameter to AR from FND as the message is in AR product
2121: l_message_acct := FND_MESSAGE.Get;
2122: END IF;

Line 2119: arp_recon_rep.var_tname.g_gl_date_to) THEN

2115: /* Bug fix 4942083*/
2116: IF arp_util.Open_Period_Exists(p_reporting_level,
2117: p_reporting_entity_id,
2118: arp_recon_rep.var_tname.g_gl_date_from,
2119: arp_recon_rep.var_tname.g_gl_date_to) THEN
2120: FND_MESSAGE.SET_NAME('AR','AR_REPORT_ACC_NOT_GEN');--Changed as per Bug 5578884 the parameter to AR from FND as the message is in AR product
2121: l_message_acct := FND_MESSAGE.Get;
2122: END IF;
2123:

Line 2128: where hou.organization_id = arp_recon_rep.var_tname.g_reporting_entity_id;

2124: IF p_reporting_level = '3000' THEN
2125: select substrb(hou.name,1,60)
2126: into l_organization
2127: from hr_organization_units hou
2128: where hou.organization_id = arp_recon_rep.var_tname.g_reporting_entity_id;
2129: ELSE
2130: select meaning
2131: into l_organization
2132: from ar_lookups

Line 2177: l_gl_date_where :=' and ra.gl_date <= arp_recon_rep.get_gl_date_to()';

2173:
2174: IF p_gl_date_from IS NULL and p_gl_date_to IS NULL THEN
2175: l_gl_date_where := NULL;
2176: ELSIF p_gl_date_from IS NULL THEN
2177: l_gl_date_where :=' and ra.gl_date <= arp_recon_rep.get_gl_date_to()';
2178: ELSIF p_gl_date_to IS NULL THEN
2179: l_gl_date_where :=' and ra.gl_date >= arp_recon_rep.get_gl_date_from() ' ;
2180: ELSE
2181: l_gl_date_where := ' and ra.gl_date between arp_recon_rep.get_gl_date_from() and arp_recon_rep.get_gl_date_to() ';

Line 2179: l_gl_date_where :=' and ra.gl_date >= arp_recon_rep.get_gl_date_from() ' ;

2175: l_gl_date_where := NULL;
2176: ELSIF p_gl_date_from IS NULL THEN
2177: l_gl_date_where :=' and ra.gl_date <= arp_recon_rep.get_gl_date_to()';
2178: ELSIF p_gl_date_to IS NULL THEN
2179: l_gl_date_where :=' and ra.gl_date >= arp_recon_rep.get_gl_date_from() ' ;
2180: ELSE
2181: l_gl_date_where := ' and ra.gl_date between arp_recon_rep.get_gl_date_from() and arp_recon_rep.get_gl_date_to() ';
2182: END IF;
2183:

Line 2181: l_gl_date_where := ' and ra.gl_date between arp_recon_rep.get_gl_date_from() and arp_recon_rep.get_gl_date_to() ';

2177: l_gl_date_where :=' and ra.gl_date <= arp_recon_rep.get_gl_date_to()';
2178: ELSIF p_gl_date_to IS NULL THEN
2179: l_gl_date_where :=' and ra.gl_date >= arp_recon_rep.get_gl_date_from() ' ;
2180: ELSE
2181: l_gl_date_where := ' and ra.gl_date between arp_recon_rep.get_gl_date_from() and arp_recon_rep.get_gl_date_to() ';
2182: END IF;
2183:
2184: IF p_gl_account_low IS NOT NULL AND p_gl_account_high IS NOT NULL THEN
2185: l_account_where := ' AND ' || AR_CALC_AGING.FLEX_SQL(

Line 2206: AND fcav.id_flex_num = arp_recon_rep.var_tname.g_chart_of_accounts_id

2202: FROM fnd_segment_attribute_values fcav,
2203: fnd_id_flex_segments fifs
2204: WHERE fcav.application_id = 101
2205: AND fcav.id_flex_code = 'GL#'
2206: AND fcav.id_flex_num = arp_recon_rep.var_tname.g_chart_of_accounts_id
2207: AND fcav.attribute_value = 'Y'
2208: AND fcav.segment_attribute_type = 'GL_ACCOUNT'
2209: AND fifs.application_id = fcav.application_id
2210: AND fifs.id_flex_code = fcav.id_flex_code

Line 2242: and lookup_code = arp_recon_rep.var_tname.g_posting_status;

2238: select meaning
2239: into l_status_meaning
2240: from ar_lookups
2241: where lookup_type = 'POSTED_STATUS'
2242: and lookup_code = arp_recon_rep.var_tname.g_posting_status;
2243:
2244: l_posting_status_where := 'and nvl(ra.gl_posted_date,TO_DATE(''01/01/0001'',''MM/DD/YYYY'')) =
2245: decode(arp_recon_rep.get_posting_status(),
2246: ''POSTED'',ra.gl_posted_date,

Line 2245: decode(arp_recon_rep.get_posting_status(),

2241: where lookup_type = 'POSTED_STATUS'
2242: and lookup_code = arp_recon_rep.var_tname.g_posting_status;
2243:
2244: l_posting_status_where := 'and nvl(ra.gl_posted_date,TO_DATE(''01/01/0001'',''MM/DD/YYYY'')) =
2245: decode(arp_recon_rep.get_posting_status(),
2246: ''POSTED'',ra.gl_posted_date,
2247: ''UNPOSTED'',TO_DATE(''01/01/0001'',''MM/DD/YYYY''),
2248: nvl(ra.gl_posted_date,TO_DATE(''01/01/0001'',''MM/DD/YYYY'')))';
2249: ELSE

Line 2275: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''ALL'',gc.code_combination_id) account,

2271: to_char(ps1.exchange_date,''YYYY-MM-DD'') trx_exchange_date,
2272: ps.exchange_rate cm_exchange_rate,
2273: ps1.exchange_rate trx_exchange_rate,
2274: l_cat.meaning category,
2275: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''ALL'',gc.code_combination_id) account,
2276: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_BALANCING'',gc.code_combination_id) company,
2277: ar_calc_aging.get_description(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_ACCOUNT'',gc.code_combination_id) account_desc
2278: from '||arp_recon_rep.var_tname.l_ar_receivable_apps_all||' ra ,
2279: '||arp_recon_rep.var_tname.l_ar_distributions_all||' ard ,

Line 2276: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_BALANCING'',gc.code_combination_id) company,

2272: ps.exchange_rate cm_exchange_rate,
2273: ps1.exchange_rate trx_exchange_rate,
2274: l_cat.meaning category,
2275: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''ALL'',gc.code_combination_id) account,
2276: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_BALANCING'',gc.code_combination_id) company,
2277: ar_calc_aging.get_description(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_ACCOUNT'',gc.code_combination_id) account_desc
2278: from '||arp_recon_rep.var_tname.l_ar_receivable_apps_all||' ra ,
2279: '||arp_recon_rep.var_tname.l_ar_distributions_all||' ard ,
2280: '||arp_recon_rep.var_tname.l_ar_payment_schedules_all||' ps ,

Line 2277: ar_calc_aging.get_description(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_ACCOUNT'',gc.code_combination_id) account_desc

2273: ps1.exchange_rate trx_exchange_rate,
2274: l_cat.meaning category,
2275: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''ALL'',gc.code_combination_id) account,
2276: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_BALANCING'',gc.code_combination_id) company,
2277: ar_calc_aging.get_description(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_ACCOUNT'',gc.code_combination_id) account_desc
2278: from '||arp_recon_rep.var_tname.l_ar_receivable_apps_all||' ra ,
2279: '||arp_recon_rep.var_tname.l_ar_distributions_all||' ard ,
2280: '||arp_recon_rep.var_tname.l_ar_payment_schedules_all||' ps ,
2281: '||arp_recon_rep.var_tname.l_ar_payment_schedules_all||' ps1 ,

Line 2278: from '||arp_recon_rep.var_tname.l_ar_receivable_apps_all||' ra ,

2274: l_cat.meaning category,
2275: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''ALL'',gc.code_combination_id) account,
2276: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_BALANCING'',gc.code_combination_id) company,
2277: ar_calc_aging.get_description(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_ACCOUNT'',gc.code_combination_id) account_desc
2278: from '||arp_recon_rep.var_tname.l_ar_receivable_apps_all||' ra ,
2279: '||arp_recon_rep.var_tname.l_ar_distributions_all||' ard ,
2280: '||arp_recon_rep.var_tname.l_ar_payment_schedules_all||' ps ,
2281: '||arp_recon_rep.var_tname.l_ar_payment_schedules_all||' ps1 ,
2282: gl_code_combinations gc,

Line 2279: '||arp_recon_rep.var_tname.l_ar_distributions_all||' ard ,

2275: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''ALL'',gc.code_combination_id) account,
2276: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_BALANCING'',gc.code_combination_id) company,
2277: ar_calc_aging.get_description(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_ACCOUNT'',gc.code_combination_id) account_desc
2278: from '||arp_recon_rep.var_tname.l_ar_receivable_apps_all||' ra ,
2279: '||arp_recon_rep.var_tname.l_ar_distributions_all||' ard ,
2280: '||arp_recon_rep.var_tname.l_ar_payment_schedules_all||' ps ,
2281: '||arp_recon_rep.var_tname.l_ar_payment_schedules_all||' ps1 ,
2282: gl_code_combinations gc,
2283: hz_cust_accounts cust,

Line 2280: '||arp_recon_rep.var_tname.l_ar_payment_schedules_all||' ps ,

2276: ar_calc_aging.get_value(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_BALANCING'',gc.code_combination_id) company,
2277: ar_calc_aging.get_description(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_ACCOUNT'',gc.code_combination_id) account_desc
2278: from '||arp_recon_rep.var_tname.l_ar_receivable_apps_all||' ra ,
2279: '||arp_recon_rep.var_tname.l_ar_distributions_all||' ard ,
2280: '||arp_recon_rep.var_tname.l_ar_payment_schedules_all||' ps ,
2281: '||arp_recon_rep.var_tname.l_ar_payment_schedules_all||' ps1 ,
2282: gl_code_combinations gc,
2283: hz_cust_accounts cust,
2284: hz_parties party,

Line 2281: '||arp_recon_rep.var_tname.l_ar_payment_schedules_all||' ps1 ,

2277: ar_calc_aging.get_description(101,''GL#'',arp_recon_rep.get_chart_of_accounts_id(),''GL_ACCOUNT'',gc.code_combination_id) account_desc
2278: from '||arp_recon_rep.var_tname.l_ar_receivable_apps_all||' ra ,
2279: '||arp_recon_rep.var_tname.l_ar_distributions_all||' ard ,
2280: '||arp_recon_rep.var_tname.l_ar_payment_schedules_all||' ps ,
2281: '||arp_recon_rep.var_tname.l_ar_payment_schedules_all||' ps1 ,
2282: gl_code_combinations gc,
2283: hz_cust_accounts cust,
2284: hz_parties party,
2285: ar_lookups l_cat

Line 2296: and gc.chart_of_accounts_id = arp_recon_rep.get_chart_of_accounts_id()

2292: and ra.applied_payment_schedule_id = ps1.payment_schedule_id
2293: and cust.cust_account_id = ps.customer_id
2294: and cust.party_id = party.party_id
2295: and gc.code_combination_id = ard.code_combination_id
2296: and gc.chart_of_accounts_id = arp_recon_rep.get_chart_of_accounts_id()
2297: and l_cat.lookup_type = ''ARRGTA_FUNCTION_MAPPING''
2298: and l_cat.lookup_code = (''CMAPP_''||ard.source_type)
2299: '||l_ard_org_where||'
2300: '||l_ra_org_where||'

Line 2503: arp_recon_rep.var_tname.g_reporting_level := 1000;

2499: /* Assign the input parameters to the global variables */
2500: /* AR to GL Reconciliation Report can be run only for the Set of Books
2501: So hard coding the reporting_level and context */
2502:
2503: arp_recon_rep.var_tname.g_reporting_level := 1000;
2504: arp_recon_rep.var_tname.g_reporting_entity_id := p_reporting_entity_id;
2505: arp_recon_rep.var_tname.g_set_of_books_id := p_reporting_entity_id;
2506: arp_recon_rep.var_tname.g_chart_of_accounts_id := p_coa_id;
2507: arp_recon_rep.var_tname.g_period_name := p_period_name;

Line 2504: arp_recon_rep.var_tname.g_reporting_entity_id := p_reporting_entity_id;

2500: /* AR to GL Reconciliation Report can be run only for the Set of Books
2501: So hard coding the reporting_level and context */
2502:
2503: arp_recon_rep.var_tname.g_reporting_level := 1000;
2504: arp_recon_rep.var_tname.g_reporting_entity_id := p_reporting_entity_id;
2505: arp_recon_rep.var_tname.g_set_of_books_id := p_reporting_entity_id;
2506: arp_recon_rep.var_tname.g_chart_of_accounts_id := p_coa_id;
2507: arp_recon_rep.var_tname.g_period_name := p_period_name;
2508: arp_recon_rep.var_tname.g_out_of_balance_only := p_out_of_balance_only;

Line 2505: arp_recon_rep.var_tname.g_set_of_books_id := p_reporting_entity_id;

2501: So hard coding the reporting_level and context */
2502:
2503: arp_recon_rep.var_tname.g_reporting_level := 1000;
2504: arp_recon_rep.var_tname.g_reporting_entity_id := p_reporting_entity_id;
2505: arp_recon_rep.var_tname.g_set_of_books_id := p_reporting_entity_id;
2506: arp_recon_rep.var_tname.g_chart_of_accounts_id := p_coa_id;
2507: arp_recon_rep.var_tname.g_period_name := p_period_name;
2508: arp_recon_rep.var_tname.g_out_of_balance_only := p_out_of_balance_only;
2509:

Line 2506: arp_recon_rep.var_tname.g_chart_of_accounts_id := p_coa_id;

2502:
2503: arp_recon_rep.var_tname.g_reporting_level := 1000;
2504: arp_recon_rep.var_tname.g_reporting_entity_id := p_reporting_entity_id;
2505: arp_recon_rep.var_tname.g_set_of_books_id := p_reporting_entity_id;
2506: arp_recon_rep.var_tname.g_chart_of_accounts_id := p_coa_id;
2507: arp_recon_rep.var_tname.g_period_name := p_period_name;
2508: arp_recon_rep.var_tname.g_out_of_balance_only := p_out_of_balance_only;
2509:
2510: /* Initialize the reporting context */

Line 2507: arp_recon_rep.var_tname.g_period_name := p_period_name;

2503: arp_recon_rep.var_tname.g_reporting_level := 1000;
2504: arp_recon_rep.var_tname.g_reporting_entity_id := p_reporting_entity_id;
2505: arp_recon_rep.var_tname.g_set_of_books_id := p_reporting_entity_id;
2506: arp_recon_rep.var_tname.g_chart_of_accounts_id := p_coa_id;
2507: arp_recon_rep.var_tname.g_period_name := p_period_name;
2508: arp_recon_rep.var_tname.g_out_of_balance_only := p_out_of_balance_only;
2509:
2510: /* Initialize the reporting context */
2511: init(p_sob_id);

Line 2508: arp_recon_rep.var_tname.g_out_of_balance_only := p_out_of_balance_only;

2504: arp_recon_rep.var_tname.g_reporting_entity_id := p_reporting_entity_id;
2505: arp_recon_rep.var_tname.g_set_of_books_id := p_reporting_entity_id;
2506: arp_recon_rep.var_tname.g_chart_of_accounts_id := p_coa_id;
2507: arp_recon_rep.var_tname.g_period_name := p_period_name;
2508: arp_recon_rep.var_tname.g_out_of_balance_only := p_out_of_balance_only;
2509:
2510: /* Initialize the reporting context */
2511: init(p_sob_id);
2512:

Line 2529: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');

2525: l_ath_org_where := XLA_MO_REPORTING_API.Get_Predicate('ath',NULL);
2526:
2527: /* Replace the bind variables with global functions */
2528: l_ra_org_where := replace(l_ra_org_where,
2529: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
2530: l_adj_org_where := replace(l_adj_org_where,
2531: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
2532: l_ard_org_where := replace(l_ard_org_where,
2533: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');

Line 2531: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');

2527: /* Replace the bind variables with global functions */
2528: l_ra_org_where := replace(l_ra_org_where,
2529: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
2530: l_adj_org_where := replace(l_adj_org_where,
2531: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
2532: l_ard_org_where := replace(l_ard_org_where,
2533: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
2534: l_gl_dist_org_where := replace(l_gl_dist_org_where,
2535: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');

Line 2533: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');

2529: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
2530: l_adj_org_where := replace(l_adj_org_where,
2531: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
2532: l_ard_org_where := replace(l_ard_org_where,
2533: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
2534: l_gl_dist_org_where := replace(l_gl_dist_org_where,
2535: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
2536: l_sysparam_org_where := replace(l_sysparam_org_where,
2537: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');

Line 2535: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');

2531: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
2532: l_ard_org_where := replace(l_ard_org_where,
2533: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
2534: l_gl_dist_org_where := replace(l_gl_dist_org_where,
2535: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
2536: l_sysparam_org_where := replace(l_sysparam_org_where,
2537: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
2538: l_mcd_org_where := replace(l_mcd_org_where,
2539: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');

Line 2537: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');

2533: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
2534: l_gl_dist_org_where := replace(l_gl_dist_org_where,
2535: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
2536: l_sysparam_org_where := replace(l_sysparam_org_where,
2537: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
2538: l_mcd_org_where := replace(l_mcd_org_where,
2539: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
2540: l_crh_org_where := replace(l_crh_org_where,
2541: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');

Line 2539: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');

2535: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
2536: l_sysparam_org_where := replace(l_sysparam_org_where,
2537: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
2538: l_mcd_org_where := replace(l_mcd_org_where,
2539: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
2540: l_crh_org_where := replace(l_crh_org_where,
2541: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
2542: /* Bug fix 6432847 */
2543: l_cr_org_where := replace(l_cr_org_where,

Line 2541: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');

2537: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
2538: l_mcd_org_where := replace(l_mcd_org_where,
2539: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
2540: l_crh_org_where := replace(l_crh_org_where,
2541: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
2542: /* Bug fix 6432847 */
2543: l_cr_org_where := replace(l_cr_org_where,
2544: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
2545: l_ath_org_where := replace(l_ath_org_where,

Line 2544: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');

2540: l_crh_org_where := replace(l_crh_org_where,
2541: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
2542: /* Bug fix 6432847 */
2543: l_cr_org_where := replace(l_cr_org_where,
2544: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
2545: l_ath_org_where := replace(l_ath_org_where,
2546: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
2547:
2548: l_reporting_entity_name := substrb(XLA_MO_REPORTING_API.get_reporting_entity_name,1,80);

Line 2546: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');

2542: /* Bug fix 6432847 */
2543: l_cr_org_where := replace(l_cr_org_where,
2544: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
2545: l_ath_org_where := replace(l_ath_org_where,
2546: ':p_reporting_entity_id','arp_recon_rep.get_reporting_entity_id()');
2547:
2548: l_reporting_entity_name := substrb(XLA_MO_REPORTING_API.get_reporting_entity_name,1,80);
2549: l_reporting_level_name := substrb(XLA_MO_REPORTING_API.get_reporting_level_name,1,30);
2550:

Line 2616: AND fcav.id_flex_num = arp_recon_rep.var_tname.g_chart_of_accounts_id

2612: FROM fnd_segment_attribute_values fcav,
2613: fnd_id_flex_segments fifs
2614: WHERE fcav.application_id = 101
2615: AND fcav.id_flex_code = 'GL#'
2616: AND fcav.id_flex_num = arp_recon_rep.var_tname.g_chart_of_accounts_id
2617: AND fcav.attribute_value = 'Y'
2618: AND fcav.segment_attribute_type = 'GL_ACCOUNT'
2619: AND fifs.application_id = fcav.application_id
2620: AND fifs.id_flex_code = fcav.id_flex_code

Line 2639: WHERE sob.set_of_books_id = arp_recon_rep.var_tname.g_reporting_entity_id;

2635: sob.currency_code functional_currency
2636: INTO l_sob_name,
2637: l_functional_currency
2638: FROM gl_sets_of_books sob
2639: WHERE sob.set_of_books_id = arp_recon_rep.var_tname.g_reporting_entity_id;
2640:
2641: ELSIF p_reporting_level = 3000 THEN
2642: SELECT sob.name sob_name,
2643: sob.currency_code functional_currency

Line 2649: AND sysparam.org_id = arp_recon_rep.var_tname.g_reporting_entity_id;

2645: l_functional_currency
2646: FROM gl_sets_of_books sob,
2647: ar_system_parameters_all sysparam
2648: WHERE sob.set_of_books_id = sysparam.set_of_books_id
2649: AND sysparam.org_id = arp_recon_rep.var_tname.g_reporting_entity_id;
2650:
2651: END IF;
2652: /* Changes for bug:5181586 ends*/
2653:

Line 2654: arp_recon_rep.var_tname.g_functional_currency := l_functional_currency;

2650:
2651: END IF;
2652: /* Changes for bug:5181586 ends*/
2653:
2654: arp_recon_rep.var_tname.g_functional_currency := l_functional_currency;
2655:
2656: /* Get the format mask for the function currency */
2657: select fnd_currency.get_format_mask(l_functional_currency,40)
2658: into l_format

Line 2666: AND b.set_of_books_id = arp_recon_rep.var_tname.g_set_of_books_id

2662: INTO l_gl_date_from , l_gl_date_to
2663: FROM gl_periods p, gl_sets_of_books b
2664: WHERE p.period_set_name = b.period_set_name
2665: AND p.period_type = b.accounted_period_type
2666: AND b.set_of_books_id = arp_recon_rep.var_tname.g_set_of_books_id
2667: AND p.period_name = arp_recon_rep.var_tname.g_period_name;
2668: arp_recon_rep.var_tname.g_gl_date_from := l_gl_date_from;
2669: arp_recon_rep.var_tname.g_gl_date_to := l_gl_date_to;
2670:

Line 2667: AND p.period_name = arp_recon_rep.var_tname.g_period_name;

2663: FROM gl_periods p, gl_sets_of_books b
2664: WHERE p.period_set_name = b.period_set_name
2665: AND p.period_type = b.accounted_period_type
2666: AND b.set_of_books_id = arp_recon_rep.var_tname.g_set_of_books_id
2667: AND p.period_name = arp_recon_rep.var_tname.g_period_name;
2668: arp_recon_rep.var_tname.g_gl_date_from := l_gl_date_from;
2669: arp_recon_rep.var_tname.g_gl_date_to := l_gl_date_to;
2670:
2671: /* Bug fix 4942083*/

Line 2668: arp_recon_rep.var_tname.g_gl_date_from := l_gl_date_from;

2664: WHERE p.period_set_name = b.period_set_name
2665: AND p.period_type = b.accounted_period_type
2666: AND b.set_of_books_id = arp_recon_rep.var_tname.g_set_of_books_id
2667: AND p.period_name = arp_recon_rep.var_tname.g_period_name;
2668: arp_recon_rep.var_tname.g_gl_date_from := l_gl_date_from;
2669: arp_recon_rep.var_tname.g_gl_date_to := l_gl_date_to;
2670:
2671: /* Bug fix 4942083*/
2672: IF arp_util.Open_Period_Exists(p_reporting_level,

Line 2669: arp_recon_rep.var_tname.g_gl_date_to := l_gl_date_to;

2665: AND p.period_type = b.accounted_period_type
2666: AND b.set_of_books_id = arp_recon_rep.var_tname.g_set_of_books_id
2667: AND p.period_name = arp_recon_rep.var_tname.g_period_name;
2668: arp_recon_rep.var_tname.g_gl_date_from := l_gl_date_from;
2669: arp_recon_rep.var_tname.g_gl_date_to := l_gl_date_to;
2670:
2671: /* Bug fix 4942083*/
2672: IF arp_util.Open_Period_Exists(p_reporting_level,
2673: p_reporting_entity_id,

Line 2674: arp_recon_rep.var_tname.g_gl_date_from,

2670:
2671: /* Bug fix 4942083*/
2672: IF arp_util.Open_Period_Exists(p_reporting_level,
2673: p_reporting_entity_id,
2674: arp_recon_rep.var_tname.g_gl_date_from,
2675: arp_recon_rep.var_tname.g_gl_date_to) THEN
2676: FND_MESSAGE.SET_NAME('AR','AR_REPORT_ACC_NOT_GEN');--Changed as per Bug 5578884 the parameter to AR from FND as the message is in AR product
2677: l_message_acct := FND_MESSAGE.Get;
2678: END IF;

Line 2675: arp_recon_rep.var_tname.g_gl_date_to) THEN

2671: /* Bug fix 4942083*/
2672: IF arp_util.Open_Period_Exists(p_reporting_level,
2673: p_reporting_entity_id,
2674: arp_recon_rep.var_tname.g_gl_date_from,
2675: arp_recon_rep.var_tname.g_gl_date_to) THEN
2676: FND_MESSAGE.SET_NAME('AR','AR_REPORT_ACC_NOT_GEN');--Changed as per Bug 5578884 the parameter to AR from FND as the message is in AR product
2677: l_message_acct := FND_MESSAGE.Get;
2678: END IF;
2679:

Line 2721: from '||arp_recon_rep.var_tname.l_ra_cust_trx_gl_dist_all||' gl_dist

2717: ''UNBILL'',decode(sign(acctd_amount), -1, 0,acctd_amount),0) acctd_amount_cr,
2718: gl_dist.code_combination_id code_combination_id,
2719: gl_dist.ae_header_id ae_header_id,
2720: gl_dist.ae_line_num ae_line_num
2721: from '||arp_recon_rep.var_tname.l_ra_cust_trx_gl_dist_all||' gl_dist
2722: where gl_dist.gl_date between :gl_date_from and :gl_date_to
2723: /* Bug fix 6631925 */
2724: and gl_dist.account_set_flag = ''N''
2725: and gl_dist.posting_control_id <> -3

Line 2733: from '||arp_recon_rep.var_tname.l_ar_distributions_all||' ard,

2729: ard.acctd_amount_cr acctd_amount_cr ,
2730: ard.code_combination_id code_combination_id,
2731: ard.ae_header_id ae_header_id,
2732: ard.ae_line_num ae_line_num
2733: from '||arp_recon_rep.var_tname.l_ar_distributions_all||' ard,
2734: '||arp_recon_rep.var_tname.l_ar_cash_receipt_history_all||' crh,
2735: '||arp_recon_rep.var_tname.l_ar_cash_receipts_all||' cr /* Bug fix 6432847 */
2736: where crh.gl_date between :gl_date_from and :gl_date_to
2737: and crh.posting_control_id <> -3

Line 2734: '||arp_recon_rep.var_tname.l_ar_cash_receipt_history_all||' crh,

2730: ard.code_combination_id code_combination_id,
2731: ard.ae_header_id ae_header_id,
2732: ard.ae_line_num ae_line_num
2733: from '||arp_recon_rep.var_tname.l_ar_distributions_all||' ard,
2734: '||arp_recon_rep.var_tname.l_ar_cash_receipt_history_all||' crh,
2735: '||arp_recon_rep.var_tname.l_ar_cash_receipts_all||' cr /* Bug fix 6432847 */
2736: where crh.gl_date between :gl_date_from and :gl_date_to
2737: and crh.posting_control_id <> -3
2738: and crh.cash_receipt_history_id = ard.source_id

Line 2735: '||arp_recon_rep.var_tname.l_ar_cash_receipts_all||' cr /* Bug fix 6432847 */

2731: ard.ae_header_id ae_header_id,
2732: ard.ae_line_num ae_line_num
2733: from '||arp_recon_rep.var_tname.l_ar_distributions_all||' ard,
2734: '||arp_recon_rep.var_tname.l_ar_cash_receipt_history_all||' crh,
2735: '||arp_recon_rep.var_tname.l_ar_cash_receipts_all||' cr /* Bug fix 6432847 */
2736: where crh.gl_date between :gl_date_from and :gl_date_to
2737: and crh.posting_control_id <> -3
2738: and crh.cash_receipt_history_id = ard.source_id
2739: /* Bug 6432847 : select receipts that are not reversed */

Line 2753: from '||arp_recon_rep.var_tname.l_ar_distributions_all||' ard,

2749: ard.acctd_amount_cr acctd_amount_cr ,
2750: ard.code_combination_id code_combination_id,
2751: ard.ae_header_id ae_header_id,
2752: ard.ae_line_num ae_line_num
2753: from '||arp_recon_rep.var_tname.l_ar_distributions_all||' ard,
2754: '||arp_recon_rep.var_tname.l_ar_cash_receipt_history_all||' crh,
2755: '||arp_recon_rep.var_tname.l_ar_cash_receipts_all||' cr
2756: where cr.reversal_date IS NOT NULL
2757: and crh.cash_receipt_id = cr.cash_receipt_id

Line 2754: '||arp_recon_rep.var_tname.l_ar_cash_receipt_history_all||' crh,

2750: ard.code_combination_id code_combination_id,
2751: ard.ae_header_id ae_header_id,
2752: ard.ae_line_num ae_line_num
2753: from '||arp_recon_rep.var_tname.l_ar_distributions_all||' ard,
2754: '||arp_recon_rep.var_tname.l_ar_cash_receipt_history_all||' crh,
2755: '||arp_recon_rep.var_tname.l_ar_cash_receipts_all||' cr
2756: where cr.reversal_date IS NOT NULL
2757: and crh.cash_receipt_id = cr.cash_receipt_id
2758: and crh.posting_control_id <> -3

Line 2755: '||arp_recon_rep.var_tname.l_ar_cash_receipts_all||' cr

2751: ard.ae_header_id ae_header_id,
2752: ard.ae_line_num ae_line_num
2753: from '||arp_recon_rep.var_tname.l_ar_distributions_all||' ard,
2754: '||arp_recon_rep.var_tname.l_ar_cash_receipt_history_all||' crh,
2755: '||arp_recon_rep.var_tname.l_ar_cash_receipts_all||' cr
2756: where cr.reversal_date IS NOT NULL
2757: and crh.cash_receipt_id = cr.cash_receipt_id
2758: and crh.posting_control_id <> -3
2759: and crh.cash_receipt_history_id = ard.source_id

Line 2773: from '||arp_recon_rep.var_tname.l_ar_distributions_all||' ard,

2769: ard.acctd_amount_cr acctd_amount_cr ,
2770: ard.code_combination_id code_combination_id,
2771: ard.ae_header_id ae_header_id,
2772: ard.ae_line_num ae_line_num
2773: from '||arp_recon_rep.var_tname.l_ar_distributions_all||' ard,
2774: '||arp_recon_rep.var_tname.l_ar_receivable_apps_all||' ra,
2775: '||arp_recon_rep.var_tname.l_ar_cash_receipts_all||' cr /* Bug fix 6432847 */
2776: where ra.gl_date between :gl_date_from and :gl_date_to
2777: and cr.cash_receipt_id = ra.cash_receipt_id

Line 2774: '||arp_recon_rep.var_tname.l_ar_receivable_apps_all||' ra,

2770: ard.code_combination_id code_combination_id,
2771: ard.ae_header_id ae_header_id,
2772: ard.ae_line_num ae_line_num
2773: from '||arp_recon_rep.var_tname.l_ar_distributions_all||' ard,
2774: '||arp_recon_rep.var_tname.l_ar_receivable_apps_all||' ra,
2775: '||arp_recon_rep.var_tname.l_ar_cash_receipts_all||' cr /* Bug fix 6432847 */
2776: where ra.gl_date between :gl_date_from and :gl_date_to
2777: and cr.cash_receipt_id = ra.cash_receipt_id
2778: and cr.reversal_date IS NULL

Line 2775: '||arp_recon_rep.var_tname.l_ar_cash_receipts_all||' cr /* Bug fix 6432847 */

2771: ard.ae_header_id ae_header_id,
2772: ard.ae_line_num ae_line_num
2773: from '||arp_recon_rep.var_tname.l_ar_distributions_all||' ard,
2774: '||arp_recon_rep.var_tname.l_ar_receivable_apps_all||' ra,
2775: '||arp_recon_rep.var_tname.l_ar_cash_receipts_all||' cr /* Bug fix 6432847 */
2776: where ra.gl_date between :gl_date_from and :gl_date_to
2777: and cr.cash_receipt_id = ra.cash_receipt_id
2778: and cr.reversal_date IS NULL
2779: and ra.posting_control_id <> -3

Line 2794: from '||arp_recon_rep.var_tname.l_ar_distributions_all||' ard,

2790: ard.acctd_amount_cr acctd_amount_cr ,
2791: ard.code_combination_id code_combination_id,
2792: ard.ae_header_id ae_header_id,
2793: ard.ae_line_num ae_line_num
2794: from '||arp_recon_rep.var_tname.l_ar_distributions_all||' ard,
2795: '||arp_recon_rep.var_tname.l_ar_receivable_apps_all||' ra,
2796: '||arp_recon_rep.var_tname.l_ar_cash_receipts_all||' cr /* Bug fix 6432847 */
2797: where ard.gl_date between :gl_date_from and :gl_date_to
2798: and cr.reversal_date IS NOT NULL

Line 2795: '||arp_recon_rep.var_tname.l_ar_receivable_apps_all||' ra,

2791: ard.code_combination_id code_combination_id,
2792: ard.ae_header_id ae_header_id,
2793: ard.ae_line_num ae_line_num
2794: from '||arp_recon_rep.var_tname.l_ar_distributions_all||' ard,
2795: '||arp_recon_rep.var_tname.l_ar_receivable_apps_all||' ra,
2796: '||arp_recon_rep.var_tname.l_ar_cash_receipts_all||' cr /* Bug fix 6432847 */
2797: where ard.gl_date between :gl_date_from and :gl_date_to
2798: and cr.reversal_date IS NOT NULL
2799: and ra.cash_receipt_id = cr.cash_receipt_id

Line 2796: '||arp_recon_rep.var_tname.l_ar_cash_receipts_all||' cr /* Bug fix 6432847 */

2792: ard.ae_header_id ae_header_id,
2793: ard.ae_line_num ae_line_num
2794: from '||arp_recon_rep.var_tname.l_ar_distributions_all||' ard,
2795: '||arp_recon_rep.var_tname.l_ar_receivable_apps_all||' ra,
2796: '||arp_recon_rep.var_tname.l_ar_cash_receipts_all||' cr /* Bug fix 6432847 */
2797: where ard.gl_date between :gl_date_from and :gl_date_to
2798: and cr.reversal_date IS NOT NULL
2799: and ra.cash_receipt_id = cr.cash_receipt_id
2800: and ra.posting_control_id <> -3

Line 2814: from '||arp_recon_rep.var_tname.l_ar_distributions_all||' ard,

2810: ard.acctd_amount_cr acctd_amount_cr ,
2811: ard.code_combination_id code_combination_id,
2812: ard.ae_header_id ae_header_id,
2813: ard.ae_line_num ae_line_num
2814: from '||arp_recon_rep.var_tname.l_ar_distributions_all||' ard,
2815: '||arp_recon_rep.var_tname.l_ar_receivable_apps_all||' ra
2816: where ard.gl_date between :gl_date_from and :gl_date_to
2817: and ra.posting_control_id <> -3
2818: and ra.receivable_application_id = ard.source_id

Line 2815: '||arp_recon_rep.var_tname.l_ar_receivable_apps_all||' ra

2811: ard.code_combination_id code_combination_id,
2812: ard.ae_header_id ae_header_id,
2813: ard.ae_line_num ae_line_num
2814: from '||arp_recon_rep.var_tname.l_ar_distributions_all||' ard,
2815: '||arp_recon_rep.var_tname.l_ar_receivable_apps_all||' ra
2816: where ard.gl_date between :gl_date_from and :gl_date_to
2817: and ra.posting_control_id <> -3
2818: and ra.receivable_application_id = ard.source_id
2819: and ard.source_table = ''RA''

Line 2829: from '||arp_recon_rep.var_tname.l_ar_distributions_all||' ard,

2825: ard.acctd_amount_cr acctd_amount_cr ,
2826: ard.code_combination_id code_combination_id,
2827: ard.ae_header_id ae_header_id,
2828: ard.ae_line_num ae_line_num
2829: from '||arp_recon_rep.var_tname.l_ar_distributions_all||' ard,
2830: '||arp_recon_rep.var_tname.l_ar_misc_cash_dists_all||' mcd
2831: where mcd.gl_date between :gl_date_from and :gl_date_to
2832: and mcd.posting_control_id <> -3
2833: and mcd.misc_cash_distribution_id = ard.source_id

Line 2830: '||arp_recon_rep.var_tname.l_ar_misc_cash_dists_all||' mcd

2826: ard.code_combination_id code_combination_id,
2827: ard.ae_header_id ae_header_id,
2828: ard.ae_line_num ae_line_num
2829: from '||arp_recon_rep.var_tname.l_ar_distributions_all||' ard,
2830: '||arp_recon_rep.var_tname.l_ar_misc_cash_dists_all||' mcd
2831: where mcd.gl_date between :gl_date_from and :gl_date_to
2832: and mcd.posting_control_id <> -3
2833: and mcd.misc_cash_distribution_id = ard.source_id
2834: and ard.source_table = ''MCD''

Line 2843: from '||arp_recon_rep.var_tname.l_ar_distributions_all||' ard,

2839: ard.acctd_amount_cr acctd_amount_cr ,
2840: ard.code_combination_id code_combination_id,
2841: ard.ae_header_id ae_header_id,
2842: ard.ae_line_num ae_line_num
2843: from '||arp_recon_rep.var_tname.l_ar_distributions_all||' ard,
2844: '||arp_recon_rep.var_tname.l_ar_adjustments_all||' adj
2845: where adj.gl_date between :gl_date_from and :gl_date_to
2846: and adj.posting_control_id <> -3
2847: and adj.adjustment_id = ard.source_id

Line 2844: '||arp_recon_rep.var_tname.l_ar_adjustments_all||' adj

2840: ard.code_combination_id code_combination_id,
2841: ard.ae_header_id ae_header_id,
2842: ard.ae_line_num ae_line_num
2843: from '||arp_recon_rep.var_tname.l_ar_distributions_all||' ard,
2844: '||arp_recon_rep.var_tname.l_ar_adjustments_all||' adj
2845: where adj.gl_date between :gl_date_from and :gl_date_to
2846: and adj.posting_control_id <> -3
2847: and adj.adjustment_id = ard.source_id
2848: and ard.source_table = ''ADJ''

Line 2857: from '||arp_recon_rep.var_tname.l_ar_distributions_all||' ard,

2853: ard.acctd_amount_cr acctd_amount_cr ,
2854: ard.code_combination_id code_combination_id,
2855: ard.ae_header_id ae_header_id,
2856: ard.ae_line_num ae_line_num
2857: from '||arp_recon_rep.var_tname.l_ar_distributions_all||' ard,
2858: ar_transaction_history_all ath
2859: where ath.gl_date between :gl_date_from and :gl_date_to
2860: and ath.posting_control_id <> -3
2861: and ath.transaction_history_id = ard.source_id

Line 2981: arp_recon_rep.get_chart_of_accounts_id(),'ALL',code_combination_id),

2977: group by gif.code_combination_id);
2978:
2979: update ar_gl_recon_gt
2980: set account = ar_calc_aging.get_value(101,'GL#',
2981: arp_recon_rep.get_chart_of_accounts_id(),'ALL',code_combination_id),
2982: company = ar_calc_aging.get_value(101,'GL#',
2983: arp_recon_rep.get_chart_of_accounts_id(),'GL_BALANCING',code_combination_id),
2984: account_desc = ar_calc_aging.get_description(101,'GL#',
2985: arp_recon_rep.get_chart_of_accounts_id(),'GL_ACCOUNT',code_combination_id);

Line 2983: arp_recon_rep.get_chart_of_accounts_id(),'GL_BALANCING',code_combination_id),

2979: update ar_gl_recon_gt
2980: set account = ar_calc_aging.get_value(101,'GL#',
2981: arp_recon_rep.get_chart_of_accounts_id(),'ALL',code_combination_id),
2982: company = ar_calc_aging.get_value(101,'GL#',
2983: arp_recon_rep.get_chart_of_accounts_id(),'GL_BALANCING',code_combination_id),
2984: account_desc = ar_calc_aging.get_description(101,'GL#',
2985: arp_recon_rep.get_chart_of_accounts_id(),'GL_ACCOUNT',code_combination_id);
2986:
2987: l_xml_query := '

Line 2985: arp_recon_rep.get_chart_of_accounts_id(),'GL_ACCOUNT',code_combination_id);

2981: arp_recon_rep.get_chart_of_accounts_id(),'ALL',code_combination_id),
2982: company = ar_calc_aging.get_value(101,'GL#',
2983: arp_recon_rep.get_chart_of_accounts_id(),'GL_BALANCING',code_combination_id),
2984: account_desc = ar_calc_aging.get_description(101,'GL#',
2985: arp_recon_rep.get_chart_of_accounts_id(),'GL_ACCOUNT',code_combination_id);
2986:
2987: l_xml_query := '
2988: select code_combination_id,
2989: account_type,

Line 3011: where ''N'' = arp_recon_rep.get_out_of_balance_only()

3007: nvl(gl_interface_cr,0) gl_interface_credit,
3008: nvl(receivables_dr,0) receivables_debit,
3009: nvl(receivables_cr,0) receivables_credit
3010: from ar_gl_recon_gt
3011: where ''N'' = arp_recon_rep.get_out_of_balance_only()
3012: or nvl(receivables_dr,0)- nvl(subledger_rec_dr,0) <> 0
3013: or nvl(receivables_cr,0)- nvl(subledger_rec_cr,0) <> 0
3014: order by account_type_code,
3015: company,

Line 3017: arp_recon_rep.get_chart_of_accounts_id(),

3013: or nvl(receivables_cr,0)- nvl(subledger_rec_cr,0) <> 0
3014: order by account_type_code,
3015: company,
3016: ar_calc_aging.get_value(101,''GL#'',
3017: arp_recon_rep.get_chart_of_accounts_id(),
3018: ''GL_ACCOUNT'',code_combination_id)';
3019:
3020: DBMS_UTILITY.DB_VERSION(l_version, l_compatibility);
3021: l_majorVersion := to_number(substr(l_version, 1, instr(l_version,'.')-1));

Line 3110: END ARP_RECON_REP;

3106: log('arglrecon_load_xml(-)');
3107:
3108: END arglrecon_load_xml;
3109:
3110: END ARP_RECON_REP;