DBA Data[Home] [Help]

APPS.WSH_TRIP_STOPS_ACTIONS dependencies on FND_GLOBAL

Line 1824: last_updated_by = FND_GLOBAL.USER_ID,

1820: carrier_id = p_in_rec1.carrier_id,
1821: service_level = p_in_rec1.service_level,
1822: mode_of_transport = p_in_rec1.mode_of_transport,
1823: last_update_date = SYSDATE,
1824: last_updated_by = FND_GLOBAL.USER_ID,
1825: last_update_login = FND_GLOBAL.LOGIN_ID
1826: WHERE delivery_id = l_dlvy_id_tbl(i)
1827: AND NVL(ship_method_code,' ') <> p_in_rec1.ship_method_code;
1828: --}

Line 1825: last_update_login = FND_GLOBAL.LOGIN_ID

1821: service_level = p_in_rec1.service_level,
1822: mode_of_transport = p_in_rec1.mode_of_transport,
1823: last_update_date = SYSDATE,
1824: last_updated_by = FND_GLOBAL.USER_ID,
1825: last_update_login = FND_GLOBAL.LOGIN_ID
1826: WHERE delivery_id = l_dlvy_id_tbl(i)
1827: AND NVL(ship_method_code,' ') <> p_in_rec1.ship_method_code;
1828: --}
1829: END IF;

Line 1885: last_updated_by = FND_GLOBAL.USER_ID,

1881: actual_arrival_date = NVL(actual_arrival_date,NVL(p_in_rec.actual_date,SYSDATE)), -- Bug 3901377
1882: departure_seal_code = NVL(departure_seal_code,p_in_rec1.trip_seal_code),
1883: tms_interface_flag = l_tms_interface_flag, --OTM R12 Org-Specific.
1884: last_update_date = sysdate,
1885: last_updated_by = FND_GLOBAL.USER_ID,
1886: last_update_login = FND_GLOBAL.LOGIN_ID
1887: WHERE stop_id IN (p_in_rec.stop_id,
1888: p_in_rec1.linked_stop_id) --wr
1889: RETURNING stop_id BULK COLLECT INTO l_stop_tab; -- Added for DBI Project

Line 1886: last_update_login = FND_GLOBAL.LOGIN_ID

1882: departure_seal_code = NVL(departure_seal_code,p_in_rec1.trip_seal_code),
1883: tms_interface_flag = l_tms_interface_flag, --OTM R12 Org-Specific.
1884: last_update_date = sysdate,
1885: last_updated_by = FND_GLOBAL.USER_ID,
1886: last_update_login = FND_GLOBAL.LOGIN_ID
1887: WHERE stop_id IN (p_in_rec.stop_id,
1888: p_in_rec1.linked_stop_id) --wr
1889: RETURNING stop_id BULK COLLECT INTO l_stop_tab; -- Added for DBI Project
1890: --

Line 2488: last_updated_by = FND_GLOBAL.USER_ID,

2484: actual_arrival_date = NULL, -- Bug 3901377
2485: --actual_departure_date = nvl(p_in_rec.actual_date, SYSDATE),
2486: --departure_seal_code = NVL(p_in_rec1.trip_seal_code, departure_seal_code),
2487: last_update_date = sysdate,
2488: last_updated_by = FND_GLOBAL.USER_ID,
2489: last_update_login = FND_GLOBAL.LOGIN_ID
2490: WHERE stop_id = p_in_rec.stop_id
2491: RETURNING stop_id BULK COLLECT INTO l_stop_tab; -- Added for DBI Project;
2492:

Line 2489: last_update_login = FND_GLOBAL.LOGIN_ID

2485: --actual_departure_date = nvl(p_in_rec.actual_date, SYSDATE),
2486: --departure_seal_code = NVL(p_in_rec1.trip_seal_code, departure_seal_code),
2487: last_update_date = sysdate,
2488: last_updated_by = FND_GLOBAL.USER_ID,
2489: last_update_login = FND_GLOBAL.LOGIN_ID
2490: WHERE stop_id = p_in_rec.stop_id
2491: RETURNING stop_id BULK COLLECT INTO l_stop_tab; -- Added for DBI Project;
2492:
2493: --