DBA Data[Home] [Help]

APPS.WIP_PICKING_PVT dependencies on FND_GLOBAL

Line 398: last_updated_by = fnd_global.user_id,

394: BEGIN
395: update wip_requirement_operations
396: set quantity_allocated = nvl(quantity_allocated,0) - p_openQty,
397: last_update_date = sysdate,
398: last_updated_by = fnd_global.user_id,
399: last_update_login = fnd_global.login_id
400: where rowid = p_rowId;
401:
402: INV_MO_Cancel_PVT.Cancel_Move_Order_Line(x_return_status => x_return_status,

Line 399: last_update_login = fnd_global.login_id

395: update wip_requirement_operations
396: set quantity_allocated = nvl(quantity_allocated,0) - p_openQty,
397: last_update_date = sysdate,
398: last_updated_by = fnd_global.user_id,
399: last_update_login = fnd_global.login_id
400: where rowid = p_rowId;
401:
402: INV_MO_Cancel_PVT.Cancel_Move_Order_Line(x_return_status => x_return_status,
403: x_msg_count => l_msgCount,

Line 1494: if (nvl(fnd_global.CONC_REQUEST_ID, -1) <> -1) then

1490: /* if thru srs, print the records that errored out and set the global variable so that we can
1491: set the request to warning. Decided to use global variable instead of a new parameter
1492: to avoid chain-dependencies. */
1493:
1494: if (nvl(fnd_global.CONC_REQUEST_ID, -1) <> -1) then
1495: if x_MOLineErrTbl.count > 0 then
1496:
1497: WIP_PICKING_PVT.g_PickRelease_Failed := TRUE;
1498: fnd_file.put_line(which => fnd_file.log, buff => 'The errored Records are as follows:');

Line 1655: l_userId NUMBER := fnd_global.user_id;

1651:
1652: IS
1653:
1654: l_sysDate DATE := sysdate;
1655: l_userId NUMBER := fnd_global.user_id;
1656: l_loginId NUMBER := fnd_global.login_id;
1657: l_lineStatus NUMBER := INV_Globals.G_TO_STATUS_PREAPPROVED;
1658: l_push NUMBER := wip_constants.push;
1659: l_pick_grouping_rule_id NUMBER;

Line 1656: l_loginId NUMBER := fnd_global.login_id;

1652: IS
1653:
1654: l_sysDate DATE := sysdate;
1655: l_userId NUMBER := fnd_global.user_id;
1656: l_loginId NUMBER := fnd_global.login_id;
1657: l_lineStatus NUMBER := INV_Globals.G_TO_STATUS_PREAPPROVED;
1658: l_push NUMBER := wip_constants.push;
1659: l_pick_grouping_rule_id NUMBER;
1660: