APPS.WMA_INV_WRAPPERS dependencies on WIP_LPN_COMPLETIONS

Line 65: from wip_lpn_completions_lots

61: x_err_msg OUT NOCOPY VARCHAR2,
62: x_return_status OUT NOCOPY VARCHAR2) IS
63: cursor lots(v_header_id in NUMBER) IS
64: select lot_number
65: from wip_lpn_completions_lots
66: where header_id = v_header_id;
67:
68: l_msg_count NUMBER;
69:

Line 93: from wip_lpn_completions_serials

89: x_err_msg OUT NOCOPY VARCHAR2,
90: x_return_status OUT NOCOPY VARCHAR2) IS
91: cursor serials(v_header_id NUMBER) IS
92: select fm_serial_number
93: from wip_lpn_completions_serials
94: where header_id = v_header_id;
95:
96: l_msg_count NUMBER;
97:

Line 405: update wip_lpn_completions

401: wip_logger.entryPoint(p_procName => 'wma_inv_wrappers.transferReservation',
402: p_params => l_params,
403: x_returnStatus => l_dummy);
404: end if;
405: update wip_lpn_completions
406: set subinventory_code = p_subinventory_code,
407: locator_id = p_locator_id
408: where header_id = p_header_id
409: returning wip_entity_id, organization_id, inventory_item_id, wip_entity_type

Line 446: from wip_lpn_completions

442: if(l_ctoItemCount > 0) then
443: */
444: select count(*)
445: into l_soExistsFlag
446: from wip_lpn_completions
447: where header_id = p_header_id
448: and demand_source_header_id is not null
449: and demand_source_line is not null;
450: if(l_soExistsFlag > 0) then