APPS.WIP_MATERIAL_PROCESSOR dependencies on WIP_LPN_COMPLETIONS

Line 6: l_wlcRec wip_lpn_completions%ROWTYPE;

2: /* $Header: wipmatpb.pls 115.8 2003/05/16 18:26:13 ccai ship $ */
3:
4: FUNCTION wroUpdate(p_header_id IN NUMBER)
5: return boolean IS
6: l_wlcRec wip_lpn_completions%ROWTYPE;
7: BEGIN
8: SELECT *
9: INTO l_wlcRec
10: FROM wip_lpn_completions

Line 10: FROM wip_lpn_completions

6: l_wlcRec wip_lpn_completions%ROWTYPE;
7: BEGIN
8: SELECT *
9: INTO l_wlcRec
10: FROM wip_lpn_completions
11: WHERE header_id = p_header_id;
12:
13: UPDATE wip_requirement_operations
14: SET quantity_issued = quantity_issued - ROUND(l_wlcRec.primary_quantity, 6),

Line 34: --header_id is PK of wip_lpn_completions, so TOO_MANY_ROWS will never occur

30: return FALSE;
31: else
32: return TRUE;
33: end if;
34: --header_id is PK of wip_lpn_completions, so TOO_MANY_ROWS will never occur
35:
36: EXCEPTION
37: WHEN NO_DATA_FOUND then
38: return FALSE;

Line 43: l_wlcRec wip_lpn_completions%ROWTYPE;

39: END wroUpdate;
40:
41: FUNCTION wroInsert(p_header_id IN NUMBER)
42: return boolean IS
43: l_wlcRec wip_lpn_completions%ROWTYPE;
44: BEGIN
45: SELECT *
46: INTO l_wlcRec
47: FROM wip_lpn_completions

Line 47: FROM wip_lpn_completions

43: l_wlcRec wip_lpn_completions%ROWTYPE;
44: BEGIN
45: SELECT *
46: INTO l_wlcRec
47: FROM wip_lpn_completions
48: WHERE header_id = p_header_id;
49:
50: INSERT INTO WIP_REQUIREMENT_OPERATIONS
51: (INVENTORY_ITEM_ID,