APPS.INV_PICK_RELEASE_PUB dependencies on WSH_PICK_SLIP_NUMBERS_S

Line 389: SET pick_slip_number = wsh_pick_slip_numbers_s.nextval

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

Line 452: SET pick_slip_number = wsh_pick_slip_numbers_s.nextval

448: IF mmtt_line.parent_line_id is not null THEN -- parent line
449: -- assign a seperate pick slip number for parent task and call WMS's pick slip
450: -- report to print out
451: UPDATE mtl_material_transactions_temp
452: SET pick_slip_number = wsh_pick_slip_numbers_s.nextval
453: WHERE transaction_temp_id = mmtt_line.parent_line_id;
454: IF ( p_ps_mode <> 'I' ) THEN
455: WSH_INV_INTEGRATION_GRP.FIND_PRINTER
456: ( p_subinventory => mmtt_line.subinventory_code