APPS.WSH_OTM_INBOUND_GRP dependencies on WSH_TRIP_STOPS_INTERFACE

Line 613: -- Create timezone_code as a new column in wsh_trip_stops_interface

609: l_stop_sequence_number(k) := p_int_trip_info(i).shipment_stops(k).stop_sequence_number;
610: l_stop_trip_int_id(k) := l_trip_int_id(i);
611:
612: -- Timezone conversion
613: -- Create timezone_code as a new column in wsh_trip_stops_interface
614:
615: -- LOOP over p_int_trip_info(i).locations
616: -- IF LocationGid.Xid matches stop_location_xid THEN store Address.TimeZoneGid.Xid of that record as TimezoneCode
617: -- Exit LOOP

Line 657: WSH_DEBUG_SV.logmsg(l_module_name,'Inserting into wsh_trip_stops_interface ');

653:
654: -- Bulk insert stop interface records here
655: -- returning stop_interface_id s BULK COLLECT INTO l_stop_int_id_tab
656: IF l_debug_on THEN
657: WSH_DEBUG_SV.logmsg(l_module_name,'Inserting into wsh_trip_stops_interface ');
658: END IF;
659:
660: forall j in p_int_trip_info(i).shipment_stops.FIRST .. p_int_trip_info(i).shipment_stops.LAST
661: -- bug 6700792: OTM Dock Door App Sched Info

Line 663: Insert into WSH_TRIP_STOPS_INTERFACE

659:
660: forall j in p_int_trip_info(i).shipment_stops.FIRST .. p_int_trip_info(i).shipment_stops.LAST
661: -- bug 6700792: OTM Dock Door App Sched Info
662: -- Inserting columns dock_name, start_time and end_time
663: Insert into WSH_TRIP_STOPS_INTERFACE
664: (STOP_INTERFACE_ID,
665: INTERFACE_ACTION_CODE,
666: TRIP_INTERFACE_ID,
667: STOP_LOCATION_ID,

Line 679: Values (WSH_TRIP_STOPS_INTERFACE_S.nextval,

675: CREATION_DATE,
676: CREATED_BY,
677: LAST_UPDATE_DATE,
678: LAST_UPDATED_BY)
679: Values (WSH_TRIP_STOPS_INTERFACE_S.nextval,
680: l_interface_act_code,
681: l_stop_trip_int_id(j),
682: l_stop_location_id(j),
683: l_stop_sequence_number(j),