APPS.WSH_ITM_EXPORT_SCREENING dependencies on WSH_ITM_SERIAL_NUMBERS

Line 145: INSERT INTO WSH_ITM_SERIAL_NUMBERS

141: WSH_DEBUG_SV.log(l_module_name,'l_from_serial_num ',l_from_serial_num);
142: END IF;
143:
144: -- Only one serial number needs to go in either From or to as both are same.
145: INSERT INTO WSH_ITM_SERIAL_NUMBERS
146: (request_control_id,
147: delivery_id,
148: delivery_detail_id,
149: serial_number)

Line 169: INSERT INTO WSH_ITM_SERIAL_NUMBERS

165: IF l_debug_on THEN
166: WSH_DEBUG_SV.log(l_module_name,'New Serial Number ',l_new_serial_number);
167: END IF;
168:
169: INSERT INTO WSH_ITM_SERIAL_NUMBERS
170: (request_control_id,
171: delivery_id,
172: delivery_detail_id,
173: serial_number)