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
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
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;
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:
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;
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;
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
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,
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;
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;