APPS.WSH_PR_PICKING_SESSION dependencies on SO_PICKING_BATCHES_ALL

Line 169: FROM SO_PICKING_BATCHES_ALL

165: NVL(ORG_ID, -3114),
166: NVL(AUTOCREATE_DELIVERY_FLAG,'N'),
167: NVL(ORDER_LINE_ID, 0),
168: TO_NUMBER(NVL(PRINT_FLAG, '-1'))
169: FROM SO_PICKING_BATCHES_ALL
170: WHERE BATCH_ID = x_batch_id
171: FOR UPDATE OF BATCH_ID NOWAIT;
172:
173: -- cursor to fetch release sequence rule info

Line 560: UPDATE SO_PICKING_BATCHES_ALL

556: -- Use the parameters passed to the Init Function, instead of using the
557: -- column names in the = conditions of the SQL. That is use
558: -- p_user_id , p_program_id , p_request_id , p_login_id and p_batch_id and p_application_id
559:
560: UPDATE SO_PICKING_BATCHES_ALL
561: SET REQUEST_ID = p_request_id,
562: PROGRAM_APPLICATION_ID = p_application_id,
563: PROGRAM_ID = p_program_id,
564: PROGRAM_UPDATE_DATE = SYSDATE,

Line 744: FROM SO_PICKING_BATCHES_ALL

740: -- Check if batch already exists with this name
741: WSH_UTIL.Write_Log('Checking batch name ' || x_batch_name);
742: SELECT COUNT(*)
743: INTO count_temp
744: FROM SO_PICKING_BATCHES_ALL
745: WHERE NAME = x_batch_name;
746:
747: IF count_temp = 0 THEN
748: EXIT;

Line 755: INSERT INTO SO_PICKING_BATCHES_ALL

751: END LOOP;
752:
753: -- Insert the new picking batch
754:
755: INSERT INTO SO_PICKING_BATCHES_ALL
756: (BATCH_ID,
757: CREATION_DATE,
758: CREATED_BY,
759: LAST_UPDATE_DATE,