APPS.WSH_U_TRACK SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 265

		if(l_request_in.FromPickupDate IS NOT NULL) then
    		L_INPUT_STR := L_INPUT_STR || '&' || 'FromPickupDate' ||'='|| TO_CHAR(l_request_in.FromPickupDate, 'YYYYMMDD');

Line: 271

		if(l_request_in.ToPickupDate IS NOT NULL) then
    		L_INPUT_STR := L_INPUT_STR || '&' || 'ToPickupDate' ||'='|| TO_CHAR(l_request_in.ToPickupDate, 'YYYYMMDD');

Line: 499

					x_track_header.FromPickupDate :=
							TO_DATE(WSH_U_UTIL.Calculate_Token(L_Track_Message,L_Token_Start,L_Token_End), 'YYYYMMDD');

Line: 508

					x_track_header.ToPickupDate :=
							TO_DATE(WSH_U_UTIL.Calculate_Token(L_Track_Message,L_Token_Start,L_Token_End), 'YYYYMMDD');

Line: 765

	    			x_multi_sum_header(l_multi_sum_header_i).PickupDate :=
							TO_DATE(WSH_U_UTIL.Calculate_Token(L_Track_Message,L_Token_Start,L_Token_End), 'YYYYMMDD');

Line: 767

	    			-- DBMS_OUTPUT.PUT_LINE('after PickupDate');

Line: 970

					x_pkg_detail_segment(l_pkg_detail_segment_i).PickupDate :=
							TO_DATE(WSH_U_UTIL.Calculate_Token(L_Track_Message,L_Token_Start,L_Token_End), 'YYYYMMDD');