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.GMPMRACT dependencies on FND_DATE

Line 394: | with fnd_date.date_to_canonical. |

390: | |
391: | MODIFICATION HISTORY |
392: | 12/31/02 Sridhar Gidugu ----- created |
393: | 04/22/03 Sastry BUG#2889706 Modified the G_where by replacing to_char|
394: | with fnd_date.date_to_canonical. |
395: +============================================================================*/
396: PROCEDURE set_where_clause IS
397: BEGIN
398: IF G_fwhse_code IS NOT NULL THEN

Line 407: --Modified the G_where by replacing to_char with fnd_date.date_to_canonical

403: G_where := G_where||' and whse_code <= '||''''||G_twhse_code||'''';
404: END IF;
405: IF G_ftrans_date IS NOT NULL THEN
406: --BEGIN BUG#2889706 Sastry
407: --Modified the G_where by replacing to_char with fnd_date.date_to_canonical
408: G_where := G_where||' and trans_date >= fnd_date.canonical_to_date('''||
409: fnd_date.date_to_canonical(G_ftrans_date)||''')';
410: END IF;
411: IF G_ttrans_date IS NOT NULL THEN

Line 408: G_where := G_where||' and trans_date >= fnd_date.canonical_to_date('''||

404: END IF;
405: IF G_ftrans_date IS NOT NULL THEN
406: --BEGIN BUG#2889706 Sastry
407: --Modified the G_where by replacing to_char with fnd_date.date_to_canonical
408: G_where := G_where||' and trans_date >= fnd_date.canonical_to_date('''||
409: fnd_date.date_to_canonical(G_ftrans_date)||''')';
410: END IF;
411: IF G_ttrans_date IS NOT NULL THEN
412: G_where := G_where||' and trans_date <= fnd_date.canonical_to_date('''||

Line 409: fnd_date.date_to_canonical(G_ftrans_date)||''')';

405: IF G_ftrans_date IS NOT NULL THEN
406: --BEGIN BUG#2889706 Sastry
407: --Modified the G_where by replacing to_char with fnd_date.date_to_canonical
408: G_where := G_where||' and trans_date >= fnd_date.canonical_to_date('''||
409: fnd_date.date_to_canonical(G_ftrans_date)||''')';
410: END IF;
411: IF G_ttrans_date IS NOT NULL THEN
412: G_where := G_where||' and trans_date <= fnd_date.canonical_to_date('''||
413: fnd_date.date_to_canonical(G_ttrans_date)||''')';

Line 412: G_where := G_where||' and trans_date <= fnd_date.canonical_to_date('''||

408: G_where := G_where||' and trans_date >= fnd_date.canonical_to_date('''||
409: fnd_date.date_to_canonical(G_ftrans_date)||''')';
410: END IF;
411: IF G_ttrans_date IS NOT NULL THEN
412: G_where := G_where||' and trans_date <= fnd_date.canonical_to_date('''||
413: fnd_date.date_to_canonical(G_ttrans_date)||''')';
414: --END BUG#2889706
415: END IF;
416: END set_where_clause; /* End of Procedure set where Clause */

Line 413: fnd_date.date_to_canonical(G_ttrans_date)||''')';

409: fnd_date.date_to_canonical(G_ftrans_date)||''')';
410: END IF;
411: IF G_ttrans_date IS NOT NULL THEN
412: G_where := G_where||' and trans_date <= fnd_date.canonical_to_date('''||
413: fnd_date.date_to_canonical(G_ttrans_date)||''')';
414: --END BUG#2889706
415: END IF;
416: END set_where_clause; /* End of Procedure set where Clause */
417: /*============================================================================+