APPS.WIP_WOL_PROCESSOR dependencies on WIP_LPN_COMPLETIONS

Line 7: UPDATE wip_lpn_completions wlc

3:
4: --copied from $INV_TOP/src/inltwv.ppc
5: PROCEDURE deriveItemRevision(p_header_id IN NUMBER) is
6: BEGIN
7: UPDATE wip_lpn_completions wlc
8: SET last_update_date = SYSDATE,
9: bom_revision =
10: (SELECT NVL(wlc.bom_revision, MAX(mir.revision))
11: FROM mtl_item_revisions mir

Line 35: UPDATE wip_lpn_completions wlc

31:
32: --copied from $INV_TOP/src/inltwv.ppc
33: FUNCTION validateItemRevision(p_source_id IN NUMBER) return NUMBER is
34: BEGIN
35: UPDATE wip_lpn_completions wlc
36: SET last_update_date = sysdate,
37: error_code = 'HOOWAA'
38: WHERE p_source_id = source_id
39: AND source_id <> header_id

Line 144: FROM wip_lpn_completions

140: p_task_id IN NUMBER) return boolean
141: IS
142: CURSOR c_items IS
143: SELECT inventory_item_id, subinventory_code, locator_id, rowid
144: FROM wip_lpn_completions
145: WHERE p_header_id = source_id
146: AND p_header_id <> header_id
147: AND locator_id is not null
148: ORDER BY operation_seq_num;

Line 187: UPDATE wip_lpn_completions

183: return false;
184: else
185: if (compRec.locator_id <> 0) then
186: BEGIN
187: UPDATE wip_lpn_completions
188: SET (locator_id, item_project_id, item_task_id) =
189: (select inventory_location_id, project_id, task_id
190: from mtl_item_locations
191: where inventory_location_id = compRec.locator_id

Line 210: l_wlcRec wip_lpn_completions%ROWTYPE;

206: PROCEDURE completeAssyItem(p_header_id IN NUMBER,
207: x_err_msg OUT NOCOPY VARCHAR2,
208: x_return_status OUT NOCOPY VARCHAR2)
209: IS
210: l_wlcRec wip_lpn_completions%ROWTYPE;
211: l_errNum NUMBER;
212: l_err_msg VARCHAR2(240);
213: l_wip_entity_id NUMBER;
214:

Line 221: FROM wip_lpn_completions

217: x_return_status := FND_API.G_RET_STS_ERROR;
218:
219: SELECT *
220: INTO l_wlcRec
221: FROM wip_lpn_completions
222: WHERE header_id = p_header_id;
223:
224: --default locator ids by the item's project
225: /* There is no place to enter the project in the mobile

Line 322: UPDATE WIP_LPN_COMPLETIONS

318: x_err_msg := x_err_msg || ' ' || fnd_message.get ;
319: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
320: END IF;
321:
322: UPDATE WIP_LPN_COMPLETIONS
323: SET wip_entity_id = l_wlcRec.wip_entity_id,
324: last_update_date = sysdate
325: WHERE l_wlcRec.header_id = header_id
326: AND l_wlcRec.header_id = source_id;