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