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 3004: last_updated_by = FND_GLOBAL.USER_ID,

3000: 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)),
3001: TMS_VERSION_NUMBER = decode(l_tms_update, 'Y', l_tms_version_number, nvl(tms_version_number, 1)),
3002: -- End of OTM R12
3003: last_update_date = SYSDATE,
3004: last_updated_by = FND_GLOBAL.USER_ID,
3005: last_update_login = FND_GLOBAL.LOGIN_ID
3006: where delivery_id = l_del_id_for_container.delivery_id;
3007:
3008: -- OTM R12 : update delivery

Line 3005: last_update_login = FND_GLOBAL.LOGIN_ID

3001: TMS_VERSION_NUMBER = decode(l_tms_update, 'Y', l_tms_version_number, nvl(tms_version_number, 1)),
3002: -- End of OTM R12
3003: last_update_date = SYSDATE,
3004: last_updated_by = FND_GLOBAL.USER_ID,
3005: last_update_login = FND_GLOBAL.LOGIN_ID
3006: where delivery_id = l_del_id_for_container.delivery_id;
3007:
3008: -- OTM R12 : update delivery
3009: IF (l_gc3_is_installed = 'Y' AND l_tms_update = 'Y') THEN

Line 3078: last_updated_by = FND_GLOBAL.USER_ID,

3074: UPDATE wsh_delivery_assignments_v
3075: SET parent_delivery_detail_id = p_parent_detail_id,
3076: delivery_id = l_del_id_for_container.delivery_id,
3077: last_update_date = SYSDATE,
3078: last_updated_by = FND_GLOBAL.USER_ID,
3079: last_update_login = FND_GLOBAL.LOGIN_ID
3080: WHERE delivery_detail_id = p_detail_id;
3081:
3082: -- OTM R12 : assign delivery detail

Line 3079: last_update_login = FND_GLOBAL.LOGIN_ID

3075: SET parent_delivery_detail_id = p_parent_detail_id,
3076: delivery_id = l_del_id_for_container.delivery_id,
3077: last_update_date = SYSDATE,
3078: last_updated_by = FND_GLOBAL.USER_ID,
3079: last_update_login = FND_GLOBAL.LOGIN_ID
3080: WHERE delivery_detail_id = p_detail_id;
3081:
3082: -- OTM R12 : assign delivery detail
3083: IF (l_assign_update AND

Line 3188: last_updated_by = FND_GLOBAL.USER_ID,

3184:
3185: UPDATE wsh_delivery_assignments_v
3186: SET parent_delivery_detail_id = p_parent_detail_id,
3187: last_update_date = SYSDATE,
3188: last_updated_by = FND_GLOBAL.USER_ID,
3189: last_update_login = FND_GLOBAL.LOGIN_ID
3190: WHERE delivery_detail_id = p_detail_id;
3191:
3192: l_mdc_detail_tab(1) := p_detail_id;

Line 3189: last_update_login = FND_GLOBAL.LOGIN_ID

3185: UPDATE wsh_delivery_assignments_v
3186: SET parent_delivery_detail_id = p_parent_detail_id,
3187: last_update_date = SYSDATE,
3188: last_updated_by = FND_GLOBAL.USER_ID,
3189: last_update_login = FND_GLOBAL.LOGIN_ID
3190: WHERE delivery_detail_id = p_detail_id;
3191:
3192: l_mdc_detail_tab(1) := p_detail_id;
3193: WSH_DELIVERY_DETAILS_ACTIONS.Delete_Consol_Record(

Line 3336: last_updated_by = FND_GLOBAL.USER_ID,

3332: FORALL i in l_sync_tmp_recTbl.delivery_detail_id_tbl.first..l_sync_tmp_recTbl.delivery_detail_id_tbl.last
3333: UPDATE wsh_delivery_assignments_v
3334: SET delivery_id = l_del_id_FOR_detail.delivery_id,
3335: last_update_date = SYSDATE,
3336: last_updated_by = FND_GLOBAL.USER_ID,
3337: last_update_login = FND_GLOBAL.LOGIN_ID
3338: WHERE delivery_detail_id = l_sync_tmp_recTbl.delivery_detail_id_tbl(i);
3339:
3340: -- OTM R12 : assign delivery detail

Line 3337: last_update_login = FND_GLOBAL.LOGIN_ID

3333: UPDATE wsh_delivery_assignments_v
3334: SET delivery_id = l_del_id_FOR_detail.delivery_id,
3335: last_update_date = SYSDATE,
3336: last_updated_by = FND_GLOBAL.USER_ID,
3337: last_update_login = FND_GLOBAL.LOGIN_ID
3338: WHERE delivery_detail_id = l_sync_tmp_recTbl.delivery_detail_id_tbl(i);
3339:
3340: -- OTM R12 : assign delivery detail
3341: -- executed only once since it's for the same delivery

Line 3729: last_updated_by = FND_GLOBAL.USER_ID,

3725: --
3726: UPDATE wsh_delivery_assignments_v
3727: SET parent_delivery_detail_id = NULL,
3728: last_update_date = SYSDATE,
3729: last_updated_by = FND_GLOBAL.USER_ID,
3730: last_update_login = FND_GLOBAL.LOGIN_ID
3731: WHERE delivery_detail_id = p_detail_id;
3732: l_mdc_detail_tab(1) := p_detail_id;
3733: WSH_DELIVERY_DETAILS_ACTIONS.Create_Consol_Record(

Line 3730: last_update_login = FND_GLOBAL.LOGIN_ID

3726: UPDATE wsh_delivery_assignments_v
3727: SET parent_delivery_detail_id = NULL,
3728: last_update_date = SYSDATE,
3729: last_updated_by = FND_GLOBAL.USER_ID,
3730: last_update_login = FND_GLOBAL.LOGIN_ID
3731: WHERE delivery_detail_id = p_detail_id;
3732: l_mdc_detail_tab(1) := p_detail_id;
3733: WSH_DELIVERY_DETAILS_ACTIONS.Create_Consol_Record(
3734: p_detail_id_tab => l_mdc_detail_tab,

Line 4724: last_updated_by = FND_GLOBAL.USER_ID,

4720:
4721: UPDATE wsh_delivery_assignments_v
4722: SET delivery_id = p_delivery_id,
4723: last_update_date = SYSDATE,
4724: last_updated_by = FND_GLOBAL.USER_ID,
4725: last_update_login = FND_GLOBAL.LOGIN_ID
4726: WHERE delivery_detail_id = l_detail.delivery_detail_id;
4727: IF (SQL%NOTFOUND) THEN
4728: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 4725: last_update_login = FND_GLOBAL.LOGIN_ID

4721: UPDATE wsh_delivery_assignments_v
4722: SET delivery_id = p_delivery_id,
4723: last_update_date = SYSDATE,
4724: last_updated_by = FND_GLOBAL.USER_ID,
4725: last_update_login = FND_GLOBAL.LOGIN_ID
4726: WHERE delivery_detail_id = l_detail.delivery_detail_id;
4727: IF (SQL%NOTFOUND) THEN
4728: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4729: RAISE NO_DATA_FOUND;

Line 4793: last_updated_by = FND_GLOBAL.USER_ID,

4789:
4790: UPDATE wsh_new_deliveries
4791: SET freight_terms_code = x_dlvy_freight_terms_code,
4792: last_update_date = SYSDATE,
4793: last_updated_by = FND_GLOBAL.USER_ID,
4794: last_update_login = FND_GLOBAL.LOGIN_ID
4795: WHERE delivery_id = p_delivery_id;
4796: --
4797: IF (SQL%NOTFOUND)

Line 4794: last_update_login = FND_GLOBAL.LOGIN_ID

4790: UPDATE wsh_new_deliveries
4791: SET freight_terms_code = x_dlvy_freight_terms_code,
4792: last_update_date = SYSDATE,
4793: last_updated_by = FND_GLOBAL.USER_ID,
4794: last_update_login = FND_GLOBAL.LOGIN_ID
4795: WHERE delivery_id = p_delivery_id;
4796: --
4797: IF (SQL%NOTFOUND)
4798: THEN

Line 6051: last_updated_by = FND_GLOBAL.USER_ID,

6047: FORALL i in l_sync_tmp_recTbl.delivery_detail_id_tbl.first..l_sync_tmp_recTbl.delivery_detail_id_tbl.last
6048: UPDATE wsh_delivery_assignments_v
6049: SET delivery_id = l_del_id_for_container1.delivery_id,
6050: last_update_date = SYSDATE,
6051: last_updated_by = FND_GLOBAL.USER_ID,
6052: last_update_login = FND_GLOBAL.LOGIN_ID
6053: WHERE delivery_detail_id = l_sync_tmp_recTbl.delivery_detail_id_tbl(i);
6054:
6055: -- OTM R12 : assign delivery detail

Line 6052: last_update_login = FND_GLOBAL.LOGIN_ID

6048: UPDATE wsh_delivery_assignments_v
6049: SET delivery_id = l_del_id_for_container1.delivery_id,
6050: last_update_date = SYSDATE,
6051: last_updated_by = FND_GLOBAL.USER_ID,
6052: last_update_login = FND_GLOBAL.LOGIN_ID
6053: WHERE delivery_detail_id = l_sync_tmp_recTbl.delivery_detail_id_tbl(i);
6054:
6055: -- OTM R12 : assign delivery detail
6056: IF (l_assign_update AND

Line 6215: last_updated_by = FND_GLOBAL.USER_ID,

6211: FORALL i in l_sync_tmp_recTbl.delivery_detail_id_tbl.first..l_sync_tmp_recTbl.delivery_detail_id_tbl.last
6212: UPDATE wsh_delivery_assignments_v
6213: SET delivery_id = l_del_id_for_container2.delivery_id,
6214: last_update_date = SYSDATE,
6215: last_updated_by = FND_GLOBAL.USER_ID,
6216: last_update_login = FND_GLOBAL.LOGIN_ID
6217: WHERE delivery_detail_id = l_sync_tmp_recTbl.delivery_detail_id_tbl(i);
6218:
6219: -- OTM R12 : assign delivery detail

Line 6216: last_update_login = FND_GLOBAL.LOGIN_ID

6212: UPDATE wsh_delivery_assignments_v
6213: SET delivery_id = l_del_id_for_container2.delivery_id,
6214: last_update_date = SYSDATE,
6215: last_updated_by = FND_GLOBAL.USER_ID,
6216: last_update_login = FND_GLOBAL.LOGIN_ID
6217: WHERE delivery_detail_id = l_sync_tmp_recTbl.delivery_detail_id_tbl(i);
6218:
6219: -- OTM R12 : assign delivery detail
6220: IF (l_assign_update AND

Line 6325: last_updated_by = FND_GLOBAL.USER_ID,

6321: --
6322: UPDATE wsh_delivery_assignments_v
6323: SET parent_delivery_detail_id = p_detail_id2,
6324: last_update_date = SYSDATE,
6325: last_updated_by = FND_GLOBAL.USER_ID,
6326: last_update_login = FND_GLOBAL.LOGIN_ID
6327: WHERE delivery_detail_id = p_detail_id1;
6328: l_mdc_detail_tab(1) := p_detail_id1;
6329: WSH_DELIVERY_DETAILS_ACTIONS.Delete_Consol_Record(

Line 6326: last_update_login = FND_GLOBAL.LOGIN_ID

6322: UPDATE wsh_delivery_assignments_v
6323: SET parent_delivery_detail_id = p_detail_id2,
6324: last_update_date = SYSDATE,
6325: last_updated_by = FND_GLOBAL.USER_ID,
6326: last_update_login = FND_GLOBAL.LOGIN_ID
6327: WHERE delivery_detail_id = p_detail_id1;
6328: l_mdc_detail_tab(1) := p_detail_id1;
6329: WSH_DELIVERY_DETAILS_ACTIONS.Delete_Consol_Record(
6330: p_detail_id_tab => l_mdc_detail_tab,

Line 6988: last_updated_by = FND_GLOBAL.USER_ID,

6984: --
6985: UPDATE wsh_delivery_assignments_v
6986: SET delivery_id = l_null_delivery_id, --bugfix 3768823
6987: last_update_date = SYSDATE,
6988: last_updated_by = FND_GLOBAL.USER_ID,
6989: last_update_login = FND_GLOBAL.LOGIN_ID
6990: WHERE delivery_detail_id = l_dd_id(j);
6991:
6992: -- bug 6700792: OTM Dock Door Appt Sched Proj

Line 6989: last_update_login = FND_GLOBAL.LOGIN_ID

6985: UPDATE wsh_delivery_assignments_v
6986: SET delivery_id = l_null_delivery_id, --bugfix 3768823
6987: last_update_date = SYSDATE,
6988: last_updated_by = FND_GLOBAL.USER_ID,
6989: last_update_login = FND_GLOBAL.LOGIN_ID
6990: WHERE delivery_detail_id = l_dd_id(j);
6991:
6992: -- bug 6700792: OTM Dock Door Appt Sched Proj
6993: --Upadating the loading sequence of the delivery detail to NULL while unassigning from delivery

Line 6997: last_updated_by = FND_GLOBAL.USER_ID,

6993: --Upadating the loading sequence of the delivery detail to NULL while unassigning from delivery
6994: UPDATE wsh_delivery_details
6995: SET load_seq_number = NULL,
6996: last_update_date = SYSDATE,
6997: last_updated_by = FND_GLOBAL.USER_ID,
6998: last_update_login = FND_GLOBAL.LOGIN_ID
6999: WHERE delivery_detail_id = l_dd_id(j);
7000:
7001: IF (SQL%NOTFOUND) THEN

Line 6998: last_update_login = FND_GLOBAL.LOGIN_ID

6994: UPDATE wsh_delivery_details
6995: SET load_seq_number = NULL,
6996: last_update_date = SYSDATE,
6997: last_updated_by = FND_GLOBAL.USER_ID,
6998: last_update_login = FND_GLOBAL.LOGIN_ID
6999: WHERE delivery_detail_id = l_dd_id(j);
7000:
7001: IF (SQL%NOTFOUND) THEN
7002: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 7102: last_updated_by = FND_GLOBAL.USER_ID,

7098: deliver_to_location_id = NULL,
7099: -- tracking_number = NULL, Bug# 3632485
7100: line_direction = DECODE(line_direction,'IO','O',line_direction), -- J-IB-NPARIKH
7101: last_update_date = SYSDATE,
7102: last_updated_by = FND_GLOBAL.USER_ID,
7103: last_update_login = FND_GLOBAL.LOGIN_ID
7104: WHERE delivery_detail_id = l_dd_id(j);
7105: IF (SQL%NOTFOUND) THEN
7106: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 7103: last_update_login = FND_GLOBAL.LOGIN_ID

7099: -- tracking_number = NULL, Bug# 3632485
7100: line_direction = DECODE(line_direction,'IO','O',line_direction), -- J-IB-NPARIKH
7101: last_update_date = SYSDATE,
7102: last_updated_by = FND_GLOBAL.USER_ID,
7103: last_update_login = FND_GLOBAL.LOGIN_ID
7104: WHERE delivery_detail_id = l_dd_id(j);
7105: IF (SQL%NOTFOUND) THEN
7106: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
7107: RAISE NO_DATA_FOUND;

Line 7133: last_updated_by = FND_GLOBAL.USER_ID,

7129: 'X'), -- J-IB-NPARIKH
7130: ignore_for_planning = 'Y', -- J-IB-NPARIKH
7131: --wv_frozen_flag = DECODE(l_ib_upd_flag,'Y','N',wv_frozen_flag), -- J-IB-NPARIKH
7132: last_update_date = SYSDATE,
7133: last_updated_by = FND_GLOBAL.USER_ID,
7134: last_update_login = FND_GLOBAL.LOGIN_ID
7135: WHERE delivery_detail_id = l_dd_id(j)
7136: returning released_status into l_rel_status;
7137: --bugfix 4530813

Line 7134: last_update_login = FND_GLOBAL.LOGIN_ID

7130: ignore_for_planning = 'Y', -- J-IB-NPARIKH
7131: --wv_frozen_flag = DECODE(l_ib_upd_flag,'Y','N',wv_frozen_flag), -- J-IB-NPARIKH
7132: last_update_date = SYSDATE,
7133: last_updated_by = FND_GLOBAL.USER_ID,
7134: last_update_login = FND_GLOBAL.LOGIN_ID
7135: WHERE delivery_detail_id = l_dd_id(j)
7136: returning released_status into l_rel_status;
7137: --bugfix 4530813
7138: IF (SQL%NOTFOUND) THEN

Line 7349: last_updated_by = FND_GLOBAL.USER_ID,

7345: --Upadating the loading sequence of the delivery detail to NULL while unassigning from delivery
7346: UPDATE wsh_delivery_details
7347: SET load_seq_number = NULL,
7348: last_update_date = SYSDATE,
7349: last_updated_by = FND_GLOBAL.USER_ID,
7350: last_update_login = FND_GLOBAL.LOGIN_ID
7351: WHERE delivery_detail_id = p_detail_id;
7352:
7353: IF (SQL%NOTFOUND) THEN

Line 7350: last_update_login = FND_GLOBAL.LOGIN_ID

7346: UPDATE wsh_delivery_details
7347: SET load_seq_number = NULL,
7348: last_update_date = SYSDATE,
7349: last_updated_by = FND_GLOBAL.USER_ID,
7350: last_update_login = FND_GLOBAL.LOGIN_ID
7351: WHERE delivery_detail_id = p_detail_id;
7352:
7353: IF (SQL%NOTFOUND) THEN
7354: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

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

9405: l_delivery_details_info.serial_number := FND_API.G_MISS_CHAR;
9406: l_delivery_details_info.to_serial_number := FND_API.G_MISS_CHAR;
9407: l_delivery_details_info.transaction_temp_id := FND_API.G_MISS_NUM;
9408: l_delivery_details_info.last_update_date := SYSDATE;
9409: l_delivery_details_info.last_updated_by := FND_GLOBAL.USER_ID;
9410: l_delivery_details_info.last_update_login := FND_GLOBAL.LOGIN_ID;
9411: -- Bug 2419301
9412: l_delivery_details_info.oe_interfaced_flag := p_old_delivery_detail_rec.oe_interfaced_flag;
9413: --

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

9406: l_delivery_details_info.to_serial_number := FND_API.G_MISS_CHAR;
9407: l_delivery_details_info.transaction_temp_id := FND_API.G_MISS_NUM;
9408: l_delivery_details_info.last_update_date := SYSDATE;
9409: l_delivery_details_info.last_updated_by := FND_GLOBAL.USER_ID;
9410: l_delivery_details_info.last_update_login := FND_GLOBAL.LOGIN_ID;
9411: -- Bug 2419301
9412: l_delivery_details_info.oe_interfaced_flag := p_old_delivery_detail_rec.oe_interfaced_flag;
9413: --
9414: IF l_debug_on THEN

Line 9757: last_updated_by = FND_GLOBAL.USER_ID,

9753: net_weight = net_weight - l_total_net_wt,
9754: volume = volume - l_total_vol,
9755: -- End J: W/V Changes
9756: last_update_date = SYSDATE,
9757: last_updated_by = FND_GLOBAL.USER_ID,
9758: last_update_login = FND_GLOBAL.LOGIN_ID
9759: WHERE delivery_detail_id = p_old_delivery_detail_rec.delivery_detail_id;
9760:
9761: /* call the wv util to calculate the wv for the original detail too */

Line 9758: last_update_login = FND_GLOBAL.LOGIN_ID

9754: volume = volume - l_total_vol,
9755: -- End J: W/V Changes
9756: last_update_date = SYSDATE,
9757: last_updated_by = FND_GLOBAL.USER_ID,
9758: last_update_login = FND_GLOBAL.LOGIN_ID
9759: WHERE delivery_detail_id = p_old_delivery_detail_rec.delivery_detail_id;
9760:
9761: /* call the wv util to calculate the wv for the original detail too */
9762: --

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

10736: l_delivery_details_info.serial_number := FND_API.G_MISS_CHAR;
10737: l_delivery_details_info.to_serial_number := FND_API.G_MISS_CHAR;
10738: l_delivery_details_info.transaction_temp_id := FND_API.G_MISS_NUM;
10739: l_delivery_details_info.last_update_date := SYSDATE;
10740: l_delivery_details_info.last_updated_by := FND_GLOBAL.USER_ID;
10741: l_delivery_details_info.last_update_login := FND_GLOBAL.LOGIN_ID;
10742: -- Bug 2419301
10743: l_delivery_details_info.oe_interfaced_flag := p_old_delivery_detail_rec.oe_interfaced_flag;
10744:

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

10737: l_delivery_details_info.to_serial_number := FND_API.G_MISS_CHAR;
10738: l_delivery_details_info.transaction_temp_id := FND_API.G_MISS_NUM;
10739: l_delivery_details_info.last_update_date := SYSDATE;
10740: l_delivery_details_info.last_updated_by := FND_GLOBAL.USER_ID;
10741: l_delivery_details_info.last_update_login := FND_GLOBAL.LOGIN_ID;
10742: -- Bug 2419301
10743: l_delivery_details_info.oe_interfaced_flag := p_old_delivery_detail_rec.oe_interfaced_flag;
10744:
10745: l_new_delivery_detail_id := NULL;

Line 10941: last_updated_by = FND_GLOBAL.USER_ID,

10937: net_weight = net_weight - l_total_net_wt,
10938: volume = volume - l_total_vol,
10939: -- End J: W/V Changes
10940: last_update_date = SYSDATE,
10941: last_updated_by = FND_GLOBAL.USER_ID,
10942: last_update_login = FND_GLOBAL.LOGIN_ID
10943: WHERE delivery_detail_id = p_old_delivery_detail_rec.delivery_detail_id;
10944:
10945: -- DBI Project

Line 10942: last_update_login = FND_GLOBAL.LOGIN_ID

10938: volume = volume - l_total_vol,
10939: -- End J: W/V Changes
10940: last_update_date = SYSDATE,
10941: last_updated_by = FND_GLOBAL.USER_ID,
10942: last_update_login = FND_GLOBAL.LOGIN_ID
10943: WHERE delivery_detail_id = p_old_delivery_detail_rec.delivery_detail_id;
10944:
10945: -- DBI Project
10946: -- Update of wsh_delivery_details where requested_quantity/released_status

Line 11315: last_updated_by = FND_GLOBAL.USER_ID,

11311: UPDATE mtl_serial_numbers_temp
11312: SET to_serial_number = l_old_to_sn,
11313: serial_prefix = TO_CHAR(l_range_count - l_qty_to_split),
11314: last_update_date = SYSDATE,
11315: last_updated_by = FND_GLOBAL.USER_ID,
11316: last_update_login = FND_GLOBAL.LOGIN_ID
11317: WHERE rowid = c.rowid;
11318: END IF;
11319: IF l_debug_on THEN

Line 11316: last_update_login = FND_GLOBAL.LOGIN_ID

11312: SET to_serial_number = l_old_to_sn,
11313: serial_prefix = TO_CHAR(l_range_count - l_qty_to_split),
11314: last_update_date = SYSDATE,
11315: last_updated_by = FND_GLOBAL.USER_ID,
11316: last_update_login = FND_GLOBAL.LOGIN_ID
11317: WHERE rowid = c.rowid;
11318: END IF;
11319: IF l_debug_on THEN
11320: WSH_DEBUG_SV.log(l_module_name,

Line 11357: FND_GLOBAL.USER_ID,

11353: DFF_UPDATED_FLAG)
11354: VALUES
11355: (l_transaction_temp_id,
11356: SYSDATE,
11357: FND_GLOBAL.USER_ID,
11358: FND_GLOBAL.LOGIN_ID,
11359: SYSDATE,
11360: FND_GLOBAL.USER_ID,
11361: l_new_sn,

Line 11358: FND_GLOBAL.LOGIN_ID,

11354: VALUES
11355: (l_transaction_temp_id,
11356: SYSDATE,
11357: FND_GLOBAL.USER_ID,
11358: FND_GLOBAL.LOGIN_ID,
11359: SYSDATE,
11360: FND_GLOBAL.USER_ID,
11361: l_new_sn,
11362: l_new_to_sn,

Line 11360: FND_GLOBAL.USER_ID,

11356: SYSDATE,
11357: FND_GLOBAL.USER_ID,
11358: FND_GLOBAL.LOGIN_ID,
11359: SYSDATE,
11360: FND_GLOBAL.USER_ID,
11361: l_new_sn,
11362: l_new_to_sn,
11363: TO_CHAR(l_qty_to_split),
11364: c.attribute_category,

Line 11459: last_updated_by = FND_GLOBAL.USER_ID,

11455: -- we need to assign the full serial number range to the new line
11456: UPDATE mtl_serial_numbers_temp
11457: SET transaction_temp_id = l_transaction_temp_id,
11458: last_update_date = SYSDATE,
11459: last_updated_by = FND_GLOBAL.USER_ID,
11460: last_update_login = FND_GLOBAL.LOGIN_ID
11461: WHERE rowid = c.rowid;
11462:
11463: --Bug 2740681

Line 11460: last_update_login = FND_GLOBAL.LOGIN_ID

11456: UPDATE mtl_serial_numbers_temp
11457: SET transaction_temp_id = l_transaction_temp_id,
11458: last_update_date = SYSDATE,
11459: last_updated_by = FND_GLOBAL.USER_ID,
11460: last_update_login = FND_GLOBAL.LOGIN_ID
11461: WHERE rowid = c.rowid;
11462:
11463: --Bug 2740681
11464: IF l_debug_on THEN

Line 12255: l_user_id := FND_GLOBAL.user_id;

12251: --
12252:
12253: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
12254: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
12255: l_user_id := FND_GLOBAL.user_id;
12256: l_login_id := FND_GLOBAL.login_id;
12257:
12258: FOR i IN 1..p_Cons_Source_Line_Rec_Tab.count --{ Looping thru' the input params
12259: LOOP

Line 12256: l_login_id := FND_GLOBAL.login_id;

12252:
12253: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
12254: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
12255: l_user_id := FND_GLOBAL.user_id;
12256: l_login_id := FND_GLOBAL.login_id;
12257:
12258: FOR i IN 1..p_Cons_Source_Line_Rec_Tab.count --{ Looping thru' the input params
12259: LOOP
12260: --

Line 13369: FND_GLOBAL.USER_ID,

13365: l_consol_delivery_id_tab(i),
13366: l_detail_id_tab(i),
13367: NULL,
13368: SYSDATE,
13369: FND_GLOBAL.USER_ID,
13370: SYSDATE,
13371: FND_GLOBAL.USER_ID,
13372: FND_GLOBAL.USER_ID,
13373: NULL,

Line 13371: FND_GLOBAL.USER_ID,

13367: NULL,
13368: SYSDATE,
13369: FND_GLOBAL.USER_ID,
13370: SYSDATE,
13371: FND_GLOBAL.USER_ID,
13372: FND_GLOBAL.USER_ID,
13373: NULL,
13374: NULL,
13375: NULL,

Line 13372: FND_GLOBAL.USER_ID,

13368: SYSDATE,
13369: FND_GLOBAL.USER_ID,
13370: SYSDATE,
13371: FND_GLOBAL.USER_ID,
13372: FND_GLOBAL.USER_ID,
13373: NULL,
13374: NULL,
13375: NULL,
13376: NULL,