APPS.WIP_PICKING_PVT dependencies on BOM_EXPLOSIONS

Line 25: from bom_explosions

21: order by component_code;
22:
23: CURSOR c_lock
24: IS select '1'
25: from bom_explosions
26: where top_bill_sequence_id = p_bill_sequence_id
27: and organization_id = p_organization_id
28: for update nowait;
29: BEGIN

Line 35: delete bom_explosions

31: --delete any previous explosions as effectivity/disable dates could be changed
32: --make sure the records are not locked.
33: open c_lock;
34:
35: delete bom_explosions
36: where top_bill_sequence_id = p_bill_sequence_id
37: and organization_id = p_organization_id;
38:
39:

Line 55: update bom_explosions

51: x_return_status := fnd_api.g_ret_sts_success;
52: end if;
53:
54: FOR l_compRec IN c_components LOOP
55: update bom_explosions
56: set component_quantity = component_quantity * l_compRec.component_quantity,
57: operation_seq_num = l_compRec.operation_seq_num
58: where component_code <> l_compRec.component_code
59: and component_code like l_compRec.component_code || '%'