965: BEGIN
966:
967: update pon_bid_item_prices_interface p
968: set p.CLM_PROMISE_PERIOD_UOM_CODE = (SELECT lookup_code
969: FROM fnd_lookup_values_vl
970: WHERE lookup_type = 'CLM_PERIOD'
971: AND meaning = p.CLM_PROMISE_PERIOD_UOM);
972:
973: INSERT INTO pon_interface_errors
1010: and p.CLM_PROMISE_PERIOD_UOM IS NOT NULL;
1011:
1012: update pon_bid_item_prices_interface p
1013: set p.CLM_PROMISE_POP_DUR_UOM_CODE = (SELECT lookup_code
1014: FROM fnd_lookup_values_vl
1015: WHERE lookup_type = 'CLM_PERIOD'
1016: AND meaning = p.CLM_PROMISE_POP_DURATION_UOM);
1017:
1018: INSERT INTO pon_interface_errors