APPS.WSH_SHIPMENT_ADVICE_PUB dependencies on WSH_NEW_DEL_INTERFACE

Line 156: l_delivery_interface_id WSH_NEW_DEL_INTERFACE.delivery_interface_id%TYPE;

152: p_delivery_rec IN Delivery_Rec_Type,
153: x_return_status OUT NOCOPY VARCHAR2) IS
154:
155: --
156: l_delivery_interface_id WSH_NEW_DEL_INTERFACE.delivery_interface_id%TYPE;
157: l_del_detail_interface_id WSH_DEL_DETAILS_INTERFACE.delivery_detail_interface_id%TYPE;
158: l_del_leg_interface_id NUMBER;
159: l_pickup_stop_interface_id NUMBER;
160: l_dropoff_stop_interface_id NUMBER;

Line 214: wsh_debug_sv.logmsg(l_module_name, 'Inserting into WSH_NEW_DEL_INTERFACE');

210: RAISE FND_API.G_EXC_ERROR;
211: END IF;
212:
213: IF l_debug_on THEN
214: wsh_debug_sv.logmsg(l_module_name, 'Inserting into WSH_NEW_DEL_INTERFACE');
215: END IF;
216:
217: INSERT INTO WSH_NEW_DEL_INTERFACE(
218: DELIVERY_INTERFACE_ID,

Line 217: INSERT INTO WSH_NEW_DEL_INTERFACE(

213: IF l_debug_on THEN
214: wsh_debug_sv.logmsg(l_module_name, 'Inserting into WSH_NEW_DEL_INTERFACE');
215: END IF;
216:
217: INSERT INTO WSH_NEW_DEL_INTERFACE(
218: DELIVERY_INTERFACE_ID,
219: NAME,
220: DESCRIPTION,
221: INITIAL_PICKUP_DATE,

Line 284: wsh_new_del_interface_s.nextval,

280: program_update_date,
281: request_id
282: )
283: VALUES(
284: wsh_new_del_interface_s.nextval,
285: p_delivery_rec.name,
286: p_delivery_rec.DESCRIPTION,
287: p_delivery_rec.INITIAL_PICKUP_DATE,
288: p_delivery_rec.ULTIMATE_DROPOFF_DATE,

Line 353: WSH_DEBUG_SV.log(l_module_name, 'Number of records inserted into WSH_NEW_DEL_INTERFACE',l_ins_rows);

349: RETURNING DELIVERY_INTERFACE_ID into l_delivery_interface_id;
350:
351: l_ins_rows := sql%rowcount;
352: IF l_debug_on THEN
353: WSH_DEBUG_SV.log(l_module_name, 'Number of records inserted into WSH_NEW_DEL_INTERFACE',l_ins_rows);
354: WSH_DEBUG_SV.log(l_module_name, 'Number of Delivery Freight records',p_delivery_rec.delivery_freight_tab.count);
355: END IF;
356:
357: