DBA Data[Home] [Help]

APPS.WIP_CHANGE_STATUS dependencies on FND_GLOBAL

Line 11: X_user_id NUMBER := FND_GLOBAL.USER_ID;

7: P_organization_id NUMBER,
8: P_repetitive_schedule_id NUMBER,
9: P_routing_exists OUT NOCOPY NUMBER) IS
10:
11: X_user_id NUMBER := FND_GLOBAL.USER_ID;
12: X_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
13:
14: BEGIN
15: IF (P_repetitive_schedule_id IS NULL) THEN

Line 12: X_login_id NUMBER := FND_GLOBAL.LOGIN_ID;

8: P_repetitive_schedule_id NUMBER,
9: P_routing_exists OUT NOCOPY NUMBER) IS
10:
11: X_user_id NUMBER := FND_GLOBAL.USER_ID;
12: X_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
13:
14: BEGIN
15: IF (P_repetitive_schedule_id IS NULL) THEN
16: UPDATE WIP_OPERATIONS

Line 56: X_user_id NUMBER := FND_GLOBAL.USER_ID;

52: P_line_id NUMBER,
53: P_class_code VARCHAR2,
54: P_release_date DATE DEFAULT SYSDATE) IS
55:
56: X_user_id NUMBER := FND_GLOBAL.USER_ID;
57: X_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
58:
59: BEGIN
60: IF P_repetitive_schedule_id IS NULL THEN

Line 57: X_login_id NUMBER := FND_GLOBAL.LOGIN_ID;

53: P_class_code VARCHAR2,
54: P_release_date DATE DEFAULT SYSDATE) IS
55:
56: X_user_id NUMBER := FND_GLOBAL.USER_ID;
57: X_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
58:
59: BEGIN
60: IF P_repetitive_schedule_id IS NULL THEN
61: INSERT INTO WIP_PERIOD_BALANCES

Line 352: X_user_id NUMBER := FND_GLOBAL.USER_ID;

348: X_status_type NUMBER;
349: X_class_code VARCHAR2(10) := '';
350: X_valid_job BOOLEAN;
351: X_routing_exists NUMBER;
352: X_user_id NUMBER := FND_GLOBAL.USER_ID;
353: X_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
354:
355: BEGIN
356: OPEN disc_info;

Line 353: X_login_id NUMBER := FND_GLOBAL.LOGIN_ID;

349: X_class_code VARCHAR2(10) := '';
350: X_valid_job BOOLEAN;
351: X_routing_exists NUMBER;
352: X_user_id NUMBER := FND_GLOBAL.USER_ID;
353: X_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
354:
355: BEGIN
356: OPEN disc_info;
357: FETCH disc_info INTO X_status_type, X_class_code;

Line 396: X_user_id NUMBER := FND_GLOBAL.USER_ID;

392: P_line_id NUMBER,
393: P_organization_id NUMBER) IS
394:
395: X_valid_schedule BOOLEAN := TRUE;
396: X_user_id NUMBER := FND_GLOBAL.USER_ID;
397: X_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
398:
399: BEGIN
400: UPDATE WIP_REPETITIVE_SCHEDULES

Line 397: X_login_id NUMBER := FND_GLOBAL.LOGIN_ID;

393: P_organization_id NUMBER) IS
394:
395: X_valid_schedule BOOLEAN := TRUE;
396: X_user_id NUMBER := FND_GLOBAL.USER_ID;
397: X_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
398:
399: BEGIN
400: UPDATE WIP_REPETITIVE_SCHEDULES
401: SET STATUS_TYPE = WIP_CONSTANTS.HOLD,

Line 428: X_user_id NUMBER := FND_GLOBAL.USER_ID;

424: X_status_type NUMBER;
425: X_class_code VARCHAR2(10) := '';
426: X_valid_job BOOLEAN;
427: X_routing_exists NUMBER;
428: X_user_id NUMBER := FND_GLOBAL.USER_ID;
429: X_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
430:
431: BEGIN
432: OPEN disc_info;

Line 429: X_login_id NUMBER := FND_GLOBAL.LOGIN_ID;

425: X_class_code VARCHAR2(10) := '';
426: X_valid_job BOOLEAN;
427: X_routing_exists NUMBER;
428: X_user_id NUMBER := FND_GLOBAL.USER_ID;
429: X_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
430:
431: BEGIN
432: OPEN disc_info;
433: FETCH disc_info INTO X_status_type, X_class_code;