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:
59: BEGIN
60: IF P_repetitive_schedule_id IS NULL THEN
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
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;
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;
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
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,
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;
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;