10: p_operation_id in number,
11: p_department_id in number) is
12: x_prev_op_seq_num number := NULL;
13: x_next_op_seq_num number := NULL;
14: x_user_id number := FND_GLOBAL.USER_ID;
15: x_login_id number := FND_GLOBAL.LOGIN_ID;
16: x_request_id number := FND_GLOBAL.CONC_REQUEST_ID;
17: x_appl_id number := FND_GLOBAL.PROG_APPL_ID;
18: x_program_id number := FND_GLOBAL.CONC_PROGRAM_ID;
11: p_department_id in number) is
12: x_prev_op_seq_num number := NULL;
13: x_next_op_seq_num number := NULL;
14: x_user_id number := FND_GLOBAL.USER_ID;
15: x_login_id number := FND_GLOBAL.LOGIN_ID;
16: x_request_id number := FND_GLOBAL.CONC_REQUEST_ID;
17: x_appl_id number := FND_GLOBAL.PROG_APPL_ID;
18: x_program_id number := FND_GLOBAL.CONC_PROGRAM_ID;
19: adding_standard_op boolean := (p_operation_id is NOT NULL
12: x_prev_op_seq_num number := NULL;
13: x_next_op_seq_num number := NULL;
14: x_user_id number := FND_GLOBAL.USER_ID;
15: x_login_id number := FND_GLOBAL.LOGIN_ID;
16: x_request_id number := FND_GLOBAL.CONC_REQUEST_ID;
17: x_appl_id number := FND_GLOBAL.PROG_APPL_ID;
18: x_program_id number := FND_GLOBAL.CONC_PROGRAM_ID;
19: adding_standard_op boolean := (p_operation_id is NOT NULL
20: or
13: x_next_op_seq_num number := NULL;
14: x_user_id number := FND_GLOBAL.USER_ID;
15: x_login_id number := FND_GLOBAL.LOGIN_ID;
16: x_request_id number := FND_GLOBAL.CONC_REQUEST_ID;
17: x_appl_id number := FND_GLOBAL.PROG_APPL_ID;
18: x_program_id number := FND_GLOBAL.CONC_PROGRAM_ID;
19: adding_standard_op boolean := (p_operation_id is NOT NULL
20: or
21: p_operation_id = -1);
14: x_user_id number := FND_GLOBAL.USER_ID;
15: x_login_id number := FND_GLOBAL.LOGIN_ID;
16: x_request_id number := FND_GLOBAL.CONC_REQUEST_ID;
17: x_appl_id number := FND_GLOBAL.PROG_APPL_ID;
18: x_program_id number := FND_GLOBAL.CONC_PROGRAM_ID;
19: adding_standard_op boolean := (p_operation_id is NOT NULL
20: or
21: p_operation_id = -1);
22: l_scrap_qty number := 0;
522: AND organization_id = X_Organization_Id
523: AND (repetitive_Schedule_id = X_Repetitive_Schedule_Id
524: OR (repetitive_schedule_id IS NULL
525: AND X_Repetitive_Schedule_Id IS NULL));
526: x_user_id number := FND_GLOBAL.USER_ID;
527: x_login_id number := FND_GLOBAL.LOGIN_ID;
528: x_request_id number := FND_GLOBAL.CONC_REQUEST_ID;
529: x_appl_id number := FND_GLOBAL.PROG_APPL_ID;
530: x_program_id number := FND_GLOBAL.CONC_PROGRAM_ID;
523: AND (repetitive_Schedule_id = X_Repetitive_Schedule_Id
524: OR (repetitive_schedule_id IS NULL
525: AND X_Repetitive_Schedule_Id IS NULL));
526: x_user_id number := FND_GLOBAL.USER_ID;
527: x_login_id number := FND_GLOBAL.LOGIN_ID;
528: x_request_id number := FND_GLOBAL.CONC_REQUEST_ID;
529: x_appl_id number := FND_GLOBAL.PROG_APPL_ID;
530: x_program_id number := FND_GLOBAL.CONC_PROGRAM_ID;
531: x_standard_op boolean := (X_Standard_Operation_Id is NOT NULL);
524: OR (repetitive_schedule_id IS NULL
525: AND X_Repetitive_Schedule_Id IS NULL));
526: x_user_id number := FND_GLOBAL.USER_ID;
527: x_login_id number := FND_GLOBAL.LOGIN_ID;
528: x_request_id number := FND_GLOBAL.CONC_REQUEST_ID;
529: x_appl_id number := FND_GLOBAL.PROG_APPL_ID;
530: x_program_id number := FND_GLOBAL.CONC_PROGRAM_ID;
531: x_standard_op boolean := (X_Standard_Operation_Id is NOT NULL);
532: l_scrap_qty number :=0;
525: AND X_Repetitive_Schedule_Id IS NULL));
526: x_user_id number := FND_GLOBAL.USER_ID;
527: x_login_id number := FND_GLOBAL.LOGIN_ID;
528: x_request_id number := FND_GLOBAL.CONC_REQUEST_ID;
529: x_appl_id number := FND_GLOBAL.PROG_APPL_ID;
530: x_program_id number := FND_GLOBAL.CONC_PROGRAM_ID;
531: x_standard_op boolean := (X_Standard_Operation_Id is NOT NULL);
532: l_scrap_qty number :=0;
533:
526: x_user_id number := FND_GLOBAL.USER_ID;
527: x_login_id number := FND_GLOBAL.LOGIN_ID;
528: x_request_id number := FND_GLOBAL.CONC_REQUEST_ID;
529: x_appl_id number := FND_GLOBAL.PROG_APPL_ID;
530: x_program_id number := FND_GLOBAL.CONC_PROGRAM_ID;
531: x_standard_op boolean := (X_Standard_Operation_Id is NOT NULL);
532: l_scrap_qty number :=0;
533:
534: BEGIN