3659: p_delivery_interface_id,
3660: l_pickup_stop_interface_id,
3661: l_dropoff_stop_interface_id,
3662: SYSDATE,
3663: FND_GLOBAL.USER_ID,
3664: SYSDATE,
3665: FND_GLOBAL.USER_ID,
3666: '94X_INBOUND');
3667:
3661: l_dropoff_stop_interface_id,
3662: SYSDATE,
3663: FND_GLOBAL.USER_ID,
3664: SYSDATE,
3665: FND_GLOBAL.USER_ID,
3666: '94X_INBOUND');
3667:
3668: -- insert records into wsh_trip_stops_interface
3669: -- first the pickup stop
3682: l_trip_interface_id,
3683: p_act_dep_date,
3684: p_dep_seal_code,
3685: SYSDATE,
3686: FND_GLOBAL.USER_ID,
3687: SYSDATE,
3688: FND_GLOBAL.USER_ID,
3689: '94X_INBOUND');
3690:
3684: p_dep_seal_code,
3685: SYSDATE,
3686: FND_GLOBAL.USER_ID,
3687: SYSDATE,
3688: FND_GLOBAL.USER_ID,
3689: '94X_INBOUND');
3690:
3691: -- then the dropoff stop
3692: INSERT INTO wsh_trip_stops_interface(
3702: l_dropoff_stop_interface_id,
3703: l_trip_interface_id,
3704: p_act_arr_date,
3705: SYSDATE,
3706: FND_GLOBAL.USER_ID,
3707: SYSDATE,
3708: FND_GLOBAL.USER_ID,
3709: '94X_INBOUND');
3710:
3704: p_act_arr_date,
3705: SYSDATE,
3706: FND_GLOBAL.USER_ID,
3707: SYSDATE,
3708: FND_GLOBAL.USER_ID,
3709: '94X_INBOUND');
3710:
3711: -- insert records into wsh_trips_interface
3712: INSERT INTO wsh_trips_interface(
3728: p_trip_vehicle_num,
3729: p_trip_route_id,
3730: p_trip_routing_ins,
3731: SYSDATE,
3732: FND_GLOBAL.USER_ID,
3733: SYSDATE,
3734: FND_GLOBAL.USER_ID,
3735: '94X_INBOUND',
3736: p_operator);
3730: p_trip_routing_ins,
3731: SYSDATE,
3732: FND_GLOBAL.USER_ID,
3733: SYSDATE,
3734: FND_GLOBAL.USER_ID,
3735: '94X_INBOUND',
3736: p_operator);
3737:
3738: IF l_debug_on THEN