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 530: ' AND inner.del_pickup_date BETWEEN ''' || FND_DATE.CANONICAL_TO_DATE(p_ship_date_from) ||

526: END IF;
527:
528: IF (p_ship_date_from IS NOT NULL) THEN
529: trip_sql := trip_sql ||
530: ' AND inner.del_pickup_date BETWEEN ''' || FND_DATE.CANONICAL_TO_DATE(p_ship_date_from) ||
531: ''' AND ''' || FND_DATE.CANONICAL_TO_DATE(p_ship_date_to) || '''';
532: ELSE
533: trip_sql := trip_sql ||
534: ' AND inner.del_pickup_date < '''

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

527:
528: IF (p_ship_date_from IS NOT NULL) THEN
529: trip_sql := trip_sql ||
530: ' AND inner.del_pickup_date BETWEEN ''' || FND_DATE.CANONICAL_TO_DATE(p_ship_date_from) ||
531: ''' AND ''' || FND_DATE.CANONICAL_TO_DATE(p_ship_date_to) || '''';
532: ELSE
533: trip_sql := trip_sql ||
534: ' AND inner.del_pickup_date < '''
535: || to_date(SYSDATE - p_delete_beyond_x_ship_days,'DD-MM-YYYY') ||'''' ;

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

619: --check for taking creation dates
620: IF (p_create_date_from IS NOT NULL) THEN
621: delivery_sql := delivery_sql || '
622: AND wnd.creation_date
623: BETWEEN '''|| FND_DATE.CANONICAL_TO_DATE(p_create_date_from) || '''
624: AND '''|| FND_DATE.CANONICAL_TO_DATE(p_create_date_to) || '''' ;
625: ELSE
626: delivery_sql := delivery_sql || '
627: AND wnd.creation_date < '''

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

620: IF (p_create_date_from IS NOT NULL) THEN
621: delivery_sql := delivery_sql || '
622: AND wnd.creation_date
623: BETWEEN '''|| FND_DATE.CANONICAL_TO_DATE(p_create_date_from) || '''
624: AND '''|| FND_DATE.CANONICAL_TO_DATE(p_create_date_to) || '''' ;
625: ELSE
626: delivery_sql := delivery_sql || '
627: AND wnd.creation_date < '''
628: || to_date(SYSDATE - p_del_beyond_creation_days,'DD-MM-YYYY') ||'''' ;

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

643: --check for taking creation dates
644: IF (p_create_date_from IS NOT NULL) THEN
645: empty_trip_sql := empty_trip_sql || '
646: wt.creation_date
647: BETWEEN '''|| FND_DATE.CANONICAL_TO_DATE(p_create_date_from) || '''
648: AND '''|| FND_DATE.CANONICAL_TO_DATE(p_create_date_to) || '''' ;
649: ELSE
650: empty_trip_sql := empty_trip_sql || '
651: wt.creation_date < '''

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

644: IF (p_create_date_from IS NOT NULL) THEN
645: empty_trip_sql := empty_trip_sql || '
646: wt.creation_date
647: BETWEEN '''|| FND_DATE.CANONICAL_TO_DATE(p_create_date_from) || '''
648: AND '''|| FND_DATE.CANONICAL_TO_DATE(p_create_date_to) || '''' ;
649: ELSE
650: empty_trip_sql := empty_trip_sql || '
651: wt.creation_date < '''
652: || to_date(SYSDATE - p_del_beyond_creation_days,'DD-MM-YYYY') ||'''' ;

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

682: --check for taking creation dates
683: IF (p_create_date_from IS NOT NULL) THEN
684: empty_container_sql := empty_container_sql || '
685: AND wdd.creation_date
686: BETWEEN '''|| FND_DATE.CANONICAL_TO_DATE(p_create_date_from) || '''
687: AND '''|| FND_DATE.CANONICAL_TO_DATE(p_create_date_to) || '''' ;
688: ELSE
689: empty_container_sql := empty_container_sql || '
690: AND wdd.creation_date < '''

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

683: IF (p_create_date_from IS NOT NULL) THEN
684: empty_container_sql := empty_container_sql || '
685: AND wdd.creation_date
686: BETWEEN '''|| FND_DATE.CANONICAL_TO_DATE(p_create_date_from) || '''
687: AND '''|| FND_DATE.CANONICAL_TO_DATE(p_create_date_to) || '''' ;
688: ELSE
689: empty_container_sql := empty_container_sql || '
690: AND wdd.creation_date < '''
691: || to_date(SYSDATE - p_del_beyond_creation_days,'DD-MM-YYYY') ||'''' ;

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

2234:
2235: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_order_number_from || '');
2236: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_order_number_to || '');
2237: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_order_type || '');
2238: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || FND_DATE.CANONICAL_TO_DATE(p_ship_date_from) || '');
2239: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || FND_DATE.CANONICAL_TO_DATE(p_ship_date_to) || '');
2240: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_delete_beyond_x_ship_days || '');
2241:
2242: IF p_purge_intransit_trips = 'Y' THEN

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

2235: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_order_number_from || '');
2236: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_order_number_to || '');
2237: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_order_type || '');
2238: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || FND_DATE.CANONICAL_TO_DATE(p_ship_date_from) || '');
2239: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || FND_DATE.CANONICAL_TO_DATE(p_ship_date_to) || '');
2240: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_delete_beyond_x_ship_days || '');
2241:
2242: IF p_purge_intransit_trips = 'Y' THEN
2243: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Yes');

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

2250: ELSE
2251: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'No');
2252: END IF;
2253:
2254: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| FND_DATE.CANONICAL_TO_DATE(p_create_date_from) ||'');
2255: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| FND_DATE.CANONICAL_TO_DATE(p_create_date_to) ||'');
2256: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_del_beyond_creation_days || '');
2257:
2258: IF p_sort_per_criteria = 'T' THEN

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

2251: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'No');
2252: END IF;
2253:
2254: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| FND_DATE.CANONICAL_TO_DATE(p_create_date_from) ||'');
2255: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| FND_DATE.CANONICAL_TO_DATE(p_create_date_to) ||'');
2256: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_del_beyond_creation_days || '');
2257:
2258: IF p_sort_per_criteria = 'T' THEN
2259: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Trip');