DBA Data[Home] [Help]

APPS.WIP_MATERIAL_PROCESSOR dependencies on WIP_REQUIREMENT_OPERATIONS

Line 13: UPDATE wip_requirement_operations

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),
15: quantity_allocated = greatest(0, quantity_allocated + ROUND(l_wlcRec.primary_quantity, 6)),
16: last_update_date = l_wlcRec.last_update_date,
17: last_updated_by = l_wlcRec.last_updated_by,

Line 50: INSERT INTO WIP_REQUIREMENT_OPERATIONS

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,
52: ORGANIZATION_ID,
53: WIP_ENTITY_ID,
54: OPERATION_SEQ_NUM,

Line 149: WHEN OTHERS then --invalid insertion into wip_requirement_operations or invalid header_id

145: RETURN TRUE;
146:
147:
148: EXCEPTION
149: WHEN OTHERS then --invalid insertion into wip_requirement_operations or invalid header_id
150: return FALSE;
151: END wroInsert;
152:
153: