APPS.WIP_DISCRETE_JOB_PROCESSOR dependencies on WIP_LPN_COMPLETIONS

Line 15: l_wlcRec wip_lpn_completions%ROWTYPE;

11: l_ret_code NUMBER;
12: l_ret_msg VARCHAR2(240);--size???
13: l_retVal VARCHAR2(4);--retval for inventory update kanban proc, sales order completions
14: l_rowid ROWID;
15: l_wlcRec wip_lpn_completions%ROWTYPE;
16: l_msgCount NUMBER;
17: l_msgData VARCHAR2(240);
18:
19: BEGIN

Line 23: FROM wip_lpn_completions

19: BEGIN
20: SAVEPOINT preProcessing;
21: SELECT *
22: INTO l_wlcRec
23: FROM wip_lpn_completions
24: WHERE p_header_id = header_id;
25:
26: WIP_WEIGHTED_AVG.FINAL_COMPLETE(
27: p_org_id => l_wlcRec.organization_id,

Line 38: UPDATE wip_lpn_completions

34: x_err_msg := fnd_message.get_string('WIP', 'TRANSACTION_FAILED') || ' ' || l_ret_msg;
35: raise FND_API.G_EXC_UNEXPECTED_ERROR;
36: end if;
37:
38: UPDATE wip_lpn_completions
39: SET final_completion_flag = nvl(l_wlcRec.final_completion_flag, 'N')
40: WHERE header_id = p_header_id;--rowid = l_wlcRec.rowid;
41:
42: SELECT start_quantity - quantity_completed - quantity_scrapped, rowid

Line 130: 'WLC', --use wip_lpn_completions table

126: /* wip_so_reservations.allocate_completion_to_so(l_wlcRec.organization_id,
127: l_wlcRec.wip_entity_id,
128: l_wlcRec.inventory_item_id,
129: l_wlcRec.header_id,
130: 'WLC', --use wip_lpn_completions table
131: l_retVal,
132: l_msgCount,
133: l_msgData);
134: if(l_retVal <> FND_API.G_RET_STS_SUCCESS) then