APPS.INV_PICK_RELEASE_PUB dependencies on WSH_PICK_SLIP_NUMBERS_S

Line 388: SET pick_slip_number = wsh_pick_slip_numbers_s.nextval

384: 'Inv_Pick_Release_PVT.assign_pick_slip_number');
385: END IF;
386: For mmtt_line in l_mold_crs_con LOOP
387: UPDATE mtl_material_transactions_temp
388: SET pick_slip_number = wsh_pick_slip_numbers_s.nextval
389: WHERE transaction_temp_id = mmtt_line.transaction_temp_id;
390: END LOOP;
391: ELSE
392:

Line 442: SET pick_slip_number = wsh_pick_slip_numbers_s.nextval

438: IF mmtt_line.parent_line_id is not null THEN -- parent line
439: -- assign a seperate pick slip number for parent task and call WMS's pick slip
440: -- report to print out
441: UPDATE mtl_material_transactions_temp
442: SET pick_slip_number = wsh_pick_slip_numbers_s.nextval
443: WHERE transaction_temp_id = mmtt_line.parent_line_id;
444: IF ( p_ps_mode <> 'I' ) THEN
445: WSH_INV_INTEGRATION_GRP.FIND_PRINTER
446: ( p_subinventory => mmtt_line.subinventory_code