DBA Data[Home] [Help]

APPS.WSH_ITM_EXPORT_SCREENING dependencies on WSH_ITM_SERIAL_NUMBERS

Line 134: INSERT INTO WSH_ITM_SERIAL_NUMBERS

130: WSH_DEBUG_SV.log(l_module_name,'l_from_serial_num ',l_from_serial_num);
131: END IF;
132:
133: -- Only one serial number needs to go in either From or to as both are same.
134: INSERT INTO WSH_ITM_SERIAL_NUMBERS
135: (request_control_id,
136: delivery_id,
137: delivery_detail_id,
138: serial_number)

Line 158: INSERT INTO WSH_ITM_SERIAL_NUMBERS

154: IF l_debug_on THEN
155: WSH_DEBUG_SV.log(l_module_name,'New Serial Number ',l_new_serial_number);
156: END IF;
157:
158: INSERT INTO WSH_ITM_SERIAL_NUMBERS
159: (request_control_id,
160: delivery_id,
161: delivery_detail_id,
162: serial_number)