[Home] [Help]
5: -- insert into mtl_pending_item_status
6: -- insert into mtl_item_revisions
7: -- insert into mtl_item_categories
8: -- call CSTPIICI to insert into cst_item_costs
9: -- insert into mtl_uom_conversions
10: -- Call other procedures passing event='INSERT'
11:
12: -- After updating an item:
13: -- insert into mtl_pending_item_status
11:
12: -- After updating an item:
13: -- insert into mtl_pending_item_status
14: -- insert into mtl_item_categories
15: -- insert into mtl_uom_conversions
16: -- Call other procedures passing event = 'UPDATE'
17:
18: -- After assigning the item to a child org:
19: -- delete from mtl_item_categories
25:
26: -- After updating item/org attributes:
27: -- insert into mtl_pending_item_status
28: -- insert into mtl_item_categories
29: -- insert into mtl_uom_conversions
30: -- Call other procedures passing event = 'ITEM_ORG'
31:
32: l_cat_ins_upd BOOLEAN := FALSE; --* Added for Bug 4491340
33:
1680:
1681: begin
1682: select conversion_rate
1683: into v_rate
1684: from mtl_uom_conversions
1685: where inventory_item_id = 0
1686: and uom_code = X_primary_uom_code;
1687:
1688: --and unit_of_measure = X_primary_uom;
1691: when NO_DATA_FOUND then
1692: v_rate := null;
1693: end;
1694:
1695: insert into mtl_uom_conversions
1696: ( unit_of_measure,
1697: uom_code,
1698: uom_class,
1699: inventory_item_id,
1717: from mtl_units_of_measure_vl
1718: where uom_code = X_primary_uom_code
1719: and not exists
1720: ( select 'x'
1721: from mtl_uom_conversions
1722: where inventory_item_id = X_item_id
1723: and uom_code = X_primary_uom_code
1724: );
1725: