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 809: l_userId NUMBER := fnd_global.user_id;

805: x_return_status OUT NOCOPY VARCHAR2,
806: x_msg_data OUT NOCOPY VARCHAR2) IS
807: l_entityType NUMBER;
808: l_sysDate DATE := sysdate;
809: l_userId NUMBER := fnd_global.user_id;
810: l_loginId NUMBER := fnd_global.login_id;
811:
812: Begin
813: SAVEPOINT WIP_UPDATE_REQ_SUBINVLOC_START;

Line 810: l_loginId NUMBER := fnd_global.login_id;

806: x_msg_data OUT NOCOPY VARCHAR2) IS
807: l_entityType NUMBER;
808: l_sysDate DATE := sysdate;
809: l_userId NUMBER := fnd_global.user_id;
810: l_loginId NUMBER := fnd_global.login_id;
811:
812: Begin
813: SAVEPOINT WIP_UPDATE_REQ_SUBINVLOC_START;
814: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 862: l_userId NUMBER := fnd_global.user_id;

858: x_return_status OUT NOCOPY VARCHAR2,
859: x_msg_data OUT NOCOPY VARCHAR2) IS
860: l_entityType NUMBER;
861: l_sysDate DATE := sysdate;
862: l_userId NUMBER := fnd_global.user_id;
863: l_loginId NUMBER := fnd_global.login_id;
864: l_dummy VARCHAR2(1);
865: Begin
866: SAVEPOINT WIP_COMP_BACKORDQTY_START;

Line 863: l_loginId NUMBER := fnd_global.login_id;

859: x_msg_data OUT NOCOPY VARCHAR2) IS
860: l_entityType NUMBER;
861: l_sysDate DATE := sysdate;
862: l_userId NUMBER := fnd_global.user_id;
863: l_loginId NUMBER := fnd_global.login_id;
864: l_dummy VARCHAR2(1);
865: Begin
866: SAVEPOINT WIP_COMP_BACKORDQTY_START;
867: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 939: l_userId NUMBER := fnd_global.user_id;

935: x_return_status OUT NOCOPY VARCHAR2,
936: x_msg_data OUT NOCOPY VARCHAR2) IS
937: l_entityType NUMBER;
938: l_sysDate DATE := sysdate;
939: l_userId NUMBER := fnd_global.user_id;
940: l_loginId NUMBER := fnd_global.login_id;
941: Begin
942: SAVEPOINT WIP_JOB_BACKORDQTY_START;
943: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 940: l_loginId NUMBER := fnd_global.login_id;

936: x_msg_data OUT NOCOPY VARCHAR2) IS
937: l_entityType NUMBER;
938: l_sysDate DATE := sysdate;
939: l_userId NUMBER := fnd_global.user_id;
940: l_loginId NUMBER := fnd_global.login_id;
941: Begin
942: SAVEPOINT WIP_JOB_BACKORDQTY_START;
943: x_return_status := FND_API.G_RET_STS_SUCCESS;
944: