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: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
59: x_returnStatus varchar2(1);
60: l_params wip_logger.param_tbl_t;

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: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
59: x_returnStatus varchar2(1);
60: l_params wip_logger.param_tbl_t;
61:

Line 487: X_user_id NUMBER := FND_GLOBAL.USER_ID;

483: X_status_type NUMBER;
484: X_class_code VARCHAR2(10) := '';
485: X_valid_job BOOLEAN;
486: X_routing_exists NUMBER;
487: X_user_id NUMBER := FND_GLOBAL.USER_ID;
488: X_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
489:
490: BEGIN
491: OPEN disc_info;

Line 488: X_login_id NUMBER := FND_GLOBAL.LOGIN_ID;

484: X_class_code VARCHAR2(10) := '';
485: X_valid_job BOOLEAN;
486: X_routing_exists NUMBER;
487: X_user_id NUMBER := FND_GLOBAL.USER_ID;
488: X_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
489:
490: BEGIN
491: OPEN disc_info;
492: FETCH disc_info INTO X_status_type, X_class_code;

Line 541: X_user_id NUMBER := FND_GLOBAL.USER_ID;

537: P_line_id NUMBER,
538: P_organization_id NUMBER) IS
539:
540: X_valid_schedule BOOLEAN := TRUE;
541: X_user_id NUMBER := FND_GLOBAL.USER_ID;
542: X_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
543:
544: BEGIN
545: UPDATE WIP_REPETITIVE_SCHEDULES

Line 542: X_login_id NUMBER := FND_GLOBAL.LOGIN_ID;

538: P_organization_id NUMBER) IS
539:
540: X_valid_schedule BOOLEAN := TRUE;
541: X_user_id NUMBER := FND_GLOBAL.USER_ID;
542: X_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
543:
544: BEGIN
545: UPDATE WIP_REPETITIVE_SCHEDULES
546: SET STATUS_TYPE = WIP_CONSTANTS.HOLD,

Line 573: X_user_id NUMBER := FND_GLOBAL.USER_ID;

569: X_status_type NUMBER;
570: X_class_code VARCHAR2(10) := '';
571: X_valid_job BOOLEAN;
572: X_routing_exists NUMBER;
573: X_user_id NUMBER := FND_GLOBAL.USER_ID;
574: X_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
575:
576: BEGIN
577: OPEN disc_info;

Line 574: X_login_id NUMBER := FND_GLOBAL.LOGIN_ID;

570: X_class_code VARCHAR2(10) := '';
571: X_valid_job BOOLEAN;
572: X_routing_exists NUMBER;
573: X_user_id NUMBER := FND_GLOBAL.USER_ID;
574: X_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
575:
576: BEGIN
577: OPEN disc_info;
578: FETCH disc_info INTO X_status_type, X_class_code;