3:
4: procedure update_adjustments (
5: v_orgid mtl_parameters.organization_id%TYPE,
6: v_physinvid mtl_physical_inventories.physical_inventory_id%TYPE,
7: v_adjid mtl_physical_adjustments.adjustment_id%TYPE,
8: v_last_updated_by mtl_physical_adjustments.last_updated_by%TYPE,
9: v_adj_count_quantity mtl_physical_adjustments.count_quantity%TYPE)
10: is
11: begin
4: procedure update_adjustments (
5: v_orgid mtl_parameters.organization_id%TYPE,
6: v_physinvid mtl_physical_inventories.physical_inventory_id%TYPE,
7: v_adjid mtl_physical_adjustments.adjustment_id%TYPE,
8: v_last_updated_by mtl_physical_adjustments.last_updated_by%TYPE,
9: v_adj_count_quantity mtl_physical_adjustments.count_quantity%TYPE)
10: is
11: begin
12:
5: v_orgid mtl_parameters.organization_id%TYPE,
6: v_physinvid mtl_physical_inventories.physical_inventory_id%TYPE,
7: v_adjid mtl_physical_adjustments.adjustment_id%TYPE,
8: v_last_updated_by mtl_physical_adjustments.last_updated_by%TYPE,
9: v_adj_count_quantity mtl_physical_adjustments.count_quantity%TYPE)
10: is
11: begin
12:
13: update mtl_physical_adjustments
9: v_adj_count_quantity mtl_physical_adjustments.count_quantity%TYPE)
10: is
11: begin
12:
13: update mtl_physical_adjustments
14: set last_update_date = sysdate,
15: last_updated_by = nvl(last_updated_by, -1),
16: count_quantity = v_adj_count_quantity,
17: adjustment_quantity = nvl(v_adj_count_quantity,nvl(system_quantity,0))