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

Line 546: ' TRUNC(inner.del_pickup_date) BETWEEN ''' || FND_DATE.CANONICAL_TO_DATE(p_ship_date_from) ||

542:
543: --added TRUNC function for bug 12605679
544: IF (p_ship_date_from IS NOT NULL) THEN
545: trip_sql := trip_sql ||
546: ' TRUNC(inner.del_pickup_date) BETWEEN ''' || FND_DATE.CANONICAL_TO_DATE(p_ship_date_from) ||
547: ''' AND ''' || FND_DATE.CANONICAL_TO_DATE(p_ship_date_to) || '''';
548: ELSE
549: trip_sql := trip_sql ||
550: ' inner.del_pickup_date < '''

Line 547: ''' AND ''' || FND_DATE.CANONICAL_TO_DATE(p_ship_date_to) || '''';

543: --added TRUNC function for bug 12605679
544: IF (p_ship_date_from IS NOT NULL) THEN
545: trip_sql := trip_sql ||
546: ' TRUNC(inner.del_pickup_date) BETWEEN ''' || FND_DATE.CANONICAL_TO_DATE(p_ship_date_from) ||
547: ''' AND ''' || FND_DATE.CANONICAL_TO_DATE(p_ship_date_to) || '''';
548: ELSE
549: trip_sql := trip_sql ||
550: ' inner.del_pickup_date < '''
551: || to_date(SYSDATE - p_delete_beyond_x_ship_days,'DD-MM-YYYY') ||'''' ;

Line 690: BETWEEN '''|| FND_DATE.CANONICAL_TO_DATE(p_create_date_from) || '''

686: --added TRUNC function for bug 12605679
687: IF (p_create_date_from IS NOT NULL) THEN
688: delivery_sql := delivery_sql || '
689: AND TRUNC(wnd.creation_date)
690: BETWEEN '''|| FND_DATE.CANONICAL_TO_DATE(p_create_date_from) || '''
691: AND '''|| FND_DATE.CANONICAL_TO_DATE(p_create_date_to) || '''' ;
692: ELSE
693: delivery_sql := delivery_sql || '
694: AND wnd.creation_date < '''

Line 691: AND '''|| FND_DATE.CANONICAL_TO_DATE(p_create_date_to) || '''' ;

687: IF (p_create_date_from IS NOT NULL) THEN
688: delivery_sql := delivery_sql || '
689: AND TRUNC(wnd.creation_date)
690: BETWEEN '''|| FND_DATE.CANONICAL_TO_DATE(p_create_date_from) || '''
691: AND '''|| FND_DATE.CANONICAL_TO_DATE(p_create_date_to) || '''' ;
692: ELSE
693: delivery_sql := delivery_sql || '
694: AND wnd.creation_date < '''
695: || to_date(SYSDATE - p_del_beyond_creation_days,'DD-MM-YYYY') ||'''' ;

Line 723: BETWEEN '''|| FND_DATE.CANONICAL_TO_DATE(p_create_date_from) || '''

719: --added TRUNC function for bug 12605679
720: IF (p_create_date_from IS NOT NULL) THEN
721: empty_trip_sql := empty_trip_sql || '
722: TRUNC(wt.creation_date)
723: BETWEEN '''|| FND_DATE.CANONICAL_TO_DATE(p_create_date_from) || '''
724: AND '''|| FND_DATE.CANONICAL_TO_DATE(p_create_date_to) || '''' ;
725: ELSE
726: empty_trip_sql := empty_trip_sql || '
727: wt.creation_date < '''

Line 724: AND '''|| FND_DATE.CANONICAL_TO_DATE(p_create_date_to) || '''' ;

720: IF (p_create_date_from IS NOT NULL) THEN
721: empty_trip_sql := empty_trip_sql || '
722: TRUNC(wt.creation_date)
723: BETWEEN '''|| FND_DATE.CANONICAL_TO_DATE(p_create_date_from) || '''
724: AND '''|| FND_DATE.CANONICAL_TO_DATE(p_create_date_to) || '''' ;
725: ELSE
726: empty_trip_sql := empty_trip_sql || '
727: wt.creation_date < '''
728: || to_date(SYSDATE - p_del_beyond_creation_days,'DD-MM-YYYY') ||'''' ;

Line 762: BETWEEN '''|| FND_DATE.CANONICAL_TO_DATE(p_create_date_from) || '''

758: --added TRUNC function for bug 12605679
759: IF (p_create_date_from IS NOT NULL) THEN
760: empty_container_sql := empty_container_sql || '
761: AND TRUNC(wdd.creation_date)
762: BETWEEN '''|| FND_DATE.CANONICAL_TO_DATE(p_create_date_from) || '''
763: AND '''|| FND_DATE.CANONICAL_TO_DATE(p_create_date_to) || '''' ;
764: ELSE
765: empty_container_sql := empty_container_sql || '
766: AND wdd.creation_date < '''

Line 763: AND '''|| FND_DATE.CANONICAL_TO_DATE(p_create_date_to) || '''' ;

759: IF (p_create_date_from IS NOT NULL) THEN
760: empty_container_sql := empty_container_sql || '
761: AND TRUNC(wdd.creation_date)
762: BETWEEN '''|| FND_DATE.CANONICAL_TO_DATE(p_create_date_from) || '''
763: AND '''|| FND_DATE.CANONICAL_TO_DATE(p_create_date_to) || '''' ;
764: ELSE
765: empty_container_sql := empty_container_sql || '
766: AND wdd.creation_date < '''
767: || to_date(SYSDATE - p_del_beyond_creation_days,'DD-MM-YYYY') ||'''' ;

Line 946: BETWEEN '''|| FND_DATE.CANONICAL_TO_DATE(p_create_date_from) || '''

942:
943: IF (p_create_date_from IS NOT NULL) THEN
944: cancel_wdd_sql := cancel_wdd_sql || '
945: AND TRUNC(wdd.creation_date)
946: BETWEEN '''|| FND_DATE.CANONICAL_TO_DATE(p_create_date_from) || '''
947: AND '''|| FND_DATE.CANONICAL_TO_DATE(p_create_date_to) || '''' ;
948: ELSE
949: cancel_wdd_sql := cancel_wdd_sql || '
950: AND wdd.creation_date < '''

Line 947: AND '''|| FND_DATE.CANONICAL_TO_DATE(p_create_date_to) || '''' ;

943: IF (p_create_date_from IS NOT NULL) THEN
944: cancel_wdd_sql := cancel_wdd_sql || '
945: AND TRUNC(wdd.creation_date)
946: BETWEEN '''|| FND_DATE.CANONICAL_TO_DATE(p_create_date_from) || '''
947: AND '''|| FND_DATE.CANONICAL_TO_DATE(p_create_date_to) || '''' ;
948: ELSE
949: cancel_wdd_sql := cancel_wdd_sql || '
950: AND wdd.creation_date < '''
951: || to_date(SYSDATE - p_del_beyond_creation_days,'DD-MM-YYYY') ||'''' ;

Line 2384: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || FND_DATE.CANONICAL_TO_DATE(p_ship_date_from) || '');

2380:
2381: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_order_number_from || '');
2382: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_order_number_to || '');
2383: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_order_type || '');
2384: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || FND_DATE.CANONICAL_TO_DATE(p_ship_date_from) || '');
2385: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || FND_DATE.CANONICAL_TO_DATE(p_ship_date_to) || '');
2386: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_delete_beyond_x_ship_days || '');
2387:
2388: IF p_purge_intransit_trips = 'Y' THEN

Line 2385: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || FND_DATE.CANONICAL_TO_DATE(p_ship_date_to) || '');

2381: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_order_number_from || '');
2382: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_order_number_to || '');
2383: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_order_type || '');
2384: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || FND_DATE.CANONICAL_TO_DATE(p_ship_date_from) || '');
2385: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || FND_DATE.CANONICAL_TO_DATE(p_ship_date_to) || '');
2386: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_delete_beyond_x_ship_days || '');
2387:
2388: IF p_purge_intransit_trips = 'Y' THEN
2389: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Yes');

Line 2400: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| FND_DATE.CANONICAL_TO_DATE(p_create_date_from) ||'');

2396: ELSE
2397: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'No');
2398: END IF;
2399:
2400: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| FND_DATE.CANONICAL_TO_DATE(p_create_date_from) ||'');
2401: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| FND_DATE.CANONICAL_TO_DATE(p_create_date_to) ||'');
2402: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_del_beyond_creation_days || '');
2403:
2404: IF p_sort_per_criteria = 'T' THEN

Line 2401: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| FND_DATE.CANONICAL_TO_DATE(p_create_date_to) ||'');

2397: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'No');
2398: END IF;
2399:
2400: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| FND_DATE.CANONICAL_TO_DATE(p_create_date_from) ||'');
2401: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| FND_DATE.CANONICAL_TO_DATE(p_create_date_to) ||'');
2402: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_del_beyond_creation_days || '');
2403:
2404: IF p_sort_per_criteria = 'T' THEN
2405: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Trip');