2135: into lv_ref_name,
2136: lv_ref_val,
2137: lv_sp_order
2138: --,lv_sp_uid
2139: from xdp_order_headers
2140: where order_id = p_order_id;
2141:
2142: update xdp_order_headers
2143: set
2138: --,lv_sp_uid
2139: from xdp_order_headers
2140: where order_id = p_order_id;
2141:
2142: update xdp_order_headers
2143: set
2144: order_ref_name = NVL(p_order_ref_name,lv_ref_name),
2145: order_ref_value = NVL(p_order_ref_value,lv_ref_val),
2146: sp_order_number = NVL(p_sp_order_number,lv_sp_order),