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

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

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

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

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

949: -- arp_recon_rep.var_tname.g_set_of_books_id := p_sob_id;
950: /* Bug fix 5678284
951: p_coa_id is passed incorrectly when the user has access to multiple Ledgers */
952: --arp_recon_rep.var_tname.g_chart_of_accounts_id := p_coa_id;
953: arp_recon_rep.var_tname.g_gl_date_from := fnd_date.canonical_to_date(p_gl_date_from);
954: arp_recon_rep.var_tname.g_gl_date_to := fnd_date.canonical_to_date(p_gl_date_to);
955: arp_recon_rep.var_tname.g_posting_status := p_posting_status;
956: arp_recon_rep.var_tname.g_max_gl_date := to_date('31-12-4712','DD-MM-YYYY');
957:

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

950: /* Bug fix 5678284
951: p_coa_id is passed incorrectly when the user has access to multiple Ledgers */
952: --arp_recon_rep.var_tname.g_chart_of_accounts_id := p_coa_id;
953: arp_recon_rep.var_tname.g_gl_date_from := fnd_date.canonical_to_date(p_gl_date_from);
954: arp_recon_rep.var_tname.g_gl_date_to := fnd_date.canonical_to_date(p_gl_date_to);
955: arp_recon_rep.var_tname.g_posting_status := p_posting_status;
956: arp_recon_rep.var_tname.g_max_gl_date := to_date('31-12-4712','DD-MM-YYYY');
957:
958:

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

1991: l_xml_header := l_xml_header ||l_new_line||' '||l_reporting_entity_name||'';
1992: l_xml_header := l_xml_header ||l_new_line||' '||p_sob_id||'';
1993: l_xml_header := l_xml_header ||l_new_line||' '||p_co_seg_low||'';
1994: l_xml_header := l_xml_header ||l_new_line||' '||p_co_seg_high||'';
1995: l_xml_header := l_xml_header ||l_new_line||' '||to_char(fnd_date.canonical_to_date(p_gl_date_from),'YYYY-MM-DD')||'';
1996: l_xml_header := l_xml_header ||l_new_line||' '||to_char(fnd_date.canonical_to_date(p_gl_date_to),'YYYY-MM-DD')||'';
1997: l_xml_header := l_xml_header ||l_new_line||' '||l_status_meaning||'';
1998: l_xml_header := l_xml_header ||l_new_line||' '||p_gl_account_low||'';
1999: l_xml_header := l_xml_header ||l_new_line||' '||p_gl_account_high||'';

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

1992: l_xml_header := l_xml_header ||l_new_line||' '||p_sob_id||'';
1993: l_xml_header := l_xml_header ||l_new_line||' '||p_co_seg_low||'';
1994: l_xml_header := l_xml_header ||l_new_line||' '||p_co_seg_high||'';
1995: l_xml_header := l_xml_header ||l_new_line||' '||to_char(fnd_date.canonical_to_date(p_gl_date_from),'YYYY-MM-DD')||'';
1996: l_xml_header := l_xml_header ||l_new_line||' '||to_char(fnd_date.canonical_to_date(p_gl_date_to),'YYYY-MM-DD')||'';
1997: l_xml_header := l_xml_header ||l_new_line||' '||l_status_meaning||'';
1998: l_xml_header := l_xml_header ||l_new_line||' '||p_gl_account_low||'';
1999: l_xml_header := l_xml_header ||l_new_line||' '||p_gl_account_high||'';
2000: l_xml_header := l_xml_header ||l_new_line||' '||p_summary_account||'';

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

2163: /* bug 5654975 p_coa_id,p_sob_id is passed incorrectly when the user
2164: has access to multiple Ledgers */
2165: -- arp_recon_rep.var_tname.g_set_of_books_id := p_sob_id;
2166: -- arp_recon_rep.var_tname.g_chart_of_accounts_id := p_coa_id;
2167: arp_recon_rep.var_tname.g_gl_date_from := fnd_date.canonical_to_date(p_gl_date_from);
2168: arp_recon_rep.var_tname.g_gl_date_to := fnd_date.canonical_to_date(p_gl_date_to);
2169: arp_recon_rep.var_tname.g_posting_status := p_posting_status;
2170:
2171: /* Added Conditional Implication to address bug:5181586*/

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

2164: has access to multiple Ledgers */
2165: -- arp_recon_rep.var_tname.g_set_of_books_id := p_sob_id;
2166: -- arp_recon_rep.var_tname.g_chart_of_accounts_id := p_coa_id;
2167: arp_recon_rep.var_tname.g_gl_date_from := fnd_date.canonical_to_date(p_gl_date_from);
2168: arp_recon_rep.var_tname.g_gl_date_to := fnd_date.canonical_to_date(p_gl_date_to);
2169: arp_recon_rep.var_tname.g_posting_status := p_posting_status;
2170:
2171: /* Added Conditional Implication to address bug:5181586*/
2172: /*Added set of books id and char of accounts id for bug fix 5654975 */

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

3098: l_xml_header := l_xml_header ||l_new_line||' '||l_reporting_entity_name||'';
3099: l_xml_header := l_xml_header ||l_new_line||' '||p_sob_id||'';
3100: l_xml_header := l_xml_header ||l_new_line||' '||p_co_seg_low||'';
3101: l_xml_header := l_xml_header ||l_new_line||' '||p_co_seg_high||'';
3102: l_xml_header := l_xml_header ||l_new_line||' '||to_char(fnd_date.canonical_to_date(p_gl_date_from),'YYYY-MM-DD')||'';
3103: l_xml_header := l_xml_header ||l_new_line||' '||to_char(fnd_date.canonical_to_date(p_gl_date_to),'YYYY-MM-DD')||'';
3104: l_xml_header := l_xml_header ||l_new_line||' '||l_status_meaning||'';
3105: l_xml_header := l_xml_header ||l_new_line||' '||p_gl_account_low||'';
3106: l_xml_header := l_xml_header ||l_new_line||' '||p_gl_account_high||'';

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

3099: l_xml_header := l_xml_header ||l_new_line||' '||p_sob_id||'';
3100: l_xml_header := l_xml_header ||l_new_line||' '||p_co_seg_low||'';
3101: l_xml_header := l_xml_header ||l_new_line||' '||p_co_seg_high||'';
3102: l_xml_header := l_xml_header ||l_new_line||' '||to_char(fnd_date.canonical_to_date(p_gl_date_from),'YYYY-MM-DD')||'';
3103: l_xml_header := l_xml_header ||l_new_line||' '||to_char(fnd_date.canonical_to_date(p_gl_date_to),'YYYY-MM-DD')||'';
3104: l_xml_header := l_xml_header ||l_new_line||' '||l_status_meaning||'';
3105: l_xml_header := l_xml_header ||l_new_line||' '||p_gl_account_low||'';
3106: l_xml_header := l_xml_header ||l_new_line||' '||p_gl_account_high||'';
3107: l_xml_header := l_xml_header ||l_new_line||' '||p_summary_account||'';

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

3248: /* bug 5654975 p_coa_id,p_sob_id is passed incorrectly when the user
3249: has access to multiple Ledgers */
3250: -- arp_recon_rep.var_tname.g_set_of_books_id := p_sob_id;
3251: -- arp_recon_rep.var_tname.g_chart_of_accounts_id := p_coa_id;
3252: arp_recon_rep.var_tname.g_gl_date_from := fnd_date.canonical_to_date(p_gl_date_from);
3253: arp_recon_rep.var_tname.g_gl_date_to := fnd_date.canonical_to_date(p_gl_date_to);
3254: arp_recon_rep.var_tname.g_posting_status := p_posting_status;
3255:
3256: /* Added Conditional Implication to address bug:5181586*/

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

3249: has access to multiple Ledgers */
3250: -- arp_recon_rep.var_tname.g_set_of_books_id := p_sob_id;
3251: -- arp_recon_rep.var_tname.g_chart_of_accounts_id := p_coa_id;
3252: arp_recon_rep.var_tname.g_gl_date_from := fnd_date.canonical_to_date(p_gl_date_from);
3253: arp_recon_rep.var_tname.g_gl_date_to := fnd_date.canonical_to_date(p_gl_date_to);
3254: arp_recon_rep.var_tname.g_posting_status := p_posting_status;
3255:
3256: /* Added Conditional Implication to address bug:5181586*/
3257: /* Added set of books id and chart of accounts id for bug fix 565497*/

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

3581: l_xml_header := l_xml_header ||l_new_line||' '||l_reporting_entity_name||'';
3582: l_xml_header := l_xml_header ||l_new_line||' '||p_sob_id||'';
3583: l_xml_header := l_xml_header ||l_new_line||' '||p_co_seg_low||'';
3584: l_xml_header := l_xml_header ||l_new_line||' '||p_co_seg_high||'';
3585: l_xml_header := l_xml_header ||l_new_line||' '||to_char(fnd_date.canonical_to_date(p_gl_date_from),'YYYY-MM-DD')||'';
3586: l_xml_header := l_xml_header ||l_new_line||' '||to_char(fnd_date.canonical_to_date(p_gl_date_to),'YYYY-MM-DD')||'';
3587: l_xml_header := l_xml_header ||l_new_line||' '||l_status_meaning||'';
3588: l_xml_header := l_xml_header ||l_new_line||' '||p_gl_account_low||'';
3589: l_xml_header := l_xml_header ||l_new_line||' '||p_gl_account_high||'';

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

3582: l_xml_header := l_xml_header ||l_new_line||' '||p_sob_id||'';
3583: l_xml_header := l_xml_header ||l_new_line||' '||p_co_seg_low||'';
3584: l_xml_header := l_xml_header ||l_new_line||' '||p_co_seg_high||'';
3585: l_xml_header := l_xml_header ||l_new_line||' '||to_char(fnd_date.canonical_to_date(p_gl_date_from),'YYYY-MM-DD')||'';
3586: l_xml_header := l_xml_header ||l_new_line||' '||to_char(fnd_date.canonical_to_date(p_gl_date_to),'YYYY-MM-DD')||'';
3587: l_xml_header := l_xml_header ||l_new_line||' '||l_status_meaning||'';
3588: l_xml_header := l_xml_header ||l_new_line||' '||p_gl_account_low||'';
3589: l_xml_header := l_xml_header ||l_new_line||' '||p_gl_account_high||'';
3590: l_xml_header := l_xml_header ||l_new_line||' '||p_summary_account||'';