APPS.WSH_ITM_EXPORT_SCREENING dependencies on FND_DATE

Line 518: l_Delivery_Condn8Tab(1).g_date_val := FND_DATE.CANONICAL_TO_DATE(p_pickup_date_from);

514: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Delivery_Table, ' AND WND.SHIP_METHOD_CODE = :b_ship_method_code', l_Delivery_Condn6Tab, 'VARCHAR');
515: END IF;
516:
517: IF p_pickup_date_from is not null THEN
518: l_Delivery_Condn8Tab(1).g_date_val := FND_DATE.CANONICAL_TO_DATE(p_pickup_date_from);
519: l_Delivery_Condn8Tab(1).g_Bind_Literal := ':b_pickup_date_from';
520: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Delivery_Table, ' AND WND.INITIAL_PICKUP_DATE >= :b_pickup_date_from', l_Delivery_Condn8Tab, 'DATE');
521: END IF;
522:

Line 524: l_Delivery_Condn9Tab(1).g_date_val := FND_DATE.CANONICAL_TO_DATE(p_pickup_date_to);

520: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Delivery_Table, ' AND WND.INITIAL_PICKUP_DATE >= :b_pickup_date_from', l_Delivery_Condn8Tab, 'DATE');
521: END IF;
522:
523: IF p_pickup_date_to is not null THEN
524: l_Delivery_Condn9Tab(1).g_date_val := FND_DATE.CANONICAL_TO_DATE(p_pickup_date_to);
525: l_Delivery_Condn9Tab(1).g_Bind_Literal := ':b_pickup_date_to';
526: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Delivery_Table, ' AND WND.INITIAL_PICKUP_DATE <= :b_pickup_date_to', l_Delivery_Condn9Tab, 'DATE');
527: END IF;
528: