DBA Data[Home] [Help]

APPS.FTE_DELIVERY_LEGS_PVT dependencies on FND_GLOBAL

Line 1219: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

1215: --{
1216: UPDATE wsh_delivery_legs
1217: SET fte_trip_id = l_fte_trip_id,
1218: LAST_UPDATE_DATE = SYSDATE,
1219: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1220: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
1221: WHERE delivery_leg_id = l_delivery_leg_id;
1222: --
1223: --

Line 1220: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

1216: UPDATE wsh_delivery_legs
1217: SET fte_trip_id = l_fte_trip_id,
1218: LAST_UPDATE_DATE = SYSDATE,
1219: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1220: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
1221: WHERE delivery_leg_id = l_delivery_leg_id;
1222: --
1223: --
1224: IF SQL%NOTFOUND

Line 1263: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

1259: --{
1260: UPDATE wsh_delivery_legs
1261: SET reprice_required = l_reprice_required,
1262: LAST_UPDATE_DATE = SYSDATE,
1263: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1264: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
1265: WHERE delivery_leg_id IN
1266: ( SELECT delivery_leg_id
1267: FROM wsh_trip_stops wts,

Line 1264: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

1260: UPDATE wsh_delivery_legs
1261: SET reprice_required = l_reprice_required,
1262: LAST_UPDATE_DATE = SYSDATE,
1263: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1264: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
1265: WHERE delivery_leg_id IN
1266: ( SELECT delivery_leg_id
1267: FROM wsh_trip_stops wts,
1268: wsh_delivery_legs wdl