DBA Data[Home] [Help]

APPS.WSH_OTM_INBOUND_GRP dependencies on WSH_TRIPS_INTERFACE

Line 524: WSH_DEBUG_SV.logmsg(l_module_name,'Inserting into wsh_trips interface ');

520:
521: -- Insert the trip_interface here returning the trip_interface_id into l_trip_int_id(i)
522:
523: IF l_debug_on THEN
524: WSH_DEBUG_SV.logmsg(l_module_name,'Inserting into wsh_trips interface ');
525: END IF;
526:
527: Insert into WSH_TRIPS_INTERFACE
528: (TRIP_INTERFACE_ID,

Line 527: Insert into WSH_TRIPS_INTERFACE

523: IF l_debug_on THEN
524: WSH_DEBUG_SV.logmsg(l_module_name,'Inserting into wsh_trips interface ');
525: END IF;
526:
527: Insert into WSH_TRIPS_INTERFACE
528: (TRIP_INTERFACE_ID,
529: INTERFACE_ACTION_CODE,
530: NAME,
531: GROUP_ID,

Line 546: Values ( WSH_TRIPS_INTERFACE_S.nextval,

542: CREATION_DATE,
543: CREATED_BY,
544: LAST_UPDATE_DATE,
545: LAST_UPDATED_BY)
546: Values ( WSH_TRIPS_INTERFACE_S.nextval,
547: l_interface_act_code,
548: NULL,
549: nvl(l_group_id,WSH_TRIPS_INTERFACE_GROUP_S.nextval),
550: l_tp_plan_name(i),

Line 549: nvl(l_group_id,WSH_TRIPS_INTERFACE_GROUP_S.nextval),

545: LAST_UPDATED_BY)
546: Values ( WSH_TRIPS_INTERFACE_S.nextval,
547: l_interface_act_code,
548: NULL,
549: nvl(l_group_id,WSH_TRIPS_INTERFACE_GROUP_S.nextval),
550: l_tp_plan_name(i),
551: l_carrier_id(i),
552: l_mode_of_transport(i),
553: l_service_level(i),