DBA Data[Home] [Help]

APPS.WIP_PICKING_PVT dependencies on FND_GLOBAL

Line 412: last_updated_by = fnd_global.user_id,

408: BEGIN
409: update wip_requirement_operations
410: set quantity_allocated = nvl(quantity_allocated,0) - p_openQty,
411: last_update_date = sysdate,
412: last_updated_by = fnd_global.user_id,
413: last_update_login = fnd_global.login_id
414: where rowid = p_rowId;
415:
416: INV_MO_Cancel_PVT.Cancel_Move_Order_Line(x_return_status => x_return_status,

Line 413: last_update_login = fnd_global.login_id

409: update wip_requirement_operations
410: set quantity_allocated = nvl(quantity_allocated,0) - p_openQty,
411: last_update_date = sysdate,
412: last_updated_by = fnd_global.user_id,
413: last_update_login = fnd_global.login_id
414: where rowid = p_rowId;
415:
416: INV_MO_Cancel_PVT.Cancel_Move_Order_Line(x_return_status => x_return_status,
417: x_msg_count => l_msgCount,

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

1510: /* if thru srs, print the records that errored out and set the global variable so that we can
1511: set the request to warning. Decided to use global variable instead of a new parameter
1512: to avoid chain-dependencies. */
1513:
1514: if (nvl(fnd_global.CONC_REQUEST_ID, -1) <> -1) then
1515: if x_MOLineErrTbl.count > 0 then
1516:
1517: WIP_PICKING_PVT.g_PickRelease_Failed := TRUE;
1518: fnd_file.put_line(which => fnd_file.log, buff => 'The errored Records are as follows:');

Line 1680: l_userId NUMBER := fnd_global.user_id;

1676:
1677: IS
1678:
1679: l_sysDate DATE := sysdate;
1680: l_userId NUMBER := fnd_global.user_id;
1681: l_loginId NUMBER := fnd_global.login_id;
1682: l_lineStatus NUMBER := INV_Globals.G_TO_STATUS_PREAPPROVED;
1683: l_push NUMBER := wip_constants.push;
1684: l_pick_grouping_rule_id NUMBER;

Line 1681: l_loginId NUMBER := fnd_global.login_id;

1677: IS
1678:
1679: l_sysDate DATE := sysdate;
1680: l_userId NUMBER := fnd_global.user_id;
1681: l_loginId NUMBER := fnd_global.login_id;
1682: l_lineStatus NUMBER := INV_Globals.G_TO_STATUS_PREAPPROVED;
1683: l_push NUMBER := wip_constants.push;
1684: l_pick_grouping_rule_id NUMBER;
1685: l_unit_number VARCHAR2(30);