DBA Data[Home] [Help]

APPS.WIP_PICKING_PUB dependencies on FND_GLOBAL

Line 17: l_userId NUMBER := fnd_global.user_id;

13: x_msg_data OUT NOCOPY VARCHAR2) IS
14:
15: l_entityType NUMBER;
16: l_sysDate DATE := sysdate;
17: l_userId NUMBER := fnd_global.user_id;
18: l_loginId NUMBER := fnd_global.login_id;
19:
20: begin
21:

Line 18: l_loginId NUMBER := fnd_global.login_id;

14:
15: l_entityType NUMBER;
16: l_sysDate DATE := sysdate;
17: l_userId NUMBER := fnd_global.user_id;
18: l_loginId NUMBER := fnd_global.login_id;
19:
20: begin
21:
22: SAVEPOINT WIP_PRE_ALLOC_MATERIAL_START;

Line 187: fnd_global.user_id,

183: p_transaction_id,
184: l_rec.repetitive_schedule_id,
185: l_rec.organization_id,
186: sysdate,
187: fnd_global.user_id,
188: sysdate,
189: fnd_global.user_id,
190: -1 * round(l_updQty, 6),
191: -1 * round(l_updQty, 6),

Line 189: fnd_global.user_id,

185: l_rec.organization_id,
186: sysdate,
187: fnd_global.user_id,
188: sysdate,
189: fnd_global.user_id,
190: -1 * round(l_updQty, 6),
191: -1 * round(l_updQty, 6),
192: sysdate);
193:

Line 752: l_userId NUMBER := fnd_global.user_id;

748: x_return_status OUT NOCOPY VARCHAR2,
749: x_msg_data OUT NOCOPY VARCHAR2) IS
750: l_entityType NUMBER;
751: l_sysDate DATE := sysdate;
752: l_userId NUMBER := fnd_global.user_id;
753: l_loginId NUMBER := fnd_global.login_id;
754:
755: Begin
756: SAVEPOINT WIP_UPDATE_REQ_SUBINVLOC_START;

Line 753: l_loginId NUMBER := fnd_global.login_id;

749: x_msg_data OUT NOCOPY VARCHAR2) IS
750: l_entityType NUMBER;
751: l_sysDate DATE := sysdate;
752: l_userId NUMBER := fnd_global.user_id;
753: l_loginId NUMBER := fnd_global.login_id;
754:
755: Begin
756: SAVEPOINT WIP_UPDATE_REQ_SUBINVLOC_START;
757: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 805: l_userId NUMBER := fnd_global.user_id;

801: x_return_status OUT NOCOPY VARCHAR2,
802: x_msg_data OUT NOCOPY VARCHAR2) IS
803: l_entityType NUMBER;
804: l_sysDate DATE := sysdate;
805: l_userId NUMBER := fnd_global.user_id;
806: l_loginId NUMBER := fnd_global.login_id;
807: l_dummy VARCHAR2(1);
808: Begin
809: SAVEPOINT WIP_COMP_BACKORDQTY_START;

Line 806: l_loginId NUMBER := fnd_global.login_id;

802: x_msg_data OUT NOCOPY VARCHAR2) IS
803: l_entityType NUMBER;
804: l_sysDate DATE := sysdate;
805: l_userId NUMBER := fnd_global.user_id;
806: l_loginId NUMBER := fnd_global.login_id;
807: l_dummy VARCHAR2(1);
808: Begin
809: SAVEPOINT WIP_COMP_BACKORDQTY_START;
810: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 882: l_userId NUMBER := fnd_global.user_id;

878: x_return_status OUT NOCOPY VARCHAR2,
879: x_msg_data OUT NOCOPY VARCHAR2) IS
880: l_entityType NUMBER;
881: l_sysDate DATE := sysdate;
882: l_userId NUMBER := fnd_global.user_id;
883: l_loginId NUMBER := fnd_global.login_id;
884: Begin
885: SAVEPOINT WIP_JOB_BACKORDQTY_START;
886: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 883: l_loginId NUMBER := fnd_global.login_id;

879: x_msg_data OUT NOCOPY VARCHAR2) IS
880: l_entityType NUMBER;
881: l_sysDate DATE := sysdate;
882: l_userId NUMBER := fnd_global.user_id;
883: l_loginId NUMBER := fnd_global.login_id;
884: Begin
885: SAVEPOINT WIP_JOB_BACKORDQTY_START;
886: x_return_status := FND_API.G_RET_STS_SUCCESS;
887: