DBA Data[Home] [Help]

APPS.WSH_DELIVERY_LEGS_ACTIONS dependencies on FND_GLOBAL

Line 721: p_logging_entity_id => FND_GLOBAL.USER_ID,

717: x_exception_id => l_dummy_exception_id ,
718: p_logged_at_location_id => l_pickup_location_id,
719: p_exception_location_id => l_pickup_location_id,
720: p_logging_entity => 'SHIPPER',
721: p_logging_entity_id => FND_GLOBAL.USER_ID,
722: p_exception_name => l_exception_name,
723: p_message => l_msg,
724: p_trip_id => p_trip_id
725: );

Line 1102: last_updated_by = FND_GLOBAL.USER_ID, -- J-IB-NPARIKH

1098: set planned_departure_date=least(nvl(l_pickup_date,sysdate),planned_departure_date),
1099: planned_arrival_date=least(nvl(l_pickup_date,sysdate),planned_arrival_date),
1100: shipments_type_flag = l_stop_shipments_type_flag , -- J-IB-NPARIKH
1101: last_update_date = SYSDATE, -- J-IB-NPARIKH
1102: last_updated_by = FND_GLOBAL.USER_ID, -- J-IB-NPARIKH
1103: last_update_login = FND_GLOBAL.LOGIN_ID -- J-IB-NPARIKH
1104: where stop_id=l_pickup_stop_id;
1105:
1106: --

Line 1103: last_update_login = FND_GLOBAL.LOGIN_ID -- J-IB-NPARIKH

1099: planned_arrival_date=least(nvl(l_pickup_date,sysdate),planned_arrival_date),
1100: shipments_type_flag = l_stop_shipments_type_flag , -- J-IB-NPARIKH
1101: last_update_date = SYSDATE, -- J-IB-NPARIKH
1102: last_updated_by = FND_GLOBAL.USER_ID, -- J-IB-NPARIKH
1103: last_update_login = FND_GLOBAL.LOGIN_ID -- J-IB-NPARIKH
1104: where stop_id=l_pickup_stop_id;
1105:
1106: --
1107: -- DBI Project

Line 1522: last_updated_by = FND_GLOBAL.USER_ID,

1518: /* End of H integration - call Multi Leg FTE */
1519: update wsh_trip_stops
1520: set shipments_type_flag = l_stop_shipments_type_flag , -- J-IB-NPARIKH
1521: last_update_date = SYSDATE,
1522: last_updated_by = FND_GLOBAL.USER_ID,
1523: last_update_login = FND_GLOBAL.LOGIN_ID
1524: where stop_id=l_dropoff_stop_id;
1525: END IF;
1526:

Line 1523: last_update_login = FND_GLOBAL.LOGIN_ID

1519: update wsh_trip_stops
1520: set shipments_type_flag = l_stop_shipments_type_flag , -- J-IB-NPARIKH
1521: last_update_date = SYSDATE,
1522: last_updated_by = FND_GLOBAL.USER_ID,
1523: last_update_login = FND_GLOBAL.LOGIN_ID
1524: where stop_id=l_dropoff_stop_id;
1525: END IF;
1526:
1527: END IF;

Line 1796: last_updated_by = FND_GLOBAL.USER_ID,

1792: update wsh_trip_stops
1793: set planned_departure_date=p_pickup_dep_date,
1794: planned_arrival_date=p_pickup_arr_date,
1795: last_update_date = SYSDATE,
1796: last_updated_by = FND_GLOBAL.USER_ID,
1797: last_update_login = FND_GLOBAL.LOGIN_ID
1798: where stop_id=p_pickup_stop_id;
1799:
1800: --

Line 1797: last_update_login = FND_GLOBAL.LOGIN_ID

1793: set planned_departure_date=p_pickup_dep_date,
1794: planned_arrival_date=p_pickup_arr_date,
1795: last_update_date = SYSDATE,
1796: last_updated_by = FND_GLOBAL.USER_ID,
1797: last_update_login = FND_GLOBAL.LOGIN_ID
1798: where stop_id=p_pickup_stop_id;
1799:
1800: --
1801: -- DBI Project

Line 1873: last_updated_by = FND_GLOBAL.USER_ID,

1869: update wsh_trip_stops
1870: set planned_departure_date=p_dropoff_dep_date,
1871: planned_arrival_date=p_dropoff_arr_date,
1872: last_update_date = SYSDATE,
1873: last_updated_by = FND_GLOBAL.USER_ID,
1874: last_update_login = FND_GLOBAL.LOGIN_ID
1875: where stop_id=p_dropoff_stop_id;
1876:
1877: --

Line 1874: last_update_login = FND_GLOBAL.LOGIN_ID

1870: set planned_departure_date=p_dropoff_dep_date,
1871: planned_arrival_date=p_dropoff_arr_date,
1872: last_update_date = SYSDATE,
1873: last_updated_by = FND_GLOBAL.USER_ID,
1874: last_update_login = FND_GLOBAL.LOGIN_ID
1875: where stop_id=p_dropoff_stop_id;
1876:
1877: --
1878: -- DBI Project

Line 2090: last_updated_by = FND_GLOBAL.USER_ID,

2086: /* End of H integration - call Multi Leg FTE */
2087: update wsh_trip_stops
2088: set shipments_type_flag = l_pu_stop_shipments_type_flag, -- J-IB-NPARIKH
2089: last_update_date = SYSDATE,
2090: last_updated_by = FND_GLOBAL.USER_ID,
2091: last_update_login = FND_GLOBAL.LOGIN_ID
2092: where stop_id=l_pickup_stop_id;
2093: --}
2094: END IF;

Line 2091: last_update_login = FND_GLOBAL.LOGIN_ID

2087: update wsh_trip_stops
2088: set shipments_type_flag = l_pu_stop_shipments_type_flag, -- J-IB-NPARIKH
2089: last_update_date = SYSDATE,
2090: last_updated_by = FND_GLOBAL.USER_ID,
2091: last_update_login = FND_GLOBAL.LOGIN_ID
2092: where stop_id=l_pickup_stop_id;
2093: --}
2094: END IF;
2095: --

Line 2174: last_updated_by = FND_GLOBAL.USER_ID,

2170: /* End of H integration - call Multi Leg FTE */
2171: update wsh_trip_stops
2172: set shipments_type_flag = l_do_stop_shipments_type_flag, -- J-IB-NPARIKH
2173: last_update_date = SYSDATE,
2174: last_updated_by = FND_GLOBAL.USER_ID,
2175: last_update_login = FND_GLOBAL.LOGIN_ID
2176: where stop_id=l_dropoff_stop_id;
2177: --}
2178: END IF;

Line 2175: last_update_login = FND_GLOBAL.LOGIN_ID

2171: update wsh_trip_stops
2172: set shipments_type_flag = l_do_stop_shipments_type_flag, -- J-IB-NPARIKH
2173: last_update_date = SYSDATE,
2174: last_updated_by = FND_GLOBAL.USER_ID,
2175: last_update_login = FND_GLOBAL.LOGIN_ID
2176: where stop_id=l_dropoff_stop_id;
2177: --}
2178: END IF;
2179: --

Line 2234: last_updated_by = FND_GLOBAL.USER_ID,

2230: THEN
2231: UPDATE WSH_TRIPS
2232: SET shipments_type_flag = l_trip_shipments_type_flag_new, -- 'M',
2233: last_update_date = SYSDATE,
2234: last_updated_by = FND_GLOBAL.USER_ID,
2235: last_update_login = FND_GLOBAL.LOGIN_ID
2236: WHERE trip_id = p_trip_id;
2237:
2238: IF (l_trip_shipments_type_flag_new <> 'M') THEN

Line 2235: last_update_login = FND_GLOBAL.LOGIN_ID

2231: UPDATE WSH_TRIPS
2232: SET shipments_type_flag = l_trip_shipments_type_flag_new, -- 'M',
2233: last_update_date = SYSDATE,
2234: last_updated_by = FND_GLOBAL.USER_ID,
2235: last_update_login = FND_GLOBAL.LOGIN_ID
2236: WHERE trip_id = p_trip_id;
2237:
2238: IF (l_trip_shipments_type_flag_new <> 'M') THEN
2239:

Line 2243: last_updated_by = FND_GLOBAL.USER_ID,

2239:
2240: UPDATE WSH_TRIP_STOPS
2241: SET shipments_type_flag = l_trip_shipments_type_flag_new,
2242: last_update_date = SYSDATE,
2243: last_updated_by = FND_GLOBAL.USER_ID,
2244: last_update_login = FND_GLOBAL.LOGIN_ID
2245: WHERE trip_id = p_trip_id
2246: and shipments_type_flag <> l_trip_shipments_type_flag_new;
2247:

Line 2244: last_update_login = FND_GLOBAL.LOGIN_ID

2240: UPDATE WSH_TRIP_STOPS
2241: SET shipments_type_flag = l_trip_shipments_type_flag_new,
2242: last_update_date = SYSDATE,
2243: last_updated_by = FND_GLOBAL.USER_ID,
2244: last_update_login = FND_GLOBAL.LOGIN_ID
2245: WHERE trip_id = p_trip_id
2246: and shipments_type_flag <> l_trip_shipments_type_flag_new;
2247:
2248: IF l_debug_on THEN

Line 3225: last_updated_by = FND_GLOBAL.USER_ID,

3221:
3222: UPDATE wsh_new_deliveries
3223: SET loading_sequence = NULL,
3224: last_update_date = SYSDATE,
3225: last_updated_by = FND_GLOBAL.USER_ID,
3226: last_update_login = FND_GLOBAL.LOGIN_ID
3227: WHERE delivery_id = p_del_rows(i);
3228:
3229: FORALL i in l_del_det_tab.FIRST..l_del_det_tab.LAST

Line 3226: last_update_login = FND_GLOBAL.LOGIN_ID

3222: UPDATE wsh_new_deliveries
3223: SET loading_sequence = NULL,
3224: last_update_date = SYSDATE,
3225: last_updated_by = FND_GLOBAL.USER_ID,
3226: last_update_login = FND_GLOBAL.LOGIN_ID
3227: WHERE delivery_id = p_del_rows(i);
3228:
3229: FORALL i in l_del_det_tab.FIRST..l_del_det_tab.LAST
3230: UPDATE wsh_delivery_details

Line 3233: last_updated_by = FND_GLOBAL.USER_ID,

3229: FORALL i in l_del_det_tab.FIRST..l_del_det_tab.LAST
3230: UPDATE wsh_delivery_details
3231: SET load_seq_number = NULL,
3232: last_update_date = SYSDATE,
3233: last_updated_by = FND_GLOBAL.USER_ID,
3234: last_update_login = FND_GLOBAL.LOGIN_ID
3235: WHERE delivery_detail_id = l_del_det_tab(i);
3236:
3237: END IF;

Line 3234: last_update_login = FND_GLOBAL.LOGIN_ID

3230: UPDATE wsh_delivery_details
3231: SET load_seq_number = NULL,
3232: last_update_date = SYSDATE,
3233: last_updated_by = FND_GLOBAL.USER_ID,
3234: last_update_login = FND_GLOBAL.LOGIN_ID
3235: WHERE delivery_detail_id = l_del_det_tab(i);
3236:
3237: END IF;
3238: