[Home] [Help]
1223: oe_debug_pub.add('Updating Line_Ids for'||c.org_id);
1224: oe_debug_pub.add('Updating Line_Ids for'||c.orig_sys_document_ref);
1225: End If;
1226: UPDATE oe_headers_iface_all
1227: SET header_id = oe_order_headers_s.nextval
1228: WHERE order_source_id = c.order_source_id
1229: AND orig_sys_document_ref = c.orig_sys_document_ref
1230: AND nvl(org_id,-99) = nvl(c.org_id,-99)
1231: AND request_id = c.request_id; -- Changed for MOAC