DBA Data[Home] [Help]

APPS.WSH_DELIVERY_LEGS_PVT dependencies on FND_GLOBAL

Line 127: ,nvl(p_delivery_leg_info.created_by, FND_GLOBAL.USER_ID)

123: ,p_delivery_leg_info.weight_uom_code
124: ,p_delivery_leg_info.volume
125: ,p_delivery_leg_info.volume_uom_code
126: ,nvl(p_delivery_leg_info.creation_date, SYSDATE)
127: ,nvl(p_delivery_leg_info.created_by, FND_GLOBAL.USER_ID)
128: ,nvl(p_delivery_leg_info.last_update_date, SYSDATE)
129: ,nvl(p_delivery_leg_info.last_updated_by, FND_GLOBAL.USER_ID)
130: ,nvl(p_delivery_leg_info.last_update_login, FND_GLOBAL.LOGIN_ID)
131: ,p_delivery_leg_info.program_application_id

Line 129: ,nvl(p_delivery_leg_info.last_updated_by, FND_GLOBAL.USER_ID)

125: ,p_delivery_leg_info.volume_uom_code
126: ,nvl(p_delivery_leg_info.creation_date, SYSDATE)
127: ,nvl(p_delivery_leg_info.created_by, FND_GLOBAL.USER_ID)
128: ,nvl(p_delivery_leg_info.last_update_date, SYSDATE)
129: ,nvl(p_delivery_leg_info.last_updated_by, FND_GLOBAL.USER_ID)
130: ,nvl(p_delivery_leg_info.last_update_login, FND_GLOBAL.LOGIN_ID)
131: ,p_delivery_leg_info.program_application_id
132: ,p_delivery_leg_info.program_id
133: ,p_delivery_leg_info.program_update_date

Line 130: ,nvl(p_delivery_leg_info.last_update_login, FND_GLOBAL.LOGIN_ID)

126: ,nvl(p_delivery_leg_info.creation_date, SYSDATE)
127: ,nvl(p_delivery_leg_info.created_by, FND_GLOBAL.USER_ID)
128: ,nvl(p_delivery_leg_info.last_update_date, SYSDATE)
129: ,nvl(p_delivery_leg_info.last_updated_by, FND_GLOBAL.USER_ID)
130: ,nvl(p_delivery_leg_info.last_update_login, FND_GLOBAL.LOGIN_ID)
131: ,p_delivery_leg_info.program_application_id
132: ,p_delivery_leg_info.program_id
133: ,p_delivery_leg_info.program_update_date
134: ,p_delivery_leg_info.request_id

Line 227: l_freight_cost_info.created_by := FND_GLOBAL.USER_ID;

223: l_freight_cost_info.unit_amount := NULL;
224: l_freight_cost_info.currency_code := NULL;
225: l_freight_cost_info.delivery_leg_id := x_delivery_leg_id;
226: l_freight_cost_info.creation_date := SYSDATE;
227: l_freight_cost_info.created_by := FND_GLOBAL.USER_ID;
228: l_freight_cost_info.last_update_date := SYSDATE;
229: l_freight_cost_info.last_updated_by := FND_GLOBAL.USER_ID;
230: --
231: WSH_FREIGHT_COSTS_PVT.create_freight_cost(

Line 229: l_freight_cost_info.last_updated_by := FND_GLOBAL.USER_ID;

225: l_freight_cost_info.delivery_leg_id := x_delivery_leg_id;
226: l_freight_cost_info.creation_date := SYSDATE;
227: l_freight_cost_info.created_by := FND_GLOBAL.USER_ID;
228: l_freight_cost_info.last_update_date := SYSDATE;
229: l_freight_cost_info.last_updated_by := FND_GLOBAL.USER_ID;
230: --
231: WSH_FREIGHT_COSTS_PVT.create_freight_cost(
232: p_freight_cost_info => l_freight_cost_info,
233: x_rowid => l_row_id,

Line 350: ,Last_Updated_By = NVL(p_delivery_leg_info.Last_Updated_By, fnd_global.user_id)

346: ,Weight_Uom_Code = p_delivery_leg_info.Weight_Uom_Code
347: ,Volume = p_delivery_leg_info.Volume
348: ,Volume_Uom_Code = p_delivery_leg_info.Volume_Uom_Code
349: ,Last_Update_Date = NVL(p_delivery_leg_info.Last_Update_Date, sysdate)
350: ,Last_Updated_By = NVL(p_delivery_leg_info.Last_Updated_By, fnd_global.user_id)
351: ,Last_Update_Login = p_delivery_leg_info.Last_Update_Login
352: ,Program_Application_Id = p_delivery_leg_info.Program_Application_Id
353: ,Program_Id = p_delivery_leg_info.Program_Id
354: ,Program_Update_Date = p_delivery_leg_info.Program_Update_Date

Line 850: last_updated_by = FND_GLOBAL.USER_ID,

846: /* End of H integration - call Multi Leg FTE */
847: update wsh_trip_stops
848: set shipments_type_flag = lock_trip_rec.pu_stop_shipments_type_flag, -- J-IB-NPARIKH
849: last_update_date = SYSDATE,
850: last_updated_by = FND_GLOBAL.USER_ID,
851: last_update_login = FND_GLOBAL.LOGIN_ID
852: where stop_id = leg_rec.pick_up_stop_id;
853:
854: IF lock_trip_rec.pu_stop_shipments_type_flag = 'I'

Line 851: last_update_login = FND_GLOBAL.LOGIN_ID

847: update wsh_trip_stops
848: set shipments_type_flag = lock_trip_rec.pu_stop_shipments_type_flag, -- J-IB-NPARIKH
849: last_update_date = SYSDATE,
850: last_updated_by = FND_GLOBAL.USER_ID,
851: last_update_login = FND_GLOBAL.LOGIN_ID
852: where stop_id = leg_rec.pick_up_stop_id;
853:
854: IF lock_trip_rec.pu_stop_shipments_type_flag = 'I'
855: AND l_pu_stop_shipType_flag_orig = 'M'

Line 959: last_updated_by = FND_GLOBAL.USER_ID,

955: /* End of H integration - call Multi Leg FTE */
956: update wsh_trip_stops
957: set shipments_type_flag = lock_trip_rec.do_stop_shipments_type_flag, -- J-IB-NPARIKH
958: last_update_date = SYSDATE,
959: last_updated_by = FND_GLOBAL.USER_ID,
960: last_update_login = FND_GLOBAL.LOGIN_ID
961: where stop_id = leg_rec.drop_off_stop_id;
962:
963: IF lock_trip_rec.do_stop_shipments_type_flag = 'I'

Line 960: last_update_login = FND_GLOBAL.LOGIN_ID

956: update wsh_trip_stops
957: set shipments_type_flag = lock_trip_rec.do_stop_shipments_type_flag, -- J-IB-NPARIKH
958: last_update_date = SYSDATE,
959: last_updated_by = FND_GLOBAL.USER_ID,
960: last_update_login = FND_GLOBAL.LOGIN_ID
961: where stop_id = leg_rec.drop_off_stop_id;
962:
963: IF lock_trip_rec.do_stop_shipments_type_flag = 'I'
964: AND l_do_stop_shipType_flag_orig = 'M'

Line 1032: last_updated_by = FND_GLOBAL.USER_ID,

1028: --
1029: UPDATE WSH_TRIPS
1030: SET shipments_type_flag = lock_trip_rec.trip_shipments_type_flag,
1031: last_update_date = SYSDATE,
1032: last_updated_by = FND_GLOBAL.USER_ID,
1033: last_update_login = FND_GLOBAL.LOGIN_ID
1034: WHERE trip_id = leg_rec.trip_id;
1035:
1036: -- To keep the shipments_type_flag of all the

Line 1033: last_update_login = FND_GLOBAL.LOGIN_ID

1029: UPDATE WSH_TRIPS
1030: SET shipments_type_flag = lock_trip_rec.trip_shipments_type_flag,
1031: last_update_date = SYSDATE,
1032: last_updated_by = FND_GLOBAL.USER_ID,
1033: last_update_login = FND_GLOBAL.LOGIN_ID
1034: WHERE trip_id = leg_rec.trip_id;
1035:
1036: -- To keep the shipments_type_flag of all the
1037: -- stops in SYNC with the trip

Line 1041: last_updated_by = FND_GLOBAL.USER_ID,

1037: -- stops in SYNC with the trip
1038: UPDATE WSH_TRIP_STOPS
1039: SET shipments_type_flag = lock_trip_rec.trip_shipments_type_flag,
1040: last_update_date = SYSDATE,
1041: last_updated_by = FND_GLOBAL.USER_ID,
1042: last_update_login = FND_GLOBAL.LOGIN_ID
1043: WHERE trip_id = leg_rec.trip_id
1044: AND shipments_type_flag <> lock_trip_rec.trip_shipments_type_flag;
1045:

Line 1042: last_update_login = FND_GLOBAL.LOGIN_ID

1038: UPDATE WSH_TRIP_STOPS
1039: SET shipments_type_flag = lock_trip_rec.trip_shipments_type_flag,
1040: last_update_date = SYSDATE,
1041: last_updated_by = FND_GLOBAL.USER_ID,
1042: last_update_login = FND_GLOBAL.LOGIN_ID
1043: WHERE trip_id = leg_rec.trip_id
1044: AND shipments_type_flag <> lock_trip_rec.trip_shipments_type_flag;
1045:
1046: IF l_debug_on THEN