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 FND_DATE

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 787: l_xml_header := l_xml_header ||l_new_line||' '||to_char(fnd_date.canonical_to_date(p_gl_date_from),'YYYY-MM-DD')||'';

783: l_xml_header := l_xml_header ||l_new_line||' '||l_reporting_entity_name||'';
784: l_xml_header := l_xml_header ||l_new_line||' '||p_sob_id||'';
785: l_xml_header := l_xml_header ||l_new_line||' '||p_co_seg_low||'';
786: l_xml_header := l_xml_header ||l_new_line||' '||p_co_seg_high||'';
787: l_xml_header := l_xml_header ||l_new_line||' '||to_char(fnd_date.canonical_to_date(p_gl_date_from),'YYYY-MM-DD')||'';
788: l_xml_header := l_xml_header ||l_new_line||' '||to_char(fnd_date.canonical_to_date(p_gl_date_to),'YYYY-MM-DD')||'';
789: l_xml_header := l_xml_header ||l_new_line||' '||l_status_meaning||'';
790: l_xml_header := l_xml_header ||l_new_line||' '||p_gl_account_low||'';
791: l_xml_header := l_xml_header ||l_new_line||' '||p_gl_account_high||'';

Line 788: l_xml_header := l_xml_header ||l_new_line||' '||to_char(fnd_date.canonical_to_date(p_gl_date_to),'YYYY-MM-DD')||'';

784: l_xml_header := l_xml_header ||l_new_line||' '||p_sob_id||'';
785: l_xml_header := l_xml_header ||l_new_line||' '||p_co_seg_low||'';
786: l_xml_header := l_xml_header ||l_new_line||' '||p_co_seg_high||'';
787: l_xml_header := l_xml_header ||l_new_line||' '||to_char(fnd_date.canonical_to_date(p_gl_date_from),'YYYY-MM-DD')||'';
788: l_xml_header := l_xml_header ||l_new_line||' '||to_char(fnd_date.canonical_to_date(p_gl_date_to),'YYYY-MM-DD')||'';
789: l_xml_header := l_xml_header ||l_new_line||' '||l_status_meaning||'';
790: l_xml_header := l_xml_header ||l_new_line||' '||p_gl_account_low||'';
791: l_xml_header := l_xml_header ||l_new_line||' '||p_gl_account_high||'';
792: l_xml_header := l_xml_header ||l_new_line||' '||p_summary_account||'';

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 1382: l_xml_header := l_xml_header ||l_new_line||' '||to_char(fnd_date.canonical_to_date(p_gl_date_from),'YYYY-MM-DD')||'';

1378: l_xml_header := l_xml_header ||l_new_line||' '||l_reporting_entity_name||'';
1379: l_xml_header := l_xml_header ||l_new_line||' '||p_sob_id||'';
1380: l_xml_header := l_xml_header ||l_new_line||' '||p_co_seg_low||'';
1381: l_xml_header := l_xml_header ||l_new_line||' '||p_co_seg_high||'';
1382: l_xml_header := l_xml_header ||l_new_line||' '||to_char(fnd_date.canonical_to_date(p_gl_date_from),'YYYY-MM-DD')||'';
1383: l_xml_header := l_xml_header ||l_new_line||' '||to_char(fnd_date.canonical_to_date(p_gl_date_to),'YYYY-MM-DD')||'';
1384: l_xml_header := l_xml_header ||l_new_line||' '||l_status_meaning||'';
1385: l_xml_header := l_xml_header ||l_new_line||' '||p_gl_account_low||'';
1386: l_xml_header := l_xml_header ||l_new_line||' '||p_gl_account_high||'';

Line 1383: l_xml_header := l_xml_header ||l_new_line||' '||to_char(fnd_date.canonical_to_date(p_gl_date_to),'YYYY-MM-DD')||'';

1379: l_xml_header := l_xml_header ||l_new_line||' '||p_sob_id||'';
1380: l_xml_header := l_xml_header ||l_new_line||' '||p_co_seg_low||'';
1381: l_xml_header := l_xml_header ||l_new_line||' '||p_co_seg_high||'';
1382: l_xml_header := l_xml_header ||l_new_line||' '||to_char(fnd_date.canonical_to_date(p_gl_date_from),'YYYY-MM-DD')||'';
1383: l_xml_header := l_xml_header ||l_new_line||' '||to_char(fnd_date.canonical_to_date(p_gl_date_to),'YYYY-MM-DD')||'';
1384: l_xml_header := l_xml_header ||l_new_line||' '||l_status_meaning||'';
1385: l_xml_header := l_xml_header ||l_new_line||' '||p_gl_account_low||'';
1386: l_xml_header := l_xml_header ||l_new_line||' '||p_gl_account_high||'';
1387: l_xml_header := l_xml_header ||l_new_line||' '||p_summary_account||'';

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 1901: l_xml_header := l_xml_header ||l_new_line||' '||to_char(fnd_date.canonical_to_date(p_gl_date_from),'YYYY-MM-DD')||'';

1897: l_xml_header := l_xml_header ||l_new_line||' '||l_reporting_entity_name||'';
1898: l_xml_header := l_xml_header ||l_new_line||' '||p_sob_id||'';
1899: l_xml_header := l_xml_header ||l_new_line||' '||p_co_seg_low||'';
1900: l_xml_header := l_xml_header ||l_new_line||' '||p_co_seg_high||'';
1901: l_xml_header := l_xml_header ||l_new_line||' '||to_char(fnd_date.canonical_to_date(p_gl_date_from),'YYYY-MM-DD')||'';
1902: l_xml_header := l_xml_header ||l_new_line||' '||to_char(fnd_date.canonical_to_date(p_gl_date_to),'YYYY-MM-DD')||'';
1903: l_xml_header := l_xml_header ||l_new_line||' '||l_status_meaning||'';
1904: l_xml_header := l_xml_header ||l_new_line||' '||p_gl_account_low||'';
1905: l_xml_header := l_xml_header ||l_new_line||' '||p_gl_account_high||'';

Line 1902: l_xml_header := l_xml_header ||l_new_line||' '||to_char(fnd_date.canonical_to_date(p_gl_date_to),'YYYY-MM-DD')||'';

1898: l_xml_header := l_xml_header ||l_new_line||' '||p_sob_id||'';
1899: l_xml_header := l_xml_header ||l_new_line||' '||p_co_seg_low||'';
1900: l_xml_header := l_xml_header ||l_new_line||' '||p_co_seg_high||'';
1901: l_xml_header := l_xml_header ||l_new_line||' '||to_char(fnd_date.canonical_to_date(p_gl_date_from),'YYYY-MM-DD')||'';
1902: l_xml_header := l_xml_header ||l_new_line||' '||to_char(fnd_date.canonical_to_date(p_gl_date_to),'YYYY-MM-DD')||'';
1903: l_xml_header := l_xml_header ||l_new_line||' '||l_status_meaning||'';
1904: l_xml_header := l_xml_header ||l_new_line||' '||p_gl_account_low||'';
1905: l_xml_header := l_xml_header ||l_new_line||' '||p_gl_account_high||'';
1906: l_xml_header := l_xml_header ||l_new_line||' '||p_summary_account||'';

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 2372: l_xml_header := l_xml_header ||l_new_line||' '||to_char(fnd_date.canonical_to_date(p_gl_date_from),'YYYY-MM-DD')||'';

2368: l_xml_header := l_xml_header ||l_new_line||' '||l_reporting_entity_name||'';
2369: l_xml_header := l_xml_header ||l_new_line||' '||p_sob_id||'';
2370: l_xml_header := l_xml_header ||l_new_line||' '||p_co_seg_low||'';
2371: l_xml_header := l_xml_header ||l_new_line||' '||p_co_seg_high||'';
2372: l_xml_header := l_xml_header ||l_new_line||' '||to_char(fnd_date.canonical_to_date(p_gl_date_from),'YYYY-MM-DD')||'';
2373: l_xml_header := l_xml_header ||l_new_line||' '||to_char(fnd_date.canonical_to_date(p_gl_date_to),'YYYY-MM-DD')||'';
2374: l_xml_header := l_xml_header ||l_new_line||' '||l_status_meaning||'';
2375: l_xml_header := l_xml_header ||l_new_line||' '||p_gl_account_low||'';
2376: l_xml_header := l_xml_header ||l_new_line||' '||p_gl_account_high||'';

Line 2373: l_xml_header := l_xml_header ||l_new_line||' '||to_char(fnd_date.canonical_to_date(p_gl_date_to),'YYYY-MM-DD')||'';

2369: l_xml_header := l_xml_header ||l_new_line||' '||p_sob_id||'';
2370: l_xml_header := l_xml_header ||l_new_line||' '||p_co_seg_low||'';
2371: l_xml_header := l_xml_header ||l_new_line||' '||p_co_seg_high||'';
2372: l_xml_header := l_xml_header ||l_new_line||' '||to_char(fnd_date.canonical_to_date(p_gl_date_from),'YYYY-MM-DD')||'';
2373: l_xml_header := l_xml_header ||l_new_line||' '||to_char(fnd_date.canonical_to_date(p_gl_date_to),'YYYY-MM-DD')||'';
2374: l_xml_header := l_xml_header ||l_new_line||' '||l_status_meaning||'';
2375: l_xml_header := l_xml_header ||l_new_line||' '||p_gl_account_low||'';
2376: l_xml_header := l_xml_header ||l_new_line||' '||p_gl_account_high||'';
2377: l_xml_header := l_xml_header ||l_new_line||' '||p_summary_account||'';