eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_DELIVERY_DETAILS_ACTIONS dependencies on FND_GLOBAL

Line 3149: last_updated_by = FND_GLOBAL.USER_ID,

3145: TMS_INTERFACE_FLAG = decode(l_tms_update, 'Y', l_new_interface_flag_tab(1), nvl(TMS_INTERFACE_FLAG, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)),
3146: TMS_VERSION_NUMBER = decode(l_tms_update, 'Y', l_tms_version_number, nvl(tms_version_number, 1)),
3147: -- End of OTM R12
3148: last_update_date = SYSDATE,
3149: last_updated_by = FND_GLOBAL.USER_ID,
3150: last_update_login = FND_GLOBAL.LOGIN_ID
3151: where delivery_id = l_del_id_for_container.delivery_id;
3152:
3153: -- OTM R12 : update delivery

Line 3150: last_update_login = FND_GLOBAL.LOGIN_ID

3146: TMS_VERSION_NUMBER = decode(l_tms_update, 'Y', l_tms_version_number, nvl(tms_version_number, 1)),
3147: -- End of OTM R12
3148: last_update_date = SYSDATE,
3149: last_updated_by = FND_GLOBAL.USER_ID,
3150: last_update_login = FND_GLOBAL.LOGIN_ID
3151: where delivery_id = l_del_id_for_container.delivery_id;
3152:
3153: -- OTM R12 : update delivery
3154: IF (l_gc3_is_installed = 'Y' AND l_tms_update = 'Y') THEN

Line 3223: last_updated_by = FND_GLOBAL.USER_ID,

3219: UPDATE wsh_delivery_assignments_v
3220: SET parent_delivery_detail_id = p_parent_detail_id,
3221: delivery_id = l_del_id_for_container.delivery_id,
3222: last_update_date = SYSDATE,
3223: last_updated_by = FND_GLOBAL.USER_ID,
3224: last_update_login = FND_GLOBAL.LOGIN_ID
3225: WHERE delivery_detail_id = p_detail_id;
3226:
3227: -- OTM R12 : assign delivery detail

Line 3224: last_update_login = FND_GLOBAL.LOGIN_ID

3220: SET parent_delivery_detail_id = p_parent_detail_id,
3221: delivery_id = l_del_id_for_container.delivery_id,
3222: last_update_date = SYSDATE,
3223: last_updated_by = FND_GLOBAL.USER_ID,
3224: last_update_login = FND_GLOBAL.LOGIN_ID
3225: WHERE delivery_detail_id = p_detail_id;
3226:
3227: -- OTM R12 : assign delivery detail
3228: IF (l_assign_update AND

Line 3333: last_updated_by = FND_GLOBAL.USER_ID,

3329:
3330: UPDATE wsh_delivery_assignments_v
3331: SET parent_delivery_detail_id = p_parent_detail_id,
3332: last_update_date = SYSDATE,
3333: last_updated_by = FND_GLOBAL.USER_ID,
3334: last_update_login = FND_GLOBAL.LOGIN_ID
3335: WHERE delivery_detail_id = p_detail_id;
3336:
3337: l_mdc_detail_tab(1) := p_detail_id;

Line 3334: last_update_login = FND_GLOBAL.LOGIN_ID

3330: UPDATE wsh_delivery_assignments_v
3331: SET parent_delivery_detail_id = p_parent_detail_id,
3332: last_update_date = SYSDATE,
3333: last_updated_by = FND_GLOBAL.USER_ID,
3334: last_update_login = FND_GLOBAL.LOGIN_ID
3335: WHERE delivery_detail_id = p_detail_id;
3336:
3337: l_mdc_detail_tab(1) := p_detail_id;
3338: WSH_DELIVERY_DETAILS_ACTIONS.Delete_Consol_Record(

Line 3481: last_updated_by = FND_GLOBAL.USER_ID,

3477: FORALL i in l_sync_tmp_recTbl.delivery_detail_id_tbl.first..l_sync_tmp_recTbl.delivery_detail_id_tbl.last
3478: UPDATE wsh_delivery_assignments_v
3479: SET delivery_id = l_del_id_FOR_detail.delivery_id,
3480: last_update_date = SYSDATE,
3481: last_updated_by = FND_GLOBAL.USER_ID,
3482: last_update_login = FND_GLOBAL.LOGIN_ID
3483: WHERE delivery_detail_id = l_sync_tmp_recTbl.delivery_detail_id_tbl(i);
3484:
3485: -- OTM R12 : assign delivery detail

Line 3482: last_update_login = FND_GLOBAL.LOGIN_ID

3478: UPDATE wsh_delivery_assignments_v
3479: SET delivery_id = l_del_id_FOR_detail.delivery_id,
3480: last_update_date = SYSDATE,
3481: last_updated_by = FND_GLOBAL.USER_ID,
3482: last_update_login = FND_GLOBAL.LOGIN_ID
3483: WHERE delivery_detail_id = l_sync_tmp_recTbl.delivery_detail_id_tbl(i);
3484:
3485: -- OTM R12 : assign delivery detail
3486: -- executed only once since it's for the same delivery

Line 3874: last_updated_by = FND_GLOBAL.USER_ID,

3870: --
3871: UPDATE wsh_delivery_assignments_v
3872: SET parent_delivery_detail_id = NULL,
3873: last_update_date = SYSDATE,
3874: last_updated_by = FND_GLOBAL.USER_ID,
3875: last_update_login = FND_GLOBAL.LOGIN_ID
3876: WHERE delivery_detail_id = p_detail_id;
3877: l_mdc_detail_tab(1) := p_detail_id;
3878: WSH_DELIVERY_DETAILS_ACTIONS.Create_Consol_Record(

Line 3875: last_update_login = FND_GLOBAL.LOGIN_ID

3871: UPDATE wsh_delivery_assignments_v
3872: SET parent_delivery_detail_id = NULL,
3873: last_update_date = SYSDATE,
3874: last_updated_by = FND_GLOBAL.USER_ID,
3875: last_update_login = FND_GLOBAL.LOGIN_ID
3876: WHERE delivery_detail_id = p_detail_id;
3877: l_mdc_detail_tab(1) := p_detail_id;
3878: WSH_DELIVERY_DETAILS_ACTIONS.Create_Consol_Record(
3879: p_detail_id_tab => l_mdc_detail_tab,

Line 4875: last_updated_by = FND_GLOBAL.USER_ID,

4871:
4872: UPDATE wsh_delivery_assignments
4873: SET delivery_id = p_delivery_id,
4874: last_update_date = SYSDATE,
4875: last_updated_by = FND_GLOBAL.USER_ID,
4876: last_update_login = FND_GLOBAL.LOGIN_ID
4877: WHERE delivery_detail_id = l_detail.delivery_detail_id
4878: AND (type IN ('S', 'O') OR type IS NULL);
4879:

Line 4876: last_update_login = FND_GLOBAL.LOGIN_ID

4872: UPDATE wsh_delivery_assignments
4873: SET delivery_id = p_delivery_id,
4874: last_update_date = SYSDATE,
4875: last_updated_by = FND_GLOBAL.USER_ID,
4876: last_update_login = FND_GLOBAL.LOGIN_ID
4877: WHERE delivery_detail_id = l_detail.delivery_detail_id
4878: AND (type IN ('S', 'O') OR type IS NULL);
4879:
4880: IF (SQL%NOTFOUND) THEN

Line 4946: last_updated_by = FND_GLOBAL.USER_ID,

4942:
4943: UPDATE wsh_new_deliveries
4944: SET freight_terms_code = x_dlvy_freight_terms_code,
4945: last_update_date = SYSDATE,
4946: last_updated_by = FND_GLOBAL.USER_ID,
4947: last_update_login = FND_GLOBAL.LOGIN_ID
4948: WHERE delivery_id = p_delivery_id;
4949: --
4950: IF (SQL%NOTFOUND)

Line 4947: last_update_login = FND_GLOBAL.LOGIN_ID

4943: UPDATE wsh_new_deliveries
4944: SET freight_terms_code = x_dlvy_freight_terms_code,
4945: last_update_date = SYSDATE,
4946: last_updated_by = FND_GLOBAL.USER_ID,
4947: last_update_login = FND_GLOBAL.LOGIN_ID
4948: WHERE delivery_id = p_delivery_id;
4949: --
4950: IF (SQL%NOTFOUND)
4951: THEN

Line 6205: last_updated_by = FND_GLOBAL.USER_ID,

6201: FORALL i in l_sync_tmp_recTbl.delivery_detail_id_tbl.first..l_sync_tmp_recTbl.delivery_detail_id_tbl.last
6202: UPDATE wsh_delivery_assignments_v
6203: SET delivery_id = l_del_id_for_container1.delivery_id,
6204: last_update_date = SYSDATE,
6205: last_updated_by = FND_GLOBAL.USER_ID,
6206: last_update_login = FND_GLOBAL.LOGIN_ID
6207: WHERE delivery_detail_id = l_sync_tmp_recTbl.delivery_detail_id_tbl(i);
6208:
6209: -- OTM R12 : assign delivery detail

Line 6206: last_update_login = FND_GLOBAL.LOGIN_ID

6202: UPDATE wsh_delivery_assignments_v
6203: SET delivery_id = l_del_id_for_container1.delivery_id,
6204: last_update_date = SYSDATE,
6205: last_updated_by = FND_GLOBAL.USER_ID,
6206: last_update_login = FND_GLOBAL.LOGIN_ID
6207: WHERE delivery_detail_id = l_sync_tmp_recTbl.delivery_detail_id_tbl(i);
6208:
6209: -- OTM R12 : assign delivery detail
6210: IF (l_assign_update AND

Line 6369: last_updated_by = FND_GLOBAL.USER_ID,

6365: FORALL i in l_sync_tmp_recTbl.delivery_detail_id_tbl.first..l_sync_tmp_recTbl.delivery_detail_id_tbl.last
6366: UPDATE wsh_delivery_assignments_v
6367: SET delivery_id = l_del_id_for_container2.delivery_id,
6368: last_update_date = SYSDATE,
6369: last_updated_by = FND_GLOBAL.USER_ID,
6370: last_update_login = FND_GLOBAL.LOGIN_ID
6371: WHERE delivery_detail_id = l_sync_tmp_recTbl.delivery_detail_id_tbl(i);
6372:
6373: -- OTM R12 : assign delivery detail

Line 6370: last_update_login = FND_GLOBAL.LOGIN_ID

6366: UPDATE wsh_delivery_assignments_v
6367: SET delivery_id = l_del_id_for_container2.delivery_id,
6368: last_update_date = SYSDATE,
6369: last_updated_by = FND_GLOBAL.USER_ID,
6370: last_update_login = FND_GLOBAL.LOGIN_ID
6371: WHERE delivery_detail_id = l_sync_tmp_recTbl.delivery_detail_id_tbl(i);
6372:
6373: -- OTM R12 : assign delivery detail
6374: IF (l_assign_update AND

Line 6479: last_updated_by = FND_GLOBAL.USER_ID,

6475: --
6476: UPDATE wsh_delivery_assignments_v
6477: SET parent_delivery_detail_id = p_detail_id2,
6478: last_update_date = SYSDATE,
6479: last_updated_by = FND_GLOBAL.USER_ID,
6480: last_update_login = FND_GLOBAL.LOGIN_ID
6481: WHERE delivery_detail_id = p_detail_id1;
6482: l_mdc_detail_tab(1) := p_detail_id1;
6483: WSH_DELIVERY_DETAILS_ACTIONS.Delete_Consol_Record(

Line 6480: last_update_login = FND_GLOBAL.LOGIN_ID

6476: UPDATE wsh_delivery_assignments_v
6477: SET parent_delivery_detail_id = p_detail_id2,
6478: last_update_date = SYSDATE,
6479: last_updated_by = FND_GLOBAL.USER_ID,
6480: last_update_login = FND_GLOBAL.LOGIN_ID
6481: WHERE delivery_detail_id = p_detail_id1;
6482: l_mdc_detail_tab(1) := p_detail_id1;
6483: WSH_DELIVERY_DETAILS_ACTIONS.Delete_Consol_Record(
6484: p_detail_id_tab => l_mdc_detail_tab,

Line 7157: last_updated_by = FND_GLOBAL.USER_ID,

7153: --
7154: UPDATE wsh_delivery_assignments_v
7155: SET delivery_id = l_null_delivery_id, --bugfix 3768823
7156: last_update_date = SYSDATE,
7157: last_updated_by = FND_GLOBAL.USER_ID,
7158: last_update_login = FND_GLOBAL.LOGIN_ID
7159: WHERE delivery_detail_id = l_dd_id(j);
7160:
7161: -- bug 6700792: OTM Dock Door Appt Sched Proj

Line 7158: last_update_login = FND_GLOBAL.LOGIN_ID

7154: UPDATE wsh_delivery_assignments_v
7155: SET delivery_id = l_null_delivery_id, --bugfix 3768823
7156: last_update_date = SYSDATE,
7157: last_updated_by = FND_GLOBAL.USER_ID,
7158: last_update_login = FND_GLOBAL.LOGIN_ID
7159: WHERE delivery_detail_id = l_dd_id(j);
7160:
7161: -- bug 6700792: OTM Dock Door Appt Sched Proj
7162: --Upadating the loading sequence of the delivery detail to NULL while unassigning from delivery

Line 7166: last_updated_by = FND_GLOBAL.USER_ID,

7162: --Upadating the loading sequence of the delivery detail to NULL while unassigning from delivery
7163: UPDATE wsh_delivery_details
7164: SET load_seq_number = NULL,
7165: last_update_date = SYSDATE,
7166: last_updated_by = FND_GLOBAL.USER_ID,
7167: last_update_login = FND_GLOBAL.LOGIN_ID
7168: WHERE delivery_detail_id = l_dd_id(j);
7169:
7170: IF (SQL%NOTFOUND) THEN

Line 7167: last_update_login = FND_GLOBAL.LOGIN_ID

7163: UPDATE wsh_delivery_details
7164: SET load_seq_number = NULL,
7165: last_update_date = SYSDATE,
7166: last_updated_by = FND_GLOBAL.USER_ID,
7167: last_update_login = FND_GLOBAL.LOGIN_ID
7168: WHERE delivery_detail_id = l_dd_id(j);
7169:
7170: IF (SQL%NOTFOUND) THEN
7171: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 7271: last_updated_by = FND_GLOBAL.USER_ID,

7267: deliver_to_location_id = NULL,
7268: -- tracking_number = NULL, Bug# 3632485
7269: line_direction = DECODE(line_direction,'IO','O',line_direction), -- J-IB-NPARIKH
7270: last_update_date = SYSDATE,
7271: last_updated_by = FND_GLOBAL.USER_ID,
7272: last_update_login = FND_GLOBAL.LOGIN_ID
7273: WHERE delivery_detail_id = l_dd_id(j);
7274: IF (SQL%NOTFOUND) THEN
7275: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 7272: last_update_login = FND_GLOBAL.LOGIN_ID

7268: -- tracking_number = NULL, Bug# 3632485
7269: line_direction = DECODE(line_direction,'IO','O',line_direction), -- J-IB-NPARIKH
7270: last_update_date = SYSDATE,
7271: last_updated_by = FND_GLOBAL.USER_ID,
7272: last_update_login = FND_GLOBAL.LOGIN_ID
7273: WHERE delivery_detail_id = l_dd_id(j);
7274: IF (SQL%NOTFOUND) THEN
7275: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
7276: RAISE NO_DATA_FOUND;

Line 7302: last_updated_by = FND_GLOBAL.USER_ID,

7298: 'X'), -- J-IB-NPARIKH
7299: ignore_for_planning = 'Y', -- J-IB-NPARIKH
7300: --wv_frozen_flag = DECODE(l_ib_upd_flag,'Y','N',wv_frozen_flag), -- J-IB-NPARIKH
7301: last_update_date = SYSDATE,
7302: last_updated_by = FND_GLOBAL.USER_ID,
7303: last_update_login = FND_GLOBAL.LOGIN_ID
7304: WHERE delivery_detail_id = l_dd_id(j)
7305: returning released_status into l_rel_status;
7306: --bugfix 4530813

Line 7303: last_update_login = FND_GLOBAL.LOGIN_ID

7299: ignore_for_planning = 'Y', -- J-IB-NPARIKH
7300: --wv_frozen_flag = DECODE(l_ib_upd_flag,'Y','N',wv_frozen_flag), -- J-IB-NPARIKH
7301: last_update_date = SYSDATE,
7302: last_updated_by = FND_GLOBAL.USER_ID,
7303: last_update_login = FND_GLOBAL.LOGIN_ID
7304: WHERE delivery_detail_id = l_dd_id(j)
7305: returning released_status into l_rel_status;
7306: --bugfix 4530813
7307: IF (SQL%NOTFOUND) THEN

Line 7513: last_updated_by = FND_GLOBAL.USER_ID,

7509: --Upadating the loading sequence of the delivery detail to NULL while unassigning from delivery
7510: UPDATE wsh_delivery_details
7511: SET load_seq_number = NULL,
7512: last_update_date = SYSDATE,
7513: last_updated_by = FND_GLOBAL.USER_ID,
7514: last_update_login = FND_GLOBAL.LOGIN_ID
7515: WHERE delivery_detail_id = p_detail_id;
7516:
7517: IF (SQL%NOTFOUND) THEN

Line 7514: last_update_login = FND_GLOBAL.LOGIN_ID

7510: UPDATE wsh_delivery_details
7511: SET load_seq_number = NULL,
7512: last_update_date = SYSDATE,
7513: last_updated_by = FND_GLOBAL.USER_ID,
7514: last_update_login = FND_GLOBAL.LOGIN_ID
7515: WHERE delivery_detail_id = p_detail_id;
7516:
7517: IF (SQL%NOTFOUND) THEN
7518: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 9588: l_delivery_details_info.last_updated_by := FND_GLOBAL.USER_ID;

9584: l_delivery_details_info.serial_number := FND_API.G_MISS_CHAR;
9585: l_delivery_details_info.to_serial_number := FND_API.G_MISS_CHAR;
9586: l_delivery_details_info.transaction_temp_id := FND_API.G_MISS_NUM;
9587: l_delivery_details_info.last_update_date := SYSDATE;
9588: l_delivery_details_info.last_updated_by := FND_GLOBAL.USER_ID;
9589: l_delivery_details_info.last_update_login := FND_GLOBAL.LOGIN_ID;
9590: -- Bug 2419301
9591: l_delivery_details_info.oe_interfaced_flag := p_old_delivery_detail_rec.oe_interfaced_flag;
9592: --

Line 9589: l_delivery_details_info.last_update_login := FND_GLOBAL.LOGIN_ID;

9585: l_delivery_details_info.to_serial_number := FND_API.G_MISS_CHAR;
9586: l_delivery_details_info.transaction_temp_id := FND_API.G_MISS_NUM;
9587: l_delivery_details_info.last_update_date := SYSDATE;
9588: l_delivery_details_info.last_updated_by := FND_GLOBAL.USER_ID;
9589: l_delivery_details_info.last_update_login := FND_GLOBAL.LOGIN_ID;
9590: -- Bug 2419301
9591: l_delivery_details_info.oe_interfaced_flag := p_old_delivery_detail_rec.oe_interfaced_flag;
9592: --
9593: IF l_debug_on THEN

Line 9937: last_updated_by = FND_GLOBAL.USER_ID,

9933: net_weight = net_weight - l_total_net_wt,
9934: volume = volume - l_total_vol,
9935: -- End J: W/V Changes
9936: last_update_date = SYSDATE,
9937: last_updated_by = FND_GLOBAL.USER_ID,
9938: last_update_login = FND_GLOBAL.LOGIN_ID
9939: WHERE delivery_detail_id = p_old_delivery_detail_rec.delivery_detail_id;
9940:
9941: /* call the wv util to calculate the wv for the original detail too */

Line 9938: last_update_login = FND_GLOBAL.LOGIN_ID

9934: volume = volume - l_total_vol,
9935: -- End J: W/V Changes
9936: last_update_date = SYSDATE,
9937: last_updated_by = FND_GLOBAL.USER_ID,
9938: last_update_login = FND_GLOBAL.LOGIN_ID
9939: WHERE delivery_detail_id = p_old_delivery_detail_rec.delivery_detail_id;
9940:
9941: /* call the wv util to calculate the wv for the original detail too */
9942: --

Line 11124: l_delivery_details_info.last_updated_by := FND_GLOBAL.USER_ID;

11120: l_delivery_details_info.serial_number := FND_API.G_MISS_CHAR;
11121: l_delivery_details_info.to_serial_number := FND_API.G_MISS_CHAR;
11122: l_delivery_details_info.transaction_temp_id := FND_API.G_MISS_NUM;
11123: l_delivery_details_info.last_update_date := SYSDATE;
11124: l_delivery_details_info.last_updated_by := FND_GLOBAL.USER_ID;
11125: l_delivery_details_info.last_update_login := FND_GLOBAL.LOGIN_ID;
11126: -- Bug 2419301
11127: l_delivery_details_info.oe_interfaced_flag := p_old_delivery_detail_rec.oe_interfaced_flag;
11128: l_delivery_details_info.consignee_flag := p_old_delivery_detail_rec.consignee_flag; --RTV changes

Line 11125: l_delivery_details_info.last_update_login := FND_GLOBAL.LOGIN_ID;

11121: l_delivery_details_info.to_serial_number := FND_API.G_MISS_CHAR;
11122: l_delivery_details_info.transaction_temp_id := FND_API.G_MISS_NUM;
11123: l_delivery_details_info.last_update_date := SYSDATE;
11124: l_delivery_details_info.last_updated_by := FND_GLOBAL.USER_ID;
11125: l_delivery_details_info.last_update_login := FND_GLOBAL.LOGIN_ID;
11126: -- Bug 2419301
11127: l_delivery_details_info.oe_interfaced_flag := p_old_delivery_detail_rec.oe_interfaced_flag;
11128: l_delivery_details_info.consignee_flag := p_old_delivery_detail_rec.consignee_flag; --RTV changes
11129: l_new_delivery_detail_id := NULL;

Line 11350: last_updated_by = FND_GLOBAL.USER_ID,

11346: net_weight = net_weight - l_total_net_wt,
11347: volume = volume - l_total_vol,
11348: -- End J: W/V Changes
11349: last_update_date = SYSDATE,
11350: last_updated_by = FND_GLOBAL.USER_ID,
11351: last_update_login = FND_GLOBAL.LOGIN_ID
11352: WHERE delivery_detail_id = p_old_delivery_detail_rec.delivery_detail_id;
11353:
11354: -- DBI Project

Line 11351: last_update_login = FND_GLOBAL.LOGIN_ID

11347: volume = volume - l_total_vol,
11348: -- End J: W/V Changes
11349: last_update_date = SYSDATE,
11350: last_updated_by = FND_GLOBAL.USER_ID,
11351: last_update_login = FND_GLOBAL.LOGIN_ID
11352: WHERE delivery_detail_id = p_old_delivery_detail_rec.delivery_detail_id;
11353:
11354: -- DBI Project
11355: -- Update of wsh_delivery_details where requested_quantity/released_status

Line 11746: last_updated_by = FND_GLOBAL.USER_ID,

11742: UPDATE mtl_serial_numbers_temp
11743: SET to_serial_number = l_old_to_sn,
11744: serial_prefix = TO_CHAR(l_range_count - l_qty_to_split),
11745: last_update_date = SYSDATE,
11746: last_updated_by = FND_GLOBAL.USER_ID,
11747: last_update_login = FND_GLOBAL.LOGIN_ID
11748: WHERE rowid = c.rowid;
11749: END IF;
11750: IF l_debug_on THEN

Line 11747: last_update_login = FND_GLOBAL.LOGIN_ID

11743: SET to_serial_number = l_old_to_sn,
11744: serial_prefix = TO_CHAR(l_range_count - l_qty_to_split),
11745: last_update_date = SYSDATE,
11746: last_updated_by = FND_GLOBAL.USER_ID,
11747: last_update_login = FND_GLOBAL.LOGIN_ID
11748: WHERE rowid = c.rowid;
11749: END IF;
11750: IF l_debug_on THEN
11751: WSH_DEBUG_SV.log(l_module_name,

Line 11788: FND_GLOBAL.USER_ID,

11784: DFF_UPDATED_FLAG)
11785: VALUES
11786: (l_transaction_temp_id,
11787: SYSDATE,
11788: FND_GLOBAL.USER_ID,
11789: FND_GLOBAL.LOGIN_ID,
11790: SYSDATE,
11791: FND_GLOBAL.USER_ID,
11792: l_new_sn,

Line 11789: FND_GLOBAL.LOGIN_ID,

11785: VALUES
11786: (l_transaction_temp_id,
11787: SYSDATE,
11788: FND_GLOBAL.USER_ID,
11789: FND_GLOBAL.LOGIN_ID,
11790: SYSDATE,
11791: FND_GLOBAL.USER_ID,
11792: l_new_sn,
11793: l_new_to_sn,

Line 11791: FND_GLOBAL.USER_ID,

11787: SYSDATE,
11788: FND_GLOBAL.USER_ID,
11789: FND_GLOBAL.LOGIN_ID,
11790: SYSDATE,
11791: FND_GLOBAL.USER_ID,
11792: l_new_sn,
11793: l_new_to_sn,
11794: TO_CHAR(l_qty_to_split),
11795: c.attribute_category,

Line 11907: last_updated_by = FND_GLOBAL.USER_ID,

11903: -- we need to assign the full serial number range to the new line
11904: UPDATE mtl_serial_numbers_temp
11905: SET transaction_temp_id = l_transaction_temp_id,
11906: last_update_date = SYSDATE,
11907: last_updated_by = FND_GLOBAL.USER_ID,
11908: last_update_login = FND_GLOBAL.LOGIN_ID
11909: WHERE rowid = c.rowid;
11910:
11911: --Bug 2740681

Line 11908: last_update_login = FND_GLOBAL.LOGIN_ID

11904: UPDATE mtl_serial_numbers_temp
11905: SET transaction_temp_id = l_transaction_temp_id,
11906: last_update_date = SYSDATE,
11907: last_updated_by = FND_GLOBAL.USER_ID,
11908: last_update_login = FND_GLOBAL.LOGIN_ID
11909: WHERE rowid = c.rowid;
11910:
11911: --Bug 2740681
11912: IF l_debug_on THEN

Line 12723: l_user_id := FND_GLOBAL.user_id;

12719: --
12720:
12721: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
12722: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
12723: l_user_id := FND_GLOBAL.user_id;
12724: l_login_id := FND_GLOBAL.login_id;
12725:
12726: FOR i IN 1..p_Cons_Source_Line_Rec_Tab.count --{ Looping thru' the input params
12727: LOOP

Line 12724: l_login_id := FND_GLOBAL.login_id;

12720:
12721: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
12722: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
12723: l_user_id := FND_GLOBAL.user_id;
12724: l_login_id := FND_GLOBAL.login_id;
12725:
12726: FOR i IN 1..p_Cons_Source_Line_Rec_Tab.count --{ Looping thru' the input params
12727: LOOP
12728: --

Line 14060: FND_GLOBAL.USER_ID,

14056: l_consol_delivery_id_tab(i),
14057: l_detail_id_tab(i),
14058: NULL,
14059: SYSDATE,
14060: FND_GLOBAL.USER_ID,
14061: SYSDATE,
14062: FND_GLOBAL.USER_ID,
14063: FND_GLOBAL.USER_ID,
14064: NULL,

Line 14062: FND_GLOBAL.USER_ID,

14058: NULL,
14059: SYSDATE,
14060: FND_GLOBAL.USER_ID,
14061: SYSDATE,
14062: FND_GLOBAL.USER_ID,
14063: FND_GLOBAL.USER_ID,
14064: NULL,
14065: NULL,
14066: NULL,

Line 14063: FND_GLOBAL.USER_ID,

14059: SYSDATE,
14060: FND_GLOBAL.USER_ID,
14061: SYSDATE,
14062: FND_GLOBAL.USER_ID,
14063: FND_GLOBAL.USER_ID,
14064: NULL,
14065: NULL,
14066: NULL,
14067: NULL,