APPS.WSH_ITM_EXPORT_SCREENING dependencies on FND_DATE

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

527: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Delivery_Table, ' AND WND.SHIP_METHOD_CODE = :b_ship_method_code', l_Delivery_Condn6Tab, 'VARCHAR');
528: END IF;
529:
530: IF p_pickup_date_from is not null THEN
531: l_Delivery_Condn8Tab(1).g_date_val := FND_DATE.CANONICAL_TO_DATE(p_pickup_date_from);
532: l_Delivery_Condn8Tab(1).g_Bind_Literal := ':b_pickup_date_from';
533: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Delivery_Table, ' AND WND.INITIAL_PICKUP_DATE >= :b_pickup_date_from', l_Delivery_Condn8Tab, 'DATE');
534: END IF;
535:

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

533: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Delivery_Table, ' AND WND.INITIAL_PICKUP_DATE >= :b_pickup_date_from', l_Delivery_Condn8Tab, 'DATE');
534: END IF;
535:
536: IF p_pickup_date_to is not null THEN
537: l_Delivery_Condn9Tab(1).g_date_val := FND_DATE.CANONICAL_TO_DATE(p_pickup_date_to);
538: l_Delivery_Condn9Tab(1).g_Bind_Literal := ':b_pickup_date_to';
539: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Delivery_Table, ' AND WND.INITIAL_PICKUP_DATE <= :b_pickup_date_to', l_Delivery_Condn9Tab, 'DATE');
540: END IF;
541: